03333 445950
 |
 |
 |
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.
| INVOICE | |||||||||||||||||||||||||||||
| Name | Label | Prefix | Postfix | Minlength | Maxlength | Widthhint | Padding | Alignment | Casesensitive | Allcaps | Dp | Minvalue | Maxvalue | Validchars | Validformat | Tooltip | Sample | Default | Nature | Storage | Usage | Primary Key | Details | ||||||
| ACCOUNT_REF | A/C | 0 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | ^[A-Z0-9#_/!%&\.\-\$\(\)\042\054']*$ | Account Reference | SKYEWR01 | Text | String | RequiredUse | > | The account reference for the invoice. | ||||||||||
| ADDRESS_1 | Street1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 1 | Unit 1 | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_2 | Street2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 2 | High Street | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_3 | Town | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 3 | Sometown | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_4 | County | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 4 | Someshire | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| ADDRESS_5 | Post Code | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Address Line 5 | ZZ00 00AA | Text | String | OptionalUse | > | The address for this account. | ||||||||||
| AMOUNT_PREPAID | Payment Amount | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Pre-paid amount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of any pre-payment for the invoice. | ||||||||||
| BANK_CODE | Bank N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Bank nominal account code | 0 | Text | String | OptionalUse | > | The nominal code for banking any amount paid. | ||||||||||
| BASE_TOT_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item discounted totals (i.e. net). Does not include carriage. | ||||||||||
| BASE_TOT_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item tax amounts. | ||||||||||
| BASE_CARR_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The net value of carriage for the invoice. | ||||||||||
| BASE_CARR_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of tax on the carriage. | ||||||||||
| BASE_NETVALUE_DISCOUNT | Net Disc | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Net discount value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Base Net discount value. | ||||||||||
| BASE_SETT_DISC_RATE | Discount % | 0 | 5 | 5 | RightAlignment | N | N | 2 | 0 | 99.99 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Early settlement discount percentage | 5 | 0 | Text | 8ByteDouble | OptionalUse | > | The percentage discount allowed for early payment of the invoice. | |||||||||
| BASE_AMOUNT_PAID | Payment Amount | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Pre-paid amount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of any pre-payment for the invoice. | ||||||||||
| CARR_DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Carriage department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department to be used for carriage anaylsis. | |||||||||
| CARR_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The net value of carriage for the invoice. | ||||||||||
| CARR_NOM_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Carriage nominal account | 0 | Text | String | OptionalUse | > | The nominal code for any carriage charge. | ||||||||||
| CARR_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Carriage tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The value of tax on the carriage. | ||||||||||
| CARR_TAX_CODE | Tax Code | T | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Carriage tax code | 1 | Numeric | 2ByteInt | OptionalUse | > | The tax code for any carriage charge. | |||||||||
| CONSIGNMENT_REF | Consign. No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Consignment Number | Any Text | Text | String | OptionalUse | > | The Consignment Number. | ||||||||||
| CONTACT_NAME | Contact name | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Contact | Duine Gasda | Text | String | OptionalUse | > | A contact name for this account. This is usually the accounts contact. | ||||||||||
| COURIER | Courier | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Courier number | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The courier used. | |||||||||
| CURRENCY | Currency | 1 | 2 | 2 | RightAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]?[0-9]$ | Transaction currency | 1 | Numeric | 2ByteInt | OptionalUse | > | Transaction Currency. Sage Documentation at Sage v7 says <em>Not Used</em>, but it appears to be the document account currency. | ||||||||||
| CURRENCY_USED | Currency Used | 1 | 2 | 2 | RightAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[0-9]?[0-9]$ | Currency used | 6 | Numeric | 2ByteInt | OptionalUse | > | Currency Used (Not Used). Sage Documentation at Sage v7 says <em>Not Used</em>. | ||||||||||
| CUST_DISC_RATE | Disc % | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Customer based discount rate | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The customer based discount percentage. | ||||||||||
| CUST_ORDER_NUMBER | Customer Order No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Customer Order Number | Any Text | Text | String | OptionalUse | > | The Customer Order Number relating to the invoice. | ||||||||||
| CUST_TEL_NUMBER | Customer Tel. No. | 0 | 30 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Customer Telephone Number | 0000 00000000 | Text | String | OptionalUse | > | A contact telephone number. | ||||||||||
| DEL_ADDRESS_1 | Street1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 1 | Floor 1, Building A | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_2 | Street2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 2 | High Street | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_3 | Town | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 3 | Atown | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_4 | County | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 4 | Ashire | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DEL_ADDRESS_5 | Post Code | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account delivery address line 5 | ZZ99 00ZZ | Text | String | OptionalUse | > | The delivery address for this account. | ||||||||||
| DELIVERY_NAME | Name | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Delivery Name | A Delivery Company Name | Text | String | OptionalUse | > | The company associated with the delivery. | ||||||||||
| DISCOUNT_COMMENT1 | Disc Comment 1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Discount Comment 1 | Any Text | Text | String | OptionalUse | > | A discount comment line. | ||||||||||
| DISCOUNT_COMMENT2 | Disc Comment 2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Discount Comment 2 | Any Text | Text | String | OptionalUse | > | A discount comment line. | ||||||||||
| DISCOUNT_TYPE | Additional Disc. | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 6 | ^[0-9]*$ | ^[0-9]*$ | Additional discount scheme type | 3 | 0 | Numeric | 2ByteInt | OptionalUse | > | The type of discount scheme applicable. | |||||||||
| DUNS_NUMBER | Duns Number | 0 | 9 | 9 | LeftAlignment | N | N | 0 | 0 | 0 | ^\d*$ | ^\d*$ | Duns Number | 123456789 | Text | String | OptionalUse | > | Duns Number for the account (new Sage 50 v2008/v14). | ||||||||||
| EURO_GROSS | Euro Gross | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Gross value in Euros | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The gross invoice value in Euros (if applicable). | ||||||||||
| EURO_RATE | Euro Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 6 | -99999999.99 | 1000000000 | ^[\.0-9]*$ | ^[0-9]+\.[0-9]+$ | Euro Rate | 1.4 | 1 | Numeric | 8ByteDouble | OptionalUse | > | Euro Rate (if applicable). | |||||||||
| FIRST_ITEM | First Item | 0 | 10 | 10 | RightAlignment | Y | Y | 0 | 0 | 999999999 | ^[0-9]*$ | ^[0-9]*$ | First Item Pos. | 21 | 0 | Numeric | 4ByteInt | SpecialUse | > | Position of first item. | |||||||||
| FOREIGN_GROSS | Foreign Gross | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Gross value in foreign currency | 1000 | Numeric | 8ByteDouble | OptionalUse | > | The gross invoice value in foreign currency (if applicable). | ||||||||||
| FOREIGN_RATE | Foreign Rate | 0 | 12 | 12 | RightAlignment | Y | Y | 6 | -99999999.99 | 1000000000 | ^[\.0-9]*$ | ^[0-9]+\.[0-9]+$ | Foreign Rate | 1.4 | 1 | Numeric | 8ByteDouble | OptionalUse | > | Foreign Rate (if applicable). | |||||||||
| GLOBAL_DEPT_NUMBER | Dept | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Global department | 100 | 0 | Numeric | 2ByteInt | OptionalUse | > | The department to be used for invoice anaylsis. | |||||||||
| GLOBAL_DETAILS | Details | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | GlobalDetails | Any Text | Text | String | OptionalUse | > | Global Details. | ||||||||||
| GLOBAL_NOM_CODE | N/C | 4 | 8 | 8 | LeftAlignment | Y | Y | 0 | 0 | 0 | ^[0-9]*$ | ^[0-9]*$ | Global nominal account | 0 | Text | String | OptionalUse | > | The nominal code for overall invoice analysis (if appropriate). | ||||||||||
| GLOBAL_TAX_CODE | Tax Code | T | 0 | 3 | 3 | LeftAlignment | N | N | 0 | 0 | 99 | ^[0-9]*$ | ^[1-9]?[0-9]$ | Global tax code | 1 | Numeric | 2ByteInt | OptionalUse | > | The overall tax code for the invoice (if appropriate). | |||||||||
| INVOICE_DATE | Invoice Date | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Invoice document date | 2451158 | JulianDateNumber | Date | RequiredUse | > | The main date associated with the invoice. | ||||||||||
| INVOICE_NUMBER | Invoice No. | 0 | 7 | 10 | RightAlignment | Y | Y | 0 | 0 | 9999999 | ^[0-9]*$ | ^[0-9]*$ | Invoice Number | 21 | Numeric | 4ByteInt | SpecialUse | primary="Y" | > | The number of the invoice. | |||||||||
| INVOICE_TYPE_CODE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 12 | ^[0-9]*$ | ^[0-9]*$ | Document type code | 1 | 0 | Numeric | 2ByteInt | RequiredUse | > | The type of document, choose from Invoice, Quote or Proforma | |||||||||
| ITEMS_NET | Net | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items net value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item discounted totals (i.e. net). Does not include carriage. | ||||||||||
| ITEMS_TAX | VAT | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | -99999999.99 | 1000000000 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Items tax value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Sum of item tax amounts. | ||||||||||
| LAST_NETVALUE_DISCOUNT | Last Net Disc | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Net discount value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Last Net discount value. | ||||||||||
| LAST_UPDATED | Last Updated | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Date of last update | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of last update. | ||||||||||
| NAME | Name | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Account Name | A Sample Company Name | Text | String | OptionalUse | > | The company associated with this account. | ||||||||||
| NETVALUE_DESCRIPTION | Description | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Product description | A Sample Product Name | Text | String | OptionalUse | > | The name of the product associated with this code. | ||||||||||
| NETVALUE_DISCOUNT | Net Disc | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Net discount value | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Net discount value. | ||||||||||
| NETVALUE_DISCOUNT_PERCENT | Net Disc% | 0 | 12 | 12 | RightAlignment | Y | Y | 4 | 0 | 100 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9]{4}$ | Net discount rate | 25 | Numeric | 8ByteDouble | OptionalUse | > | Net discount percentage rate. | ||||||||||
| NOTES_1 | Note 1 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 1 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| NOTES_2 | Note 2 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 2 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| NOTES_3 | Note 3 | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Note 3 | Any Text | Text | String | OptionalUse | > | A note line. | ||||||||||
| ORDER_NUMBER | Order No. | 0 | 7 | 7 | RightAlignment | Y | N | 0 | 0 | 9999999 | ^.*$ | ^.*$ | Order Number | 1001 | Text | String | OptionalUse | > | The corresponding order number. May be non-numeric if not an SOP invoice | ||||||||||
| PAYMENT_REF | Pymt Ref | 0 | 30 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Payment Reference | Any Text | Text | String | OptionalUse | > | The Payment Reference. | ||||||||||
| PAYMENT_TYPE | Type | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 18 | ^[0-9]*$ | ^[0-9]*$ | Payment type code | 1 | Numeric | 2ByteInt | OptionalUse | > | The type of payment, choose from Sales Receipt or Sale Payment on Account | ||||||||||
| POSTED_CODE | Posted | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Has Invoice been posted? | Y | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the invoice has been posted to the ledgers. | ||||||||||
| PRINTED_CODE | Printed | 0 | 1 | 0 | NoAlignment | N | N | 0 | 0 | 0 | ^[01FNTYfnty]$ | ^[01FNTYfnty]*$ | Has Invoice been printed? | Y | Boolean | 1ByteInt | OptionalUse | > | Indicates whether the invoice has been printed. | ||||||||||
| QUOTE_EXPIRY | Quote Expiry | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Quote expiry date | 2451158 | JulianDateNumber | Date | OptionalUse | > | Quote expiry date if relevant | ||||||||||
| QUOTE_STATUS | Quote Status | 0 | 2 | 2 | LeftAlignment | N | N | 0 | 0 | 4 | ^[0-9]*$ | ^[0-9]*$ | Quote status code | 1 | Numeric | 2ByteInt | OptionalUse | > | The status of the quote, if relevant. | ||||||||||
| RECORD_CREATE_DATE | Create Date | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Date of creation | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of record creation | ||||||||||
| RECORD_DELETED | Deleted | 0 | 7 | 1 | LeftAlignment | N | N | 0 | -9999999 | 9999999 | ^[0-9\-]*$ | ^[0-9\-]*$ | Deleted flag | 1 | 0 | Numeric | 2ByteInt | OptionalUse | > | Record deleted flag. | |||||||||
| RECORD_MODIFY_DATE | Modify Date | 0 | 10 | 10 | LeftAlignment | N | N | 0 | 2440588 | 2488069 | ^[0-9 /]*$ | ^(?:\d{1,2}/\d{1,2}/\d{2}(?:\d{2})?|\d\d\d\d\d{2}(?:\d{2})?)$ | Date of modification | 2451158 | JulianDateNumber | Date | OptionalUse | > | Date of last modification | ||||||||||
| RECURRING_REFERENCE | Recurr Ref | 0 | 8 | 8 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Recurring Reference | Any Text | Text | String | OptionalUse | > | The Recurring Reference. | ||||||||||
| SEND_VIA_EMAIL | Via Email | 0 | 1 | 1 | LeftAlignment | N | N | 0 | 0 | 1 | ^.*$ | ^.*$ | Output to Email | 0 | Numeric | 1ByteInt | OptionalUse | > | Flag To State Output to Email (new v2004/v14) | ||||||||||
| SETTLEMENT_DISC_RATE | Discount % | 0 | 5 | 5 | RightAlignment | N | N | 2 | 0 | 99.99 | ^[\+\-\.0-9]*$ | ^[\+\-]?[0-9]+\.[0-9][0-9]$ | Early settlement discount percentage | 5 | 0 | Numeric | 8ByteDouble | OptionalUse | > | The percentage discount allowed for early payment of the invoice. | |||||||||
| SETTLEMENT_DUE_DAYS | Days | 0 | 3 | 3 | RightAlignment | N | N | 0 | 0 | 999 | ^[0-9]*$ | ^[0-9][0-9]?[0-9]?$ | Days for early settlement discount | 7 | Numeric | 2ByteInt | OptionalUse | > | The limit, in days, for payment of the invoice to qualify for early settlement discount | ||||||||||
| TAKEN_BY | Taken by | 0 | 60 | 30 | LeftAlignment | N | N | 0 | 0 | 0 | ^.*$ | ^.*$ | Order Taken By | Any Text | Text | String | OptionalUse | > | Order Taken By. | ||||||||||
| UNALLOCATED_NETVALUE_DISCOUNT | Unalloc NVD | 0 | 12 | 12 | RightAlignment | Y | Y | 2 | 0 | 1000000000 | ^[\+\.0-9]*$ | ^\+?[0-9]+\.[0-9][0-9]$ | Unalloc Net Value Discount | 1000 | Numeric | 8ByteDouble | OptionalUse | > | Unallocated Net Value Discount (an internal technical value). | ||||||||||
| RecordNumber | RecordNumber | 0 | 10 | 10 | 0 | RightAlignment | N | N | 0 | 0 | 2147483647 | ^[0-9]*$ | ^[0-9]*$ | Record number | 12 | PaddedNumeric | None | SpecialUse | > | The record number. | </header> | </sydd> | |||||||