Depot Station ID Codes (SVC06001)

azurecurveProductsFieldService (949)ProjectDepot Station ID Codes (SVC06001)

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

Product: FieldService (949)
Series:

Display Name: Depot Station ID Codes
Physical Name: SVC06001
Technical Name: SVC_Codes_Depot_StationID

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1STATIONID SearchDepot Station IDStringSTR10_LBAU10
2DSCRIPTN SearchDescriptionStringSTR3030
3LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Depot Station ID Codes'].LOCNCODE AS 'Depot Station ID Codes-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC06001 AS ['Depot Station ID Codes']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Depot Station ID Codes'].LOCNCODE = ['Site Setup'].LOCNCODE
4ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Depot Station ID Codes'].ITEMNMBR AS 'Depot Station ID Codes-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC06001 AS ['Depot Station ID Codes']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Depot Station ID Codes'].ITEMNMBR = ['Item Master'].ITEMNMBR
5WORKDYS_1 SearchWork Days[1]BooleanCB0
6WORKDYS SearchWork DaysCBBoolean0
7WORKDYS_2 SearchWork Days[2]BooleanCB0
8WORKDYS_3 SearchWork Days[3]BooleanCB0
9WORKDYS_4 SearchWork Days[4]BooleanCB0
10WORKDYS_5 SearchWork Days[5]BooleanCB0
11WORKDYS_6 SearchWork Days[6]BooleanCB0
12WORKDYS_7 SearchWork Days[7]BooleanCB0
13WORKSTRT_1 SearchWork Start[1]TimeTM66
14WORKSTRT_2 SearchWork Start[2]TimeTM66
15WORKSTRT SearchWork StartTM6Time6
16WORKSTRT_3 SearchWork Start[3]TimeTM66
17WORKSTRT_4 SearchWork Start[4]TimeTM66
18WORKSTRT_5 SearchWork Start[5]TimeTM66
19WORKSTRT_6 SearchWork Start[6]TimeTM66
20WORKSTRT_7 SearchWork Start[7]TimeTM66
21WORKEND_1 SearchWork End[1]TimeTM66
22WORKEND_2 SearchWork End[2]TimeTM66
23WORKEND SearchWork EndTM6Time6
24WORKEND_3 SearchWork End[3]TimeTM66
25WORKEND_4 SearchWork End[4]TimeTM66
26WORKEND_5 SearchWork End[5]TimeTM66
27WORKEND_6 SearchWork End[6]TimeTM66
28WORKEND_7 SearchWork End[7]TimeTM66
29PRETIME SearchPre Station TimeIntegerINT54
30POSTTIME SearchPost Station TimeIntegerINT54
31svcPostToPayroll SearchsvcPostToPayrollBooleanCB0
32PAYRCORD SearchPay RecordStringSTR6_Payroll_Code6
azurecurveProductsFieldService (949)ProjectDepot Station ID Codes (SVC06001)

Leave a Reply

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