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 -
ASSETDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ASSET_CAT,"Category number",5,2,0,0 ASSET_REF,"Fixed asset reference",12,8,1,0 BAL_SHEET_NOM_CODE,"Balance sheet nominal code",12,8,1,0 COST_PRICE,"Cost price",8,8,0,2 DEP_LAST,"Amount of last depreciation",8,8,0,2 DEP_METHOD_CODE,"Depreciation method code (1-3)",5,2,0,0 DEP_RATE,"Depreciation rate",8,8,0,2 DEP_TO_DATE,"Amount depreciated to date",8,8,0,2 DEPT_NUMBER,"Department number",5,2,0,0 DETAILS_1,"Details 1",12,60,0,0 DETAILS_2,"Details 2",12,60,0,0 DETAILS_3,"Details 3",12,60,0,0 EMPLOYEE,"Employee",12,15,0,0 NET_BOOK,"Net book value",8,8,0,2 NEXT_ASSET,"",4,4,0,0 POST_DATE,"",9,2,0,0 PREV_ASSET,"",4,4,0,0 PROFIT_LOSS_NOM_CODE,"Profit and Loss nominal code",12,8,1,0 PURCHASE_DATE,"Date of purchase",9,2,0,0 PURCHASE_REF,"Purchase reference number",12,8,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 SERIAL_NUMBER,"Serial number",12,60,0,0