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 | |
PAVARTOTFEEAMT | PA Variance Total Fee Amount |
Currency | 10 | View | |
PAsequencenumber | PA Sequence Number 1 |
Integer | 2 | View | |
PAbegindate | PA Begin Date |
Date | 4 | View | |
PAEnDate | PA End Date |
Date | 4 | View | |
PATOTPRJFEEAMT | PA Total Project Fee Amount |
Currency | 10 | View | |
PATOTRETNFEEAMT | PA Total Retainer Fee Amount |
Currency | 10 | View | |
PATOTRETNTNAMT | PA Total Retention Amount |
Currency | 10 | View | |
PATOTSRVCFEEAMT | PA Total Service Fee Amount |
Currency | 10 | View | |
PAClose_CB | PA Close CB |
Boolean | 2 | View | |
PAVARPRJFEEAMT | PA Variance Project Fee Amount |
Currency | 10 | View | |
PAVARRETFEEAMT | PA Variance Retainer Fee Amount |
Currency | 10 | View | |
PAVARETNFEEAMT | PA Variance Retention Amount |
Currency | 10 | View | |
PAVARSERVFEEAMT | PA Variance Service Fee Amount |
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 |