Table 5900 Service Header in 18
- App
- Base Application
Fields, 144Keys, 7Procedures, 37Events, 62
Versions171819202122232425262728latest
Source29
Fields, 144
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Document Type | Enum Service Document Type | - |
| 2 | Customer No. | Code[20] | - |
| 3 | No. | Code[20] | - |
| 4 | Bill-to Customer No. | Code[20] | - |
| 5 | Bill-to Name | Text[100] | - |
| 6 | Bill-to Name 2 | Text[50] | - |
| 7 | Bill-to Address | Text[100] | - |
| 8 | Bill-to Address 2 | Text[50] | - |
| 9 | Bill-to City | Text[30] | - |
| 10 | Bill-to Contact | Text[100] | - |
| 11 | Your Reference | Text[35] | - |
| 12 | Ship-to Code | Code[10] | - |
| 13 | Ship-to Name | Text[100] | - |
| 14 | Ship-to Name 2 | Text[50] | - |
| 15 | Ship-to Address | Text[100] | - |
| 16 | Ship-to Address 2 | Text[50] | - |
| 17 | Ship-to City | Text[30] | - |
| 18 | Ship-to Contact | Text[100] | - |
| 19 | Order Date | Date | - |
| 20 | Posting Date | Date | - |
| 22 | Posting Description | Text[100] | - |
| 23 | Payment Terms Code | Code[10] | - |
| 24 | Due Date | Date | - |
| 25 | Payment Discount % | Decimal | - |
| 26 | Pmt. Discount Date | Date | - |
| 27 | Shipment Method Code | Code[10] | - |
| 28 | Location Code | Code[10] | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | - |
| 31 | Customer Posting Group | Code[20] | - |
| 32 | Currency Code | Code[10] | - |
| 33 | Currency Factor | Decimal | - |
| 34 | Customer Price Group | Code[10] | - |
| 35 | Prices Including VAT | Boolean | - |
| 37 | Invoice Disc. Code | Code[20] | - |
| 40 | Customer Disc. Group | Code[20] | - |
| 41 | Language Code | Code[10] | - |
| 43 | Salesperson Code | Code[20] | - |
| 46 | Comment | Boolean | - |
| 47 | No. Printed | Integer | - |
| 52 | Applies-to Doc. Type | Enum Gen. Journal Document Type | - |
| 53 | Applies-to Doc. No. | Code[20] | - |
| 55 | Bal. Account No. | Code[20] | - |
| 62 | Shipping No. | Code[20] | - |
| 63 | Posting No. | Code[20] | - |
| 64 | Last Shipping No. | Code[20] | - |
| 65 | Last Posting No. | Code[20] | - |
| 70 | VAT Registration No. | Text[20] | - |
| 73 | Reason Code | Code[10] | - |
| 74 | Gen. Bus. Posting Group | Code[20] | - |
| 75 | EU 3-Party Trade | Boolean | - |
| 76 | Transaction Type | Code[10] | - |
| 77 | Transport Method | Code[10] | - |
| 78 | VAT Country/Region Code | Code[10] | - |
| 79 | Name | Text[100] | - |
| 80 | Name 2 | Text[50] | - |
| 81 | Address | Text[100] | - |
| 82 | Address 2 | Text[50] | - |
| 83 | City | Text[30] | - |
| 84 | Contact Name | Text[100] | - |
| 85 | Bill-to Post Code | Code[20] | - |
| 86 | Bill-to County | Text[30] | - |
| 87 | Bill-to Country/Region Code | Code[10] | - |
| 88 | Post Code | Code[20] | - |
| 89 | County | Text[30] | - |
| 90 | Country/Region Code | Code[10] | - |
| 91 | Ship-to Post Code | Code[20] | - |
| 92 | Ship-to County | Text[30] | - |
| 93 | Ship-to Country/Region Code | Code[10] | - |
| 94 | Bal. Account Type | Enum Payment Balance Account Type | - |
| 97 | Exit Point | Code[10] | - |
| 98 | Correction | Boolean | - |
| 99 | Document Date | Date | - |
| 101 | Area | Code[10] | - |
| 102 | Transaction Specification | Code[10] | - |
| 104 | Payment Method Code | Code[10] | - |
| 105 | Shipping Agent Code | Code[10] | - |
| 107 | No. Series | Code[20] | - |
| 108 | Posting No. Series | Code[20] | - |
| 109 | Shipping No. Series | Code[20] | - |
| 114 | Tax Area Code | Code[20] | - |
| 115 | Tax Liable | Boolean | - |
| 116 | VAT Bus. Posting Group | Code[20] | - |
| 117 | Reserve | Enum Reserve Method | - |
| 118 | Applies-to ID | Code[50] | - |
| 119 | VAT Base Discount % | Decimal | - |
| 120 | Status | Enum Service Document Status | - |
| 121 | Invoice Discount Calculation | Option | - |
| 122 | Invoice Discount Value | Decimal | - |
| 130 | Release Status | Option | - |
| 480 | Dimension Set ID | Integer | - |
| 1200 | Direct Debit Mandate ID | Code[35] | - |
| 5052 | Contact No. | Code[20] | - |
| 5053 | Bill-to Contact No. | Code[20] | - |
| 5700 | Responsibility Center | Code[10] | - |
| 5750 | Shipping Advice | Enum Sales Header Shipping Advice | - |
| 5752 | Completely Shipped | Boolean | - |
| 5754 | Location Filter | Code[10] | - |
| 5792 | Shipping Time | DateFormula | - |
| 5794 | Shipping Agent Service Code | Code[10] | - |
| 5796 | Date Filter | Date | - |
| 5902 | Description | Text[100] | - |
| 5904 | Service Order Type | Code[10] | - |
| 5905 | Link Service to Service Item | Boolean | - |
| 5907 | Priority | Option | - |
| 5911 | Allocated Hours | Decimal | - |
| 5915 | Phone No. | Text[30] | - |
| 5916 | Text[80] | - | |
| 5917 | Phone No. 2 | Text[30] | - |
| 5918 | Fax No. | Text[30] | - |
| 5921 | No. of Unallocated Items | Integer | - |
| 5923 | Order Time | Time | - |
| 5924 | Default Response Time (Hours) | Decimal | - |
| 5925 | Actual Response Time (Hours) | Decimal | - |
| 5926 | Service Time (Hours) | Decimal | - |
| 5927 | Response Date | Date | - |
| 5928 | Response Time | Time | - |
| 5929 | Starting Date | Date | - |
| 5930 | Starting Time | Time | - |
| 5931 | Finishing Date | Date | - |
| 5932 | Finishing Time | Time | - |
| 5933 | Contract Serv. Hours Exist | Boolean | - |
| 5934 | Reallocation Needed | Boolean | - |
| 5936 | Notify Customer | Option | - |
| 5937 | Max. Labor Unit Price | Decimal | - |
| 5938 | Warning Status | Option | - |
| 5939 | No. of Allocations | Integer | - |
| 5940 | Contract No. | Code[20] | - |
| 5951 | Type Filter | Option | - |
| 5952 | Customer Filter | Code[20] | - |
| 5953 | Resource Filter | Code[20] | - |
| 5954 | Contract Filter | Code[20] | - |
| 5955 | Ship-to Fax No. | Text[30] | - |
| 5956 | Ship-to E-Mail | Text[80] | - |
| 5957 | Resource Group Filter | Code[20] | - |
| 5958 | Ship-to Phone | Text[30] | - |
| 5959 | Ship-to Phone 2 | Text[30] | - |
| 5966 | Service Zone Filter | Code[10] | - |
| 5968 | Service Zone Code | Code[10] | - |
| 5981 | Expected Finishing Date | Date | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 7001 | Allow Line Disc. | Boolean | - |
| 9000 | Assigned User ID | Code[50] | - |
| 9001 | Quote No. | Code[20] | - |
Keys, 7
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Document Type, No. | - |
| Key2 | No., Document Type | - |
| Key3 | Customer No., Order Date | - |
| Key4 | Contract No., Status, Posting Date | - |
| Key5 | Status, Response Date, Response Time, Priority, Responsibility Center | - |
| Key6 | Status, Priority, Response Date, Response Time | - |
| Key7 | Document Type, Customer No., Order Date | - |
Procedures, 37
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| AssistEdit | (Record Service Header) | Boolean | public | - | |||
| CreateDim | (Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20]) | public | - | ||||
| UpdateAllLineDim | (Integer, Integer) | public | - | ||||
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| RecreateServLines | (Text[100]) | public | - | ||||
| TestMandatoryFields | (var Record Service Line) | public | - | ||||
| UpdateResponseDateTime | () | public | - | ||||
| ServItemLineExists | () | Boolean | public | - | |||
| ServLineExists | () | Boolean | public | - | |||
| SetHideValidationDialog | (Boolean) | public | - | ||||
| SetValidatingFromLines | (Boolean) | public | - | ||||
| CheckCreditMaxBeforeInsert | (Boolean) | public | - | ||||
| UpdateServiceOrderChangeLog | (var Record Service Header) | public | - | ||||
| InitRecord | () | public | - | ||||
| SetShipToAddress | (Text[100], Text[50], Text[100], Text[50], Text[30], Code[20], Text[30], Code[10]) | public | - | ||||
| ConfirmDeletion | () | Boolean | public | - | |||
| ShowDocDim | () | public | - | ||||
| LookupAdjmtValueEntries | (Option) | public | - | ||||
| CalcInvDiscForHeader | () | public | - | ||||
| SetSecurityFilterOnRespCenter | () | public | - | ||||
| SetShipToCustomerAddressFieldsFromShipToAddr | (Record Ship-to Address) | public | - | ||||
| InventoryPickConflict | (Option, Code[20], Option) | Boolean | public | Pending 18.0 | |||
| Replaced by WhsePickConflict(). | |||||||
| WhsePickConflict | (Enum Service Document Type, Code[20], Enum Sales Header Shipping Advice) | Boolean | public | - | |||
| InvPickConflictResolutionTxt | () | Text[500] | public | - | |||
| WhseShpmntConflict | (Option, Code[20], Option) | Boolean | public | Pending 18.0 | |||
| Replaced by WhseShipmentConflict(). | |||||||
| WhseShipmentConflict | (Enum Service Document Type, Code[20], Enum Sales Header Shipping Advice) | Boolean | public | - | |||
| WhseShpmtConflictResolutionTxt | () | Text[500] | public | - | |||
| SetCustomerFromFilter | () | public | - | ||||
| CopyCustomerFilter | () | public | - | ||||
| ConfirmCloseUnposted | () | Boolean | public | - | |||
| ValidateSalesPersonOnServiceHeader | (Record Service Header, Boolean, Boolean) | public | - | ||||
| GetHideValidationDialog | () | Boolean | public | - | |||
| GetFullDocTypeTxt | () | Text | public | - | |||
| IsCreditDocType | () | Boolean | public | - | |||
| UpdateServLinesByFieldNo | (Integer, Boolean) | public | - | ||||
| OpenStatistics | () | public | - | ||||
| OpenOrderStatistics | () | public | - | ||||
Events, 62
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnBeforeGetFullDocTypeTxt | (var Record Service Header, var Text, var Boolean) | - | ||||
| Integration event | OnAfterCopyCustomerFields | (var Record Service Header, Record Customer) | - | ||||
| Integration event | OnAfterCopyBillToCustomerFields | (var Record Service Header, Record Customer) | - | ||||
| Integration event | OnAfterCopyShipToCustomerAddressFieldsFromCustomer | (var Record Service Header, Record Customer) | - | ||||
| Integration event | OnAfterCopyShipToCustomerAddressFieldsFromShipToAddr | (var Record Service Header, Record Ship-to Address) | - | ||||
| Integration event | OnAfterGetPostingNoSeriesCode | (var Record Service Header, var Code[20]) | - | ||||
| Integration event | OnAfterInitRecord | (var Record Service Header) | - | ||||
| Integration event | OnAfterUpdateShipToAddress | (var Record Service Header) | - | ||||
| Integration event | OnUpdateServLineByChangedFieldName | (Record Service Header, var Record Service Line, Text[100]) | - | ||||
| Integration event | OnAfterCreateDimTableIDs | (var Record Service Header, Integer, var Integer, var Code[20]) | - | ||||
| Integration event | OnAfterValidateShortcutDimCode | (var Record Service Header, Record Service Header, Integer, var Code[20]) | - | ||||
| Integration event | OnAfterUpdateCust | (var Record Service Header) | - | ||||
| Integration event | OnAfterTransferExtendedTextForServLineRecreation | (var Record Service Line) | - | ||||
| Integration event | OnBeforeCheckBlockedCustomer | (var Record Customer, var Boolean) | - | ||||
| Integration event | OnBeforeCheckDocumentTypeAlreadyUsed | (var Record Service Header, var Record Service Shipment Header, var Boolean) | - | ||||
| Integration event | OnBeforeConfirmUpdateContractNo | (var Record Service Header, var Boolean, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeCopyShipToCustomerAddressFieldsFromCustomer | (var Record Service Header, Record Customer, var Boolean) | - | ||||
| Integration event | OnBeforeCopyShipToCustomerAddressFieldsFromShipToAddr | (var Record Service Header, Record Ship-to Address, var Boolean) | - | ||||
| Integration event | OnBeforeCreateDim | (var Record Service Header, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeGetNoSeries | (var Record Service Header, var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeGetPostingNoSeriesCode | (var Record Service Header, Record Service Mgt. Setup, var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeInsertServLineOnServLineRecreation | (var Record Service Line, var Record Service Line) | - | ||||
| Integration event | OnBeforeTestMandatoryFields | (var Record Service Header, var Record Service Line) | - | ||||
| Integration event | OnBeforeTestNoSeries | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeTestNoSeriesManual | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeValidateServiceZoneCode | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Service Header, var Record Service Header, Integer, var Code[20]) | - | ||||
| Integration event | OnBeforeUpdateAllLineDim | (var Record Service Header, Integer, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeUpdateCust | (Code[20], var Boolean) | - | ||||
| Integration event | OnCreateDimOnBeforeUpdateLines | (var Record Service Header, Record Service Header, Integer) | - | ||||
| Integration event | OnRecreateServLinesOnBeforeUpdateLines | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnValidateCustomerNoOnBeforeDeleteLines | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnValidateCustomerNoOnBeforeModify | (var Record Service Header, Integer) | - | ||||
| Integration event | OnValidateVATBaseDiscountPctOnBeforeUpdateLineAmounts | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnValidatePaymentTermsCodeOnBeforeValidateDueDate | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnValidateShipToCodeOnBeforeDleereLines | (var Record Service Header, var Boolean) | Pending 18.0 | ||||
| replaced by OnValidateShipToCodeOnBeforeDeleteLines | |||||||
| Integration event | OnValidateShipToCodeOnBeforeDeleteLines | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeConfirmRecalculatePrice | (Record Service Header, var Boolean, var Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeSetSalespersonCode | (var Record Service Header, Code[20], var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeShowPostedDocsToPrintCreatedMsg | (var Boolean) | - | ||||
| Integration event | OnBeforeRecreateServLines | (var Record Service Header, Record Service Header, Text[100], var Boolean) | - | ||||
| Integration event | OnBeforeConfirmRecreateServLines | (var Record Service Header, Record Service Header, Text[100], var Boolean, var Boolean, var Boolean) | - | ||||
| Integration event | OnUpdateAllLineDimOnBeforeGetServLineNewDimSetID | (var Record Service Line, Integer, Integer) | - | ||||
| Integration event | OnUpdateAllLineDimOnBeforeGetServItemLineNewDimSetID | (var Record Service Item Line, Integer, Integer) | - | ||||
| Integration event | OnRecreateServLinesOnAfterServLineSetFilters | (var Record Service Line) | - | ||||
| Integration event | OnRecreateServLinesOnBeforeServLineDeleteAll | (var Record Service Header, var Record Service Line, Integer, var Boolean) | - | ||||
| Integration event | OnRecreateServLinesOnAfterTempServLineDeleteAll | (Record Service Header) | - | ||||
| Integration event | OnTestMandatoryFieldsOnBeforePassedServLineFind | (Record Service Header, var Record Service Line, var Record Service Line, var Boolean) | - | ||||
| Integration event | OnAfterGetServiceMgtSetup | (var Record Service Mgt. Setup, Record Service Header, Integer) | - | ||||
| Integration event | OnBeforeUpdateCurrencyFactor | (var Record Service Header, var Record Currency Exchange Rate) | - | ||||
| Integration event | OnBeforeUpdateShipToAddress | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnAfterGetNoSeriesCode | (var Record Service Header, Record Service Mgt. Setup, var Code[20]) | - | ||||
| Integration event | OnAfterUpdateBillToCont | (var Record Service Header, Record Customer, Record Contact) | - | ||||
| Integration event | OnAfterUpdateServLinesByFieldNo | (var Record Service Header, var Record Service Line, Integer) | - | ||||
| Integration event | OnBeforeLookupAppliesToDocNo | (var Record Service Header, var Record Cust. Ledger Entry, var Boolean) | - | ||||
| Integration event | OnBeforeOpenOrderStatistics | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeOpenStatistics | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnBeforeValidateAppliesToDocNo | (var Record Service Header, var Record Cust. Ledger Entry, Record Service Header, var Boolean) | - | ||||
| Integration event | OnValidateShipToCodeOnAfterCalcShouldUpdateShipToAddressFields | (var Record Service Header, var Boolean) | - | ||||
| Integration event | OnInsertOnBeforeInitRecord | (var Record Service Header, Record Service Header) | - | ||||
| Integration event | OnUpdateBillToCustOnAfterUpdateBillToContact | (var Record Service Header, Record Customer, Record Contact) | - | ||||
| Integration event | OnShowDocDimOnBeforeUpdateAllLineDim | (var Record Service Header, Integer, Integer) | - | ||||