Purchase Order Work (POP10100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchase Order Work
Physical Name: POP10100
Technical Name: PA_POP_Report_PO

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMBER SearchPO NumberSTR17_POP_NumberString1817
2POSTATUS SearchPO StatusDDL_PO_StatusInteger20
Status assigned to the Purchase Order.

Click to show/hide PO Statuses

1	New
2	Released (i.e. emailed/printed)
3	Change Order
4	Received
5	Closed
6	Cancelled
3STATGRP SearchStatus GroupINT1Integer21
Assigned when the status of the purchase order changes and is used to group Purchase Orders by status types to enable ranging on active (New, Open or Modified) or closed (Canceled or Closed ) purchase orders.

Click to show/hide PO Statuses

1	Active
2	Closed
4POTYPE SearchPO TypeDDL_POP_PO_TypeInteger20
Type of Purchase Order.

Click to show/hide PO Types

1	Standard
2	Drop Ship
3	Blanket
4	Blanket Drop Ship
5USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Purchase Order Work'].USER2ENT AS 'Purchase Order Work-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchase Order Work'].USER2ENT = ['Users Master'].USERID
6CONFIRM1 SearchConfirm WithSTR20String2220
Name or Initials of the person in company with whom the order should be authorized or approved.
7DOCDATE SearchDocument DateDTDate48
8LSTEDTDT SearchLast Edit DateDT_DateDate46
Date the Purchase Order was last modified. This date is not updated when the PO is being printed, even if printing changes the status. It also is not updated when a PO with a New status is received against and the status is changed to Open.
9LSTPRTDT SearchLast Printed DateDATE_LDate40
10PRMDATE SearchPromised DateDATE_LDate40
11PRMSHPDTE SearchPromised Ship DateDATE_LDate40
12REQDATE SearchRequired DateDATE_LDate40
13REQTNDT SearchRequisition DateDATE_LDate40
14SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Purchase Order Work'].SHIPMTHD AS 'Purchase Order Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Purchase Order Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
15TXRGNNUM SearchTax Registration NumberSTR25String2625
16REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
17SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
18TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
19FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
20MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
21TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
22VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Purchase Order Work'].VENDORID AS 'Purchase Order Work-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Purchase Order Work'].VENDORID = ['PM Vendor Master File'].VENDORID
23VENDNAME SearchVendor NameSTR64_Vendor_NameString6664
24MINORDER SearchMinimum OrderDLR17_$U2Currency1017
25VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString1615
Partial key to the PM Address MSTR (PM00300).

Click to show/hide

SELECT
       ['Purchase Order Work'].VADCDPAD AS 'Purchase Order Work-Vendor Address Code - Purchase Address'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['Purchase Order Work'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
              AND
                     ['Purchase Order Work'].VENDORID = ['PM Address MSTR'].VENDORID
26CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Purchase Order Work'].CMPANYID AS 'Purchase Order Work-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Purchase Order Work'].CMPANYID = ['Company Master'].CMPANYID
27PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
28PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
29CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
30CONTACT SearchContactSTR60String6260
31ADDRESS1 SearchAddress 1STR60String6260
32ADDRESS2 SearchAddress 2STR60String6260
33ADDRESS3 SearchAddress 3STR60String6260
34CITY SearchCitySTR35String3635
35STATE SearchStateSTR30_StateString3029
36ZIPCODE SearchZip CodeSTR10String1210
37CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Purchase Order Work'].CCode AS 'Purchase Order Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Purchase Order Work'].CCode = ['VAT Country Code MSTR'].CCode
38COUNTRY SearchCountrySTR60String6260
39PHONE1 SearchPhone 1Phone_NumberString2214
40PHONE2 SearchPhone 2Phone_NumberString2214
41PHONE3 SearchPhone 3Phone_Number3String2214
42FAX SearchFaxSTR14_FAXString2214
43PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Purchase Order Work'].PYMTRMID AS 'Purchase Order Work-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Purchase Order Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
44DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
45DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
47DISCDATE SearchDiscount DateDTDate48
48DUEDATE SearchDue DateDTDate48
49TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)1223
50CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Purchase Order Work'].CUSTNMBR AS 'Purchase Order Work-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Purchase Order Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
51TIMESPRT SearchTimes PrintedINT4_U0Integer24
52CREATDDT SearchCreated DateDTDate48
53MODIFDT SearchModified DateDTDate48
54PONOTIDS SearchPO Note ID ArrayDLR14Currency1014
55PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency1014
56PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency1014
57PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency1014
58PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency1014
59PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency1014
60PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency1014
61PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency1014
62PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency1014
63PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency1014
64PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency1014
65PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency1014
66PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency1014
67PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency1014
68PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency1014
69PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency1014
70COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Purchase Order Work'].COMMNTID AS 'Purchase Order Work-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Purchase Order Work'].COMMNTID = ['Comment Master'].COMMNTID
71CANCSUB SearchCanceled SubtotalDLR17_RBS0_STR$Currency1017
72CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchase Order Work'].CURNCYID AS 'Purchase Order Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchase Order Work'].CURNCYID = ['Currency Setup'].CURNCYID
73CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Purchase Order Work'].CURRNIDX AS 'Purchase Order Work-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Purchase Order Work'].CURRNIDX = ['Currency Setup'].CURRNIDX
74RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Purchase Order Work'].RATETPID AS 'Purchase Order Work-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Purchase Order Work'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
75EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Purchase Order Work'].EXGTBLID AS 'Purchase Order Work-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Purchase Order Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
76XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
77EXCHDATE SearchExchange DateDT_DateDate46
78TIME1 SearchTimeTM6Time46
79RATECALC SearchRate Calc MethodINTInteger20
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
80DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
81MCTRXSTT SearchMC Transaction StateINT1Integer21
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.
82OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency1017
83ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
84Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency1017
85ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
86ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
87OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
88ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
89ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
90ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency1017
91BUYERID SearchBuyer IDSTR15_User_IDString1615
Key to the Buyer Master (POP00101).

Click to show/hide

SELECT
       ['Purchase Order Work'].BUYERID AS 'Purchase Order Work-Buyer ID'
       ,['Buyer Master'].BUYERID AS 'Buyer Master-Buyer ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       POP00101 AS ['Buyer Master']
              ON
                     ['Purchase Order Work'].BUYERID = ['Buyer Master'].BUYERID
92ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
93ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency1019
94HOLD SearchHoldCB_HoldBoolean20
95ONHOLDDATE SearchOn Hold DateDTDate48
96ONHOLDBY SearchOn Hold BySTR15_User_IDString1615
97HOLDREMOVEDATE SearchHold Remove DateDTDate48
98HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString1615
99ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean20
100DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
101DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
102Revision_Number SearchRevision NumberINT4Integer24
103Change_Order_Flag SearchChange Order FlagINTInteger20
104PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer40
105PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger20
Status assigned to the Purchase Order.

Click to show/hide PO Statuses

1	New
2	Released (i.e. emailed/printed)
3	Change Order
4	Received
5	Closed
6	Cancelled
106TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchase Order Work'].TAXSCHID AS 'Purchase Order Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchase Order Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
107TXSCHSRC SearchTax Schedule SourceINT1Integer21
108TXENGCLD SearchTax Engine CalledYNBoolean20
109BSIVCTTL SearchBased On Invoice TotalYNBoolean20
110Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
111Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
112FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchase Order Work'].FRTSCHID AS 'Purchase Order Work-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchase Order Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
113MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Purchase Order Work'].MSCSCHID AS 'Purchase Order Work-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       POP10100 AS ['Purchase Order Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Purchase Order Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
114FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency1019
115ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
116MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
117ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
118BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
119OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
120BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
121OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency1017
122BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
123OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency1017
124Flags SearchFlagsINT1Integer21
125BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
126OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency1017
127POPCONTNUM SearchPOP Contract NumberSTR20String2220
128CONTENDDTE SearchContract End DateDATE_LDate40
129CNTRLBLKTBY SearchControl Blanket ByINTInteger20
130PURCHCMPNYNAM SearchPurchase Company NameSTR64_Company_NameString6664
131PURCHCONTACT SearchPurchase ContactSTR60String6260
132PURCHADDRESS1 SearchPurchase Address 1STR60String6260
133PURCHADDRESS2 SearchPurchase Address 2STR60String6260
134PURCHADDRESS3 SearchPurchase Address 3STR60String6260
135PURCHCITY SearchPurchase CitySTR35String3635
136PURCHSTATE SearchPurchase StateSTR30_StateString3029
137PURCHZIPCODE SearchPurchase Zip CodeSTR10String1210
138PURCHCCode SearchPurchase Country CodeSTR6_VATString86
139PURCHCOUNTRY SearchPurchase CountrySTR60String6260
140PURCHPHONE1 SearchPurchase Phone 1Phone_NumberString2214
141PURCHPHONE2 SearchPurchase Phone 2Phone_NumberString2214
142PURCHPHONE3 SearchPurchase Phone 3Phone_Number3String2214
143PURCHFAX SearchPurchase FaxSTR14_FAXString2214
144BLNKTLINEEXTQTYSUM SearchTotal Blanket Line Ext QtyDLR17_QTY_RBS0_UTRCurrency1017
145CBVAT SearchCash Based VATCB_CashBasedVATBoolean20
146Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger20
147Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger20
148Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
149Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
150PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency1019
151OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency1019
152DEX_ROW_TS Searchdatetimedatetime33
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.
153DEX_ROW_ID Searchintint1010

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.

Leave a Reply

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