Importing Asset Types

The following table defines the field references used in the Asset Types section of the MasterFA.DEF file:

Table: tblFAType
Context Section: CONTEXT,FATYPE,HEADER,HASSETTYPE
Field ID Req'd Field Length Default Value Notes

FATM_TYPEID

Y

User Defined

 

Asset Type ID

FATM_STATUS

Y

1

 

A (Active), I (Inactive), or D (Discontinued)

FATM_DESCRIP

Y

User Defined

 

Asset Type Description

FATM_DEPRCODE

Y

User Defined

 

Depreciation Methods: SL, SYD, DB150, DB200, No, or <Unique Custom Code>. See Table 4.

FATM_SW_DEPRCODE

N

User Defined

 

Switch Depreciation Code (SL). Not valid if FATM_DEPRCODE is SL. See Table 4.

FATM_DISTCODE

Y

User Defined

 

Default Distribution Code

FATM_EXPCODE

Y

User Defined

 

Default GL Depreciation Expense Type Account. Must be set up using Maintain>Chart of Accounts Codes.

FATM_ADCODE

Y

User Defined

 

Default Accumulated Depreciation GL—FAO-Type Account. Must be set up using Maintain>Chart of Accounts Codes.

FATM_ASSETCODE

Y

User Defined

 

Default Asset GL—FAO-Type Account. Must be set up using Maintain>Chart of Accounts Codes.