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 | |
CUTOFDAT | Cutoff Date |
Date | 4 | View | |
PACOSTCATID | PA Cost Category ID |
String | 16 | View | |
PAAcctgMethod | PA Accounting Method |
Integer | 2 | View | |
PATOTCST | PA Total Cost |
Currency | 10 | View | |
PATQTY | PA Total Quantity |
Currency | 10 | View | |
PAPercentCompleted | PA Percent Completed |
Currency | 10 | View | |
PAFFbillamount | PA Billing Amount - FF |
Currency | 10 | View | |
PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
PAbilltaxscheduleid | PA Billing Tax Schedule ID |
String | 16 | View | |
PAFFtaxamt | PA Tax Amt - FF |
Currency | 10 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
PATU | PA Transaction Usage 1 = Timesheet |
Integer | 2 | View | |
PACostPcntCompleted | PA Cost Percent Completed |
Currency | 10 | View | |
PAQuantityPcntCompleted | PA Quantity Percent Completed |
Currency | 10 | View | |
PAObservedPcntCompleted | PA Observed Percent Completed |
Currency | 10 | View | |
PAAmount_Earned | PA Amount Earned |
Currency | 10 | View | |
PAPreviously_Billed | PA Previously Billed |
Currency | 10 | View | |
PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
PAAR_IDX | PA AR IDX |
Long Integer | 4 | View | |
PABillRevAcctIdx | PA Billing/Rev Acct Index |
Long Integer | 4 | View | |
PA_Trade_Discount_Amount | PA Trade Discount Amount |
Currency | 10 | View | |
PA_Retention_IDX | PA Retention IDX |
Long Integer | 4 | View | |
PAORIGTOTCOST | PA Originating Total Cost |
Currency | 10 | View | |
PAOrigBillingAmtFF | PA Originating Billing Amount - FF |
Currency | 10 | View | |
PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
Currency | 10 | View | |
PAOrigTaxAmtFF | PA Originating Tax Amt - FF |
Currency | 10 | View | |
PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
PAOrigAmtEarned | PA Originating Amt Earned |
Currency | 10 | View | |
PAOrigPrevBill | PA Originating Prev Billed |
Currency | 10 | View | |
PAOrigTradeDiscAmt | PA Originating Trade Discount 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 | |
PA_Backout_Retention_Amt | PA Backout Retention Amount |
Currency | 10 | View | |
PA_OrigBackRetentionAmt | PA Originating Backout Retention Amount |
Currency | 10 | View |