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