| 1 PK | No. | Code20 | |
| 2 | No. 2 | Code20 | |
| 3 | Description | Text50 | |
| 4 | Search Description | Code50 | - CaptionML
ENU=Search Description
|
| 5 | Description 2 | Text50 | - CaptionML
ENU=Description 2
|
| 6 | Assembly BOM | Boolean | NotEditableFlowField CalcFormula Exist("BOM Component" WHERE (Parent Item No.=FIELD(No.))) - CaptionML
ENU=Assembly BOM
|
| 8 | Base Unit of Measure | Code10 | - CaptionML
ENU=Base Unit of Measure
|
| 9 | Price Unit Conversion | Integer | - CaptionML
ENU=Price Unit Conversion
|
| 10 | Type | Option | - OptionCaptionML
ENU=Inventory,Service - OptionString
[Inventory,Service]
|
| 11 | Inventory Posting Group | Code20 | TableRelation "Inventory Posting Group" - CaptionML
ENU=Inventory Posting Group
|
| 12 | Shelf No. | Code10 | |
| 14 | Item Disc. Group | Code20 | TableRelation "Item Discount Group" - CaptionML
ENU=Item Disc. Group
|
| 15 | Allow Invoice Disc. | Boolean | - CaptionML
ENU=Allow Invoice Disc.
|
| 16 | Statistics Group | Integer | - CaptionML
ENU=Statistics Group
|
| 17 | Commission Group | Integer | - CaptionML
ENU=Commission Group
|
| 18 | Unit Price | Decimal | |
| 19 | Price/Profit Calculation | Option | - CaptionML
ENU=Price/Profit Calculation - OptionCaptionML
ENU="Profit=Price-Cost,Price=Cost+Profit,No Relationship" - OptionString
[Profit=Price-Cost,Price=Cost+Profit,No Relationship]
|
| 20 | Profit % | Decimal | |
| 21 | Costing Method | Option | - CaptionML
ENU=Costing Method - OptionCaptionML
ENU=FIFO,LIFO,Specific,Average,Standard - OptionString
[FIFO,LIFO,Specific,Average,Standard]
|
| 22 | Unit Cost | Decimal | |
| 24 | Standard Cost | Decimal | - CaptionML
ENU=Standard Cost
|
| 25 | Last Direct Cost | Decimal | - CaptionML
ENU=Last Direct Cost
|
| 28 | Indirect Cost % | Decimal | - CaptionML
ENU=Indirect Cost %
|
| 29 | Cost is Adjusted | Boolean | NotEditable - CaptionML
ENU=Cost is Adjusted
|
| 30 | Allow Online Adjustment | Boolean | NotEditable - CaptionML
ENU=Allow Online Adjustment
|
| 31 | Vendor No. | Code20 | |
| 32 | Vendor Item No. | Text20 | - CaptionML
ENU=Vendor Item No.
|
| 33 | Lead Time Calculation | DateFormula | - CaptionML
ENU=Lead Time Calculation - AccessByPermission
TableData 120=R
|
| 34 | Reorder Point | Decimal | - CaptionML
ENU=Reorder Point - AccessByPermission
TableData 244=R
|
| 35 | Maximum Inventory | Decimal | - CaptionML
ENU=Maximum Inventory - AccessByPermission
TableData 244=R
|
| 36 | Reorder Quantity | Decimal | - CaptionML
ENU=Reorder Quantity - AccessByPermission
TableData 244=R
|
| 37 | Alternative Item No. | Code20 | - CaptionML
ENU=Alternative Item No.
|
| 38 | Unit List Price | Decimal | - CaptionML
ENU=Unit List Price
|
| 39 | Duty Due % | Decimal | |
| 40 | Duty Code | Code10 | |
| 41 | Gross Weight | Decimal | - CaptionML
ENU=Gross Weight
|
| 42 | Net Weight | Decimal | |
| 43 | Units per Parcel | Decimal | - CaptionML
ENU=Units per Parcel
|
| 44 | Unit Volume | Decimal | |
| 45 | Durability | Code10 | |
| 46 | Freight Type | Code10 | - CaptionML
ENU=Freight Type
|
| 47 | Tariff No. | Code20 | |
| 48 | Duty Unit Conversion | Decimal | - CaptionML
ENU=Duty Unit Conversion
|
| 49 | Country/Region Purchased Code | Code10 | TableRelation Country/Region - CaptionML
ENU=Country/Region Purchased Code
|
| 50 | Budget Quantity | Decimal | - CaptionML
ENU=Budget Quantity
|
| 51 | Budgeted Amount | Decimal | - CaptionML
ENU=Budgeted Amount
|
| 52 | Budget Profit | Decimal | - CaptionML
ENU=Budget Profit
|
| 53 | Comment | Boolean | NotEditableFlowField CalcFormula Exist("Comment Line" WHERE (Table Name=CONST(Item),
No.=FIELD(No.)));
|
| 54 | Blocked | Boolean | |
| 55 | Cost is Posted to G/L | Boolean | NotEditableFlowField CalcFormula -Exist("Post Value Entry to G/L" WHERE (Item No.=FIELD(No.))) - CaptionML
ENU=Cost is Posted to G/L
|
| 56 | Block Reason | Text250 | - CaptionML
ENU=Block Reason
|
| 61 | Last DateTime Modified | DateTime | NotEditable - CaptionML
ENU=Last DateTime Modified
|
| 62 | Last Date Modified | Date | NotEditable - CaptionML
ENU=Last Date Modified
|
| 63 | Last Time Modified | Time | NotEditable - CaptionML
ENU=Last Time Modified
|
| 64 | Date Filter | Date | |
| 65 | Global Dimension 1 Filter | Code20 | FlowFilter TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1)) - CaptionML
ENU=Global Dimension 1 Filter
|
| 66 | Global Dimension 2 Filter | Code20 | FlowFilter TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2)) - CaptionML
ENU=Global Dimension 2 Filter
|
| 67 | Location Filter | Code10 | FlowFilter - CaptionML
ENU=Location Filter
|
| 68 | Inventory | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter)));
|
| 69 | Net Invoiced Qty. | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter))); - CaptionML
ENU=Net Invoiced Qty.
|
| 70 | Net Change | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Posting Date=FIELD(Date Filter),
Variant Code=FIELD(Variant Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter)));
|
| 71 | Purchases (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Entry Type=CONST(Purchase),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter))); - CaptionML
ENU=Purchases (Qty.)
|
| 72 | Sales (Qty.) | Decimal | NotEditableFlowField CalcFormula -Sum("Value Entry"."Invoiced Quantity" WHERE (Item Ledger Entry Type=CONST(Sale),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter))); - CaptionML
ENU=Sales (Qty.)
|
| 73 | Positive Adjmt. (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Entry Type=CONST(Positive Adjmt.),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter))); - CaptionML
ENU=Positive Adjmt. (Qty.)
|
| 74 | Negative Adjmt. (Qty.) | Decimal | NotEditableFlowField CalcFormula -Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Entry Type=CONST(Negative Adjmt.),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter))); - CaptionML
ENU=Negative Adjmt. (Qty.)
|
| 77 | Purchases (LCY) | Decimal | NotEditableFlowField CalcFormula Sum("Value Entry"."Purchase Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Purchase),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter))); - CaptionML
ENU=Purchases (LCY)
|
| 78 | Sales (LCY) | Decimal | NotEditableFlowField CalcFormula Sum("Value Entry"."Sales Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Sale),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter)));
|
| 79 | Positive Adjmt. (LCY) | Decimal | NotEditableFlowField CalcFormula Sum("Value Entry"."Cost Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Positive Adjmt.),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter))); - CaptionML
ENU=Positive Adjmt. (LCY)
|
| 80 | Negative Adjmt. (LCY) | Decimal | NotEditableFlowField CalcFormula Sum("Value Entry"."Cost Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Negative Adjmt.),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter))); - CaptionML
ENU=Negative Adjmt. (LCY)
|
| 83 | COGS (LCY) | Decimal | NotEditableFlowField CalcFormula -Sum("Value Entry"."Cost Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Sale),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter)));
|
| 84 | Qty. on Purch. Order | Decimal | NotEditableFlowField CalcFormula Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Purch. Order - AccessByPermission
TableData 120=R
|
| 85 | Qty. on Sales Order | Decimal | NotEditableFlowField CalcFormula Sum("Sales Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Sales Order - AccessByPermission
TableData 110=R
|
| 87 | Price Includes VAT | Boolean | - CaptionML
ENU=Price Includes VAT
|
| 89 | Drop Shipment Filter | Boolean | FlowFilter - CaptionML
ENU=Drop Shipment Filter - AccessByPermission
TableData 223=R
|
| 90 | VAT Bus. Posting Gr. (Price) | Code20 | TableRelation "VAT Business Posting Group" - CaptionML
ENU=VAT Bus. Posting Gr. (Price)
|
| 91 | Gen. Prod. Posting Group | Code20 | TableRelation "Gen. Product Posting Group" - CaptionML
ENU=Gen. Prod. Posting Group
|
| 92 | Picture | MediaSet | |
| 93 | Transferred (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Item Ledger Entry"."Invoiced Quantity" WHERE (Entry Type=CONST(Transfer),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter))); - CaptionML
ENU=Transferred (Qty.)
|
| 94 | Transferred (LCY) | Decimal | NotEditableFlowField CalcFormula Sum("Value Entry"."Sales Amount (Actual)" WHERE (Item Ledger Entry Type=CONST(Transfer),
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Posting Date=FIELD(Date Filter))); - CaptionML
ENU=Transferred (LCY)
|
| 95 | Country/Region of Origin Code | Code10 | TableRelation Country/Region - CaptionML
ENU=Country/Region of Origin Code
|
| 96 | Automatic Ext. Texts | Boolean | - CaptionML
ENU=Automatic Ext. Texts
|
| 97 | No. Series | Code20 | NotEditable TableRelation "No. Series"
|
| 98 | Tax Group Code | Code20 | TableRelation "Tax Group" - CaptionML
ENU=Tax Group Code
|
| 99 | VAT Prod. Posting Group | Code20 | TableRelation "VAT Product Posting Group" - CaptionML
ENU=VAT Prod. Posting Group
|
| 100 | Reserve | Option | - OptionCaptionML
ENU=Never,Optional,Always - OptionString
[Never,Optional,Always] - AccessByPermission
TableData 120=R
|
| 101 | Reserved Qty. on Inventory | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(32),
Source Subtype=CONST(0),
Reservation Status=CONST(Reservation),
Serial No.=FIELD(Serial No. Filter),
Lot No.=FIELD(Lot No. Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter))); - CaptionML
ENU=Reserved Qty. on Inventory - AccessByPermission
TableData 120=R
|
| 102 | Reserved Qty. on Purch. Orders | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(39),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Reserved Qty. on Purch. Orders - AccessByPermission
TableData 120=R
|
| 103 | Reserved Qty. on Sales Orders | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(37),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Reserved Qty. on Sales Orders - AccessByPermission
TableData 110=R
|
| 105 | Global Dimension 1 Code | Code20 | TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1)) - CaptionML
ENU=Global Dimension 1 Code
|
| 106 | Global Dimension 2 Code | Code20 | TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2)) - CaptionML
ENU=Global Dimension 2 Code
|
| 107 | Res. Qty. on Outbound Transfer | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(5741),
Source Subtype=CONST(0),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Outbound Transfer - AccessByPermission
TableData 5740=R
|
| 108 | Res. Qty. on Inbound Transfer | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(5741),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Inbound Transfer - AccessByPermission
TableData 5740=R
|
| 109 | Res. Qty. on Sales Returns | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(37),
Source Subtype=CONST(5),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Sales Returns - AccessByPermission
TableData 6660=R
|
| 110 | Res. Qty. on Purch. Returns | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(39),
Source Subtype=CONST(5),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Purch. Returns - AccessByPermission
TableData 6650=R
|
| 120 | Stockout Warning | Option | - CaptionML
ENU=Stockout Warning - OptionCaptionML
ENU=Default,No,Yes - OptionString
[Default,No,Yes]
|
| 121 | Prevent Negative Inventory | Option | - CaptionML
ENU=Prevent Negative Inventory - OptionCaptionML
ENU=Default,No,Yes - OptionString
[Default,No,Yes]
|
| 200 | Cost of Open Production Orders | Decimal | FlowField CalcFormula Sum("Prod. Order Line"."Cost Amount" WHERE (Status=FILTER(Planned|Firm Planned|Released),
Item No.=FIELD(No.))); - CaptionML
ENU=Cost of Open Production Orders
|
| 521 | Application Wksh. User ID | Code128 | - CaptionML
ENU=Application Wksh. User ID
|
| 910 | Assembly Policy | Option | - CaptionML
ENU=Assembly Policy - OptionCaptionML
ENU=Assemble-to-Stock,Assemble-to-Order - OptionString
[Assemble-to-Stock,Assemble-to-Order] - AccessByPermission
TableData 90=R
|
| 929 | Res. Qty. on Assembly Order | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(900),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Assembly Order - AccessByPermission
TableData 90=R
|
| 930 | Res. Qty. on Asm. Comp. | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(901),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Asm. Comp. - AccessByPermission
TableData 90=R
|
| 977 | Qty. on Assembly Order | Decimal | NotEditableFlowField CalcFormula Sum("Assembly Header"."Remaining Quantity (Base)" WHERE (Document Type=CONST(Order),
Item No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Assembly Order
|
| 978 | Qty. on Asm. Component | Decimal | NotEditableFlowField CalcFormula Sum("Assembly Line"."Remaining Quantity (Base)" WHERE (Document Type=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Asm. Component
|
| 1001 | Qty. on Job Order | Decimal | NotEditableFlowField CalcFormula Sum("Job Planning Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Planning Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Job Order
|
| 1002 | Res. Qty. on Job Order | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(1003),
Source Subtype=CONST(2),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Job Order - AccessByPermission
TableData 167=R
|
| 1217 | GTIN | Code14 | |
| 1700 | Default Deferral Template Code | Code10 | TableRelation "Deferral Template"."Deferral Code" - CaptionML
ENU=Default Deferral Template Code
|
| 5400 | Low-Level Code | Integer | NotEditable - CaptionML
ENU=Low-Level Code
|
| 5401 | Lot Size | Decimal | - AccessByPermission
TableData 5405=R
|
| 5402 | Serial Nos. | Code20 | TableRelation "No. Series"
|
| 5403 | Last Unit Cost Calc. Date | Date | NotEditable - CaptionML
ENU=Last Unit Cost Calc. Date
|
| 5404 | Rolled-up Material Cost | Decimal | NotEditable - CaptionML
ENU=Rolled-up Material Cost
|
| 5405 | Rolled-up Capacity Cost | Decimal | NotEditable - CaptionML
ENU=Rolled-up Capacity Cost
|
| 5407 | Scrap % | Decimal | - AccessByPermission
TableData 5405=R
|
| 5409 | Inventory Value Zero | Boolean | - CaptionML
ENU=Inventory Value Zero
|
| 5410 | Discrete Order Quantity | Integer | - CaptionML
ENU=Discrete Order Quantity
|
| 5411 | Minimum Order Quantity | Decimal | - CaptionML
ENU=Minimum Order Quantity - AccessByPermission
TableData 244=R
|
| 5412 | Maximum Order Quantity | Decimal | - CaptionML
ENU=Maximum Order Quantity - AccessByPermission
TableData 244=R
|
| 5413 | Safety Stock Quantity | Decimal | - CaptionML
ENU=Safety Stock Quantity - AccessByPermission
TableData 244=R
|
| 5414 | Order Multiple | Decimal | - CaptionML
ENU=Order Multiple - AccessByPermission
TableData 244=R
|
| 5415 | Safety Lead Time | DateFormula | - CaptionML
ENU=Safety Lead Time - AccessByPermission
TableData 244=R
|
| 5417 | Flushing Method | Option | - CaptionML
ENU=Flushing Method - OptionCaptionML
ENU=Manual,Forward,Backward,Pick + Forward,Pick + Backward - OptionString
[Manual,Forward,Backward,Pick + Forward,Pick + Backward] - AccessByPermission
TableData 5405=R
|
| 5419 | Replenishment System | Option | - CaptionML
ENU=Replenishment System - OptionCaptionML
ENU=Purchase,Prod. Order,,Assembly - OptionString
[Purchase,Prod. Order,,Assembly] - AccessByPermission
TableData 244=R
|
| 5420 | Scheduled Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=FILTER(Firm Planned|Released),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Scheduled Receipt (Qty.)
|
| 5421 | Scheduled Need (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Component"."Remaining Qty. (Base)" WHERE (Status=FILTER(Planned..Released),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Scheduled Need (Qty.)
|
| 5422 | Rounding Precision | Decimal | - CaptionML
ENU=Rounding Precision - AccessByPermission
TableData 5405=R
|
| 5423 | Bin Filter | Code20 | FlowFilter TableRelation Bin.Code WHERE (Location Code=FIELD(Location Filter))
|
| 5424 | Variant Filter | Code10 | FlowFilter TableRelation "Item Variant".Code WHERE (Item No.=FIELD(No.)) - CaptionML
ENU=Variant Filter
|
| 5425 | Sales Unit of Measure | Code10 | TableRelation IF (No.=FILTER(<>'')) "Item Unit of Measure".Code WHERE (Item No.=FIELD(No.))
ELSE "Unit of Measure"; - CaptionML
ENU=Sales Unit of Measure
|
| 5426 | Purch. Unit of Measure | Code10 | TableRelation IF (No.=FILTER(<>'')) "Item Unit of Measure".Code WHERE (Item No.=FIELD(No.))
ELSE "Unit of Measure"; - CaptionML
ENU=Purch. Unit of Measure
|
| 5428 | Time Bucket | DateFormula | - AccessByPermission
TableData 244=R
|
| 5429 | Reserved Qty. on Prod. Order | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(5406),
Source Subtype=FILTER(1..3),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Reserved Qty. on Prod. Order - AccessByPermission
TableData 5405=R
|
| 5430 | Res. Qty. on Prod. Order Comp. | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(5407),
Source Subtype=FILTER(1..3),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Prod. Order Comp. - AccessByPermission
TableData 5405=R
|
| 5431 | Res. Qty. on Req. Line | Decimal | NotEditableFlowField CalcFormula Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(246),
Source Subtype=FILTER(0),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Req. Line - AccessByPermission
TableData 244=R
|
| 5440 | Reordering Policy | Option | - CaptionML
ENU=Reordering Policy - OptionCaptionML
ENU=" ,Fixed Reorder Qty.,Maximum Qty.,Order,Lot-for-Lot" - OptionString
[ ,Fixed Reorder Qty.,Maximum Qty.,Order,Lot-for-Lot] - AccessByPermission
TableData 244=R
|
| 5441 | Include Inventory | Boolean | - CaptionML
ENU=Include Inventory - AccessByPermission
TableData 244=R
|
| 5442 | Manufacturing Policy | Option | - CaptionML
ENU=Manufacturing Policy - OptionCaptionML
ENU=Make-to-Stock,Make-to-Order - OptionString
[Make-to-Stock,Make-to-Order] - AccessByPermission
TableData 244=R
|
| 5443 | Rescheduling Period | DateFormula | - CaptionML
ENU=Rescheduling Period - AccessByPermission
TableData 244=R
|
| 5444 | Lot Accumulation Period | DateFormula | - CaptionML
ENU=Lot Accumulation Period - AccessByPermission
TableData 244=R
|
| 5445 | Dampener Period | DateFormula | - CaptionML
ENU=Dampener Period - AccessByPermission
TableData 244=R
|
| 5446 | Dampener Quantity | Decimal | - CaptionML
ENU=Dampener Quantity - AccessByPermission
TableData 244=R
|
| 5447 | Overflow Level | Decimal | - CaptionML
ENU=Overflow Level - AccessByPermission
TableData 244=R
|
| 5449 | Planning Transfer Ship. (Qty). | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Replenishment System=CONST(Transfer),
Type=CONST(Item),
No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Transfer-from Code=FIELD(Location Filter),
Transfer Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Planning Transfer Ship. (Qty).
|
| 5450 | Planning Worksheet (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Planning Line Origin=CONST(Planning),
Type=CONST(Item),
No.=FIELD(No.),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter))); - CaptionML
ENU=Planning Worksheet (Qty.)
|
| 5700 | Stockkeeping Unit Exists | Boolean | NotEditableFlowField CalcFormula Exist("Stockkeeping Unit" WHERE (Item No.=FIELD(No.))) - CaptionML
ENU=Stockkeeping Unit Exists
|
| 5701 | Manufacturer Code | Code10 | TableRelation Manufacturer - CaptionML
ENU=Manufacturer Code
|
| 5702 | Item Category Code | Code20 | TableRelation "Item Category" - CaptionML
ENU=Item Category Code
|
| 5703 | Created From Nonstock Item | Boolean | NotEditable - CaptionML
ENU=Created From Nonstock Item - AccessByPermission
TableData 5718=R
|
| 5704 | Product Group Code | Code10 | "Product Group".Code WHERE (Item Category Code=FIELD(Item Category Code)) - CaptionML
ENU=Product Group Code - ObsoleteReason
Product Groups became first level children of Item Categories.
|
| 5706 | Substitutes Exist | Boolean | NotEditableFlowField CalcFormula Exist("Item Substitution" WHERE (Type=CONST(Item),
No.=FIELD(No.))); - CaptionML
ENU=Substitutes Exist
|
| 5707 | Qty. in Transit | Decimal | NotEditableFlowField CalcFormula Sum("Transfer Line"."Qty. in Transit (Base)" WHERE (Derived From Line No.=CONST(0),
Item No.=FIELD(No.),
Transfer-to Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. in Transit
|
| 5708 | Trans. Ord. Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Transfer Line"."Outstanding Qty. (Base)" WHERE (Derived From Line No.=CONST(0),
Item No.=FIELD(No.),
Transfer-to Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Trans. Ord. Receipt (Qty.)
|
| 5709 | Trans. Ord. Shipment (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Transfer Line"."Outstanding Qty. (Base)" WHERE (Derived From Line No.=CONST(0),
Item No.=FIELD(No.),
Transfer-from Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Trans. Ord. Shipment (Qty.)
|
| 5776 | Qty. Assigned to ship | Decimal | NotEditableFlowField CalcFormula Sum("Warehouse Shipment Line"."Qty. Outstanding (Base)" WHERE (Item No.=FIELD(No.),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. Assigned to ship
|
| 5777 | Qty. Picked | Decimal | NotEditableFlowField CalcFormula Sum("Warehouse Shipment Line"."Qty. Picked (Base)" WHERE (Item No.=FIELD(No.),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter)));
|
| 5900 | Service Item Group | Code10 | TableRelation "Service Item Group".Code - CaptionML
ENU=Service Item Group
|
| 5901 | Qty. on Service Order | Decimal | NotEditableFlowField CalcFormula Sum("Service Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Needed by Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Service Order
|
| 5902 | Res. Qty. on Service Orders | Decimal | NotEditableFlowField CalcFormula -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),
Source Type=CONST(5902),
Source Subtype=CONST(1),
Reservation Status=CONST(Reservation),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Res. Qty. on Service Orders - AccessByPermission
TableData 5900=R
|
| 6500 | Item Tracking Code | Code10 | TableRelation "Item Tracking Code" - CaptionML
ENU=Item Tracking Code
|
| 6501 | Lot Nos. | Code20 | TableRelation "No. Series"
|
| 6502 | Expiration Calculation | DateFormula | - CaptionML
ENU=Expiration Calculation
|
| 6503 | Lot No. Filter | Code20 | FlowFilter - CaptionML
ENU=Lot No. Filter
|
| 6504 | Serial No. Filter | Code20 | FlowFilter - CaptionML
ENU=Serial No. Filter
|
| 6650 | Qty. on Purch. Return | Decimal | NotEditableFlowField CalcFormula Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Return Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Purch. Return - AccessByPermission
TableData 6660=R
|
| 6660 | Qty. on Sales Return | Decimal | NotEditableFlowField CalcFormula Sum("Sales Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Return Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Shipment Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Sales Return - AccessByPermission
TableData 6650=R
|
| 7171 | No. of Substitutes | Integer | NotEditableFlowField CalcFormula Count("Item Substitution" WHERE (Type=CONST(Item),
No.=FIELD(No.))); - CaptionML
ENU=No. of Substitutes
|
| 7300 | Warehouse Class Code | Code10 | TableRelation "Warehouse Class" - CaptionML
ENU=Warehouse Class Code
|
| 7301 | Special Equipment Code | Code10 | TableRelation "Special Equipment" - CaptionML
ENU=Special Equipment Code
|
| 7302 | Put-away Template Code | Code10 | TableRelation "Put-away Template Header" - CaptionML
ENU=Put-away Template Code
|
| 7307 | Put-away Unit of Measure Code | Code10 | TableRelation IF (No.=FILTER(<>'')) "Item Unit of Measure".Code WHERE (Item No.=FIELD(No.))
ELSE "Unit of Measure"; - CaptionML
ENU=Put-away Unit of Measure Code - AccessByPermission
TableData 7340=R
|
| 7380 | Phys Invt Counting Period Code | Code10 | TableRelation "Phys. Invt. Counting Period" - CaptionML
ENU=Phys Invt Counting Period Code
|
| 7381 | Last Counting Period Update | Date | NotEditable - CaptionML
ENU=Last Counting Period Update - AccessByPermission
TableData 7380=R
|
| 7383 | Last Phys. Invt. Date | Date | NotEditableFlowField CalcFormula Max("Phys. Inventory Ledger Entry"."Posting Date" WHERE (Item No.=FIELD(No.),
Phys Invt Counting Period Type=FILTER(' '|Item))); - CaptionML
ENU=Last Phys. Invt. Date
|
| 7384 | Use Cross-Docking | Boolean | - CaptionML
ENU=Use Cross-Docking - AccessByPermission
TableData 7302=R
|
| 7385 | Next Counting Start Date | Date | NotEditable - CaptionML
ENU=Next Counting Start Date
|
| 7386 | Next Counting End Date | Date | NotEditable - CaptionML
ENU=Next Counting End Date
|
| 7700 | Identifier Code | Code20 | NotEditableFlowField CalcFormula Lookup("Item Identifier".Code WHERE (Item No.=FIELD(No.))) - CaptionML
ENU=Identifier Code
|
| 8000 | Id | GUID | |
| 8001 | Unit of Measure Id | GUID | TableRelation "Unit of Measure".Id - CaptionML
ENU=Unit of Measure Id
|
| 8002 | Tax Group Id | GUID | TableRelation "Tax Group".Id - CaptionML
ENU=Tax Group Id
|
| 99000750 | Routing No. | Code20 | TableRelation "Routing Header"
|
| 99000751 | Production BOM No. | Code20 | TableRelation "Production BOM Header" - CaptionML
ENU=Production BOM No.
|
| 99000752 | Single-Level Material Cost | Decimal | NotEditable - CaptionML
ENU=Single-Level Material Cost
|
| 99000753 | Single-Level Capacity Cost | Decimal | NotEditable - CaptionML
ENU=Single-Level Capacity Cost
|
| 99000754 | Single-Level Subcontrd. Cost | Decimal | NotEditable - CaptionML
ENU=Single-Level Subcontrd. Cost
|
| 99000755 | Single-Level Cap. Ovhd Cost | Decimal | NotEditable - CaptionML
ENU=Single-Level Cap. Ovhd Cost
|
| 99000756 | Single-Level Mfg. Ovhd Cost | Decimal | NotEditable - CaptionML
ENU=Single-Level Mfg. Ovhd Cost
|
| 99000757 | Overhead Rate | Decimal | - CaptionML
ENU=Overhead Rate - AccessByPermission
TableData 5405=R
|
| 99000758 | Rolled-up Subcontracted Cost | Decimal | NotEditable - CaptionML
ENU=Rolled-up Subcontracted Cost - AccessByPermission
TableData 5405=R
|
| 99000759 | Rolled-up Mfg. Ovhd Cost | Decimal | NotEditable - CaptionML
ENU=Rolled-up Mfg. Ovhd Cost
|
| 99000760 | Rolled-up Cap. Overhead Cost | Decimal | NotEditable - CaptionML
ENU=Rolled-up Cap. Overhead Cost
|
| 99000761 | Planning Issues (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Planning Component"."Expected Quantity (Base)" WHERE (Item No.=FIELD(No.),
Due Date=FIELD(Date Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Planning Line Origin=CONST(" "))); - CaptionML
ENU=Planning Issues (Qty.)
|
| 99000762 | Planning Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),
No.=FIELD(No.),
Due Date=FIELD(Date Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter))); - CaptionML
ENU=Planning Receipt (Qty.)
|
| 99000765 | Planned Order Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Planned),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Planned Order Receipt (Qty.)
|
| 99000766 | FP Order Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Firm Planned),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=FP Order Receipt (Qty.)
|
| 99000767 | Rel. Order Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Released),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 2 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Rel. Order Receipt (Qty.)
|
| 99000768 | Planning Release (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),
No.=FIELD(No.),
Starting Date=FIELD(Date Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter))); - CaptionML
ENU=Planning Release (Qty.)
|
| 99000769 | Planned Order Release (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Planned),
Item No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 1 Filter),
Location Code=FIELD(Location Filter),
Starting Date=FIELD(Date Filter))); - CaptionML
ENU=Planned Order Release (Qty.)
|
| 99000770 | Purch. Req. Receipt (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),
No.=FIELD(No.),
Variant Code=FIELD(Variant Filter),
Location Code=FIELD(Location Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Due Date=FIELD(Date Filter),
Planning Line Origin=CONST(" "))); - CaptionML
ENU=Purch. Req. Receipt (Qty.)
|
| 99000771 | Purch. Req. Release (Qty.) | Decimal | NotEditableFlowField CalcFormula Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),
No.=FIELD(No.),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Order Date=FIELD(Date Filter))); - CaptionML
ENU=Purch. Req. Release (Qty.)
|
| 99000773 | Order Tracking Policy | Option | - CaptionML
ENU=Order Tracking Policy - OptionCaptionML
ENU=None,Tracking Only,Tracking & Action Msg. - OptionString
[None,Tracking Only,Tracking & Action Msg.]
|
| 99000774 | Prod. Forecast Quantity (Base) | Decimal | FlowField CalcFormula Sum("Production Forecast Entry"."Forecast Quantity (Base)" WHERE (Item No.=FIELD(No.),
Production Forecast Name=FIELD(Production Forecast Name),
Forecast Date=FIELD(Date Filter),
Location Code=FIELD(Location Filter),
Component Forecast=FIELD(Component Forecast))); - CaptionML
ENU=Prod. Forecast Quantity (Base)
|
| 99000775 | Production Forecast Name | Code10 | FlowFilter TableRelation "Production Forecast Name" - CaptionML
ENU=Production Forecast Name
|
| 99000776 | Component Forecast | Boolean | FlowFilter - CaptionML
ENU=Component Forecast
|
| 99000777 | Qty. on Prod. Order | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=FILTER(Planned..Released),
Item No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Prod. Order
|
| 99000778 | Qty. on Component Lines | Decimal | NotEditableFlowField CalcFormula Sum("Prod. Order Component"."Remaining Qty. (Base)" WHERE (Status=FILTER(Planned..Released),
Item No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Variant Code=FIELD(Variant Filter),
Due Date=FIELD(Date Filter))); - CaptionML
ENU=Qty. on Component Lines
|
| 99000875 | Critical | Boolean | |
| 99008500 | Common Item No. | Code20 | - CaptionML
ENU=Common Item No.
|