SING PROFIT CENTER Table
View exposing Singapore profit center reference records including identifiers and organizational hierarchy attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_INACTIVE_PROFIT_CENTER |
Indicator identifying whether inactive profit center (Y/N). |
VARCHAR2 |
1 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_COUNTER |
Profit center counter associated with the record. |
NUMBER |
|
PROFIT_CENTER_EFFECTIVE_DATE |
Date associated with profit center effective. |
DATE |
|
PROFIT_CENTER_EXPIRATION_DATE |
Date associated with profit center expiration. |
DATE |
|
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |