PM Sched Header (SVC8005)

Easily find this page again using the shortlink:

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 TypeLength
1SCHEDID SearchSched_IDSTR8_LBUString8
2SCHEDDESC SearchSched_DescriptionSTR50String50
3SRVTYPE SearchService TypeSTR10_LBAUString10
4UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

       ['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'
       SVC8005 AS ['PM Sched Header']
       IV40201 AS ['Inventory U of M Schedule Setup']
                     ['PM Sched Header'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
5DEX_ROW_ID Searchintint10

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 *