CPO10113 - POE Unposted GL Transaction
Dynamics GP table CPO10113 (POE Unposted GL Transaction) contains 14 columns including JRNENTRY, SQNCLINE, DTAControlNum....
SQL Query Builder
14 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| SQNCLINE | Sequence Line | Currency | 10 | |
| DTAControlNum | DTA Control Number | String | 22 | |
| DTATRXType | DTA TRX Type | Integer | 2 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| DEBITAMT | Debit Amount | Currency | 10 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| TRXDATE | TRX Date | Date | 4 | |
| YEAR1 | Year | Integer | 2 | |
| PERIODID | Period ID | Integer | 2 | |
| BACHNUMB | Batch Number | String | 16 | |
| BCHSOURC | Batch Source | String | 16 | |
| SOURCDOC | Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo | String | 12 | |
| REFRENCE | Reference | String | 32 |
Related Tables
Tables that share columns with CPO10113. Click "Join" to add to your query.