CMK_XREF_DOMAIN_LOC_VALUES
This table stores the information related to the customer sites with location codes those needs to be configured at customer level for the Bill To, Ship To Usage, there are some sites both Ship To and Bill To Flag.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CMK_XREF_DMN_LOC_VALS_PK |
XREF_LOC_VALUE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
XREF_LOC_VALUE_ID | NUMBER | 18 | Yes | Primary Key of the Electronic Data Interchange Location Codes for Customer. | |
BILLTO | VARCHAR2 | 20 | To shore if the value of Bill to is true or not | ||
SHIPTO | VARCHAR2 | 20 | To store if the value of ship to is true or not | ||
XREF_DOMAIN_ID | NUMBER | 18 | Yes | Foreign Key to Cross Reference Domain. | |
SITE_USE_CODE | VARCHAR2 | 30 | Stores site use code frm TCA entities. | ||
SITE_USE_TYPE | VARCHAR2 | 30 | Stores site use code fromTCA entities. | ||
PARTY_SITE_NUMBER | VARCHAR2 | 30 | Stores the party site number from TCA entities. | ||
PARTY_ID | VARCHAR2 | 256 | The Primary Key of the Party. | ||
PARTY_TYPE | VARCHAR2 | 100 | Type of Party either it's SUPPLIER or CUSTOMER. | ||
PARTNER_KEY1 | VARCHAR2 | 256 | It stores the Party Id | ||
PARTNER_KEY2 | VARCHAR2 | 256 | It stores the Party Site id | ||
PARTNER_KEY_TYPE | VARCHAR2 | 256 | It the type of record as supplier or customer | ||
LOCATION_CODE | VARCHAR2 | 100 | Use stores the location code for the ShipTo or BillTo Site | ||
PARTY_SITE_ID | VARCHAR2 | 100 | Logical Foreign Key reference of Party Sites. The primary key of a party site. | ||
LOCATION_ID | NUMBER | 18 | Stores the Location Id for a location | ||
CUST_ACCT_SITE_ID | VARCHAR2 | 100 | Logical Foreign Key reference of Customer Account Sites. The primary key of a customer account site. | ||
CUST_ACCT_SITE_USE_ID | VARCHAR2 | 100 | The primary key of a customer account site use (type Bill To) | ||
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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CMK_XREF_DOMAIN_LOC_VALUES | cmk_xref_domains | XREF_DOMAIN_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CMK_XREF_DMN_LOC_VALS_U1 | Unique | FUSION_TS_TX_IDX | XREF_LOC_VALUE_ID |
CMK_XREF_DMN_LOC_VALS_U2 | Unique | FUSION_TS_TX_IDX | LOCATION_CODE |
CMK_XREF_DMN_LOC_VALS_U3 | Unique | FUSION_TS_TX_IDX | PARTY_ID, PARTY_TYPE, PARTY_SITE_ID |