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 | |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
CUTOFDAT | Cutoff Date |
Date | 4 | View | |
PAFeeID | PA Fee ID |
String | 16 | View | |
PAFeebillamount | PA Billing Amount - Fee |
Currency | 10 | View | |
PAFeeAmount | PA Fee Amount |
Currency | 10 | View | |
PAPreviously_Billed | PA Previously Billed |
Currency | 10 | View | |
PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
PAbilltaxscheduleid | PA Billing Tax Schedule ID |
String | 16 | View | |
PAFeetaxamount | PA Tax Amt - Fee |
Currency | 10 | View | |
PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
PAFeeType | PA Fee Type |
Integer | 2 | View | |
PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
ORTRXAMT | Original Trx Amount |
Currency | 10 | View | |
PA_Project_Sales_IDX | PA Project Sales IDX |
Long Integer | 4 | View | |
PAAR_IDX | PA AR IDX |
Long Integer | 4 | View | |
PA_Deferred_RevIDX | PA Deferred Rev IDX |
Long Integer | 4 | View | |
PACGBWIPIDX | PA WIP IDX |
Long Integer | 4 | View | |
PABProjectBlgsIDX | PA Project Blgs IDX |
Long Integer | 4 | View | |
PA_FF_AR_IDX | PA FF AR IDX |
Long Integer | 4 | View | |
PABProjectRevenueIDX | PA Project Revenue IDX |
Long Integer | 4 | View | |
PA_Retention_AR | PA Retention AR IDX |
Long Integer | 4 | View | |
PA_FF_Deferred_Rev_IDX | PA FF Deferred Rev IDX |
Long Integer | 4 | View | |
PA_Trade_Discount_Amount | PA Trade Discount Amount |
Currency | 10 | View | |
PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
PA_Retention_IDX | PA Retention IDX |
Long Integer | 4 | View | |
PAUD1 | PA User Defined 1 |
String | 22 | View | |
PAUD2 | PA User Defined 2 |
String | 22 | View | |
PAOrigBillingAmtFee | PA Originating Billing Amount - Fee |
Currency | 10 | View | |
PAOrigFeeAmount | PA Originating Fee Amount |
Currency | 10 | View | |
PAOrigPrevBill | PA Originating Prev Billed |
Currency | 10 | View | |
PAOrigTaxAmtFee | PA Originating Tax Amt - Fee |
Currency | 10 | View | |
PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
ORCTRXAM | Originating Current Trx Amount |
Currency | 10 | View | |
ORORGTRX | Originating Original Trx Amount |
Currency | 10 | View | |
PAOrigTradeDiscAmt | PA Originating Trade Discount Amt |
Currency | 10 | View | |
PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
Currency | 10 | View | |
PA_Previous_Retention | PA Previous Retention |
Currency | 10 | View | |
PAOPREVRETENTION | PA Originating Previous Retention |
Currency | 10 | View | |
PACHGORDNO | PA Change Order Number |
String | 18 | View | |
BackoutTradeDisc | Backout Trade Discount Amount |
Currency | 10 | View | |
OrigBackoutTradeDisc | Originating Backout Trade Discount Amount |
Currency | 10 | View | |
PA_Backout_Retention_Amt | PA Backout Retention Amount |
Currency | 10 | View | |
PA_OrigBackRetentionAmt | PA Originating Backout Retention Amount |
Currency | 10 | View |