Table 1382 Item Templ.
106 fields
| Id | Name | Type | Versions |
|---|---|---|---|
| 1 | Code | Code[20] | 17-29 |
| 2 | Description | Text[100] | 17-29 |
| 8 | Base Unit of Measure | Code[10] | 17-29 |
| 9 | Price Unit Conversion | Integer | new in 18 |
| 10 | Type | Enum "Item Type" | 17-29 |
| 11 | Inventory Posting Group | Code[20] | 17-29 |
| 12 | Shelf No. | Code[10] | new in 18 |
| 14 | Item Disc. Group | Code[20] | 17-29 |
| 15 | Allow Invoice Disc. | Boolean | 17-29 |
| 16 | Statistics Group | Integer | new in 18 |
| 17 | Commission Group | Integer | new in 18 |
| 18 | Unit Price | Decimal | new in 18 |
| 19 | Price/Profit Calculation | Enum "Item Price Profit Calculation" | 17-29changed in 19 |
| 20 | Profit % | Decimal | 17-29 |
| 21 | Costing Method | Enum "Costing Method" | 17-29 |
| 22 | Unit Cost | Decimal | new in 18 |
| 24 | Standard Cost | Decimal | new in 18 |
| 28 | Indirect Cost % | Decimal | 17-29 |
| 31 | Vendor No. | Code[20] | new in 18 |
| 32 | Vendor Item No. | Text[50] | new in 18 |
| 33 | Lead Time Calculation | DateFormula | new in 18 |
| 34 | Reorder Point | Decimal | new in 18 |
| 35 | Maximum Inventory | Decimal | new in 18 |
| 36 | Reorder Quantity | Decimal | new in 18 |
| 37 | Alternative Item No. | Code[20] | new in 18 |
| 38 | Unit List Price | Decimal | new in 18 |
| 39 | Duty Due % | Decimal | new in 18 |
| 40 | Duty Code | Code[10] | new in 18 |
| 41 | Gross Weight | Decimal | new in 18 |
| 42 | Net Weight | Decimal | new in 18 |
| 43 | Units per Parcel | Decimal | new in 18 |
| 44 | Unit Volume | Decimal | new in 18 |
| 45 | Durability | Code[10] | new in 18 |
| 46 | Freight Type | Code[10] | new in 18 |
| 47 | Tariff No. | Code[20] | new in 18 |
| 48 | Duty Unit Conversion | Decimal | new in 18 |
| 49 | Country/Region Purchased Code | Code[10] | new in 18 |
| 50 | Budget Quantity | Decimal | new in 18 |
| 51 | Budgeted Amount | Decimal | new in 18 |
| 52 | Budget Profit | Decimal | new in 18 |
| 54 | Blocked | Boolean | 17-29 |
| 56 | Block Reason | Text[250] | new in 18 |
| 87 | Price Includes VAT | Boolean | 17-29 |
| 90 | VAT Bus. Posting Gr. (Price) | Code[20] | new in 18 |
| 91 | Gen. Prod. Posting Group | Code[20] | 17-29 |
| 95 | Country/Region of Origin Code | Code[10] | new in 18 |
| 96 | Automatic Ext. Texts | Boolean | 17-29 |
| 97 | No. Series | Code[20] | new in 18 |
| 98 | Tax Group Code | Code[20] | 17-29 |
| 99 | VAT Prod. Posting Group | Code[20] | 17-29 |
| 100 | Reserve | Enum "Reserve Method" | new in 18 |
| 105 | Global Dimension 1 Code | Code[20] | 17-29 |
| 106 | Global Dimension 2 Code | Code[20] | 17-29 |
| 120 | Stockout Warning | Option | new in 18 |
| 121 | Prevent Negative Inventory | Option | new in 18 |
| 122 | Variant Mandatory if Exists | Option | new in 22 |
| 910 | Assembly Policy | Enum "Assembly Policy" | new in 18 |
| 1217 | GTIN | Code[14] | new in 18 |
| 1700 | Default Deferral Template Code | Code[10] | new in 18 |
| 5401 | Lot Size | Decimal | new in 18 |
| 5402 | Serial Nos. | Code[20] | new in 18 |
| 5407 | Scrap % | Decimal | new in 18 |
| 5408 | Rolled-up Mat. Non-Invt. Cost | Decimal | new in 26 |
| 5409 | Inventory Value Zero | Boolean | new in 21 |
| 5410 | Discrete Order Quantity | Integer | new in 18 |
| 5411 | Minimum Order Quantity | Decimal | new in 18 |
| 5412 | Maximum Order Quantity | Decimal | new in 18 |
| 5413 | Safety Stock Quantity | Decimal | new in 18 |
| 5414 | Order Multiple | Decimal | new in 18 |
| 5415 | Safety Lead Time | DateFormula | new in 18 |
| 5417 | Flushing Method | Enum "Flushing Method" | 18-25, 27-29 |
| 5419 | Replenishment System | Enum "Replenishment System" | new in 18 |
| 5422 | Rounding Precision | Decimal | new in 19 |
| 5428 | Time Bucket | DateFormula | new in 18 |
| 5440 | Reordering Policy | Enum "Reordering Policy" | new in 18 |
| 5441 | Include Inventory | Boolean | new in 18 |
| 5442 | Manufacturing Policy | Enum "Manufacturing Policy" | new in 18 |
| 5443 | Rescheduling Period | DateFormula | new in 18 |
| 5444 | Lot Accumulation Period | DateFormula | new in 18 |
| 5445 | Dampener Period | DateFormula | new in 18 |
| 5446 | Dampener Quantity | Decimal | new in 18 |
| 5447 | Overflow Level | Decimal | new in 18 |
| 5701 | Manufacturer Code | Code[10] | new in 18 |
| 5702 | Item Category Code | Code[20] | 17-29 |
| 5711 | Purchasing Code | Code[10] | new in 18 |
| 6500 | Item Tracking Code | Code[10] | new in 18 |
| 6501 | Lot Nos. | Code[20] | new in 18 |
| 6502 | Expiration Calculation | DateFormula | new in 18 |
| 7300 | Warehouse Class Code | Code[10] | 17-29 |
| 7301 | Special Equipment Code | Code[10] | new in 18 |
| 7302 | Put-away Template Code | Code[10] | new in 18 |
| 7380 | Phys Invt Counting Period Code | Code[10] | new in 18 |
| 7384 | Use Cross-Docking | Boolean | new in 18 |
| 8003 | Sales Blocked | Boolean | 17-29 |
| 8004 | Purchasing Blocked | Boolean | 17-29 |
| 8010 | Service Blocked | Boolean | new in 24 |
| 8510 | Over-Receipt Code | Code[20] | new in 18 |
| 10004 | Duty Class | Code[10] | new in 18 |
| 27000 | SAT Item Classification | Code[10] | new in 18 |
| 27024 | SAT Hazardous Material | Code[10] | new in 19 |
| 27025 | SAT Packaging Type | Code[10] | new in 19 |
| 27026 | SAT Material Type | Code[10] | new in 23 |
| 99000757 | Overhead Rate | Decimal | new in 18 |
| 99000773 | Order Tracking Policy | Enum "Order Tracking Policy" | 18-25, 27-29 |
| 99000875 | Critical | Boolean | 18-25, 27-29 |
| 99008500 | Common Item No. | Code[20] | 18-25, 27-29 |