Purchase Management

Purchase Management

Purchase is an important department in any retail business to help enterprises store enough stock in the warehouse for smooth running of the business. Compiere ERP Retail POS provides lot of important features like purchase based on last 6 months sales, 3-way matching of POs, generating returns from GRN’s directly and lot of other features to help the purchase department to procure goods on time every time.

Create/Manage Purchase Orders – User should be able to select a Vendor from the vendor list and create Purchase Orders based on availability of stock. User should be able to select the list of products that are purchased from the selected vendor, and create purchase order lines in bulk. The purchase order can be sent as email to the vendor or printed and given to the vendor for the vendor to supply the mentioned goods.

Business Rules

  • User should be able to open the purchase order screen and create new purchase order and purchase order line records.
  • User should be able to select a vendor against whom purchase order is being raised.
  • The system should automatically set the vendor information like vendor location, vendor contact upon selection of vendor.
  • User should be able to search the list of products sold by the Vendor based on different parameters and filter the same.
  • User should be able to calculate the suggested PO Qty based on different options like last PO Qty, last GRN Qty, last Sales Qty, etc.
  • User should be able to manually update the PO Qty and create the PO Lines.
  • User should be able to select all the products listed against a specific vendor using a single button.
  • User should be able to manually select a specific set of products from a long list of available products to create order lines.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Create_Purchase_Order

TenthPlanet_Compiere_Retail_Purchase_Management_Create_Purchase_Order 2

TenthPlanet_Compiere_Retail_Purchase_Management_Create_Purchase_Order 3

PO generate based on Ordering Methods – The search products button in Purchase Order screen helps users to calculate the suggested qty for purchase based on different ordering methods. The available ordering methods are Last GRN Qty Wise, Min/Max Reorder Level, Reorder by No. of Days, Sold qty from last GRN date, and sold qty in given Date range.

Business Rules

  • System should allow the user to choose one of the following ordering method
  • Last GRN Quantity Wise: Show suggested quantity based on last GRN quantity.
  • Minimum/Maximum reorder level: Current on hand quantity should be lesser or equal to minimum level the suggested quantity is = (maximum quantity-on hand quantity).
  • Reorder by No. of Days: Average sold quantity with date range and No. of days. (Suggested quantity = (One day sales * No. of days)- On Hand quantity)
  • Sold Quantity from last GRN Date: Getting sold quantity after last GRN Date, the suggested quantity is sold quantity.
  • Sold Quantity in given Date Range: Display the sold quantity for the given date range.
  • By default no ordering method will be selected. In that case if the user filters the product it should list the products without calculating anything (suggested Qty, Order Qty will be zero).
  • Date range: date range for ordering method.
  • Days No: Number of days for ordering method.
  • Apply Order: Apply ordering method and suggested quantity will be displayed.
  • Hide Negative: In Product list hide the negative suggested quantity.
  • Hide Zero: In Product list hide the Zero suggested quantity.
  • Zoom: All the masters have zoom view. It is used to view full details of single master

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_PO_Gennerate

PO based GRN – Purchase back office users can receive or raise a GRN based on the already created pending purchase order. This way they can match the qty, price, etc. with the purchase order created and receive the stock accordingly. If there is any discrepancy they can let the Vendor know about it and clarify the same.
Users can also receive a GRN without a Purchase Order in case of emergency where the stock is ordered over phone or by other oral communication means.

Business Rules

  • User should be able to select a PO using the “Create Lines from PO” button.
  • The user should be able to create the PO lines as GRN lines.
  • User should be able to receive partial GRNs for a single PO.
  • Bill No should be unique for each processed GRN.
  • System should be able to calculate the Grand Total, Basic Cost Total, Discount Total, Scheme Discount Total, Tax Total and Landed Cost Total.
  • User should be able to type the Add/Ded Amount, Add/Dec Reason, Total Pay Amt, Basic Cost Total, Discount Total, Scheme Discount Total, Tax Total and Landed Cost Total.
  • User should be able to process the GRN and print the GRN Entry for account submission.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_PO_Based_GRN

TenthPlanet_Compiere_Retail_Purchase_Management_PO_Based_GRN 2

Product scanning during GRN Entry – In the GRN Line, back office users has the facility to scan a product EAN Code and fetch a product from product master. This helps the users to reduce manual work by avoiding typing the EAN Code no.

Business Rules

  • User should be able to scan the product in the product field of GRN Line tab.
  • Once the product is scanned, the system should be able to search the product batch from the list of available products.
  • If a product has more than 1 batch, the system should be able to show the list of batches for the searched product.
  • User should be able to select a particular product batch from the list for the specific GRN Line.

UI/Layout

Receive stock using HHT – Back Office users in the warehouse can open Compiere ERP Retail application using a HHT device to receive stock quickly and easily. This feature enables the users to receive the stock by selecting the Purchase Order and scanning the products one by one using a Hand Held Terminal. It will be easy for the user to receive stock this way, because they don’t need to carry the goods for scanning in a desktop application. The HHT device can be carried to the place where the goods are stored, scanned and received.

Business Rules

  • User should be able to open the GRN Scan screen from HHT.
  • User should be able to create GRN Scan record and select with/without PO option.
  • User should be able to select the PO when With PO option is selected.
  • The system should populate the Vendor, Movement Date and other details automatically.
  • The user should be able to capture the Bill No, Bill Date.
  • User should be able to select the Warehouse where the receipt is being made.
  • User should be able to view the grand total of all the GRN lines which should get automatically calculated.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Receive stock using HHT

TenthPlanet_Compiere_Retail_Purchase_Management_Receive stock using HHT 2

TenthPlanet_Compiere_Retail_Purchase_Management_Receive stock using HHT 3

TenthPlanet_Compiere_Retail_Purchase_Management_Receive stock using HHT 4

Capture Overheads/Freight Charges – The back office user can calculate the landed cost of a product effectively/accurately by capturing the overheads/freight charges for a specific receipt made from the vendor. This charge will be duly allocated according to the quantity of product that is supplied in a single GRN.

Business Rules

  • User should be able to capture freight charges in the GRN screen.
  • User should also be able to distribute the freight charges for each GRN Line based on the line qty that is purchased from the vendor.
  • The system should auto calculate the freight charge for each qty, each line and also each include the freight charge in the landed cost of the product.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Capture Overheads_Freight Charges

TenthPlanet_Compiere_Retail_Purchase_Management_Capture Overheads_Freight Charges 2

TenthPlanet_Compiere_Retail_Purchase_Management_Capture Overheads_Freight Charges 3

Print GRN with GST details – User should be able to process a GRN and print the GRN details from the GRN screen.

Business Rules

  • User should be able to complete the GRN from the GRN screen.
  • After the GRN is processed, user should be able to select the print preview button to print the GRN.
  • The GRN should show all the header, line, tax details related to the specific GRN.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Print GRN with GST details

Print Barcode stickers from GRN – After processing a GRN, user can print barcode stickers for the GRN specific products based on the qty of products purchased.
Users can choose different parameters from the available to print or not print specific details in the barcode like MRP, Discount %, Expiry Date, etc.

Business Rules

  • System should show a button called “Generate Barcode” to open the barcode generation screen from GRN.
  • Once the button is clicked the system should show a popup screen with parameters and the list of products received in this GRN document.
  • Users can choose any number of products from the available list, change the qty and click ok to print barcode stickers.
  • Users can choose either Barcode Sticker or SET Sticker templates based on their needs.

UI/Layout

Purchase Return – Purchase Return can be processed by the users from the GRN itself if the user has captured the return qty in the GRN itself. This helps the users to verify the product’s quality and return the product immediately to the vendor during delivery. Otherwise users can keep the products for return in a different Bay in the warehouse and generate return transactions at a later time.

Business Rules

  • User should be able to capture the return qty for each GRN Line.
  • Once the GRN is processed, user should be able to generate the return for those GRN Lines, where return qty is captured.
  • User can generate Return using the Return to Vendor screen also.
  • Here user should be able to mention the Vendor name and the Warehouse details. In the Return Line, user should capture the product, qty that are being returned.
  • Once captured the Return to Vendor is processed and print of the Return transaction is printed.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Purchase Return

TenthPlanet_Compiere_Retail_Purchase_Management_Purchase Return 2

TenthPlanet_Compiere_Retail_Purchase_Management_Purchase Return 3

AP Credit Memo Management – When a purchase return is generated by the user, the system automatically creates an AP Credit Memo against the vendor so that the vendor returns the money that is pending against him due to the return.

Business Rules

  • Using the EOD process, user should be able to generate AP Credit Memo for the Purchase Return generated.
  • The AP Credit Memo should have the same bill no., bill date and other details as in the Purchase Return.

UI/Layout

Generate Invoices for multiple GRNs – Users don’t need to generate individual invoices for each GRN separately. Compiere ERP Retail POS product has a process which helps in generating invoices for all pending purchase order/GRN documents. This way user can reduce the time of generating invoices and work on other effective tasks to improve productivity

Business Rules

  • User should be able to run EOD Generate Invoices process with a specific date and generate invoices.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Generate Invoices for multiple GRNs

TenthPlanet_Compiere_Retail_Purchase_Management_Generate Invoices for multiple GRNs 2

TenthPlanet_Compiere_Retail_Purchase_Management_Generate Invoices for multiple GRNs 3

TenthPlanet_Compiere_Retail_Purchase_Management_Generate Invoices for multiple GRNs 4

Consolidate payment by vendors/invoices – Once the AP Invoice is generated the accounting users can generate payment for the invoices by consolidating multiple invoices of a specific Vendor into one payment. Using the payment selection screen, users should be able to select a list of invoices for each vendor and generate the payment. The payment can be finally printed.

Business Rules

  • User should be able to run EOD Generate Invoices process with a specific date and generate invoices.
  • Once the process is generated, it should mark the specific GRN for which invoice is generated as generateto=’Y’.
  • It should copy all the details from the GRN to the invoice and complete the invoice automatically.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_Consolidate payment by vendors_invoices

TenthPlanet_Compiere_Retail_Purchase_Management_Consolidate payment by vendors_invoices 2

TenthPlanet_Compiere_Retail_Purchase_Management_Consolidate payment by vendors_invoices 3

GST based Purchase Tax configuration – GST taxes can be configured for the products in the Product screen and the CGST, SGST split can also be configured.
This helps the users to find the accurate tax for the purchases made and submit their tax returns accordingly.

Business Rules

  • Users should be able to configure the GST taxes for products in the product screen.
  • Users should also be able to configure the purchase tax specifically for products.
  • System should help users to capture the Cess Tax % for a product
  • All these tax information and their respective tax values should be captured by the system in the GRN Line for each product.

UI/Layout

TenthPlanet_Compiere_Retail_Purchase_Management_GST based Purchase Tax configuration

