Module List > Module ASI tables ASI25899
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25899 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char

The user t...(more) Join Now
join ... more text available
CMPANYID smallint

Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
PADocnumber20 char


PABILLTRXT smallint


PADOCDT datetime


PACOMM char


CUSTNMBR char

Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
CUSTNAME char


PRBTADCD char

Primary Bi...(more) Join Now PA01101.PRBTADCD
join ... more text available
CNTCPRSN char

Contact Pe...(more) Join Now PA01101.CNTCPRSN
ADDRESS1 char


ADDRESS2 char


ADDRESS3 char


CITY char


STATE char


ZIP char


COUNTRY char


ADRSCODE char

Address Co...(more) Join Now PA01101.ADRSCODE
PRSTADCD char


join ... more text available
STADDRCD char


CURNCYID char

Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
CURRNIDX smallint

Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
RTCLCMTD smallint

Rate calcu...(more) Join Now MC40300.RTCLCMTD
XCHGRATE numeric

Exchange R...(more) Join Now MC00100.XCHGRATE
DENXRATE numeric

Exchange R...(more) Join Now PTE30501.DENXRATE
PAInvFrmtTaxDetailID_1 char


PAInvFrmtTaxDetailID_2 char


PAInvFrmtTaxDetailID_3 char


PAInvFrmtTaxDetailID_4 char


PAInvFrmtTaxDetailID_5 char


PAInvFrmtTaxDetailID_6 char


PAInvFrmtTaxDetailID_7 char


PAInvFrmtTaxDetailID_8 char


PAInvFrmtTaxDetailID_9 char


PAInvFrmtTaxDetailID_10 char


PAIFTaxDetailName_1 char


PAIFTaxDetailName_2 char


PAIFTaxDetailName_3 char


PAIFTaxDetailName_4 char


PAIFTaxDetailName_5 char


PAIFTaxDetailName_6 char


PAIFTaxDetailName_7 char


PAIFTaxDetailName_8 char


PAIFTaxDetailName_9 char


PAIFTaxDetailName_10 char


PAIFTaxAmount_1 numeric


PAIFTaxAmount_2 numeric


PAIFTaxAmount_3 numeric


PAIFTaxAmount_4 numeric


PAIFTaxAmount_5 numeric


PAIFTaxAmount_6 numeric


PAIFTaxAmount_7 numeric


PAIFTaxAmount_8 numeric


PAIFTaxAmount_9 numeric


PAIFTaxAmount_10 numeric


PAIFTaxAmount1_1 numeric


PAIFTaxAmount1_2 numeric


PAIFTaxAmount1_3 numeric


PAIFTaxAmount1_4 numeric


PAIFTaxAmount1_5 numeric


PAIFTaxAmount1_6 numeric


PAIFTaxAmount1_7 numeric


PAIFTaxAmount1_8 numeric


PAIFTaxAmount1_9 numeric


PAIFTaxAmount1_10 numeric


Outstanding_Amount numeric


PAOOUTSTANDINGAMT numeric


PA_Inv_Frmt_TM tinyint


PA_Inv_Frmt_IV tinyint


PA_Inv_Frmt_CPFP tinyint


PA_Inv_Frmt_Fee tinyint


PAtotbillings numeric


PAOrigTotalBilings numeric


PARetentionFeeAmount numeric

PA Retenti...(more) Join Now PA01101.PARetentionFeeAmount
PAOrigRetentionFeeAmt numeric


TRDISAMT numeric

Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric


PA_Freight_Amount numeric


PAOrigFreightAmt numeric


PA_Misc_Amount numeric


PAOrigMiscAmt numeric


PATOTTAX numeric


PAOrigTotalTaxAmt numeric


PABillingAmount numeric


PAOrigBillAmount numeric


PARetainer_Fee_Amount numeric

PA Project...(more) Join Now PA01101.PARetainer_Fee_Amount
PAOrigRetainerFeeAmt numeric


DOCAMNT numeric

Source Doc...(more) Join Now RVLPD026.DOCAMNT
ORDOCAMT numeric

Orig Docum...(more) Join Now RVLPD026.ORDOCAMT
CASHAMNT numeric

Cash Amoun...(more) Join Now PTE30500.CASHAMNT
ORCASAMT numeric

Originatin...(more) Join Now PTE30500.ORCASAMT
CHEKAMNT numeric

Check Amou...(more) Join Now PTE30500.CHEKAMNT
ORCHKAMT numeric

Originatin...(more) Join Now PTE30500.ORCHKAMT
CRCRDAMT numeric

Credit Car...(more) Join Now PTE30500.CRCRDAMT
ORCCDAMT numeric

Originatin...(more) Join Now PTE30500.ORCCDAMT
DISTKNAM numeric

Discount T...(more) Join Now RM20102.DISTKNAM
PAOrigDiscTakenAmt numeric


DISCRTND numeric

Discount R...(more) Join Now ICJC9000.DISCRTND
PAOrigDiscRetAmt numeric


PADISCRETAMT numeric


PAODISCRETAMT numeric


PAProject_Amount numeric

PA Project...(more) Join Now PA01101.PAProject_Amount
PAProject_Amount1 numeric


PATOTCHGORDAMT numeric


PATOTCHGORDAMT2 numeric


PACOBASEPROJAMT numeric


PACOBASEPROJAMT2 numeric


PACOBSLNFEEPROJAMT numeric


PACOBSLNFEEPROJAMT2 numeric


PATOTCHGORDAMT1 numeric


PATOTCHGORDAMT11 numeric


PACOBASEPROJAMT1 numeric


PACOBASEPROJAMT11 numeric


PACOBSLNFEEPROJAMT1 numeric


PACOBSLNFEEPROJAMT11 numeric


PAPostedBillingsN numeric

PA Actual ...(more) Join Now PA01101.PAPostedBillingsN
PAPostedBillingsN1 numeric


PAPOSTRETAMT numeric

PA Actual ...(more) Join Now PA01101.PAPOSTRETAMT
PAPOSTRETAMT1 numeric


PABillingAmount1 numeric


PAOrigBillAmount1 numeric


PATMbillamount1 numeric


PAOrigBillingAmtTM1 numeric


PAFFbillamount1 numeric


PAOrigBillingAmtFF1 numeric


PAFeebillamount1 numeric


PAOrigBillingAmtFee1 numeric


PAFeebillamount2 numeric


PAFeebillamount21 numeric


PAFeebillamount211 numeric


PAFeebillamount2111 numeric


ACCTAMNT numeric

Account Am...(more) Join Now
ORACTAMT numeric


CSTPONBR char


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3