| 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 | |
| PATU | PA Transaction Usage 1 = Timesheet |
Integer | 2 | 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 | |
| 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 | |
| PACostPcntCompleted | PA Cost Percent Completed |
Currency | 10 | View | |
| PAQuantityPcntCompleted | PA Quantity Percent Completed |
Currency | 10 | View | |
| PAObservedPcntCompleted | PA Observed Percent Completed |
Currency | 10 | View | |
| PAPreviously_Billed | PA Previously Billed |
Currency | 10 | View | |
| PAAmount_Earned | PA Amount Earned |
Currency | 10 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
| PAAR_IDX | PA AR IDX |
Long Integer | 4 | View | |
| PABillRevAcctIdx | PA Billing/Rev Acct Index |
Long Integer | 4 | View | |
| PABPSE | PA Bill Progress Subline Errors |
Long Integer | 4 | View | |
| PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | 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 | |
| PAOrigTaxAmtFF | PA Originating Tax Amt - FF |
Currency | 10 | View | |
| PAOrigPrevBill | PA Originating Prev Billed |
Currency | 10 | View | |
| PAOrigAmtEarned | PA Originating Amt Earned |
Currency | 10 | View | |
| PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
| PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
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 |