FAS Depreciation Entry Table Formats (DEDeprec)
Follow Vision specifications for preparing a file containing FAS depreciation entries.
| Field Name | Data Type | Notes |
|---|---|---|
|
Account |
varchar | |
|
TransDate |
datetime | |
|
MasterDescription |
varchar | |
|
FASPeriod |
datetime | |
|
RefNo |
varchar | |
|
DetailDescription |
varchar | |
|
LinkFile |
varchar | |
|
Amount |
decimal | |
|
EntryType |
varchar | |
|
WBS1 |
varchar | |
|
WBS2 |
varchar | |
|
WBS3 |
varchar | |
|
PostType |
varchar | |
|
TaxCode |
varchar | |
|
TaxType |
varchar | |
|
CurrencyCode |
varchar | Multicurrency only. CurrencyCode must exist in CFGEnabledCurrencies table. |
|
TaxCodeSequence1 through TaxCodeSequence10 |
varchar | Vision validates that the tax codes have an active status and the tax type matches the selected tax code. |
|
TaxAmountSequence1 through TaxAmountSequence10 |
decimal | |
|
LinkCompany |
varchar | Multicompany only. This is the due to/from company. The import program determines whether it is required. If it is required but is blank in the import file, an error message is returned. |
