MOW_ASGN_ACCOUNTS_GT
MOW_ASGN_ACCOUNTS_GT is a global temp table to store the output of sales account query on translation phase
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
MOW_ASGN_ACCOUNTS_PK |
SEQ_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SEQ_ID | NUMBER | 18 | Yes | SEQ_ID = To store the primary key value | |
PARTY_ID | NUMBER | 18 | Yes | PARTY_ID = To store the party id | |
NAMED_ACCOUNT_FLAG | VARCHAR2 | 1 | NAMED_ACCOUNT_FLAG = To store the column value NAMED_ACCOUNT_FLAG of table ZCA_SALES_ACCOUNTS | ||
GEOGRAPHY_ID | NUMBER | 18 | GEOGRAPHY_ID = To store the column value of GEOGRAPHY_ID of table HZ_GEO_NAME_REFERENCES_V | ||
CUSTOMER_SIZE | VARCHAR2 | 30 | CUSTOMER_SIZE = Store the value of column ORGANIZATION_SIZE of table HZ_ORGANIZATION_PROFILES | ||
SALES_ACCOUNT_ID | NUMBER | 18 | Yes | SALES_ACCOUNT_ID = To store the value of column SALES_ACCOUNT_ID of table ZCA_SALES_ACCOUNTS |
Indexes
Index | Uniqueness | Columns |
---|---|---|
MOW_ASGN_ACCOUNTS_U1 | Unique | SEQ_ID |