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 TypeLength
1PONUMBER SearchPO NumberSTR17_POP_NumberString17
2POSTATUS SearchPO StatusDDL_PO_StatusInteger0
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 GroupINT1Integer1
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_TypeInteger0
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_IDString15
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 WithSTR20String20
Name or Initials of the person in company with whom the order should be authorized or approved.
7DOCDATE SearchDocument DateDTDate8
8LSTEDTDT SearchLast Edit DateDT_DateDate6
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_LDate0
10PRMDATE SearchPromised DateDATE_LDate0
11PRMSHPDTE SearchPromised Ship DateDATE_LDate0
12REQDATE SearchRequired DateDATE_LDate0
13REQTNDT SearchRequisition DateDATE_LDate0
14SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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 NumberSTR25String25
16REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
17SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
18TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
19FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
20MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
21TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
22VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_NameString64
24MINORDER SearchMinimum OrderDLR17_$U2Currency17
25VADCDPAD SearchVendor Address Code - Purchase AddressSTR15_Address_CodeString15
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 IDINT5Integer4
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_LBAUString15
28PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
29CMPNYNAM SearchCompany NameSTR64_Company_NameString64
30CONTACT SearchContactSTR60String60
31ADDRESS1 SearchAddress 1STR60String60
32ADDRESS2 SearchAddress 2STR60String60
33ADDRESS3 SearchAddress 3STR60String60
34CITY SearchCitySTR35String35
35STATE SearchStateSTR30_StateString29
36ZIPCODE SearchZip CodeSTR10String10
37CCode SearchCountry CodeSTR6_VATString6
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 SearchCountrySTR60String60
39PHONE1 SearchPhone 1Phone_NumberString14
40PHONE2 SearchPhone 2Phone_NumberString14
41PHONE3 SearchPhone 3Phone_Number3String14
42FAX SearchFaxSTR14_FAXString14
43PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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$Currency11
45DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
46DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
47DISCDATE SearchDiscount DateDTDate8
48DUEDATE SearchDue DateDTDate8
49TRDPCTPR SearchTrade Discount Percent (Precise)Trade Discount Percent (Precise)Currency (Variable)23
50CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_U0Integer4
52CREATDDT SearchCreated DateDTDate8
53MODIFDT SearchModified DateDTDate8
54PONOTIDS SearchPO Note ID ArrayDLR14Currency14
55PONOTIDS_1 SearchPO Note ID Array[1]DLR14Currency14
56PONOTIDS_2 SearchPO Note ID Array[2]DLR14Currency14
57PONOTIDS_3 SearchPO Note ID Array[3]DLR14Currency14
58PONOTIDS_4 SearchPO Note ID Array[4]DLR14Currency14
59PONOTIDS_5 SearchPO Note ID Array[5]DLR14Currency14
60PONOTIDS_6 SearchPO Note ID Array[6]DLR14Currency14
61PONOTIDS_7 SearchPO Note ID Array[7]DLR14Currency14
62PONOTIDS_8 SearchPO Note ID Array[8]DLR14Currency14
63PONOTIDS_9 SearchPO Note ID Array[9]DLR14Currency14
64PONOTIDS_10 SearchPO Note ID Array[10]DLR14Currency14
65PONOTIDS_11 SearchPO Note ID Array[11]DLR14Currency14
66PONOTIDS_12 SearchPO Note ID Array[12]DLR14Currency14
67PONOTIDS_13 SearchPO Note ID Array[13]DLR14Currency14
68PONOTIDS_14 SearchPO Note ID Array[14]DLR14Currency14
69PONOTIDS_15 SearchPO Note ID Array[15]DLR14Currency14
70COMMNTID SearchComment IDSTR15_Comment_IDString15
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$Currency17
72CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 IndexINT3Integer3
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_IDString15
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_IDString15
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)14
77EXCHDATE SearchExchange DateDT_DateDate6
78TIME1 SearchTimeTM6Time6
79RATECALC SearchRate Calc MethodINTInteger0
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)14
81MCTRXSTT SearchMC Transaction StateINT1Integer1
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$Currency17
83ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
84Originating_Canceled_Sub SearchOriginating Canceled SubtotalDLR17_RBS0_STR$Currency17
85ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
86ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
87OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
88ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
89ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
90ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17
91BUYERID SearchBuyer IDSTR15_User_IDString15
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$Currency19
93ORORDAMT SearchOriginating On Order AmountDLR19_RBS0_UTR$Currency19
94HOLD SearchHoldCB_HoldBoolean0
95ONHOLDDATE SearchOn Hold DateDTDate8
96ONHOLDBY SearchOn Hold BySTR15_User_IDString15
97HOLDREMOVEDATE SearchHold Remove DateDTDate8
98HOLDREMOVEBY SearchHold Remove BySTR15_User_IDString15
99ALLOWSOCMTS SearchAllow SO CommitmentsCB_AllowSOCommitmentsBoolean0
100DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
101DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
102Revision_Number SearchRevision NumberINT4Integer4
103Change_Order_Flag SearchChange Order FlagINTInteger0
104PO_Field_Changes SearchPO Field ChangesML_POP_PO_Field_ChangesLong Integer0
105PO_Status_Orig SearchPO Status OrigDDL_PO_StatusInteger0
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_IDString15
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 SourceINT1Integer1
108TXENGCLD SearchTax Engine CalledYNBoolean0
109BSIVCTTL SearchBased On Invoice TotalYNBoolean0
110Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
111Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
112FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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_LBAUString15
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$Currency19
115ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
116MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
117ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
118BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
119OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
120BackoutFreightTaxAmt SearchBackout Freight Tax AmountDLR17_RBS0_UTR$Currency17
121OrigBackoutFreightTaxAmt SearchOriginating Backout Freight Tax AmountDLR17_RBS0_UTR$Currency17
122BackoutMiscTaxAmt SearchBackout Misc Tax AmountDLR17_RBS0_UTR$Currency17
123OrigBackoutMiscTaxAmt SearchOriginating Backout Misc Tax AmountDLR17_RBS0_UTR$Currency17
124Flags SearchFlagsINT1Integer1
125BackoutTradeDiscTax SearchBackout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
126OrigBackoutTradeDiscTax SearchOriginating Backout Trade Discount Tax AmountDLR17_RBS0_UTR$Currency17
127POPCONTNUM SearchPOP Contract NumberSTR20String20
128CONTENDDTE SearchContract End DateDATE_LDate0
129CNTRLBLKTBY SearchControl Blanket ByINTInteger0
130PURCHCMPNYNAM SearchPurchase Company NameSTR64_Company_NameString64
131PURCHCONTACT SearchPurchase ContactSTR60String60
132PURCHADDRESS1 SearchPurchase Address 1STR60String60
133PURCHADDRESS2 SearchPurchase Address 2STR60String60
134PURCHADDRESS3 SearchPurchase Address 3STR60String60
135PURCHCITY SearchPurchase CitySTR35String35
136PURCHSTATE SearchPurchase StateSTR30_StateString29
137PURCHZIPCODE SearchPurchase Zip CodeSTR10String10
138PURCHCCode SearchPurchase Country CodeSTR6_VATString6
139PURCHCOUNTRY SearchPurchase CountrySTR60String60
140PURCHPHONE1 SearchPurchase Phone 1Phone_NumberString14
141PURCHPHONE2 SearchPurchase Phone 2Phone_NumberString14
142PURCHPHONE3 SearchPurchase Phone 3Phone_Number3String14
143PURCHFAX SearchPurchase FaxSTR14_FAXString14
144BLNKTLINEEXTQTYSUM SearchTotal Blanket Line Ext QtyDLR17_QTY_RBS0_UTRCurrency17
145CBVAT SearchCash Based VATCB_CashBasedVATBoolean0
146Workflow_Approval_Status SearchWorkflow Approval StatusDDL_WorkflowApprovalStatusInteger0
147Workflow_Priority SearchWorkflow PriorityDDL_WorkflowPriorityInteger0
148Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
149Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
150PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency19
151OriginatingPrepaymentAmt SearchOriginating Prepayment AmountDLR19_RBS0_UTR$Currency19
152DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *