General

General

Company

Tenant is the highest level of an independent business entity. Each Tenant will have one or more Organizations reporting to it.

Table Name DB Field Name Super Store Work Edition
AD_Client AD_Client_ID HIDDEN Adempiere 3.7
AD_Client AD_Language DEFAULT Adempiere 3.7
AD_Client AD_Org_ID HIDDEN Adempiere 3.7
AD_Client AD_ReplicationStrategy_ID HIDDEN Adempiere 3.7
AD_Client AutoArchive DEFAULT Adempiere 3.7
AD_Client Created HIDDEN Adempiere 3.7
AD_Client CreatedBy HIDDEN Adempiere 3.7
AD_Client Description DEFAULT Adempiere 3.7
AD_Client DocumentDir HIDDEN Adempiere 3.7
AD_Client EMailTest DEFAULT Adempiere 3.7
AD_Client IsActive DEFAULT Adempiere 3.7
AD_Client IsCostImmediate HIDDEN Adempiere 3.7
AD_Client IsMultiLingualDocument HIDDEN Adempiere 3.7
AD_Client IsPostImmediate HIDDEN Adempiere 3.7
AD_Client IsServerEMail DEFAULT Adempiere 3.7
AD_Client IsSmtpAuthorization DEFAULT Adempiere 3.7
AD_Client IsUseASP HIDDEN Adempiere 3.7
AD_Client IsUseBetaFunctions HIDDEN Adempiere 3.7
AD_Client MMPolicy DEFAULT Adempiere 3.7
AD_Client ModelValidationClasses HIDDEN Adempiere 3.7
AD_Client Name DEFAULT Adempiere 3.7
AD_Client RequestEMail DEFAULT Adempiere 3.7
AD_Client RequestFolder DEFAULT Adempiere 3.7
AD_Client RequestUser DEFAULT Adempiere 3.7
AD_Client RequestUserPW DEFAULT Adempiere 3.7
AD_Client SMTPHost DEFAULT Adempiere 3.7
AD_Client StoreArchiveOnFileSystem ADDED Adempiere 3.7
AD_Client StoreAttachmentsOnFileSystem ADDED Adempiere 3.7
AD_Client UM_IsOnline ADDED Adempiere 3.7
AD_Client UnixArchivePath ADDED Adempiere 3.7
AD_Client UnixAttachmentPath ADDED Adempiere 3.7
AD_Client Updated HIDDEN Adempiere 3.7
AD_Client UpdatedBy HIDDEN Adempiere 3.7
AD_Client Value DEFAULT Adempiere 3.7
AD_Client WindowsArchivePath ADDED Adempiere 3.7
AD_Client WindowsAttachmentPath ADDED Adempiere 3.7
AD_ClientInfo AD_Client_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Org_ID HIDDEN Adempiere 3.7
AD_ClientInfo AD_Tree_Activity_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_BPartner_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_Campaign_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_Menu_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_Org_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_Product_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_Project_ID DEFAULT Adempiere 3.7
AD_ClientInfo AD_Tree_SalesRegion_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_AcctSchema1_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_BPartnerCashTrx_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_Calendar_ID DEFAULT Adempiere 3.7
AD_ClientInfo Created HIDDEN Adempiere 3.7
AD_ClientInfo CreatedBy HIDDEN Adempiere 3.7
AD_ClientInfo C_UOM_Length_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_UOM_Time_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_UOM_Volume_ID DEFAULT Adempiere 3.7
AD_ClientInfo C_UOM_Weight_ID DEFAULT Adempiere 3.7
AD_ClientInfo IsActive DEFAULT Adempiere 3.7
AD_ClientInfo IsDiscountLineAmt DEFAULT Adempiere 3.7
AD_ClientInfo KeepLogDays DEFAULT Adempiere 3.7
AD_ClientInfo Logo_ID DEFAULT Adempiere 3.7
AD_ClientInfo LogoReport_ID DEFAULT Adempiere 3.7
AD_ClientInfo LogoWeb_ID DEFAULT Adempiere 3.7
AD_ClientInfo M_ProductFreight_ID HIDDEN Adempiere 3.7
AD_ClientInfo Updated HIDDEN Adempiere 3.7
AD_ClientInfo UpdatedBy HIDDEN Adempiere 3.7

 

Branch

The Organization allows you to define and maintain Organizational entities. An Organization is often a legal entity or sub-unit for which documents and transactions are processed.

Table Name DB Field Name Super Store Work Edition
AD_Org AD_Client_ID DEFAULT Adempiere 3.7
AD_Org AD_Org_ID HIDDEN Adempiere 3.7
AD_Org AD_ReplicationStrategy_ID Adempiere 3.7
AD_Org Created HIDDEN Adempiere 3.7
AD_Org CreatedBy HIDDEN Adempiere 3.7
AD_Org Description DEFAULT Adempiere 3.7
AD_Org IsActive DEFAULT Adempiere 3.7
AD_Org IsSummary Adempiere 3.7
AD_Org Name DEFAULT Adempiere 3.7
AD_Org UM_LDBName ADDED Adempiere 3.7
AD_Org UM_LocalHost ADDED Adempiere 3.7
AD_Org UM_LocatorGodown_ID ADDED Adempiere 3.7
AD_Org UM_LocatorInTransit_ID ADDED Adempiere 3.7
AD_Org UM_LocatorSFloor_ID ADDED Adempiere 3.7
AD_Org UM_LUName ADDED Adempiere 3.7
AD_Org UM_LUPasswd ADDED Adempiere 3.7
AD_Org UM_Port ADDED Adempiere 3.7
AD_Org UM_SDBName ADDED Adempiere 3.7
AD_Org UM_SellingPriceRoundOff ADDED Adempiere 3.7
AD_Org UM_ServerHost ADDED Adempiere 3.7
AD_Org UM_SUName ADDED Adempiere 3.7
AD_Org UM_SUPasswd ADDED Adempiere 3.7
AD_Org UM_WSPRoundOff ADDED Adempiere 3.7
AD_Org Updated HIDDEN Adempiere 3.7
AD_Org UpdatedBy HIDDEN Adempiere 3.7
AD_Org Value DEFAULT Adempiere 3.7

 

Branch – Org Info

This tab helps users to configure the list of features, configurations that will be used by the entire ERP during different transactions.

Table Name DB Field Name Super Store Work Edition
AD_OrgInfo AD_Client_ID DEFAULT Adempiere 3.7
AD_OrgInfo AD_Org_ID DEFAULT Adempiere 3.7
AD_OrgInfo AD_OrgType_ID DEFAULT Adempiere 3.7
AD_OrgInfo C_BPartner_ID DEFAULT Adempiere 3.7
AD_OrgInfo C_Calendar_ID DEFAULT Adempiere 3.7
AD_OrgInfo C_Location_ID DEFAULT Adempiere 3.7
AD_OrgInfo Created HIDDEN Adempiere 3.7
AD_OrgInfo CreatedBy HIDDEN Adempiere 3.7
AD_OrgInfo DropShip_Warehouse_ID DEFAULT Adempiere 3.7
AD_OrgInfo DUNS HIDDEN Adempiere 3.7
AD_OrgInfo EMail DEFAULT Adempiere 3.7
AD_OrgInfo Fax DEFAULT Adempiere 3.7
AD_OrgInfo IsActive DEFAULT Adempiere 3.7
AD_OrgInfo IsFoodCourt ADDED Adempiere 3.7
AD_OrgInfo Logo_ID DEFAULT Adempiere 3.7
AD_OrgInfo M_AttributeSetInstance_ID ADDED Adempiere 3.7
AD_OrgInfo M_PriceList_ID ADDED Adempiere 3.7
AD_OrgInfo M_PriceList_Version_ID ADDED Adempiere 3.7
AD_OrgInfo M_Warehouse_ID ADDED Adempiere 3.7
AD_OrgInfo PA_Goal_ID HIDDEN Adempiere 3.7
AD_OrgInfo Parent_Org_ID HIDDEN Adempiere 3.7
AD_OrgInfo Phone DEFAULT Adempiere 3.7
AD_OrgInfo Phone2 HIDDEN Adempiere 3.7
AD_OrgInfo ReceiptFooterMsg ADDED Adempiere 3.7
AD_OrgInfo Supervisor_ID DEFAULT Adempiere 3.7
AD_OrgInfo TaxID ADDED Adempiere 3.7
AD_OrgInfo TransferBank_ID DEFAULT Adempiere 3.7
AD_OrgInfo TransferCashBook_ID DEFAULT Adempiere 3.7
AD_OrgInfo UM_BackOfficeQTYLimit ADDED Adempiere 3.7
AD_OrgInfo UM_BarcodeTitle ADDED Adempiere 3.7
AD_OrgInfo UM_BonusPointAlertMsg ADDED Adempiere 3.7
AD_OrgInfo UM_BonusPoints ADDED Adempiere 3.7
AD_OrgInfo UM_CouponDiffRange ADDED Adempiere 3.7
AD_OrgInfo UM_EMailAddress HIDDEN Adempiere 3.7
AD_OrgInfo UM_FTPLocation ADDED Adempiere 3.7
AD_OrgInfo UM_FTPPassword ADDED Adempiere 3.7
AD_OrgInfo UM_FTPServer ADDED Adempiere 3.7
AD_OrgInfo UM_FTPUserName ADDED Adempiere 3.7
AD_OrgInfo UM_GTINNo ADDED Adempiere 3.7
AD_OrgInfo UM_HSNDigits ADDED Adempiere 3.7
AD_OrgInfo UM_IsAdvancePromotion ADDED Adempiere 3.7
AD_OrgInfo UM_IsAllowPartialRedeem ADDED Adempiere 3.7
AD_OrgInfo UM_IsAutoMRPUpdate ADDED Adempiere 3.7
AD_OrgInfo UM_IsBillWisePromo ADDED Adempiere 3.7
AD_OrgInfo UM_IsBonusPoints ADDED Adempiere 3.7
AD_OrgInfo UM_IsCouponPromo ADDED Adempiere 3.7
AD_OrgInfo UM_IsCreditOrderPrintCopies ADDED Adempiere 3.7
AD_OrgInfo UM_IsCreditSalesDiscount ADDED Adempiere 3.7
AD_OrgInfo UM_IsCrossPromotion ADDED Adempiere 3.7
AD_OrgInfo UM_IsCustomerMandatory ADDED Adempiere 3.7
AD_OrgInfo UM_IsECommerceIntegration ADDED Adempiere 3.7
AD_OrgInfo UM_IsFreeItemPromo ADDED Adempiere 3.7
AD_OrgInfo UM_IsFTPEnabled ADDED Adempiere 3.7
AD_OrgInfo UM_IsGenInvoiceManual HIDDEN Adempiere 3.7
AD_OrgInfo UM_IsGKMRequired ADDED Adempiere 3.7
AD_OrgInfo UM_IsGST ADDED Adempiere 3.7
AD_OrgInfo UM_IsPODateValidation ADDED Adempiere 3.7
AD_OrgInfo UM_IsProductApproval ADDED Adempiere 3.7
AD_OrgInfo UM_IsPromotionPrice ADDED Adempiere 3.7
AD_OrgInfo UM_IsReceivePOOnly ADDED Adempiere 3.7
AD_OrgInfo um_isterminalwisedocsequence ADDED Adempiere 3.7
AD_OrgInfo UM_IsTPFileTransfer ADDED Adempiere 3.7
AD_OrgInfo UM_IsVoidInvoice ADDED Adempiere 3.7
AD_OrgInfo UM_MRPMargin ADDED Adempiere 3.7
AD_OrgInfo UM_NoOfPrintCopies ADDED Adempiere 3.7
AD_OrgInfo UM_OTP ADDED Adempiere 3.7
AD_OrgInfo um_otp_host ADDED Adempiere 3.7
AD_OrgInfo UM_OTPLength ADDED Adempiere 3.7
AD_OrgInfo UM_OTPMsg ADDED Adempiere 3.7
AD_OrgInfo um_otp_port ADDED Adempiere 3.7
AD_OrgInfo UM_OTPValidityMin ADDED Adempiere 3.7
AD_OrgInfo UM_Password ADDED Adempiere 3.7
AD_OrgInfo UM_Phone ADDED Adempiere 3.7
AD_OrgInfo UM_POEmailAddress ADDED Adempiere 3.7
AD_OrgInfo UM_POEmailMessage ADDED Adempiere 3.7
AD_OrgInfo UM_PORemarks ADDED Adempiere 3.7
AD_OrgInfo UM_SellingQtyLimit ADDED Adempiere 3.7
AD_OrgInfo UM_Sender ADDED Adempiere 3.7
AD_OrgInfo UM_SMSIsActive ADDED Adempiere 3.7
AD_OrgInfo UM_SMSURL ADDED Adempiere 3.7
AD_OrgInfo UM_TPFileLocation ADDED Adempiere 3.7
AD_OrgInfo UM_TransactionURL ADDED Adempiere 3.7
AD_OrgInfo UM_UpdateGKM ADDED Adempiere 3.7
AD_OrgInfo UM_UserName ADDED Adempiere 3.7
AD_OrgInfo UM_ValidateBillDate ADDED Adempiere 3.7
AD_OrgInfo UM_VoucherValidDays ADDED Adempiere 3.7
AD_OrgInfo Updated HIDDEN Adempiere 3.7
AD_OrgInfo UpdatedBy HIDDEN Adempiere 3.7

 

Branch – Color Config

Using this tab users can configure the Point of Sale button, background, Text Colors based on needs

Table Name DB Field Name Super Store Work Edition
UM_ColorConfig AD_Client_ID DEFAULT Adempiere 3.7
UM_ColorConfig AD_Org_ID DEFAULT Adempiere 3.7
UM_ColorConfig Created HIDDEN Adempiere 3.7
UM_ColorConfig CreatedBy HIDDEN Adempiere 3.7
UM_ColorConfig IsActive HIDDEN Adempiere 3.7
UM_ColorConfig Logo_ID ADDED Adempiere 3.7
UM_ColorConfig UM_ColorConfig_ID HIDDEN Adempiere 3.7
UM_ColorConfig UM_FormBGColor ADDED Adempiere 3.7
UM_ColorConfig UM_POSBGColor ADDED Adempiere 3.7
UM_ColorConfig UM_POSBTColor ADDED Adempiere 3.7
UM_ColorConfig UM_POSBTDisableColor ADDED Adempiere 3.7
UM_ColorConfig UM_POSBTSelectionColor ADDED Adempiere 3.7
UM_ColorConfig UM_POSTitle HIDDEN Adempiere 3.7
UM_ColorConfig UM_SelectBGColor ADDED Adempiere 3.7
UM_ColorConfig UM_SelectBTColor ADDED Adempiere 3.7
UM_ColorConfig UM_SelectBTDisableColor ADDED Adempiere 3.7
UM_ColorConfig UM_SelectBTSelectionColor ADDED Adempiere 3.7
UM_ColorConfig UM_SelectFormBGColor ADDED Adempiere 3.7
UM_ColorConfig Updated HIDDEN Adempiere 3.7
UM_ColorConfig UpdatedBy HIDDEN Adempiere 3.7

 

Branch – Web Service API Config

This tab should be used for configuring Textiles Software Alpose Gift Card API URLs and its credentials. Based on this information, Gift Card redemption happens in the Point of Sale.

Table Name DB Field Name Super Store Work Edition
UM_WebServiceAPIConfig AD_Client_ID DEFAULT Adempiere 3.7
UM_WebServiceAPIConfig AD_Org_ID DEFAULT Adempiere 3.7
UM_WebServiceAPIConfig Created HIDDEN Adempiere 3.7
UM_WebServiceAPIConfig CreatedBy HIDDEN Adempiere 3.7
UM_WebServiceAPIConfig DB ADDED Adempiere 3.7
UM_WebServiceAPIConfig IsActive DEFAULT Adempiere 3.7
UM_WebServiceAPIConfig Password ADDED Adempiere 3.7
UM_WebServiceAPIConfig UM_LoginURL ADDED Adempiere 3.7
UM_WebServiceAPIConfig UM_RedeemURL ADDED Adempiere 3.7
UM_WebServiceAPIConfig UM_SearchURL ADDED Adempiere 3.7
UM_WebServiceAPIConfig Updated HIDDEN Adempiere 3.7
UM_WebServiceAPIConfig UpdatedBy HIDDEN Adempiere 3.7
UM_WebServiceAPIConfig UserName ADDED Adempiere 3.7

 

Branch – Paytm Web Service Config

This tab should be used for configuring Paytm Web Service API details and its credentials. This will be used by the Point of Sale during POS payment using Paytm.

Table Name DB Field Name Super Store Work Edition
UM_PaytmWebServiceConfig AD_Client_ID DEFAULT Adempiere 3.7
UM_PaytmWebServiceConfig AD_Org_ID DEFAULT Adempiere 3.7
UM_PaytmWebServiceConfig Created HIDDEN Adempiere 3.7
UM_PaytmWebServiceConfig CreatedBy HIDDEN Adempiere 3.7
UM_PaytmWebServiceConfig IsActive DEFAULT Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmMerchantGUID ADDED Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmMerchantID ADDED Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmMerchantKey ADDED Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmTransCheckURL ADDED Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmURL ADDED Adempiere 3.7
UM_PaytmWebServiceConfig UM_PaytmWebServiceConfig_ID HIDDEN Adempiere 3.7
UM_PaytmWebServiceConfig Updated HIDDEN Adempiere 3.7
UM_PaytmWebServiceConfig UpdatedBy HIDDEN Adempiere 3.7

 

Employee

Employee screen should be used for configuring the Employee details of a Company like Name, Address, Contact Info.

Table Name DB Field Name Super Store Work Edition
C_BPartner AcqusitionCost Adempiere 3.7
C_BPartner ActualLifeTimeValue Adempiere 3.7
C_BPartner AD_Client_ID DEFAULT Adempiere 3.7
C_BPartner AD_Language HIDDEN Adempiere 3.7
C_BPartner AD_OrgBP_ID HIDDEN Adempiere 3.7
C_BPartner AD_Org_ID DEFAULT Adempiere 3.7
C_BPartner BPartner_Parent_ID HIDDEN Adempiere 3.7
C_BPartner C_BPartner_ID HIDDEN Adempiere 3.7
C_BPartner C_BP_Group_ID HIDDEN Adempiere 3.7
C_BPartner C_Dunning_ID HIDDEN Adempiere 3.7
C_BPartner C_Greeting_ID HIDDEN Adempiere 3.7
C_BPartner C_InvoiceSchedule_ID HIDDEN Adempiere 3.7
C_BPartner C_Location_ID HIDDEN Adempiere 3.7
C_BPartner C_PaymentTerm_ID HIDDEN Adempiere 3.7
C_BPartner Created HIDDEN Adempiere 3.7
C_BPartner CreatedBy HIDDEN Adempiere 3.7
C_BPartner C_TaxGroup_ID HIDDEN Adempiere 3.7
C_BPartner DeliveryRule HIDDEN Adempiere 3.7
C_BPartner DeliveryViaRule HIDDEN Adempiere 3.7
C_BPartner Description HIDDEN Adempiere 3.7
C_BPartner DocumentCopies HIDDEN Adempiere 3.7
C_BPartner DunningGrace HIDDEN Adempiere 3.7
C_BPartner DUNS HIDDEN Adempiere 3.7
C_BPartner FirstSale HIDDEN Adempiere 3.7
C_BPartner FlatDiscount HIDDEN Adempiere 3.7
C_BPartner FreightCostRule HIDDEN Adempiere 3.7
C_BPartner Invoice_PrintFormat_ID HIDDEN Adempiere 3.7
C_BPartner InvoiceRule HIDDEN Adempiere 3.7
C_BPartner IsActive DEFAULT Adempiere 3.7
C_BPartner IsCustomer HIDDEN Adempiere 3.7
C_BPartner IsDiscountPrinted HIDDEN Adempiere 3.7
C_BPartner IsEmployee DEFAULT Adempiere 3.7
C_BPartner IsManufacturer HIDDEN Adempiere 3.7
C_BPartner IsOneTime HIDDEN Adempiere 3.7
C_BPartner IsPOTaxExempt HIDDEN Adempiere 3.7
C_BPartner IsProspect HIDDEN Adempiere 3.7
C_BPartner IsSalesRep HIDDEN Adempiere 3.7
C_BPartner IsSOTrx HIDDEN Adempiere 3.7
C_BPartner IsSummary HIDDEN Adempiere 3.7
C_BPartner IsTaxExempt HIDDEN Adempiere 3.7
C_BPartner IsVendor HIDDEN Adempiere 3.7
C_BPartner Logo_ID HIDDEN Adempiere 3.7
C_BPartner M_DiscountSchema_ID HIDDEN Adempiere 3.7
C_BPartner M_PriceList_ID HIDDEN Adempiere 3.7
C_BPartner NAICS HIDDEN Adempiere 3.7
C_BPartner Name DEFAULT Adempiere 3.7
C_BPartner Name2 HIDDEN Adempiere 3.7
C_BPartner NumberEmployees HIDDEN Adempiere 3.7
C_BPartner PaymentRule HIDDEN Adempiere 3.7
C_BPartner PaymentRulePO HIDDEN Adempiere 3.7
C_BPartner PO_DiscountSchema_ID HIDDEN Adempiere 3.7
C_BPartner PO_PaymentTerm_ID HIDDEN Adempiere 3.7
C_BPartner PO_PriceList_ID HIDDEN Adempiere 3.7
C_BPartner POReference HIDDEN Adempiere 3.7
C_BPartner PotentialLifeTimeValue HIDDEN Adempiere 3.7
C_BPartner Processed HIDDEN Adempiere 3.7
C_BPartner Rating HIDDEN Adempiere 3.7
C_BPartner ReferenceNo HIDDEN Adempiere 3.7
C_BPartner SalesRep_ID HIDDEN Adempiere 3.7
C_BPartner SalesVolume HIDDEN Adempiere 3.7
C_BPartner SendEMail HIDDEN Adempiere 3.7
C_BPartner ShareOfCustomer HIDDEN Adempiere 3.7
C_BPartner ShelfLifeMinPct HIDDEN Adempiere 3.7
C_BPartner SO_CreditLimit HIDDEN Adempiere 3.7
C_BPartner SOCreditStatus HIDDEN Adempiere 3.7
C_BPartner SO_CreditUsed HIDDEN Adempiere 3.7
C_BPartner SO_Description HIDDEN Adempiere 3.7
C_BPartner TaxID HIDDEN Adempiere 3.7
C_BPartner TotalOpenBalance HIDDEN Adempiere 3.7
C_BPartner UM_CardNo HIDDEN Adempiere 3.7
C_BPartner UM_CreditAvailable HIDDEN Adempiere 3.7
C_BPartner UM_CreditDays HIDDEN Adempiere 3.7
C_BPartner UM_CSTCode HIDDEN Adempiere 3.7
C_BPartner UM_CurrentYearPoint HIDDEN Adempiere 3.7
C_BPartner UM_EmpCommission_No ADDED Adempiere 3.7
C_BPartner UM_ExpDate HIDDEN Adempiere 3.7
C_BPartner UM_GSTinNo HIDDEN Adempiere 3.7
C_BPartner UM_IsCForm HIDDEN Adempiere 3.7
C_BPartner UM_IsGST HIDDEN Adempiere 3.7
C_BPartner UM_IsInstitutional HIDDEN Adempiere 3.7
C_BPartner UM_IsLastYearRedeemed HIDDEN Adempiere 3.7
C_BPartner UM_IsOtherState HIDDEN Adempiere 3.7
C_BPartner UM_IsPaymentStop HIDDEN Adempiere 3.7
C_BPartner UM_IsSMSEligible HIDDEN Adempiere 3.7
C_BPartner UM_JoinDate HIDDEN Adempiere 3.7
C_BPartner UM_LastRedeemedDate HIDDEN Adempiere 3.7
C_BPartner UM_LastRedeemedPoints HIDDEN Adempiere 3.7
C_BPartner UM_LastYearPoint HIDDEN Adempiere 3.7
C_BPartner UM_MemberType_ID HIDDEN Adempiere 3.7
C_BPartner UM_MobileNo HIDDEN Adempiere 3.7
C_BPartner UM_NumOfHoldBills HIDDEN Adempiere 3.7
C_BPartner UM_OtherDiscount HIDDEN Adempiere 3.7
C_BPartner UM_OTPGeneratedDate HIDDEN Adempiere 3.7
C_BPartner UM_OTPNo HIDDEN Adempiere 3.7
C_BPartner UM_PayRoll_No ADDED Adempiere 3.7
C_BPartner UM_PromiseDays HIDDEN Adempiere 3.7
C_BPartner UM_PurchaseTarget HIDDEN Adempiere 3.7
C_BPartner UM_ResPhoneNo HIDDEN Adempiere 3.7
C_BPartner UM_ScheduleDay HIDDEN Adempiere 3.7
C_BPartner UM_SOS HIDDEN Adempiere 3.7
C_BPartner UM_SupplierSchedule HIDDEN Adempiere 3.7
C_BPartner UM_TinNumber HIDDEN Adempiere 3.7
C_BPartner UM_TOT HIDDEN Adempiere 3.7
C_BPartner UM_Ullage HIDDEN Adempiere 3.7
C_BPartner Updated HIDDEN Adempiere 3.7
C_BPartner UpdatedBy HIDDEN Adempiere 3.7
C_BPartner URL HIDDEN Adempiere 3.7
C_BPartner Value DEFAULT Adempiere 3.7
C_BPartner_Location AD_Client_ID HIDDEN Adempiere 3.7
C_BPartner_Location AD_Org_ID HIDDEN Adempiere 3.7
C_BPartner_Location C_BPartner_ID DEFAULT Adempiere 3.7
C_BPartner_Location C_BPartner_Location_ID HIDDEN Adempiere 3.7
C_BPartner_Location C_Location_ID DEFAULT Adempiere 3.7
C_BPartner_Location Created HIDDEN Adempiere 3.7
C_BPartner_Location CreatedBy HIDDEN Adempiere 3.7
C_BPartner_Location C_SalesRegion_ID HIDDEN Adempiere 3.7
C_BPartner_Location Fax HIDDEN Adempiere 3.7
C_BPartner_Location IsActive DEFAULT Adempiere 3.7
C_BPartner_Location IsBillTo HIDDEN Adempiere 3.7
C_BPartner_Location IsDefault HIDDEN Adempiere 3.7
C_BPartner_Location ISDN HIDDEN Adempiere 3.7
C_BPartner_Location IsPayFrom HIDDEN Adempiere 3.7
C_BPartner_Location IsRemitTo HIDDEN Adempiere 3.7
C_BPartner_Location IsShipTo HIDDEN Adempiere 3.7
C_BPartner_Location Name DEFAULT Adempiere 3.7
C_BPartner_Location Phone DEFAULT Adempiere 3.7
C_BPartner_Location Phone2 HIDDEN Adempiere 3.7
C_BPartner_Location Updated HIDDEN Adempiere 3.7
C_BPartner_Location UpdatedBy HIDDEN Adempiere 3.7
AD_User AD_Client_ID HIDDEN Adempiere 3.7
AD_User AD_Org_ID HIDDEN Adempiere 3.7
AD_User AD_OrgTrx_ID HIDDEN Adempiere 3.7
AD_User AD_User_ID HIDDEN Adempiere 3.7
AD_User Birthday DEFAULT Adempiere 3.7
AD_User C_BPartner_ID DEFAULT Adempiere 3.7
AD_User C_BPartner_Location_ID HIDDEN Adempiere 3.7
AD_User C_Greeting_ID HIDDEN Adempiere 3.7
AD_User C_Job_ID DEFAULT Adempiere 3.7
AD_User C_Location_ID HIDDEN Adempiere 3.7
AD_User Comments HIDDEN Adempiere 3.7
AD_User ConnectionProfile HIDDEN Adempiere 3.7
AD_User Created HIDDEN Adempiere 3.7
AD_User CreatedBy HIDDEN Adempiere 3.7
AD_User Description HIDDEN Adempiere 3.7
AD_User EMail DEFAULT Adempiere 3.7
AD_User EMailUser HIDDEN Adempiere 3.7
AD_User EMailUserPW HIDDEN Adempiere 3.7
AD_User EMailVerify HIDDEN Adempiere 3.7
AD_User EMailVerifyDate HIDDEN Adempiere 3.7
AD_User Fax HIDDEN Adempiere 3.7
AD_User IsActive DEFAULT Adempiere 3.7
AD_User IsDefault HIDDEN Adempiere 3.7
AD_User IsFullBPAccess HIDDEN Adempiere 3.7
AD_User IsInPayroll HIDDEN Adempiere 3.7
AD_User IsSalesRep HIDDEN Adempiere 3.7
AD_User LastContact HIDDEN Adempiere 3.7
AD_User LastResult HIDDEN Adempiere 3.7
AD_User LDAPUser HIDDEN Adempiere 3.7
AD_User Name DEFAULT Adempiere 3.7
AD_User NotificationType DEFAULT Adempiere 3.7
AD_User Password HIDDEN Adempiere 3.7
AD_User Phone DEFAULT Adempiere 3.7
AD_User Phone2 DEFAULT Adempiere 3.7
AD_User Processing HIDDEN Adempiere 3.7
AD_User Supervisor_ID HIDDEN Adempiere 3.7
AD_User Title HIDDEN Adempiere 3.7
AD_User UM_SecondaryEmail HIDDEN Adempiere 3.7
AD_User Updated HIDDEN Adempiere 3.7
AD_User UpdatedBy HIDDEN Adempiere 3.7
AD_User UserPIN HIDDEN Adempiere 3.7
AD_User Value HIDDEN Adempiere 3.7

 

Import Barcode

This is the staging screen used for importing Barcode information either from CSV or Excel

Table Name DB Field Name Super Store Work Edition
I_UM_Product_BarCode AD_Client_ID DEFAULT Adempiere 3.7
I_UM_Product_BarCode AD_Org_ID DEFAULT Adempiere 3.7
I_UM_Product_BarCode Created HIDDEN Adempiere 3.7
I_UM_Product_BarCode CreatedBy HIDDEN Adempiere 3.7
I_UM_Product_BarCode Description HIDDEN Adempiere 3.7
I_UM_Product_BarCode I_ErrorMsg DEFAULT Adempiere 3.7
I_UM_Product_BarCode I_IsImported DEFAULT Adempiere 3.7
I_UM_Product_BarCode IsActive HIDDEN Adempiere 3.7
I_UM_Product_BarCode I_UM_Product_BarCode_ID HIDDEN Adempiere 3.7
I_UM_Product_BarCode M_Product_ID DEFAULT Adempiere 3.7
I_UM_Product_BarCode OrgValue HIDDEN Adempiere 3.7
I_UM_Product_BarCode Processed HIDDEN Adempiere 3.7
I_UM_Product_BarCode Processing DEFAULT Adempiere 3.7
I_UM_Product_BarCode product_value DEFAULT Adempiere 3.7
I_UM_Product_BarCode UM_BarCode ADDED Adempiere 3.7
I_UM_Product_BarCode UM_Product_BarCode_ID ADDED Adempiere 3.7
I_UM_Product_BarCode Updated HIDDEN Adempiere 3.7
I_UM_Product_BarCode UpdatedBy HIDDEN Adempiere 3.7

 

Import Brand

This is the staging screen used for importing Brand information either from CSV or Excel

Table Name DB Field Name Super Store Work Edition
I_UM_Brand AD_Client_ID DEFAULT Adempiere 3.7
I_UM_Brand AD_Org_ID DEFAULT Adempiere 3.7
I_UM_Brand Created HIDDEN Adempiere 3.7
I_UM_Brand CreatedBy HIDDEN Adempiere 3.7
I_UM_Brand Description HIDDEN Adempiere 3.7
I_UM_Brand I_ErrorMsg DEFAULT Adempiere 3.7
I_UM_Brand I_IsImported DEFAULT Adempiere 3.7
I_UM_Brand IsActive HIDDEN Adempiere 3.7
I_UM_Brand I_UM_Brand_ID HIDDEN Adempiere 3.7
I_UM_Brand manufacturer_value ADDED Adempiere 3.7
I_UM_Brand merchandise_value ADDED Adempiere 3.7
I_UM_Brand Name DEFAULT Adempiere 3.7
I_UM_Brand OrgValue HIDDEN Adempiere 3.7
I_UM_Brand Processed HIDDEN Adempiere 3.7
I_UM_Brand Processing DEFAULT Adempiere 3.7
I_UM_Brand UM_BrandCode ADDED Adempiere 3.7
I_UM_Brand UM_Brand_ID ADDED Adempiere 3.7
I_UM_Brand UM_Manufacturer_ID ADDED Adempiere 3.7
I_UM_Brand UM_Merchandise_ID ADDED Adempiere 3.7
I_UM_Brand Updated HIDDEN Adempiere 3.7
I_UM_Brand UpdatedBy HIDDEN Adempiere 3.7

 

Import CommodityCode

This is the staging screen used for importing Commodity Code information either from CSV or Excel

Table Name DB Field Name Super Store Work Edition
I_UM_CommodityCode AD_Client_ID DEFAULT Adempiere 3.7
I_UM_CommodityCode AD_Org_ID DEFAULT Adempiere 3.7
I_UM_CommodityCode CommodityCode ADDED Adempiere 3.7
I_UM_CommodityCode Created HIDDEN Adempiere 3.7
I_UM_CommodityCode CreatedBy HIDDEN Adempiere 3.7
I_UM_CommodityCode C_TaxCategory_ID DEFAULT Adempiere 3.7
I_UM_CommodityCode Description DEFAULT Adempiere 3.7
I_UM_CommodityCode I_ErrorMsg DEFAULT Adempiere 3.7
I_UM_CommodityCode I_IsImported DEFAULT Adempiere 3.7
I_UM_CommodityCode IsActive HIDDEN Adempiere 3.7
I_UM_CommodityCode I_UM_CommodityCode_ID HIDDEN Adempiere 3.7
I_UM_CommodityCode Name HIDDEN Adempiere 3.7
I_UM_CommodityCode OrgValue HIDDEN Adempiere 3.7
I_UM_CommodityCode Processed HIDDEN Adempiere 3.7
I_UM_CommodityCode Processing DEFAULT Adempiere 3.7
I_UM_CommodityCode taxcategory_value ADDED Adempiere 3.7
I_UM_CommodityCode UM_CommodityCode_ID ADDED Adempiere 3.7
I_UM_CommodityCode UM_ItemNo ADDED Adempiere 3.7
I_UM_CommodityCode UM_PartNo ADDED Adempiere 3.7
I_UM_CommodityCode UM_Schedule ADDED Adempiere 3.7
I_UM_CommodityCode UM_SubItemNo ADDED Adempiere 3.7
I_UM_CommodityCode Updated HIDDEN Adempiere 3.7
I_UM_CommodityCode UpdatedBy HIDDEN Adempiere 3.7

 

Import Customer

This is the staging screen used for importing Customer information either from CSV or Excel

