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.