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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1INDEX1 SearchIndexINT1Integer21
2PO_Code SearchPO CodeSTR3String43
3PONUMBER SearchPO NumberSTR17_POP_NumberString1817
4POFORMAT SearchPO FormatDDL_POP_Document_FormatsInteger20
5POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
6Receipt_Code SearchReceipt CodeSTR3String43
7DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
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
8DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
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
9POHIST SearchPO Maintain HistoryBooleanBoolean20
10RCPTHIST SearchReceipt Maintain HistoryBooleanBoolean20
11DISTHIST SearchDistribution Maintain HistoryBooleanBoolean20
12DSPLYITM SearchDisplay ItemINTInteger20
13CREATDDT SearchCreated DateDTDate48
14MODIFDT SearchModified DateDTDate48
15Number_Of_Lines SearchNumber Of LinesINT3_U0Integer23
16POPALWOP SearchPOP Allow OptionCBBoolean20
17POPALWOP_1 SearchPOP Allow Option[1]CBBoolean20
18POPALWOP_2 SearchPOP Allow Option[2]CBBoolean20
19POPALWOP_3 SearchPOP Allow Option[3]CBBoolean20
20POPALWOP_4 SearchPOP Allow Option[4]CBBoolean20
21POPALWOP_5 SearchPOP Allow Option[5]CBBoolean20
22POPPSWRD SearchPOP Option PasswordPasswordString1210
23POPPSWRD_1 SearchPOP Option Password[1]PasswordString1210
24POPPSWRD_2 SearchPOP Option Password[2]PasswordString1210
25POPPSWRD_3 SearchPOP Option Password[3]PasswordString1210
26POPPSWRD_4 SearchPOP Option Password[4]PasswordString1210
27POPPSWRD_5 SearchPOP Option Password[5]PasswordString1210
28DEFAULTSITEMETHOD SearchDefault Site MethodDDL_Default_SiteInteger20
29ALLOWHOLDEDIT SearchAllow Hold EditCB_Allow_Hold_EditBoolean20
30AUTOHOLD SearchAuto Assign HoldsCB_AutoAssignHoldsBoolean20
31SearchPOQtysFromSO SearchSearchPOQtysFromSOCB_SearchPOQtysFromSOBoolean20
32TransferLineComments SearchTransferLineCommentsCB_TransferLineCommentsBoolean20
33Purchase_Non_IV_Taxable SearchPurchase Non IV TaxableDDL_Purchase_Tax_OptionsInteger20
34Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger20
35Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger20
36NONIVSCH SearchNon IV Item Schedule IDSTR15_Tax_Schedule_IDString1615
37FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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
38MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
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
39USEADVTX SearchUse Advanced TaxesGBInteger20
40TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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
41User_Defined_Prompt01 SearchUser Defined Prompt01STR30String3230
42User_Defined_Prompt02 SearchUser Defined Prompt02STR30String3230
43User_Defined_Prompt03 SearchUser Defined Prompt03STR30String3230
44User_Defined_Prompt04 SearchUser Defined Prompt04STR30String3230
45User_Defined_Prompt05 SearchUser Defined Prompt05STR30String3230
46User_Defined_Prompt06 SearchUser Defined Prompt06STR30String3230
47User_Defined_Prompt07 SearchUser Defined Prompt07STR30String3230
48User_Defined_Prompt08 SearchUser Defined Prompt08STR30String3230
49User_Defined_Prompt09 SearchUser Defined Prompt09STR30String3230
50User_Defined_Prompt10 SearchUser Defined Prompt10STR30String3230
51User_Defined_Prompt11 SearchUser Defined Prompt11STR30String3230
52User_Defined_Prompt12 SearchUser Defined Prompt12STR30String3230
53User_Defined_Prompt13 SearchUser Defined Prompt13STR30String3230
54User_Defined_Prompt14 SearchUser Defined Prompt14STR30String3230
55User_Defined_Prompt15 SearchUser Defined Prompt15STR30String3230
56User_Defined_Prompt16 SearchUser Defined Prompt16STR30String3230
57User_Defined_Prompt17 SearchUser Defined Prompt17STR30String3230
58User_Defined_Prompt18 SearchUser Defined Prompt18STR30String3230
59User_Defined_Prompt19 SearchUser Defined Prompt19STR30String3230
60User_Defined_Prompt20 SearchUser Defined Prompt20STR30String3230
61User_Defined_Prompt21 SearchUser Defined Prompt21STR30String3230
62User_Defined_Prompt22 SearchUser Defined Prompt22STR30String3230
63User_Defined_Prompt23 SearchUser Defined Prompt23STR30String3230
64User_Defined_Prompt24 SearchUser Defined Prompt24STR30String3230
65User_Defined_Prompt25 SearchUser Defined Prompt25STR30String3230
66User_Defined_Prompt26 SearchUser Defined Prompt26STR30String3230
67User_Defined_Prompt27 SearchUser Defined Prompt27STR30String3230
68User_Defined_Prompt28 SearchUser Defined Prompt28STR30String3230
69User_Defined_Prompt29 SearchUser Defined Prompt29STR30String3230
70User_Defined_Prompt30 SearchUser Defined Prompt30STR30String3230
71User_Defined_Prompt31 SearchUser Defined Prompt31STR30String3230
72User_Defined_Prompt32 SearchUser Defined Prompt32STR30String3230
73User_Defined_Prompt33 SearchUser Defined Prompt33STR30String3230
74User_Defined_Prompt34 SearchUser Defined Prompt34STR30String3230
75User_Defined_Prompt35 SearchUser Defined Prompt35STR30String3230
76FreightTaxSchedNoteIdx SearchFreight Tax Schedule Note IndexDLR14Currency1014
77MiscTaxSchedNoteIdx SearchMisc Tax Schedule Note IndexDLR14Currency1014
78NonIVTaxSchedNoteIdx SearchNon IV Tax Schedule Note IndexDLR14Currency1014
79SingleTaxSchedNoteIdx SearchSingle Tax Schedule Note IndexDLR14Currency1014
80ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger20
81POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger20
82MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString1210
83POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger20
84POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger20
85IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean20
86IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean20
87IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean20
88RETORIGTAX SearchReturn Original TaxesCB_ReturnOriginalTaxesBoolean20
89ONEPOPERADDR SearchCreate One PO Per AddressCB_CreateOnePOPerAddressBoolean20
90CALCRELDT SearchCalc Release By Date Using Vendors LeadCB_CalcReleaseByDateUsingVendorsLeadBoolean20
91Default_Document_Date SearchDefault Document DateDDL_Default_DateInteger20
92UseQtyOverageTolerance SearchUse Qty Overage ToleranceCBBoolean20
93UseQtyShortageTolerance SearchUse Qty Shortage ToleranceCBBoolean20
94QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLI5_%3Long Integer45
95QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLI5_%3Long Integer45
96AllowPOPrepayments SearchAllow Purchase Order PrepaymentsCB_AllowPurchaseOrderPrepaymentsBoolean20
97CreateManualPrepayment SearchCreate Manual PrepaymentCBBoolean20
98PrepaymentPassword SearchPrepayment PasswordPasswordString1210
99PrepaymentAccountIndex SearchPrepayment Account IndexLI_14Long Integer414
100RequisitionCode SearchRequisition CodeSTR3String43
101POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString1817
102RequisitionMaintainHist SearchRequisition Maintain HistoryBooleanBoolean20
103RequisitionDefDocDate SearchRequisition Default Doc DateDDL_Default_DateInteger20
104RequisitionDefSiteMethod SearchRequisition Default Site MethodDDL_Default_SiteInteger20
105RequisitionVendorSelect SearchRequisition Vendor SelectionDDL_POP_VendorSelectionInteger20
106RequisitionCostSelection SearchRequisition Cost SelectionDDL_POP_PriceSelectionInteger20
107ReqCreateOnePOPerAddress SearchRequisition Create One PO Per AddressCB_CreateOnePOPerAddressBoolean20
108ReqTransferLineComments SearchRequisition Transfer Line CommentsCB_TransferLineCommentsFromReqBoolean20
109SearchPOQtysFromRequisit SearchSearchPOQtysFromRequisitionCB_SearchForUncommitedPOQtysBoolean20
110Req_Hdr_UD_Prompt1 SearchReq Hdr User Defined Prompt 1STR15String1615
111Req_Hdr_UD_Prompt2 SearchReq Hdr User Defined Prompt 2STR15String1615
112Req_Line_UD_Prompt1 SearchReq Line User Defined Prompt 1STR15String1615
113Req_Line_UD_Prompt2 SearchReq Line User Defined Prompt 2STR15String1615
114DEX_ROW_ID Searchintint1010

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 *