SVC_RTV_Line_HIST (SVC35601)

azurecurve Products FieldService (949)ProjectSVC_RTV_Line_HIST (SVC35601)

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

Display Name: SVC_RTV_Line_HIST
Physical Name: SVC35601
Technical Name: SVC_RTV_Line_HIST

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RTV_Number	RTV Number	String	STR15_LBAU	15
2	RTV_Line	RTV Line	Currency	Sequence_Number	19
3	RTV_Type	RTV Type	String	STR10_LBAU	10
4	RTV_Status	RTV Status	Integer	DDL_RTV_Type	0
5	RTV_Return_Status	RTV Return Status	String	STR3_LBAU	3
6	VRMA_Document_ID	VRMA Document ID	String	STR15_LBAU	15
7	RETDOCID	Return Document ID	String	STR15_LBAU	15
8	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
9	SVC_Process_SEQ_Number	SVC Process SEQ Number	Currency	Sequence_Number	19
10	DSCRIPTN	Description	String	STR30	30
11	REFRENCE	Reference	String	STR30	30
12	Reference2	Reference2	String	STR30	30
13	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_RTV_Line_HIST'].ITEMNMBR AS 'SVC_RTV_Line_HIST-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC35601 AS ['SVC_RTV_Line_HIST'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_RTV_Line_HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
14	ITEMDESC	Item Description	String	STR100	100
15	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
16	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
17	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
18	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
19	QTY_To_Receive	QTY To Receive	Currency	DLR17_QTY_RBS0_STR	17
20	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
21	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
22	UOFM	U Of M	String	U_Of_M	8
23	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SVC_RTV_Line_HIST'].VENDORID AS 'SVC_RTV_Line_HIST-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SVC35601 AS ['SVC_RTV_Line_HIST'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SVC_RTV_Line_HIST'].VENDORID = ['PM Vendor Master File'].VENDORID
24	VNDITNUM	Vendor Item Number	String	Item_Number	30
25	Return_Item_Number	Return Item Number	String	STR30_Item_Number	30
26	OFFID	Office ID	String	STR10_LBAU	10
27	LOCCODEB	Location Code Bad	String	STR10_Location_Code	10
28	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SVC_RTV_Line_HIST'].LOCNCODE AS 'SVC_RTV_Line_HIST-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC35601 AS ['SVC_RTV_Line_HIST'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SVC_RTV_Line_HIST'].LOCNCODE = ['Site Setup'].LOCNCODE
29	ADRSCODE	Address Code	String	STR15_Address_Code	15
30	Ship_Address_Name	Ship Address Name	String	STR64_Vendor_Name	64
31	Ship_Address_1	Ship Address 1	String	STR60	60
32	Ship_Address_2	Ship Address 2	String	STR60	60
33	Ship_Address_3	Ship Address 3	String	STR60	60
34	Ship_City	Ship City	String	STR35	35
35	Ship_State	Ship State	String	STR30_State	29
36	ZIPCODE	Zip Code	String	STR10	10
37	Ship_Country	Ship Country	String	STR60	60
38	ENTDTE	Entry Date	Date	DT_Date	6
39	ENTTME	Entry Time	Time	TM6	6
40	PRMDATE	Promised Date	Date	DATE_L	0
41	Promised_Time	Promised Time	Time	TM6	6
42	Shipped_Date	Shipped Date	Date	DT_Date	6
43	Shipped_Time	Shipped Time	Time	TM6	6
44	receiptdate	Receipt Date	Date	DT	8
45	Receipt_Time	Receipt Time	Time	TM6	6
46	COMPDTE	Complete Date	Date	DT_Date	6
47	COMPTME	Complete Time	Time	TM6	6
48	PONMBRSTR	Purchase_Order_Number_STR	String	STR17_LBAU	17
49	POLNSEQ	Purchase_Order_Line_Sequence_DOL	Currency	DLR17_RBS0_STR	17
50	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
51	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
52	Transfer_Reference	Transfer Reference	String	STR30	30
53	TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	LI_Sequence_Number	10
54	CALLNBR	Service Call Number	String	STR10_LBAU	10
55	EQPLINE	Equipment Line Item Sequence	Long Integer	LI_Sequence_Number	10
56	LINITMTYP	Line Item Type	String	STR3	3
57	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
58	Bill_of_Lading_Out	Bill of Lading Out	String	STR30	30
59	Shipping_Method_Out	Shipping Method Out	String	STR15_Shipping_Method	15
60	Bill_of_Lading	Bill of Lading	String	STR30	30
61	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SVC_RTV_Line_HIST'].SHIPMTHD AS 'SVC_RTV_Line_HIST-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC35601 AS ['SVC_RTV_Line_HIST'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SVC_RTV_Line_HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
62	Tracking_Number	Tracking Number	String	STR40	40
63	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SVC_RTV_Line_HIST'].NOTEINDX AS 'SVC_RTV_Line_HIST-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC35601 AS ['SVC_RTV_Line_HIST'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SVC_RTV_Line_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
64	VCHNUMWK	Voucher Number - WORK	String	STR17_LBAU	17
65	Voucher_Number_Invoice	Voucher Number Invoice	String	STR17_LBAU	17
66	Voucher_Number_Reimburse	Voucher Number Reimbursement	String	STR17_LBAU	17
67	CUSTOWN	Customer Owned	Boolean	CB	0
68	USERDEF1	User Defined 1	String	STR20	20
69	USERDEF2	User Defined 2	String	STR20	20
70	USRDEF03	User Defined 3	String	STR20	20
71	USRDEF04	User Defined 4	String	STR20	20
72	USRDEF05	User Defined 5	String	STR20	20
73	Part_Price	Part Price	Currency	DLR17_RBS0_STR$	17
74	Part_Cost	Part Cost	Currency	DLR17_RBS0_STR$	17
75	Labor_Price	Labor Price	Currency	DLR17_RBS0_STR$	17
76	Labor_Cost	Labor Cost	Currency	DLR17_RBS0_STR$	17
77	Expense_Price	Expense Price	Currency	DLR17_RBS0_STR$	17
78	Expense_Cost	Expense Cost	Currency	DLR17_RBS0_STR$	17
79	Travel_Price	Travel Price	Currency	DLR17_RBS0_STR$	17
80	Travel_Cost	Travel Cost	Currency	DLR17_RBS0_STR$	17
81	Originating_Part_Price	Originating Part Price	Currency	DLR17_RBS0_STR$	17
82	Originating_Part_Cost	Originating Part Cost	Currency	DLR17_RBS0_STR$	17
83	Originating_Labor_Price	Originating Labor Price	Currency	DLR17_RBS0_STR$	17
84	Originating_Labor_Cost	Originating Labor Cost	Currency	DLR17_RBS0_STR$	17
85	Originating_ExpensePrice	Originating Expense Price	Currency	DLR17_RBS0_STR$	17
86	Originating_Expense_Cost	Originating Expense Cost	Currency	DLR17_RBS0_STR$	17
87	Originating_Travel_Price	Originating Travel Price	Currency	DLR17_RBS0_STR$	17
88	Originating_Travel_Cost	Originating Travel Cost	Currency	DLR17_RBS0_STR$	17
89	QTYTYPE	QTY Type	Integer	DDL_QTY_Type	0

azurecurve Products FieldService (949)ProjectSVC_RTV_Line_HIST (SVC35601)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply