Purchase Order History (POP30100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchase Order History
Physical Name: POP30100
Technical Name: PA_POP_Report_POHist

Group Display Name: Purchasing History
Group Technical Name: Purchasing History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PONUMBER	PO Number	STR17_POP_Number	String	18	17
2	POSTATUS	PO Status	DDL_PO_Status	Integer	2	0
3	STATGRP	Status Group	INT1	Integer	2	1
4	POTYPE	PO Type	DDL_POP_PO_Type	Integer	2	0
	Type of Purchase Order. Click to show/hide PO Types 1 Standard 2 Drop Ship 3 Blanket 4 Blanket Drop Ship
5	USER2ENT	User To Enter	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchase Order History'].USER2ENT AS 'Purchase Order History-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchase Order History'].USER2ENT = ['Users Master'].USERID
6	CONFIRM1	Confirm With	STR20	String	22	20
7	DOCDATE	Document Date	DT	Date	4	8
8	LSTEDTDT	Last Edit Date	DT_Date	Date	4	6
9	LSTPRTDT	Last Printed Date	DATE_L	Date	4	0
10	PRMDATE	Promised Date	DATE_L	Date	4	0
11	PRMSHPDTE	Promised Ship Date	DATE_L	Date	4	0
12	REQDATE	Required Date	DATE_L	Date	4	0
13	REQTNDT	Requisition Date	DATE_L	Date	4	0
14	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	16	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchase Order History'].SHIPMTHD AS 'Purchase Order History-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP30100 AS ['Purchase Order History'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchase Order History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
15	TXRGNNUM	Tax Registration Number	STR25	String	26	25
16	REMSUBTO	Remaining Subtotal	DLR17_RBS0_UTR$	Currency	10	17
17	SUBTOTAL	Subtotal	DLR17_RBS0_STR$	Currency	10	17
18	TRDISAMT	Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
19	TRDPCTPR	Trade Discount Percent (Precise)	Trade Discount Percent (Precise)	Currency (Variable)	12	23
20	FRTAMNT	Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
21	MSCCHAMT	Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
22	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
23	VENDORID	Vendor ID	STR_15_Vendor_ID	String	16	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchase Order History'].VENDORID AS 'Purchase Order History-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchase Order History'].VENDORID = ['PM Vendor Master File'].VENDORID
24	VENDNAME	Vendor Name	STR64_Vendor_Name	String	66	64
25	MINORDER	Minimum Order	DLR17_$U2	Currency	10	17
26	VADCDPAD	Vendor Address Code - Purchase Address	STR15_Address_Code	String	16	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['Purchase Order History'].VADCDPAD AS 'Purchase Order History-Vendor Address Code - Purchase Address' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM POP30100 AS ['Purchase Order History'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['Purchase Order History'].VADCDPAD = ['PM Address MSTR'].ADRSCODE AND ['Purchase Order History'].VENDORID = ['PM Address MSTR'].VENDORID
27	CMPANYID	Company ID	INT5	Integer	2	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['Purchase Order History'].CMPANYID AS 'Purchase Order History-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['Purchase Order History'].CMPANYID = ['Company Master'].CMPANYID
28	PRBTADCD	Primary Billto Address Code	STR15_LBAU	String	16	15
29	PRSTADCD	Primary Shipto Address Code	STR15_LBAU	String	16	15
30	CMPNYNAM	Company Name	STR64_Company_Name	String	66	64
31	CONTACT	Contact	STR60	String	62	60
32	ADDRESS1	Address 1	STR60	String	62	60
33	ADDRESS2	Address 2	STR60	String	62	60
34	ADDRESS3	Address 3	STR60	String	62	60
35	CITY	City	STR35	String	36	35
36	STATE	State	STR30_State	String	30	29
37	ZIPCODE	Zip Code	STR10	String	12	10
38	CCode	Country Code	STR6_VAT	String	8	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Purchase Order History'].CCode AS 'Purchase Order History-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM POP30100 AS ['Purchase Order History'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Purchase Order History'].CCode = ['VAT Country Code MSTR'].CCode
39	COUNTRY	Country	STR60	String	62	60
40	PHONE1	Phone 1	Phone_Number	String	22	14
41	PHONE2	Phone 2	Phone_Number	String	22	14
42	PHONE3	Phone 3	Phone_Number3	String	22	14
43	FAX	Fax	STR14_FAX	String	22	14
44	PYMTRMID	Payment Terms ID	STR20_Payment_Terms_ID	String	22	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['Purchase Order History'].PYMTRMID AS 'Purchase Order History-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['Purchase Order History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
45	DSCDLRAM	Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
46	DSCPCTAM	Discount Percent Amount	INT5_%2	Integer	2	5
47	DISAMTAV	Discount Amount Available	DLR17_RBS0_UTR$	Currency	10	17
48	DISCDATE	Discount Date	DT	Date	4	8
49	DUEDATE	Due Date	DT	Date	4	8
50	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	16	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Purchase Order History'].CUSTNMBR AS 'Purchase Order History-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM POP30100 AS ['Purchase Order History'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Purchase Order History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
51	TIMESPRT	Times Printed	INT4_U0	Integer	2	4
52	CREATDDT	Created Date	DT	Date	4	8
53	MODIFDT	Modified Date	DT	Date	4	8
54	PONOTIDS	PO Note ID Array	DLR14	Currency	10	14
55	PONOTIDS_1	PO Note ID Array[1]	DLR14	Currency	10	14
56	PONOTIDS_2	PO Note ID Array[2]	DLR14	Currency	10	14
57	PONOTIDS_3	PO Note ID Array[3]	DLR14	Currency	10	14
58	PONOTIDS_4	PO Note ID Array[4]	DLR14	Currency	10	14
59	PONOTIDS_5	PO Note ID Array[5]	DLR14	Currency	10	14
60	PONOTIDS_6	PO Note ID Array[6]	DLR14	Currency	10	14
61	PONOTIDS_7	PO Note ID Array[7]	DLR14	Currency	10	14
62	PONOTIDS_8	PO Note ID Array[8]	DLR14	Currency	10	14
63	PONOTIDS_9	PO Note ID Array[9]	DLR14	Currency	10	14
64	PONOTIDS_10	PO Note ID Array[10]	DLR14	Currency	10	14
65	PONOTIDS_11	PO Note ID Array[11]	DLR14	Currency	10	14
66	PONOTIDS_12	PO Note ID Array[12]	DLR14	Currency	10	14
67	PONOTIDS_13	PO Note ID Array[13]	DLR14	Currency	10	14
68	PONOTIDS_14	PO Note ID Array[14]	DLR14	Currency	10	14
69	PONOTIDS_15	PO Note ID Array[15]	DLR14	Currency	10	14
70	TRXSORCE	TRX Source	STR13	String	14	13
71	COMMNTID	Comment ID	STR15_Comment_ID	String	16	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Purchase Order History'].COMMNTID AS 'Purchase Order History-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Purchase Order History'].COMMNTID = ['Comment Master'].COMMNTID
72	CANCSUB	Canceled Subtotal	DLR17_RBS0_STR$	Currency	10	17
73	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchase Order History'].CURNCYID AS 'Purchase Order History-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchase Order History'].CURNCYID = ['Currency Setup'].CURNCYID
74	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchase Order History'].CURRNIDX AS 'Purchase Order History-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP30100 AS ['Purchase Order History'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchase Order History'].CURRNIDX = ['Currency Setup'].CURRNIDX
75	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Purchase Order History'].RATETPID AS 'Purchase Order History-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Purchase Order History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
76	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Purchase Order History'].EXGTBLID AS 'Purchase Order History-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Purchase Order History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
77	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
78	EXCHDATE	Exchange Date	DT_Date	Date	4	6
79	TIME1	Time	TM6	Time	4	6
80	RATECALC	Rate Calc Method	INT	Integer	2	0
	Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank. Click to show/hide Rate Calc Methods 0 Multiply 1 Divide
81	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
82	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
	MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank. Click to show/hide MC Transaction States 0 Euro currency is not created or no denomination currencies are enabled. 1 Originating is not a denomination; Functional is not a denomination 2 Originating is not a denomination; Functional is the Euro currency. 3 Originating is not a denomination; Functional is a denomination. 4 Originating is a denomination; Functional is not a denomination. 5 Originating is a denomination; Functional is a denomination. 6 Originating is a denomination; Functional is the Euro currency. 7 Originating is the Euro currency; Functional is a denomination. 8 Originating is the Euro currency; Functional is not a denomination.
83	OREMSUBT	Originating Remaining Subtotal	DLR17_RBS0_UTR$	Currency	10	17
84	ORSUBTOT	Originating Subtotal	DLR17_RBS0_STR$	Currency	10	17
85	Originating_Canceled_Sub	Originating Canceled Subtotal	DLR17_RBS0_STR$	Currency	10	17
86	ORTDISAM	Originating Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
87	ORFRTAMT	Originating Freight Amount	DLR17_RBS0_UTR$	Currency	10	17
88	OMISCAMT	Originating Misc Charges Amount	DLR17_RBS0_UTR$	Currency	10	17
89	ORTAXAMT	Originating Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
90	ORDDLRAT	Originating Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
91	ODISAMTAV	Originating Discount Amount Available	DLR17_RBS0_UTR$	Currency	10	17
92	BUYERID	Buyer ID	STR15_User_ID	String	16	15
	Key to the Buyer Master (POP00101). Click to show/hide SELECT ['Purchase Order History'].BUYERID AS 'Purchase Order History-Buyer ID' ,['Buyer Master'].BUYERID AS 'Buyer Master-Buyer ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN POP00101 AS ['Buyer Master'] ON ['Purchase Order History'].BUYERID = ['Buyer Master'].BUYERID
93	ALLOWSOCMTS	Allow SO Commitments	CB_AllowSOCommitments	Boolean	2	0
94	DISGRPER	Discount Grace Period	INT2_U0	Integer	2	2
95	DUEGRPER	Due Date Grace Period	INT2_U0	Integer	2	2
96	Revision_Number	Revision Number	INT4	Integer	2	4
97	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchase Order History'].TAXSCHID AS 'Purchase Order History-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
98	TXSCHSRC	Tax Schedule Source	INT1	Integer	2	1
99	BSIVCTTL	Based On Invoice Total	YN	Boolean	2	0
100	Purchase_Freight_Taxable	Purchase Freight Taxable	DDL_Purchase_Tax_Options	Integer	2	0
101	Purchase_Misc_Taxable	Purchase Misc Taxable	DDL_Purchase_Tax_Options	Integer	2	0
102	FRTSCHID	Freight Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchase Order History'].FRTSCHID AS 'Purchase Order History-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order History'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
103	MSCSCHID	Misc Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchase Order History'].MSCSCHID AS 'Purchase Order History-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP30100 AS ['Purchase Order History'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchase Order History'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
104	FRTTXAMT	Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
105	ORFRTTAX	Originating Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
106	MSCTXAMT	Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
107	ORMSCTAX	Originating Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
108	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
109	OBTAXAMT	Originating Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
110	BackoutFreightTaxAmt	Backout Freight Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
111	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
112	BackoutMiscTaxAmt	Backout Misc Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
113	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
114	Flags	Flags	INT1	Integer	2	1
115	POPCONTNUM	POP Contract Number	STR20	String	22	20
116	CONTENDDTE	Contract End Date	DATE_L	Date	4	0
117	CNTRLBLKTBY	Control Blanket By	INT	Integer	2	0
118	PURCHCMPNYNAM	Purchase Company Name	STR64_Company_Name	String	66	64
119	PURCHCONTACT	Purchase Contact	STR60	String	62	60
120	PURCHADDRESS1	Purchase Address 1	STR60	String	62	60
121	PURCHADDRESS2	Purchase Address 2	STR60	String	62	60
122	PURCHADDRESS3	Purchase Address 3	STR60	String	62	60
123	PURCHCITY	Purchase City	STR35	String	36	35
124	PURCHSTATE	Purchase State	STR30_State	String	30	29
125	PURCHZIPCODE	Purchase Zip Code	STR10	String	12	10
126	PURCHCCode	Purchase Country Code	STR6_VAT	String	8	6
127	PURCHCOUNTRY	Purchase Country	STR60	String	62	60
128	PURCHPHONE1	Purchase Phone 1	Phone_Number	String	22	14
129	PURCHPHONE2	Purchase Phone 2	Phone_Number	String	22	14
130	PURCHPHONE3	Purchase Phone 3	Phone_Number3	String	22	14
131	PURCHFAX	Purchase Fax	STR14_FAX	String	22	14
132	BLNKTLINEEXTQTYSUM	Total Blanket Line Ext Qty	DLR17_QTY_RBS0_UTR	Currency	10	17
133	Workflow_Approval_Status	Workflow Approval Status	DDL_WorkflowApprovalStatus	Integer	2	0
134	Workflow_Priority	Workflow Priority	DDL_WorkflowPriority	Integer	2	0
135	Workflow_Status	Workflow Status	Workflow Status	Integer	2	0
136	Print_Phone_NumberGB	Print Phone Number GB	GB	Integer	2	0
137	PrepaymentAmount	Prepayment Amount	DLR19_RBS0_UTR$	Currency	10	19
138	OriginatingPrepaymentAmt	Originating Prepayment Amount	DLR19_RBS0_UTR$	Currency	10	19
139	DEX_ROW_TS		datetime	datetime	3	3
	DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
140	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase Order History (POP30100)

Leave a Reply Cancel reply