Customer

Customer

Sales Rep

This screen is used for managing the Sales Rep who are employed with the Company. These Sales Rep can be mapped to specific Customers and their information will be captured during Sales Transactions when the specific customer purchases goods from the Company.

Table Name DB Field Name Super Store Work Edition
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 HIDDEN Adempiere 3.7
AD_User C_BPartner_ID HIDDEN 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 HIDDEN Adempiere 3.7
AD_User C_Location_ID DEFAULT 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 DEFAULT Adempiere 3.7
AD_User EMail HIDDEN 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 HIDDEN 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 ADDED 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 HIDDEN Adempiere 3.7
AD_User Password HIDDEN Adempiere 3.7
AD_User Phone DEFAULT Adempiere 3.7
AD_User Phone2 HIDDEN 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 DEFAULT Adempiere 3.7

 

Sales Rep Info

This window allows you to view Sales Rep related information.

Table Name DB Field Name Super Store Work Edition
AD_User AD_Client_ID DEFAULT Adempiere 3.7
AD_User AD_Org_ID DEFAULT Adempiere 3.7
AD_User AD_OrgTrx_ID DEFAULT Adempiere 3.7
AD_User AD_User_ID DEFAULT 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 HIDDEN Adempiere 3.7
AD_User C_Job_ID HIDDEN 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 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 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 HIDDEN Adempiere 3.7
AD_User Password HIDDEN Adempiere 3.7
AD_User Phone HIDDEN Adempiere 3.7
AD_User Phone2 HIDDEN 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 ADDED, 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

 

Orders

List of Sales Orders where this Sales Rep is involved or part of

Table Name DB Field Name Super Store Work Edition
C_Order AD_Client_ID DEFAULT Adempiere 3.7
C_Order AD_Org_ID DEFAULT Adempiere 3.7
C_Order AD_OrgTrx_ID DEFAULT Adempiere 3.7
C_Order AD_User_ID DEFAULT Adempiere 3.7
C_Order AmountRefunded HIDDEN Adempiere 3.7
C_Order AmountTendered HIDDEN Adempiere 3.7
C_Order Bill_BPartner_ID DEFAULT Adempiere 3.7
C_Order Bill_Location_ID DEFAULT Adempiere 3.7
C_Order Bill_User_ID DEFAULT Adempiere 3.7
C_Order C_Activity_ID DEFAULT Adempiere 3.7
C_Order C_BPartner_ID DEFAULT Adempiere 3.7
C_Order C_BPartner_Location_ID DEFAULT Adempiere 3.7
C_Order C_Campaign_ID DEFAULT Adempiere 3.7
C_Order C_CashLine_ID DEFAULT Adempiere 3.7
C_Order C_Charge_ID DEFAULT Adempiere 3.7
C_Order C_ConversionType_ID DEFAULT Adempiere 3.7
C_Order C_Currency_ID DEFAULT Adempiere 3.7
C_Order C_DocType_ID DEFAULT Adempiere 3.7
C_Order C_DocTypeTarget_ID DEFAULT Adempiere 3.7
C_Order ChargeAmt DEFAULT Adempiere 3.7
C_Order CopyFrom DEFAULT Adempiere 3.7
C_Order C_Order_ID DEFAULT Adempiere 3.7
C_Order C_OrderSource_ID HIDDEN Adempiere 3.7
C_Order C_Payment_ID DEFAULT Adempiere 3.7
C_Order C_PaymentTerm_ID DEFAULT Adempiere 3.7
C_Order C_POS_ID HIDDEN Adempiere 3.7
C_Order C_Project_ID DEFAULT Adempiere 3.7
C_Order Created HIDDEN Adempiere 3.7
C_Order CreatedBy HIDDEN Adempiere 3.7
C_Order DateAcct DEFAULT Adempiere 3.7
C_Order DateOrdered DEFAULT Adempiere 3.7
C_Order DatePrinted DEFAULT Adempiere 3.7
C_Order DatePromised DEFAULT Adempiere 3.7
C_Order DeliveryRule DEFAULT Adempiere 3.7
C_Order DeliveryViaRule DEFAULT Adempiere 3.7
C_Order Description DEFAULT Adempiere 3.7
C_Order DocAction DEFAULT Adempiere 3.7
C_Order DocStatus DEFAULT Adempiere 3.7
C_Order DocumentNo DEFAULT Adempiere 3.7
C_Order DropShip_BPartner_ID HIDDEN Adempiere 3.7
C_Order DropShip_Location_ID HIDDEN Adempiere 3.7
C_Order DropShip_User_ID HIDDEN Adempiere 3.7
C_Order FreightAmt DEFAULT Adempiere 3.7
C_Order FreightCostRule DEFAULT Adempiere 3.7
C_Order GrandTotal DEFAULT Adempiere 3.7
C_Order InvoiceRule DEFAULT Adempiere 3.7
C_Order IsActive DEFAULT Adempiere 3.7
C_Order IsApproved DEFAULT Adempiere 3.7
C_Order IsCreditApproved DEFAULT Adempiere 3.7
C_Order IsDelivered DEFAULT Adempiere 3.7
C_Order IsDiscountPrinted DEFAULT Adempiere 3.7
C_Order IsDropShip DEFAULT Adempiere 3.7
C_Order IsInvoiced DEFAULT Adempiere 3.7
C_Order IsPrinted DEFAULT Adempiere 3.7
C_Order IsSelected DEFAULT Adempiere 3.7
C_Order IsSelfService DEFAULT Adempiere 3.7
C_Order IsSOTrx DEFAULT Adempiere 3.7
C_Order IsTaxIncluded DEFAULT Adempiere 3.7
C_Order IsTransferred DEFAULT Adempiere 3.7
C_Order Link_Order_ID HIDDEN Adempiere 3.7
C_Order M_FreightCategory_ID HIDDEN Adempiere 3.7
C_Order M_PriceList_ID DEFAULT Adempiere 3.7
C_Order M_Shipper_ID DEFAULT Adempiere 3.7
C_Order M_Warehouse_ID DEFAULT Adempiere 3.7
C_Order OrderType HIDDEN Adempiere 3.7
C_Order Pay_BPartner_ID DEFAULT Adempiere 3.7
C_Order Pay_Location_ID DEFAULT Adempiere 3.7
C_Order PaymentRule DEFAULT Adempiere 3.7
C_Order POReference DEFAULT Adempiere 3.7
C_Order Posted DEFAULT Adempiere 3.7
C_Order PriorityRule DEFAULT Adempiere 3.7
C_Order Processed DEFAULT Adempiere 3.7
C_Order ProcessedOn HIDDEN Adempiere 3.7
C_Order Processing DEFAULT Adempiere 3.7
C_Order PromotionCode HIDDEN Adempiere 3.7
C_Order Ref_Order_ID DEFAULT Adempiere 3.7
C_Order SalesRep_ID DEFAULT Adempiere 3.7
C_Order SearchProduct HIDDEN Adempiere 3.7
C_Order SendEMail DEFAULT Adempiere 3.7
C_Order TotalLines DEFAULT Adempiere 3.7
C_Order TotalQty HIDDEN Adempiere 3.7
C_Order UM_BonusPoints HIDDEN Adempiere 3.7
C_Order UM_CessTotal HIDDEN Adempiere 3.7
C_Order UM_IsDoorDelivery HIDDEN Adempiere 3.7
C_Order UM_IsRefund HIDDEN Adempiere 3.7
C_Order UM_RewardPointUsage_ID HIDDEN Adempiere 3.7
C_Order UM_Save HIDDEN Adempiere 3.7
C_Order Updated HIDDEN Adempiere 3.7
C_Order UpdatedBy HIDDEN Adempiere 3.7
C_Order User1_ID DEFAULT Adempiere 3.7
C_Order User2_ID DEFAULT Adempiere 3.7
C_Order Volume HIDDEN Adempiere 3.7
C_Order Weight HIDDEN Adempiere 3.7

Order Lines

List of Item Details for the specific order in which this Sales Rep is part of

Table Name DB Field Name Super Store Work Edition
C_OrderLine AD_Client_ID DEFAULT Adempiere 3.7
C_OrderLine AD_Org_ID DEFAULT Adempiere 3.7
C_OrderLine AD_OrgTrx_ID HIDDEN Adempiere 3.7
C_OrderLine C_Activity_ID HIDDEN Adempiere 3.7
C_OrderLine C_BPartner_ID DEFAULT Adempiere 3.7
C_OrderLine C_BPartner_Location_ID DEFAULT Adempiere 3.7
C_OrderLine C_Campaign_ID HIDDEN Adempiere 3.7
C_OrderLine C_Charge_ID HIDDEN Adempiere 3.7
C_OrderLine C_Currency_ID DEFAULT Adempiere 3.7
C_OrderLine C_Order_ID DEFAULT Adempiere 3.7
C_OrderLine C_OrderLine_ID HIDDEN Adempiere 3.7
C_OrderLine C_Project_ID HIDDEN Adempiere 3.7
C_OrderLine C_ProjectPhase_ID HIDDEN Adempiere 3.7
C_OrderLine C_ProjectTask_ID HIDDEN Adempiere 3.7
C_OrderLine Created HIDDEN Adempiere 3.7
C_OrderLine CreatedBy HIDDEN Adempiere 3.7
C_OrderLine C_Tax_ID DEFAULT Adempiere 3.7
C_OrderLine C_UOM_ID HIDDEN Adempiere 3.7
C_OrderLine DateDelivered DEFAULT Adempiere 3.7
C_OrderLine DateInvoiced DEFAULT Adempiere 3.7
C_OrderLine DateOrdered DEFAULT Adempiere 3.7
C_OrderLine DatePromised DEFAULT Adempiere 3.7
C_OrderLine Description DEFAULT Adempiere 3.7
C_OrderLine Discount DEFAULT Adempiere 3.7
C_OrderLine FreightAmt HIDDEN Adempiere 3.7
C_OrderLine IsActive HIDDEN Adempiere 3.7
C_OrderLine IsDescription DEFAULT Adempiere 3.7
C_OrderLine Line DEFAULT Adempiere 3.7
C_OrderLine LineNetAmt DEFAULT Adempiere 3.7
C_OrderLine Link_OrderLine_ID HIDDEN Adempiere 3.7
C_OrderLine Margin HIDDEN Adempiere 3.7
C_OrderLine M_AttributeSetInstance_ID DEFAULT Adempiere 3.7
C_OrderLine M_Product_ID DEFAULT Adempiere 3.7
C_OrderLine M_Promotion_ID HIDDEN Adempiere 3.7
C_OrderLine M_Shipper_ID HIDDEN Adempiere 3.7
C_OrderLine M_Warehouse_ID DEFAULT Adempiere 3.7
C_OrderLine Name HIDDEN Adempiere 3.7
C_OrderLine PP_Cost_Collector_ID HIDDEN Adempiere 3.7
C_OrderLine PriceActual DEFAULT Adempiere 3.7
C_OrderLine PriceCost HIDDEN Adempiere 3.7
C_OrderLine PriceEntered HIDDEN Adempiere 3.7
C_OrderLine PriceLimit HIDDEN Adempiere 3.7
C_OrderLine PriceList DEFAULT Adempiere 3.7
C_OrderLine Processed HIDDEN Adempiere 3.7
C_OrderLine QtyDelivered DEFAULT Adempiere 3.7
C_OrderLine QtyEntered HIDDEN Adempiere 3.7
C_OrderLine QtyInvoiced DEFAULT Adempiere 3.7
C_OrderLine QtyLostSales HIDDEN Adempiere 3.7
C_OrderLine QtyOnHand HIDDEN Adempiere 3.7
C_OrderLine QtyOrdered DEFAULT Adempiere 3.7
C_OrderLine QtyReserved DEFAULT Adempiere 3.7
C_OrderLine Ref_OrderLine_ID HIDDEN Adempiere 3.7
C_OrderLine RRAmt HIDDEN Adempiere 3.7
C_OrderLine RRStartDate HIDDEN Adempiere 3.7
C_OrderLine S_ResourceAssignment_ID DEFAULT Adempiere 3.7
C_OrderLine UM_BasicCost ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_BasicCostTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_BefLandCost ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CaseQty ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CashDisPer ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CashDisValue ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CessAmt ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CessTaxCategory_ID ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CessTax_ID ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CessTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CGST ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_CommodityCode_ID ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_Discount ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_DiscountAmt ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_DiscountTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_GKM ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_GrossCost1 ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_GrossCost2 ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_IGST ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_IsCrossPromotion ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_IsExchange ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_IsWBarcode ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_MarkDown ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_MarkUp ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_MRP ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_NetCost ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_NetCostTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_PieceQty ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_PrevOrderQty ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_Promotion_ID ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_PurchaseTaxCategory_ID ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_PurchaseVATAmt ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SchemeDiscount ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SchemeDiscountAmt ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SchemeDiscountTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SellingMargin ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SellingMarginMRP ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SellingMarginNC ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SellingMarginType ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SellingPrice ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_SGST ADDED, HIDDEN Adempiere 3.7
C_OrderLine UM_VATTotal ADDED, HIDDEN Adempiere 3.7
C_OrderLine UPC ADDED, HIDDEN Adempiere 3.7
C_OrderLine Updated HIDDEN Adempiere 3.7
C_OrderLine UpdatedBy HIDDEN Adempiere 3.7
C_OrderLine User1_ID HIDDEN Adempiere 3.7
C_OrderLine User2_ID HIDDEN Adempiere 3.7
C_OrderLine Value HIDDEN Adempiere 3.7

 

