03333 445950
03333 calls are same cost
 |  |  |
Making It Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Native Tables
Native Table -
BILLDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Account Reference",12,8,0,0 BILL_DATE,"Date of Bill",9,2,0,0 DATE_PAID,"Date Bill Paid",9,2,0,0 DETAILS,"Account Details",12,60,0,0 NET_AMOUNT,"Net Amount",8,8,0,2 NET_PAID,"Nat Amount Paid",8,8,0,2 PAY_BY_DATE,"Date Bill to be Paid By",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 REFERENCE,"Reference",12,8,0,0 TAX_AMOUNT,"Tax Amount",8,8,0,2 TAX_CODE,"Tax Code",5,2,0,0 TAX_PAID,"Tax Amount Paid",8,8,0,2