REQ ITEMS Table
View exposing requisition item detail including release attributes, requisitioner, quantities, prices, plant and material attributes, document type, vendor, and purchase-order conversion detail.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
DATE_CHANGED |
Date changed associated with the record. |
DATE |
|
DOCUMENT_CATEGORY |
Document category associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_TYPE |
Document type associated with the record. |
VARCHAR2 |
4 |
IS_ITEM_RELEASED_FOR_PO |
Indicator identifying whether item released for po (Y/N). |
VARCHAR2 |
1 |
IS_REQUISITION_RELEASED_FOR_PO |
Indicator identifying whether requisition released for po (Y/N). |
VARCHAR2 |
1 |
IS_REQ_CONVERTED_TO_PO |
Indicator identifying whether req converted to po (Y/N). |
VARCHAR2 |
1 |
ITEM_RELEASE_DATE |
Date associated with item release. |
DATE |
|
MATERIAL_GROUP |
Material group associated with the record. |
VARCHAR2 |
9 |
PLANT |
Plant associated with the record. |
VARCHAR2 |
4 |
PRICE_UNIT |
Price unit associated with the record. |
NUMBER |
6 |
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_GROUP |
Purchasing group associated with the record. |
VARCHAR2 |
3 |
RELEASE_INDICATOR |
Indicator identifying whether release (Y/N). |
VARCHAR2 |
1 |
REQUIREMENT_TRACKING_NUMBER |
Requirement tracking number associated with the record. |
VARCHAR2 |
10 |
REQUISITIONER |
Requisitioner associated with the record. |
VARCHAR2 |
12 |
REQUISITION_ITEM_NUMBER |
Requisition item number associated with the record. |
NUMBER |
5 |
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
10 |
REQUISITION_RELEASE_DATE |
Date associated with requisition release. |
DATE |
|
REQ_DATE |
Date associated with req. |
DATE |
|
REQ_QUANTITY |
Req quantity associated with the record. |
NUMBER |
17,3 |
REQ_TO_PO_CONVERSION_DATE |
Date associated with req to po conversion. |
DATE |
|
REQ_UOM |
Req uom associated with the record. |
VARCHAR2 |
3 |
SHORT_TEXT |
Short text associated with the record. |
VARCHAR2 |
45 |
STORAGE_LOCATION |
Storage location associated with the record. |
VARCHAR2 |
4 |
SUPPLYING_PLANT |
Supplying plant associated with the record. |
VARCHAR2 |
4 |
TOTAL_REQUISITION_VALUE |
Total requisition value associated with the record. |
NUMBER |
13,2 |
UNIT_PRICE |
Unit price associated with the record. |
NUMBER |
15,2 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |