Purchase_Order_SETP_File (PO40100)

azurecurveProductsWennSoft Products (131)PurchasingPurchase_Order_SETP_File (PO40100)

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_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1UNITTOLERANCE SearchPO_Restrict_Over_Receiving_CBPO_Restrict_Over_Receiving_CBBoolean20
2UNITTOLERANCELEVEL SearchPO_Restrict_Over_Receiving_Percent_DOLDLR5_%2Currency108
3tiUpdateIVOnDropShip SearchPO_Update_IV_On_Drop_Ship_CBPO_Update_IV_On_Drop_Ship_CBBoolean20
4KEYINT SearchKey_INTINT1Integer21
5Always_Use_Base_Unit SearchAlways_Use_Base_Unit_CBAlways_Use_Base_UnitBoolean20
6Next_Purchase_Order_Temp SearchNext_Purchase_Order_Template_STRSTR17_LBAUString1817
7LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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'].LOCNCODE
8NTREQNUM SearchNext_Requisition_Number_STRSTR17_LBAUString1817
9NTPONUM SearchNext_Purchase_Order_Number_STRSTR17_LBAUString1817
10NTRECNUM SearchNext_Receivings_Number_STRSTR17_LBAUString1817
11ALLOWNOPO SearchAllow_No_PO_Receivings_CBAllow_No_PO_Receivings_CBBoolean20
12SUPREQPRC SearchSuppress_Requisition_Prices_Status_CBSurpress_Requisition_Prices_Status_CBBoolean20
13USECOM SearchUse_Commitment_Accounting_CBCB_Use_Commitment_AccountingBoolean20
14DEFPURACCACCT SearchDefault_Purchases_Accrual_Account_Index_LILI_14Long Integer414
15DEFPURACCT SearchDefault_Purchases_Account_Index_LILI_14Long Integer414
16PPVAccount SearchPurchase_Price_Var_Account_Index_LILI_14Long Integer414
17SHIPMTHID SearchShipping_Method_ID_STRSTR20_LBAUString2220
18DELTOID SearchDelivery_To_ID_STRSTR20_LBAUString2220
19SHPTOID SearchShipment_To_ID_STRSTR20_LBAUString2220
20PO_Standard_Cost_CB SearchPO_Standard_Cost_CBPO_Standard_Cost_CBBoolean20
21USRDEFND1 SearchUser_Defined_1_STRSTR15String1615
22USRDEFND2 SearchUser_Defined_2_STRSTR10String1210
23USRDEFND3 SearchUser_Defined_3_STRSTR10String1210
24USRDEFND4 SearchUser_Defined_4_STRSTR10String1210
25DFBN SearchDefault_Batch_NumberLI_14Long Integer414
26Allow_Accrual_Of_Non_IV_C SearchAllow_Accrual_Of_Non_IV_CBAllow_Accrual_Of_Non_IV_CBBoolean20
27Default_NS_Account_From_S SearchDefault_NS_Account_From_SupplierDefault_NS_Account_From_SupplierBoolean20
28Integrate_To_WennSoft_Jo SearchIntegrate_To_Wenn/Soft_Job_Cost_CBIntegrate_To_Wenn/Soft_Job_Cost_CBBoolean20
29Use_Line_Numbering_On_PO_ SearchUse_Line_Numbering_On_PO_CBUse_Line_Numbering_On_PO_CBBoolean20
30Post_Through_Inventory_CB SearchPost_Through_Inventory_CBPost_Through_Inventory_CBBoolean20
31Use_Vendor_Specific_Looku SearchUse_Vendor_Specific_LookupsUse_Vendor_Specific_LookupsBoolean20
32PO_Use_PPV_Only_CB SearchPO_Use_PPV_Only_CBPO_Use_PPV_Only_CBBoolean20
33PO_Commitments_YTD_Basis SearchPO_Commitments_YTD_Basis_CBPO_Commitments_YTD_Basis_CBBoolean20
34Use_Inventory_Module SearchUse_Inventory_ModuleUse_Inventory_ModuleBoolean20
35DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
36Use_VAT_Taxes SearchUse_VAT_TaxesUse_VAT_TaxesBoolean20
37PASSWORD SearchPasswordSTR15_LBString1615
38POOVERRECEIPTLEVEL SearchPO_Overreceipt_Tolerance_LevelDLR5_%2Currency108
39DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
40PO_Allow_Over_Receipting SearchPO_Allow_Over_ReceiptingPO_Allow_Over_ReceiptingBoolean20
41PO_Suppress_Costs_Receivi SearchPO_Suppress_Costs_ReceivingPO_Suppress_Costs_ReceivingBoolean20
42Use_Certification_Numbers SearchUse_Certification_NumbersUse_Certification_NumbersBoolean20
43PO_Commitment_Use_PO_Dat SearchPO_Commitment_Use_PO_DatePO_Commitment_Use_PO_Date_CBBoolean20
44PO_Use_Approval_Process SearchPO_Use_Approval_ProcessPO_Use_Approval_Process_CBBoolean20
45PO_Post_Thru_Payables SearchPO_Post_Thru_PayablesPO_Post_Thru_PayablesBoolean20
46QTY_Invoice_Autofill_CB SearchQTY_Invoice_Autofill_CBQTY_Invoice_Autofill_CBBoolean20
47INTLRSVCB1 SearchINTL_RSV_CB_1CBBoolean20
48INTLRSVCB2 SearchINTL_RSV_CB_2CBBoolean20
49INTLRSVCB3 SearchINTL_RSV_CB_3CBBoolean20
50INTLRSVCB4 SearchINTL_RSV_CB_4CBBoolean20
51INTLRSVCB5 SearchINTL_RSV_CB_5CBBoolean20
52INTLRSVCB6 SearchINTL_RSV_CB_6CBBoolean20
azurecurveProductsWennSoft Products (131)PurchasingPurchase_Order_SETP_File (PO40100)

Leave a Reply

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