ZCA_S_ACCT_CLASSIFICATION_DN
The ZCA_S_ACCT_CLASSIFICATION_DN is a column flattened denormalization table storing all ten primary classification code assignments per sales account. (one row per account) When a particular Auxiliary dimension profile option is not populated with a Classification Category selection, all of the associated columns for that dimension in this table will be null. When there are no primary code assignments to a sales account for a particular Auxiliary dimension, the associated columns for that dimension will also be null. Sales accounts that do not have any class code assignments or no Primary class code assignments in any of the class categories mapped through the setup profile options will NOT have any corresponding rows in this column flattened denorm table.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_S_ACC_CLASSIFICATION_PK |
SALES_ACCOUNT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SALES_ACCOUNT_ID | NUMBER | 18 | Yes | Account identifier | |
| CLASS_CATEGORY_1 | VARCHAR2 | 30 | 1st classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_1 | VARCHAR2 | 30 | 1st classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_1 | DATE | Yes | The date that the 1st class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_1 | DATE | The date when the 1st class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_1 | VARCHAR2 | 1 | Record status flag for the 1st classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_2 | VARCHAR2 | 30 | 2nd classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_2 | VARCHAR2 | 30 | 2nd classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_2 | DATE | Yes | The date that the 2nd class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_2 | DATE | The date when the 2nd class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_2 | VARCHAR2 | 1 | Record status flag for the 2nd classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_3 | VARCHAR2 | 30 | 3rd classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_3 | VARCHAR2 | 30 | 3rd classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_3 | DATE | Yes | The date that the 3rd class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_3 | DATE | The date when the 3rd class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_3 | VARCHAR2 | 1 | Record status flag for the 3rd classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_4 | VARCHAR2 | 30 | 4th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_4 | VARCHAR2 | 30 | 4th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_4 | DATE | Yes | The date that the 4th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_4 | DATE | The date when the 4th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_4 | VARCHAR2 | 1 | Record status flag for the 4th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_5 | VARCHAR2 | 30 | 5th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_5 | VARCHAR2 | 30 | 5th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_5 | DATE | Yes | The date that the 5th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_5 | DATE | The date when the 5th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_5 | VARCHAR2 | 1 | Record status flag for the 5th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_6 | VARCHAR2 | 30 | 6th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_6 | VARCHAR2 | 30 | 6th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_6 | DATE | Yes | The date that the 6th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_6 | DATE | The date when the 6th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_6 | VARCHAR2 | 1 | Record status flag for the 6th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_7 | VARCHAR2 | 30 | 7th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_7 | VARCHAR2 | 30 | 7th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_7 | DATE | Yes | The date that the 7th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_7 | DATE | The date when the 7th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_7 | VARCHAR2 | 1 | Record status flag for the 7th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_8 | VARCHAR2 | 30 | 8th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_8 | VARCHAR2 | 30 | 8th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_8 | DATE | Yes | The date that the 8th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_8 | DATE | The date when the 8th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_8 | VARCHAR2 | 1 | Record status flag for the 8th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_9 | VARCHAR2 | 30 | 9th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_9 | VARCHAR2 | 30 | 9th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_9 | DATE | Yes | The date that the 9th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_9 | DATE | The date when the 9th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_9 | VARCHAR2 | 1 | Record status flag for the 9th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CATEGORY_10 | VARCHAR2 | 30 | 10th classification category name. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CLASS_CODE_10 | VARCHAR2 | 30 | 10th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| START_DATE_ACTIVE_10 | DATE | Yes | The date that the 10th class code applies to the sales account. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| END_DATE_ACTIVE_10 | DATE | The date when the 10th class code is no longer applied. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | |||
| STATUS_10 | VARCHAR2 | 1 | Record status flag for the 10th classification code. Data sourced from ZCA_SA_CODE_ASSIGNMENTS with the associated account's primary classification category and code | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_S_ACCT_CLASS_DN_U1 | Unique | Default | SALES_ACCOUNT_ID |