POP PA Receipt Line Hist View (POP31310)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPOP PA Receipt Line Hist View (POP31310)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: POP PA Receipt Line Hist View
Physical Name: POP31310
Technical Name: POP_PA_ReceiptLineHist_View

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
2	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
3	ProjNum	Project Number	String	STR15_LBAU	15
4	ProjectName	Proj. Name	String	STR30	30
5	CostCatID	Cost Category ID	String	STR15_LBAU	15
6	CostCategoryName	Cost Category Name	String	STR30	30
7	CONTNBR	Contract Number	String	STR11	11
8	ContractName	Contract Name	String	STR30	30
9	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['POP PA Receipt Line Hist View'].CUSTNMBR AS 'POP PA Receipt Line Hist View-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM POP31310 AS ['POP PA Receipt Line Hist View'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['POP PA Receipt Line Hist View'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
10	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['POP PA Receipt Line Hist View'].CURRNIDX AS 'POP PA Receipt Line Hist View-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP31310 AS ['POP PA Receipt Line Hist View'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['POP PA Receipt Line Hist View'].CURRNIDX = ['Currency Setup'].CURRNIDX
11	AccruedRevenues	Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
12	OrigAccruedRevenues	Originating Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
13	MCAccruedRevenues	MC Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
14	VarianceAccruedRevenue	Variance Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
15	OrigVarAccruedRevenues	Originating Variance Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
16	MCVarianceAccruedRev	MC Variance Accrued Revenues	Currency	DLR17_RBS0_UTR$	17
17	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
18	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
19	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
20	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
21	Array_of_Strings_1	Array of Strings[1]	String	STR30	30
22	Array_of_Strings_2	Array of Strings[2]	String	STR30	30
23	Array_of_Strings_3	Array of Strings[3]	String	STR30	30
24	Array_of_Strings_4	Array of Strings[4]	String	STR30	30
25	Array_of_Strings_5	Array of Strings[5]	String	STR30	30
26	Array_of_Strings_6	Array of Strings[6]	String	STR30	30
27	Array_of_Strings_7	Array of Strings[7]	String	STR30	30
28	Array_of_Strings_8	Array of Strings[8]	String	STR30	30
29	Array_of_Strings_9	Array of Strings[9]	String	STR30	30
30	Array_of_Strings_10	Array of Strings[10]	String	STR30	30
31	Array_of_Strings_11	Array of Strings[11]	String	STR30	30
32	Array_of_Strings_12	Array of Strings[12]	String	STR30	30
33	Array_of_Strings_13	Array of Strings[13]	String	STR30	30
34	Array_of_Strings_14	Array of Strings[14]	String	STR30	30
35	Array_of_Strings_15	Array of Strings[15]	String	STR30	30
36	Array_of_Strings_16	Array of Strings[16]	String	STR30	30
37	Array_of_Strings_17	Array of Strings[17]	String	STR30	30
38	Array_of_Strings_18	Array of Strings[18]	String	STR30	30
39	Array_of_Strings_19	Array of Strings[19]	String	STR30	30
40	Array_of_Strings_20	Array of Strings[20]	String	STR30	30
41	Array_of_Dollars_1	Array of Dollars[1]	Currency	DLR19_RBS0_UTR$	19
42	Array_of_Dollars_2	Array of Dollars[2]	Currency	DLR19_RBS0_UTR$	19
43	Array_of_Dollars_3	Array of Dollars[3]	Currency	DLR19_RBS0_UTR$	19
44	Array_of_Dollars_4	Array of Dollars[4]	Currency	DLR19_RBS0_UTR$	19
45	Array_of_Dollars_5	Array of Dollars[5]	Currency	DLR19_RBS0_UTR$	19
46	Array_of_Dollars_6	Array of Dollars[6]	Currency	DLR19_RBS0_UTR$	19
47	Array_of_Dollars_7	Array of Dollars[7]	Currency	DLR19_RBS0_UTR$	19
48	Array_of_Dollars_8	Array of Dollars[8]	Currency	DLR19_RBS0_UTR$	19
49	Array_of_Dollars_9	Array of Dollars[9]	Currency	DLR19_RBS0_UTR$	19
50	Array_of_Dollars_10	Array of Dollars[10]	Currency	DLR19_RBS0_UTR$	19
51	Array_of_Dollars_11	Array of Dollars[11]	Currency	DLR19_RBS0_UTR$	19
52	Array_of_Dollars_12	Array of Dollars[12]	Currency	DLR19_RBS0_UTR$	19
53	Array_of_Dollars_13	Array of Dollars[13]	Currency	DLR19_RBS0_UTR$	19
54	Array_of_Dollars_14	Array of Dollars[14]	Currency	DLR19_RBS0_UTR$	19
55	Array_of_Dollars_15	Array of Dollars[15]	Currency	DLR19_RBS0_UTR$	19
56	Array_of_Dollars_16	Array of Dollars[16]	Currency	DLR19_RBS0_UTR$	19
57	Array_of_Dollars_17	Array of Dollars[17]	Currency	DLR19_RBS0_UTR$	19
58	Array_of_Dollars_18	Array of Dollars[18]	Currency	DLR19_RBS0_UTR$	19
59	Array_of_Dollars_19	Array of Dollars[19]	Currency	DLR19_RBS0_UTR$	19
60	Array_of_Dollars_20	Array of Dollars[20]	Currency	DLR19_RBS0_UTR$	19
61	BillingNote	Billing Note	Text	TX500	500
62	Array_of_Texts_1	Array of Texts[1]	Text	TX500	500
63	Array_of_Texts_2	Array of Texts[2]	Text	TX500	500
64	Array_of_Texts_3	Array of Texts[3]	Text	TX500	500
65	Array_of_Texts_4	Array of Texts[4]	Text	TX500	500
66	Array_of_Texts_5	Array of Texts[5]	Text	TX500	500

azurecurve Products Microsoft Dynamics GP (0)PurchasingPOP PA Receipt Line Hist View (POP31310)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply