REQUISITION DETAIL Table
Purchasing requisition information
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account distribution assignment serial number. This number identifies a single account distribution for a line item. |
NUMBER |
22 |
ACCOUNT_DISTRIBUTION_IND |
XXX |
VARCHAR2 |
1 |
ACCT_DISTRIBUTION_AMOUNT |
XXX |
NUMBER |
22 |
ACCT_DISTRIBUTION_PERCENTAGE |
The percentage of the line item value which has been assigned to a particular cost collector/GL account. The percentage values of the account distributions for a given PO line item will total 100. |
NUMBER |
22 |
ACCT_DISTRIBUTION_QUANTITY |
XXX |
NUMBER |
22 |
ARE_COMMITMENTS_AFFECTED |
XXX |
VARCHAR2 |
1 |
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
11 |
COMMITMENT_ITEM |
In SAP's FM module, expenses are classified by "commitment item", not G/L account. Each G/L account in SAP's CO module maps to a "commitment item" in the FM module. There are many fewer commitment items that G/L accounts. FM's commitment items represent a more summarized view of expense types. |
VARCHAR2 |
14 |
COMMITMENT_QUANTITY |
Quantity of material for an open commitment. |
NUMBER |
22 |
CONSUMPTION_POSTING_IND |
XXX |
VARCHAR2 |
1 |
CONTROLLING_AREA |
XXX |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CREATED_BY |
User account or user name of the person who created the record. |
VARCHAR2 |
12 |
CURRENCY |
XXX |
VARCHAR2 |
5 |
DATE_CHANGED |
XXX |
DATE |
8 |
DELIVERY_DATE_CATEGORY |
XXX |
VARCHAR2 |
1 |
DESIRED_VENDOR |
XXX |
VARCHAR2 |
10 |
DOCUMENT_CATEGORY |
XXX |
VARCHAR2 |
1 |
DOCUMENT_TYPE |
XXX |
VARCHAR2 |
2 |
FUND |
XXX |
VARCHAR2 |
10 |
FUND_CENTER |
XXX |
VARCHAR2 |
16 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
The person or group who will receive the goods. |
VARCHAR2 |
12 |
GR_IND |
XXX |
VARCHAR2 |
1 |
GR_NONVALUED_IND |
XXX |
VARCHAR2 |
1 |
GR_PROCESSING_TIME |
XXX |
NUMBER |
22 |
IR_IND |
XXX |
VARCHAR2 |
1 |
IS_ACCOUNT_ASGMT_CHANGEABLE |
XXX |
VARCHAR2 |
1 |
IS_ITEM_RELEASED_FOR_PO |
XXX |
VARCHAR2 |
1 |
IS_RELEASE_COMPLETE |
XXX |
VARCHAR2 |
1 |
IS_REQUISITION_CLOSED |
XXX |
VARCHAR2 |
1 |
IS_REQUISITION_RELEASED_FOR_PO |
XXX |
VARCHAR2 |
1 |
IS_REQ_CONVERTED_TO_PO |
XXX |
VARCHAR2 |
1 |
ITEM_AMOUNT |
The dollar value of a purchase order line item. In most cases, equates to Ordered Quantity multiplied by Unit Price |
NUMBER |
22 |
ITEM_DELIVERY_DATE |
XXX |
DATE |
8 |
ITEM_PRICE_UNIT |
Indicates what "unit" the Unit Price on a PO Line Item refers to. Usually equal to 1. |
VARCHAR2 |
6 |
ITEM_QUANTITY |
Ordered Quantity on a PO Line Item |
NUMBER |
22 |
ITEM_RELEASE_DATE |
XXX |
DATE |
8 |
ITEM_TEXT_LINE_2 |
XXX |
VARCHAR2 |
132 |
ITEM_UNIT_PRICE |
Unit Price on a PO Line Item |
NUMBER |
22 |
ITEM_UOM |
XXX |
VARCHAR2 |
3 |
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 |
ORDER_QUANTITY |
XXX |
NUMBER |
22 |
PARTIAL_INVOICE_IND |
XXX |
VARCHAR2 |
1 |
PLANT |
The plant code associated with the PO line item. |
VARCHAR2 |
4 |
PLANT_KEY |
XXX |
VARCHAR2 |
4 |
PROCESSING_STATUS |
XXX |
VARCHAR2 |
1 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
7 |
PURCHASE_ORDER_DATE |
XXX |
DATE |
8 |
PURCHASE_ORDER_ITEM_NUMBER |
XXX |
NUMBER |
22 |
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
10 |
PURCHASING_GROUP_KEY |
Key identifying a Purchasing Group. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
3 |
PURCHASING_ORG_KEY |
Key identifying a Purchasing Organization. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
4 |
RELEASE_DATE |
XXXX |
DATE |
8 |
RELEASE_GROUP |
XXX |
VARCHAR2 |
2 |
RELEASE_INDICATOR |
XXX |
VARCHAR2 |
1 |
RELEASE_STATUS |
XXX |
VARCHAR2 |
8 |
RELEASE_STRATEGY |
XXX |
VARCHAR2 |
2 |
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_DATE |
XXX |
DATE |
8 |
REQUISITION_ITEM_NUMBER |
XXX |
NUMBER |
22 |
REQUISITION_NUMBER |
Purchase Requisition Document Number |
VARCHAR2 |
10 |
REQUISITION_RELEASE_DATE |
XXX |
DATE |
8 |
REQ_TO_PO_CONVERSION_DATE |
XXX |
DATE |
8 |
SHORT_TEXT |
XXX |
VARCHAR2 |
30 |
STORAGE_LOCATION |
XXX |
VARCHAR2 |
4 |
SUPPLYING_PLANT |
XXX |
VARCHAR2 |
4 |
TOTAL_REQUISITION_VALUE |
XXX |
NUMBER |
22 |
UNLOADING_POINT |
The location to which the goods should be delivered. |
VARCHAR2 |
25 |
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 |
VENDOR_MATERIAL_NUMBER |
XXX |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |