CAM30000 - CAM Transaction History
SQL Query Builder
9 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DATE1 | datetime '1/1/1900' | ||||
| TIME1 | datetime '1/1/1900' | ||||
| VCHRNMBR | char(21) '' | ||||
| DOCTYPE | smallint 0 | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| CNTRLTYP | smallint 0 | ||||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| VENDORID | char(15) '' | ||||
| CAM_Amount_Total | numeric(19,5) 0.00 | ||||
| CAM_Amount_Owing | numeric(19,5) 0.00 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with CAM30000. Click "Join" to add to your query.
CAM_Amount_Owing