Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
ASSET_REF*
|
Fixed asset reference
|
10
|
String
|
8
|
DETAILS_1
|
Details 1
|
10
|
String
|
60
|
DETAILS_2
|
Details 2
|
10
|
String
|
60
|
DETAILS_3
|
Details 3
|
10
|
String
|
60
|
EMPLOYEE
|
Employee
|
10
|
String
|
2009
|
SERIAL_NUMBER
|
Serial number
|
10
|
String
|
60
|
PURCHASE_REF
|
Purchase reference number
|
10
|
String
|
8
|
BAL_SHEET_NOM_CODE
|
Balance sheet nominal code
|
10
|
String
|
8
|
PROFIT_LOSS_NOM_CODE
|
Profit and Loss nominal code
|
10
|
String
|
8
|
DEP_METHOD_CODE
|
Depreciation method code (1-3)
|
10
|
Int32
|
2
|
DEP_METHOD
|
Depreciation method
|
10
|
String
|
60
|
DEP_RATE
|
Depreciation rate
|
10
|
Double
|
8
|
DEPT_NUMBER
|
Department number
|
10
|
Int32
|
2
|
DEPT_NAME
|
Department name
|
10
|
String
|
60
|
ASSET_CAT
|
Category number
|
10
|
Int32
|
2
|
PURCHASE_DATE
|
Date of purchase
|
10
|
Date
|
2
|
COST_PRICE
|
Cost price
|
10
|
Double
|
8
|
DEP_LAST
|
Amount of last depreciation
|
10
|
Double
|
8
|
DEP_NEXT
|
Amount of next depreciation
|
10
|
Double
|
8
|
DEP_TO_DATE
|
Amount depreciated to date
|
10
|
Double
|
8
|
NET_BOOK
|
Net book value
|
10
|
Double
|
8
|
RECORD_CREATE_DATE
|
Date and time when the record was created.
|
2009
|
Date
|
8
|
RECORD_MODIFY_DATE
|
Date and time when the record was modified.
|
2009
|
Date
|
8
|
RECORD_DELETED
|
Flag denoting if the record has been deleted or not.
|
2009
|
Boolean
|
2
|