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 |
PROFIT_CENTER_KEY |
Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
11 |
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 |