INV_RESERVATIONS
This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_RESERVATIONS_PK |
RESERVATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| RESERVATION_ID | NUMBER | 18 | Yes | This identifies the reservation. | Active | ||
| ORDER_INTERFACE_STATUS | VARCHAR2 | 1 | Indicates whether the reservation is for unreleased SO/TO or interfaced SO/TO.Y/Null - interfaced to Inventory or Shipping;N- not interfaced. | ||||
| BACK_TO_BACK_FLAG | VARCHAR2 | 1 | Indicates whether a transfer order is a back-to-back transfer order. | ||||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Identifier of organization in which reservation is made | Active | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | This identifies the reserved inventory item. | Active | ||
| DEMAND_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Indicates demand source for which reservation is made | Active | ||
| DEMAND_SOURCE_NAME | VARCHAR2 | 30 | Identifier for inventory or user defined demand | Active | |||
| DEMAND_SOURCE_HEADER_ID | NUMBER | 18 | Header identifier for source of demand. For Sales Order: OE_ORDER_HEADERS.HEADER_ID. For Account: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. For Account Alias: INV_GENERIC_DISPOSITIONS.DISPOSITION_ID | Active | |||
| DEMAND_SOURCE_LINE_ID | NUMBER | 18 | Line ID for demand source. For Sales Order: OE_ORDER_LINES.LINE_ID | Active | |||
| SOURCE_LINE_NUMBER | VARCHAR2 | 150 | When demand source is not within the same pillar (e.g. DOO) then this column stores the demand source line number | Active | |||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 150 | Identifies the line number for a sales order. | Active | |||
| SOURCE_FULFILLMENT_LINE_ID | NUMBER | 18 | Points to source_fulfillment_line_id (e.g. DOO fulfillment line id) | Active | |||
| SOURCE_SHIPMENT_NUMBER | VARCHAR2 | 150 | Points to source_fulfillment_line_number (e.g. DOO fulfillment line number) | Active | |||
| SALES_ORDER_SHIPMENT_NUMBER | VARCHAR2 | 150 | Identifies the shipment number for a sales order. | Active | |||
| DEMAND_SOURCE_DELIVERY | NUMBER | 18 | Delivery identifier for demand sources having one | Active | |||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Lines of an order could be shipped to multiple places | Active | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary unit of measure of reserved item | Active | |||
| RESERVATION_UOM_CODE | VARCHAR2 | 3 | Unit of measure in which reservation is made | Active | |||
| RESERVATION_QUANTITY | NUMBER | Yes | Quanity reserved in RESERVATION_UOM_CODE | Active | |||
| PRIMARY_RESERVATION_QUANTITY | NUMBER | Yes | Quantity reserved in PRIMARY_UOM_CODE | Active | |||
| SUPPLY_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Indicates supply source of reservation | Active | ||
| SUPPLY_SOURCE_HEADER_ID | NUMBER | 18 | Header identifier of supply source | Active | |||
| SUPPLY_SOURCE_LINE_ID | NUMBER | 18 | Indicates line identifier of supply source | Active | |||
| SUPPLY_SOURCE_LINE_DETAIL | NUMBER | 18 | Indicates line detail identifier of supply source | Active | |||
| SUPPLY_SOURCE_NAME | VARCHAR2 | 30 | Indicates name of supply source | Active | |||
| REVISION | VARCHAR2 | 18 | Revision of revision controlled reserved item | Active | |||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Subinventory in which reserved item resides | Active | |||
| LOCATOR_ID | NUMBER | 18 | Locator in which reserved item resides | Active | |||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number of lot controlled reserved item | Active | |||
| LPN_ID | NUMBER | 18 | LPN in which reserved item resides. This is used in WMS. | Active | |||
| REQUIREMENT_DATE | DATE | This is the reservation requirement date. | Active | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | Active | ||
| SHIP_READY_FLAG | NUMBER | 18 | Indicates that reserved quantity is ready to be shipped | Active | |||
| N_COLUMN1 | NUMBER | This column is used for synchronization purpose. | Active | ||||
| DETAILED_QUANTITY | NUMBER | If high level reservation, quantity detailed. | Active | ||||
| CONTAINER_LPN_ID | NUMBER | 18 | Indicates LPN of the empty container reserved - used by WMS only | Active | |||
| STAGED_FLAG | VARCHAR2 | 1 | Indicates if the reservation is in staged area. | Active | |||
| SECONDARY_DETAILED_QUANTITY | NUMBER | Detailed Quantity Recorded in the Secondary Unit Of Measure | Active | ||||
| SECONDARY_RESERVATION_QUANTITY | NUMBER | Reservation Quantity Recorded in the Secondary Unit Of Measure | Active | ||||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Items Secondary Unit Of Measure Code | Active | |||
| CROSSDOCK_FLAG | VARCHAR2 | 1 | Indicates whether the reservation is crossdocked or not | Active | |||
| CROSSDOCK_CRITERIA_ID | NUMBER | 18 | Indicates the crossdock rule that flaged the reservation | Active | |||
| DEMAND_SOURCE_LINE_DETAIL | NUMBER | 18 | Holds the demand's line detail information | Active | |||
| SERIAL_RESERVATION_QUANTITY | NUMBER | Indicates the number of serial reserved against the reservation record | Active | ||||
| SUPPLY_RECEIPT_DATE | DATE | Indicates when the supply is expected | Active | ||||
| DEMAND_SHIP_DATE | DATE | Indicates when the demand will be met | Active | ||||
| EXCEPTION_CODE | VARCHAR2 | 150 | Holds the exception code for crossdocked reservations | Active | |||
| ORIG_SUPPLY_SOURCE_TYPE_ID | NUMBER | 18 | Holds the original supply type that created the reservation | Active | |||
| ORIG_SUPPLY_SOURCE_HEADER_ID | NUMBER | 18 | Holds the original supply header information that created the reservation | Active | |||
| ORIG_SUPPLY_SOURCE_LINE_ID | NUMBER | 18 | Holds the original supply line information that created the reservation | Active | |||
| ORIG_SUPPLY_SOURCE_LINE_DETAIL | NUMBER | 18 | Holds the original supply line detail information that created the reservation | Active | |||
| ORIG_DEMAND_SOURCE_TYPE_ID | NUMBER | 18 | Holds the original demand type that created the reservation | Active | |||
| ORIG_DEMAND_SOURCE_HEADER_ID | NUMBER | 18 | Holds the original demand header information that created the reservation | Active | |||
| ORIG_DEMAND_SOURCE_LINE_ID | NUMBER | 18 | Holds the original demand line information that created the reservation | Active | |||
| ORIG_DEMAND_SOURCE_LINE_NUMBER | VARCHAR2 | 150 | When original demand source is not within the same pillar (e.g. DOO) then this column stores the demand source line number | Active | |||
| ORIG_DEMAND_SOURCE_LINE_DETAIL | NUMBER | 18 | Holds the original demand line detail information that created the reservation | Active | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| PROJECT_ID | NUMBER | 18 | Identifier of the project used to stripe Inventory transactions | Active | |||
| TASK_ID | NUMBER | 18 | Identifier of the task used to stripe Inventory transactions | Active | |||
| 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. | Active | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | Active | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | Active | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Reservations (INV_RESERVATIONS) | ||||
| INV_STRIPING_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for Inventory striping attributes | ||||
| COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of manufacture used to stripe Inventory transactions | ||||
| INV_RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
| INV_RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for future Inventory striping related functionality | ||||
| INV_USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information | ||||
| INV_USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for user-definable Inventory striping information |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_RESERVATIONS | inv_org_parameters | ORGANIZATION_ID |
| INV_RESERVATIONS | inv_lot_numbers | INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER |
| INV_RESERVATIONS | egp_item_org_associations | INVENTORY_ITEM_ID, ORGANIZATION_ID |
| INV_RESERVATIONS | inv_txn_source_types_b | DEMAND_SOURCE_TYPE_ID |
| INV_RESERVATIONS | inv_txn_source_types_b | SUPPLY_SOURCE_TYPE_ID |
| INV_RESERVATIONS | inv_secondary_inventories | SUBINVENTORY_CODE, ORGANIZATION_ID |
| INV_RESERVATIONS | inv_item_locations | LOCATOR_ID |
| inv_material_txns_temp | inv_reservations | RESERVATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| INV_RESERVATIONS_N1 | Non Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, INVENTORY_ITEM_ID | Obsolete |
| INV_RESERVATIONS_N10 | Non Unique | FUSION_TS_TX_IDX | DEMAND_SOURCE_LINE_DETAIL | |
| INV_RESERVATIONS_N11 | Non Unique | FUSION_TS_TX_IDX | SOURCE_FULFILLMENT_LINE_ID | |
| INV_RESERVATIONS_N2 | Non Unique | FUSION_TS_TX_IDX | DEMAND_SOURCE_LINE_ID | |
| INV_RESERVATIONS_N3 | Non Unique | FUSION_TS_TX_IDX | LPN_ID, ORGANIZATION_ID | |
| INV_RESERVATIONS_N5 | Non Unique | FUSION_TS_TX_IDX | ORGANIZATION_ID, INVENTORY_ITEM_ID, REQUIREMENT_DATE | |
| INV_RESERVATIONS_N6 | Non Unique | FUSION_TS_TX_IDX | SHIP_READY_FLAG | |
| INV_RESERVATIONS_N7 | Non Unique | FUSION_TS_TX_IDX | N_COLUMN1 | |
| INV_RESERVATIONS_N8 | Non Unique | FUSION_TS_TX_IDX | DEMAND_SOURCE_HEADER_ID | |
| INV_RESERVATIONS_N9 | Non Unique | FUSION_TS_TX_IDX | SUPPLY_SOURCE_HEADER_ID, SUPPLY_SOURCE_LINE_ID, SUPPLY_SOURCE_TYPE_ID | |
| INV_RESERVATIONS_U1 | Unique | FUSION_TS_TX_IDX | RESERVATION_ID |