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 -
BANKDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_NAME,"Bank account name",12,60,0,0 ACCOUNT_NUMBER,"Bank account number",12,60,0,0 ACCOUNT_REF,"Account reference",12,8,1,0 ACCOUNT_TYPE,"Account type",-6,1,0,0 ADDRESS_1,"Address line 1",12,60,0,0 ADDRESS_2,"Address line 2",12,60,0,0 ADDRESS_3,"Address line 3",12,60,0,0 ADDRESS_4,"Address line 4",12,60,0,0 ADDRESS_5,"Address line 5",12,60,0,0 BACS_REFERENCE,"Bank BACS Ref",12,60,0,0 BANK_BICSWIFT,"Bank BIC/Swift Number",12,60,0,0 BANK_CHARGES_DEFAULT_BANK_REF,"The default bank account for bank charges",12,8,0,0 BANK_CHARGES_DEFAULT_DEPARTMENT,"The default department for bank charges",5,2,0,0 BANK_CHARGES_DEFAULT_NOMINAL_CODE,"The default nominal code for bank charges",12,8,0,0 BANK_CHARGES_DEFAULT_TAX_CODE,"The default tax code for bank charges",5,2,0,0 BANK_FEEDS_ACCESS_TO_ACCOUNTANT_GRANTED,"Access To Accountant Granted",-6,2,0,0 BANK_FEEDS_ACCOUNT_ID,"Bank Feeds Bank Account ID",12,37,0,0 BANK_FEEDS_ENABLED,"Bank Feeds Enabled",5,4,0,0 BANK_FEEDS_LAST_TRAN_ID,"Bank Last Transaction ID",4,4,0,0 BANK_FEEDS_PROVIDER_TYPE,"Bank Feeds Provider Type",5,2,0,0 BANK_FEEDS_TRANSACTIONS_ARE_RECONCILED,"Bank Transactions Are Posted Reconciled",-6,2,0,0 BANK_IBAN,"Bank IBAN Number",12,60,0,0 BANK_REF,"Bank Reference Number",5,2,0,0 CONTACT_NAME,"Bank Contact Name",12,30,0,0 CURRENCY,"Currency code",-6,1,0,0 DELETED_FLAG,"Is Deleted",5,2,0,0 E_MAIL,"Bank EMail Address",12,255,0,0 ELEC_TRANS,"Bank Accepts Electronic Transactions",5,2,0,0 EXPIRY_DATE,"Card expiry date",9,2,0,0 EXTERNAL_USAGE,"Number of External Usages",4,4,0,0 FAX,"Bank Fax Number",12,30,0,0 FIRST_SPLIT,"First tran",4,4,0,0 FOREIGN_BALANCE,"Foreign Balance",8,8,0,2 INACTIVE_FLAG,"Inactive Flag - Yes/No",4,4,0,0 LAST_REC_BALANCE,"Balance at last reconciliation",8,8,0,2 LAST_REC_DATE,"Date of last reconciliation",9,2,0,0 LAST_SPLIT,"Last tran",4,4,0,0 NAME,"Name",12,60,0,0 NEXT_CHQ_NO,"Next chq number",12,10,0,0 NEXT_DEP_NO,"Deposit No",12,6,0,0 NEXT_WITHDRAWAL_NO,"Withdrawal No",12,6,0,0 NO_OF_SPLIT,"No of splits",4,4,0,0 NO_OF_TRAN,"No of trans",4,4,0,0 NO_OF_UNRECONCILED_ITEMS,"No of unreconciled items",4,4,0,0 NO_RECONCILIATION_FLAG,"Ignore reconciliation",-6,1,0,0 OVERDRAFT_LIMIT,"Overdraft limit",8,8,0,2 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 SORT_CODE,"Bank sort code",12,10,0,0 TELEPHONE,"Bank Telephone Number",12,30,0,0 WWW,"Bank Web Site",12,255,0,0