MSC_ITEM_SOURCING
This table stores sourcing information for an item used in Oracle Advanced Planning and Scheduling. This table is also used to store Sourcing information for in line vehicle sequencing ( ILVS ) in the supply chain hub product.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
MSC_ITEM_SOURCING_PK |
PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SOURCE_ORGANIZATION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, EFFECTIVE_DATE, SHIP_METHOD, CUSTOMER_ID, CUSTOMER_SITE_ID, ZONE_ID, ASSIGNMENT_SET_TYPE, RANK, CIRCULAR_SRC |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | This value indicates the plan identifier for the record. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Organization identifier | ||
| SR_INSTANCE_ID | NUMBER | Identifier of the source system from where the data is collected. | Obsolete | |||
| SR_INSTANCE_ID2 | NUMBER | Identifier of the source system from where the data is collected. | Obsolete | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item id | ||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Yes | This value indicates the Source organization identifier. | ||
| SITE_ID | NUMBER | 18 | This value indicates the Trading partner site identifier. | |||
| EFFECTIVE_DATE | DATE | Yes | Date from when the sourcing rule is effective | |||
| DISABLE_DATE | DATE | Disable date of the item sourcing rule | ||||
| ALLOCATION_PERCENT | NUMBER | Percent allocated to the source | ||||
| RANK | NUMBER | 18 | Yes | This value indicates the Rank of the record. | ||
| SOURCE_TYPE | NUMBER | Source type of the sourcing. Make, Buy, Transfer. | ||||
| AVG_TRANSIT_LEAD_TIME | NUMBER | Intransit lead time between two organizations | ||||
| CONVERSION_FACTOR | NUMBER | Conversion factor applicable for the sourcing. | ||||
| SOURCING_RULE_ID | NUMBER | Sourcing rule or bill of distribution identifier | ||||
| ASSIGNMENT_ID | NUMBER | Yes | Unique Identifier of the allocation assignment | |||
| ASSIGNMENT_SET_ID | NUMBER | 18 | Yes | Unique Identifier of the assignment set | ||
| ASSIGNMENT_TYPE | NUMBER | 18 | Yes | Sourcing Assignment type for the item. | ||
| SOURCING_RULE_TYPE | NUMBER | Yes | Sourcing rule type. This indicates whether it is a Bill of distribution or a Sourcing rule. | |||
| SHIP_METHOD | VARCHAR2 | 300 | Yes | Shipping method used to move the material. | ||
| HISTORICAL_ALLOC_QTY | NUMBER | Total historical allocation to supplier for item | ||||
| 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | ||||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SUPPLIER_ID | NUMBER | 18 | Yes | This value indicates the Supplier identifier in the planning system. | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Yes | This value indicates the Supplier site identifier. | ||
| MIN_TRANSFER_QTY | NUMBER | Minimum transfer quantity specified while defining the sourcing. | ||||
| MAX_TRANSFER_QTY | NUMBER | Maximum transfer quantity | ||||
| TRANSFER_TYPE | NUMBER | This value indicates the Transfer lot multiple. | ||||
| TRANSFER_LOT_MULTIPLE | NUMBER | This value indicates the Transfer lot multiple. | ||||
| FIXED_TRANSFER_QTY | NUMBER | This value indicates the fixed transfer quantity. | ||||
| CUSTOMER_ID | NUMBER | 18 | Yes | Customer id used for Customer level sourcing | ||
| CUSTOMER_SITE_ID | NUMBER | 18 | Yes | Customer site id used for Customer site level sourcing | ||
| ZONE_ID | NUMBER | 18 | Yes | Zone id for zone level sourcing | ||
| ASSIGNMENT_SET_TYPE | NUMBER | Yes | Assignment Set Type. Possible values 1- Global, 2- Category, 3- Item, 4- Organization, 5- Category-Org, 6- Item_Org | |||
| CIRCULAR_SRC | NUMBER | Yes | The flag indicates whether circular sourcing is enabled for this sourcing rule or not. | |||
| 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. | ||
| SUBINV_FLAG | NUMBER | 1 | This indicates whether the row is for ITEM+ORG/ITEM+SUBORG. 1=ITEM+SUBORG, 2=ITEM+ORG, null=ITEM+ORG | |||
| CREATE_MOVEMENT_REQUEST | NUMBER | 1 | This column identifies whether to create a movement request or Transfer order between subinventories of the same org. 1=Create Movement Request, 2=Do not create movement request (Create transfer order), null=Do not create movement request (Create transfer order) | |||
| CARRIER_ID | NUMBER | 38 | Unique identifier for the carrier | |||
| MODE_OF_TRANSPORT | NUMBER | 18 | Mode of transport specified in the shipping method | |||
| SERVICE_LEVEL | NUMBER | 18 | Service level specified in the shipping method |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_ITEM_SOURCING | msc_sourcing_rules | SOURCING_RULE_ID |
| MSC_ITEM_SOURCING | msc_sr_assignments | ASSIGNMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_ITEM_SOURCING_N1 | Non Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SOURCE_ORGANIZATION_ID | Obsolete |
| MSC_ITEM_SOURCING_N2 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, SUPPLIER_ID, SUPPLIER_SITE_ID | |
| MSC_ITEM_SOURCING_N3 | Non Unique | Default | PLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, SOURCE_ORGANIZATION_ID | |
| MSC_ITEM_SOURCING_U1 | Unique | Default | PLAN_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, SOURCE_ORGANIZATION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, EFFECTIVE_DATE, SHIP_METHOD, CUSTOMER_ID, CUSTOMER_SITE_ID, ZONE_ID, ASSIGNMENT_SET_TYPE, RANK, CIRCULAR_SRC |