REQUISITION DETAIL Table
View exposing purchasing requisition detail by requisition item and account assignment including cost collector, general ledger account, vendor, requisitioner, dates, release indicators, quantities, prices, commitment amounts, purchase-order linkage, plant and material attributes, and accounting assignments.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account assignment number associated with the record. |
NUMBER |
2 |
ACCOUNT_DISTRIBUTION_IND |
Indicator identifying whether account distribution (Y/N). |
VARCHAR2 |
1 |
ACCT_DISTRIBUTION_AMOUNT |
Acct distribution amount associated with the record. |
NUMBER |
16,2 |
ACCT_DISTRIBUTION_PERCENTAGE |
Acct distribution percentage associated with the record. |
NUMBER |
34,17 |
ACCT_DISTRIBUTION_QUANTITY |
Acct distribution quantity associated with the record. |
NUMBER |
13,3 |
ARE_COMMITMENTS_AFFECTED |
Indicator identifying whether commitments affected (Y/N). |
VARCHAR2 |
1 |
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
13,2 |
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
COMMITMENT_QUANTITY |
Commitment quantity associated with the record. |
NUMBER |
17,3 |
CONSUMPTION_POSTING_IND |
Indicator identifying whether consumption posting (Y/N). |
VARCHAR2 |
1 |
CONTROLLING_AREA |
Controlling area associated with the record. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CURRENCY |
Currency associated with the record. |
VARCHAR2 |
5 |
DATE_CHANGED |
Date changed associated with the record. |
DATE |
|
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 |
FUND |
Fund associated with the record. |
VARCHAR2 |
10 |
FUND_CENTER |
Fund center associated with the record. |
VARCHAR2 |
16 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
Goods recipient associated with the record. |
VARCHAR2 |
25 |
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 |
IS_ACCOUNT_ASGMT_CHANGEABLE |
Indicator identifying whether account asgmt changeable (Y/N). |
VARCHAR2 |
1 |
IS_ITEM_RELEASED_FOR_PO |
Indicator identifying whether item released for po (Y/N). |
VARCHAR2 |
1 |
IS_RELEASE_COMPLETE |
Indicator identifying whether release complete (Y/N). |
VARCHAR2 |
1 |
IS_REQUISITION_CLOSED |
Indicator identifying whether requisition closed (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_AMOUNT |
Item amount associated with the record. |
NUMBER |
31,11 |
ITEM_DELIVERY_DATE |
Date associated with item delivery. |
DATE |
|
ITEM_PRICE_UNIT |
Item price unit associated with the record. |
NUMBER |
5 |
ITEM_QUANTITY |
Item quantity associated with the record. |
NUMBER |
13,3 |
ITEM_RELEASE_DATE |
Date associated with item release. |
DATE |
|
ITEM_TEXT_LINE_2 |
Item text line 2 associated with the record. |
VARCHAR2 |
140 |
ITEM_UNIT_PRICE |
Item unit price associated with the record. |
NUMBER |
11,2 |
ITEM_UOM |
Item uom associated with the record. |
VARCHAR2 |
10 |
MATERIAL_GROUP |
Material group associated with the record. |
VARCHAR2 |
9 |
ORDER_QUANTITY |
Order quantity associated with the record. |
NUMBER |
13,3 |
PARTIAL_INVOICE_IND |
Indicator identifying whether partial invoice (Y/N). |
VARCHAR2 |
1 |
PLANT |
Plant associated with the record. |
VARCHAR2 |
4 |
PLANT_KEY |
Surrogate key identifying the plant. |
VARCHAR2 |
4 |
PROCESSING_STATUS |
Processing status associated with the record. |
VARCHAR2 |
1 |
PROFIT_CENTER |
Profit center associated with the record. |
VARCHAR2 |
10 |
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_KEY |
Surrogate key identifying the purchasing group. |
VARCHAR2 |
3 |
PURCHASING_ORG_KEY |
Surrogate key identifying the purchasing org. |
VARCHAR2 |
4 |
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_DATE |
Date associated with requisition. |
DATE |
|
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_TO_PO_CONVERSION_DATE |
Date associated with req to po conversion. |
DATE |
|
SHORT_TEXT |
Short text associated with the record. |
VARCHAR2 |
80 |
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 |
UNLOADING_POINT |
Unloading point associated with the record. |
VARCHAR2 |
80 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VENDOR_MATERIAL_NUMBER |
Vendor material number associated with the record. |
VARCHAR2 |
35 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |