Service Transfer Header History (SVC30700)

azurecurve Products FieldService (949)ProjectService Transfer Header History (SVC30700)

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

Display Name: Service Transfer Header History
Physical Name: SVC30700
Technical Name: SVC_Transfer_HDR_HIST

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ORDDOCID	Order Document ID	String	STR15_LBAU	15
2	RFRNCDOC	Reference Document	String	STR20	20
3	TECHID	Tech ID	String	STR10_LBAU	10
4	OFFID	Office ID	String	STR10_LBAU	10
5	STATUS	Transfer Status	Integer	INT	0
6	ORDRDATE	Order Date	Date	DT	8
7	ETADTE	ETA Date	Date	DT_Date	6
8	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
9	ADDRESS1	Address 1	String	STR60	60
10	ADDRESS2	Address 2	String	STR60	60
11	CITY	City	String	STR35	35
12	STATE	State	String	STR30_State	29
13	ZIPCODE	Zip Code	String	STR10	10
14	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Service Transfer Header History'].SHIPMTHD AS 'Service Transfer Header History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC30700 AS ['Service Transfer Header History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Service Transfer Header History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
15	TRNSFLOC	Transfer From Location	String	STR10_Location_Code	10
16	ITLOCN	Intransit Location	String	STR10_Location_Code	10
17	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Service Transfer Header History'].LOCNCODE AS 'Service Transfer Header History-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC30700 AS ['Service Transfer Header History'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Service Transfer Header History'].LOCNCODE = ['Site Setup'].LOCNCODE
18	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Service Transfer Header History'].NOTEINDX AS 'Service Transfer Header History-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC30700 AS ['Service Transfer Header History'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Service Transfer Header History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19	SVC_Address_Option	SVC_Address_Option	Integer	DDL_Address_Option	0
20	SVC_Misc_Address_Code	SVC_Misc_Address_Code	String	STR15_Address_Code	15
21	ADDRESS3	Address 3	String	STR60	60
22	COUNTRY	Country	String	STR60	60
23	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Service Transfer Header History'].USERID AS 'Service Transfer Header History-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC30700 AS ['Service Transfer Header History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Service Transfer Header History'].USERID = ['Users Master'].USERID

azurecurve Products FieldService (949)ProjectService Transfer Header History (SVC30700)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply