| Worksheet Template Name | Code[10] | |
| Journal Batch Name | Code[10] | |
| Line No. | Integer | |
| Type | Enum Purchase Line Type | |
| 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 | Enum (KVSMTCSourceSubtype) | |
| Demand Order No. | Code[20] | |
| Demand Line No. | Integer | |
| Demand Ref. No. | Integer | |
| Status | Enum (KVSMTCSourceSubtype) | |
| 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 | |
| Purchase Order Type | Code[10] | |
| KVSMTCDeliveryViaEntryNo | 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 | |
| RoutingNo | Code[20] | |
| OperationNo | Code[10] | |
| WorkCenterNo | Code[20] | |
| ProdOrderLineNo | Integer | |
| MPSOrder | Boolean | |
| PlanningFlexibility | Option | OptionMembers: Unlimited,None |
| RoutingReferenceNo | Integer | |
| GenProdPostingGroup | Code[20] | |
| GenBusinessPostingGroup | Code[20] | |
| LowLevelCode | Integer | |
| ProdBOMVersionCode | Code[20] | |
| RoutingVersionCode | Code[20] | |
| RoutingType | Option | OptionMembers: Serial,Parallel |
| OriginalQuantity | Decimal | |
| FinishedQuantity | Decimal | |
| RemainingQuantity | Decimal | |
| OriginalDueDate | Date | |
| ScrapInPercent | Decimal | |
| StartingDate | Date | |
| StartingTime | Time | |
| EndingDate | Date | |
| EndingTime | Time | |
| ProductionBOMNo | Code[20] | |
| IndirectCostInPercent | Decimal | |
| OverheadRate | Decimal | |
| UnitCost | Decimal | |
| CostAmount | Decimal | |
| ReplenishmentSystem | Option | OptionMembers: Purchase,Prod. Order,Transfer,Assembly, |
| RefOrderNo | Code[20] | |
| RefOrderType | Option | OptionMembers: ,Purchase,Prod. Order,Transfer,Assembly |
| RefOrderStatus | Option | OptionMembers: ,Planned,Firm Planned,Released |
| RefLineNo | Integer | |
| NoSeries | Code[20] | |
| ExpectedOperationCostAmt | Decimal | FlowField |
| ExpectedComponentCostAmt | Decimal | FlowField |
| FinishedQtyBase | Decimal | |
| RemainingQtyBase | Decimal | |
| RelatedToPlanningLine | Integer | |
| PlanningLevel | Integer | |
| PlanningLineOrigin | Option | OptionMembers: ,Action Message,Planning,Order Planning |
| ActionMessage | Option | OptionMembers: ,New,Change Qty.,Reschedule,Resched. & Chg. Qty.,Cancel |
| AcceptActionMessage | Boolean | |
| NetQuantityBase | Decimal | |
| StartingDateTime | DateTime | |
| EndingDateTime | DateTime | |
| OrderPromisingID | Code[20] | |
| OrderPromisingLineNo | Integer | |
| OrderPromisingLineID | Integer | |