This table requires activation of Current Inventory Balances functional area. This table stores Inbound quantity information by control level and location
Module: Inventory Management
SUPPLY_SOURCE_ID, SUPPLY_TYPE_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
SUPPLY_TYPE_CODE | VARCHAR2 | 32 | True | This code indicates the supply type. | |||
SUPPLY_SOURCE_ID | NUMBER | 38 | 0 | True | Supply source unique identifier REQ_HEADER_ID, PO_DISTRIBUTION_ID, SHIPMENT_LINE_ID or RCV_TRANSACTION_ID depending on SUPPLY_TYPE_CODE | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System | ||||
DOCUMENT_TYPE | VARCHAR2 | 32 | Type of Inbound Document. Can have below values:- Purchase Order Transfer Order In-transit shipment Internal Requisition Advance Shipment Notice | ||||
EXTRACT_TIMESTAMP | TIMESTAMP | Extract Timestamp for the table | |||||
REQ_HEADER_ID | NUMBER | 38 | 0 | Identifies the requisition header. | |||
REQ_LINE_ID | NUMBER | 38 | 0 | Identifies the requisition line. | |||
PO_HEADER_ID | NUMBER | 38 | 0 | Purchase order header identifier | |||
PO_LINE_ID | NUMBER | 38 | 0 | This identifies a purchase order line. | |||
PO_LINE_LOCATION_ID | NUMBER | 38 | 0 | Purchase order line location identifier | |||
SHIPMENT_HEADER_ID | NUMBER | 38 | 0 | This column identifies the shipment. | |||
SHIPMENT_LINE_ID | NUMBER | 38 | 0 | This identifies the shipment line. | |||
RCV_TRANSACTION_ID | NUMBER | 38 | 0 | Receiving transaction identifier | |||
ITEM_ID | NUMBER | 38 | 0 | This identifies the inventory item. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID | |
ITEM_REVISION | VARCHAR2 | 32 | Revision of the inventory item. | ||||
CATEGORY_ID | NUMBER | 38 | 0 | This identifies the item category. | DW_ITEM_CATEGORIES_D | CATEGORY_ID | |
QUANTITY | NUMBER | This is the actual supply quantity. | |||||
UOM_CODE | VARCHAR2 | 16 | Unit of measure code for actual supply quantity | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
TO_ORG_PRIMARY_QUANTITY | NUMBER | Supply quantity in terms of primary unit of measure of item in destination organization | |||||
TO_ORG_PRIMARY_UOM_CODE | VARCHAR2 | 16 | Primary unit of measure code of the item in destination organization | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE | ||
RECEIPT_DATE | DATE | Expected or actual receipt date depending on supply type | DW_DAY_D | CALENDAR_DATE | |||
NEED_BY_DATE | DATE | This is the original need by date. | DW_DAY_D | CALENDAR_DATE | |||
EXPECTED_DELIVERY_DATE | DATE | Expected delivery date (receipt Date + post-processing lead time for MFG) | DW_DAY_D | CALENDAR_DATE | |||
FROM_ORGANIZATION_ID | NUMBER | 38 | 0 | Sending organization identifier for interorg shipment | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
TO_ORGANIZATION_ID | NUMBER | 38 | 0 | Destination organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
INTRANSIT_OWNING_ORG_ID | NUMBER | 38 | 0 | Owner organization identifier for interorg shipment | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
TRANSFER_ORDER_HEADER_ID | NUMBER | 38 | 0 | Transfer order header unique identifier | |||
TRANSFER_ORDER_LINE_ID | NUMBER | 38 | 0 | Transfer order line unique identifier | |||
BUSINESS_UNIT_ID | NUMBER | 38 | 0 | This identifies the business unit | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
INVENTORY_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 | Profit Center Business Unit Id of the Inventory Organization. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
INTRANSIT_SHIPMENT_FLAG | VARCHAR2 | 16 | Flag denotes whether record is of in-transit shipment type or not | ||||
DATA_AS_OF_DATE | DATE | Date on which data load was started | DW_DAY_D | CALENDAR_DATE | |||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Name of the accounting calendar. | ||||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. Examples are Weekly, Monthly, Quarterly. | ||||
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Business unit legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID |
#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D
Copyright © 2019, 2024, Oracle and/or its affiliates.