# DW_PO_RECEIPT_TRANSACTIONS_CF

This table stores Purchase Order receipt transactions.

## Details

Module: Purchasing

## Key Columns

TRANSACTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
TRANSACTION_ID | NUMBER | 38 | 0 | True | This column stores the unique identifier for the receiving transaction. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
SHIPMENT_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the receiving header unique identifier. |  |
RECEIPT_NUMBER | VARCHAR2 | 32 |  |  | This column stores the receipt number for the receiving. |  |
INV_ORG_BU_ID | NUMBER | 38 | 0 |  | This Column stores the Inventory Org Business unit Identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEDGER_ID | NUMBER | 38 | 0 |  | This column stores receiving organization's Primary Ledger | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal Period Set Name #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Period type. Examples are Weekly, Monthly, Quarterly #3 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
SHIPMENT_LINE_ID | NUMBER | 38 | 0 |  | This column stores the receiving line unique identifier |  |
LINE_NUM | NUMBER | 38 | 0 |  | This column stores the number corresponding to the receipt line. |  |
ITEM_ID | NUMBER | 38 | 0 |  | This column stores the inventory item unique identifier of the document for which the receiving receipt line is created. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ITEM_DESCRIPTION | VARCHAR2 | 256 |  |  | This column stores the item description for a receipt line. |  |
ITEM_REVISION | VARCHAR2 | 32 |  |  | This column stores the revision number of the inventory item. |  |
SOURCE_DOCUMENT_CODE | VARCHAR2 | 32 |  |  | This column stores the source document code for the receiving transactions. | DW_RCV_SOURCE_DOCUMENT_TYPE_D_TL | CODE
TRANSACTION_TYPE | VARCHAR2 | 32 |  |  | This column stores receiving transaction type. | DW_RCV_TRANSACTION_TYPE_D_TL | RCV_TRANSACTION_TYPE_CODE
TRANSACTION_DATE | DATE |  |  |  | This column stores the transaction date for the receiving transactions. | DW_DAY_D | CALENDAR_DATE
ORGANIZATION_ID | NUMBER | 38 | 0 |  | This column stores Receiving organization unique identifier where the receiving transaction is created. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID
SUBINVENTORY | VARCHAR2 | 16 |  |  | This column stores the destination subinventory name for the receiving transaction.#2 | DW_INV_SUBINVENTORY_D | SECONDARY_INVENTORY_NAME
LOCATOR_ID | NUMBER | 38 | 0 |  | This column stores the destination locator unique identifier for the receiving transaction. | DW_INV_LOCATOR_D | INVENTORY_LOCATION_ID
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | This column stores the destination type code when the receiving transaction is created. | DW_RCV_DESTINATION_TYPE_D_TL | CODE
LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the deliver or receive to location unique identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
DELIVER_TO_PERSON_ID | NUMBER | 38 | 0 |  | This column stores the deliver to person, or requester, unique identifier. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
EMPLOYEE_ID | NUMBER | 38 | 0 |  | This column stores the Unique identifier for the person who created the receiving transaction. | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PARENT_TRANSACTION_ID | NUMBER | 38 | 0 |  | This column stores the unique identifier of the parent receiving transaction. |  |
DELIVER_TO_LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the deliver to location unique identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project corresponding to the source document and is propagated to the inventory transactions. | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task corresponding to the source document and is propagated to the inventory transactions. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
SUBINVENTORY_LOCATION_ID | NUMBER | 38 | 0 |  | This identifies the subinventory location identifier. | DW_WORKER_LOCATION_D | LOCATION_ID
INSPECTION_STATUS_CODE | VARCHAR2 | 32 |  |  | This column stores the inspection status code. | DW_RCV_INSPECTION_STATUS_D_TL | RCV_INSPECTION_STATUS_CODE
REASON_ID | NUMBER | 38 | 0 |  | This column stores the inventory transaction reason unique identifier. | DW_INV_TRANSACTION_REASONS_D_TL | REASON_ID
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 16 |  |  | This column stores the code for the country of manufacture. | DW_INSERT_COUNTRY_LKP_TL | INSERT_COUNTRY_LKP_CODE
QUANTITY | NUMBER |  |  |  | This column stores the transaction quantits for Receiving Transaction |  |
UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the unit of measure code for the receiving transaction. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SOURCE_DOC_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the source document's (PO) unit of measure code. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SOURCE_DOC_QUANTITY | NUMBER |  |  |  | Transaction quantity in terms of the source document's(PO) unit of measure. |  |
PRIMARY_QUANTITY | NUMBER |  |  |  | Receiving Transaction quantity in terms of the item's primary unit of measure. |  |
PRIMARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the primary unit of measure code of the item | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
SECONDARY_QUANTITY | NUMBER |  |  |  | This column stores the receiving transaction quantity in the item's secondary unit of measure. |  |
SECONDARY_UOM_CODE | VARCHAR2 | 16 |  |  | This column stores the secondary unit of measure code of the inventory item. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
CURRENCY_CODE | VARCHAR2 | 16 |  |  | This column stores currency code for a transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | This column stores global currency code for a transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Exchange rate between Transaction currency and global currency. |  |
AMOUNT | NUMBER |  |  |  | This column stores amounts for fixed price lines. |  |
GLOBAL_AMOUNT | NUMBER |  |  |  | This column stores amounts for fixed price lines in global currency |  |
PRICE_OVERRIDE | NUMBER |  |  |  | Order shipment price or break price for blanket purchase orders in PO Transaction UOM(Source Doc UOM) and Transaction Currency |  |
GLOBAL_PRICE_OVERRIDE | NUMBER |  |  |  | Order shipment price or break price for blanket purchase orders in global currency. |  |
PARENT_TRANSACTION_TYPE | VARCHAR2 | 32 |  |  | This column stores parent transaction type | DW_RCV_TRANSACTION_TYPE_D_TL | RCV_TRANSACTION_TYPE_CODE
DELIVER_FLAG | VARCHAR2 | 32 |  |  | This column is stores a value Yes if the Transaction is DELIVER transaction or it's Parent Transaction is a DELIVER Transaction. Else it stores a value No |  |
PO_HEADER_ID | NUMBER | 38 | 0 |  | This column stores the purchase order header unique identifier. |  |
PO_LINE_ID | NUMBER | 38 | 0 |  | This column stores the purchase order line unique identifier. |  |
PO_LINE_LOCATION_ID | NUMBER | 38 | 0 |  | This column stores the purchase order schedule unique identifier. |  |
PO_DISTRIBUTION_ID | NUMBER | 38 | 0 |  | This column stores the purchase order distribution unique identifier. |  |
CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the General Ledger charge account of the PO Distribution of the Receiving Transaction | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE

## Notes

#1 In these cases in addition to the item columns ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D.#2 In these cases in addition to the Subinventory Name column, ORGANIZATION_ID column should also be used for join with DW_INV_SUBINVENTORY_D.#3 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on TRANSACTION_DATE column

Copyright © 2019, 2025, Oracle and/or its affiliates.