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.