Purchase Order Work (POP10100)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase 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: POP_PO

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	POSTATUS	PO Status	Integer	DDL_PO_Status	0
	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
3	STATGRP	Status Group	Integer	INT1	1
	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
4	POTYPE	PO Type	Integer	DDL_POP_PO_Type	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	String	STR15_User_ID	15
	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
6	CONFIRM1	Confirm With	String	STR20	20
	Name or Initials of the person in company with whom the order should be authorized or approved.
7	DOCDATE	Document Date	Date	DT	8
8	LSTEDTDT	Last Edit Date	Date	DT_Date	6
	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.
9	LSTPRTDT	Last Printed Date	Date	DATE_L	0
10	PRMDATE	Promised Date	Date	DATE_L	0
11	PRMSHPDTE	Promised Ship Date	Date	DATE_L	0
12	REQDATE	Required Date	Date	DATE_L	0
13	REQTNDT	Requisition Date	Date	DATE_L	0
14	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	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
15	TXRGNNUM	Tax Registration Number	String	STR25	25
16	REMSUBTO	Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
17	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
18	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
19	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
20	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
21	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
22	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	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
23	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
24	MINORDER	Minimum Order	Currency	DLR17_$U2	17
25	VADCDPAD	Vendor Address Code - Purchase Address	String	STR15_Address_Code	15
	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
26	CMPANYID	Company ID	Integer	INT5	4
	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
27	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
28	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
29	CMPNYNAM	Company Name	String	STR64_Company_Name	64
30	CONTACT	Contact	String	STR60	60
31	ADDRESS1	Address 1	String	STR60	60
32	ADDRESS2	Address 2	String	STR60	60
33	ADDRESS3	Address 3	String	STR60	60
34	CITY	City	String	STR35	35
35	STATE	State	String	STR30_State	29
36	ZIPCODE	Zip Code	String	STR10	10
37	CCode	Country Code	String	STR6_VAT	6
	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
38	COUNTRY	Country	String	STR60	60
39	PHONE1	Phone 1	String	Phone_Number	14
40	PHONE2	Phone 2	String	Phone_Number	14
41	PHONE3	Phone 3	String	Phone_Number3	14
42	FAX	Fax	String	STR14_FAX	14
43	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	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
44	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
45	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
46	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
47	DISCDATE	Discount Date	Date	DT	8
48	DUEDATE	Due Date	Date	DT	8
49	TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	Trade Discount Percent (Precise)	23
50	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	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
51	TIMESPRT	Times Printed	Integer	INT4_U0	4
52	CREATDDT	Created Date	Date	DT	8
53	MODIFDT	Modified Date	Date	DT	8
54	PONOTIDS_1	PO Note ID Array[1]	Currency	DLR14	14
55	PONOTIDS	PO Note ID Array	DLR14	Currency	14
56	PONOTIDS_2	PO Note ID Array[2]	Currency	DLR14	14
57	PONOTIDS_3	PO Note ID Array[3]	Currency	DLR14	14
58	PONOTIDS_4	PO Note ID Array[4]	Currency	DLR14	14
59	PONOTIDS_5	PO Note ID Array[5]	Currency	DLR14	14
60	PONOTIDS_6	PO Note ID Array[6]	Currency	DLR14	14
61	PONOTIDS_7	PO Note ID Array[7]	Currency	DLR14	14
62	PONOTIDS_8	PO Note ID Array[8]	Currency	DLR14	14
63	PONOTIDS_9	PO Note ID Array[9]	Currency	DLR14	14
64	PONOTIDS_10	PO Note ID Array[10]	Currency	DLR14	14
65	PONOTIDS_11	PO Note ID Array[11]	Currency	DLR14	14
66	PONOTIDS_12	PO Note ID Array[12]	Currency	DLR14	14
67	PONOTIDS_13	PO Note ID Array[13]	Currency	DLR14	14
68	PONOTIDS_14	PO Note ID Array[14]	Currency	DLR14	14
69	PONOTIDS_15	PO Note ID Array[15]	Currency	DLR14	14
70	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	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
71	CANCSUB	Canceled Subtotal	Currency	DLR17_RBS0_STR$	17
72	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	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
73	CURRNIDX	Currency Index	Integer	INT3	3
	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
74	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	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
75	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	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
76	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
77	EXCHDATE	Exchange Date	Date	DT_Date	6
78	TIME1	Time	Time	TM6	6
79	RATECALC	Rate Calc Method	Integer	INT	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
80	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
81	MCTRXSTT	MC Transaction State	Integer	INT1	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.
82	OREMSUBT	Originating Remaining Subtotal	Currency	DLR17_RBS0_UTR$	17
83	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
84	Originating_Canceled_Sub	Originating Canceled Subtotal	Currency	DLR17_RBS0_STR$	17
85	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
86	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
87	OMISCAMT	Originating Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
88	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
89	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
90	ODISAMTAV	Originating Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
91	BUYERID	Buyer ID	String	STR15_User_ID	15
	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
