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