# 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 |  | This column is for Oracle Internal use only. 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_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of creation of the row. |  |
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 | 999 |  |  | 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 |  |
SALES_ORDER_LINE_NUMBER | VARCHAR2 | 64 |  |  | Backing Sales Order Line Number |  |
SALES_ORDER_SCHEDULE_NUMBER | VARCHAR2 | 64 |  |  | Backing Sales Order Schedule Number |  |
CUSTOMER_PO_NUMBER | VARCHAR2 | 64 |  |  | Customer PO Number |  |
CUSTOMER_PO_LINE_NUMBER | VARCHAR2 | 64 |  |  | Customer PO Line Number |  |
CUSTOMER_PO_SCHEDULE_NUMBER | VARCHAR2 | 64 |  |  | Customer PO Schedule Number |  |
WORK_ORDER_ID | NUMBER | 38 | 0 |  | Unique identifier for the work order |  |
WORK_ORDER_OPERATION_ID | NUMBER | 38 | 0 |  | The unique identifier of a work order operation |  |
WORK_ORDER_NUMBER | VARCHAR2 | 256 |  |  | Number of the manufacturing work order |  |
WORK_ORDER_OPERATION_SEQ | NUMBER |  |  |  | Indicates execution sequence of the work order operation |  |
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 | 999 |  |  | 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 |  |

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