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 |