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 -
BANKHEADERDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Sales/Purchase/Bank Account Reference",12,8,1,0 AMOUNT_PAID,"Total amount paid",8,8,0,2 BANK_CHARGE_ACCOUNT,"Bank Charge Customer/Supplier Ref",12,8,0,0 BANK_CHARGE_IS_CUSTOMER,"Is Bank Charge Customer or Supplier",5,2,0,0 BANK_CODE,"Bank Account Reference",12,8,1,0 BANK_FEEDS_MATCHED,"Bank Feeds Matched",-6,1,0,0 BANK_FLAG,"Bank reconciled flag",-6,1,0,0 BANK_RECONCILIATION_ID,"Bank reconciliation ID that this transaciton is part of",4,4,0,0 CURRENCY,"Currency for Transaction",-6,1,0,0 CURRENCY_USED,"Currency Used",-6,1,0,0 DATE,"Transaction date",9,2,1,0 DATE_AMENDED,"User who last amended this transaction",12,32,0,0 DATE_DUE,"Date Invoice is Due for Payment",9,2,0,0 DATE_FORECAST,"Forecast Date",9,2,0,0 DATE_LAST_CHARGE,"Date Interest Last Charged",9,2,0,0 DELETED_FLAG,"Transaction deleted flag",5,2,0,0 DEPOSIT_DATE,"Bank deposited date",9,2,0,0 DEPOSIT_FLAG,"Bank deposited flag",-6,1,0,0 DETAILS,"Details",12,60,0,0 ELEC_TRANS,"Electronic Transaction Flag",5,2,0,0 EURO_GROSS,"euro Gross Amount",8,8,1,6 EURO_RATE,"euro Rate",8,8,1,6 FINANCE_CHARGE,"Finance Charge Flag",-6,1,0,0 FIRST_SPLIT,"Item number",4,4,0,0 FORECAST_INCLUDE,"Included in Forecast",9,2,0,0 FOREIGN_AMOUNT_PAID,"Foreign Total amount paid",8,8,0,2 FOREIGN_GROSS,"Foreign Gross Amount",8,8,1,6 FOREIGN_NET_AMOUNT,"Foreign Net amount",8,8,0,2 FOREIGN_RATE,"Foreign Rate for euro currency",8,8,1,6 FOREIGN_TAX_AMOUNT,"Foreign Tax amount",8,8,0,2 INTEREST_RATE,"Interest Rate to Charge",8,8,1,2 INV_REF,"Invoice Reference Number",12,30,0,0 ISP_REFERENCE,"Inv/Sop/Pop Reference",4,4,0,0 JOB_REFERENCE,"Job Costing Reference",12,60,0,0 LAST_SPLIT,"Item number",4,4,0,0 NET_AMOUNT,"Net amount",8,8,1,2 NEXT_ACCOUNT,"Item number",4,4,0,0 NEXT_BANK,"Item number",4,4,0,0 NO_DISPUTED,"Number of Disputed Splits",5,2,0,0 NO_OF_SPLIT,"Item number",4,4,0,0 OPENING_BALANCE_TRANS,"Is Transaction an Opening Balance",5,2,0,0 ORIGINATOR_ID,"Guid of the originating Overdrive transaction (For Internal Use Only)",12,37,0,0 OVERRIDDEN_CLOSED_LEDGER_DATE,"The closed ledger date that was overridden at the time of posting",9,2,0,0 PAID_FLAG,"Transaction paid flag - y/n",-6,1,0,0 POSTED_DATE,"posting date",9,2,0,0 POSTING_LOCATION,"Location Transaction Posted From",5,2,0,0 PRACTICE_SOLUTIONS_REFN,"Sage Practice Solutions Reference",12,60,0,0 PREV_ACCOUNT,"Item number",4,4,0,0 PREV_BANK,"Item number",4,4,0,0 PRINTED_FLAG,"Printed Flag",-6,1,0,0 PROTX_REFN,"Sage Pay Reference",12,63,0,0 RECON_DATE,"Bank reconciled date",9,2,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 REVALUATION_TRANS,"Is Transaction a Revaluation Transaction",5,2,0,0 SETT_DISCOUNT_RATE,"Settlement Discount Rate",8,8,0,2 TAX_AMOUNT,"Tax amount",8,8,0,2 TYPE,"Transaction type",-6,1,1,0 UNIQUE_REF,"Header number",4,4,0,0 USER_NAME,"User name ",12,32,0,0 USER_NAME_AMENDED,"Date this transaction was last amended",9,2,0,0 VAT_FLAG,"VAT Flag",-6,1,0,0