| 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 |