| Worksheet Template Name |
Code[10] |
|
| Journal Batch Name |
Code[10] |
|
| Line No. |
Integer |
|
| Type |
Option |
OptionMembers: ,G/L Account,Item |
| No. |
Code[20] |
|
| Description |
Text[100] |
|
| Description 2 |
Text[50] |
|
| Quantity |
Decimal |
|
| Vendor No. |
Code[20] |
|
| Direct Unit Cost |
Decimal |
|
| Due Date |
Date |
|
| Requester ID |
Code[50] |
|
| Confirmed |
Boolean |
|
| Shortcut Dimension 1 Code |
Code[20] |
|
| Shortcut Dimension 2 Code |
Code[20] |
|
| Location Code |
Code[10] |
|
| Recurring Method |
Option |
OptionMembers: ,Fixed,Variable |
| Expiration Date |
Date |
|
| Recurring Frequency |
DateFormula |
|
| Order Date |
Date |
|
| Vendor Item No. |
Text[50] |
|
| Sales Order No. |
Code[20] |
|
| Sales Order Line No. |
Integer |
|
| Sell-to Customer No. |
Code[20] |
|
| Ship-to Code |
Code[10] |
|
| Order Address Code |
Code[10] |
|
| Currency Code |
Code[10] |
|
| Currency Factor |
Decimal |
|
| Reserved Quantity |
Decimal |
FlowField |
| Dimension Set ID |
Integer |
|
| Prod. Order No. |
Code[20] |
|
| Variant Code |
Code[10] |
|
| Bin Code |
Code[20] |
|
| Qty. per Unit of Measure |
Decimal |
|
| Unit of Measure Code |
Code[10] |
|
| Quantity (Base) |
Decimal |
|
| Reserved Qty. (Base) |
Decimal |
FlowField |
| Demand Type |
Integer |
|
| Demand Subtype |
Option |
OptionMembers: 0,1,2,3,4,5,6,7,8,9 |
| Demand Order No. |
Code[20] |
|
| Demand Line No. |
Integer |
|
| Demand Ref. No. |
Integer |
|
| Status |
Option |
OptionMembers: 0,1,2,3,4,5,6,7,8,9,10 |
| Demand Date |
Date |
|
| Demand Quantity |
Decimal |
|
| Demand Quantity (Base) |
Decimal |
|
| Needed Quantity |
Decimal |
|
| Needed Quantity (Base) |
Decimal |
|
| Reserve |
Boolean |
|
| Qty. per UOM (Demand) |
Decimal |
|
| Unit Of Measure Code (Demand) |
Code[10] |
|
| Supply From |
Code[20] |
|
| Original Item No. |
Code[20] |
|
| Original Variant Code |
Code[10] |
|
| Level |
Integer |
|
| Demand Qty. Available |
Decimal |
|
| User ID |
Code[50] |
|
| Item Category Code |
Code[20] |
|
| Nonstock |
Boolean |
|
| Purchasing Code |
Code[10] |
|
| Transfer-from Code |
Code[10] |
|
| Transfer Shipment Date |
Date |
|
| Line Discount % |
Decimal |
|
| Discount Reason |
Code[20] |
|
| Qty. Purchase Condition |
Boolean |
FlowField |
| Purchase Order Type |
Code[10] |
|
| KVSMEDDeliveryViaEntryNo |
Integer |
|
| Shipping Contact No. |
Code[20] |
|
| Ship-to Code Contact No. |
Code[10] |
|
| Posting Code |
Code[10] |
|
| Purchaser Code |
Code[20] |
|
| Inventory |
Decimal |
FlowField |
| Line in Requisition |
Boolean |
|
| Quantity modified |
Boolean |
|
| Initial Quantity |
Decimal |
|
| Lot No. (Tracking) |
Code[50] |
FlowField |
| Expiration Date (Tracking) |
Date |
FlowField |
| Range |
Decimal |
|
| Weighted Range |
Decimal |
|
| Open Blanket Order |
Decimal |
|
| Backorder |
Decimal |
|
| Qty. on Purch. Order |
Decimal |
FlowField |
| Inventory in Location |
Decimal |
FlowField |
| Lead Time |
DateFormula |
|
| Base Unit of Measure |
Code[10] |
FlowField |
| Amount |
Decimal |
|
| Cubage |
Decimal |
|
| Weight |
Decimal |
|
| Stock scope in Weeks |
Decimal |
|
| Avg. Positive Adjmt. per week |
Decimal |
|
| Avg. Negative Adjmt. per week |
Decimal |
|
| Price Origin |
Option |
OptionMembers: ,,Pricing,Blanket Order,Manual |
| Line Discount Origin |
Option |
OptionMembers: ,,Pricing,Blanket Order,Manual |
| WarnOption |
Option |
OptionMembers: ,Emergency,Exception,Attention |
| Number of Blanket Order Lines |
Integer |
FlowField |
| Blanket Order No. |
Code[20] |
|
| Blanket Order Line No. |
Integer |
|
| Direct Unit Cost (Price Unit) |
Decimal |
|
| Price Unit |
Decimal |
|
| Subcontracted Item |
Boolean |
|
| Standard Task Code |
Code[10] |
|
| Assigned User ID |
Code[50] |
|
| Generate Quote Request |
Boolean |
|
| Quote Requests exist |
Boolean |
FlowField |
| Order Date (Calc. Req.) |
Date |
|
| To Date (Calc. Req.) |
Date |
|
| Use Forecast (Calc. Req.) |
Code[10] |
|
| Excl. Forec. Bef. (Calc. Req.) |
Date |
|
| Routing No. |
Code[20] |
|
| Operation No. |
Code[10] |
|
| Work Center No. |
Code[20] |
|
| Prod. Order Line No. |
Integer |
|
| MPS Order |
Boolean |
|
| Planning Flexibility |
Option |
OptionMembers: Unlimited,None |
| Routing Reference No. |
Integer |
|
| Gen. Prod. Posting Group |
Code[20] |
|
| Gen. Business Posting Group |
Code[20] |
|
| Low-Level Code |
Integer |
|
| Production BOM Version Code |
Code[20] |
|
| Routing Version Code |
Code[20] |
|
| Routing Type |
Option |
OptionMembers: Serial,Parallel |
| Original Quantity |
Decimal |
|
| Finished Quantity |
Decimal |
|
| Remaining Quantity |
Decimal |
|
| Original Due Date |
Date |
|
| Scrap % |
Decimal |
|
| Starting Date |
Date |
|
| Starting Time |
Time |
|
| Ending Date |
Date |
|
| Ending Time |
Time |
|
| Production BOM No. |
Code[20] |
|
| Indirect Cost % |
Decimal |
|
| Overhead Rate |
Decimal |
|
| Unit Cost |
Decimal |
|
| Cost Amount |
Decimal |
|
| Replenishment System |
Option |
OptionMembers: Purchase,Prod. Order,Transfer,Assembly, |
| Ref. Order No. |
Code[20] |
|
| Ref. Order Type |
Option |
OptionMembers: ,Purchase,Prod. Order,Transfer,Assembly |
| Ref. Order Status |
Option |
OptionMembers: ,Planned,Firm Planned,Released |
| Ref. Line No. |
Integer |
|
| No. Series |
Code[20] |
|
| Expected Operation Cost Amt. |
Decimal |
FlowField |
| Expected Component Cost Amt. |
Decimal |
FlowField |
| Finished Qty. (Base) |
Decimal |
|
| Remaining Qty. (Base) |
Decimal |
|
| Related to Planning Line |
Integer |
|
| Planning Level |
Integer |
|
| Planning Line Origin |
Option |
OptionMembers: ,Action Message,Planning,Order Planning |
| Action Message |
Option |
OptionMembers: ,New,Change Qty.,Reschedule,Resched. & Chg. Qty.,Cancel |
| Accept Action Message |
Boolean |
|
| Net Quantity (Base) |
Decimal |
|
| Starting Date-Time |
DateTime |
|
| Ending Date-Time |
DateTime |
|
| Order Promising ID |
Code[20] |
|
| Order Promising Line No. |
Integer |
|
| Order Promising Line ID |
Integer |
|