The file_orderitem_fs.csv
file is generic and therefore does not support any source Order system-specific features, such as recurring order lines.
Each line in this file will supplement existing E-Business Suite Order Lines with data to populate the following prices:
Order Item Approved Invoice Price
Order Item Approved Pocket Margin
Order Item Approved Pocket Price
Order Item Guideline Invoice Price
Order Item Guideline Pocket Price
Order Item Guideline Pocket Price
Order Item Requested Invoice Price
Order Item Requested Pocket Margin
Order Item Requested Pocket Price
The granularity of this file is each Order Line ID which should be the root Order Line ID in the case of configured products.
Each price above should be the rolled-up price in case of a configured product.
Column Name | Data Type | Sample Data | Description |
---|---|---|---|
INTEGRATION_ID |
VARCHAR2(80) |
344946 |
The INTEGRATION_ID for this file will be the Order Line ID. This should be the root Order Line ID in the case of configured products. |
GLN_INV_PRI |
NUMBER(28,10) |
101.55 |
The sales guideline (price policy) invoice price that was applied to the order. If there was no price exception, this is the same as the actual invoice price. |
GLN_PKT_PRI |
NUMBER(28,10) |
91.534 |
The sales guideline (price policy) pocket price that was applied to the order, or the derived guideline pocket price based on the guideline invoice price. If there was no price exception, this is the same as the actual pocket price. |
GLN_PKT_MARGIN |
NUMBER(28,10) |
30 |
What the pocket margin would have been for the order based on its quantity and the guideline pocket price. If there was no price exception, this is the same as the actual pocket margin. |
REQ_INV_PRI |
NUMBER(28,10) |
1345.12 |
The invoice price that was requested (usually by sales) on the price exception request. If there was no price exception, this is the same as the actual invoice price. |
REQ_PKT_PRI |
NUMBER(28,10) |
122.2 |
The pocket price based on the requested invoice price (usually by sales) on the price exception request. If there was no price exception, this is the same as the actual pocket price. |
REQ_PKT_MARGIN |
NUMBER(28,10) |
1.3 |
What the pocket margin would have been for the order based on its quantity and the requested pocket price. If there was no price exception, this is the same as the actual pocket margin. |
APPR_INV_PRI |
NUMBER(28,10) |
44.44 |
The invoice price that was last approved for the order. If there was no price exception, this is the same as the actual invoice price. |
APPR_PKT_PRI |
NUMBER(28,10) |
22222.2 |
The pocket price that was last approved for the order. If there was no price exception, this is the same as the actual pocket price. |
APPR_PKT_MARGIN |
NUMBER(28,10) |
172222.2 |
What the pocket margin amount would have been on the order the order based on its quantity and the invoice price that was last approved for the order. If there was no price exception, this is the same as the actual pocket margin. |