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 -
SETUPDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCESS_RIGHTS,"Access rights enabled flag",5,2,0,0 ACTIVE_SEARCH,"Display Active Search",-6,1,0,0 ADDRESS_1,"Company Address Line1",12,60,0,0 ADDRESS_2,"Company Address Line2",12,60,0,0 ADDRESS_3,"Company Address Line3",12,60,0,0 ADDRESS_4,"Company Address Line4",12,60,0,0 ADDRESS_5,"Company Address Line5",12,60,0,0 ADDRESS_ON_STAT,"Print Name & Address on Stationery",-6,1,0,0 ADDRESS_ON_STATIONERY,"Address on Stationery flag",-6,1,0,0 ADDRESS_PROMPT_1,"Addr label 1",12,10,0,0 ADDRESS_PROMPT_2,"Addr label 2",12,10,0,0 ADDRESS_PROMPT_3,"Addr label 3",12,10,0,0 ADDRESS_PROMPT_4,"Addr label 4",12,10,0,0 ADDRESS_PROMPT_5,"Addr label 5",12,10,0,0 AGE_DISPUTE_CURRENT,"Age Disputed Items as Current",5,2,0,0 ALL_CUSTOMERS,"All Customers",-6,1,0,0 ALLOW_NEGATIVE_STOCK,"Allow negative stock flag",5,2,0,0 ALLOW_ON_HOLD_TRANS_ENTRY,"Allow entering transactions to an on hold account",5,2,0,0 BANK_FEEDS_COMPANY_ID,"Bank Cloud Company ID",12,37,0,0 BANK_FEEDS_ORGANISTION_ID,"Bank Cloud Organisation ID",12,37,0,0 BANK_FEEDS_USER_EMAIL,"Bank Cloud User Email",12,37,0,0 BASE_CURRENCY,"Base currency",5,2,0,0 BUDGETING_TYPE,"Budgeting Method",5,2,0,0 CASH_REGISTER_BANK,"Cash register bank nominal",12,8,0,0 CASH_REGISTER_DISCREPENCIES_NOM,"Cash register discrepencies nominal",12,8,0,0 CASH_REGISTER_SALES_NOM,"Cash register sales nominal",12,8,0,0 CASH_REGISTER_TAX_INCLUSIVE_FLAG,"Cash register tax inclusive flag",-6,1,0,0 CASH_REGISTER_TAXCODE,"Cash register tax code nominal",5,2,0,0 CASHSALES_ADD_MESSAGE,"Cash Sales Adds a Message line to Inv",5,2,0,0 CASHSALES_DEFAULT_BANK,"Cash Sales Default Bank",12,8,0,0 CASHSALES_MESSAGE,"Message Line Added to Inv by Cash Sales",12,60,0,0 CASHSALES_PRINT_GDN,"Cash Sales Prints GDN",5,2,0,0 CASHSALES_PRINT_INVOICE,"Cash Sales Prints Invoice",5,2,0,0 CASHSALES_PRINT_SOP,"Cash Sales Prints SOP",5,2,0,0 CASHSALES_USE_DEFAULT_BANK,"Use default Bank without prompting",5,2,0,0 CHARITY_ENABLED,"Enable Charity - Non Profit options",-6,1,0,0 CHEQUE_LINES,"Cheque Lines Per Page",5,2,0,0 CLOSED_LEDGER_CHECK_DATE,"The date which a transaction being posted is validated against",9,2,0,0 CLOSED_LEDGER_DATE_CONTROL_ENABLED,"Flag indicating if closed ledger control is currently enforced",-6,1,0,0 COMPANYID,"Unique Company Id",12,36,3,0 COUNTRY_CODE,"Country Code",12,2,0,0 CREDIT_CHARGE_DEP,"Credit Charge Department",5,2,0,0 CREDIT_REF,"Credit Reference Number",12,60,0,0 CUST_UPDATE_TRAN_EX_REF_FROM,"Source used to fill the extra reference field",5,2,0,0 CUST_UPDATE_TRAN_REF_FROM,"Source used to fill the reference field",5,2,0,0 CUSTOMER_COUNTRY_CODE,"Default Customer Country Code",12,2,0,0 DEF_COURIER,"Default Courier",5,2,0,0 DEF_CREDIT_BUREAU,"Default Credit Bureau",5,2,0,0 DEF_CUST_STATUS,"Default Status for Customer Accounts",5,2,0,0 DEF_DELIVERY_TERMS,"Default Delivery Terms",12,8,0,0 DEF_DELIVERY_TERMS_FOR_PURCHASES,"Default Delivery Terms For Purchases",12,8,0,0 DEF_DELIVERY_TERMS_FOR_SALES,"Default Delivery Terms For Sales",12,8,0,0 DEF_NOTC,"Default Nature Of Transaction Code",12,8,0,0 DEF_NOTC_FOR_PURCHASES,"Default Nature Of Transaction Code For Purchases",12,8,0,0 DEF_NOTC_FOR_SALES,"Default Nature Of Transaction Code For Sales",12,8,0,0 DEF_PUR_ADDRESS,"Default Purchase Order Address",4,4,0,0 DEF_SUPP_STATUS,"Default Status for Supplier Accounts",5,2,0,0 DEFAULT_CHART,"Default Layout of Accounts",5,2,0,0 DEPARTMENTS_LABEL,"Departments Label",12,10,0,0 E_MAIL,"Company EMail Address",12,255,0,0 ECSALES_BRANCH_POSTCODE,"VAT Settings EC Sales List Brach PostCode",12,8,0,0 ENABLE_PROJECT_COSTING,"Enable Project Costing",-6,1,0,0 EURO_RATE,"euro Rate",8,8,0,0 EXCLUDE_DOCTOR,"Exclude Deleted Transactions",5,2,0,0 FAX,"Fax Number",12,30,0,0 FINYEAR_MONTH,"Financial Year start month",-6,1,0,0 FINYEAR_YEAR,"Financial Year",5,2,0,0 FIXEDASSETS_LABEL,"Fixed Assets Label",12,10,0,0 FLAT_RATE_VAT_PERCENT,"Flat Rate VAT Percent",8,8,0,0 INV_SHOW_SPECIAL_CODES,"Show special codes in Invoicing/Sop/Pop",-6,1,0,0 INVOICE_CARR_DEPT,"Default Invoice Carriage Department",5,2,0,0 INVOICE_CARR_NET,"Default Invoice Carriage Net",8,8,0,0 INVOICE_CARR_NOMINAL,"Default Invoice Carriage Nominal Code",12,8,0,0 INVOICE_DEF_ACC,"Invoice Default to Account Ref",-6,1,0,0 INVOICE_DEF_QTY,"Invoice Item Default to Qty",-6,1,0,0 INVOICE_DEF_SRVTEXT,"Default Service Text",12,8,0,0 INVOICE_DISC_UNITPRICE,"Calculate Unit Price by Discount",-6,1,0,0 ITEM_AMENDABLE,"VAT Amendable on items",5,2,0,0 LAST_AUDIT_CHECK,"Last Audit Trail Check Date",9,2,0,0 LAST_BACKUP,"Last Backup Date",9,2,0,0 LAST_BANK_CHECK,"Last Bank Check Date",9,2,0,0 LAST_CHEQUE,"Last system generated remittance number",4,4,0,0 LAST_CLEAR_AUDIT,"Date Last Clear Audit Trail",9,2,0,0 LAST_INVOICE_CHECK,"Last Invoice Check Date",9,2,0,0 LAST_MONTH_END,"Last Month End",9,2,0,0 LAST_NOMINAL_CHECK,"Last Nominal Check Date",9,2,0,0 LAST_POP_CHECK,"Last POP Check Date",9,2,0,0 LAST_PUCRHASE_CHECK,"Last Purchase Check Date",9,2,0,0 LAST_REMITTANCE,"Last system generated remittance number",4,4,0,0 LAST_SALES_CHECK,"Last Sales Check Date",9,2,0,0 LAST_SOP_CHECK,"Last SOP Check Date",9,2,0,0 LAST_STOCK_CHECK,"Last Stock Check Date",9,2,0,0 MAJOR_VERSION,"Major version number",-6,1,3,0 MINOR_VERSION,"Minor version number",-6,1,3,0 NAME,"Company Name",12,60,0,0 NO_RECUR_STARTUP,"No Recurring Entries as Startup",-6,1,0,0 NO_VAT_TAX_CODE,"No-VAT Tax Code",5,2,0,0 NO_WARN_VISA_RECEIPT,"No Warnings on Visa Receipt",-6,1,0,0 NON_VATABLE_TAX_CODE,"Non Vatable Tax Code",5,2,0,0 OVERRIDE_STOCK_DEP,"Override Stock Dept with Customer Dept",-6,1,0,0 POP_INTRASTAT_ENABLED,"Intrastat Reporting enabled for POP",-6,1,0,0 PRICE_LIST_PRICES,"Price List Prices",-6,1,0,0 PRINT_CHEQUE,"Cheque Voucher",-6,1,0,0 PRINT_LASER,"Laser Format",-6,1,0,0 PRINT_PAGE_THROW,"Page Throw",-6,1,0,0 PRINT_PLAIN,"Plain Format",-6,1,0,0 PRINT_PREFS,"Print Preferences",5,2,0,0 PRINT_QUICK,"Quick Format",-6,1,0,0 PRODUCT_ANALYSIS_1,"1st Product Customer Field",12,10,0,0 PRODUCT_ANALYSIS_2,"2st Product Customer Field",12,10,0,0 PRODUCT_ANALYSIS_3,"3st Product Customer Field",12,10,0,0 PRODUCT_DESCRIPTION_DISCOUNT_A,"Product Discount A label",12,20,0,0 PRODUCT_DESCRIPTION_DISCOUNT_B,"Product Discount B label",12,20,0,0 PRODUCT_DESCRIPTION_DISCOUNT_C,"Product Discount C label",12,20,0,0 PRODUCT_DESCRIPTION_DISCOUNT_D,"Product Discount D label",12,20,0,0 PRODUCT_DESCRIPTION_DISCOUNT_E,"Product Discount E label",12,20,0,0 PROGRAM_BUGFIX_VERSION,"Program Bugfix Version",5,2,0,0 PROGRAM_BUILD_VERSION,"Program Build Version",5,2,0,0 PROGRAM_MAJOR_VERSION,"Program Major Version",5,2,0,0 PROGRAM_MINOR_VERSION,"Program Minor Version",5,2,0,0 PROGRAM_TYPE,"Program Type Flag",5,2,0,0 PROJECT_CUSTOM_1,"Project Record Custom Field One Default",12,30,0,0 PROJECT_CUSTOM_2,"Project Record Custom Field Two Default",12,30,0,0 PROJECT_CUSTOM_3,"Project Record Custom Field Three Default",12,30,0,0 PURCHASE_ACCOUNT_STATUS,"Sales account status",5,2,0,0 PURCHASE_AGED_PAYMENTS,"",5,2,0,0 PURCHASE_AGREED_TERMS,"Sales agreed credit terms",5,2,0,0 PURCHASE_ANALYSIS_1,"Purchase analysis 1",12,10,0,0 PURCHASE_ANALYSIS_2,"Purchase analysis 2",12,10,0,0 PURCHASE_ANALYSIS_3,"Purchase analysis 3",12,10,0,0 PURCHASE_CAL_MTH_AGED,"Purchase Transaction Ageing Method",-6,1,0,0 PURCHASE_CARR_DEPT,"Default Purchase Carriage Department",5,2,0,0 PURCHASE_CARR_NET,"Default Purchase Carriage Net",8,8,0,0 PURCHASE_CARR_NOMINAL,"Default Purchase Carriage Nominal Code",12,8,0,0 PURCHASE_CREDIT_LIMIT,"Purchase default credit limit",8,8,0,0 PURCHASE_CURRENCY,"Purchase default currency",-6,1,0,0 PURCHASE_DAYS_TO_AGE,"Days to use for Purchase Transaction Ageing",5,2,0,0 PURCHASE_DEPARTMENT,"",5,2,0,0 PURCHASE_DISC_TYPE,"Purchase discount type",-6,1,0,0 PURCHASE_DISCOUNT_VAL,"",8,8,0,0 PURCHASE_DUEDAYS,"",5,2,0,0 PURCHASE_FUTURE,"Include Future Totals in Balance",5,2,0,0 PURCHASE_HOLD_MAIL,"Sales hold mail",5,2,0,0 PURCHASE_NOMINAL,"Purchase default nominal code",12,8,0,0 PURCHASE_PAY_DUE_DAYS,"",5,2,0,0 PURCHASE_PERIOD_1,"",5,2,0,0 PURCHASE_PERIOD_2,"",5,2,0,0 PURCHASE_PERIOD_3,"",5,2,0,0 PURCHASE_PERIOD_4,"",5,2,0,0 PURCHASE_SETT_DISCOUNT,"Purchase default sett.discount",8,8,0,0 PURCHASE_TAXCODE,"",5,2,0,0 PURCHASE_TERMS,"Purchase default nominal",12,30,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 REMITTANCE_LINES_PAGE,"No of remittance lines per page",5,2,0,0 REPORT_POSITION,"Report Position",-6,1,0,0 REPORTS_BANNER,"Reports Include Banner",5,2,0,0 REPORTS_DISPLAY,"Reports Display",-6,1,0,0 REPORTS_EMAIL,"Reports EMail",-6,1,0,0 REPORTS_FILE,"Reports File",-6,1,0,0 REPORTS_PREVIEW,"Reports Preview",-6,1,0,0 REPORTS_PRINTER,"Reports Printer",-6,1,0,0 REVISION_NO,"Revision number",-6,1,3,0 SALES_ACCOUNT_STATUS,"Sales account status",5,2,0,0 SALES_ADD_DISC_1,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_10,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_2,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_3,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_4,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_5,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_6,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_7,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_8,"Add.Disc.Table 1",8,8,0,0 SALES_ADD_DISC_9,"Add.Disc.Table 1",8,8,0,0 SALES_AGED_PAYMENTS,"Sales def Age by payments",5,2,0,0 SALES_AGREED_TERMS,"Sales agreed credit terms",5,2,0,0 SALES_AMOUNT_SOLD_1,"Sales Amount Sold 1",8,8,0,0 SALES_AMOUNT_SOLD_10,"Sales Amount Sold 10",8,8,0,0 SALES_AMOUNT_SOLD_2,"Sales Amount Sold 2",8,8,0,0 SALES_AMOUNT_SOLD_3,"Sales Amount Sold 3",8,8,0,0 SALES_AMOUNT_SOLD_4,"Sales Amount Sold 4",8,8,0,0 SALES_AMOUNT_SOLD_5,"Sales Amount Sold 5",8,8,0,0 SALES_AMOUNT_SOLD_6,"Sales Amount Sold 6",8,8,0,0 SALES_AMOUNT_SOLD_7,"Sales Amount Sold 7",8,8,0,0 SALES_AMOUNT_SOLD_8,"Sales Amount Sold 8",8,8,0,0 SALES_AMOUNT_SOLD_9,"Sales Amount Sold 9",8,8,0,0 SALES_ANALYSIS_1,"Sales Analysis 1",12,10,0,0 SALES_ANALYSIS_2,"Sales Analysis 2",12,10,0,0 SALES_ANALYSIS_3,"Sales Analysis 3",12,10,0,0 SALES_CAL_MTH_AGED,"Sales Transaction Ageing Method",-6,1,0,0 SALES_CREDIT_LIMIT,"Sales Credit limit",8,8,0,0 SALES_CURRENCY,"Sales def currency",-6,1,0,0 SALES_DAYS_TO_AGE,"Days to use for Sales Transaction Ageing",5,2,0,0 SALES_DEPARTMENT,"Sales def. department",5,2,0,0 SALES_DISC_TYPE,"Sales def discount type",-6,1,0,0 SALES_DISCOUNT_VAL,"Sales discount value",8,8,0,0 SALES_DUEDAYS,"Sales def due days",5,2,0,0 SALES_FINANCE_RATE,"Sales finance rate",8,8,0,0 SALES_FUTURE,"Include Future Totals in Balance",5,2,0,0 SALES_HOLD_MAIL,"Sales hold mail",5,2,0,0 SALES_LAST_FIN_DATE,"Sales last finance date",9,2,0,0 SALES_NOMINAL,"Sales def nominal code",12,8,0,0 SALES_PAY_DUE_DAYS,"Sales def Payment due in",5,2,0,0 SALES_PERIOD_1,"Sales aged period 1",5,2,0,0 SALES_PERIOD_2,"Sales aged period 2",5,2,0,0 SALES_PERIOD_3,"Sales aged period 3",5,2,0,0 SALES_PERIOD_4,"Sales aged period 4",5,2,0,0 SALES_SETT_DISCOUNT,"Sales Settlement discount",8,8,0,0 SALES_TAXCODE,"Sales def tax code",5,2,0,0 SALES_TERMS,"Sales def terms",12,30,0,0 SHOW_REPORT_BITMAP,"Show Report Bitmap",-6,1,0,0 SINGLE_USER_FLAG,"Single User Flag",5,2,0,0 SIPS_BANKREFN,"The reference for the SIPS bank account",12,8,0,0 SIPS_REF,"The GUID of the associated SIPS Account",12,37,0,0 SKELETON_JOURNALS,"Copy Skeleton Journal Values",5,2,0,0 SOP_INTRASTAT_ENABLED,"Intrastat Reporting enabled for SOP",-6,1,0,0 SPECIAL_PRICES,"Special Prices",-6,1,0,0 STOCK_CATEGORY,"Stock default category",5,2,0,0 STOCK_DEPARTMENT,"Stock default dept",5,2,0,0 STOCK_NEGATIVE_COUNTER,"Negative stock counter",4,4,0,0 STOCK_NOMINAL,"Stock default Sales nominal code",12,8,0,0 STOCK_PURCHASE_NOMINAL,"Stock default Purchse nominal code",12,8,0,0 STOCK_QTYDP,"Stock Qty DP",5,2,0,0 STOCK_TAXCODE,"Stock default Tax code",5,2,0,0 STOCK_UNITDP,"Stock Price DP",5,2,0,0 STOCK_UNITS,"Stock default Units",12,8,0,0 STOCKCATEGORY_LABEL,"Product Categories Label",12,10,0,0 SUPP_UPDATE_TRAN_EX_REF_FROM,"Source used to fill the extra reference field",5,2,0,0 SUPP_UPDATE_TRAN_REF_FROM,"Source used to fill the reference field",5,2,0,0 SUPPLIER_COUNTRY_CODE,"Default Supplier Country Code",12,2,0,0 TELEPHONE,"Telephone Number",12,30,0,0 TELEPHONE_2,"Company's 2nd Telephone Number",12,30,0,0 TERMS_WARNING,"Throw Warning on Terms",5,2,0,0 TRANSFER_DEFAULTS,"Transfer comp detials to new comp",5,2,0,0 UPDATE_SERVICE_TEXT,"Update Service Default Text",-6,1,0,0 VALIDATE_VAT_NO,"Validate VAT Numbers",-6,1,0,0 VALUE_DISCOUNTS,"Always apply value discounts to special items",-6,1,0,0 VAT_CASH_FLAG,"VAT Cash accounting flag",-6,1,0,0 VAT_REG_NUMBER,"VAT Registration Number",12,20,0,0 VAT_REGISTERED_FLAG,"Vat registered flag",-6,1,0,0 VAT_SCHEME_FLAG,"VAT scheme flag",-6,1,0,0 WELCOME_SCREEN_FLAG,"Hide welcome screen at startup",5,2,0,0 WIZ_SCALE_CODE,"Scale Charge Code",12,8,0,0 WIZ_SCALE_DATE,"Last Scale Charges Posting Date",9,2,0,0 WIZ_START_BILL,"Call Bill Nominal",12,8,0,0 WIZ_START_GROUP_BANK,"Group Items on Bank Rec",5,2,0,0 WIZ_START_GROUP_PP,"Group Invoices In Purchase Payments",5,2,0,0 WIZ_START_GROUP_SR,"Group Invoice In Sales Receipts",5,2,0,0 WIZ_START_LAST_POS,"Startup Wizard Last Position",5,2,0,0 WIZ_START_RUN,"Startup Wizard Already Ran",-6,2,0,0 WIZ_START_SPLITS,"Payment by Splits",5,2,0,0 WIZ_STK_CLOSE_CODE,"Stock Wizard Closing Stock Code",12,8,0,0 WIZ_STK_CLOSE_VAL,"Previous Months Closing Stock Value",8,8,0,0 WIZ_STK_CODE,"Stock Wizard Stock Code",12,8,0,0 WIZ_STK_DATE,"Last Stock Posting Date",9,2,0,0 WIZ_VAT_AMOUNT,"VAT Return Amount",8,8,0,0 WIZ_VAT_CODE,"VAT Code",12,8,0,0 WIZ_VAT_DATE,"Last VAT Return Date",9,2,0,0 WIZ_VAT_DATE_FROM,"Last VAT Return From Date",9,2,0,0 WIZ_VAT_DATE_TO,"Last VAT Return To Date",9,2,0,0 WIZ_VAT_PUR_AMOUNT,"Vat Return VAT on Purchase Amount",8,8,0,0 WIZ_VAT_SAL_AMOUNT,"Vat Return VAT on Sales Amount",8,8,0,0 WWW,"Company WWW Address",12,255,0,0