Requisitions Fact
Module: Purchasing
REQUISITION_DISTRIBUTION_ID
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 | 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_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 | 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 |