Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
2 | Customer No. (Customer No.) | Code20 |
|
Editable: No |
3 | Document No. (Document No.) | Code20 |
|
|
4 | Line No. (Line No.) | Integer | ||
5 | Type (Type) | Option | [ ,Item,Resource,Cost,G/L Account] | |
6 | No. (No.) | Code20 |
|
|
7 | Location Code (Location Code) | Code10 |
|
|
8 | Posting Group (Posting Group) | Code20 |
|
|
11 | Description (Description) | Text50 | ||
12 | Description 2 (Description 2) | Text50 | ||
13 | Unit of Measure (Unit of Measure) | Text10 | ||
15 | Quantity (Quantity) | Decimal (0:5) | ||
22 | Unit Price (Unit Price) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Unit Price")) AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
23 | Unit Cost (LCY) (Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | |
25 | VAT % (VAT %) | Decimal (0:5) | Editable: No | |
27 | Line Discount % (Line Discount %) | Decimal (0:5) | MaxValue: 100 | |
32 | Allow Invoice Disc. (Allow Invoice Disc.) | Boolean | InitValue: Yes | |
34 | Gross Weight (Gross Weight) | Decimal (0:5) | ||
35 | Net Weight (Net Weight) | Decimal (0:5) | ||
36 | Units per Parcel (Units per Parcel) | Decimal (0:5) | ||
37 | Unit Volume (Unit Volume) | Decimal (0:5) | ||
38 | Appl.-to Item Entry (Appl.-to Item Entry) | Integer | AccessByPermission: TableData 27=R | |
39 | Item Shpt. Entry No. (Item Shpt. Entry No.) | Integer | ||
40 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
41 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
42 | Customer Price Group (Customer Price Group) | Code10 |
|
Editable: No |
52 | Work Type Code (Work Type Code) | Code10 |
|
|
58 | Qty. Shipped Not Invoiced (Qty. Shipped Not Invoiced) | Decimal (0:5) | Editable: No | |
61 | Quantity Invoiced (Quantity Invoiced) | Decimal (0:5) | Editable: No | |
65 | Order No. (Order No.) | Code20 | ||
66 | Order Line No. (Order Line No.) | Integer | ||
68 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
Editable: No |
74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
75 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
77 | VAT Calculation Type (VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
78 | Transaction Type (Transaction Type) | Code10 |
|
|
79 | Transport Method (Transport Method) | Code10 |
|
|
80 | Attached to Line No. (Attached to Line No.) | Integer | Editable: No | |
81 | Exit Point (Exit Point) | Code10 |
|
|
82 | Area (Area) | Code10 |
|
|
83 | Transaction Specification (Transaction Specification) | Code10 |
|
|
85 | Tax Area Code (Tax Area Code) | Code20 |
|
|
86 | Tax Liable (Tax Liable) | Boolean | ||
87 | Tax Group Code (Tax Group Code) | Code20 |
|
|
89 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
90 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
91 | Currency Code (Currency Code) | Code10 |
|
Editable: No |
99 | VAT Base Amount (VAT Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
100 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
950 | Time Sheet No. (Time Sheet No.) | Code20 |
|
|
951 | Time Sheet Line No. (Time Sheet Line No.) | Integer |
|
|
952 | Time Sheet Date (Time Sheet Date) | Date |
|
|
5402 | Variant Code (Variant Code) | Code10 |
|
|
5403 | Bin Code (Bin Code) | Code20 |
|
|
5404 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
5415 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
5458 | Qty. Shipped Not Invd. (Base) (Qty. Shipped Not Invd. (Base)) | Decimal (0:5) | Editable: No | |
5461 | Qty. Invoiced (Base) (Qty. Invoiced (Base)) | Decimal (0:5) | ||
5700 | Responsibility Center (Responsibility Center) | Code10 |
|
|
5709 | Item Category Code (Item Category Code) | Code20 |
|
|
5710 | Nonstock (Nonstock) | Boolean | ||
5712 | Product Group Code (Product Group Code) | Code10 |
|
|
5817 | Correction (Correction) | Boolean | ||
5901 | Appl.-to Warranty Entry (Appl.-to Warranty Entry) | Integer | ||
5902 | Service Item No. (Service Item No.) | Code20 |
|
|
5903 | Appl.-to Service Entry (Appl.-to Service Entry) | Integer | ||
5904 | Service Item Line No. (Service Item Line No.) | Integer | ||
5905 | Service Item Serial No. (Service Item Serial No.) | Code20 | ||
5906 | Service Item Line Description (Service Item Line Description) | Text50 | ||
5908 | Posting Date (Posting Date) | Date | ||
5909 | Order Date (Order Date) | Date | ||
5910 | Needed by Date (Needed by Date) | Date | ||
5916 | Ship-to Code (Ship-to Code) | Code10 |
|
|
5918 | Quantity Consumed (Quantity Consumed) | Decimal (0:5) | ||
5920 | Qty. Consumed (Base) (Qty. Consumed (Base)) | Decimal (0:5) | ||
5928 | Service Price Group Code (Service Price Group Code) | Code10 |
|
|
5929 | Fault Area Code (Fault Area Code) | Code10 |
|
|
5930 | Symptom Code (Symptom Code) | Code10 |
|
|
5931 | Fault Code (Fault Code) | Code10 |
|
|
5932 | Resolution Code (Resolution Code) | Code10 |
|
|
5933 | Exclude Warranty (Exclude Warranty) | Boolean | ||
5934 | Warranty (Warranty) | Boolean | ||
5936 | Contract No. (Contract No.) | Code20 |
|
|
5938 | Contract Disc. % (Contract Disc. %) | Decimal (0:5) | MaxValue: 100 | |
5939 | Warranty Disc. % (Warranty Disc. %) | Decimal (0:5) | MaxValue: 100 | |
5965 | Component Line No. (Component Line No.) | Integer | ||
5966 | Spare Part Action (Spare Part Action) | Option | [ ,Permanent,Temporary,Component Replaced,Component Installed] | |
5967 | Fault Reason Code (Fault Reason Code) | Code10 |
|
|
5968 | Replaced Item No. (Replaced Item No.) | Code20 |
|
|
5969 | Exclude Contract Discount (Exclude Contract Discount) | Boolean | ||
5970 | Replaced Item Type (Replaced Item Type) | Option | [ ,Service Item,Item] | |
5994 | Price Adjmt. Status (Price Adjmt. Status) | Option | [ ,Adjusted,Modified] | |
5997 | Line Discount Type (Line Discount Type) | Option | [ ,Warranty Disc.,Contract Disc.,Line Disc.,Manual] | |
5999 | Copy Components From (Copy Components From) | Option | [None,Item BOM,Old Service Item,Old Serv.Item w/o Serial No.] | |
6608 | Return Reason Code (Return Reason Code) | Code10 |
|
|
7001 | Allow Line Disc. (Allow Line Disc.) | Boolean | ||
7002 | Customer Disc. Group (Customer Disc. Group) | Code20 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Document No.,Line No. (Document No.,Line No.) | Clustered: Yes | |
1 | Order No.,Order Line No. (Order No.,Order Line No.) | ||
2 | Item Shpt. Entry No. (Item Shpt. Entry No.) | ||
3 | Service Item No.,Type,Posting Date (Service Item No.,Type,Posting Date) | ||
4 | Customer No. (Customer No.) | ||
5 | Bill-to Customer No. (Bill-to Customer No.) | ||
6 | Fault Reason Code (Fault Reason Code) | ||
7 | Contract No. (Contract No.) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area (Area) | Area | Code (Code) |
|
1..n |
Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
Customer Disc. Group (Customer Disc. Group) | Customer Discount Group | Code (Code) |
|
1..n |
Customer Price Group (Customer Price Group) | Customer Price Group | Code (Code) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
Exit Point (Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
Fault Area Code (Fault Area Code) | Fault Area | Code (Code) |
|
1..n |
Fault Code (Fault Code) | Fault Code | Code (Code) |
|
1..n |
Fault Reason Code (Fault Reason Code) | Fault Reason Code | Code (Code) |
|
1..n |
No. (No.) | G/L Account | No. (No.) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
Posting Group (Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
Replaced Item No. (Replaced Item No.) | Item | No. (No.) |
|
1..n |
Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
Location Code (Location Code) | Location | Code (Code) |
|
1..n |
Resolution Code (Resolution Code) | Resolution Code | Code (Code) |
|
1..n |
No. (No.) | Resource | No. (No.) |
|
1..n |
Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
Return Reason Code (Return Reason Code) | Return Reason | Code (Code) |
|
1..n |
Contract No. (Contract No.) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
No. (No.) | Service Cost | Code (Code) |
|
1..n |
Replaced Item No. (Replaced Item No.) | Service Item | No. (No.) |
|
1..n |
Service Price Group Code (Service Price Group Code) | Service Price Group | Code (Code) |
|
1..n |
Document No. (Document No.) | Service Shipment Header | No. (No.) |
|
1..n |
Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
No. (No.) | Standard Text | Code (Code) |
|
1..n |
Symptom Code (Symptom Code) | Symptom Code | Code (Code) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
Time Sheet Date (Time Sheet Date) | Time Sheet Detail | Date (Date) |
|
1..n |
Time Sheet No. (Time Sheet No.) | Time Sheet Header | No. (No.) |
|
1..n |
Time Sheet Line No. (Time Sheet Line No.) | Time Sheet Line | Line No. (Line No.) |
|
1..n |
Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Work Type Code (Work Type Code) | Work Type | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|