Purchasing
Table Or View: Table
Important columns:
SHIPMENT_HEADER_ID - NUMBER - Receipt header unique identifier
RECEIPT_SOURCE_CODE - VARCHAR2 - Source type of the shipment - VENDOR, INTERNAL ORDER or
CUSTOMER
VENDOR_ID - NUMBER - Source supplier unique identifier
VENDOR_SITE_ID
ORGANIZATION_ID - NUMBER - Source organization unique identifier
SHIPMENT_NUM - Shipment number assigned by the shipment's source
RECEIPT_NUM - Receipt number
RECEIPT_SOURCE_CODE - VARCHAR2 - Source type of the shipment - VENDOR, INTERNAL ORDER or
CUSTOMER
VENDOR_ID - NUMBER - Source supplier unique identifier
VENDOR_SITE_ID
ORGANIZATION_ID - NUMBER - Source organization unique identifier
SHIPMENT_NUM - Shipment number assigned by the shipment's source
RECEIPT_NUM - Receipt number
Description:
RCV_SHIPMENT_HEADERS stores common information about the source of your receipts or expected receipts. You group your receipts by the source type and the source of the receipt. Oracle Purchasing does not allow you to group receipts from different sources under one receipt header.
There are two receipt source types, Supplier and Internal Order, that you need to use when receiving against different source document types. You use a receipt source type of 'Supplier' when receiving items that you ordered from an external supplier using
a purchase order. When you receive items that are part of an inter-organization transfer, or when receiving items that you request from your inventory using an internal requisition, the receipt type would be 'Internal Order'. The 'Internal Order' receipt source type populates the ORGANIZATION_ID column.
a purchase order. When you receive items that are part of an inter-organization transfer, or when receiving items that you request from your inventory using an internal requisition, the receipt type would be 'Internal Order'. The 'Internal Order' receipt source type populates the ORGANIZATION_ID column.
Oracle Purchasing creates a receipt header when you are entering your receipts or when you perform inter-organization transfers using Oracle Inventory. When Oracle Inventory creates a receipt header for an intransit shipment, the receipt number is not populated until you receive the shipment.
No comments:
Post a Comment