Depot Master (SVC06100)

azurecurve Products FieldService (949)ProjectDepot Master (SVC06100)

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

Display Name: Depot Master
Physical Name: SVC06100
Technical Name: SVC_Depot_MSTR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	WORECTYPE	Work Order Record Type	Integer	DDL_Work_Order_Record_Type	0
2	WORKORDNUM	Work Order Number	String	STR10_LBAU	10
3	WOSTAT	Work Order Status	String	STR3_LBU	3
4	WOTYPE	Work Order Type	String	STR10_LBAU	10
5	SVC_Depot_Priority	SVC_Depot_Priority	Currency	SVC_Depot_Priority	7
6	PARWORECTYPE	Parent Work Order Record Type	Integer	INT	0
7	PARWONUM	Parent Work Order Number	String	STR15_LBAU	15
8	ORIGIN	Origin	Integer	DDL	0
9	REFRENCE	Reference	String	STR30	30
10	TIMEZONE	TimeZone	String	STR3_LBU	3
11	ENTDTE	Entry Date	Date	DT_Date	6
12	ENTTME	Entry Time	Time	TM6	6
13	ETADTE	ETA Date	Date	DT_Date	6
14	ETATME	ETA Time	Time	TM6	6
15	ECOMPDT	EComp Date	Date	DT_Date	6
16	EComp_Time	EComp Time	Time	TM6	6
17	RETUDATE	Return Date	Date	DT	8
18	Return_Time	Return Time	Time	TM6	6
19	COMPDTE	Complete Date	Date	DT_Date	6
20	COMPTME	Complete Time	Time	TM6	6
21	BIN	Bin	String	STR15_Bin	15
22	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Depot Master'].USERID AS 'Depot Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC06100 AS ['Depot Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Depot Master'].USERID = ['Users Master'].USERID
23	OFFID	Office ID	String	STR10_LBAU	10
24	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Depot Master'].CUSTNMBR AS 'Depot Master-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC06100 AS ['Depot Master'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Depot Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
25	ADRSCODE	Address Code	String	STR15_Address_Code	15
26	ADDRESS1	Address 1	String	STR60	60
27	ADDRESS2	Address 2	String	STR60	60
28	CITY	City	String	STR35	35
29	STATE	State	String	STR30_State	29
30	ZIPCODE	Zip Code	String	STR10	10
31	RETDOCID	Return Document ID	String	STR15_LBAU	15
32	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
33	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
34	CALLNBR	Service Call Number	String	STR10_LBAU	10
35	SERVLITEMSEQ	Service Line Item Sequence	Long Integer	LI_Sequence_Number	10
36	IBITEMNUM	Inbound Item Number	String	STR30_Item_Number	30
37	IBSERIAL	Inbound Serial Number	String	STR20_LBAU	20
38	IBEQUIPID	Inbound Equipment ID	Long Integer	Long Int	8
39	OBITEMNUM	Outbound Item Number	String	STR30_Item_Number	30
40	OBSERIAL	Outbound Serial Number	String	STR20_LBAU	20
41	OBEQUIPID	Outbound Equipment ID	Long Integer	Long Int	8
42	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
43	STATIONID	Depot Station ID	String	STR10_LBAU	10
44	ROUTEID	Route ID	String	STR10_LBAU	10
45	SEQUENCE1	Sequence	Currency	DLR19_$S2	19
46	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Depot Master'].LOCNCODE AS 'Depot Master-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC06100 AS ['Depot Master'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Depot Master'].LOCNCODE = ['Site Setup'].LOCNCODE
47	IBANALCODE	Inbound Analysis Code	String	STR10_LBAU	10
48	OBANALCODE	Outbound Analysis Code	String	STR10_LBAU	10
49	CUSTOWN	Customer Owned	Boolean	CB	0
50	ORDDOCID	Order Document ID	String	STR15_LBAU	15
51	TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	LI_Sequence_Number	10
52	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Depot Master'].NOTEINDX AS 'Depot Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC06100 AS ['Depot Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Depot Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
53	FACTSEAL	Factory Sealed	Boolean	CB	0
54	LABSTOTCST	Labor Sub Total Cost	Currency	DLR17_RBS0_STR$	17
55	PARSTOTCST	Part Sub Total Cost	Currency	DLR17_RBS0_STR$	17
56	TOTLABHRS	Total Labor Hours	Currency	DLR17_QTY_RBS0_UTR	17
57	PRICELVL	Price Level	String	STR15_LBAU	15
58	NUMRESCHED	Number of Reschedules	Integer	INT	0
59	Commit_Date	Commit Date	Date	DT_Date	6
60	Commit_Time	Commit Time	Time	TM6	6
61	USERDEF1	User Defined 1	String	STR20	20
62	USERDEF2	User Defined 2	String	STR20	20
63	USRDEF03	User Defined 3	String	STR20	20
64	USRDEF04	User Defined 4	String	STR20	20
65	USRDEF05	User Defined 5	String	STR20	20
66	ADDRESS3	Address 3	String	STR60	60
67	COUNTRY	Country	String	STR60	60
68	SVC_RMA_Reason_Code	SVC_RMA_Reason_Code	String	STR3_LBAU	3
69	SVC_RMA_Reason_Code_Desc	SVC_RMA_Reason_Code_Desc	String	STR30	30
70	SVC_Process_SEQ_Number	SVC Process SEQ Number	Currency	Sequence_Number	19
71	svcRMAComponentSeq	svcRMAComponentSeq	Long Integer	LI_Sequence_Number	10
72	QTYTYPE	QTY Type	Integer	DDL_QTY_Type	0

azurecurve Products FieldService (949)ProjectDepot Master (SVC06100)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply