DW_REQUISITION_CF

Requisitions Fact

Details

Module: Purchasing

Key Columns

REQUISITION_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REQUISITION_DISTRIBUTION_ID NUMBER 38 0 True Requisition distribution unique identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier    
REQUISITION_DISTRIBUTION_NUMBER NUMBER       Requisition distribution number    
REQUISITION_LINE_ID NUMBER 38 0   Requisition line unique identifier    
REQUISITION_LINE_NUMBER NUMBER       Requisition line number    
REQUISITION_HEADER_ID NUMBER 38 0   Requisition unique identifier    
REQUISITION_NUMBER VARCHAR2 64     Requisition number    
DISTRIBUTION_CREATION_DATE DATE       Indicates the date of creation of the row.    
DISTRIBUTION_LAST_UPDATE_DATE DATE       Indicates the date of last update of the row.    
DISTRIBUTION_CREATED_BY VARCHAR2 128     Indicates the user who created the row. DW_USER_D USERNAME
DISTRIBUTION_LAST_UPDATED_BY VARCHAR2 128     Indicates the user who last updated the row. DW_USER_D USERNAME
CODE_COMBINATION_ID NUMBER 38 0   Unique identifier for the general ledger charge account 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 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
DISTRIBUTION_QUANTITY NUMBER       Requisition distribution quantity    
PUOM_DISTRIBUTION_QUANTITY NUMBER       Quantity for the distribution in Primary Unit of Measure    
DISTRIBUTION_AMOUNT NUMBER       Requisition distribution amount in functional currency    
RECOVERABLE_TAX NUMBER       Recoverable tax amount in functional currency    
NONRECOVERABLE_TAX NUMBER       Nonrecoverable tax amount in functional currency    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global currency conversion rate.    
GLOBAL_DISTRIBUTION_AMOUNT NUMBER       Requisition distribution amount in global currency    
GLOBAL_RECOVERABLE_TAX NUMBER       Recoverable tax amount in global currency    
GLOBAL_NONRECOVERABLE_TAX NUMBER       Nonrecoverable tax amount in global currency    
PROJECT_ID NUMBER 38 0   Identifier of the project used to biuld the transaction descriptive flexfield for project-related transaction distributions DW_PJF_PROJECTS_ALL_D_TL PROJECT_ID
TASK_ID NUMBER 38 0   Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions DW_PJF_PROJ_ELEMENTS_D_TL PROJ_ELEMENT_ID, PROJECT_ID
EXPENDITURE_TYPE_ID NUMBER 38 0   Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions DW_PJF_EXP_TYPES_D_TL EXPENDITURE_TYPE_ID
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0   Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID
EXPENDITURE_ITEM_DATE DATE       Date on which project-related transaction is incurred    
ITEM_SOURCE VARCHAR2 64     Indicates whether item comes from Catalog, Noncatalog, Quick Entry, Punchout, Req import or Req service. DW_POR_ITEM_SOURCE_D_TL CODE
LINE_TYPE_ID NUMBER 38 0   Requisition line type unique identifier DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
REQUESTER_ID NUMBER 38 0   Requisition requester unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
NON_CATALOG_FLAG VARCHAR2 32     Indicates whether item source is Non Catalog or not DW_Y_N_D_TL CODE
URGENT_FLAG VARCHAR2 32     Indicates whether the requisition requires urgent processing or not. Values will be Y or N. DW_Y_N_D_TL CODE
MODIFIED_BY_BUYER_FLAG VARCHAR2 32     Indicates whether a buyer modified this line or not. Values will be Y or N. DW_Y_N_D_TL CODE
BUYER_PROCESSING_FLAG VARCHAR2 32     Indicates if a buyer is currently processing this requisition line. Values will be Y or N. DW_Y_N_D_TL CODE
NEW_SUPPLIER_FLAG VARCHAR2 32     Indicator that this is a new supplier. Values will be Y or N. DW_Y_N_D_TL CODE
REQUISITION_LINE_STATUS VARCHAR2 64     Status of the requisition line. Values are APPROVED, CANCELED, REJECTED, WITHDRAWN, SPLIT, REPLACED etc. DW_POR_LINE_STATUS_D_TL CODE
BACK_TO_BACK_FLAG VARCHAR2 32     Indicates whether a requisition line has a backing sales order that is fulfilled using a back to back order. Y indicates a back to back requisition line. N indicates that the requisition line is not a back to back requisition line. DW_Y_N_D_TL CODE
UOM_CODE VARCHAR2 32     Unit of measure code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CODE VARCHAR2 32     Abbreviated Primary Unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CONVERSION_FACTOR NUMBER       Conversion factor by which the UOM is equivalent to the primary UOM of the item.    
LINE_QUANTITY NUMBER       Quantity ordered    
PUOM_LINE_QUANTITY NUMBER       Line Quantity ordered in Primary Unit of Measure    
LINE_CURRENCY_CODE VARCHAR2 32     Unique identifier for the currency on req line DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
UNIT_PRICE NUMBER       Unit price in functional currency    
LINE_CURRENCY_UNIT_PRICE NUMBER       Unit price in req line currency    
LINE_AMOUNT NUMBER       Requisition line amount in functional currency    
LINE_CURRENCY_AMOUNT NUMBER       Amount on the req line in line currency    
GLOBAL_UNIT_PRICE NUMBER       Unit price in global currency    
GLOBAL_LINE_AMOUNT NUMBER       Requisition line amount in global currency    
SUGGESTED_BUYER_ID NUMBER 38 0   Suggested buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
ASSIGNED_BUYER_ID NUMBER 38 0   Assigned buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
SUGGESTED_VENDOR_NAME VARCHAR2 512     Suggested supplier name    
SUGGESTED_VENDOR_SITE VARCHAR2 256     Suggested supplier site name    
SUGGESTED_VENDOR_CONTACT VARCHAR2 128     Suggested supplier contact name    
SUGGESTED_VENDOR_EMAIL VARCHAR2 2048     Suggested supplier email contact information    
SUGGESTED_VENDOR_FAX VARCHAR2 32     Suggested supplier contact fax number    
SUGGESTED_VENDOR_PHONE VARCHAR2 32     Suggested supplier phone number    
VENDOR_ID NUMBER 38 0   Supplier unique identifier DW_PARTY_D SUPPLIER_ID
VENDOR_SITE_ID NUMBER 38 0   Supplier site unique identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
ITEM_ID NUMBER 38 0   Item unique identifier. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID ,ORGANIZATION_ID
ITEM_DESCRIPTION VARCHAR2 256     Item description    
SUGGESTED_SUPPLIER_ITEM_NUMBER VARCHAR2 512     Suggested supplier product number    
CATEGORY_ID NUMBER 38 0   Item category unique identifier DW_ITEM_CATEGORIES_D CATEGORY_ID
LINE_LAST_APPROVAL_DATE DATE       Date when the requisition lines is last approved. It is used to compute the average approval time metric for the items on requisition lines.    
LINE_LAST_SUBMITTED_DATE DATE       Date when the requisition line is last submitted for approval. It is used to compute the average approval time metric for the items on requisition lines.    
NEED_BY_DATE DATE       Date the requisition is needed internally    
LINE_CREATED_BY VARCHAR2 128     Indicates the user who created requisition line DW_USER_D USERNAME
LINE_LAST_UPDATE_DATE DATE       Indicates the date of last update of requisition line    
LINE_CREATION_DATE VARCHAR2 128     Indicates the date of creation of requisition line    
LINE_LAST_UPDATED_BY VARCHAR2 128     Indicates the user who last updated requisition line DW_USER_D USERNAME
PO_HEADER_ID NUMBER 38 0   Purchase order header unique identifier    
PO_NUMBER VARCHAR2 32     Purchase order number    
PO_DESCRIPTION VARCHAR2 256     Purchase Order descriptive comments    
PO_CREATION_DATE DATE       Indicates the date of creation of purchase order    
PO_PROC_BU_ID NUMBER 38 0   Procurement business unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
REQ_PROC_BU_ID NUMBER 38 0   Procurement business unit identifier in requisition document. In requisitions, procurement BU is stamped from purchase agreement when requisition line is created or bsed on assignment rules for emergency requisitions (auto create PO scenario). DW_INTERNAL_ORG_D ORGANIZATION_ID
SECURITY_PROC_BU_ID NUMBER 38 0   If REQ_PROC_BU_ID is null then PO_PROC_BU_ID else REQ_PROC_BU_ID DW_INTERNAL_ORG_D ORGANIZATION_ID
PO_LINE_ID NUMBER 38 0   Purchase order line unique identifier    
PO_LINE_NUMBER NUMBER       Purchase order line number    
PO_LINE_TYPE_ID NUMBER 38 0   Purchase order line type unique identifier DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
PO_LINE_CREATION_DATE DATE       Indicates the date of creation of purchsae order line    
PO_LINE_CLOSE_DATE DATE       Indicates the date when purchase order line is closed    
PO_DOCUMENT_STATUS VARCHAR2 32     Purchase order status. Values are CLOSED FOR INVOICING, OPEN, CLOSED FOR RECEIVING etc DW_DOCUMENT_STATUS_D_TL CODE
PO_LINE_STATUS VARCHAR2 32     Purchase order line status. Values could be CLOSED FOR INVOICING, OPEN, CLOSED FOR RECEIVING etc DW_PO_LINE_STATUS_D_TL CODE
SOURCE_ORGANIZATION_ID NUMBER 38 0   Inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation. DW_INTERNAL_ORG_D ORGANIZATION_ID
SOURCE_SUBINVENTORY VARCHAR2 64     Subinventory within a source inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME,ORGANIZATION_ID
SOURCE_TYPE_CODE VARCHAR2 64     Indicator of the type of the source of supply for the requisition line. The possible values are INTERNAL for inventory organizations and EXTERNAL for suppliers. DW_POR_SOURCE_TYPE_D_TL CODE
DESTINATION_ORGANIZATION_ID NUMBER 38 0   Destination organization unique identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
DESTINATION_SUBINVENTORY VARCHAR2 64     Destination subinventory name. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME,ORGANIZATION_ID
DESTINATION_TYPE_CODE VARCHAR2 64     Destination type code. Values could be EXPENSE, INVENTORY, MANUFACTURING, DROP SHIP etc DW_POR_DESTINATION_TYPE_D_TL CODE
ONE_TIME_LOCATION_FLAG VARCHAR2 32     Indicates that the deliver to location of the requisition line is a one-time location. Values are Y or N. DW_Y_N_D_TL CODE
DELIVER_TO_LOCATION_ID NUMBER 38 0   Deliver-to location unique identifier DW_WORKER_LOCATION_D LOCATION_ID
DELIVER_TO_CUST_ID NUMBER 38 0   Customer to whom merchandise is being delivered. DW_PARTY_D PARTY_ID
DELIVER_TO_CUST_LOCATION_ID NUMBER 38 0   Customer location unique identifier. The final location where goods will be delivered that were previously received from a supplier. For Structured One-Time Address, this represents the delivery location. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
SALES_ORDER_NUMBER VARCHAR2 64     Backing Sales Order Number    
WORK_ORDER_NUMBER VARCHAR2 256     Number of the contract manufacturing work order.    
PARENT_REQ_LINE_ID NUMBER 38 0   Unique identifier of the parent requisition line for a modified requisition line    
CANCEL_DATE DATE       Cancel date    
CANCEL_REASON VARCHAR2 256     Cancel reason    
AGREEMENT_TYPE VARCHAR2 64     Source document type - Blanket or Contract    
AGREEMENT_HEADER_ID NUMBER 38 0   Suggested source blanket agreement or contract header unique identifier    
AGREEMENT_HEADER_NUMBER VARCHAR2 32     Suggested source blanket agreement or contract header number    
AGREEMENT_LINE_ID NUMBER 38 0   Suggested source blanket agreement line identifier    
AGREEMENT_LINE_NUMBER NUMBER 38 0   Suggested source blanket agreement line number    
NEGOTIATION_HEADER_ID NUMBER 38 0   Reference to sourcing auction id    
NEGOTIATION_NUMBER VARCHAR2 256     Reference to sourcing auction number    
NEGOTIATION_LINE_NUMBER NUMBER       Reference to sourcing auction line number    
NEGOTIATION_REQUIRED_FLAG VARCHAR2 32     Indicates whether an RFQ is required prior to placement on a purchase order. Values will be Y or N. DW_Y_N_D_TL CODE
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 32     Indicates whether price has been negotiated by buyer. Values will be Y or N. DW_Y_N_D_TL CODE
FULFILLED_DATE DATE       Fufilled_date for a given PO Line will be the max fufilled_date among its schedules. The fufilled date for a PO schedule is calculated as 1. min of SHIPMENT_CLOSED_DATE and CLOSED_FOR_INVOICE_DATE if RECEIPT_REQUIRED_FLAG and INSPECTION_REQUIRED_FLAG are marked as N Else 2. min of SHIPMENT_CLOSED_DATE and CLOSED_FOR_RECEIVING_DATE. Fulfill date will have value only if all the the schedule lines for that PO line is closed for Receiving or invoicing.    
PROCESSED_DATE DATE       Processed Date of version 0 of purchase order.    
INTERFACE_SOURCE_CODE VARCHAR2 32     Source of requisition from requisition import. Values are DOO, SCO, INV etc.    
EMERGENCY_REQ_FLAG VARCHAR2 32     Stores state of emergency requisition checkbox. Values will be Y or N. DW_Y_N_D_TL CODE
INTERNAL_TRANSFER_REQ_FLAG VARCHAR2 32     Indicates whether all lines of the requisition are for internal material transfer. Values will be Y or N.    
REQUISITION_DOCUMENT_STATUS VARCHAR2 32     Requisition document status. Values are PENDING APPROVAL, APPROVED, CANCELED, REJECTED, WITHDRAWN etc. DW_POR_DOCUMENT_STATUS_D_TL CODE
DESCRIPTION VARCHAR2 256     Description for requisition    
JUSTIFICATION VARCHAR2 1024     Note to approver    
EMERGENCY_PO_NUMBER VARCHAR2 32     Purchase order number reserved in advance for an emergency requisition    
REQUISITION_BU_ID NUMBER 38 0   Requisition business unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
OVERRIDING_APPROVER_ID NUMBER 38 0   Overriding first approver identifier for a requisition for approval routing. DW_PERSON_NAME_CURRENT_D PERSON_ID
PREPARER_ID NUMBER 38 0   Unique identifier of the employee who prepared the requisition DW_PERSON_NAME_CURRENT_D PERSON_ID
CURRENCY_CODE VARCHAR2 32     Unique identifier for the requisition currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
REQ_BU_PRIMARY_LEDGER_ID NUMBER 38 0   Primary ledger identifier of requisition business unit DW_LEDGER_D LEDGER_ID
HEADER_CREATION_DATE DATE       Indicates the date of creation of requisition header    
HEADER_LAST_UPDATE_DATE VARCHAR2 128     Indicates the date of last update of requisition header    
HEADER_CREATED_BY VARCHAR2 128     Indicates the user who created requisition header DW_USER_D USERNAME
HEADER_LAST_UPDATED_BY VARCHAR2 128     Indicates the user who last updated requisition header DW_USER_D USERNAME
REQ_FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
REQ_FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
FIRST_SUBMIT_DATE DATE       Date when requisition was first submitted.    
FIRST_SUBMITTER_ID NUMBER 38 0   Indicates the user who first submitted the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
FIRST_APPROVAL_DATE DATE       Date when requisition was first approved    
FIRST_APPROVER_ID NUMBER 38 0   Indicates the user who first approved the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
LAST_SUBMIT_DATE DATE       Date when requisition was last submitted.    
LAST_SUBMITTER_ID NUMBER 38 0   Indicates the user who last submitted the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
LAST_APPROVAL_DATE DATE       Date when requisition was last approved    
LAST_APPROVER_ID NUMBER 38 0   Indicates the user who last approved the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
NEGOTIATED_FLAG VARCHAR2 32     Values will be Y if requisition was negotiated through any RFQ/sourcing event, else N DW_Y_N_D_TL CODE
PROCESSED_FLAG VARCHAR2 32     Values will be Y if requisition is processed and converted into purchase order, else N DW_Y_N_D_TL CODE
FULFILLED_FLAG VARCHAR2 32     Values will be Y if requisition is processed and purchase order line is closed, else N DW_Y_N_D_TL CODE
LINE_PARENT_FLAG VARCHAR2 32     Value will be Y if the line is the parent requisition line for a modified requisition line, else N DW_Y_N_D_TL CODE
REQ_APPROVAL_CYCLE_TIME NUMBER       Time taken to get requisition approved in first cycle i.e. from first submit date to first approval date    
REQ_PROCESS_CYCLE_TIME NUMBER       Time taken to process requisition i.e requisition line last approval date to processed date of purchase order version 0    
REQ_APPROVAL_TO_FULFIL_TIME NUMBER       Time taken to fulfil requisition i.e. from req line last approval date to purchase order line closed date    
REQ_SUBMIT_TO_FULFIL_TIME NUMBER       Time taken to fulfil requisition i.e. from req line last submit date to purchase order line closed date    
PR_TO_PO_CYCLE_TIME NUMBER       Time between requisition line last approval date and purchse order creation date