Home > Technical > Table Definitions > ACCTINTFADJ
The accounts interface usually pulls data directly from the relevant tables. However, sometime there is a need for special transactions to be tracked and sent to the general ledger via the interface. This table will record these special transactions.
Column | Type | Description | ||||
CTRCODE | BIGINT | A unique number assigned by the system to identify the record. | ||||
INTTYPE | INT | The type of
transaction.
|
||||
STRTRADECODE | VARCHAR(10) | The
location for which the transactions was made.![]() |
||||
DTMWHEN | DATETIME | The date when the transaction was written. | ||||
LINTITEMNUMBER | INT | The item number, if any, to which this transaction was related. | ||||
STRSOURCE | VARCHAR(5) | The source of the transaction, for example PO=Purchase Order, POS=Point Of Sale, and so on. | ||||
LINTREFERENCE | BIGINT | The primary key of the source record. If STRSOURCE=PO, this would be the purchase order number. | ||||
CURVALUE | DECIMAL(19,4) | The value of the transaction. |
Primary Key: CTRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |