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: POP_POHist

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PONUMBER SearchPO NumberStringSTR17_POP_Number17
2POSTATUS SearchPO StatusIntegerDDL_PO_Status0
3STATGRP SearchStatus GroupIntegerINT11
4POTYPE SearchPO TypeIntegerDDL_POP_PO_Type0
Type of Purchase Order.

Click to show/hide PO Types

1	Standard
2	Drop Ship
3	Blanket
4	Blanket Drop Ship
5USER2ENT SearchUser To EnterStringSTR15_User_ID15
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
6CONFIRM1 SearchConfirm WithStringSTR2020
7DOCDATE SearchDocument DateDateDT8
8LSTEDTDT SearchLast Edit DateDateDT_Date6
9LSTPRTDT SearchLast Printed DateDateDATE_L0
10PRMDATE SearchPromised DateDateDATE_L0
11PRMSHPDTE SearchPromised Ship DateDateDATE_L0
12REQDATE SearchRequired DateDateDATE_L0
13REQTNDT SearchRequisition DateDateDATE_L0
14SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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
15TXRGNNUM SearchTax Registration NumberStringSTR2525
16REMSUBTO SearchRemaining SubtotalCurrencyDLR17_RBS0_UTR$17
17SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
18TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
19TRDPCTPR SearchTrade Discount Percent (Precise)Currency (Variable)Trade Discount Percent (Precise)23
20FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
21MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
22TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
23VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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
24VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
25MINORDER SearchMinimum OrderCurrencyDLR17_$U217
26VADCDPAD SearchVendor Address Code - Purchase AddressStringSTR15_Address_Code15
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
27CMPANYID SearchCompany IDIntegerINT54
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
28PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
29PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
30CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
31CONTACT SearchContactStringSTR6060
32ADDRESS1 SearchAddress 1StringSTR6060
33ADDRESS2 SearchAddress 2StringSTR6060
34ADDRESS3 SearchAddress 3StringSTR6060
35CITY SearchCityStringSTR3535
36STATE SearchStateStringSTR30_State29
37ZIPCODE SearchZip CodeStringSTR1010
38CCode SearchCountry CodeStringSTR6_VAT6
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
39COUNTRY SearchCountryStringSTR6060
40PHONE1 SearchPhone 1StringPhone_Number14
41PHONE2 SearchPhone 2StringPhone_Number14
42PHONE3 SearchPhone 3StringPhone_Number314
43FAX SearchFaxStringSTR14_FAX14
44PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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
45DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
46DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
47DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
48DISCDATE SearchDiscount DateDateDT8
49DUEDATE SearchDue DateDateDT8
50CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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
51TIMESPRT SearchTimes PrintedIntegerINT4_U04
52CREATDDT SearchCreated DateDateDT8
53MODIFDT SearchModified DateDateDT8
54PONOTIDS SearchPO Note ID ArrayDLR14Currency14
55PONOTIDS_1 SearchPO Note ID Array[1]CurrencyDLR1414
56PONOTIDS_2 SearchPO Note ID Array[2]CurrencyDLR1414
57PONOTIDS_3 SearchPO Note ID Array[3]CurrencyDLR1414
58PONOTIDS_4 SearchPO Note ID Array[4]CurrencyDLR1414
59PONOTIDS_5 SearchPO Note ID Array[5]CurrencyDLR1414
60PONOTIDS_6 SearchPO Note ID Array[6]CurrencyDLR1414
61PONOTIDS_7 SearchPO Note ID Array[7]CurrencyDLR1414
62PONOTIDS_8 SearchPO Note ID Array[8]CurrencyDLR1414
63PONOTIDS_9 SearchPO Note ID Array[9]CurrencyDLR1414
64PONOTIDS_10 SearchPO Note ID Array[10]CurrencyDLR1414
65PONOTIDS_11 SearchPO Note ID Array[11]CurrencyDLR1414
66PONOTIDS_12 SearchPO Note ID Array[12]CurrencyDLR1414
67PONOTIDS_13 SearchPO Note ID Array[13]CurrencyDLR1414
68PONOTIDS_14 SearchPO Note ID Array[14]CurrencyDLR1414
69PONOTIDS_15 SearchPO Note ID Array[15]CurrencyDLR1414
70TRXSORCE SearchTRX SourceStringSTR1313
71COMMNTID SearchComment IDStringSTR15_Comment_ID15
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
72CANCSUB SearchCanceled SubtotalCurrencyDLR17_RBS0_STR$17
73CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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
74CURRNIDX SearchCurrency IndexIntegerINT33
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
75RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
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
76EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
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
77XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
78EXCHDATE SearchExchange DateDateDT_Date6
79TIME1 SearchTimeTimeTM66
80RATECALC SearchRate Calc MethodIntegerINT0
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
81DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
82MCTRXSTT SearchMC Transaction StateIntegerINT11
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.
83OREMSUBT SearchOriginating Remaining SubtotalCurrencyDLR17_RBS0_UTR$17
84ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
85Originating_Canceled_Sub SearchOriginating Canceled SubtotalCurrencyDLR17_RBS0_STR$17
86ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
87ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
88OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
89ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
90ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
91ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
92BUYERID SearchBuyer IDStringSTR15_User_ID15
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
93ALLOWSOCMTS SearchAllow SO CommitmentsBooleanCB_AllowSOCommitments0
94DISGRPER SearchDiscount Grace PeriodIntegerINT2_U02
95DUEGRPER SearchDue Date Grace PeriodIntegerINT2_U02
96Revision_Number SearchRevision NumberIntegerINT44
97TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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
98TXSCHSRC SearchTax Schedule SourceIntegerINT11
99BSIVCTTL SearchBased On Invoice TotalBooleanYN0
100Purchase_Freight_Taxable SearchPurchase Freight TaxableIntegerDDL_Purchase_Tax_Options0
101Purchase_Misc_Taxable SearchPurchase Misc TaxableIntegerDDL_Purchase_Tax_Options0
102FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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
103MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
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
104FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
105ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
106MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
107ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
108BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
109OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
110BackoutFreightTaxAmt SearchBackout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
111OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountCurrencyDLR17_RBS0_UTR$17
112BackoutMiscTaxAmt SearchBackout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
113OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountCurrencyDLR17_RBS0_UTR$17
114Flags SearchFlagsIntegerINT11
115POPCONTNUM SearchPOP Contract NumberStringSTR2020
116CONTENDDTE SearchContract End DateDateDATE_L0
117CNTRLBLKTBY SearchControl Blanket ByIntegerINT0
118PURCHCMPNYNAM SearchPurchase Company NameStringSTR64_Company_Name64
119PURCHCONTACT SearchPurchase ContactStringSTR6060
120PURCHADDRESS1 SearchPurchase Address 1StringSTR6060
121PURCHADDRESS2 SearchPurchase Address 2StringSTR6060
122PURCHADDRESS3 SearchPurchase Address 3StringSTR6060
123PURCHCITY SearchPurchase CityStringSTR3535
124PURCHSTATE SearchPurchase StateStringSTR30_State29
125PURCHZIPCODE SearchPurchase Zip CodeStringSTR1010
126PURCHCCode SearchPurchase Country CodeStringSTR6_VAT6
127PURCHCOUNTRY SearchPurchase CountryStringSTR6060
128PURCHPHONE1 SearchPurchase Phone 1StringPhone_Number14
129PURCHPHONE2 SearchPurchase Phone 2StringPhone_Number14
130PURCHPHONE3 SearchPurchase Phone 3StringPhone_Number314
131PURCHFAX SearchPurchase FaxStringSTR14_FAX14
132BLNKTLINEEXTQTYSUM SearchTotal Blanket Line Ext QtyCurrencyDLR17_QTY_RBS0_UTR17
133Workflow_Approval_Status SearchWorkflow Approval StatusIntegerDDL_WorkflowApprovalStatus0
134Workflow_Priority SearchWorkflow PriorityIntegerDDL_WorkflowPriority0
135Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
136Print_Phone_NumberGB SearchPrint Phone Number GBIntegerGB0
137PrepaymentAmount SearchPrepayment AmountCurrencyDLR19_RBS0_UTR$19
138OriginatingPrepaymentAmt SearchOriginating Prepayment AmountCurrencyDLR19_RBS0_UTR$19

Leave a Reply

Your email address will not be published. Required fields are marked *