| TRAN_NUMBER |
INTEGER |
4 |
10 |
Item number |
|
| ITEM_COUNT |
INTEGER |
4 |
10 |
No of items for this header |
|
| TYPE |
VARCHAR |
2 |
2 |
Transaction type |
|
| DATE |
DATE |
2 |
10 |
Transaction date |
|
| ACCOUNT_REF |
VARCHAR |
8 |
8 |
Sales/Purchase/Bank Account Reference |
|
| SALES_PURCHASE_REF |
VARCHAR |
8 |
8 |
Sales/Purchase Account Reference |
|
| BANK_CODE |
VARCHAR |
8 |
8 |
Bank Account Reference |
|
| INV_REF |
VARCHAR |
8 |
8 |
Invoice Reference Number |
|
| USER_NAME |
VARCHAR |
32 |
32 |
User name |
|
| DETAILS |
VARCHAR |
60 |
60 |
Details |
|
| DUE_DATE |
DATE |
2 |
10 |
Due date |
|
| LAST_CHARGE_DATE |
DATE |
2 |
10 |
Date Charges Last Applied |
|
| FINANCE_CHARGE |
TINYINT |
1 |
3 |
Finance Charge flag |
|
| INTEREST_RATE |
DOUBLE |
8 |
15 |
Interest Rate |
|
| ELECTRONIC_TRANS |
SMALLINT |
2 |
5 |
Electronic Transaction |
|
| DISPUTED |
SMALLINT |
2 |
5 |
Number of Disputed items |
|
| PAID_FLAG |
VARCHAR |
1 |
1 |
Transaction paid flag - y/n |
|
| PAID_STATUS |
VARCHAR |
2 |
2 |
Transaction disputed/paid status - /p/d/dp |
|
| DELETED_FLAG |
SMALLINT |
2 |
5 |
Transaction deleted flag |
|
| NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount (signed according to transaction type) |
|
| TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount (signed according to transaction type) |
|
| GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (signed according to transaction type) |
|
| BANK_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount (signed for use in bank statements) |
|
| AMOUNT_PAID |
DOUBLE |
8 |
15 |
Total amount paid (allocated against invoice/credit) |
|
| FOREIGN_NET_AMOUNT |
DOUBLE |
8 |
15 |
Net amount in foreign currency (signed according to transaction type) |
|
| FOREIGN_TAX_AMOUNT |
DOUBLE |
8 |
15 |
Tax amount in foreign currency (signed according to transaction type) |
|
| FOREIGN_GROSS_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount in foreign currency (signed according to transaction type) |
|
| FOREIGN_AMOUNT_PAID |
DOUBLE |
8 |
15 |
Total amount paid in foreign currency (allocated against invoice/credit) |
|
| FOREIGN_BANK_AMOUNT |
DOUBLE |
8 |
15 |
Gross amount in foreign currency (signed for use in bank statements) |
|
| CURRENCY |
TINYINT |
1 |
3 |
Which foreign currency |
|
| CURRENCY_TYPE |
TINYINT |
1 |
3 |
Foreign or Euro currency |
|
| EURO_GROSS |
DOUBLE |
8 |
15 |
Gross amount in Euros |
|
| EURO_RATE |
DOUBLE |
8 |
15 |
Euro exchange rate |
|
| FOREIGN_RATE |
DOUBLE |
8 |
15 |
Foreign currency exchange rate |
|
| BANK_FLAG |
VARCHAR |
1 |
1 |
Bank reconciled flag |
|
| HEADER_NUMBER |
INTEGER |
4 |
10 |
Header number |
|
| DATE_ENTERED |
DATE |
2 |
10 |
|
|
| DATE_BANK_RECONCILED |
DATE |
2 |
10 |
Bank Reconciliation date |
|
| CATE_ID |
INTEGER |
4 |
10 |
Clear Audit Trail Event ID |
|
| CIS_RECONCILED |
SMALLINT |
2 |
5 |
This transaction has been CIS reconciled |
|
| RECORD_CREATE_DATE |
|
16 |
0 |
Date and time when the record was created. |
|
| RECORD_MODIFY_DATE |
|
16 |
0 |
Date and time when the record was modified. |
|
| RECORD_DELETED |
TINYINT |
2 |
3 |
Flag denoting if the record has been deleted or not. |
|