PA11901 - PA Project Closing WORK Detail
Dynamics GP table PA11901 (PA Project Closing WORK Detail) contains 20 columns including PAPROJNUMBER, PAACTUALBEGDATE, PACONTNUMBER....
SQL Query Builder
20 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAPROJNUMBER | PA Project Number | String | 16 | |
| PAACTUALBEGDATE | PA Actual Begin Date | Date | 4 | |
| PACONTNUMBER | PA Contract Number | String | 12 | |
| PASegmentCB | PA Segment CB | Boolean | 2 | |
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | |
| PA_Proj_Closing_Sequence | PA Proj Closing Sequence No. | Long Integer | 4 | |
| PAProjectType | PA Project Type | Integer | 2 | |
| PAAcctgMethod | PA Accounting Method | Integer | 2 | |
| PASTAT | PA Status1 = Open2 = On Hold3 = Closed4 = Estimate5 = Completed | Integer | 2 | |
| PAFBeginDate | PA Forecast Begin Date | Date | 4 | |
| PAFEndDate | PA Forecast End Date | Date | 4 | |
| PAProject_Amount | PA Project Amount | Currency | 10 | |
| ACCTAMNT | Account Amount | Currency | 10 | |
| PAPostedBillingsN | PA Actual Billings | Currency | 10 | |
| PA_Receipts_Amount | PA Receipts Amount | Currency | 10 | |
| PAPostedTotalCostN | PA Actual Total Cost | Currency | 10 | |
| DISTKNAM | Discount Taken Amount | Currency | 10 | |
| WROFAMNT | Write Off Amount | Currency | 10 | |
| PAChecklist_Complete | PA Checklist Complete | Boolean | 2 | |
| PAClose_CB | PA Close CB | Boolean | 2 |
Related Tables
Tables that share columns with PA11901. Click "Join" to add to your query.