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