Invoices

List of Invoices in which the sales rep is involved/part of

Table Name DB Field Name Super Store Work Edition
C_Invoice AD_Client_ID DEFAULT Adempiere 3.7
C_Invoice AD_Org_ID DEFAULT Adempiere 3.7
C_Invoice AD_OrgTrx_ID HIDDEN Adempiere 3.7
C_Invoice AD_User_ID HIDDEN 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 DEFAULT Adempiere 3.7
C_Invoice C_DocTypeTarget_ID HIDDEN 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 DEFAULT 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 DEFAULT 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 DEFAULT Adempiere 3.7
C_Invoice DateFrom HIDDEN Adempiere 3.7
C_Invoice DateInvoiced DEFAULT Adempiere 3.7
C_Invoice DateOrdered DEFAULT Adempiere 3.7
C_Invoice DatePrinted DEFAULT Adempiere 3.7
C_Invoice DateTo HIDDEN Adempiere 3.7
C_Invoice Description DEFAULT Adempiere 3.7
C_Invoice DocAction HIDDEN 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 DEFAULT Adempiere 3.7
C_Invoice IsPaid DEFAULT Adempiere 3.7
C_Invoice IsPayScheduleValid HIDDEN Adempiere 3.7
C_Invoice IsPrinted HIDDEN Adempiere 3.7
C_Invoice IsSelfService DEFAULT Adempiere 3.7
C_Invoice IsSOTrx DEFAULT 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 DEFAULT Adempiere 3.7
C_Invoice POReference DEFAULT Adempiere 3.7
C_Invoice Posted HIDDEN 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 HIDDEN Adempiere 3.7
C_Invoice UM_BasicCostTotal HIDDEN Adempiere 3.7
C_Invoice um_bill_amount HIDDEN Adempiere 3.7
C_Invoice UM_BillDate HIDDEN Adempiere 3.7
C_Invoice UM_BillNo HIDDEN Adempiere 3.7
C_Invoice UM_BonusPoints HIDDEN Adempiere 3.7
C_Invoice UM_CashDisTotal HIDDEN Adempiere 3.7
C_Invoice UM_CessTotal HIDDEN Adempiere 3.7
C_Invoice UM_DiscountTotal HIDDEN 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 HIDDEN Adempiere 3.7
C_Invoice UM_OfflineDocNo HIDDEN Adempiere 3.7
C_Invoice UM_Reason HIDDEN 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 HIDDEN Adempiere 3.7
C_Invoice UM_TokenNo HIDDEN Adempiere 3.7
C_Invoice UM_VATTotal HIDDEN 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

Invoice Lines

List of Invoices Line Item in which the sales rep is involved/part of

Table Name DB Field Name Super Store Work Edition
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 DEFAULT Adempiere 3.7
C_InvoiceLine AD_Org_ID DEFAULT 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 DEFAULT 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 DEFAULT 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 DEFAULT 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 DEFAULT Adempiere 3.7
C_InvoiceLine PriceEntered HIDDEN Adempiere 3.7
C_InvoiceLine PriceLimit HIDDEN Adempiere 3.7
C_InvoiceLine PriceList DEFAULT Adempiere 3.7
C_InvoiceLine Processed HIDDEN Adempiere 3.7
C_InvoiceLine QtyEntered HIDDEN Adempiere 3.7
C_InvoiceLine QtyInvoiced DEFAULT 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 DEFAULT Adempiere 3.7
C_InvoiceLine TaxAmt DEFAULT 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