03333 445950

 

                                

 

Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Field details that are available.


SALES_ORDER
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 order.
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 order.
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 order.
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 order.
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 order.
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 order.
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.
DESPATCH_DATE Due 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})?)$ Order despatch due date 2451158 JulianDateNumber Date OptionalUse The main despatch due date associated with the order.
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 order 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 order 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 order 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 order 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 order (if appropriate).
INTRASTAT_STATUS Intrastat Status 0 2 2 LeftAlignment N N 0 0 6 ^[0-9]*$ ^[0-9]*$ Intrastat reconciled status 1 0 Numeric 2ByteInt OptionalUse The Intrastat Reconciled Status.
INVOICE_NUMBER Invoice No. 0 7 10 RightAlignment Y Y 0 0 9999999 ^[0-9]*$ ^[0-9]*$ Invoice Number 21 Text 4ByteInt SpecialUse The number of the corresponding invoice.
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_DATE Order 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})?)$ Order document date 2451158 JulianDateNumber Date RequiredUse The main date associated with the order.
ORDER_NUMBER Order No. 0 7 7 RightAlignment Y N 0 0 9999999 ^[0-9]*$ ^ *[0-9]*$ Order Number 1001 Numeric String SpecialUse Y The order number.
ORDER_TYPE Type 0 2 2 LeftAlignment N N 0 0 12 ^[0-9]*$ ^[0-9]*$ Document type code 9 0 Numeric 2ByteInt RequiredUse The type of document, choose from Invoice, Quote or Proforma
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
PRINTED_CODE Printed 0 1 0 NoAlignment N N 0 0 0 ^[01FNTYfnty]$ ^[01FNTYfnty]*$ Has Order been printed? Y Boolean 1ByteInt OptionalUse Indicates whether the order 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 v2008/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 order.
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
STATUS Status 0 2 2 LeftAlignment N N 0 0 10 ^[0-9]*$ ^[0-9]*$ Order status code 0 Numeric 2ByteInt OptionalUse The order status in terms of allocation and delivery
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.
 


Accounting, Pay as you go Sage 50 Support, Excel Reports, Sage Reports, Sage 50 3rd Party integration and more!

This Sage 50 import website is copyright Making I.T. Happen 2022