Table Name DB Field Name Super Store Work Edition
I_BPartner AD_Client_ID DEFAULT Adempiere 3.7
I_BPartner Address1 DEFAULT Adempiere 3.7
I_BPartner Address2 DEFAULT Adempiere 3.7
I_BPartner Address3 HIDDEN Adempiere 3.7
I_BPartner AD_Org_ID DEFAULT Adempiere 3.7
I_BPartner AD_User_ID DEFAULT Adempiere 3.7
I_BPartner Birthday DEFAULT Adempiere 3.7
I_BPartner BPContactGreeting HIDDEN Adempiere 3.7
I_BPartner C_BPartner_ID DEFAULT Adempiere 3.7
I_BPartner C_BPartner_Location_ID DEFAULT Adempiere 3.7
I_BPartner C_BP_BankAccount_ID HIDDEN Adempiere 3.7
I_BPartner C_BP_Group_ID DEFAULT Adempiere 3.7
I_BPartner C_Country_ID DEFAULT Adempiere 3.7
I_BPartner C_Greeting_ID HIDDEN Adempiere 3.7
I_BPartner City DEFAULT Adempiere 3.7
I_BPartner Comments HIDDEN Adempiere 3.7
I_BPartner ContactDescription HIDDEN Adempiere 3.7
I_BPartner ContactName DEFAULT Adempiere 3.7
I_BPartner CountryCode DEFAULT Adempiere 3.7
I_BPartner Created HIDDEN Adempiere 3.7
I_BPartner CreatedBy HIDDEN Adempiere 3.7
I_BPartner CreditLimit HIDDEN Adempiere 3.7
I_BPartner C_Region_ID HIDDEN Adempiere 3.7
I_BPartner Description DEFAULT Adempiere 3.7
I_BPartner DUNS HIDDEN Adempiere 3.7
I_BPartner EMail DEFAULT Adempiere 3.7
I_BPartner Fax HIDDEN Adempiere 3.7
I_BPartner GroupValue DEFAULT Adempiere 3.7
I_BPartner I_BPartner_ID DEFAULT Adempiere 3.7
I_BPartner I_ErrorMsg DEFAULT Adempiere 3.7
I_BPartner I_IsImported DEFAULT Adempiere 3.7
I_BPartner InterestAreaName HIDDEN Adempiere 3.7
I_BPartner IsActive HIDDEN Adempiere 3.7
I_BPartner IsCustomer DEFAULT Adempiere 3.7
I_BPartner IsEmployee HIDDEN Adempiere 3.7
I_BPartner IsVendor HIDDEN Adempiere 3.7
I_BPartner NAICS HIDDEN Adempiere 3.7
I_BPartner Name DEFAULT Adempiere 3.7
I_BPartner Name2 HIDDEN Adempiere 3.7
I_BPartner Password HIDDEN Adempiere 3.7
I_BPartner PaymentRule HIDDEN Adempiere 3.7
I_BPartner Phone DEFAULT Adempiere 3.7
I_BPartner Phone2 DEFAULT Adempiere 3.7
I_BPartner PO_PaymentTerm_ID HIDDEN Adempiere 3.7
I_BPartner PO_PriceList_ID HIDDEN Adempiere 3.7
I_BPartner Postal ADDED Adempiere 3.7
I_BPartner Postal_Add DEFAULT Adempiere 3.7
I_BPartner Processed DEFAULT Adempiere 3.7
I_BPartner Processing DEFAULT Adempiere 3.7
I_BPartner RegionName HIDDEN Adempiere 3.7
I_BPartner R_InterestArea_ID HIDDEN Adempiere 3.7
I_BPartner TaxID HIDDEN Adempiere 3.7
I_BPartner Title HIDDEN Adempiere 3.7
I_BPartner UM_BankBranchCode HIDDEN Adempiere 3.7
I_BPartner UM_BankCode HIDDEN Adempiere 3.7
I_BPartner UM_CSTCode HIDDEN Adempiere 3.7
I_BPartner UM_IsActive ADDED Adempiere 3.7
I_BPartner UM_IsPaymentStop HIDDEN Adempiere 3.7
I_BPartner UM_MobileNo HIDDEN Adempiere 3.7
I_BPartner UM_NumOfHoldBills HIDDEN Adempiere 3.7
I_BPartner UM_PaymentRule HIDDEN Adempiere 3.7
I_BPartner UM_PaymentStop HIDDEN Adempiere 3.7
I_BPartner UM_TinNumber HIDDEN Adempiere 3.7
I_BPartner Updated HIDDEN Adempiere 3.7
I_BPartner UpdatedBy HIDDEN Adempiere 3.7
I_BPartner Value DEFAULT Adempiere 3.7

 

Import Loader Format

Maintain Import Loader Formats.
The Import Loader Format Window is used for defining the file layout for product information which will be imported.

Table Name DB Field Name Super Store Work Edition
AD_ImpFormat AD_Client_ID DEFAULT Adempiere 3.7
AD_ImpFormat AD_ImpFormat_ID HIDDEN Adempiere 3.7
AD_ImpFormat AD_Org_ID DEFAULT Adempiere 3.7
AD_ImpFormat AD_Table_ID DEFAULT Adempiere 3.7
AD_ImpFormat Created HIDDEN Adempiere 3.7
AD_ImpFormat CreatedBy HIDDEN Adempiere 3.7
AD_ImpFormat Description DEFAULT Adempiere 3.7
AD_ImpFormat FormatType DEFAULT Adempiere 3.7
AD_ImpFormat IsActive DEFAULT Adempiere 3.7
AD_ImpFormat Name DEFAULT Adempiere 3.7
AD_ImpFormat Processing DEFAULT Adempiere 3.7
AD_ImpFormat SeparatorChar DEFAULT Adempiere 3.7
AD_ImpFormat Updated HIDDEN Adempiere 3.7
AD_ImpFormat UpdatedBy HIDDEN Adempiere 3.7
AD_ImpFormat_Row AD_Client_ID DEFAULT Adempiere 3.7
AD_ImpFormat_Row AD_Column_ID DEFAULT Adempiere 3.7
AD_ImpFormat_Row AD_ImpFormat_ID DEFAULT Adempiere 3.7
AD_ImpFormat_Row AD_ImpFormat_Row_ID DEFAULT Adempiere 3.7
AD_ImpFormat_Row AD_Org_ID DEFAULT Adempiere 3.7
AD_ImpFormat_Row Callout DEFAULT Adempiere 3.7
AD_ImpFormat_Row ConstantValue DEFAULT Adempiere 3.7
AD_ImpFormat_Row Created HIDDEN Adempiere 3.7
AD_ImpFormat_Row CreatedBy HIDDEN Adempiere 3.7
AD_ImpFormat_Row DataFormat DEFAULT Adempiere 3.7
AD_ImpFormat_Row DataType DEFAULT Adempiere 3.7
AD_ImpFormat_Row DecimalPoint DEFAULT Adempiere 3.7
AD_ImpFormat_Row DivideBy100 DEFAULT Adempiere 3.7
AD_ImpFormat_Row EndNo DEFAULT Adempiere 3.7
AD_ImpFormat_Row IsActive DEFAULT Adempiere 3.7
AD_ImpFormat_Row Name DEFAULT Adempiere 3.7
AD_ImpFormat_Row Script DEFAULT Adempiere 3.7
AD_ImpFormat_Row SeqNo DEFAULT Adempiere 3.7
AD_ImpFormat_Row StartNo DEFAULT Adempiere 3.7
AD_ImpFormat_Row Updated HIDDEN Adempiere 3.7
AD_ImpFormat_Row UpdatedBy HIDDEN Adempiere 3.7

 

Import Manufacturer

