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