Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM30100
Product: Control Account Management (2416)
Series:
Display Name: CAM Distribution History
Physical Name: CAM30100
Technical Name: CAM_Distribution_HIST
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | DATE1  | Date | Date | DT6 | 6 | |
| 2 | TIME1 | Time | Time | TM6 | 6 | |
| 3 | CAM_ControlAccountIndex | CAM_ControlAccountIndex | Long Integer | LI_14 | 14 | |
| 4 | CAM_Account_Num_String | CAM Account Number String | String | STR128_LBU | 128 | |
| 5 | CAM_ControlAcctDescr | CAM_ControlAcctDescription | String | STR32 | 32 | |
| 6 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hide | ||||||
| 7 | ACTINDX | Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hide | ||||||
| 8 | ACTNUMST | Account Number String | String | STR128_LBU | 128 | |
| 9 | ACTDESCR | Account Description | String | STR50 | 50 | |
| 10 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
| 11 | APTVCHNM | Apply To Voucher Number | String | STR20_LBAU | 20 | |
| 12 | DEBITAMT | Debit Amount | Currency | DLR19_$S2 | 19 | |
| 13 | CRDTAMNT | Credit Amount | Currency | DLR19_$S2 | 19 | |
| 14 | CAM_Amount_Total | CAM Amount Total | Currency | DLR19_$S2 | 19 | |
| 15 | DISTTYPE | Distribution Type | Integer | DDL | 0 | |
| 16 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |