POP40100 - Purchasing Setup Table | Prospr - Dynamics GP Table Reference

POP40100 - Purchasing Setup Table

Query Builder

Select * from POP40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
INDEX1	Index	Integer	2	View
PO_Code	PO Code	String	4	View
PONUMBER	PO Number	String	18	View
POFORMAT	PO Format	Integer	2	View
POPRCTNM	POP Receipt Number	String	18	View
Receipt_Code	Receipt Code	String	4	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
POHIST	PO Maintain History	Boolean	2	View
RCPTHIST	Receipt Maintain History	Boolean	2	View
DISTHIST	Distribution Maintain History	Boolean	2	View
DSPLYITM	Display Item	Integer	2	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
Number_Of_Lines	Number Of Lines	Integer	2	View
POPALWOP_1	POP Allow Option[1]	Boolean	2	View
POPALWOP_2	POP Allow Option[2]	Boolean	2	View
POPALWOP_3	POP Allow Option[3]	Boolean	2	View
POPALWOP_4	POP Allow Option[4]	Boolean	2	View
POPALWOP_5	POP Allow Option[5]	Boolean	2	View
POPPSWRD_1	POP Option Password[1]	String	12	View
POPPSWRD_2	POP Option Password[2]	String	12	View
POPPSWRD_3	POP Option Password[3]	String	12	View
POPPSWRD_4	POP Option Password[4]	String	12	View
POPPSWRD_5	POP Option Password[5]	String	12	View
DEFAULTSITEMETHOD	Default Site Method	Integer	2	View
ALLOWHOLDEDIT	Allow Hold Edit	Boolean	2	View
AUTOHOLD	Auto Assign Holds	Boolean	2	View
SearchPOQtysFromSO	SearchPOQtysFromSO	Boolean	2	View
TransferLineComments	TransferLineComments	Boolean	2	View
Purchase_Non_IV_Taxable	Purchase Non IV Taxable	Integer	2	View
Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	2	View
Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	2	View
NONIVSCH	Non IV Item Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
USEADVTX	Use Advanced Taxes	Integer	2	View
TAXSCHID	Tax Schedule ID	String	16	View
User_Defined_Prompt01	User Defined Prompt01	String	32	View
User_Defined_Prompt02	User Defined Prompt02	String	32	View
User_Defined_Prompt03	User Defined Prompt03	String	32	View
User_Defined_Prompt04	User Defined Prompt04	String	32	View
User_Defined_Prompt05	User Defined Prompt05	String	32	View
User_Defined_Prompt06	User Defined Prompt06	String	32	View
User_Defined_Prompt07	User Defined Prompt07	String	32	View
User_Defined_Prompt08	User Defined Prompt08	String	32	View
User_Defined_Prompt09	User Defined Prompt09	String	32	View
User_Defined_Prompt10	User Defined Prompt10	String	32	View
User_Defined_Prompt11	User Defined Prompt11	String	32	View
User_Defined_Prompt12	User Defined Prompt12	String	32	View
User_Defined_Prompt13	User Defined Prompt13	String	32	View
User_Defined_Prompt14	User Defined Prompt14	String	32	View
User_Defined_Prompt15	User Defined Prompt15	String	32	View
User_Defined_Prompt16	User Defined Prompt16	String	32	View
User_Defined_Prompt17	User Defined Prompt17	String	32	View
User_Defined_Prompt18	User Defined Prompt18	String	32	View
User_Defined_Prompt19	User Defined Prompt19	String	32	View
User_Defined_Prompt20	User Defined Prompt20	String	32	View
User_Defined_Prompt21	User Defined Prompt21	String	32	View
User_Defined_Prompt22	User Defined Prompt22	String	32	View
User_Defined_Prompt23	User Defined Prompt23	String	32	View
User_Defined_Prompt24	User Defined Prompt24	String	32	View
User_Defined_Prompt25	User Defined Prompt25	String	32	View
User_Defined_Prompt26	User Defined Prompt26	String	32	View
User_Defined_Prompt27	User Defined Prompt27	String	32	View
User_Defined_Prompt28	User Defined Prompt28	String	32	View
User_Defined_Prompt29	User Defined Prompt29	String	32	View
User_Defined_Prompt30	User Defined Prompt30	String	32	View
User_Defined_Prompt31	User Defined Prompt31	String	32	View
User_Defined_Prompt32	User Defined Prompt32	String	32	View
User_Defined_Prompt33	User Defined Prompt33	String	32	View
User_Defined_Prompt34	User Defined Prompt34	String	32	View
User_Defined_Prompt35	User Defined Prompt35	String	32	View
FreightTaxSchedNoteIdx	Freight Tax Schedule Note Index	Currency	10	View
MiscTaxSchedNoteIdx	Misc Tax Schedule Note Index	Currency	10	View
NonIVTaxSchedNoteIdx	Non IV Tax Schedule Note Index	Currency	10	View
SingleTaxSchedNoteIdx	Single Tax Schedule Note Index	Currency	10	View
ReplenishmentLevel	Replenishment Level	Integer	2	View
POPOrderMethod	POP Order Method	Integer	2	View
MasterLocationCode	Master Location Code	String	12	View
POPVendorSelection	POP Vendor Selection	Integer	2	View
POPPricingSelection	POP Pricing Selection	Integer	2	View
IncludeAllocations	Include Allocations	Boolean	2	View
IncludeBackorders	Include Backorders	Boolean	2	View
IncludeRequisitions	Include Requisitions	Boolean	2	View
RETORIGTAX	Return Original Taxes	Boolean	2	View
ONEPOPERADDR	Create One PO Per Address	Boolean	2	View
CALCRELDT	Calc Release By Date Using Vendors Lead	Boolean	2	View
Default_Document_Date	Default Document Date	Integer	2	View
UseQtyOverageTolerance	Use Qty Overage Tolerance	Boolean	2	View
UseQtyShortageTolerance	Use Qty Shortage Tolerance	Boolean	2	View
QtyOverTolerancePercent	Qty Overage Tolerance Percentage	Long Integer	4	View
QtyShortTolerancePercent	Qty Shortage Tolerance Percentage	Long Integer	4	View
AllowPOPrepayments	Allow Purchase Order Prepayments	Boolean	2	View
CreateManualPrepayment	Create Manual Prepayment	Boolean	2	View
PrepaymentPassword	Prepayment Password	String	12	View
PrepaymentAccountIndex	Prepayment Account Index	Long Integer	4	View

POP40100 - Purchasing Setup Table

Query Builder

Customer Service

Information

My Account

Contact Us