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 SALESRECORD Fields

SalesRecord Fields

Name	Description	Length	Input	Data Type
ACCOUNT_MANAGER	Name of Account Manager	60	Optional	String
ACCOUNT_ON_HOLD	Account On Hold	1	Optional	Byte or Character
ACCOUNT_OPENED	Date Account Opened	2	Optional	Date
ACCOUNT_REF	Account Reference	8	Required	String
ACCOUNT_STATUS	Account Status	2	Optional	Small Integer
ACCOUNT_TYPE	Account Type (Not Used)	2	Optional	Small Integer
ADDRESS_1	Account Address Line1	60	Optional	String
ADDRESS_2	Account Address Line2	60	Optional	String
ADDRESS_3	Account Address Line3	60	Optional	String
ADDRESS_4	Account Address Line4	60	Optional	String
ADDRESS_5	Account Address Line5	60	Optional	String
ANALYSIS_1	Analysis 1	30	Optional	String
ANALYSIS_2	Analysis 2	30	Optional	String
ANALYSIS_3	Analysis 3	30	Optional	String
BACS	Account Flagged for BACS	2	Optional	Small Integer
BACS_REFERENCE	Reference for BACS Transfer	60	Optional	String
BALANCE	Balance	8	Optional	Double
BUILD_SOCIETY_REF	Reference for Building Society Transfer (Not Used)	60	Optional	String
BUILDING_SOCIETY	Account Uses Building Society (Not Used)	2	Optional	Small Integer
CAN_APPLY_CHARGES	Can Apply Charges	2	Optional	Small Integer
CONTACT_NAME	Contact Name	30	Optional	String
CREDIT_APP_RECEIVED	True if Credit Application Received	2	Optional	Small Integer
CREDIT_APPLIED_FOR	Date Credit Applied For	2	Optional	Date
CREDIT_BF	Credits Brought Forward	8	Optional	Double
CREDIT_BUREAU	Credit Bureau Used	2	Optional	Small Integer
CREDIT_CARD_NO	Credit Card Number	30	Optional	String
CREDIT_CF	Credits Carry Forward	8	Optional	Double
CREDIT_LIMIT	Credit Limit	8	Optional	Double
CREDIT_MTH1	Credits Month 1	8	Optional	Double
CREDIT_MTH10	Credits Month 10	8	Optional	Double
CREDIT_MTH11	Credits Month 11	8	Optional	Double
CREDIT_MTH12	Credits Month 12	8	Optional	Double
CREDIT_MTH2	Credits Month 2	8	Optional	Double
CREDIT_MTH3	Credits Month 3	8	Optional	Double
CREDIT_MTH4	Credits Month 4	8	Optional	Double
CREDIT_MTH5	Credits Month 5	8	Optional	Double
CREDIT_MTH6	Credits Month 6	8	Optional	Double
CREDIT_MTH7	Credits Month 7	8	Optional	Double
CREDIT_MTH8	Credits Month 8	8	Optional	Double
CREDIT_MTH9	Credits Month 9	8	Optional	Double
CREDIT_REFERENCE	Credit Bureau Reference	60	Optional	String
CURRENCY	Currency	1	Optional	Byte or Character
DATE_CREDIT_APP_RECEIVED	Date Credit Application Received	2	Optional	Date
DEF_NOM_CODE	Default Nominal Code	8	Optional	String
DEF_TAX_CODE	Tax Code Number	2	Optional	Small Integer
DEL_ADDRESS_1	Delivery Address Line1	60	Optional	String
DEL_ADDRESS_2	Delivery Address Line2	60	Optional	String
DEL_ADDRESS_3	Delivery Address Line3	60	Optional	String
DEL_ADDRESS_4	Delivery Address Line4	60	Optional	String
DEL_ADDRESS_5	Delivery Address Line5	60	Optional	String
DEL_CONTACT_NAME	Delivery Contact Name	30	Optional	String
DEL_FAX	Delivery Fax Number	30	Optional	String
DEL_TELEPHONE	Delivery Telephone Number	30	Optional	String
DELETED_FLAG	Deleted Record?	2	Optional	Small Integer
DEPT_NUMBER	Department Number	2	Optional	Small Integer
DISCOUNT_RATE	Discount Rate	8	Optional	Double
DISCOUNT_TYPE	Discount Type	1	Optional	Byte or Character
E_MAIL	E-Mail Address	255	Optional	String
EC_CODE	EC Member Code	3	Optional	String
EXTERNAL_USAGE	Number of External Usages for This Record	4	Optional	Long Integer
FAX	Fax Number	30	Optional	String
FIRST_HEADER	First header	4	Optional	Long Integer
FIRST_INVOICE	First Invoice Date	2	Optional	Date
HOLD_MAIL	Restrict Mail	2	Optional	Small Integer
INVOICE_BF	Invoices Brought Forward	8	Optional	Double
INVOICE_CF	Invoices Carry Forward	8	Optional	Double
INVOICE_MTH1	Invoices Month 1	8	Optional	Double
INVOICE_MTH10	Invoices Month 10	8	Optional	Double
INVOICE_MTH11	Invoices Month 11	8	Optional	Double
INVOICE_MTH12	Invoices Month 12	8	Optional	Double
INVOICE_MTH2	Invoices Month 2	8	Optional	Double
INVOICE_MTH3	Invoices Month 3	8	Optional	Double
INVOICE_MTH4	Invoices Month 4	8	Optional	Double
INVOICE_MTH5	Invoices Month 5	8	Optional	Double
INVOICE_MTH6	Invoices Month 6	8	Optional	Double
INVOICE_MTH7	Invoices Month 7	8	Optional	Double
INVOICE_MTH8	Invoices Month 8	8	Optional	Double
INVOICE_MTH9	Invoices Month 9	8	Optional	Double
LAST_CREDIT_REV	Date Last Credit Review	2	Optional	Date
LAST_HEADER	Last	4	Optional	Long Integer
LAST_INV_DATE	Last Invoice Date	2	Optional	Date
MEMO_OFFSET	Offset in Credit Memo File	4	Optional	Long Integer
MEMO_SIZE	Size of Memo in Bytes	4	Optional	Long Integer
NAME	Account Name	60	Optional	String
NEXT_CREDIT_REV	Date Next Credit Review	2	Optional	Date
NO_OF_HEADER	Number of Transactions	4	Optional	Long Integer
OVERRIDE_PRODUCT_TAX	Override Product Tax Code in Invoicing	1	Optional	Byte or Character
PAYMENT_BF	Payments Brought Forward	8	Optional	Double
PAYMENT_CF	Payments Carry Forward	8	Optional	Double
PAYMENT_DUE_DAYS	Payment Due Days	2	Optional	Small Integer
PAYMENT_MTH1	Payments Month 1	8	Optional	Double
PAYMENT_MTH10	Payments Month 10	8	Optional	Double
PAYMENT_MTH11	Payments Month 11	8	Optional	Double
PAYMENT_MTH12	Payments Month 12	8	Optional	Double
PAYMENT_MTH2	Payments Month 2	8	Optional	Double
PAYMENT_MTH3	Payments Month 3	8	Optional	Double
PAYMENT_MTH4	Payments Month 4	8	Optional	Double
PAYMENT_MTH5	Payments Month 5	8	Optional	Double
PAYMENT_MTH6	Payments Month 6	8	Optional	Double
PAYMENT_MTH7	Payments Month 7	8	Optional	Double
PAYMENT_MTH8	Payments Month 8	8	Optional	Double
PAYMENT_MTH9	Payments Month 9	8	Optional	Double
PRIOR_YEAR	Turnover Last Year	8	Optional	Double
SALES_REP	Name of Sales Representative	60	Optional	String
SETTLEMENT_DISC_RATE	Settlement Discount Rate	8	Optional	Double
SETTLEMENT_DUE_DAYS	Settlement Due Days	2	Optional	Small Integer
TELEPHONE	Telephone Number	30	Optional	String
TELEPHONE_2	Second Telephone Number	30	Optional	String
TERMS	Terms	30	Optional	String
TERMS_AGREED_FLAG	Terms	2	Optional	Small Integer
TRADE_CONTACT	Name of Trade Contact	30	Optional	String
TURNOVER_MTD	Turnover Month to Date	8	Optional	Double
TURNOVER_YTD	Turnover Year to Date	8	Optional	Double
VAT_REG_NUMBER	VAT Registration Number	30	Optional	String
WWW	WWW Address	255	Optional	String