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 -
RECURRINGDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACTUAL_POSTINGS,"Actual Postings to date",5,2,0,0 BANK_CODE,"Bank account reference",12,8,1,0 CUSTOMER,"Customer associated with this donation",12,8,0,0 DATE_NEXT_POSTING,"Next posting date",9,2,0,0 DAY_POSTED,"",5,2,0,0 DEPARTMENT,"",5,2,0,0 DETAILS,"Details",12,60,0,0 FREQUENCY,"",5,2,0,0 FREQUENCY_TYPE,"Frequency Type",5,2,0,0 FUND,"Fund to post against",4,4,0,0 NET_AMOUNT,"Net amount",8,8,1,0 NOMINAL_CODE,"Nominal code",12,8,1,0 POSTED_THIS_MONTH,"Transaction on hold",-6,1,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 REFERENCE,"Transaction reference",12,30,0,0 REQUIRED_POSTINGS,"Required Postings",5,2,0,0 START_DATE,"Next posting date",9,2,0,0 TAX_AMOUNT,"Tax amount",8,8,0,0 TAX_CODE,"",5,2,1,0 TYPE,"Transaction type",-6,1,1,0