REQ ITEMS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATED_BY |
User account or user name of the person who created the record. |
VARCHAR2 |
12 |
DATE_CHANGED |
XXX |
DATE |
|
DOCUMENT_CATEGORY |
XXX |
VARCHAR2 |
1 |
DOCUMENT_TYPE |
XXX |
VARCHAR2 |
4 |
IS_ITEM_RELEASED_FOR_PO |
XXX |
VARCHAR2 |
1 |
IS_REQUISITION_RELEASED_FOR_PO |
XXX |
VARCHAR2 |
1 |
IS_REQ_CONVERTED_TO_PO |
XXX |
VARCHAR2 |
1 |
ITEM_RELEASE_DATE |
XXX |
DATE |
|
MATERIAL_GROUP |
A code, usually four digit, defining a Material Group for Purchase Orders to enable reporting by Material Group categories. See also Material Group Description: this latter field gives the text name of the material group defined by the code. |
VARCHAR2 |
9 |
PLANT |
The plant code associated with the PO line item. |
VARCHAR2 |
4 |
PRICE_UNIT |
XXX |
NUMBER |
6 |
PURCHASE_ORDER_DATE |
XXX |
DATE |
|
PURCHASE_ORDER_ITEM_NUMBER |
XXX |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
10 |
PURCHASING_GROUP |
Code identifying a Purchasing Group. |
VARCHAR2 |
3 |
RELEASE_INDICATOR |
XXX |
VARCHAR2 |
1 |
REQUIREMENT_TRACKING_NUMBER |
Entered on a Purchasing Requisition and copied to subsequent Purchase Orders. Enables grouping of Purchasing Documents by Material Requirement |
VARCHAR2 |
10 |
REQUISITIONER |
Person who originated a Purchase Requisition |
VARCHAR2 |
12 |
REQUISITION_ITEM_NUMBER |
XXX |
NUMBER |
5 |
REQUISITION_NUMBER |
Purchase Requisition Document Number |
VARCHAR2 |
10 |
REQUISITION_RELEASE_DATE |
XXX |
DATE |
|
REQ_DATE |
XXX |
DATE |
|
REQ_QUANTITY |
XXX |
NUMBER |
17,3 |
REQ_TO_PO_CONVERSION_DATE |
XXX |
DATE |
|
REQ_UOM |
XXX |
VARCHAR2 |
3 |
SHORT_TEXT |
XXX |
VARCHAR2 |
45 |
STORAGE_LOCATION |
XXX |
VARCHAR2 |
4 |
SUPPLYING_PLANT |
XXX |
VARCHAR2 |
4 |
TOTAL_REQUISITION_VALUE |
XXX |
NUMBER |
13,2 |
UNIT_PRICE |
Cost associated with each piece counted in NUMBER_OF_UNITS, converted to USD. For Serial orders, this is always $.01. (Z68-UNIT-PRICE converted to USD) |
NUMBER |
15,2 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |