Importing Custom Depreciation Codes

The following tables define the field references to be used in the Depreciation Codes section of the MasterFA.DEF file:

Header

Table: tblFADeprCode
Context Section: CONTEXT,FADEPR,HEADER,HDEPRCODE
Field ID Req'd Field Length Default Value Notes

DEPR_CODEID

Y

User Defined

 

Custom Depreciation Code

DEPR_STATUS

Y

1

A

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

DEPR_DESCRIP

Y

User Defined

 

Code Description

DEPR_METHOD

Y

2

FA

FA, PD, PN, TD, or TN. See Table 3.

DEPR_FAMOUNT

Y

Currency

0.00

Required for FA. See Table 3.

DEPR_PERCENT

Y

Percent

000.0000

Required for PD or PN. Enter 5% as 05 or 5. See Table 3.

Detail

Table: tblFADeprCodeDetail
Context Section: CONTEXT,FADEPR,DETAIL,DDEPRCODE
Field ID Req'd Field Length Default Value Notes

DEPR_DET_YEAR

Y

Integer

 

Number of years into depreciation; not calendar year. Required for TN or TD.

DEPR_DET_PERC

Y

Percent

000.0000

Required for TN or TD. Enter 5% as 05 or 5.

DEPR_DET_NOTE

N

30

 

Notes