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 -
NOMINALDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ACCOUNT_REF,"Account Code",12,8,1,0 ACCOUNT_TYPE,"Account Type Code",-6,1,0,0 AUDIT_REF,"Incomplete records reference",12,20,0,0 BALANCE,"Balance",8,8,0,2 BALANCE_BF,"Balance Brought forward",8,8,0,2 BALANCE_FUTURE,"Balance for Future",8,8,0,2 BALANCE_MTH1,"Balance Month 1",8,8,0,2 BALANCE_MTH10,"Balance Month 10",8,8,0,2 BALANCE_MTH11,"Balance Month 11",8,8,0,2 BALANCE_MTH12,"Balance Month 12",8,8,0,2 BALANCE_MTH2,"Balance Month 2",8,8,0,2 BALANCE_MTH3,"Balance Month 3",8,8,0,2 BALANCE_MTH4,"Balance Month 4",8,8,0,2 BALANCE_MTH5,"Balance Month 5",8,8,0,2 BALANCE_MTH6,"Balance Month 6",8,8,0,2 BALANCE_MTH7,"Balance Month 7",8,8,0,2 BALANCE_MTH8,"Balance Month 8",8,8,0,2 BALANCE_MTH9,"Balance Month 9",8,8,0,2 BUDGET_MTH1,"Budget Month 1",8,8,0,2 BUDGET_MTH10,"Budget Month 10",8,8,0,2 BUDGET_MTH11,"Budget Month 11",8,8,0,2 BUDGET_MTH12,"Budget Month 12",8,8,0,2 BUDGET_MTH2,"Budget Month 2",8,8,0,2 BUDGET_MTH3,"Budget Month 3",8,8,0,2 BUDGET_MTH4,"Budget Month 4",8,8,0,2 BUDGET_MTH5,"Budget Month 5",8,8,0,2 BUDGET_MTH6,"Budget Month 6",8,8,0,2 BUDGET_MTH7,"Budget Month 7",8,8,0,2 BUDGET_MTH8,"Budget Month 8",8,8,0,2 BUDGET_MTH9,"Budget Month 9",8,8,0,2 CREDIT_BF,"Credit Brought Forward",8,8,0,2 CREDIT_FUTURE,"Credit for Future",8,8,0,2 CREDIT_MTH1,"Credit Month 1",8,8,0,2 CREDIT_MTH10,"Credit Month 10",8,8,0,2 CREDIT_MTH11,"Credit Month 11",8,8,0,2 CREDIT_MTH12,"Credit Month 12",8,8,0,2 CREDIT_MTH2,"Credit Month 2",8,8,0,2 CREDIT_MTH3,"Credit Month 3",8,8,0,2 CREDIT_MTH4,"Credit Month 4",8,8,0,2 CREDIT_MTH5,"Credit Month 5",8,8,0,2 CREDIT_MTH6,"Credit Month 6",8,8,0,2 CREDIT_MTH7,"Credit Month 7",8,8,0,2 CREDIT_MTH8,"Credit Month 8",8,8,0,2 CREDIT_MTH9,"Credit Month 9",8,8,0,2 DEBIT_BF,"Debit Brought Forward",8,8,0,2 DEBIT_FUTURE,"Debit for Future",8,8,0,2 DEBIT_MTH1,"Debit Month 1",8,8,0,2 DEBIT_MTH10,"Debit Month 10",8,8,0,2 DEBIT_MTH11,"Debit Month 11",8,8,0,2 DEBIT_MTH12,"Debit Month 12",8,8,0,2 DEBIT_MTH2,"Debit Month 2",8,8,0,2 DEBIT_MTH3,"Debit Month 3",8,8,0,2 DEBIT_MTH4,"Debit Month 4",8,8,0,2 DEBIT_MTH5,"Debit Month 5",8,8,0,2 DEBIT_MTH6,"Debit Month 6",8,8,0,2 DEBIT_MTH7,"Debit Month 7",8,8,0,2 DEBIT_MTH8,"Debit Month 8",8,8,0,2 DEBIT_MTH9,"Debit Month 9",8,8,0,2 DELETED_FLAG,"Is Deleted",5,2,0,0 EXTERNAL_USAGE,"Number of External Usages",4,4,0,0 FIRST_SPLIT,"First",4,4,0,0 INACTIVE_FLAG,"Inactive Flag - Yes/No",4,4,0,0 LAST_SPLIT,"Last",4,4,0,0 NAME,"Name",12,60,0,0 NO_OF_SPLIT,"No of splits",4,4,0,0 PRIOR_YR2_MTH1,"Prior Year 2 Month 1",8,8,0,2 PRIOR_YR2_MTH10,"Prior Year 2 Month 10",8,8,0,2 PRIOR_YR2_MTH11,"Prior Year 2 Month 11",8,8,0,2 PRIOR_YR2_MTH12,"Prior Year 2 Month 12",8,8,0,2 PRIOR_YR2_MTH2,"Prior Year 2 Month 2",8,8,0,2 PRIOR_YR2_MTH3,"Prior Year 2 Month 3",8,8,0,2 PRIOR_YR2_MTH4,"Prior Year 2 Month 4",8,8,0,2 PRIOR_YR2_MTH5,"Prior Year 2 Month 5",8,8,0,2 PRIOR_YR2_MTH6,"Prior Year 2 Month 6",8,8,0,2 PRIOR_YR2_MTH7,"Prior Year 2 Month 7",8,8,0,2 PRIOR_YR2_MTH8,"Prior Year 2 Month 8",8,8,0,2 PRIOR_YR2_MTH9,"Prior Year 2 Month 9",8,8,0,2 PRIOR_YR3_MTH1,"Prior Year 3 Month 1",8,8,0,2 PRIOR_YR3_MTH10,"Prior Year 3 Month 10",8,8,0,2 PRIOR_YR3_MTH11,"Prior Year 3 Month 11",8,8,0,2 PRIOR_YR3_MTH12,"Prior Year 3 Month 12",8,8,0,2 PRIOR_YR3_MTH2,"Prior Year 3 Month 2",8,8,0,2 PRIOR_YR3_MTH3,"Prior Year 3 Month 3",8,8,0,2 PRIOR_YR3_MTH4,"Prior Year 3 Month 4",8,8,0,2 PRIOR_YR3_MTH5,"Prior Year 3 Month 5",8,8,0,2 PRIOR_YR3_MTH6,"Prior Year 3 Month 6",8,8,0,2 PRIOR_YR3_MTH7,"Prior Year 3 Month 7",8,8,0,2 PRIOR_YR3_MTH8,"Prior Year 3 Month 8",8,8,0,2 PRIOR_YR3_MTH9,"Prior Year 3 Month 9",8,8,0,2 PRIOR_YR4_MTH1,"Prior Year 4 Month 1",8,8,0,2 PRIOR_YR4_MTH10,"Prior Year 4 Month 10",8,8,0,2 PRIOR_YR4_MTH11,"Prior Year 4 Month 11",8,8,0,2 PRIOR_YR4_MTH12,"Prior Year 4 Month 12",8,8,0,2 PRIOR_YR4_MTH2,"Prior Year 4 Month 2",8,8,0,2 PRIOR_YR4_MTH3,"Prior Year 4 Month 3",8,8,0,2 PRIOR_YR4_MTH4,"Prior Year 4 Month 4",8,8,0,2 PRIOR_YR4_MTH5,"Prior Year 4 Month 5",8,8,0,2 PRIOR_YR4_MTH6,"Prior Year 4 Month 6",8,8,0,2 PRIOR_YR4_MTH7,"Prior Year 4 Month 7",8,8,0,2 PRIOR_YR4_MTH8,"Prior Year 4 Month 8",8,8,0,2 PRIOR_YR4_MTH9,"Prior Year 4 Month 9",8,8,0,2 PRIOR_YR5_MTH1,"Prior Year 5 Month 1",8,8,0,2 PRIOR_YR5_MTH10,"Prior Year 5 Month 10",8,8,0,2 PRIOR_YR5_MTH11,"Prior Year 5 Month 11",8,8,0,2 PRIOR_YR5_MTH12,"Prior Year 5 Month 12",8,8,0,2 PRIOR_YR5_MTH2,"Prior Year 5 Month 2",8,8,0,2 PRIOR_YR5_MTH3,"Prior Year 5 Month 3",8,8,0,2 PRIOR_YR5_MTH4,"Prior Year 5 Month 4",8,8,0,2 PRIOR_YR5_MTH5,"Prior Year 5 Month 5",8,8,0,2 PRIOR_YR5_MTH6,"Prior Year 5 Month 6",8,8,0,2 PRIOR_YR5_MTH7,"Prior Year 5 Month 7",8,8,0,2 PRIOR_YR5_MTH8,"Prior Year 5 Month 8",8,8,0,2 PRIOR_YR5_MTH9,"Prior Year 5 Month 9",8,8,0,2 PRIOR_YR_MTH1,"Prior Year 1 Month 1",8,8,0,2 PRIOR_YR_MTH10,"Prior Year 1 Month 10",8,8,0,2 PRIOR_YR_MTH11,"Prior Year 1 Month 11",8,8,0,2 PRIOR_YR_MTH12,"Prior Year 1 Month 12",8,8,0,2 PRIOR_YR_MTH2,"Prior Year 1 Month 2",8,8,0,2 PRIOR_YR_MTH3,"Prior Year 1 Month 3",8,8,0,2 PRIOR_YR_MTH4,"Prior Year 1 Month 4",8,8,0,2 PRIOR_YR_MTH5,"Prior Year 1 Month 5",8,8,0,2 PRIOR_YR_MTH6,"Prior Year 1 Month 6",8,8,0,2 PRIOR_YR_MTH7,"Prior Year 1 Month 7",8,8,0,2 PRIOR_YR_MTH8,"Prior Year 1 Month 8",8,8,0,2 PRIOR_YR_MTH9,"Prior Year 1 Month 9",8,8,0,2 QUICK_RATIO_FLAG,"Quick ratio account flag",-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