PM Sched Header (SVC8005)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC8005

Product: FieldService (949)
Series: Project

Display Name: PM Sched Header
Physical Name: SVC8005
Technical Name: SVC_Maintenance_Schedule_HDR

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SCHEDID SearchSched_IDSTR8_LBUString108
2SCHEDDESC SearchSched_DescriptionSTR50String5250
3SRVTYPE SearchService TypeSTR10_LBAUString1210
4UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PM Sched Header'].UOMSCHDL AS 'PM Sched Header-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       SVC8005 AS ['PM Sched Header']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PM Sched Header'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
5DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *