BALANCE SHEET ACCOUNT Table
View exposing balance sheet account reference data including account identifiers, account names, grouping attributes, and reporting classifications used for financial reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
10 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
13,2 |
COMPANY_CODE |
Company code associated with the record. |
VARCHAR2 |
4 |
COST_COLLECTOR_ID |
Cost collector id associated with the record. |
VARCHAR2 |
7 |
COST_COLLECTOR_KEY |
Cost collector key associated with the record. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Cost collector name associated with the record. |
VARCHAR2 |
60 |
COST_COLLECTOR_TYPE_CODE |
Cost collector type code associated with the record. |
VARCHAR2 |
2 |
COST_COLLECTOR_TYPE_DESC |
Cost collector type desc associated with the record. |
VARCHAR2 |
20 |
EFFECTIVE_DATE |
Effective date associated with the record. |
DATE |
|
EXPIRATION_DATE |
Expiration date associated with the record. |
DATE |
|
FS_CODE |
Fs code associated with the record. |
VARCHAR2 |
1 |
FUND_CENTER_ID |
Fund center id associated with the record. |
VARCHAR2 |
6 |
FUND_ID |
Fund id associated with the record. |
VARCHAR2 |
7 |
IS_CLOSED |
Is closed associated with the record. |
VARCHAR2 |
1 |
ORGANIZATION_ID |
Organization id associated with the record. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
POOL_CODE |
Pool code associated with the record. |
VARCHAR2 |
1 |
POOL_UNITS |
Pool units associated with the record. |
NUMBER |
10,4 |
PROFIT_CENTER_ID |
Profit center id associated with the record. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Profit center key associated with the record. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
SECTION_CODE |
Section code associated with the record. |
VARCHAR2 |
3 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
60 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SUPERVISOR_ROOM |
Supervisor room associated with the record. |
VARCHAR2 |
10 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
1 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |