CAM10100 - CAM Distribution Work
Dynamics GP table CAM10100 (CAM Distribution Work) contains 14 columns including DATE1, TIME1, CAM_ControlAccountIndex....
SQL Query Builder
14 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| DATE1 | Date | Date | 4 | |
| TIME1 | Time | Time | 4 | |
| CAM_ControlAccountIndex | CAM_ControlAccountIndex | Long Integer | 4 | |
| CAM_Account_Num_String | CAM Account Number String | String | 130 | |
| CAM_ControlAcctDescr | CAM_ControlAcctDescription | String | 34 | |
| VENDORID | Vendor ID | String | 16 | |
| 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 | |
| ACTNUMST | Account Number String | String | 130 | |
| ACTDESCR | Account Description | String | 52 | |
| VCHRNMBR | Voucher Number | String | 22 | |
| APTVCHNM | Apply To Voucher Number | String | 22 | |
| DEBITAMT | Debit Amount | Currency | 10 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| CAM_Amount_Total | CAM Amount Total | Currency | 10 |
Related Tables
Tables that share columns with CAM10100. Click "Join" to add to your query.
ACTNUMST