Accounts Table Formats (CA)

Follow Vision specifications for preparing a file containing account data.

Field Name Data Type Length Notes

Account

varchar 13 Account number; primary key

Name

varchar 40 Account name

CashBasisAccount

varchar 13 Cash-basis account number

FASAccount

varchar 255 Account number for the Best Fixed Assets Interface utility

Status

varchar 1 Account's status; valid options are A (Active), I (Inactive), or D (Dormant); required field; must exist in CFGAccountStatus (Status/Label)

Detail

smallint 2 Variable indicating how detail appears on the General Ledger Account Analysis; valid options are Show Detail, No Detail, or Summarized

GlobalAccount

varchar 1 Flag indicating whether or not the account is available to all companies only to designated companies in Chart of Accounts company mapping; valid options are Y (Yes) or N (No)

AccountCurrencyCode

varchar 3

The account's currency code, which is required for any account associated with bank codes, and optional otherwise; when used, it limits to that currency all transactions posted to the account.

For accounts associated with bank codes, it ensures that all transactions against the bank code are in the bank's account currency.

CustomCurrencyCode

varchar 3 Currency of any custom fields in the Chart of Accounts