Query "Service Analysis"
The Service Analysis is a query that joins data from service ledger entries with service master data.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Service Ad-hoc Analysis |
| AboutTitle | About Service Ad-hoc Analysis |
| AboutText | The Service Analysis is a query that joins data from service ledger entries with service master data. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| ServiceContractNo | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| DocumentType | ServiceLedgerEntry | Enum Microsoft.Service.Ledger."Service Ledger Entry Document Type" | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| DocumentNo | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| DocumentLineNo | ServiceLedgerEntry | Integer | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Type | ServiceLedgerEntry | Enum Microsoft.Service.Ledger."Service Ledger Entry Type" | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| No | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Description | ServiceLedgerEntry | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| MovedFromPrepaidAcc | ServiceLedgerEntry | Boolean | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| PostingDate | ServiceLedgerEntry | Date | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| AmountLCY | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShipToCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ContractInvoicePeriod | ServiceLedgerEntry | Text[30] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| VariantCodeServiced | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ContractGroupCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| CostAmount | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| DiscountAmount | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| UnitCost | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Quantity | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ChargedQty | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| UnitPrice | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| DiscountPercentage | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ContractDiscountAmount | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| FaultReasonCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceOrderType | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceOrderNo | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| UnitOfMeasureCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| BinCode | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ResponsibilityCenter | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| VariantCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| EntryType | ServiceLedgerEntry | Enum Microsoft.Service.Ledger."Service Ledger Entry Entry Type" | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Open | ServiceLedgerEntry | Boolean | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServicePriceAdjmtGrCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServicePriceGroupCode | ServiceLedgerEntry | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Prepaid | ServiceLedgerEntry | Boolean | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ApplyUntilEntryNo | ServiceLedgerEntry | Integer | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| AppliesToEntryNo | ServiceLedgerEntry | Integer | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| Amount | ServiceLedgerEntry | Decimal | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| GlobalDimension1Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| GlobalDimension2Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension3Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension4Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension5Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension6Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension7Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ShortcutDimension8Code | ServiceLedgerEntry | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceContractDesc | Service_Contract_Header | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceContractAccGroupCode | ServiceContractAccountGroup | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceContractAccGroupDesc | ServiceContractAccountGroup | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| CustomerNo | Customer | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| CustomerName | Customer | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| BillToCustomerNo | BillToCustomer | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| BillToCustomerName | BillToCustomer | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ItemServicedNo | ItemServiced | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ItemServicedDescription | ItemServiced | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceItemServicedNo | ServiceItemServiced | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| ServiceItemServicedDescription | ServiceItemServiced | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| JobDescription | Job | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| JobTaskNo | JobTask | Code[20] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| JobTaskDescription | JobTask | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| WorkTypeCode | WorkType | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| WorkTypeDescription | WorkType | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| LocationCode | Location | Code[10] | The Service Analysis is a query that joins data from service ledger entries with service master data. |
| LocationName | Location | Text[100] | The Service Analysis is a query that joins data from service ledger entries with service master data. |