Business Partner

The Business Partner screen is used for managing the customers, vendors, employee, sales rep of the Company.

Table Name DB Field Name Super Store Work Edition
C_BPartner AcqusitionCost DEFAULT Adempiere 3.7
C_BPartner ActualLifeTimeValue DEFAULT Adempiere 3.7
C_BPartner AD_Client_ID DEFAULT Adempiere 3.7
C_BPartner AD_Language DEFAULT Adempiere 3.7
C_BPartner AD_OrgBP_ID DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner C_Dunning_ID HIDDEN Adempiere 3.7
C_BPartner C_Greeting_ID DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner DeliveryRule HIDDEN Adempiere 3.7
C_BPartner DeliveryViaRule HIDDEN Adempiere 3.7
C_BPartner Description DEFAULT Adempiere 3.7
C_BPartner DocumentCopies HIDDEN Adempiere 3.7
C_BPartner DunningGrace HIDDEN Adempiere 3.7
C_BPartner DUNS DEFAULT Adempiere 3.7
C_BPartner FirstSale DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner IsProspect DEFAULT Adempiere 3.7
C_BPartner IsSalesRep DEFAULT Adempiere 3.7
C_BPartner IsSOTrx HIDDEN Adempiere 3.7
C_BPartner IsSummary DEFAULT Adempiere 3.7
C_BPartner IsTaxExempt DEFAULT Adempiere 3.7
C_BPartner IsVendor HIDDEN Adempiere 3.7
C_BPartner Logo_ID DEFAULT Adempiere 3.7
C_BPartner M_DiscountSchema_ID HIDDEN Adempiere 3.7
C_BPartner M_PriceList_ID HIDDEN Adempiere 3.7
C_BPartner NAICS DEFAULT Adempiere 3.7
C_BPartner Name DEFAULT Adempiere 3.7
C_BPartner Name2 DEFAULT Adempiere 3.7
C_BPartner NumberEmployees DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner Processed HIDDEN Adempiere 3.7
C_BPartner Rating DEFAULT Adempiere 3.7
C_BPartner ReferenceNo DEFAULT Adempiere 3.7
C_BPartner SalesRep_ID HIDDEN Adempiere 3.7
C_BPartner SalesVolume DEFAULT Adempiere 3.7
C_BPartner SendEMail HIDDEN Adempiere 3.7
C_BPartner ShareOfCustomer DEFAULT Adempiere 3.7
C_BPartner ShelfLifeMinPct HIDDEN Adempiere 3.7
C_BPartner SO_CreditLimit HIDDEN Adempiere 3.7
C_BPartner SOCreditStatus DEFAULT Adempiere 3.7
C_BPartner SO_CreditUsed HIDDEN Adempiere 3.7
C_BPartner SO_Description HIDDEN Adempiere 3.7
C_BPartner TaxID DEFAULT Adempiere 3.7
C_BPartner TotalOpenBalance DEFAULT Adempiere 3.7
C_BPartner UM_CardNo ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_CreditAvailable ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_CreditDays ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_CSTCode ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_CurrentYearPoint ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_EmpCommission_No ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_ExpDate ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_GSTinNo ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsCForm ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsGST ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsInstitutional ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsLastYearRedeemed ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsOtherState ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsPaymentStop ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_IsSMSEligible ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_JoinDate ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_LastRedeemedDate ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_LastRedeemedPoints ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_LastYearPoint ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_MemberType_ID ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_MobileNo ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_NumOfHoldBills ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_OtherDiscount ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_OTPGeneratedDate ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_OTPNo ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_PayRoll_No ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_PromiseDays ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_PurchaseTarget ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_ResPhoneNo ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_ScheduleDay ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_SOS ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_SupplierSchedule ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_TinNumber ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_TOT ADDED, HIDDEN Adempiere 3.7
C_BPartner UM_Ullage ADDED, HIDDEN Adempiere 3.7
C_BPartner Updated HIDDEN Adempiere 3.7
C_BPartner UpdatedBy HIDDEN Adempiere 3.7
C_BPartner URL DEFAULT Adempiere 3.7
C_BPartner Value DEFAULT Adempiere 3.7
C_BPartner AcqusitionCost DEFAULT Adempiere 3.7
C_BPartner ActualLifeTimeValue HIDDEN 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 DEFAULT Adempiere 3.7
C_BPartner C_Greeting_ID HIDDEN Adempiere 3.7
C_BPartner C_InvoiceSchedule_ID DEFAULT Adempiere 3.7
C_BPartner C_Location_ID HIDDEN Adempiere 3.7
C_BPartner C_PaymentTerm_ID DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner DeliveryViaRule DEFAULT Adempiere 3.7
C_BPartner Description HIDDEN Adempiere 3.7
C_BPartner DocumentCopies DEFAULT Adempiere 3.7
C_BPartner DunningGrace DEFAULT Adempiere 3.7
C_BPartner DUNS HIDDEN Adempiere 3.7
C_BPartner FirstSale HIDDEN Adempiere 3.7
C_BPartner FlatDiscount DEFAULT Adempiere 3.7
C_BPartner FreightCostRule HIDDEN Adempiere 3.7
C_BPartner Invoice_PrintFormat_ID DEFAULT Adempiere 3.7
C_BPartner InvoiceRule DEFAULT Adempiere 3.7
C_BPartner IsActive DEFAULT Adempiere 3.7
C_BPartner IsCustomer DEFAULT Adempiere 3.7
C_BPartner IsDiscountPrinted DEFAULT Adempiere 3.7
C_BPartner IsEmployee HIDDEN 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 DEFAULT Adempiere 3.7
C_BPartner M_PriceList_ID DEFAULT 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 DEFAULT 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 DEFAULT 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 DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner SO_CreditLimit DEFAULT Adempiere 3.7
C_BPartner SOCreditStatus HIDDEN Adempiere 3.7
C_BPartner SO_CreditUsed DEFAULT Adempiere 3.7
C_BPartner SO_Description DEFAULT 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 HIDDEN 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 HIDDEN 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_BP_Customer_Acct AD_Client_ID DEFAULT Adempiere 3.7
C_BP_Customer_Acct AD_Org_ID DEFAULT Adempiere 3.7
C_BP_Customer_Acct C_AcctSchema_ID DEFAULT Adempiere 3.7
C_BP_Customer_Acct C_BPartner_ID DEFAULT Adempiere 3.7
C_BP_Customer_Acct C_Prepayment_Acct DEFAULT Adempiere 3.7
C_BP_Customer_Acct Created HIDDEN Adempiere 3.7
C_BP_Customer_Acct CreatedBy HIDDEN Adempiere 3.7
C_BP_Customer_Acct C_Receivable_Acct DEFAULT Adempiere 3.7
C_BP_Customer_Acct C_Receivable_Services_Acct DEFAULT Adempiere 3.7
C_BP_Customer_Acct IsActive DEFAULT Adempiere 3.7
C_BP_Customer_Acct Updated HIDDEN Adempiere 3.7
C_BP_Customer_Acct UpdatedBy HIDDEN Adempiere 3.7
C_BPartner AcqusitionCost HIDDEN Adempiere 3.7
C_BPartner ActualLifeTimeValue HIDDEN 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 HIDDEN Adempiere 3.7
C_BPartner IsManufacturer DEFAULT 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 DEFAULT 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 DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner PO_DiscountSchema_ID DEFAULT Adempiere 3.7
C_BPartner PO_PaymentTerm_ID DEFAULT Adempiere 3.7
C_BPartner PO_PriceList_ID DEFAULT 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 HIDDEN 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 HIDDEN 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_BP_Vendor_Acct AD_Client_ID DEFAULT Adempiere 3.7
C_BP_Vendor_Acct AD_Org_ID DEFAULT Adempiere 3.7
C_BP_Vendor_Acct C_AcctSchema_ID DEFAULT Adempiere 3.7
C_BP_Vendor_Acct C_BPartner_ID DEFAULT Adempiere 3.7
C_BP_Vendor_Acct Created HIDDEN Adempiere 3.7
C_BP_Vendor_Acct CreatedBy HIDDEN Adempiere 3.7
C_BP_Vendor_Acct IsActive DEFAULT Adempiere 3.7
C_BP_Vendor_Acct Updated HIDDEN Adempiere 3.7
C_BP_Vendor_Acct UpdatedBy HIDDEN Adempiere 3.7
C_BP_Vendor_Acct V_Liability_Acct DEFAULT Adempiere 3.7
C_BP_Vendor_Acct V_Liability_Services_Acct DEFAULT Adempiere 3.7
C_BP_Vendor_Acct V_Prepayment_Acct DEFAULT Adempiere 3.7
C_BPartner AcqusitionCost HIDDEN Adempiere 3.7
C_BPartner ActualLifeTimeValue HIDDEN 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 DEFAULT 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 HIDDEN 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 HIDDEN 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_BP_Employee_Acct AD_Client_ID DEFAULT Adempiere 3.7
C_BP_Employee_Acct AD_Org_ID DEFAULT Adempiere 3.7
C_BP_Employee_Acct C_AcctSchema_ID DEFAULT Adempiere 3.7
C_BP_Employee_Acct C_BPartner_ID DEFAULT Adempiere 3.7
C_BP_Employee_Acct Created HIDDEN Adempiere 3.7
C_BP_Employee_Acct CreatedBy HIDDEN Adempiere 3.7
C_BP_Employee_Acct E_Expense_Acct DEFAULT Adempiere 3.7
C_BP_Employee_Acct E_Prepayment_Acct DEFAULT Adempiere 3.7
C_BP_Employee_Acct IsActive DEFAULT Adempiere 3.7
C_BP_Employee_Acct Updated HIDDEN Adempiere 3.7
C_BP_Employee_Acct UpdatedBy HIDDEN Adempiere 3.7
C_BP_BankAccount AccountNo DEFAULT Adempiere 3.7
C_BP_BankAccount A_City DEFAULT Adempiere 3.7
C_BP_BankAccount A_Country DEFAULT Adempiere 3.7
C_BP_BankAccount AD_Client_ID DEFAULT Adempiere 3.7
C_BP_BankAccount AD_Org_ID DEFAULT Adempiere 3.7
C_BP_BankAccount AD_User_ID DEFAULT Adempiere 3.7
C_BP_BankAccount A_EMail DEFAULT Adempiere 3.7
C_BP_BankAccount A_Ident_DL DEFAULT Adempiere 3.7
C_BP_BankAccount A_Ident_SSN DEFAULT Adempiere 3.7
C_BP_BankAccount A_Name DEFAULT Adempiere 3.7
C_BP_BankAccount A_State DEFAULT Adempiere 3.7
C_BP_BankAccount A_Street DEFAULT Adempiere 3.7
C_BP_BankAccount A_Zip DEFAULT Adempiere 3.7
C_BP_BankAccount BankAccountType DEFAULT Adempiere 3.7
C_BP_BankAccount BPBankAcctUse DEFAULT Adempiere 3.7
C_BP_BankAccount C_Bank_ID DEFAULT Adempiere 3.7
C_BP_BankAccount C_BPartner_ID DEFAULT Adempiere 3.7
C_BP_BankAccount C_BP_BankAccount_ID HIDDEN Adempiere 3.7
C_BP_BankAccount Created HIDDEN Adempiere 3.7
C_BP_BankAccount CreatedBy HIDDEN Adempiere 3.7
C_BP_BankAccount CreditCardExpMM DEFAULT Adempiere 3.7
C_BP_BankAccount CreditCardExpYY DEFAULT Adempiere 3.7
C_BP_BankAccount CreditCardNumber DEFAULT Adempiere 3.7
C_BP_BankAccount CreditCardType DEFAULT Adempiere 3.7
C_BP_BankAccount CreditCardVV DEFAULT Adempiere 3.7
C_BP_BankAccount IsACH DEFAULT Adempiere 3.7
C_BP_BankAccount IsActive DEFAULT Adempiere 3.7
C_BP_BankAccount R_AvsAddr DEFAULT Adempiere 3.7
C_BP_BankAccount R_AvsZip DEFAULT Adempiere 3.7
C_BP_BankAccount RoutingNo DEFAULT Adempiere 3.7
C_BP_BankAccount UM_BankBranchCode HIDDEN Adempiere 3.7
C_BP_BankAccount UM_BankCode HIDDEN Adempiere 3.7
C_BP_BankAccount Updated HIDDEN Adempiere 3.7
C_BP_BankAccount UpdatedBy HIDDEN Adempiere 3.7
C_BPartner_Location AD_Client_ID DEFAULT Adempiere 3.7
C_BPartner_Location AD_Org_ID DEFAULT Adempiere 3.7
C_BPartner_Location C_BPartner_ID DEFAULT Adempiere 3.7
C_BPartner_Location C_BPartner_Location_ID DEFAULT 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 DEFAULT Adempiere 3.7
C_BPartner_Location Fax DEFAULT Adempiere 3.7
C_BPartner_Location IsActive DEFAULT Adempiere 3.7
C_BPartner_Location IsBillTo DEFAULT Adempiere 3.7
C_BPartner_Location IsDefault HIDDEN Adempiere 3.7
C_BPartner_Location ISDN DEFAULT Adempiere 3.7
C_BPartner_Location IsPayFrom DEFAULT Adempiere 3.7
C_BPartner_Location IsRemitTo DEFAULT Adempiere 3.7
C_BPartner_Location IsShipTo DEFAULT Adempiere 3.7
C_BPartner_Location Name DEFAULT Adempiere 3.7
C_BPartner_Location Phone DEFAULT Adempiere 3.7
C_BPartner_Location Phone2 DEFAULT Adempiere 3.7
C_BPartner_Location Updated HIDDEN Adempiere 3.7
C_BPartner_Location UpdatedBy HIDDEN Adempiere 3.7
AD_User AD_Client_ID DEFAULT Adempiere 3.7
AD_User AD_Org_ID DEFAULT 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 DEFAULT Adempiere 3.7
AD_User C_Greeting_ID DEFAULT Adempiere 3.7
AD_User C_Job_ID DEFAULT Adempiere 3.7
AD_User C_Location_ID HIDDEN Adempiere 3.7
AD_User Comments DEFAULT 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 DEFAULT 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 DEFAULT Adempiere 3.7
AD_User EMailVerifyDate DEFAULT Adempiere 3.7
AD_User Fax DEFAULT Adempiere 3.7
AD_User IsActive DEFAULT Adempiere 3.7
AD_User IsDefault HIDDEN Adempiere 3.7
AD_User IsFullBPAccess DEFAULT Adempiere 3.7
AD_User IsInPayroll HIDDEN Adempiere 3.7
AD_User IsSalesRep HIDDEN Adempiere 3.7
AD_User LastContact DEFAULT Adempiere 3.7
AD_User LastResult DEFAULT 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 DEFAULT 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 DEFAULT 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
AD_UserBPAccess AD_Client_ID DEFAULT Adempiere 3.7
AD_UserBPAccess AD_Org_ID DEFAULT Adempiere 3.7
AD_UserBPAccess AD_UserBPAccess_ID HIDDEN Adempiere 3.7
AD_UserBPAccess AD_User_ID DEFAULT Adempiere 3.7
AD_UserBPAccess BPAccessType DEFAULT Adempiere 3.7
AD_UserBPAccess Created HIDDEN Adempiere 3.7
AD_UserBPAccess CreatedBy HIDDEN Adempiere 3.7
AD_UserBPAccess DocBaseType DEFAULT Adempiere 3.7
AD_UserBPAccess IsActive DEFAULT Adempiere 3.7
AD_UserBPAccess R_RequestType_ID DEFAULT Adempiere 3.7
AD_UserBPAccess Updated HIDDEN Adempiere 3.7
AD_UserBPAccess UpdatedBy HIDDEN Adempiere 3.7
R_ContactInterest AD_Client_ID DEFAULT Adempiere 3.7
R_ContactInterest AD_Org_ID DEFAULT Adempiere 3.7
R_ContactInterest AD_User_ID DEFAULT Adempiere 3.7
R_ContactInterest Created HIDDEN Adempiere 3.7
R_ContactInterest CreatedBy HIDDEN Adempiere 3.7
R_ContactInterest IsActive DEFAULT Adempiere 3.7
R_ContactInterest OptOutDate DEFAULT Adempiere 3.7
R_ContactInterest R_InterestArea_ID DEFAULT Adempiere 3.7
R_ContactInterest SubscribeDate DEFAULT Adempiere 3.7
R_ContactInterest Updated HIDDEN Adempiere 3.7
R_ContactInterest UpdatedBy HIDDEN Adempiere 3.7

