PA11904 - PA Project Closing Work Fee
Dynamics GP table PA11904 (PA Project Closing Work Fee) contains 23 columns including PA_Proj_Closing_Sequence, PALineItemSeq, JRNENTRY....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PA_Proj_Closing_Sequence | PA Proj Closing Sequence No. | Long Integer | 4 | |
| PALineItemSeq | PA Line Item Sequence | Long Integer | 4 | |
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| PACONTNUMBER | PA Contract Number | String | 12 | |
| PAPROJNUMBER | PA Project Number | String | 16 | |
| PAFeeID | PA Fee ID | String | 16 | |
| PAFeeType | PA Fee Type | Integer | 2 | |
| PAFeeAmount | PA Fee Amount | Currency | 10 | |
| PACGBWIPIDX | PA WIP IDX | Long Integer | 4 | |
| PABBillingsIDX | PA Billings IDX | Long Integer | 4 | |
| PARev_IDX | PA Revenue IDX | Long Integer | 4 | |
| PABBIEEIDX | PA BIEE IDX | Long Integer | 4 | |
| PABEIEBIDX | PA EIEB IDX | Long Integer | 4 | |
| PAPostedBillingsN | PA Actual Billings | Currency | 10 | |
| PAPostRecogRevN | PA Actual Recognized Revenue | Currency | 10 | |
| PAPOSBIEEAMOUNT | PA Actual BIEE Amount | Currency | 10 | |
| PAPOSEIEBAMOUNT | PA Actual EIEB Amount | Currency | 10 | |
| PAPrevBillings | PA Prev Billings | Currency | 10 | |
| PAPrevBIEEAmount | PA Prev BIEE Amount | Currency | 10 | |
| PAPrevEIEBAmount | PA Prev EIEB Amount | Currency | 10 | |
| PAPrevRecognizedRev | PA Prev Recognized Revenue | Currency | 10 | |
| PAPrevEarnings | PA Prev Earnings | Currency | 10 | |
| PAPosted_Earnings | PA Actual Earnings | Currency | 10 |
Related Tables
Tables that share columns with PA11904. Click "Join" to add to your query.