Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PABILLTRXT | PA Biller Trx Type |
Integer | 2 | View | |
PADocnumber20 | PA Document No. |
String | 18 | View | |
PADOCDT | PA Document Date |
Date | 4 | View | |
PAREFNO | PA Reference Document No. |
String | 18 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
CUSTNMBR | Customer Number |
String | 16 | View | |
PACONTNUMBER | PA Contract Number |
String | 12 | View | |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
PAProjectType | PA Project Type |
Integer | 2 | View | |
PApurordnum | PA Purchase Order No. |
String | 18 | View | |
PABillingAmount | PA Billing Amount |
Currency | 10 | View | |
PATMbillamount | PA Billing Amount - TM |
Currency | 10 | View | |
PAFFbillamount | PA Billing Amount - FF |
Currency | 10 | View | |
PAFeebillamount | PA Billing Amount - Fee |
Currency | 10 | View | |
PAtotbillings | PA Total Billings |
Currency | 10 | View | |
PA_Discount_Type | PA Discount Type |
Integer | 2 | View | |
TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
PA_Trade_Discount_Pcnt | PA Trade Discount Percent |
Integer | 2 | View | |
PATOTTAX | PA Total Tax |
Currency | 10 | View | |
PATMtaxamt | PA Tax Amt - TM |
Currency | 10 | View | |
PAFFtaxamt | PA Tax Amt - FF |
Currency | 10 | View | |
PAFeetaxamount | PA Tax Amt - Fee |
Currency | 10 | View | |
PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
PATMbckoutbillamt | PA Backout Bill Amt - TM |
Currency | 10 | View | |
PAPBbckoutbillamt | PA Backout Bill Amt - FF |
Currency | 10 | View | |
PAFeebckoutbillamt | PA Backout Bill Amt - Fee |
Currency | 10 | View | |
APPLDAMT | Applied Amount |
Currency | 10 | View | |
ACCTAMNT | Account Amount |
Currency | 10 | View | |
PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
PA_Applied_Retainer | PA Applied Document Amt |
Currency | 10 | View | |
PA_Applied_Freight_Misc | PA Applied Freight Misc |
Currency | 10 | View | |
AGNGBUKT | Aging Bucket |
Integer | 2 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
PA_Trade_IDX | PA Trade IDX |
Long Integer | 4 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
PAOrigBillAmount | PA Originating Billing Amount |
Currency | 10 | View | |
PAOrigBillingAmtTM | PA Originating Billing Amount - TM |
Currency | 10 | View | |
PAOrigBillingAmtFF | PA Originating Billing Amount - FF |
Currency | 10 | View | |
PAOrigBillingAmtFee | PA Originating Billing Amount - Fee |
Currency | 10 | View | |
PAOrigTotalBilings | PA Originating Total Billings |
Currency | 10 | View | |
PAOrigTotalTaxAmt | PA Originating Total Tax |
Currency | 10 | View | |
PAOrigTaxAmtTM_ | PA Originating Tax Amt - TM |
Currency | 10 | View | |
PAOrigTaxAmtFF | PA Originating Tax Amt - FF |
Currency | 10 | View | |
PAOrigTaxAmtFee | PA Originating Tax Amt - Fee |
Currency | 10 | View | |
PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
PAOrigBackoutBillTM | PA Originating Backout Bill Amt - TM |
Currency | 10 | View | |
PAOrigBackoutBillFF | PA Originating Backout Bill Amt - FF |
Currency | 10 | View | |
PAOrigBackoutBillFee | PA Originating Backout Bill Amt - Fee |
Currency | 10 | View | |
PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
Currency | 10 | View | |
PAOrigRetainerFeeAmt | PA Originating Retainer Fee Amt |
Currency | 10 | View | |
ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
ORAPPAMT | Originating Applied Amount |
Currency | 10 | View | |
ORACTAMT | Originating Account Amount |
Currency | 10 | View | |
ORCTRXAM | Originating Current Trx Amount |
Currency | 10 | View | |
PAOrigAppliedDocAmt | PA Originating Applied Document Amt |
Currency | 10 | View | |
PAOrigAppliedFreightMisc | PA Originating Applied Freight Misc |
Currency | 10 | View | |
BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
PA_Third_Party_CB | PA Third Party CB |
Boolean | 2 | View | |
BackoutTradeDiscTax | Backout Trade Discount Tax Amount |
Currency | 10 | View | |
OrigBackoutTradeDiscTax | Originating Backout Trade Discount Tax Amount |
Currency | 10 | View | |
PA_Backout_Retention_Tax | PA Backout Retention Tax Amount |
Currency | 10 | View | |
PA_OrigBackRetentionTax | PA Originating Backout Retention Tax Amount |
Currency | 10 | View |