Purchasing Setup Table (POP40100)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Setup Table
Physical Name: POP40100
Technical Name: POP_Setup

Group Display Name: Purchasing Setup
Group Technical Name: Purchasing Setup

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	INDEX1	Index	INT1	Integer	2	1
2	PO_Code	PO Code	STR3	String	4	3
3	PONUMBER	PO Number	STR17_POP_Number	String	18	17
4	POFORMAT	PO Format	DDL_POP_Document_Formats	Integer	2	0
5	POPRCTNM	POP Receipt Number	STR17_POP_Number	String	18	17
6	Receipt_Code	Receipt Code	STR3	String	4	3
7	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	2	0
	Number of decimal places for the quantities. Click to show/hide Decimal Places Currency 1 0 decimals 2 1 3 2 4 3 5 4 6 5
8	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	2	0
	Number of decimal places for the currency values, based on the item's settings. Click to show/hide Decimal Places Currency 7 0 decimals 8 1 9 2 10 3 11 4 12 5
9	POHIST	PO Maintain History	Boolean	Boolean	2	0
10	RCPTHIST	Receipt Maintain History	Boolean	Boolean	2	0
11	DISTHIST	Distribution Maintain History	Boolean	Boolean	2	0
12	DSPLYITM	Display Item	INT	Integer	2	0
13	CREATDDT	Created Date	DT	Date	4	8
14	MODIFDT	Modified Date	DT	Date	4	8
15	Number_Of_Lines	Number Of Lines	INT3_U0	Integer	2	3
16	POPALWOP	POP Allow Option	CB	Boolean	2	0
17	POPALWOP_1	POP Allow Option[1]	CB	Boolean	2	0
18	POPALWOP_2	POP Allow Option[2]	CB	Boolean	2	0
19	POPALWOP_3	POP Allow Option[3]	CB	Boolean	2	0
20	POPALWOP_4	POP Allow Option[4]	CB	Boolean	2	0
21	POPALWOP_5	POP Allow Option[5]	CB	Boolean	2	0
22	POPPSWRD	POP Option Password	Password	String	12	10
23	POPPSWRD_1	POP Option Password[1]	Password	String	12	10
24	POPPSWRD_2	POP Option Password[2]	Password	String	12	10
25	POPPSWRD_3	POP Option Password[3]	Password	String	12	10
26	POPPSWRD_4	POP Option Password[4]	Password	String	12	10
27	POPPSWRD_5	POP Option Password[5]	Password	String	12	10
28	DEFAULTSITEMETHOD	Default Site Method	DDL_Default_Site	Integer	2	0
29	ALLOWHOLDEDIT	Allow Hold Edit	CB_Allow_Hold_Edit	Boolean	2	0
30	AUTOHOLD	Auto Assign Holds	CB_AutoAssignHolds	Boolean	2	0
31	SearchPOQtysFromSO	SearchPOQtysFromSO	CB_SearchPOQtysFromSO	Boolean	2	0
32	TransferLineComments	TransferLineComments	CB_TransferLineComments	Boolean	2	0
33	Purchase_Non_IV_Taxable	Purchase Non IV Taxable	DDL_Purchase_Tax_Options	Integer	2	0
34	Purchase_Freight_Taxable	Purchase Freight Taxable	DDL_Purchase_Tax_Options	Integer	2	0
35	Purchase_Misc_Taxable	Purchase Misc Taxable	DDL_Purchase_Tax_Options	Integer	2	0
36	NONIVSCH	Non IV Item Schedule ID	STR15_Tax_Schedule_ID	String	16	15
37	FRTSCHID	Freight Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Setup Table'].FRTSCHID AS 'Purchasing Setup Table-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP40100 AS ['Purchasing Setup Table'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Setup Table'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
38	MSCSCHID	Misc Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Setup Table'].MSCSCHID AS 'Purchasing Setup Table-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP40100 AS ['Purchasing Setup Table'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Setup Table'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
39	USEADVTX	Use Advanced Taxes	GB	Integer	2	0
40	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 ['Purchasing Setup Table'].TAXSCHID AS 'Purchasing Setup Table-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP40100 AS ['Purchasing Setup Table'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Setup Table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
41	User_Defined_Prompt01	User Defined Prompt01	STR30	String	32	30
42	User_Defined_Prompt02	User Defined Prompt02	STR30	String	32	30
43	User_Defined_Prompt03	User Defined Prompt03	STR30	String	32	30
44	User_Defined_Prompt04	User Defined Prompt04	STR30	String	32	30
45	User_Defined_Prompt05	User Defined Prompt05	STR30	String	32	30
46	User_Defined_Prompt06	User Defined Prompt06	STR30	String	32	30
47	User_Defined_Prompt07	User Defined Prompt07	STR30	String	32	30
48	User_Defined_Prompt08	User Defined Prompt08	STR30	String	32	30
49	User_Defined_Prompt09	User Defined Prompt09	STR30	String	32	30
50	User_Defined_Prompt10	User Defined Prompt10	STR30	String	32	30
51	User_Defined_Prompt11	User Defined Prompt11	STR30	String	32	30
52	User_Defined_Prompt12	User Defined Prompt12	STR30	String	32	30
53	User_Defined_Prompt13	User Defined Prompt13	STR30	String	32	30
54	User_Defined_Prompt14	User Defined Prompt14	STR30	String	32	30
55	User_Defined_Prompt15	User Defined Prompt15	STR30	String	32	30
56	User_Defined_Prompt16	User Defined Prompt16	STR30	String	32	30
57	User_Defined_Prompt17	User Defined Prompt17	STR30	String	32	30
58	User_Defined_Prompt18	User Defined Prompt18	STR30	String	32	30
59	User_Defined_Prompt19	User Defined Prompt19	STR30	String	32	30
60	User_Defined_Prompt20	User Defined Prompt20	STR30	String	32	30
61	User_Defined_Prompt21	User Defined Prompt21	STR30	String	32	30
62	User_Defined_Prompt22	User Defined Prompt22	STR30	String	32	30
63	User_Defined_Prompt23	User Defined Prompt23	STR30	String	32	30
64	User_Defined_Prompt24	User Defined Prompt24	STR30	String	32	30
65	User_Defined_Prompt25	User Defined Prompt25	STR30	String	32	30
66	User_Defined_Prompt26	User Defined Prompt26	STR30	String	32	30
67	User_Defined_Prompt27	User Defined Prompt27	STR30	String	32	30
68	User_Defined_Prompt28	User Defined Prompt28	STR30	String	32	30
69	User_Defined_Prompt29	User Defined Prompt29	STR30	String	32	30
70	User_Defined_Prompt30	User Defined Prompt30	STR30	String	32	30
71	User_Defined_Prompt31	User Defined Prompt31	STR30	String	32	30
72	User_Defined_Prompt32	User Defined Prompt32	STR30	String	32	30
73	User_Defined_Prompt33	User Defined Prompt33	STR30	String	32	30
74	User_Defined_Prompt34	User Defined Prompt34	STR30	String	32	30
75	User_Defined_Prompt35	User Defined Prompt35	STR30	String	32	30
76	FreightTaxSchedNoteIdx	Freight Tax Schedule Note Index	DLR14	Currency	10	14
77	MiscTaxSchedNoteIdx	Misc Tax Schedule Note Index	DLR14	Currency	10	14
78	NonIVTaxSchedNoteIdx	Non IV Tax Schedule Note Index	DLR14	Currency	10	14
79	SingleTaxSchedNoteIdx	Single Tax Schedule Note Index	DLR14	Currency	10	14
80	ReplenishmentLevel	Replenishment Level	DDL_ReplenishmentLevel	Integer	2	0
81	POPOrderMethod	POP Order Method	DDL_POP_OrderMethod	Integer	2	0
82	MasterLocationCode	Master Location Code	STR10_Location_Code	String	12	10
83	POPVendorSelection	POP Vendor Selection	DDL_POP_VendorSelection	Integer	2	0
84	POPPricingSelection	POP Pricing Selection	DDL_POP_PriceSelection	Integer	2	0
85	IncludeAllocations	Include Allocations	CB_IncludeAllocations	Boolean	2	0
86	IncludeBackorders	Include Backorders	CB_IncludeBackorders	Boolean	2	0
87	IncludeRequisitions	Include Requisitions	CB_IncludeRequisitions	Boolean	2	0
88	RETORIGTAX	Return Original Taxes	CB_ReturnOriginalTaxes	Boolean	2	0
89	ONEPOPERADDR	Create One PO Per Address	CB_CreateOnePOPerAddress	Boolean	2	0
90	CALCRELDT	Calc Release By Date Using Vendors Lead	CB_CalcReleaseByDateUsingVendorsLead	Boolean	2	0
91	Default_Document_Date	Default Document Date	DDL_Default_Date	Integer	2	0
92	UseQtyOverageTolerance	Use Qty Overage Tolerance	CB	Boolean	2	0
93	UseQtyShortageTolerance	Use Qty Shortage Tolerance	CB	Boolean	2	0
94	QtyOverTolerancePercent	Qty Overage Tolerance Percentage	LI5_%3	Long Integer	4	5
95	QtyShortTolerancePercent	Qty Shortage Tolerance Percentage	LI5_%3	Long Integer	4	5
96	AllowPOPrepayments	Allow Purchase Order Prepayments	CB_AllowPurchaseOrderPrepayments	Boolean	2	0
97	CreateManualPrepayment	Create Manual Prepayment	CB	Boolean	2	0
98	PrepaymentPassword	Prepayment Password	Password	String	12	10
99	PrepaymentAccountIndex	Prepayment Account Index	LI_14	Long Integer	4	14
100	RequisitionCode	Requisition Code	STR3	String	4	3
101	POPRequisitionNumber	POP Requisition Number	STR17_POP_Number	String	18	17
102	RequisitionMaintainHist	Requisition Maintain History	Boolean	Boolean	2	0
103	RequisitionDefDocDate	Requisition Default Doc Date	DDL_Default_Date	Integer	2	0
104	RequisitionDefSiteMethod	Requisition Default Site Method	DDL_Default_Site	Integer	2	0
105	RequisitionVendorSelect	Requisition Vendor Selection	DDL_POP_VendorSelection	Integer	2	0
106	RequisitionCostSelection	Requisition Cost Selection	DDL_POP_PriceSelection	Integer	2	0
107	ReqCreateOnePOPerAddress	Requisition Create One PO Per Address	CB_CreateOnePOPerAddress	Boolean	2	0
108	ReqTransferLineComments	Requisition Transfer Line Comments	CB_TransferLineCommentsFromReq	Boolean	2	0
109	SearchPOQtysFromRequisit	SearchPOQtysFromRequisition	CB_SearchForUncommitedPOQtys	Boolean	2	0
110	Req_Hdr_UD_Prompt1	Req Hdr User Defined Prompt 1	STR15	String	16	15
111	Req_Hdr_UD_Prompt2	Req Hdr User Defined Prompt 2	STR15	String	16	15
112	Req_Line_UD_Prompt1	Req Line User Defined Prompt 1	STR15	String	16	15
113	Req_Line_UD_Prompt2	Req Line User Defined Prompt 2	STR15	String	16	15
114	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)PurchasingPurchasing Setup Table (POP40100)

Click to show/hide Decimal Places Currency

Click to show/hide Decimal Places Currency

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply