Table 5907 Service Ledger Entry in 19
- App
- Base Application
Fields, 62Keys, 8Procedures, 5Events, 2
Versions171819202122232425262728latest
Source29
Fields, 62
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Service Contract No. | Code[20] | - |
| 3 | Document Type | Enum Service Ledger Entry Document Type | - |
| 4 | Document No. | Code[20] | - |
| 5 | Serv. Contract Acc. Gr. Code | Code[10] | - |
| 6 | Document Line No. | Integer | - |
| 8 | Moved from Prepaid Acc. | Boolean | - |
| 9 | Posting Date | Date | - |
| 11 | Amount (LCY) | Decimal | - |
| 12 | Customer No. | Code[20] | - |
| 13 | Ship-to Code | Code[10] | - |
| 14 | Item No. (Serviced) | Code[20] | - |
| 15 | Serial No. (Serviced) | Code[50] | - |
| 16 | User ID | Code[50] | - |
| 17 | Contract Invoice Period | Text[30] | - |
| 18 | Global Dimension 1 Code | Code[20] | - |
| 19 | Global Dimension 2 Code | Code[20] | - |
| 20 | Service Item No. (Serviced) | Code[20] | - |
| 21 | Variant Code (Serviced) | Code[10] | - |
| 22 | Contract Group Code | Code[10] | - |
| 23 | Type | Enum Service Ledger Entry Type | - |
| 24 | No. | Code[20] | - |
| 25 | Cost Amount | Decimal | - |
| 26 | Discount Amount | Decimal | - |
| 27 | Unit Cost | Decimal | - |
| 28 | Quantity | Decimal | - |
| 29 | Charged Qty. | Decimal | - |
| 30 | Unit Price | Decimal | - |
| 31 | Discount % | Decimal | - |
| 32 | Contract Disc. Amount | Decimal | - |
| 33 | Bill-to Customer No. | Code[20] | - |
| 34 | Fault Reason Code | Code[10] | - |
| 35 | Description | Text[100] | - |
| 37 | Service Order Type | Code[10] | - |
| 39 | Service Order No. | Code[20] | - |
| 40 | Job No. | Code[20] | - |
| 41 | Gen. Bus. Posting Group | Code[20] | - |
| 42 | Gen. Prod. Posting Group | Code[20] | - |
| 43 | Location Code | Code[10] | - |
| 44 | Unit of Measure Code | Code[10] | - |
| 45 | Work Type Code | Code[10] | - |
| 46 | Bin Code | Code[20] | - |
| 47 | Responsibility Center | Code[10] | - |
| 48 | Variant Code | Code[10] | - |
| 50 | Entry Type | Enum Service Ledger Entry Entry Type | - |
| 51 | Open | Boolean | - |
| 52 | Serv. Price Adjmt. Gr. Code | Code[10] | - |
| 53 | Service Price Group Code | Code[10] | - |
| 54 | Prepaid | Boolean | - |
| 55 | Apply Until Entry No. | Integer | - |
| 56 | Applies-to Entry No. | Integer | - |
| 57 | Amount | Decimal | - |
| 58 | Job Task No. | Code[20] | - |
| 59 | Job Line Type | Enum Job Line Type | - |
| 60 | Job Posted | Boolean | - |
| 480 | Dimension Set ID | Integer | - |
| 481 | Shortcut Dimension 3 Code | Code[20] | - |
| 482 | Shortcut Dimension 4 Code | Code[20] | - |
| 483 | Shortcut Dimension 5 Code | Code[20] | - |
| 484 | Shortcut Dimension 6 Code | Code[20] | - |
| 485 | Shortcut Dimension 7 Code | Code[20] | - |
| 486 | Shortcut Dimension 8 Code | Code[20] | - |
Keys, 8
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Document No., Posting Date | - |
| Key3 | Entry Type, Document Type, Document No., Document Line No. | - |
| Key4 | 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 | - |
| Key5 | Service Order No., Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Posting Date, Open, Type, Service Contract No. | - |
| Key6 | Type, No., Entry Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid | - |
| Key7 | 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 | - |
| Key8 | Service Item No. (Serviced), Entry Type, Type, Service Contract No., Posting Date, Service Order No. | - |
Procedures, 5
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetLastEntryNo | () | Integer | public | - |
| ShowDimensions | () | public | - | |
| CopyFromServHeader | (Record Service Header) | public | - | |
| CopyFromServLine | (Record Service Line, Code[20]) | public | - | |
| CopyServicedInfo | (Code[20], Code[20], Code[50], Code[10]) | public | - |
Events, 2
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCopyFromServHeader | (var Record Service Ledger Entry, Record Service Header) | - |
| Integration event | OnAfterCopyFromServLine | (var Record Service Ledger Entry, Record Service Line) | - |