Journal Entry Data Entry Table Formats (DEJournalEntry)
Follow Vision specifications for preparing a file containing journal entry data.
Field Name | Data Type | Notes |
---|---|---|
RefNo |
varchar | |
TransDate |
datetime | If you do not specify a transaction date in the import file, Vision assigns the date of the import as the transaction date. |
MasterDescription |
varchar | |
PostType |
varchar | |
WBS1 |
varchar | |
WBS2 |
varchar | |
WBS3 |
varchar | |
Account |
varchar | |
DebitAmount |
decimal | |
CreditAmount |
decimal | |
DetailDescription |
varchar | |
TaxType |
varchar | |
UpdateBilled |
varchar | Allows you to import the data if you selected the Update project billing amount when adjusting revenue option on the Journal Entry form. |
SuppressBill |
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. |