What is consignment Inventory:When the supplier places inventory at a customer’s location and retains ownership of the inventory. Payment is not made until the item is actually sold. A VMI relationship may or may not involve consignment inventory.
Table involved :
Supplier Material
MTL_ONHAND_QUANTITIES_DETAIL --OnhandQuantity
ConsumptionFlags
OWNING_TP_TYPE: 1 / ConsignedOWNING_ORGANIZATION_ID: Supplier Site ID
Vendor Managed Inventory (VMI) Flags
PLANNING_ORG_TYPE: 1 / Consigned PLANNING_ORGANIZATION_ID: Supplier Site ID
MTL_MATERIAL_TRANSACTIONS Transaction History
TRANSACTION_ID joins to TRANSACTION_ID in MTL_CONSUMPTION_TRANSACTIONS
Supplier Relationship
PO_HEADERS_ALL
Blanket Purchase Orders/Agreements
PO_LINES_ALL Purchase Order Lines
PO_ASL_DOCUMENTS Join Purchase Orders and Supplier ListsConsumed
PO_ASL_ATTRIBUTES ASL details:
ASL_ID: Primary Key
CONSIGNED_FROM_SUPPLIER_FLAG: Enables consignment
LAST_BILLING_DATE: Lists date the consumption was last run.
CONSIGNED_BILLING_CYCLE: Optionally tell consumption advise to wait this number of days before the next run.
CONSUME_ON_AGING_FLAG:
PO_APPROVED_SUPPLIER_LIST Approved Supplier List
ASL_ID: Primary Key
USING_ORGANIZATION_ID: Will be same asowning unless global then -1.
OWNING_ORGANIZATION_ID: This is the organization with the agreement.
VENDOR_ID: Supplier id.
ITEM_ID: Inventory Item ID.
Transaction Processing
MTL_TRANSACTIONS_INTERFACE Transaction interface table
MTL_MATERIAL_TRANSACTIONS_TEMP Pending transactions table
Consumed Material
MTL_ONHAND_QUANTITIES_DETAIL Owned Material
MTL_MATERIAL_TRANSACTIONS Transaction History
MTL_CONSUMPTION_TRANSACTIONS Consumption History
Purchasing Interfaces
PO_HEADERS_INTERFACE PO Headers Interface
PO_DISTRIBUTIONS_INTERFACE PO Distribution Interface
Purchasing Releases
PO_LINES_INTERFACE PO Lines Interface
ReleasesPO_RELEASES_ALL Blanket Releases
PO_DISTRIBUTIONS_ALL Release distribution details
