Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
URN*
|
Remittance Unique Reference Number
|
10
|
String
|
8
|
BANK_CODE
|
Bank Account Reference
|
10
|
String
|
8
|
ACCOUNT_REF
|
Supplier Account Reference
|
10
|
String
|
8
|
NAME
|
Account Name
|
10
|
String
|
60
|
ADDRESS_1
|
Account Address Line1
|
10
|
String
|
60
|
ADDRESS_2
|
Account Address Line2
|
10
|
String
|
60
|
ADDRESS_3
|
Account Address Line3
|
10
|
String
|
60
|
ADDRESS_4
|
Account Address Line4
|
10
|
String
|
60
|
ADDRESS_5
|
Account Address Line5
|
10
|
String
|
60
|
TELEPHONE
|
Telephone Number
|
10
|
String
|
30
|
FAX
|
Fax Number
|
10
|
String
|
30
|
CHEQUE
|
Cheque Reference
|
10
|
String
|
30
|
DATE
|
Remittance Date
|
10
|
Date
|
2
|
TYPE
|
Transaction Type
|
10
|
String
|
2
|
INVOICE_DATE
|
Invoice Date
|
10
|
Date
|
2
|
INV_REF
|
Invoice Reference
|
10
|
String
|
30
|
EXTRA_REF
|
Extra Reference
|
10
|
String
|
60
|
DETAILS
|
Details
|
10
|
String
|
60
|
TAX_CODE
|
Tax Code
|
10
|
String
|
3
|
NET_AMOUNT
|
Invoice Net Amount
|
10
|
Double
|
8
|
TAX_AMOUNT
|
Invoice Tax Amount
|
10
|
Double
|
8
|
GROSS_AMOUNT
|
Invoice Gross Amount
|
10
|
Double
|
8
|
PAYMENT
|
Payment on this remittance
|
10
|
Double
|
8
|
FOREIGN_RATE
|
Foreign Exchange Rate
|
10
|
Double
|
8
|
CURRENCY
|
Currency
|
10
|
Int16
|
1
|
PRINTED_FLAG
|
Printed flag
|
10
|
Boolean
|
2
|
PAID_FLAG
|
Paid flag
|
10
|
Boolean
|
2
|
LAST_LINE
|
Last Line flag
|
10
|
Boolean
|
2
|
RECORD_CREATE_DATE
|
Date and time when the record was created.
|
2009
|
Date
|
8
|
RECORD_MODIFY_DATE
|
Date and time when the record was modified.
|
2009
|
Date
|
8
|
RECORD_DELETED
|
Flag denoting if the record has been deleted or not.
|
2009
|
Boolean
|
2
|