REQ ITEM RAW Table
View exposing raw requisition item detail including document and release attributes, vendor and material references, plant and purchasing data, quantities and prices, agreement and quota attributes, purchase-order linkage, commitment indicators, and fund assignments.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASGMT_CHANGEABLE_IND |
Indicator identifying whether account asgmt changeable (Y/N). |
VARCHAR2 |
1 |
ACCOUNT_ASSIGNMENT_CATEGORY |
Account assignment category associated with the record. |
VARCHAR2 |
1 |
ACCOUNT_DISTRIBUTION_IND |
Indicator identifying whether account distribution (Y/N). |
VARCHAR2 |
1 |
ADVANCED_PROCUREMENT_IND |
Indicator identifying whether advanced procurement (Y/N). |
VARCHAR2 |
1 |
AFFECTS_COMMITMENTS_IND |
Indicator identifying whether affects commitments (Y/N). |
VARCHAR2 |
1 |
AGREEMENT_ITEM_NUMBER |
Agreement item number associated with the record. |
NUMBER |
5 |
AGREEMENT_NUMBER |
Agreement number associated with the record. |
VARCHAR2 |
10 |
ASSIGNED_SOURCE_IND |
Indicator identifying whether assigned source (Y/N). |
VARCHAR2 |
1 |
BATCH_NUMBER |
Batch number associated with the record. |
VARCHAR2 |
10 |
BOM_EXPLOSION_NUMBER |
Bom explosion number associated with the record. |
VARCHAR2 |
8 |
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
COMMITTED_DATE |
Date associated with committed. |
DATE |
|
COMMITTED_QUANTITY |
Committed quantity associated with the record. |
NUMBER |
13,3 |
CONFIGURATION |
Configuration associated with the record. |
VARCHAR2 |
18 |
CONFIG_ORIGIN |
Config origin associated with the record. |
VARCHAR2 |
1 |
CONSUMPTION_POSTING_IND |
Indicator identifying whether consumption posting (Y/N). |
VARCHAR2 |
1 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CREATION_INDICATOR |
Indicator identifying whether creation (Y/N). |
VARCHAR2 |
1 |
CURRENCY |
Currency associated with the record. |
VARCHAR2 |
5 |
DATE_CHANGED |
Date changed associated with the record. |
DATE |
|
DELETION_INDICATOR |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
DELIVERY_DATE_CATEGORY |
Delivery date category associated with the record. |
VARCHAR2 |
1 |
DESIRED_VENDOR |
Desired vendor associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_CATEGORY |
Document category associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_TYPE |
Document type associated with the record. |
VARCHAR2 |
4 |
DOC_TYPE_CONTROL_IND |
Indicator identifying whether doc type control (Y/N). |
VARCHAR2 |
1 |
FIXED_VENDOR |
Fixed vendor associated with the record. |
VARCHAR2 |
10 |
FUND |
Fund associated with the record. |
VARCHAR2 |
10 |
FUNDS_CENTER |
Funds center associated with the record. |
VARCHAR2 |
16 |
GENERAL_CONFIG_MATERIAL |
General config material associated with the record. |
VARCHAR2 |
18 |
GR_IND |
Indicator identifying whether gr (Y/N). |
VARCHAR2 |
1 |
GR_NONVALUED_IND |
Indicator identifying whether gr nonvalued (Y/N). |
VARCHAR2 |
1 |
GR_PROCESSING_TIME |
Time associated with gr processing. |
NUMBER |
3 |
IR_IND |
Indicator identifying whether ir (Y/N). |
VARCHAR2 |
1 |
ITEM_CATEGORY |
Item category associated with the record. |
VARCHAR2 |
1 |
ITEM_DELIVERY_DATE |
Date associated with item delivery. |
DATE |
|
KANBAN_IND |
Indicator identifying whether kanban (Y/N). |
VARCHAR2 |
1 |
LAST_RESUBMISSION_DATE |
Date associated with last resubmission. |
DATE |
|
MATERIAL_CATEGORY |
Material category associated with the record. |
VARCHAR2 |
1 |
MATERIAL_GROUP |
Material group associated with the record. |
VARCHAR2 |
9 |
MATERIAL_NUMBER_1 |
Material number 1 associated with the record. |
VARCHAR2 |
18 |
MATERIAL_NUMBER_2 |
Material number 2 associated with the record. |
VARCHAR2 |
18 |
MRP_CONTROLLER |
Mrp controller associated with the record. |
VARCHAR2 |
3 |
NUMBER_OF_RESUBMISSIONS |
Number of resubmissions associated with the record. |
VARCHAR2 |
8 |
ORDER_QUANTITY |
Order quantity associated with the record. |
NUMBER |
13,3 |
ORDER_UNIT |
Order unit associated with the record. |
VARCHAR2 |
3 |
PACKAGE_NUMBER |
Package number associated with the record. |
VARCHAR2 |
10 |
PARTIAL_INVOICE_IND |
Indicator identifying whether partial invoice (Y/N). |
VARCHAR2 |
1 |
PLANT |
Plant associated with the record. |
VARCHAR2 |
4 |
PO_PRICE_IND |
Indicator identifying whether po price (Y/N). |
VARCHAR2 |
1 |
PRICE_UNIT |
Price unit associated with the record. |
NUMBER |
5 |
PROCESSING_STATUS |
Processing status associated with the record. |
VARCHAR2 |
1 |
PROD_VERSION |
Prod version associated with the record. |
VARCHAR2 |
4 |
PURCHASE_ORDER_DATE |
Date associated with purchase order. |
DATE |
|
PURCHASE_ORDER_ITEM_NUMBER |
Purchase order item number associated with the record. |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the record. |
VARCHAR2 |
10 |
PURCHASING_DOC_CATEGORY_2 |
Purchasing doc category 2 associated with the record. |
VARCHAR2 |
1 |
PURCHASING_GROUP |
Purchasing group associated with the record. |
VARCHAR2 |
3 |
PURCHASING_INFO_RECORD_NUMBER |
Purchasing info record number associated with the record. |
VARCHAR2 |
10 |
PURCHASING_ORG |
Purchasing org associated with the record. |
VARCHAR2 |
4 |
QUOTA_ITEM_NUMBER |
Quota item number associated with the record. |
NUMBER |
3 |
QUOTA_NUMBER |
Quota number associated with the record. |
VARCHAR2 |
10 |
RELEASE_COMPLETE_IND |
Indicator identifying whether release complete (Y/N). |
VARCHAR2 |
1 |
RELEASE_DATE |
Date associated with release. |
DATE |
|
RELEASE_GROUP |
Release group associated with the record. |
VARCHAR2 |
2 |
RELEASE_INDICATOR |
Indicator identifying whether release (Y/N). |
VARCHAR2 |
1 |
RELEASE_STATUS |
Release status associated with the record. |
VARCHAR2 |
8 |
RELEASE_STRATEGY |
Release strategy associated with the record. |
VARCHAR2 |
2 |
REQUIREMENT_TRACKING_NUMBER |
Requirement tracking number associated with the record. |
VARCHAR2 |
10 |
REQUISITIONER |
Requisitioner associated with the record. |
VARCHAR2 |
20 |
REQUISITION_ITEM_NUMBER |
Requisition item number associated with the record. |
NUMBER |
5 |
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
10 |
REQ_CLOSED_IND |
Indicator identifying whether req closed (Y/N). |
VARCHAR2 |
1 |
REQ_DATE |
Date associated with req. |
DATE |
|
REQ_FIXED_IND |
Indicator identifying whether req fixed (Y/N). |
VARCHAR2 |
1 |
REQ_QUANTITY |
Req quantity associated with the record. |
NUMBER |
13,3 |
REQ_UOM |
Req uom associated with the record. |
VARCHAR2 |
10 |
RESERVATION_NUMBER |
Reservation number associated with the record. |
NUMBER |
10 |
RESUBMISSION_INTERVAL |
Resubmission interval associated with the record. |
NUMBER |
3 |
RETAIL_PROMOTION |
Retail promotion associated with the record. |
VARCHAR2 |
10 |
REV_LEVEL |
Rev level associated with the record. |
VARCHAR2 |
2 |
SETTLEMENT_RES_ITEM_NUMBER |
Settlement res item number associated with the record. |
NUMBER |
4 |
SETTLEMENT_RES_NUMBER |
Settlement res number associated with the record. |
VARCHAR2 |
10 |
SHORTAGE_QUANTITY |
Shortage quantity associated with the record. |
NUMBER |
13,3 |
SHORT_TEXT |
Short text associated with the record. |
VARCHAR2 |
200 |
SPECIAL_STOCK_IND |
Indicator identifying whether special stock (Y/N). |
VARCHAR2 |
1 |
SPECIAL_STOCK_TRANSFER_IND |
Indicator identifying whether special stock transfer (Y/N). |
VARCHAR2 |
1 |
STORAGE_LOCATION |
Storage location associated with the record. |
VARCHAR2 |
4 |
SUPPLYING_PLANT |
Supplying plant associated with the record. |
VARCHAR2 |
4 |
UNIT_PRICE |
Unit price associated with the record. |
NUMBER |
11,2 |
VALUATION_TYPE |
Valuation type associated with the record. |
VARCHAR2 |
10 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |