FAS Depreciation Entry Table Formats (DEDeprec)
Follow DPS 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 feature only. CurrencyCode must exist in CFGEnabledCurrencies table. |
TaxCodeSequence1 through TaxCodeSequence10 | varchar | DPS 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 feature 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. |