Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Journal Entry Data Entry Table Formats (DEJournalEntry)

Follow Vantagepoint 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, Vantagepoint 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 feature only. CurrencyCode must exist in CFGEnabledCurrencies table.
TaxCodeSequence1 through TaxCodeSequence10 varchar Vantagepoint validates that the tax codes have an active status and the tax type matches the selected tax code.
TaxDebitAmountSequence1 through TaxDebitxAmountSequence10 decimal
TaxCreditAmountSequence1 through TaxCreditAmountSequence10 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.