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