Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | No. (No.) | Code20 | ||
2 | No. 2 (No. 2) | Code20 | ||
3 | Description (Description) | Text50 | ||
4 | Search Description (Search Description) | Code50 | ||
5 | Description 2 (Description 2) | Text50 | ||
6 | Assembly BOM (Assembly BOM) | Boolean |
|
Editable: No FlowField |
8 | Base Unit of Measure (Base Unit of Measure) | Code10 |
|
|
9 | Price Unit Conversion (Price Unit Conversion) | Integer | ||
10 | Type (Type) | Option | [Inventory,Service] | |
11 | Inventory Posting Group (Inventory Posting Group) | Code10 |
|
|
12 | Shelf No. (Shelf No.) | Code10 | ||
14 | Item Disc. Group (Item Disc. Group) | Code20 |
|
|
15 | Allow Invoice Disc. (Allow Invoice Disc.) | Boolean | InitValue: Yes | |
16 | Statistics Group (Statistics Group) | Integer | ||
17 | Commission Group (Commission Group) | Integer | ||
18 | Unit Price (Unit Price) | Decimal | AutoFormatType: 2 | |
19 | Price/Profit Calculation (Price/Profit Calculation) | Option | [Profit=Price-Cost,Price=Cost+Profit,No Relationship] | |
20 | Profit % (Profit %) | Decimal (0:5) | ||
21 | Costing Method (Costing Method) | Option | [FIFO,LIFO,Specific,Average,Standard] | |
22 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
24 | Standard Cost (Standard Cost) | Decimal | AutoFormatType: 2 | |
25 | Last Direct Cost (Last Direct Cost) | Decimal | AutoFormatType: 2 | |
28 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
29 | Cost is Adjusted (Cost is Adjusted) | Boolean | InitValue: Yes | Editable: No |
30 | Allow Online Adjustment (Allow Online Adjustment) | Boolean | InitValue: Yes | Editable: No |
31 | Vendor No. (Vendor No.) | Code20 |
|
|
32 | Vendor Item No. (Vendor Item No.) | Text20 | ||
33 | Lead Time Calculation (Lead Time Calculation) | DateFormula | AccessByPermission: TableData 120=R | |
34 | Reorder Point (Reorder Point) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
35 | Maximum Inventory (Maximum Inventory) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
36 | Reorder Quantity (Reorder Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
37 | Alternative Item No. (Alternative Item No.) | Code20 |
|
|
38 | Unit List Price (Unit List Price) | Decimal | AutoFormatType: 2 | |
39 | Duty Due % (Duty Due %) | Decimal (0:5) | MaxValue: 100 | |
40 | Duty Code (Duty Code) | Code10 | ||
41 | Gross Weight (Gross Weight) | Decimal (0:5) | ||
42 | Net Weight (Net Weight) | Decimal (0:5) | ||
43 | Units per Parcel (Units per Parcel) | Decimal (0:5) | ||
44 | Unit Volume (Unit Volume) | Decimal (0:5) | ||
45 | Durability (Durability) | Code10 | ||
46 | Freight Type (Freight Type) | Code10 | ||
47 | Tariff No. (Tariff No.) | Code20 |
|
|
48 | Duty Unit Conversion (Duty Unit Conversion) | Decimal (0:5) | ||
49 | Country/Region Purchased Code (Country/Region Purchased Code) | Code10 |
|
|
50 | Budget Quantity (Budget Quantity) | Decimal (0:5) | ||
51 | Budgeted Amount (Budgeted Amount) | Decimal | AutoFormatType: 1 | |
52 | Budget Profit (Budget Profit) | Decimal | AutoFormatType: 1 | |
53 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
54 | Blocked (Blocked) | Boolean | ||
55 | Cost is Posted to G/L (Cost is Posted to G/L) | Boolean |
|
Editable: No FlowField |
62 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
63 | Last Time Modified (Last Time Modified) | Time | Editable: No | |
64 | Date Filter (Date Filter) | Date | FlowFilter | |
65 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
66 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
67 | Location Filter (Location Filter) | Code10 |
|
FlowFilter |
68 | Inventory (Inventory) | Decimal (0:5) |
|
Editable: No FlowField |
69 | Net Invoiced Qty. (Net Invoiced Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
70 | Net Change (Net Change) | Decimal (0:5) |
|
Editable: No FlowField |
71 | Purchases (Qty.) (Purchases (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
72 | Sales (Qty.) (Sales (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
73 | Positive Adjmt. (Qty.) (Positive Adjmt. (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
74 | Negative Adjmt. (Qty.) (Negative Adjmt. (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
77 | Purchases (LCY) (Purchases (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
78 | Sales (LCY) (Sales (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
79 | Positive Adjmt. (LCY) (Positive Adjmt. (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
80 | Negative Adjmt. (LCY) (Negative Adjmt. (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
83 | COGS (LCY) (COGS (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
84 | Qty. on Purch. Order (Qty. on Purch. Order) | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
85 | Qty. on Sales Order (Qty. on Sales Order) | Decimal (0:5) | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
87 | Price Includes VAT (Price Includes VAT) | Boolean | ||
89 | Drop Shipment Filter (Drop Shipment Filter) | Boolean | AccessByPermission: TableData 223=R | FlowFilter |
90 | VAT Bus. Posting Gr. (Price) (VAT Bus. Posting Gr. (Price)) | Code10 |
|
|
91 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
92 | Picture (Picture) | MediaSet | ||
93 | Transferred (Qty.) (Transferred (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
94 | Transferred (LCY) (Transferred (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
95 | Country/Region of Origin Code (Country/Region of Origin Code) | Code10 |
|
|
96 | Automatic Ext. Texts (Automatic Ext. Texts) | Boolean | ||
97 | No. Series (No. Series) | Code10 |
|
Editable: No |
98 | Tax Group Code (Tax Group Code) | Code10 |
|
|
99 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code10 |
|
|
100 | Reserve (Reserve) | Option | [Never,Optional,Always] InitValue: Optional AccessByPermission: TableData 120=R |
|
101 | Reserved Qty. on Inventory (Reserved Qty. on Inventory) | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
102 | Reserved Qty. on Purch. Orders (Reserved Qty. on Purch. Orders) | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
103 | Reserved Qty. on Sales Orders (Reserved Qty. on Sales Orders) | Decimal (0:5) | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
105 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
106 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
107 | Res. Qty. on Outbound Transfer (Res. Qty. on Outbound Transfer) | Decimal (0:5) | AccessByPermission: TableData 5740=R
|
Editable: No FlowField |
108 | Res. Qty. on Inbound Transfer (Res. Qty. on Inbound Transfer) | Decimal (0:5) | AccessByPermission: TableData 5740=R
|
Editable: No FlowField |
109 | Res. Qty. on Sales Returns (Res. Qty. on Sales Returns) | Decimal (0:5) | AccessByPermission: TableData 6660=R
|
Editable: No FlowField |
110 | Res. Qty. on Purch. Returns (Res. Qty. on Purch. Returns) | Decimal (0:5) | AccessByPermission: TableData 6650=R
|
Editable: No FlowField |
120 | Stockout Warning (Stockout Warning) | Option | [Default,No,Yes] | |
121 | Prevent Negative Inventory (Prevent Negative Inventory) | Option | [Default,No,Yes] | |
200 | Cost of Open Production Orders (Cost of Open Production Orders) | Decimal |
|
FlowField |
521 | Application Wksh. User ID (Application Wksh. User ID) | Code128 | ||
910 | Assembly Policy (Assembly Policy) | Option | [Assemble-to-Stock,Assemble-to-Order] AccessByPermission: TableData 90=R |
|
929 | Res. Qty. on Assembly Order (Res. Qty. on Assembly Order) | Decimal (0:5) | AccessByPermission: TableData 90=R
|
Editable: No FlowField |
930 | Res. Qty. on Asm. Comp. (Res. Qty. on Asm. Comp.) | Decimal (0:5) | AccessByPermission: TableData 90=R
|
Editable: No FlowField |
977 | Qty. on Assembly Order (Qty. on Assembly Order) | Decimal (0:5) |
|
Editable: No FlowField |
978 | Qty. on Asm. Component (Qty. on Asm. Component) | Decimal (0:5) |
|
Editable: No FlowField |
1001 | Qty. on Job Order (Qty. on Job Order) | Decimal (0:5) |
|
Editable: No FlowField |
1002 | Res. Qty. on Job Order (Res. Qty. on Job Order) | Decimal (0:5) | AccessByPermission: TableData 167=R
|
Editable: No FlowField |
1217 | GTIN (GTIN) | Code14 [Numeric:Yes] | ||
1700 | Default Deferral Template Code (Default Deferral Template Code) | Code10 |
|
|
5400 | Low-Level Code (Low-Level Code) | Integer | Editable: No | |
5401 | Lot Size (Lot Size) | Decimal (0:5) | AccessByPermission: TableData 5405=R | |
5402 | Serial Nos. (Serial Nos.) | Code10 |
|
|
5403 | Last Unit Cost Calc. Date (Last Unit Cost Calc. Date) | Date | Editable: No | |
5404 | Rolled-up Material Cost (Rolled-up Material Cost) | Decimal (2:5) | AutoFormatType: 2 | Editable: No |
5405 | Rolled-up Capacity Cost (Rolled-up Capacity Cost) | Decimal (2:5) | AutoFormatType: 2 | Editable: No |
5407 | Scrap % (Scrap %) | Decimal (0:2) | MaxValue: 100 AccessByPermission: TableData 5405=R |
|
5409 | Inventory Value Zero (Inventory Value Zero) | Boolean | ||
5410 | Discrete Order Quantity (Discrete Order Quantity) | Integer | ||
5411 | Minimum Order Quantity (Minimum Order Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5412 | Maximum Order Quantity (Maximum Order Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5413 | Safety Stock Quantity (Safety Stock Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5414 | Order Multiple (Order Multiple) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5415 | Safety Lead Time (Safety Lead Time) | DateFormula | AccessByPermission: TableData 244=R | |
5417 | Flushing Method (Flushing Method) | Option | [Manual,Forward,Backward,Pick + Forward,Pick + Backward] AccessByPermission: TableData 5405=R |
|
5419 | Replenishment System (Replenishment System) | Option | [Purchase,Prod. Order,,Assembly] AccessByPermission: TableData 244=R |
|
5420 | Scheduled Receipt (Qty.) (Scheduled Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
5421 | Scheduled Need (Qty.) (Scheduled Need (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
5422 | Rounding Precision (Rounding Precision) | Decimal (0:5) | InitValue: 1 AccessByPermission: TableData 5405=R |
|
5423 | Bin Filter (Bin Filter) | Code20 |
|
FlowFilter |
5424 | Variant Filter (Variant Filter) | Code10 |
|
FlowFilter |
5425 | Sales Unit of Measure (Sales Unit of Measure) | Code10 |
|
|
5426 | Purch. Unit of Measure (Purch. Unit of Measure) | Code10 |
|
|
5428 | Time Bucket (Time Bucket) | DateFormula | AccessByPermission: TableData 244=R | |
5429 | Reserved Qty. on Prod. Order (Reserved Qty. on Prod. Order) | Decimal (0:5) | AccessByPermission: TableData 5405=R
|
Editable: No FlowField |
5430 | Res. Qty. on Prod. Order Comp. (Res. Qty. on Prod. Order Comp.) | Decimal (0:5) | AccessByPermission: TableData 5405=R
|
Editable: No FlowField |
5431 | Res. Qty. on Req. Line (Res. Qty. on Req. Line) | Decimal (0:5) | AccessByPermission: TableData 244=R
|
Editable: No FlowField |
5440 | Reordering Policy (Reordering Policy) | Option | [ ,Fixed Reorder Qty.,Maximum Qty.,Order,Lot-for-Lot] AccessByPermission: TableData 244=R |
|
5441 | Include Inventory (Include Inventory) | Boolean | AccessByPermission: TableData 244=R | |
5442 | Manufacturing Policy (Manufacturing Policy) | Option | [Make-to-Stock,Make-to-Order] AccessByPermission: TableData 244=R |
|
5443 | Rescheduling Period (Rescheduling Period) | DateFormula | AccessByPermission: TableData 244=R | |
5444 | Lot Accumulation Period (Lot Accumulation Period) | DateFormula | AccessByPermission: TableData 244=R | |
5445 | Dampener Period (Dampener Period) | DateFormula | AccessByPermission: TableData 244=R | |
5446 | Dampener Quantity (Dampener Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5447 | Overflow Level (Overflow Level) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
5449 | Planning Transfer Ship. (Qty). (Planning Transfer Ship. (Qty).) | Decimal |
|
Editable: No FlowField |
5450 | Planning Worksheet (Qty.) (Planning Worksheet (Qty.)) | Decimal |
|
Editable: No FlowField |
5700 | Stockkeeping Unit Exists (Stockkeeping Unit Exists) | Boolean |
|
Editable: No FlowField |
5701 | Manufacturer Code (Manufacturer Code) | Code10 |
|
|
5702 | Item Category Code (Item Category Code) | Code20 |
|
|
5703 | Created From Nonstock Item (Created From Nonstock Item) | Boolean | AccessByPermission: TableData 5718=R | Editable: No |
5704 | Product Group Code (Product Group Code) | Code10 |
|
|
5706 | Substitutes Exist (Substitutes Exist) | Boolean |
|
Editable: No FlowField |
5707 | Qty. in Transit (Qty. in Transit) | Decimal (0:5) |
|
Editable: No FlowField |
5708 | Trans. Ord. Receipt (Qty.) (Trans. Ord. Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
5709 | Trans. Ord. Shipment (Qty.) (Trans. Ord. Shipment (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
5776 | Qty. Assigned to ship (Qty. Assigned to ship) | Decimal (0:5) |
|
Editable: No FlowField |
5777 | Qty. Picked (Qty. Picked) | Decimal (0:5) |
|
Editable: No FlowField |
5900 | Service Item Group (Service Item Group) | Code10 |
|
|
5901 | Qty. on Service Order (Qty. on Service Order) | Decimal (0:5) |
|
Editable: No FlowField |
5902 | Res. Qty. on Service Orders (Res. Qty. on Service Orders) | Decimal (0:5) | AccessByPermission: TableData 5900=R
|
Editable: No FlowField |
6500 | Item Tracking Code (Item Tracking Code) | Code10 |
|
|
6501 | Lot Nos. (Lot Nos.) | Code10 |
|
|
6502 | Expiration Calculation (Expiration Calculation) | DateFormula | ||
6503 | Lot No. Filter (Lot No. Filter) | Code20 | FlowFilter | |
6504 | Serial No. Filter (Serial No. Filter) | Code20 | FlowFilter | |
6650 | Qty. on Purch. Return (Qty. on Purch. Return) | Decimal (0:5) | AccessByPermission: TableData 6660=R
|
Editable: No FlowField |
6660 | Qty. on Sales Return (Qty. on Sales Return) | Decimal (0:5) | AccessByPermission: TableData 6650=R
|
Editable: No FlowField |
7171 | No. of Substitutes (No. of Substitutes) | Integer |
|
Editable: No FlowField |
7300 | Warehouse Class Code (Warehouse Class Code) | Code10 |
|
|
7301 | Special Equipment Code (Special Equipment Code) | Code10 |
|
|
7302 | Put-away Template Code (Put-away Template Code) | Code10 |
|
|
7307 | Put-away Unit of Measure Code (Put-away Unit of Measure Code) | Code10 | AccessByPermission: TableData 7340=R
|
|
7380 | Phys Invt Counting Period Code (Phys Invt Counting Period Code) | Code10 |
|
|
7381 | Last Counting Period Update (Last Counting Period Update) | Date | AccessByPermission: TableData 7380=R | Editable: No |
7383 | Last Phys. Invt. Date (Last Phys. Invt. Date) | Date |
|
Editable: No FlowField |
7384 | Use Cross-Docking (Use Cross-Docking) | Boolean | InitValue: Yes AccessByPermission: TableData 7302=R |
|
7385 | Next Counting Start Date (Next Counting Start Date) | Date | Editable: No | |
7386 | Next Counting End Date (Next Counting End Date) | Date | Editable: No | |
7700 | Identifier Code (Identifier Code) | Code20 |
|
Editable: No FlowField |
99000750 | Routing No. (Routing No.) | Code20 |
|
|
99000751 | Production BOM No. (Production BOM No.) | Code20 |
|
|
99000752 | Single-Level Material Cost (Single-Level Material Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000753 | Single-Level Capacity Cost (Single-Level Capacity Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000754 | Single-Level Subcontrd. Cost (Single-Level Subcontrd. Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000755 | Single-Level Cap. Ovhd Cost (Single-Level Cap. Ovhd Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000756 | Single-Level Mfg. Ovhd Cost (Single-Level Mfg. Ovhd Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000757 | Overhead Rate (Overhead Rate) | Decimal | AutoFormatType: 2 AccessByPermission: TableData 5405=R |
|
99000758 | Rolled-up Subcontracted Cost (Rolled-up Subcontracted Cost) | Decimal | AutoFormatType: 2 AccessByPermission: TableData 5405=R |
Editable: No |
99000759 | Rolled-up Mfg. Ovhd Cost (Rolled-up Mfg. Ovhd Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000760 | Rolled-up Cap. Overhead Cost (Rolled-up Cap. Overhead Cost) | Decimal | AutoFormatType: 2 | Editable: No |
99000761 | Planning Issues (Qty.) (Planning Issues (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000762 | Planning Receipt (Qty.) (Planning Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000765 | Planned Order Receipt (Qty.) (Planned Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000766 | FP Order Receipt (Qty.) (FP Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000767 | Rel. Order Receipt (Qty.) (Rel. Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000768 | Planning Release (Qty.) (Planning Release (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000769 | Planned Order Release (Qty.) (Planned Order Release (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000770 | Purch. Req. Receipt (Qty.) (Purch. Req. Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000771 | Purch. Req. Release (Qty.) (Purch. Req. Release (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
99000773 | Order Tracking Policy (Order Tracking Policy) | Option | [None,Tracking Only,Tracking & Action Msg.] | |
99000774 | Prod. Forecast Quantity (Base) (Prod. Forecast Quantity (Base)) | Decimal (0:5) |
|
FlowField |
99000775 | Production Forecast Name (Production Forecast Name) | Code10 |
|
FlowFilter |
99000776 | Component Forecast (Component Forecast) | Boolean | FlowFilter | |
99000777 | Qty. on Prod. Order (Qty. on Prod. Order) | Decimal (0:5) |
|
Editable: No FlowField |
99000778 | Qty. on Component Lines (Qty. on Component Lines) | Decimal (0:5) |
|
Editable: No FlowField |
99000875 | Critical (Critical) | Boolean | ||
99008500 | Common Item No. (Common Item No.) | Code20 |
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Search Description (Search Description) | ||
2 | Inventory Posting Group (Inventory Posting Group) | ||
3 | Shelf No. (Shelf No.) | ||
4 | Vendor No. (Vendor No.) | ||
5 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | ||
6 | Low-Level Code (Low-Level Code) | ||
7 | Production BOM No. (Production BOM No.) | ||
8 | Routing No. (Routing No.) | ||
9 | Vendor Item No.,Vendor No. (Vendor Item No.,Vendor No.) | ||
10 | Common Item No. (Common Item No.) | ||
11 | Service Item Group (Service Item Group) | ||
12 | Cost is Adjusted,Allow Online Adjustment (Cost is Adjusted,Allow Online Adjustment) | ||
13 | Description (Description) | ||
14 | Base Unit of Measure (Base Unit of Measure) | ||
15 | Type (Type) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Bin Filter (Bin Filter) | Bin | Code (Code) |
|
1..n |
Country/Region of Origin Code (Country/Region of Origin Code) | Country/Region | Code (Code) |
|
1..n |
Default Deferral Template Code (Default Deferral Template Code) | Deferral Template | Deferral Code (Deferral Code) |
|
1..n |
Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
Inventory Posting Group (Inventory Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
Alternative Item No. (Alternative Item No.) | Item | No. (No.) |
|
1..n |
Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
Item Disc. Group (Item Disc. Group) | Item Discount Group | Code (Code) |
|
1..n |
Item Tracking Code (Item Tracking Code) | Item Tracking Code | Code (Code) |
|
1..n |
Put-away Unit of Measure Code (Put-away Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
Variant Filter (Variant Filter) | Item Variant | Code (Code) |
|
1..n |
Location Filter (Location Filter) | Location | Code (Code) |
|
1..n |
Manufacturer Code (Manufacturer Code) | Manufacturer | Code (Code) |
|
1..n |
Lot Nos. (Lot Nos.) | No. Series | Code (Code) |
|
1..n |
Phys Invt Counting Period Code (Phys Invt Counting Period Code) | Phys. Invt. Counting Period | Code (Code) |
|
1..n |
Production BOM No. (Production BOM No.) | Production BOM Header | No. (No.) |
|
1..n |
Production Forecast Name (Production Forecast Name) | Production Forecast Name | Name (Name) |
|
1..n |
Put-away Template Code (Put-away Template Code) | Put-away Template Header | Code (Code) |
|
1..n |
Routing No. (Routing No.) | Routing Header | No. (No.) |
|
1..n |
Service Item Group (Service Item Group) | Service Item Group | Code (Code) |
|
1..n |
Special Equipment Code (Special Equipment Code) | Special Equipment | Code (Code) |
|
1..n |
Tariff No. (Tariff No.) | Tariff Number | No. (No.) |
|
1..n |
Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
Put-away Unit of Measure Code (Put-away Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
VAT Bus. Posting Gr. (Price) (VAT Bus. Posting Gr. (Price)) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Warehouse Class Code (Warehouse Class Code) | Warehouse Class | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Action Message Entry | Item No. (Item No.) |
|
1..n |
Analysis Dim. Selection Buffer | New Dimension Value Code (New Dimension Value Code) |
|
1..n |
Analysis Line | Source No. Filter (Source No. Filter) |
|
1..n |
Assembly Header | Item No. (Item No.) |
|
1..n |
Assembly Line | No. (No.) |
|
1..n |
Availability Calc. Overview | Item No. (Item No.) |
|
1..n |
Average Cost Calc. Overview | Item No. (Item No.) |
|
1..n |
Avg. Cost Adjmt. Entry Point | Item No. (Item No.) |
|
1..n |
BOM Buffer | No. (No.) |
|
1..n |
BOM Component | Installed in Item No. (Installed in Item No.) |
|
1..n |
Bin | Item Filter (Item Filter) |
|
1..n |
Bin Content | Item No. (Item No.) |
|
1..n |
Bin Content Buffer | Item No. (Item No.) |
|
1..n |
Bin Creation Worksheet Line | Item No. (Item No.) |
|
1..n |
Capacity Ledger Entry | Item No. (Item No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
Extended Text Header | No. (No.) |
|
1..n |
Extended Text Line | No. (No.) |
|
1..n |
Family Line | Item No. (Item No.) |
|
1..n |
Filed Contract Line | Item No. (Item No.) |
|
1..n |
Handled IC Inbox Purch. Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
Handled IC Inbox Sales Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
Handled IC Outbox Purch. Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
Handled IC Outbox Sales Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
IC Inbox Purchase Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
IC Inbox Sales Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
IC Outbox Purchase Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
IC Outbox Sales Line | IC Partner Reference (IC Partner Reference) |
|
1..n |
Intrastat Jnl. Line | Item No. (Item No.) |
|
1..n |
Inventory Adjmt. Entry (Order) | Item No. (Item No.) |
|
1..n |
Inventory Adjustment Buffer | Item No. (Item No.) |
|
1..n |
Inventory Buffer | Item No. (Item No.) |
|
1..n |
Inventory Event Buffer | Item No. (Item No.) |
|
1..n |
Inventory Page Data | Item No. (Item No.) |
|
1..n |
Inventory Profile | Item No. (Item No.) |
|
1..n |
Item | Alternative Item No. (Alternative Item No.) |
|
1..n |
Item Amount | Item No. (Item No.) |
|
1..n |
Item Analysis View Budg. Entry | Source No. (Source No.) |
|
1..n |
Item Analysis View Entry | Source No. (Source No.) |
|
1..n |
Item Budget Buffer | Source No. (Source No.) |
|
1..n |
Item Budget Entry | Source No. (Source No.) |
|
1..n |
Item Charge Assignment (Purch) | Item No. (Item No.) |
|
1..n |
Item Charge Assignment (Sales) | Item No. (Item No.) |
|
1..n |
Item Cross Reference | Item No. (Item No.) |
|
1..n |
Item Identifier | Item No. (Item No.) |
|
1..n |
Item Journal Buffer | Item No. (Item No.) |
|
1..n |
Item Journal Line | Originally Ordered No. (Originally Ordered No.) |
|
1..n |
Item Ledger Entry | Originally Ordered No. (Originally Ordered No.) |
|
1..n |
Item Substitution | Substitute No. (Substitute No.) |
|
1..n |
Item Tracing Buffer | Source No. (Source No.) |
|
1..n |
Item Tracking Comment | Item No. (Item No.) |
|
1..n |
Item Translation | Item No. (Item No.) |
|
1..n |
Item Unit of Measure | Item No. (Item No.) |
|
1..n |
Item Variant | Item No. (Item No.) |
|
1..n |
Item Vendor | Item No. (Item No.) |
|
1..n |
Job Item Price | Item No. (Item No.) |
|
1..n |
Job Journal Line | No. (No.) |
|
1..n |
Job Ledger Entry | No. (No.) |
|
1..n |
Job Planning Line | No. (No.) |
|
1..n |
Loaner | Item No. (Item No.) |
|
1..n |
Lot No. Information | Item No. (Item No.) |
|
1..n |
Machine Center | Item Filter (Item Filter) |
|
1..n |
My Item | Item No. (Item No.) |
|
1..n |
Nonstock Item | Item No. (Item No.) |
|
1..n |
Order Promising Line | Item No. (Item No.) |
|
1..n |
Order Tracking Entry | Item No. (Item No.) |
|
1..n |
Phys. Inventory Ledger Entry | Item No. (Item No.) |
|
1..n |
Phys. Invt. Item Selection | Item No. (Item No.) |
|
1..n |
Planning Assignment | Item No. (Item No.) |
|
1..n |
Planning Buffer | Item No. (Item No.) |
|
1..n |
Planning Component | Item No. (Item No.) |
|
1..n |
Planning Error Log | Item No. (Item No.) |
|
1..n |
Post Value Entry to G/L | Item No. (Item No.) |
|
1..n |
Posted Assembly Header | Item No. (Item No.) |
|
1..n |
Posted Assembly Line | No. (No.) |
|
1..n |
Posted Invt. Pick Header | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Pick Line | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Put-away Header | Destination No. (Destination No.) |
|
1..n |
Posted Invt. Put-away Line | Destination No. (Destination No.) |
|
1..n |
Posted Whse. Receipt Line | Item No. (Item No.) |
|
1..n |
Posted Whse. Shipment Line | Item No. (Item No.) |
|
1..n |
Prod. Order Component | Original Item No. (Original Item No.) |
|
1..n |
Prod. Order Line | Item No. (Item No.) |
|
1..n |
Production BOM Line | No. (No.) |
|
1..n |
Production Forecast Entry | Item No. (Item No.) |
|
1..n |
Production Matrix BOM Entry | Item No. (Item No.) |
|
1..n |
Production Matrix BOM Line | Item No. (Item No.) |
|
1..n |
Production Order | Source No. (Source No.) |
|
1..n |
Purch. Cr. Memo Line | No. (No.) |
|
1..n |
Purch. Inv. Line | No. (No.) |
|
1..n |
Purch. Rcpt. Line | No. (No.) |
|
1..n |
Purchase Line Archive | No. (No.) |
|
1..n |
Purchase Line Discount | Item No. (Item No.) |
|
1..n |
Purchase Prepayment % | Item No. (Item No.) |
|
1..n |
Purchase Price | Item No. (Item No.) |
|
1..n |
Record Buffer | Item No. (Item No.) |
|
1..n |
Registered Invt. Movement Hdr. | Destination No. (Destination No.) |
|
1..n |
Registered Invt. Movement Line | Destination No. (Destination No.) |
|
1..n |
Registered Whse. Activity Line | Destination No. (Destination No.) |
|
1..n |
Requisition Line | Original Item No. (Original Item No.) |
|
1..n |
Reservation Entry | Item No. (Item No.) |
|
1..n |
Resource Skill | No. (No.) |
|
1..n |
Return Receipt Line | No. (No.) |
|
1..n |
Return Shipment Line | No. (No.) |
|
1..n |
Sales Cr.Memo Line | No. (No.) |
|
1..n |
Sales Invoice Line | No. (No.) |
|
1..n |
Sales Line | BOM Item No. (BOM Item No.) |
|
1..n |
Sales Line Archive | BOM Item No. (BOM Item No.) |
|
1..n |
Sales Line Discount | Code (Code) |
|
1..n |
Sales Planning Line | Item No. (Item No.) |
|
1..n |
Sales Prepayment % | Item No. (Item No.) |
|
1..n |
Sales Price | Item No. (Item No.) |
|
1..n |
Sales Price Worksheet | Item No. (Item No.) |
|
1..n |
Sales Price and Line Disc Buff | Code (Code) |
|
1..n |
Sales Shipment Buffer | No. (No.) |
|
1..n |
Sales Shipment Line | No. (No.) |
|
1..n |
Serial No. Information | Item No. (Item No.) |
|
1..n |
Serv. Price Adjustment Detail | No. (No.) |
|
1..n |
Service Contract Header | Item Filter (Item Filter) |
|
1..n |
Service Contract Line | Item No. (Item No.) |
|
1..n |
Service Cr.Memo Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
Service Invoice Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
Service Item | Item No. (Item No.) |
|
1..n |
Service Item Component | No. (No.) |
|
1..n |
Service Item Line | Item No. (Item No.) |
|
1..n |
Service Ledger Entry | No. (No.) |
|
1..n |
Service Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
Service Line Price Adjmt. | No. (No.) |
|
1..n |
Service Shipment Buffer | No. (No.) |
|
1..n |
Service Shipment Item Line | Item No. (Item No.) |
|
1..n |
Service Shipment Line | Replaced Item No. (Replaced Item No.) |
|
1..n |
Social Listening Search Topic | Source No. (Source No.) |
|
1..n |
Standard Cost Worksheet | No. (No.) |
|
1..n |
Standard Item Journal Line | Originally Ordered No. (Originally Ordered No.) |
|
1..n |
Standard Purchase Line | No. (No.) |
|
1..n |
Standard Sales Line | No. (No.) |
|
1..n |
Standard Service Line | No. (No.) |
|
1..n |
Stockkeeping Unit | Item No. (Item No.) |
|
1..n |
Stockkeeping Unit Comment Line | Item No. (Item No.) |
|
1..n |
Tracking Specification | Item No. (Item No.) |
|
1..n |
Transfer Line | Item No. (Item No.) |
|
1..n |
Transfer Receipt Line | Item No. (Item No.) |
|
1..n |
Transfer Shipment Line | Item No. (Item No.) |
|
1..n |
Troubleshooting Setup | No. (No.) |
|
1..n |
Untracked Planning Element | Item No. (Item No.) |
|
1..n |
Value Entry | Source No. (Source No.) |
|
1..n |
Warehouse Activity Header | Destination No. (Destination No.) |
|
1..n |
Warehouse Activity Line | Destination No. (Destination No.) |
|
1..n |
Warehouse Entry | Item No. (Item No.) |
|
1..n |
Warehouse Journal Line | Item No. (Item No.) |
|
1..n |
Warehouse Receipt Line | Item No. (Item No.) |
|
1..n |
Warehouse Request | Destination No. (Destination No.) |
|
1..n |
Warehouse Shipment Line | Item No. (Item No.) |
|
1..n |
Warranty Ledger Entry | No. (No.) |
|
1..n |
Where-Used Line | Item No. (Item No.) |
|
1..n |
Whse. Cross-Dock Opportunity | Item No. (Item No.) |
|
1..n |
Whse. Internal Pick Line | Item No. (Item No.) |
|
1..n |
Whse. Item Tracking Line | Item No. (Item No.) |
|
1..n |
Whse. Worksheet Line | Item No. (Item No.) |
|
1..n |