Invoice (Vendor)

The Vendor Invoice Window allows you to display and enter Invoices from a Vendor. Vendor Invoices can also be generated from Purchase Orders or Delivery Receipts.

Table Name DB Field Name Super Store Work Edition
C_Invoice AD_Client_ID HIDDEN Adempiere 3.7
C_Invoice AD_Org_ID HIDDEN Adempiere 3.7
C_Invoice AD_OrgTrx_ID HIDDEN Adempiere 3.7
C_Invoice AD_User_ID DEFAULT Adempiere 3.7
C_Invoice C_Activity_ID HIDDEN Adempiere 3.7
C_Invoice C_BPartner_ID DEFAULT Adempiere 3.7
C_Invoice C_BPartner_Location_ID DEFAULT Adempiere 3.7
C_Invoice C_Campaign_ID HIDDEN Adempiere 3.7
C_Invoice C_CashLine_ID HIDDEN Adempiere 3.7
C_Invoice C_Charge_ID HIDDEN Adempiere 3.7
C_Invoice C_ConversionType_ID HIDDEN Adempiere 3.7
C_Invoice C_Currency_ID DEFAULT Adempiere 3.7
C_Invoice C_DocType_ID HIDDEN Adempiere 3.7
C_Invoice C_DocTypeTarget_ID DEFAULT Adempiere 3.7
C_Invoice C_DunningLevel_ID HIDDEN Adempiere 3.7
C_Invoice ChargeAmt HIDDEN Adempiere 3.7
C_Invoice C_Invoice_ID HIDDEN Adempiere 3.7
C_Invoice CopyFrom HIDDEN Adempiere 3.7
C_Invoice C_Order_ID HIDDEN Adempiere 3.7
C_Invoice C_Payment_ID HIDDEN Adempiere 3.7
C_Invoice C_PaymentTerm_ID DEFAULT Adempiere 3.7
C_Invoice C_POS_ID HIDDEN Adempiere 3.7
C_Invoice C_Project_ID HIDDEN Adempiere 3.7
C_Invoice Created HIDDEN Adempiere 3.7
C_Invoice CreatedBy HIDDEN Adempiere 3.7
C_Invoice CreateFrom HIDDEN Adempiere 3.7
C_Invoice DateAcct HIDDEN Adempiere 3.7
C_Invoice DateFrom DEFAULT Adempiere 3.7
C_Invoice DateInvoiced DEFAULT Adempiere 3.7
C_Invoice DateOrdered HIDDEN Adempiere 3.7
C_Invoice DatePrinted HIDDEN Adempiere 3.7
C_Invoice DateTo DEFAULT Adempiere 3.7
C_Invoice Description DEFAULT Adempiere 3.7
C_Invoice DocAction DEFAULT Adempiere 3.7
C_Invoice DocStatus DEFAULT Adempiere 3.7
C_Invoice DocumentNo DEFAULT Adempiere 3.7
C_Invoice DunningGrace HIDDEN Adempiere 3.7
C_Invoice GenerateTo HIDDEN Adempiere 3.7
C_Invoice GrandTotal DEFAULT Adempiere 3.7
C_Invoice InvoiceCollectionType HIDDEN Adempiere 3.7
C_Invoice IsActive HIDDEN Adempiere 3.7
C_Invoice IsApproved HIDDEN Adempiere 3.7
C_Invoice IsDiscountPrinted HIDDEN Adempiere 3.7
C_Invoice IsInDispute HIDDEN Adempiere 3.7
C_Invoice IsPaid HIDDEN Adempiere 3.7
C_Invoice IsPayScheduleValid HIDDEN Adempiere 3.7
C_Invoice IsPrinted HIDDEN Adempiere 3.7
C_Invoice IsSelfService HIDDEN Adempiere 3.7
C_Invoice IsSOTrx HIDDEN Adempiere 3.7
C_Invoice IsTaxIncluded HIDDEN Adempiere 3.7
C_Invoice IsTransferred HIDDEN Adempiere 3.7
C_Invoice M_PriceList_ID DEFAULT Adempiere 3.7
C_Invoice M_RMA_ID HIDDEN Adempiere 3.7
C_Invoice PaymentRule HIDDEN Adempiere 3.7
C_Invoice POReference DEFAULT Adempiere 3.7
C_Invoice Posted DEFAULT Adempiere 3.7
C_Invoice Processed HIDDEN Adempiere 3.7
C_Invoice ProcessedOn HIDDEN Adempiere 3.7
C_Invoice Processing HIDDEN Adempiere 3.7
C_Invoice Ref_Invoice_ID HIDDEN Adempiere 3.7
C_Invoice Reversal_ID HIDDEN Adempiere 3.7
C_Invoice SalesRep_ID DEFAULT Adempiere 3.7
C_Invoice SendEMail HIDDEN Adempiere 3.7
C_Invoice terminal HIDDEN Adempiere 3.7
C_Invoice TotalLines DEFAULT Adempiere 3.7
C_Invoice TotalQty HIDDEN Adempiere 3.7
C_Invoice UM_AdditionDeductionAmt ADDED Adempiere 3.7
C_Invoice UM_BasicCostTotal ADDED Adempiere 3.7
C_Invoice um_bill_amount HIDDEN Adempiere 3.7
C_Invoice UM_BillDate ADDED Adempiere 3.7
C_Invoice UM_BillNo ADDED Adempiere 3.7
C_Invoice UM_BonusPoints HIDDEN Adempiere 3.7
C_Invoice UM_CashDisTotal ADDED Adempiere 3.7
C_Invoice UM_CessTotal ADDED Adempiere 3.7
C_Invoice UM_DiscountTotal ADDED Adempiere 3.7
C_Invoice UM_DuplicateCopy HIDDEN Adempiere 3.7
C_Invoice UM_IsDoorDelivery HIDDEN Adempiere 3.7
C_Invoice UM_IsRefund HIDDEN Adempiere 3.7
C_Invoice UM_NetCostTotal ADDED Adempiere 3.7
C_Invoice UM_OfflineDocNo HIDDEN Adempiere 3.7
C_Invoice UM_Reason ADDED Adempiere 3.7
C_Invoice UM_RefundCopy HIDDEN Adempiere 3.7
C_Invoice UM_RewardPoint HIDDEN Adempiere 3.7
C_Invoice UM_RewardPointUsage_ID HIDDEN Adempiere 3.7
C_Invoice um_round_off HIDDEN Adempiere 3.7
C_Invoice UM_Save HIDDEN Adempiere 3.7
C_Invoice UM_SchemeDiscountTotal ADDED Adempiere 3.7
C_Invoice UM_TokenNo HIDDEN Adempiere 3.7
C_Invoice UM_VATTotal ADDED Adempiere 3.7
C_Invoice Updated HIDDEN Adempiere 3.7
C_Invoice UpdatedBy HIDDEN Adempiere 3.7
C_Invoice User1_ID HIDDEN Adempiere 3.7
C_Invoice User2_ID HIDDEN Adempiere 3.7
C_Invoice Weight HIDDEN Adempiere 3.7
C_InvoiceLine A_Asset_Group_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_Asset_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_CapvsExp HIDDEN Adempiere 3.7
C_InvoiceLine A_CreateAsset HIDDEN Adempiere 3.7
C_InvoiceLine AD_Client_ID HIDDEN Adempiere 3.7
C_InvoiceLine AD_Org_ID HIDDEN Adempiere 3.7
C_InvoiceLine AD_OrgTrx_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_Processed HIDDEN Adempiere 3.7
C_InvoiceLine C_Activity_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Campaign_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Charge_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Invoice_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_InvoiceLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_OrderLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Project_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_ProjectPhase_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_ProjectTask_ID HIDDEN Adempiere 3.7
C_InvoiceLine Created HIDDEN Adempiere 3.7
C_InvoiceLine CreatedBy HIDDEN Adempiere 3.7
C_InvoiceLine C_Tax_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_UOM_ID DEFAULT Adempiere 3.7
C_InvoiceLine Description HIDDEN Adempiere 3.7
C_InvoiceLine IsActive HIDDEN Adempiere 3.7
C_InvoiceLine IsDescription HIDDEN Adempiere 3.7
C_InvoiceLine IsPrinted HIDDEN Adempiere 3.7
C_InvoiceLine Line DEFAULT Adempiere 3.7
C_InvoiceLine LineNetAmt DEFAULT Adempiere 3.7
C_InvoiceLine LineTotalAmt HIDDEN Adempiere 3.7
C_InvoiceLine M_AttributeSetInstance_ID HIDDEN Adempiere 3.7
C_InvoiceLine M_InOutLine_ID DEFAULT Adempiere 3.7
C_InvoiceLine M_Product_ID DEFAULT Adempiere 3.7
C_InvoiceLine M_RMALine_ID HIDDEN Adempiere 3.7
C_InvoiceLine Name DEFAULT Adempiere 3.7
C_InvoiceLine PriceActual HIDDEN Adempiere 3.7
C_InvoiceLine PriceEntered HIDDEN Adempiere 3.7
C_InvoiceLine PriceLimit HIDDEN Adempiere 3.7
C_InvoiceLine PriceList HIDDEN Adempiere 3.7
C_InvoiceLine Processed HIDDEN Adempiere 3.7
C_InvoiceLine QtyEntered DEFAULT Adempiere 3.7
C_InvoiceLine QtyInvoiced HIDDEN Adempiere 3.7
C_InvoiceLine Ref_InvoiceLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine RRAmt HIDDEN Adempiere 3.7
C_InvoiceLine RRStartDate HIDDEN Adempiere 3.7
C_InvoiceLine S_ResourceAssignment_ID HIDDEN Adempiere 3.7
C_InvoiceLine TaxAmt HIDDEN Adempiere 3.7
C_InvoiceLine UM_BasicCost ADDED Adempiere 3.7
C_InvoiceLine UM_BasicCostTotal ADDED Adempiere 3.7
C_InvoiceLine UM_CaseQty ADDED Adempiere 3.7
C_InvoiceLine UM_CashDisTotal ADDED Adempiere 3.7
C_InvoiceLine UM_CessAmt HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTaxCategory_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTax_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTotal ADDED Adempiere 3.7
C_InvoiceLine UM_CommodityCode_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_DiscountTotal ADDED Adempiere 3.7
C_InvoiceLine UM_IsCrossPromotion HIDDEN Adempiere 3.7
C_InvoiceLine UM_IsExchange HIDDEN Adempiere 3.7
C_InvoiceLine UM_IsFreeItem ADDED Adempiere 3.7
C_InvoiceLine UM_MRP HIDDEN Adempiere 3.7
C_InvoiceLine UM_NetCostTotal ADDED Adempiere 3.7
C_InvoiceLine UM_PieceQty ADDED Adempiere 3.7
C_InvoiceLine UM_SchemeDiscountTotal ADDED Adempiere 3.7
C_InvoiceLine UM_VATTotal ADDED Adempiere 3.7
C_InvoiceLine Updated HIDDEN Adempiere 3.7
C_InvoiceLine UpdatedBy HIDDEN Adempiere 3.7
C_InvoiceLine User1_ID HIDDEN Adempiere 3.7
C_InvoiceLine User2_ID HIDDEN Adempiere 3.7
C_InvoiceLine Value DEFAULT Adempiere 3.7
C_InvoiceLine A_Asset_Group_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_Asset_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_CapvsExp HIDDEN Adempiere 3.7
C_InvoiceLine A_CreateAsset HIDDEN Adempiere 3.7
C_InvoiceLine AD_Client_ID HIDDEN Adempiere 3.7
C_InvoiceLine AD_Org_ID HIDDEN Adempiere 3.7
C_InvoiceLine AD_OrgTrx_ID HIDDEN Adempiere 3.7
C_InvoiceLine A_Processed HIDDEN Adempiere 3.7
C_InvoiceLine C_Activity_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Campaign_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Charge_ID DEFAULT Adempiere 3.7
C_InvoiceLine C_Invoice_ID DEFAULT Adempiere 3.7
C_InvoiceLine C_InvoiceLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_OrderLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_Project_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_ProjectPhase_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_ProjectTask_ID HIDDEN Adempiere 3.7
C_InvoiceLine Created HIDDEN Adempiere 3.7
C_InvoiceLine CreatedBy HIDDEN Adempiere 3.7
C_InvoiceLine C_Tax_ID HIDDEN Adempiere 3.7
C_InvoiceLine C_UOM_ID HIDDEN Adempiere 3.7
C_InvoiceLine Description DEFAULT Adempiere 3.7
C_InvoiceLine IsActive HIDDEN Adempiere 3.7
C_InvoiceLine IsDescription HIDDEN Adempiere 3.7
C_InvoiceLine IsPrinted HIDDEN Adempiere 3.7
C_InvoiceLine Line HIDDEN Adempiere 3.7
C_InvoiceLine LineNetAmt DEFAULT Adempiere 3.7
C_InvoiceLine LineTotalAmt HIDDEN Adempiere 3.7
C_InvoiceLine M_AttributeSetInstance_ID DEFAULT Adempiere 3.7
C_InvoiceLine M_InOutLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine M_Product_ID DEFAULT Adempiere 3.7
C_InvoiceLine M_RMALine_ID HIDDEN Adempiere 3.7
C_InvoiceLine Name HIDDEN Adempiere 3.7
C_InvoiceLine PriceActual HIDDEN Adempiere 3.7
C_InvoiceLine PriceEntered DEFAULT Adempiere 3.7
C_InvoiceLine PriceLimit HIDDEN Adempiere 3.7
C_InvoiceLine PriceList HIDDEN Adempiere 3.7
C_InvoiceLine Processed HIDDEN Adempiere 3.7
C_InvoiceLine QtyEntered DEFAULT Adempiere 3.7
C_InvoiceLine QtyInvoiced HIDDEN Adempiere 3.7
C_InvoiceLine Ref_InvoiceLine_ID HIDDEN Adempiere 3.7
C_InvoiceLine RRAmt HIDDEN Adempiere 3.7
C_InvoiceLine RRStartDate HIDDEN Adempiere 3.7
C_InvoiceLine S_ResourceAssignment_ID HIDDEN Adempiere 3.7
C_InvoiceLine TaxAmt HIDDEN Adempiere 3.7
C_InvoiceLine UM_BasicCost HIDDEN Adempiere 3.7
C_InvoiceLine UM_BasicCostTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_CaseQty HIDDEN Adempiere 3.7
C_InvoiceLine UM_CashDisTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessAmt HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTaxCategory_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTax_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_CessTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_CommodityCode_ID HIDDEN Adempiere 3.7
C_InvoiceLine UM_DiscountTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_IsCrossPromotion HIDDEN Adempiere 3.7
C_InvoiceLine UM_IsExchange HIDDEN Adempiere 3.7
C_InvoiceLine UM_IsFreeItem HIDDEN Adempiere 3.7
C_InvoiceLine UM_MRP HIDDEN Adempiere 3.7
C_InvoiceLine UM_NetCostTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_PieceQty HIDDEN Adempiere 3.7
C_InvoiceLine UM_SchemeDiscountTotal HIDDEN Adempiere 3.7
C_InvoiceLine UM_VATTotal HIDDEN Adempiere 3.7
C_InvoiceLine Updated HIDDEN Adempiere 3.7
C_InvoiceLine UpdatedBy HIDDEN Adempiere 3.7
C_InvoiceLine User1_ID HIDDEN Adempiere 3.7
C_InvoiceLine User2_ID HIDDEN Adempiere 3.7
C_InvoiceLine Value HIDDEN Adempiere 3.7