|
| |
Related Links: |
|---|---|
| |
BALANCE SHEET ACCOUNT ALL Table
All balance sheet accounts: Cost Collectors and pure GL Accounts
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BALANCE_SHEET_ACCOUNT_ID |
XXX |
VARCHAR2 |
7 |
BALANCE_SHEET_ACCOUNT_KEY |
Key used to join the Balance Sheet Balances or the Balance Sheet Balances by Fiscal Period tables to other tables, NOT for reporting. |
VARCHAR2 |
12 |
BALANCE_SHEET_ACCOUNT_NAME |
XXX |
VARCHAR2 |
50 |
BALANCE_SHEET_ACCOUNT_TYPE |
XXX |
VARCHAR2 |
20 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
SECTION_CODE |
A code which classifies cost collectors into sections for financial statement reporting purposes |
VARCHAR2 |
3 |
SECTION_NAME |
Description associated with the Section Code. |
VARCHAR2 |
60 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
