SAGE DATA OBJECTS > C#


sage line 50 sage line 100 sage line 50 training 50 line pos sage sage line 50 financial controller 100 line sage software 50 line sage software training 50 accounting line sage software sage line 50 software sage line sage line 50 training course 50 controller financial line sage v12 sage line 50 note 100 50 line sage 50 cheap discount line sage Searches done in April 2006 Count Search Term sage software sage accounting software sage payroll software sage software inc 100 line sage software 50 line sage software training act sage software sage payroll software training sage software training 50 accounting line sage software sage software mas 90 sage line 50 software accounting sage sales software sage payroll software course sage account software discount sage software sage accounting software uk sage book keeping software form sage software sage line50 software C# .NET Visual Basic .NET VB.NET Component OCX DLL Return to Sage Data Objects for .NET homepage SOPDATA Fields

SOPData Fields

Name Description Length Input Data Type
ACCOUNT_REF Account Reference 8 Required String
ADDRESS_1 Address Line 1 60 Optional String
ADDRESS_2 Address Line 2 60 Optional String
ADDRESS_3 Address Line 3 60 Optional String
ADDRESS_4 Address Line 4 60 Optional String
ADDRESS_5 Address Line 5 60 Optional String
AMOUNT_PREPAID Amount Prepaid 8 Optional Double
BANK_CODE Bank Posting Code 8 Optional String
CARR_DEPT_NUMBER Carriage Department Number 2 Optional Small Integer
CARR_NET Carriage Net Amount 8 Optional Double
CARR_NOM_CODE Carriage Nominal Code 8 Optional String
CARR_TAX Carriage Tax Amount 8 Optional Double
CARR_TAX_CODE Carriage Tax Code 2 Optional Small Integer
CONSIGNMENT_REF Consignment Reference 30 Optional String
CONTACT_NAME Contact Name 30 Optional String
COURIER Courier Number 2 Optional Small Integer
CURRENCY Transaction Currency (Not Used) 1 Optional Byte or Character
CURRENCY_USED Currency Used (Not Used) 1 Optional Byte or Character
CUST_DISC_RATE Customer Discount 8 Optional Double
CUST_ORDER_NUMBER Customer's Order Number 30 Optional String
CUST_TEL_NUMBER Customer's Telephone Number 30 Optional String
DEL_ADDRESS_1 Delivery Address Line 1 60 Optional String
DEL_ADDRESS_2 Delivery Address Line 2 60 Optional String
DEL_ADDRESS_3 Delivery Address Line 3 60 Optional String
DEL_ADDRESS_4 Delivery Address Line 4 60 Optional String
DEL_ADDRESS_5 Delivery Address Line 5 60 Optional String
DELETED_FLAG Deleted? 2 Optional Small Integer
DESPATCH_DATE Despatch Date 2 Optional Date
DISCOUNT_TYPE Discount Type 1 Optional Byte or Character
EURO_GROSS Euro Gross Amount 8 Optional Double
EURO_RATE Euro Rate 8 Optional Double
EXTERNAL_USAGE Number of External Usages 4 Optional Long Integer
FIRST_ITEM Record Number of First Item 4 Optional Long Integer
FOREIGN_GROSS Foreign Gross Amount 8 Optional Double
FOREIGN_RATE Foreing Rate for Euro Currency 8 Optional Double
GLOBAL_DETAILS Global Details 60 Optional String
GLOBAL_NOM_CODE Global Nominal Code 8 Optional String
GLOBAL_TAX_CODE Global Tax Code 2 Optional Small Integer
INVOICE_NUMBER Corresponding Invoice Number 7 Required String
ITEMS_NET Net Amount (Goods - Not Including Carriage) 8 Optional Double
ITEMS_TAX Tax Amount (Goods - Not Including Carriage) 8 Optional Double
NAME Name 60 Optional String
NOTES_1 Notes 1 60 Optional String
NOTES_2 Notes 2 60 Optional String
NOTES_3 Notes 3 60 Optional String
ORDER_DATE Order Date 2 Required Date
ORDER_NUMBER Order Number 4 Required Long Integer
PAYMENT_REF Payment Reference 8 Optional String
PAYMENT_TYPE Payment Type (Only SA and SR Apply) 1 Optional Byte or Character
PRINTED_CODE Printed Flag - 1/0 1 Optional Byte or Character
SETTLEMENT_DISC_RATE Settlement Discount % Rate 8 Optional Double
SETTLEMENT_DUE_DAYS Settlement Days 2 Optional Small Integer
STATUS Order Status Code 1 Optional Byte or Character
TAKEN_BY Order Taken By 60 Optional String
TOTAL_BYTES 4 Optional Long Integer