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 -
SPLITDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces AMOUNT_PAID,"Total amount paid",8,8,0,2 BANK_FLAG,"Bank reconciled flag",-6,1,0,0 DATE,"Date",9,2,1,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 DEPT_NUMBER,"Department number",5,2,0,0 DETAILS,"Details",12,60,0,0 DISPUTE_TYPE,"Dispute Type",5,2,0,0 DOCTOR_LINK,"Pointer to Fix by Doctor",4,4,0,0 FIRST_USAGE,"",4,4,0,0 FOREIGN_AMOUNT_PAID,"Foreign Total amount paid",8,8,0,2 FOREIGN_NET_AMOUNT,"Foreign Net amount",8,8,0,2 FOREIGN_TAX_AMOUNT,"Foreign Tax amount",8,8,0,2 FUND_NUMBER,"Fund number",4,4,0,0 GASDS_CLAIM_SUBMITTED,"GASDS Claim Submitted",5,2,0,0 GIFT_AID,"Gift Aid status",5,2,0,0 HAS_EXTERNAL_LINK,"Has External Link",5,2,0,0 HEADER_NUMBER,"Header number",4,4,0,0 INTERNAL_REF,"Ex Ref",12,60,0,0 LAST_USAGE,"",4,4,0,0 NET_AMOUNT,"Net amount",8,8,0,2 NEXT_NOMINAL,"",4,4,0,0 NEXT_SPLIT,"Next split",4,4,0,0 NO_OF_USAGE,"No of usage",4,4,0,0 NOMINAL_CODE,"Nominal Code",12,8,1,0 PAID_FLAG,"Paid flag",-6,1,0,0 POSTED_DATE,"posting date",9,2,1,0 PREV_NOMINAL,"",4,4,0,0 PREV_SPLIT,"Prev Split",4,4,0,0 PROJECT_ID,"Project ID",5,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 SMALL_DONATION,"Small Donations",5,2,0,0 STATUS,"Status Flag",5,2,0,0 TAX_AMOUNT,"Tax amount",8,8,0,2 TAX_CODE,"Tax code (0-99)",5,2,1,0 TRAN_NUMBER,"Transaction number",4,4,0,0 TYPE,"Transaction type",-6,1,1,0 UNIQUE_REF,"Unique reference",4,4,0,0 USER_NAME,"User name",12,32,0,0 VAT_FLAG,"Vat reconciled flag",-6,1,0,0 VAT_RECONCILED_DATE,"VAT Reconciled Date",9,2,1,0 VAT_RETURN_ID,"VAT Return ID",4,4,0,0