PA12101 - PA Change Order Fee Header WORK
Dynamics GP table PA12101 (PA Change Order Fee Header WORK) contains 21 columns including PACONTNUMBER, PACHGORDNO, PAPROJNUMBER....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PACONTNUMBER | PA Contract Number | String | 12 | |
| PACHGORDNO | PA Change Order Number | String | 18 | |
| PAPROJNUMBER | PA Project Number | String | 16 | |
| PALineItemSeq | PA Line Item Sequence | Long Integer | 4 | |
| PAVARTOTFEEAMT | PA Variance Total Fee Amount | Currency | 10 | |
| PAsequencenumber | PA Sequence Number 1 | Integer | 2 | |
| PAbegindate | PA Begin Date | Date | 4 | |
| PAEnDate | PA End Date | Date | 4 | |
| PATOTPRJFEEAMT | PA Total Project Fee Amount | Currency | 10 | |
| PATOTRETNFEEAMT | PA Total Retainer Fee Amount | Currency | 10 | |
| PATOTRETNTNAMT | PA Total Retention Amount | Currency | 10 | |
| PATOTSRVCFEEAMT | PA Total Service Fee Amount | Currency | 10 | |
| PAClose_CB | PA Close CB | Boolean | 2 | |
| PAVARPRJFEEAMT | PA Variance Project Fee Amount | Currency | 10 | |
| PAVARRETFEEAMT | PA Variance Retainer Fee Amount | Currency | 10 | |
| PAVARETNFEEAMT | PA Variance Retention Amount | Currency | 10 | |
| PAVARSERVFEEAMT | PA Variance Service Fee Amount | Currency | 10 | |
| PAPosted_Project_Fee | PA Actual Project Fee Amount | Currency | 10 | |
| PAPosted_Retainer_Fee | PA Actual Retainer Fee Amount | Currency | 10 | |
| PAPOSTRETAMT | PA Actual Retention Amount | Currency | 10 | |
| PAPosted_Service_Fee | PA Actual Service Fee Amount | Currency | 10 |
Related Tables
Tables that share columns with PA12101. Click "Join" to add to your query.