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.
|CTRCODE||BIGINT||A unique number assigned by the system to identify the record.|
|INTTYPE||INT||The type of
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)|