CPO10110 - CPOP_Line_Ctrl
Dynamics GP table CPO10110 (CPOP_Line_Ctrl) contains 11 columns including PONUMBER, ORD, ACTINDX....
SQL Query Builder
11 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PONUMBER | PO Number | String | 18 | |
| ORD | Ord | Long Integer | 4 | |
| 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 | |
| REQDATE | Required Date | Date | 4 | |
| VENDORID | Vendor ID | String | 16 | |
| APPROVL | Approval | Boolean | 2 | |
| Committed_Amount | Committed Amount | Currency | 10 | |
| POLNESTA | PO Line Status1 – New2 – Released3 – Change Order4 – Received5 – Closed6 – Canceled | Integer | 2 | |
| QTYCANCE | QTY Canceled | Currency | 10 | |
| UNITCOST | Unit Cost | Currency | 10 | |
| PostedSubtotal | Posted Subtotal | Currency | 10 |
Related Tables
Tables that share columns with CPO10110. Click "Join" to add to your query.
POLNESTA
APPROVL
Committed_Amount