Purchasing Setup Table (POP40100)

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

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