92	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
93	ORORDAMT	Originating On Order Amount	Currency	DLR19_RBS0_UTR$	19
94	HOLD	Hold	Boolean	CB_Hold	0
95	ONHOLDDATE	On Hold Date	Date	DT	8
96	ONHOLDBY	On Hold By	String	STR15_User_ID	15
97	HOLDREMOVEDATE	Hold Remove Date	Date	DT	8
98	HOLDREMOVEBY	Hold Remove By	String	STR15_User_ID	15
99	ALLOWSOCMTS	Allow SO Commitments	Boolean	CB_AllowSOCommitments	0
100	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
101	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
102	Revision_Number	Revision Number	Integer	INT4	4
103	Change_Order_Flag	Change Order Flag	Integer	INT	0
104	PO_Field_Changes	PO Field Changes	Long Integer	ML_POP_PO_Field_Changes	0
105	PO_Status_Orig	PO Status Orig	Integer	DDL_PO_Status	0
	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
106	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	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
107	TXSCHSRC	Tax Schedule Source	Integer	INT1	1
108	TXENGCLD	Tax Engine Called	Boolean	YN	0
109	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
110	Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	DDL_Purchase_Tax_Options	0
111	Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	DDL_Purchase_Tax_Options	0
112	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	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
113	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	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
114	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
115	ORFRTTAX	Originating Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
116	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
117	ORMSCTAX	Originating Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
118	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
119	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
120	BackoutFreightTaxAmt	Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
121	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
122	BackoutMiscTaxAmt	Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
123	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
124	Flags	Flags	Integer	INT1	1
125	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
126	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
127	POPCONTNUM	POP Contract Number	String	STR20	20
128	CONTENDDTE	Contract End Date	Date	DATE_L	0
129	CNTRLBLKTBY	Control Blanket By	Integer	INT	0
130	PURCHCMPNYNAM	Purchase Company Name	String	STR64_Company_Name	64
131	PURCHCONTACT	Purchase Contact	String	STR60	60
132	PURCHADDRESS1	Purchase Address 1	String	STR60	60
133	PURCHADDRESS2	Purchase Address 2	String	STR60	60
134	PURCHADDRESS3	Purchase Address 3	String	STR60	60
135	PURCHCITY	Purchase City	String	STR35	35
136	PURCHSTATE	Purchase State	String	STR30_State	29
137	PURCHZIPCODE	Purchase Zip Code	String	STR10	10
138	PURCHCCode	Purchase Country Code	String	STR6_VAT	6
139	PURCHCOUNTRY	Purchase Country	String	STR60	60
140	PURCHPHONE1	Purchase Phone 1	String	Phone_Number	14
141	PURCHPHONE2	Purchase Phone 2	String	Phone_Number	14
142	PURCHPHONE3	Purchase Phone 3	String	Phone_Number3	14
143	PURCHFAX	Purchase Fax	String	STR14_FAX	14
144	BLNKTLINEEXTQTYSUM	Total Blanket Line Ext Qty	Currency	DLR17_QTY_RBS0_UTR	17
145	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
146	Workflow_Approval_Status	Workflow Approval Status	Integer	DDL_WorkflowApprovalStatus	0
147	Workflow_Priority	Workflow Priority	Integer	DDL_WorkflowPriority	0
148	Workflow_Status	Workflow Status	Integer	Workflow Status	0
149	Print_Phone_NumberGB	Print Phone Number GB	Integer	GB	0
150	PrepaymentAmount	Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
151	OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	DLR19_RBS0_UTR$	19

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchase Order Work (POP10100)

3 thoughts on “Purchase Order Work (POP10100)”

Mike says:

18th August 2022 at 1652

Hello,

Did something change with Dynamics GP tables? I can no longer find columns that belong to multiple GP tables. For example, if I search for table POP10100, there is a hyperlink for every column. In the past, if I clicked on the hyperlink for column PONUMBER, I would get a list of POP tables that had this column. Now, when I click on this hyperlink, I get a number of tables that I do not recognize.

Thanks

1. iangrieve says:
  
  27th August 2022 at 1653
  
  I did an update recently which looks like it has had an odd side-effect.
  
  I’ll take a look into it and see what the issue is.
  
  Thanks for flagging this.
  
  1. iangrieve says:
    
    27th August 2022 at 1714
    
    This should now be resolved with all table snow correctly being returned.
    
    Please let me know if you see any other issues.

3 thoughts on “Purchase Order Work (POP10100)”

Leave a Reply Cancel reply