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 TypeLength
1INDEX1 SearchIndexINT1Integer1
2PO_Code SearchPO CodeSTR3String3
3PONUMBER SearchPO NumberSTR17_POP_NumberString17
4POFORMAT SearchPO FormatDDL_POP_Document_FormatsInteger0
5POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
6Receipt_Code SearchReceipt CodeSTR3String3
7DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
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_DollarsInteger0
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 HistoryBooleanBoolean0
10RCPTHIST SearchReceipt Maintain HistoryBooleanBoolean0
11DISTHIST SearchDistribution Maintain HistoryBooleanBoolean0
12DSPLYITM SearchDisplay ItemINTInteger0
13CREATDDT SearchCreated DateDTDate8
14MODIFDT SearchModified DateDTDate8
15Number_Of_Lines SearchNumber Of LinesINT3_U0Integer3
16POPALWOP SearchPOP Allow OptionCBBoolean0
17POPALWOP_1 SearchPOP Allow Option[1]CBBoolean0
18POPALWOP_2 SearchPOP Allow Option[2]CBBoolean0
19POPALWOP_3 SearchPOP Allow Option[3]CBBoolean0
20POPALWOP_4 SearchPOP Allow Option[4]CBBoolean0
21POPALWOP_5 SearchPOP Allow Option[5]CBBoolean0
22POPPSWRD SearchPOP Option PasswordPasswordString10
23POPPSWRD_1 SearchPOP Option Password[1]PasswordString10
24POPPSWRD_2 SearchPOP Option Password[2]PasswordString10
25POPPSWRD_3 SearchPOP Option Password[3]PasswordString10
26POPPSWRD_4 SearchPOP Option Password[4]PasswordString10
27POPPSWRD_5 SearchPOP Option Password[5]PasswordString10
28DEFAULTSITEMETHOD SearchDefault Site MethodDDL_Default_SiteInteger0
29ALLOWHOLDEDIT SearchAllow Hold EditCB_Allow_Hold_EditBoolean0
30AUTOHOLD SearchAuto Assign HoldsCB_AutoAssignHoldsBoolean0
31SearchPOQtysFromSO SearchSearchPOQtysFromSOCB_SearchPOQtysFromSOBoolean0
32TransferLineComments SearchTransferLineCommentsCB_TransferLineCommentsBoolean0
33Purchase_Non_IV_Taxable SearchPurchase Non IV TaxableDDL_Purchase_Tax_OptionsInteger0
34Purchase_Freight_Taxable SearchPurchase Freight TaxableDDL_Purchase_Tax_OptionsInteger0
35Purchase_Misc_Taxable SearchPurchase Misc TaxableDDL_Purchase_Tax_OptionsInteger0
36NONIVSCH SearchNon IV Item Schedule IDSTR15_Tax_Schedule_IDString15
37FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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_LBAUString15
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 TaxesGBInteger0
40TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 Prompt01STR30String30
42User_Defined_Prompt02 SearchUser Defined Prompt02STR30String30
43User_Defined_Prompt03 SearchUser Defined Prompt03STR30String30
44User_Defined_Prompt04 SearchUser Defined Prompt04STR30String30
45User_Defined_Prompt05 SearchUser Defined Prompt05STR30String30
46User_Defined_Prompt06 SearchUser Defined Prompt06STR30String30
47User_Defined_Prompt07 SearchUser Defined Prompt07STR30String30
48User_Defined_Prompt08 SearchUser Defined Prompt08STR30String30
49User_Defined_Prompt09 SearchUser Defined Prompt09STR30String30
50User_Defined_Prompt10 SearchUser Defined Prompt10STR30String30
51User_Defined_Prompt11 SearchUser Defined Prompt11STR30String30
52User_Defined_Prompt12 SearchUser Defined Prompt12STR30String30
53User_Defined_Prompt13 SearchUser Defined Prompt13STR30String30
54User_Defined_Prompt14 SearchUser Defined Prompt14STR30String30
55User_Defined_Prompt15 SearchUser Defined Prompt15STR30String30
56User_Defined_Prompt16 SearchUser Defined Prompt16STR30String30
57User_Defined_Prompt17 SearchUser Defined Prompt17STR30String30
58User_Defined_Prompt18 SearchUser Defined Prompt18STR30String30
59User_Defined_Prompt19 SearchUser Defined Prompt19STR30String30
60User_Defined_Prompt20 SearchUser Defined Prompt20STR30String30
61User_Defined_Prompt21 SearchUser Defined Prompt21STR30String30
62User_Defined_Prompt22 SearchUser Defined Prompt22STR30String30
63User_Defined_Prompt23 SearchUser Defined Prompt23STR30String30
64User_Defined_Prompt24 SearchUser Defined Prompt24STR30String30
65User_Defined_Prompt25 SearchUser Defined Prompt25STR30String30
66User_Defined_Prompt26 SearchUser Defined Prompt26STR30String30
67User_Defined_Prompt27 SearchUser Defined Prompt27STR30String30
68User_Defined_Prompt28 SearchUser Defined Prompt28STR30String30
69User_Defined_Prompt29 SearchUser Defined Prompt29STR30String30
70User_Defined_Prompt30 SearchUser Defined Prompt30STR30String30
71User_Defined_Prompt31 SearchUser Defined Prompt31STR30String30
72User_Defined_Prompt32 SearchUser Defined Prompt32STR30String30
73User_Defined_Prompt33 SearchUser Defined Prompt33STR30String30
74User_Defined_Prompt34 SearchUser Defined Prompt34STR30String30
75User_Defined_Prompt35 SearchUser Defined Prompt35STR30String30
76FreightTaxSchedNoteIdx SearchFreight Tax Schedule Note IndexDLR14Currency14
77MiscTaxSchedNoteIdx SearchMisc Tax Schedule Note IndexDLR14Currency14
78NonIVTaxSchedNoteIdx SearchNon IV Tax Schedule Note IndexDLR14Currency14
79SingleTaxSchedNoteIdx SearchSingle Tax Schedule Note IndexDLR14Currency14
80ReplenishmentLevel SearchReplenishment LevelDDL_ReplenishmentLevelInteger0
81POPOrderMethod SearchPOP Order MethodDDL_POP_OrderMethodInteger0
82MasterLocationCode SearchMaster Location CodeSTR10_Location_CodeString10
83POPVendorSelection SearchPOP Vendor SelectionDDL_POP_VendorSelectionInteger0
84POPPricingSelection SearchPOP Pricing SelectionDDL_POP_PriceSelectionInteger0
85IncludeAllocations SearchInclude AllocationsCB_IncludeAllocationsBoolean0
86IncludeBackorders SearchInclude BackordersCB_IncludeBackordersBoolean0
87IncludeRequisitions SearchInclude RequisitionsCB_IncludeRequisitionsBoolean0
88RETORIGTAX SearchReturn Original TaxesCB_ReturnOriginalTaxesBoolean0
89ONEPOPERADDR SearchCreate One PO Per AddressCB_CreateOnePOPerAddressBoolean0
90CALCRELDT SearchCalc Release By Date Using Vendors LeadCB_CalcReleaseByDateUsingVendorsLeadBoolean0
91Default_Document_Date SearchDefault Document DateDDL_Default_DateInteger0
92UseQtyOverageTolerance SearchUse Qty Overage ToleranceCBBoolean0
93UseQtyShortageTolerance SearchUse Qty Shortage ToleranceCBBoolean0
94QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLI5_%3Long Integer5
95QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLI5_%3Long Integer5
96AllowPOPrepayments SearchAllow Purchase Order PrepaymentsCB_AllowPurchaseOrderPrepaymentsBoolean0
97CreateManualPrepayment SearchCreate Manual PrepaymentCBBoolean0
98PrepaymentPassword SearchPrepayment PasswordPasswordString10
99PrepaymentAccountIndex SearchPrepayment Account IndexLI_14Long Integer14
100RequisitionCode SearchRequisition CodeSTR3String3
101POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString17
102RequisitionMaintainHist SearchRequisition Maintain HistoryBooleanBoolean0
103RequisitionDefDocDate SearchRequisition Default Doc DateDDL_Default_DateInteger0
104RequisitionDefSiteMethod SearchRequisition Default Site MethodDDL_Default_SiteInteger0
105RequisitionVendorSelect SearchRequisition Vendor SelectionDDL_POP_VendorSelectionInteger0
106RequisitionCostSelection SearchRequisition Cost SelectionDDL_POP_PriceSelectionInteger0
107ReqCreateOnePOPerAddress SearchRequisition Create One PO Per AddressCB_CreateOnePOPerAddressBoolean0
108ReqTransferLineComments SearchRequisition Transfer Line CommentsCB_TransferLineCommentsFromReqBoolean0
109SearchPOQtysFromRequisit SearchSearchPOQtysFromRequisitionCB_SearchForUncommitedPOQtysBoolean0
110Req_Hdr_UD_Prompt1 SearchReq Hdr User Defined Prompt 1STR15String15
111Req_Hdr_UD_Prompt2 SearchReq Hdr User Defined Prompt 2STR15String15
112Req_Line_UD_Prompt1 SearchReq Line User Defined Prompt 1STR15String15
113Req_Line_UD_Prompt2 SearchReq Line User Defined Prompt 2STR15String15
114DEX_ROW_ID Searchintint10

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 *