Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
PAFeeID | PA Fee ID |
String | 16 | View | |
PAFeeType | PA Fee Type |
Integer | 2 | View | |
PAFeeAmount | PA Fee Amount |
Currency | 10 | View | |
PAUBeginDate | PA Unposted Begin Date |
Date | 4 | View | |
PAUEndDate | PA Unposted End Date |
Date | 4 | View | |
PAUnposted_Fee_Amount | PA Unposted Fee Amount |
Currency | 10 | View | |
PAUnposted_Tax_Amount | PA Unposted Tax Amount |
Currency | 10 | View | |
PAUNPOSTBIEEAMOUNT | PA Unposted BIEE Amount |
Currency | 10 | View | |
PAUNPEIEBAMOUNT | PA Unposted EIEB Amount |
Currency | 10 | View | |
PAUnpostedRecogRevN | PA Unposted Recognized Revenue |
Currency | 10 | View | |
PA_Unposted_Billed_Reten | PA Unposted Billed Retention |
Currency | 10 | View | |
PAUnpostDiscDolAmtN | PA Unposted Discount Dollar Amount |
Currency | 10 | View | |
PAUnpostBillN | PA Unposted Billings |
Currency | 10 | View | |
PAPosted_Fee_Amount | PA Actual Fee Amount |
Currency | 10 | View | |
PAPosted_Tax_Amount | PA Actual Tax Amount |
Currency | 10 | View | |
PAPOSBIEEAMOUNT | PA Actual BIEE Amount |
Currency | 10 | View | |
PAPOSEIEBAMOUNT | PA Actual EIEB Amount |
Currency | 10 | View | |
PAPostRecogRevN | PA Actual Recognized Revenue |
Currency | 10 | View | |
PA_Actual_Billed_Retenti | PA Actual Billed Retention |
Currency | 10 | View | |
PAPostedDiscDolAmtN | PA Actual Discount Dollar Amount |
Currency | 10 | View | |
PAPostedBillingsN | PA Actual Billings |
Currency | 10 | View | |
PAACTUALBEGDATE | PA Actual Begin Date |
Date | 4 | View | |
PA_Actual_End_Date | PA Actual End Date |
Date | 4 | View | |
PA_Receipts_Amount | PA Receipts Amount |
Currency | 10 | View | |
PA_Actual_Receipts_Amoun | PA Actual Receipts Amount |
Currency | 10 | View | |
PA_Earnings | PA Earnings |
Currency | 10 | View | |
PA_Cost_of_Earnings | PA Cost of Earnings |
Currency | 10 | View | |
WROFAMNT | Write Off Amount |
Currency | 10 | View | |
ActualWriteOffAmount | Actual Write Off Amount |
Currency | 10 | View | |
DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
ActualDiscTakenAmount | Actual Discount Taken Amount |
Currency | 10 | View | |
PAtaxpaidamt | PA Tax Paid Amount |
Currency | 10 | View | |
PAPostedTaxPaidN | PA Actual Tax Paid |
Currency | 10 | View | |
PAPOSTRETAMT | PA Actual Retention Amount |
Currency | 10 | View | |
PAUNPOSTRETAMT | PA Unposted Retention Amount |
Currency | 10 | View | |
PA_Write_Off_Tax_Amount | PA Write Off Tax Amount |
Currency | 10 | View | |
PAActualWOTaxAmt | PA Actual Write Off Tax Amount |
Currency | 10 | View | |
PA_Terms_Taken_Tax_Amt | PA Terms Taken Tax Amt |
Currency | 10 | View | |
PAActualTermsTakenTax | PA Actual Terms Taken Tax Amt |
Currency | 10 | View | |
PAPosted_Earnings | PA Actual Earnings |
Currency | 10 | View | |
PAActualCostofEarnings | PA Actual Cost of Earnings |
Currency | 10 | View | |
PA_MC_Fee_Amount | PA MC Fee Amount |
Currency | 10 | View | |
PA_MC_Unposted_Fee_Amt | PA MC Unposted Fee Amount |
Currency | 10 | View | |
PA_MC_Unposted_Tax_Amt | PA MC Unposted Tax Amount |
Currency | 10 | View | |
PA_MC_Unposted_Discount | PA MC Unposted Discount Dollar Amount |
Currency | 10 | View | |
PAMCUnpostBillN | PA MC Unposted Billings |
Currency | 10 | View | |
PA_MC_Actual_Fee_Amount | PA MC Actual Fee Amount |
Currency | 10 | View | |
PA_MC_Actual_Tax_Amount | PA MC Actual Tax Amount |
Currency | 10 | View | |
PA_MC_Actual_Discount | PA MC Actual Discount Dollar Amount |
Currency | 10 | View | |
PAMCActualBillings | PA MC Actual Billings |
Currency | 10 | View |