Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Entry No. (Entry No.) | Integer | ||
| 2 | Service Contract No. (Service Contract No.) | Code20 |
|
|
| 3 | Document Type (Document Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund,Shipment] | |
| 4 | Document No. (Document No.) | Code20 | ||
| 5 | Serv. Contract Acc. Gr. Code (Serv. Contract Acc. Gr. Code) | Code10 |
|
|
| 6 | Document Line No. (Document Line No.) | Integer | ||
| 8 | Moved from Prepaid Acc. (Moved from Prepaid Acc.) | Boolean | ||
| 9 | Posting Date (Posting Date) | Date | ||
| 11 | Amount (LCY) (Amount (LCY)) | Decimal | AutoFormatType: 1 | |
| 12 | Customer No. (Customer No.) | Code20 |
|
|
| 13 | Ship-to Code (Ship-to Code) | Code10 |
|
|
| 14 | Item No. (Serviced) (Item No. (Serviced)) | Code20 |
|
|
| 15 | Serial No. (Serviced) (Serial No. (Serviced)) | Code20 | ||
| 16 | User ID (User ID) | Code50 |
|
|
| 17 | Contract Invoice Period (Contract Invoice Period) | Text30 | ||
| 18 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 19 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 20 | Service Item No. (Serviced) (Service Item No. (Serviced)) | Code20 |
|
|
| 21 | Variant Code (Serviced) (Variant Code (Serviced)) | Code10 |
|
|
| 22 | Contract Group Code (Contract Group Code) | Code10 |
|
|
| 23 | Type (Type) | Option | [ ,Resource,Item,Service Cost,Service Contract,G/L Account] | |
| 24 | No. (No.) | Code20 |
|
|
| 25 | Cost Amount (Cost Amount) | Decimal | AutoFormatType: 1 | |
| 26 | Discount Amount (Discount Amount) | Decimal | AutoFormatType: 1 | |
| 27 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
| 28 | Quantity (Quantity) | Decimal (0:5) | ||
| 29 | Charged Qty. (Charged Qty.) | Decimal (0:5) | ||
| 30 | Unit Price (Unit Price) | Decimal | AutoFormatType: 2 | |
| 31 | Discount % (Discount %) | Decimal (0:5) | ||
| 32 | Contract Disc. Amount (Contract Disc. Amount) | Decimal | AutoFormatType: 1 | |
| 33 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
|
| 34 | Fault Reason Code (Fault Reason Code) | Code10 |
|
|
| 35 | Description (Description) | Text50 | ||
| 37 | Service Order Type (Service Order Type) | Code10 |
|
|
| 39 | Service Order No. (Service Order No.) | Code20 | ||
| 40 | Job No. (Job No.) | Code20 |
|
|
| 41 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
| 42 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
| 43 | Location Code (Location Code) | Code10 |
|
|
| 44 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 45 | Work Type Code (Work Type Code) | Code10 |
|
|
| 46 | Bin Code (Bin Code) | Code20 |
|
|
| 47 | Responsibility Center (Responsibility Center) | Code10 |
|
|
| 48 | Variant Code (Variant Code) | Code10 |
|
|
| 50 | Entry Type (Entry Type) | Option | [Usage,Sale,Consume,Contract] | |
| 51 | Open (Open) | Boolean | ||
| 52 | Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) | Code10 |
|
|
| 53 | Service Price Group Code (Service Price Group Code) | Code10 |
|
|
| 54 | Prepaid (Prepaid) | Boolean | ||
| 55 | Apply Until Entry No. (Apply Until Entry No.) | Integer | ||
| 56 | Applies-to Entry No. (Applies-to Entry No.) | Integer | AccessByPermission: TableData 27=R | |
| 57 | Amount (Amount) | Decimal | AutoFormatType: 1 | |
| 58 | Job Task No. (Job Task No.) | Code20 |
|
|
| 59 | Job Line Type (Job Line Type) | Option | [ ,Schedule,Contract,Both Schedule and Contract] InitValue: Schedule |
|
| 60 | Job Posted (Job Posted) | Boolean | ||
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. (Entry No.) | Clustered: Yes | |
| 1 | Document No.,Posting Date (Document No.,Posting Date) | ||
| 2 | Entry Type,Document Type,Document No.,Document Line No. (Entry Type,Document Type,Document No.,Document Line No.) | ||
| 3 | Service Contract No.,Entry No.,Entry Type,Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid,Service Item No. (Serviced),Customer No.,Contract Group Code,Responsibility Center (Service Contract No.,Entry No.,Entry Type,Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid,Service Item No. (Serviced),Customer No.,Contract Group Code,Responsibility Center) | SumIndexFields: Amount (LCY),Cost Amount,Quantity,Charged Qty.,Contract Disc. Amount | |
| 4 | Service Order No.,Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Type,Service Contract No. (Service Order No.,Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Type,Service Contract No.) | SumIndexFields: Amount (LCY),Cost Amount,Quantity,Charged Qty.,Amount | |
| 5 | Type,No.,Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid (Type,No.,Entry Type,Moved from Prepaid Acc.,Posting Date,Open,Prepaid) | SumIndexFields: Amount (LCY),Cost Amount,Quantity,Charged Qty. | |
| 6 | Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Type,Posting Date,Open,Service Contract No.,Prepaid,Customer No.,Contract Group Code,Responsibility Center (Service Item No. (Serviced),Entry Type,Moved from Prepaid Acc.,Type,Posting Date,Open,Service Contract No.,Prepaid,Customer No.,Contract Group Code,Responsibility Center) | SumIndexFields: Amount (LCY),Cost Amount | |
| 7 | Service Item No. (Serviced),Entry Type,Type,Service Contract No.,Posting Date,Service Order No. (Service Item No. (Serviced),Entry Type,Type,Service Contract No.,Posting Date,Service Order No.) | SumIndexFields: Amount (LCY),Cost Amount,Quantity,Charged Qty. |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bin Code (Bin Code) | Bin | Code (Code) |
|
1..n |
| Contract Group Code (Contract Group Code) | Contract Group | Code (Code) |
|
1..n |
| Bill-to Customer No. (Bill-to Customer No.) | Customer | No. (No.) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | 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 |
| No. (No.) | Item | No. (No.) |
|
1..n |
| Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
| Job No. (Job No.) | Job | No. (No.) |
|
1..n |
| Job Task No. (Job Task No.) | Job Task | Job Task No. (Job Task No.) |
|
1..n |
| Location Code (Location Code) | Location | Code (Code) |
|
1..n |
| No. (No.) | Resource | No. (No.) |
|
1..n |
| Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
| Serv. Contract Acc. Gr. Code (Serv. Contract Acc. Gr. Code) | Service Contract Account Group | Code (Code) |
|
1..n |
| No. (No.) | Service Contract Header | Contract No. (Contract No.) |
|
1..n |
| No. (No.) | Service Cost | Code (Code) |
|
1..n |
| Service Item No. (Serviced) (Service Item No. (Serviced)) | Service Item | No. (No.) |
|
1..n |
| Service Order Type (Service Order Type) | Service Order Type | Code (Code) |
|
1..n |
| Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) | Service Price Adjustment Group | Code (Code) |
|
1..n |
| Service Price Group Code (Service Price Group Code) | Service Price Group | Code (Code) |
|
1..n |
| Ship-to Code (Ship-to Code) | Ship-to Address | Code (Code) |
|
1..n |
| No. (No.) | Standard Text | Code (Code) |
|
1..n |
| Unit of Measure Code (Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
| User ID (User ID) | User | User Name (User Name) |
|
1..n |
| Work Type Code (Work Type Code) | Work Type | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Service Register | To Entry No. (To Entry No.) |
|
1..n |