03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Native Tables
Native Table -
COMPANYDELIVERYDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Supplier account reference",12,8,1,0 ADDRESS_1,"Delivery address line 1",12,60,0,0 ADDRESS_2,"Delivery address line 2",12,60,0,0 ADDRESS_3,"Delivery address line 3",12,60,0,0 ADDRESS_4,"Delivery address line 4",12,60,0,0 ADDRESS_5,"Delivery address line 5",12,60,0,0 ADDRESS_REF,"Address reference number",5,2,1,0 ADDRESS_TYPE,"Address Type",-6,1,1,0 CONTACT_NAME,"Contact name",12,30,0,0 CONTACT_ROLE,"Contact Role",12,30,0,0 COUNTRY_CODE,"Country Code",12,2,1,0 DEFAULT_REF,"Default indicator",5,2,1,0 DESCRIPTION,"Description",12,60,1,0 EMAIL,"EMail",12,255,0,0 FAX,"Fax",12,30,0,0 NAME,"Name",12,60,1,0 NOTES,"Notes",12,200,0,0 RECORD_CREATE_DATE,"Date and time when the record was created",11,8,0,0 RECORD_DELETED,"Flag denoting if the record has been deleted or not.",5,2,0,0 RECORD_MODIFY_DATE,"Date and time when the record was modified",11,8,0,0 REFERENCE,"Delivery address reference",12,12,1,0 TAX_CODE,"Tax Code",5,2,1,0 TELEPHONE,"Telephone",12,30,0,0 TELEPHONE_2,"Telephone2",12,30,0,0 VAT_NUMBER,"Vat Registration Number",12,20,0,0