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 SearchIndexIntegerINT11
2PO_Code SearchPO CodeStringSTR33
3PONUMBER SearchPO NumberStringSTR17_POP_Number17
4POFORMAT SearchPO FormatIntegerDDL_POP_Document_Formats0
5POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
6Receipt_Code SearchReceipt CodeStringSTR33
7DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
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 CurrencyIntegerDDL_Decimal_Places_Dollars0
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 ItemIntegerINT0
13CREATDDT SearchCreated DateDateDT8
14MODIFDT SearchModified DateDateDT8
15Number_Of_Lines SearchNumber Of LinesIntegerINT3_U03
16POPALWOP SearchPOP Allow OptionCBBoolean0
17POPALWOP_1 SearchPOP Allow Option[1]BooleanCB0
18POPALWOP_2 SearchPOP Allow Option[2]BooleanCB0
19POPALWOP_3 SearchPOP Allow Option[3]BooleanCB0
20POPALWOP_4 SearchPOP Allow Option[4]BooleanCB0
21POPALWOP_5 SearchPOP Allow Option[5]BooleanCB0
22POPPSWRD_1 SearchPOP Option Password[1]StringPassword10
23POPPSWRD_2 SearchPOP Option Password[2]StringPassword10
24POPPSWRD SearchPOP Option PasswordPasswordString10
25POPPSWRD_3 SearchPOP Option Password[3]StringPassword10
26POPPSWRD_4 SearchPOP Option Password[4]StringPassword10
27POPPSWRD_5 SearchPOP Option Password[5]StringPassword10
28DEFAULTSITEMETHOD SearchDefault Site MethodIntegerDDL_Default_Site0
29ALLOWHOLDEDIT SearchAllow Hold EditBooleanCB_Allow_Hold_Edit0
30AUTOHOLD SearchAuto Assign HoldsBooleanCB_AutoAssignHolds0
31SearchPOQtysFromSO SearchSearchPOQtysFromSOBooleanCB_SearchPOQtysFromSO0
32TransferLineComments SearchTransferLineCommentsBooleanCB_TransferLineComments0
33Purchase_Non_IV_Taxable SearchPurchase Non IV TaxableIntegerDDL_Purchase_Tax_Options0
34Purchase_Freight_Taxable SearchPurchase Freight TaxableIntegerDDL_Purchase_Tax_Options0
35Purchase_Misc_Taxable SearchPurchase Misc TaxableIntegerDDL_Purchase_Tax_Options0
36NONIVSCH SearchNon IV Item Schedule IDStringSTR15_Tax_Schedule_ID15
37FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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 IDStringSTR15_LBAU15
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 TaxesIntegerGB0
40TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 Prompt01StringSTR3030
42User_Defined_Prompt02 SearchUser Defined Prompt02StringSTR3030
43User_Defined_Prompt03 SearchUser Defined Prompt03StringSTR3030
44User_Defined_Prompt04 SearchUser Defined Prompt04StringSTR3030
45User_Defined_Prompt05 SearchUser Defined Prompt05StringSTR3030
46User_Defined_Prompt06 SearchUser Defined Prompt06StringSTR3030
47User_Defined_Prompt07 SearchUser Defined Prompt07StringSTR3030
48User_Defined_Prompt08 SearchUser Defined Prompt08StringSTR3030
49User_Defined_Prompt09 SearchUser Defined Prompt09StringSTR3030
50User_Defined_Prompt10 SearchUser Defined Prompt10StringSTR3030
51User_Defined_Prompt11 SearchUser Defined Prompt11StringSTR3030
52User_Defined_Prompt12 SearchUser Defined Prompt12StringSTR3030
53User_Defined_Prompt13 SearchUser Defined Prompt13StringSTR3030
54User_Defined_Prompt14 SearchUser Defined Prompt14StringSTR3030
55User_Defined_Prompt15 SearchUser Defined Prompt15StringSTR3030
56User_Defined_Prompt16 SearchUser Defined Prompt16StringSTR3030
57User_Defined_Prompt17 SearchUser Defined Prompt17StringSTR3030
58User_Defined_Prompt18 SearchUser Defined Prompt18StringSTR3030
59User_Defined_Prompt19 SearchUser Defined Prompt19StringSTR3030
60User_Defined_Prompt20 SearchUser Defined Prompt20StringSTR3030
61User_Defined_Prompt21 SearchUser Defined Prompt21StringSTR3030
62User_Defined_Prompt22 SearchUser Defined Prompt22StringSTR3030
63User_Defined_Prompt23 SearchUser Defined Prompt23StringSTR3030
64User_Defined_Prompt24 SearchUser Defined Prompt24StringSTR3030
65User_Defined_Prompt25 SearchUser Defined Prompt25StringSTR3030
66User_Defined_Prompt26 SearchUser Defined Prompt26StringSTR3030
67User_Defined_Prompt27 SearchUser Defined Prompt27StringSTR3030
68User_Defined_Prompt28 SearchUser Defined Prompt28StringSTR3030
69User_Defined_Prompt29 SearchUser Defined Prompt29StringSTR3030
70User_Defined_Prompt30 SearchUser Defined Prompt30StringSTR3030
71User_Defined_Prompt31 SearchUser Defined Prompt31StringSTR3030
72User_Defined_Prompt32 SearchUser Defined Prompt32StringSTR3030
73User_Defined_Prompt33 SearchUser Defined Prompt33StringSTR3030
74User_Defined_Prompt34 SearchUser Defined Prompt34StringSTR3030
75User_Defined_Prompt35 SearchUser Defined Prompt35StringSTR3030
76FreightTaxSchedNoteIdx SearchFreight Tax Schedule Note IndexCurrencyDLR1414
77MiscTaxSchedNoteIdx SearchMisc Tax Schedule Note IndexCurrencyDLR1414
78NonIVTaxSchedNoteIdx SearchNon IV Tax Schedule Note IndexCurrencyDLR1414
79SingleTaxSchedNoteIdx SearchSingle Tax Schedule Note IndexCurrencyDLR1414
80ReplenishmentLevel SearchReplenishment LevelIntegerDDL_ReplenishmentLevel0
81POPOrderMethod SearchPOP Order MethodIntegerDDL_POP_OrderMethod0
82MasterLocationCode SearchMaster Location CodeStringSTR10_Location_Code10
83POPVendorSelection SearchPOP Vendor SelectionIntegerDDL_POP_VendorSelection0
84POPPricingSelection SearchPOP Pricing SelectionIntegerDDL_POP_PriceSelection0
85IncludeAllocations SearchInclude AllocationsBooleanCB_IncludeAllocations0
86IncludeBackorders SearchInclude BackordersBooleanCB_IncludeBackorders0
87IncludeRequisitions SearchInclude RequisitionsBooleanCB_IncludeRequisitions0
88RETORIGTAX SearchReturn Original TaxesBooleanCB_ReturnOriginalTaxes0
89ONEPOPERADDR SearchCreate One PO Per AddressBooleanCB_CreateOnePOPerAddress0
90CALCRELDT SearchCalc Release By Date Using Vendors LeadBooleanCB_CalcReleaseByDateUsingVendorsLead0
91Default_Document_Date SearchDefault Document DateIntegerDDL_Default_Date0
92UseQtyOverageTolerance SearchUse Qty Overage ToleranceBooleanCB0
93UseQtyShortageTolerance SearchUse Qty Shortage ToleranceBooleanCB0
94QtyOverTolerancePercent SearchQty Overage Tolerance PercentageLong IntegerLI5_%35
95QtyShortTolerancePercent SearchQty Shortage Tolerance PercentageLong IntegerLI5_%35
96AllowPOPrepayments SearchAllow Purchase Order PrepaymentsBooleanCB_AllowPurchaseOrderPrepayments0
97CreateManualPrepayment SearchCreate Manual PrepaymentBooleanCB0
98PrepaymentPassword SearchPrepayment PasswordStringPassword10
99PrepaymentAccountIndex SearchPrepayment Account IndexLong IntegerLI_1414
100RequisitionCode SearchRequisition CodeStringSTR33
101POPRequisitionNumber SearchPOP Requisition NumberStringSTR17_POP_Number17
102RequisitionMaintainHist SearchRequisition Maintain HistoryBooleanBoolean0
103RequisitionDefDocDate SearchRequisition Default Doc DateIntegerDDL_Default_Date0
104RequisitionDefSiteMethod SearchRequisition Default Site MethodIntegerDDL_Default_Site0
105RequisitionVendorSelect SearchRequisition Vendor SelectionIntegerDDL_POP_VendorSelection0
106RequisitionCostSelection SearchRequisition Cost SelectionIntegerDDL_POP_PriceSelection0
107ReqCreateOnePOPerAddress SearchRequisition Create One PO Per AddressBooleanCB_CreateOnePOPerAddress0
108ReqTransferLineComments SearchRequisition Transfer Line CommentsBooleanCB_TransferLineCommentsFromReq0
109SearchPOQtysFromRequisit SearchSearchPOQtysFromRequisitionBooleanCB_SearchForUncommitedPOQtys0
110Req_Hdr_UD_Prompt1 SearchReq Hdr User Defined Prompt 1StringSTR1515
111Req_Hdr_UD_Prompt2 SearchReq Hdr User Defined Prompt 2StringSTR1515
112Req_Line_UD_Prompt1 SearchReq Line User Defined Prompt 1StringSTR1515
113Req_Line_UD_Prompt2 SearchReq Line User Defined Prompt 2StringSTR1515
114GeneratePOMessageOption SearchGenerate PO Message OptionIntegerDDL_Generate_PO_Message0

Leave a Reply

Your email address will not be published. Required fields are marked *