General Ledger Account Balances Table Formats (AccountBalance)
Follow Vision specifications for preparing a file containing general ledger account balances.
Field Name | Data Type | Length | Notes |
---|---|---|---|
Org |
varchar | ||
Account |
varchar | Required. The account number to which this balance applies. This number must be a valid account in Vision. | |
Period |
integer | Required. The period to which this balance applies. The period must be prior or equal to the active period. The default for balance sheet accounts is 0. The default for other account types is 0. The format for this field is YYYYPP, which YYYY is the four-digit year (2003) and PP is the two-digit period (01). | |
TransDate |
datetime | Required. The transaction date. | |
RefNo |
varchar | Required. The reference number for expense detail purposes. The default for this field is History. | |
Description |
varchar | Optional. The description for the expense detail table. | |
AccrualDebit |
decimal | Optional. The debit amount for this account. | |
AccrualCredit |
decimal | Optional. The credit amount for this account. | |
CashDebit |
decimal | Optional. The cash-basis debit amount for this account. | |
CashCredit |
decimal | Optional. The cash-basis credit amount for this account. | |
AccountCurrencyDebit |
decimal | 9 | Multicurrency only. |
AccountCurrencyCredit |
decimal | 9 | Multicurrency only. |
LinkCompany |
varchar | 14 | Multicurrency only. LinkCompany is required only when Account is CFGAutoPosting.AcctsReceivableIntercompany, CFGAutoPosting.AcctsPayableIntercompany, or CFGAutoPosting.SuspenseIntercompany. LinkCompany has to be the company code other than active company. LinkCompany is ignored when the account is not one of the intercompany accounts. |