Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO40100
Product: WennSoft Products (131)
Series: Purchasing
Display Name: Purchase_Order_SETP_File
Physical Name: PO40100
Technical Name: Purchase_Order_SETP_FileSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UNITTOLERANCE 
PO_Restrict_Over_Receiving_CB PO_Restrict_Over_Receiving_CB Boolean 0 2 UNITTOLERANCELEVEL PO_Restrict_Over_Receiving_Percent_DOL DLR5_%2 Currency 8 3 tiUpdateIVOnDropShip PO_Update_IV_On_Drop_Ship_CB PO_Update_IV_On_Drop_Ship_CB Boolean 0 4 KEYINT Key_INT INT1 Integer 1 5 Always_Use_Base_Unit Always_Use_Base_Unit_CB Always_Use_Base_Unit Boolean 0 6 Next_Purchase_Order_Temp Next_Purchase_Order_Template_STR STR17_LBAU String 17 7 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Purchase_Order_SETP_File'].LOCNCODE AS 'Purchase_Order_SETP_File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
PO40100 AS ['Purchase_Order_SETP_File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Purchase_Order_SETP_File'].LOCNCODE = ['Site Setup'].LOCNCODE8 NTREQNUM Next_Requisition_Number_STR STR17_LBAU String 17 9 NTPONUM Next_Purchase_Order_Number_STR STR17_LBAU String 17 10 NTRECNUM Next_Receivings_Number_STR STR17_LBAU String 17 11 ALLOWNOPO Allow_No_PO_Receivings_CB Allow_No_PO_Receivings_CB Boolean 0 12 SUPREQPRC Suppress_Requisition_Prices_Status_CB Surpress_Requisition_Prices_Status_CB Boolean 0 13 USECOM Use_Commitment_Accounting_CB CB_Use_Commitment_Accounting Boolean 0 14 DEFPURACCACCT Default_Purchases_Accrual_Account_Index_LI LI_14 Long Integer 14 15 DEFPURACCT Default_Purchases_Account_Index_LI LI_14 Long Integer 14 16 PPVAccount Purchase_Price_Var_Account_Index_LI LI_14 Long Integer 14 17 SHIPMTHID Shipping_Method_ID_STR STR20_LBAU String 20 18 DELTOID Delivery_To_ID_STR STR20_LBAU String 20 19 SHPTOID Shipment_To_ID_STR STR20_LBAU String 20 20 PO_Standard_Cost_CB PO_Standard_Cost_CB PO_Standard_Cost_CB Boolean 0 21 USRDEFND1 User_Defined_1_STR STR15 String 15 22 USRDEFND2 User_Defined_2_STR STR10 String 10 23 USRDEFND3 User_Defined_3_STR STR10 String 10 24 USRDEFND4 User_Defined_4_STR STR10 String 10 25 DFBN Default_Batch_Number LI_14 Long Integer 14 26 Allow_Accrual_Of_Non_IV_C Allow_Accrual_Of_Non_IV_CB Allow_Accrual_Of_Non_IV_CB Boolean 0 27 Default_NS_Account_From_S Default_NS_Account_From_Supplier Default_NS_Account_From_Supplier Boolean 0 28 Integrate_To_WennSoft_Jo Integrate_To_Wenn/Soft_Job_Cost_CB Integrate_To_Wenn/Soft_Job_Cost_CB Boolean 0 29 Use_Line_Numbering_On_PO_ Use_Line_Numbering_On_PO_CB Use_Line_Numbering_On_PO_CB Boolean 0 30 Post_Through_Inventory_CB Post_Through_Inventory_CB Post_Through_Inventory_CB Boolean 0 31 Use_Vendor_Specific_Looku Use_Vendor_Specific_Lookups Use_Vendor_Specific_Lookups Boolean 0 32 PO_Use_PPV_Only_CB PO_Use_PPV_Only_CB PO_Use_PPV_Only_CB Boolean 0 33 PO_Commitments_YTD_Basis PO_Commitments_YTD_Basis_CB PO_Commitments_YTD_Basis_CB Boolean 0 34 Use_Inventory_Module Use_Inventory_Module Use_Inventory_Module Boolean 0 35 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 36 Use_VAT_Taxes Use_VAT_Taxes Use_VAT_Taxes Boolean 0 37 PASSWORD Password STR15_LB String 15 38 POOVERRECEIPTLEVEL PO_Overreceipt_Tolerance_Level DLR5_%2 Currency 8 39 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 0 40 PO_Allow_Over_Receipting PO_Allow_Over_Receipting PO_Allow_Over_Receipting Boolean 0 41 PO_Suppress_Costs_Receivi PO_Suppress_Costs_Receiving PO_Suppress_Costs_Receiving Boolean 0 42 Use_Certification_Numbers Use_Certification_Numbers Use_Certification_Numbers Boolean 0 43 PO_Commitment_Use_PO_Dat PO_Commitment_Use_PO_Date PO_Commitment_Use_PO_Date_CB Boolean 0 44 PO_Use_Approval_Process PO_Use_Approval_Process PO_Use_Approval_Process_CB Boolean 0 45 PO_Post_Thru_Payables PO_Post_Thru_Payables PO_Post_Thru_Payables Boolean 0 46 QTY_Invoice_Autofill_CB QTY_Invoice_Autofill_CB QTY_Invoice_Autofill_CB Boolean 0 47 INTLRSVCB1 INTL_RSV_CB_1 CB Boolean 0 48 INTLRSVCB2 INTL_RSV_CB_2 CB Boolean 0 49 INTLRSVCB3 INTL_RSV_CB_3 CB Boolean 0 50 INTLRSVCB4 INTL_RSV_CB_4 CB Boolean 0 51 INTLRSVCB5 INTL_RSV_CB_5 CB Boolean 0 52 INTLRSVCB6 INTL_RSV_CB_6 CB Boolean 0