|
Name |
Description |
Length |
Input |
Data Type |
| ACCOUNT_REF |
Sales/Purchase/Bank Account Reference |
8 |
Required |
String |
| AMOUNT_PAID |
Total Amount Paid (Allocated Against Invoice/Credit) |
8 |
Optional |
Double |
| BANK_CODE |
Bank Account Reference |
8 |
Required |
String |
| BANK_FLAG |
Bank Reconciled Flag |
1 |
Optional |
Byte or Character |
| CURRENCY |
Currency for Transaction (Not Used) |
1 |
Optional |
Byte or Character |
| CURRENCY_USED |
Currency Used (Not Used) |
1 |
Optional |
Byte or Character |
| DATE |
Transaction Date |
2 |
Required |
Date |
| DATE_DUE |
Date Invoice is Due for Payment |
2 |
Optional |
Date |
| DATE_LAST_CHARGE |
Date Interest Last Charged |
2 |
Optional |
Date |
| DELETED_FLAG |
Transaction Deleted Flag |
2 |
Optional |
Small Integer |
| DETAILS |
Details |
60 |
Optional |
String |
| ELEC_TRANS |
Electronic Transaction Flag |
2 |
Optional |
Small Integer |
| EURO_GROSS |
Euro Gross Amount |
8 |
Required |
Double |
| EURO_RATE |
Euro Rate |
8 |
Required |
Double |
| FINANCE_CHARGE |
Finance Charge Flag |
1 |
Optional |
Byte or Character |
| FIRST_SPLIT |
Item number |
4 |
Optional |
Long Integer |
| FOREIGN_GROSS |
Foreign Gross Amount |
8 |
Required |
Double |
| FOREIGN_RATE |
Foreign Rate for Euro Currency |
8 |
Required |
Double |
| INTEREST_RATE |
Interest Rate to Charge |
8 |
Required |
Double |
| INV_REF |
Invoice Reference Number |
8 |
Optional |
String |
| JOB_REFERENCE |
Job Costing Reference |
20 |
Optional |
String |
| LAST_SPLIT |
Item Number |
4 |
Optional |
Long Integer |
| NET_AMOUNT |
Net Amount |
8 |
Required |
Double |
| NEXT_ACCOUNT |
Item Number |
4 |
Optional |
Long Integer |
| NEXT_BANK |
Item Number |
4 |
Optional |
Long Integer |
| NO_DISPUTED |
Number of Disputed Splits |
2 |
Optional |
Small Integer |
| NO_OF_SPLIT |
Item Number |
4 |
Optional |
Long Integer |
| PAID_FLAG |
Transaction Paid Flag |
1 |
Optional |
Byte or Character |
| POSTED_DATE |
Posting Date |
2 |
Optional |
Date |
| POSTING_LOCATION |
Location Transaction Posted From |
2 |
Optional |
Small Integer |
| PREV_ACCOUNT |
Item Number |
4 |
Optional |
Long Integer |
| PREV_BANK |
Item Number |
4 |
Optional |
Long Integer |
| PRINTED_FLAG |
Printed Flag |
1 |
Optional |
Byte or Character |
| TAX_AMOUNT |
Tax Amount |
8 |
Optional |
Double |
| TYPE |
Transaction Types of BP, BR, CP, CR, VP and VR are valid ONLY. |
1 |
Required |
Byte or Character |
| UNIQUE_REF |
Header Number |
4 |
Optional |
Long Integer |
| USER_NAME |
User Name |
32 |
Optional |
String |
| VAT_FLAG |
VAT Flag |
1 |
Optional |
Byte or Character |