This is the staging screen used for importing Manufacturer information either from CSV or Excel

Table Name DB Field Name Super Store Work Edition
I_UM_Manufacturer AD_Client_ID DEFAULT Adempiere 3.7
I_UM_Manufacturer AD_Org_ID DEFAULT Adempiere 3.7
I_UM_Manufacturer Created HIDDEN Adempiere 3.7
I_UM_Manufacturer CreatedBy HIDDEN Adempiere 3.7
I_UM_Manufacturer Description HIDDEN Adempiere 3.7
I_UM_Manufacturer I_ErrorMsg DEFAULT Adempiere 3.7
I_UM_Manufacturer I_IsImported DEFAULT Adempiere 3.7
I_UM_Manufacturer IsActive HIDDEN Adempiere 3.7
I_UM_Manufacturer I_UM_Manufacturer_ID HIDDEN Adempiere 3.7
I_UM_Manufacturer Name DEFAULT Adempiere 3.7
I_UM_Manufacturer OrgValue HIDDEN Adempiere 3.7
I_UM_Manufacturer Processed HIDDEN Adempiere 3.7
I_UM_Manufacturer Processing DEFAULT Adempiere 3.7
I_UM_Manufacturer UM_ManufacturerCode ADDED Adempiere 3.7
I_UM_Manufacturer UM_Manufacturer_ID ADDED Adempiere 3.7
I_UM_Manufacturer Updated HIDDEN Adempiere 3.7
I_UM_Manufacturer UpdatedBy HIDDEN Adempiere 3.7

 

Import Vendor

This is the staging screen used for importing Vendor information either from CSV or Excel.

Table Name DB Field Name Super Store Work Edition
I_BPartner AD_Client_ID DEFAULT Adempiere 3.7
I_BPartner Address1 DEFAULT Adempiere 3.7
I_BPartner Address2 DEFAULT Adempiere 3.7
I_BPartner Address3 HIDDEN Adempiere 3.7
I_BPartner AD_Org_ID DEFAULT Adempiere 3.7
I_BPartner AD_User_ID HIDDEN Adempiere 3.7
I_BPartner Birthday HIDDEN Adempiere 3.7
I_BPartner BPContactGreeting HIDDEN Adempiere 3.7
I_BPartner C_BPartner_ID DEFAULT Adempiere 3.7
I_BPartner C_BPartner_Location_ID DEFAULT Adempiere 3.7
I_BPartner C_BP_BankAccount_ID DEFAULT Adempiere 3.7
I_BPartner C_BP_Group_ID DEFAULT Adempiere 3.7
I_BPartner C_Country_ID DEFAULT Adempiere 3.7
I_BPartner C_Greeting_ID HIDDEN Adempiere 3.7
I_BPartner City DEFAULT Adempiere 3.7
I_BPartner Comments HIDDEN Adempiere 3.7
I_BPartner ContactDescription HIDDEN Adempiere 3.7
I_BPartner ContactName DEFAULT Adempiere 3.7
I_BPartner CountryCode DEFAULT Adempiere 3.7
I_BPartner Created HIDDEN Adempiere 3.7
I_BPartner CreatedBy HIDDEN Adempiere 3.7
I_BPartner CreditLimit DEFAULT Adempiere 3.7
I_BPartner C_Region_ID HIDDEN Adempiere 3.7
I_BPartner Description DEFAULT Adempiere 3.7
I_BPartner DUNS HIDDEN Adempiere 3.7
I_BPartner EMail DEFAULT Adempiere 3.7
I_BPartner Fax DEFAULT Adempiere 3.7
I_BPartner GroupValue DEFAULT Adempiere 3.7
I_BPartner I_BPartner_ID DEFAULT Adempiere 3.7
I_BPartner I_ErrorMsg DEFAULT Adempiere 3.7
I_BPartner I_IsImported DEFAULT Adempiere 3.7
I_BPartner InterestAreaName HIDDEN Adempiere 3.7
I_BPartner IsActive HIDDEN Adempiere 3.7
I_BPartner IsCustomer HIDDEN Adempiere 3.7
I_BPartner IsEmployee HIDDEN Adempiere 3.7
I_BPartner IsVendor DEFAULT Adempiere 3.7
I_BPartner NAICS HIDDEN Adempiere 3.7
I_BPartner Name DEFAULT Adempiere 3.7
I_BPartner Name2 DEFAULT Adempiere 3.7
I_BPartner Password HIDDEN Adempiere 3.7
I_BPartner PaymentRule DEFAULT Adempiere 3.7
I_BPartner Phone DEFAULT Adempiere 3.7
I_BPartner Phone2 DEFAULT Adempiere 3.7
I_BPartner PO_PaymentTerm_ID DEFAULT Adempiere 3.7
I_BPartner PO_PriceList_ID DEFAULT Adempiere 3.7
I_BPartner Postal DEFAULT Adempiere 3.7
I_BPartner Postal_Add DEFAULT Adempiere 3.7
I_BPartner Processed DEFAULT Adempiere 3.7
I_BPartner Processing DEFAULT Adempiere 3.7
I_BPartner RegionName HIDDEN Adempiere 3.7
I_BPartner R_InterestArea_ID HIDDEN Adempiere 3.7
I_BPartner TaxID HIDDEN Adempiere 3.7
I_BPartner Title DEFAULT Adempiere 3.7
I_BPartner UM_BankBranchCode ADDED Adempiere 3.7
I_BPartner UM_BankCode ADDED Adempiere 3.7
I_BPartner UM_CSTCode ADDED Adempiere 3.7
I_BPartner UM_IsActive ADDED Adempiere 3.7
I_BPartner UM_IsPaymentStop ADDED Adempiere 3.7
I_BPartner UM_MobileNo ADDED Adempiere 3.7
I_BPartner UM_NumOfHoldBills ADDED Adempiere 3.7
I_BPartner UM_PaymentRule ADDED Adempiere 3.7
I_BPartner UM_PaymentStop ADDED Adempiere 3.7
I_BPartner UM_TinNumber ADDED Adempiere 3.7
I_BPartner Updated HIDDEN Adempiere 3.7
I_BPartner UpdatedBy HIDDEN Adempiere 3.7
I_BPartner Value DEFAULT Adempiere 3.7