Fields - AcctBalance
Fields
| Field Name | Data Type | Description, Example |
|---|---|---|
| Cmf | string | dealer number |
| DealerId | string | Internal Dealer Identifier (intentionally left blank) |
| AcctCode (key) | string | Account Code |
| DeptCode (key) | string | Department Code |
| FiscalYear (key) | short | Year record is report on |
| BeginningBalance | decimal | Account balance at beginning of fiscal year |
| Month1 | decimal | Ending balance at end of month 1 of fiscal year |
| Month2 | decimal | Ending balance at end of month 2 of fiscal year |
| Month3 | decimal | Ending balance at end of month 3 of fiscal year |
| Month4 | decimal | Ending balance at end of month 4 of fiscal year |
| Month5 | decimal | Ending balance at end of month 5 of fiscal year |
| Month6 | decimal | Ending balance at end of month 6 of fiscal year |
| Month7 | decimal | Ending balance at end of month 7 of fiscal year |
| Month8 | decimal | Ending balance at end of month 8 of fiscal year |
| Month9 | decimal | Ending balance at end of month 9 of fiscal year |
| Month10 | decimal | Ending balance at end of month 10 of fiscal year |
| Month11 | decimal | Ending balance at end of month 11 of fiscal year |
| Month12 | decimal | Ending balance at end of month 12 of fiscal year |
| accountdepartment | string | Account dept number |
| glaccounttype | string | Type of GL account |
| accountingid | long | ID of accounting database |
| acctdeptid | long | Account department Id |
| active | bool | Status of GL account |
| consolidationind | string | Indicates GL account consolidates into another account |
| debitcredit | string | Indicates account is debit or credit |
| acctdesc | string | Description of account |
| headerdetailtotalcons | string | Indicates the account type |
| profitbalance | string | Indicates whether profit or balance |
| schedule | string | Indicates which scheduled account record is associated with |
| sequencenumber | int | Sequence account appears in PL statement |
| deptname | string | Name of account department |
| consacctdept | string | Consolidated account number |
It is suggested to utilize a filter against FiscalYear.
Notes
Note: For shared accounting, combine beginning balance with fiscal year and dept code to receive shared beginning balance.