Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PACONTNUMBER | PA Contract Number |
String | 12 | View | |
PACHGORDNO | PA Change Order Number |
String | 18 | View | |
PAPROJNUMBER | PA Project Number |
String | 16 | View | |
PALineItemSeq | PA Line Item Sequence |
Long Integer | 4 | View | |
PAFeeID | PA Fee ID |
String | 16 | View | |
PAFeeType | PA Fee Type |
Integer | 2 | View | |
PAPREVFEEAMT | PA Prev Fee Amount |
Currency | 10 | View | |
PAVARFEESAMT | PA Variance Fee Amount |
Currency | 10 | View | |
PAFeeAmount | PA Fee Amount |
Currency | 10 | View | |
PA_Prev_Fee_Percent | PA Prev Fee Percent |
Currency | 10 | View | |
PAVARFEEPRCNT | PA Variance Fee Percent |
Currency | 10 | View | |
PAFeePercent | PA Fee Percent |
Currency | 10 | View | |
PAFeeToUse | PA Fee To Use |
Integer | 2 | View | |
PASales_Tax_Options | PA Sales Tax Options |
Integer | 2 | View | |
PAbilltaxscheduleid | PA Billing Tax Schedule ID |
String | 16 | View | |
PAPREVBILLTXSCHED | PA Prev Billing Tax Schedule ID |
String | 16 | View | |
PAbegindate | PA Begin Date |
Date | 4 | View | |
PAPREVBEGINDT | PA Prev Begin Date |
Date | 4 | View | |
PAEnDate | PA End Date |
Date | 4 | View | |
PAPREVENDDT | PA Prev End Date |
Date | 4 | View | |
PAFrequency | PA Frequency |
Integer | 2 | View | |
PAPREVFREQ | PA Prev Frequency |
Integer | 2 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
PARenew | PA Renew |
Boolean | 2 | View | |
PARenewal_Date | PA Renewal Date |
Date | 4 | View | |
PATotAmt | PA Total Amount |
Currency | 10 | View | |
PAPREVTOTAMT | PA Prev Total Amount |
Currency | 10 | View | |
PA_Renew_Day | PA Renew Day |
Integer | 2 | View | |
PA_Renew_Month | PA Renew Month |
Integer | 2 | View | |
PAsequencenumber | PA Sequence Number 1 |
Integer | 2 | View | |
TM_AR_Fee_SRC | TM AR Fee SRC |
Integer | 2 | View | |
TM_Prj_Deferred_Rev_Fee_ | TM Prj Deferred Rev Fee SRC |
Integer | 2 | View | |
TM_Prj_Rev_Fee_SRC | TM Prj Rev Fee SRC |
Integer | 2 | View | |
TM_BIEE_Fee_SRC | TM BIEE Fee SRC |
Integer | 2 | View | |
TM_EIEB_Fee_SRC | TM EIEB Fee SRC |
Integer | 2 | View | |
PAFF_AR_Fee_SRC | FF AR Fee SRC |
Integer | 2 | View | |
FF_Prj_Billings_Fee_SRC | FF Prj Billings Fee SRC |
Integer | 2 | View | |
FF_Prj_Rev_Fee_SRC | FF Prj Rev Fee SRC |
Integer | 2 | View | |
FF_Retention_Fee_SRC | FF Retention Fee SRC |
Integer | 2 | View | |
FF_WIP_Fee_SRC | FF WIP Fee SRC |
Integer | 2 | View | |
FF_Prj_Deferred_Rev_Fee_ | FF Prj Deferred Rev Fee SRC |
Integer | 2 | View | |
FF_BIEE_Fee_SRC | FF BIEE Fee SRC |
Integer | 2 | View | |
FF_EIEB_Fee_SRC | FF EIEB Fee SRC |
Integer | 2 | View | |
PAtotcbts | PA Label Checkbox - TS |
Boolean | 2 | View | |
PAtotcbEL | PA Label Checkbox - EL |
Boolean | 2 | View | |
PAtotcbML | PA Label Checkbox - ML |
Boolean | 2 | View | |
PAtotcbvi | PA Label Checkbox - VI |
Boolean | 2 | View | |
PAtotcber | PA Label Checkbox - EE |
Boolean | 2 | View | |
PAtotcbinv | PA Label Checkbox - INV |
Boolean | 2 | View | |
PAbillnoteidx | PA Billing Note Index |
Currency | 10 | View | |
PAPosted_Project_Fee | PA Actual Project Fee Amount |
Currency | 10 | View | |
PAPosted_Retainer_Fee | PA Actual Retainer Fee Amount |
Currency | 10 | View | |
PAPOSTRETAMT | PA Actual Retention Amount |
Currency | 10 | View | |
PAPosted_Service_Fee | PA Actual Service Fee Amount |
Currency | 10 | View |