View idempiere11.adempiere.rv_c_invoiceline
InvoiceLine

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_invoice_id numeric 10  √  null Invoice Identifier
salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bp_group_id numeric 10  √  null Business Partner Group
m_product_id numeric 10  √  null Product, Service, Item
m_product_category_id numeric 10  √  null Category of a Product
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateacct timestamp 29,6  √  null Accounting Date
issotrx bpchar 1  √  null This is a Sales Transaction
c_doctype_id numeric 10  √  null Document type or rules
docstatus bpchar 2  √  null The current status of the document
ispaid bpchar 1  √  null The document is fully paid
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
c_projectphase_id numeric 10  √  null Phase of a Project
c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
qtyinvoiced numeric 0  √  null Invoiced Quantity
qtyentered numeric 0  √  null The Quantity Entered is based on the selected UoM
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
productattribute varchar 2147483647  √  null Product Attribute Instance Description
m_attributeset_id numeric 10  √  null Product Attribute Set
m_lot_id numeric 10  √  null Product Lot Definition
guaranteedate timestamp 29,6  √  null Date when guarantee expires
lot varchar 40  √  null Lot number (alphanumeric)
serno varchar 40  √  null Product Serial Number
pricelist numeric 0  √  null List Price
priceactual numeric 0  √  null Actual Price
pricelimit numeric 0  √  null Lowest price for a product
priceentered numeric 0  √  null Price Entered - the price based on the selected/base UoM
discount numeric 0  √  null Discount in percent
margin numeric 0  √  null Margin for a product as a percentage
marginamt numeric 0  √  null Difference between actual and limit price multiplied by the quantity
linenetamt numeric 0  √  null Line Extended Amount (Quantity * Actual Price) without Freight and Charges
linelistamt numeric 0  √  null Line List Amount
linelimitamt numeric 0  √  null Line Limit Amount
linediscountamt numeric 0  √  null Line Discount Amount
lineoverlimitamt numeric 0  √  null Gross Margin
ad_orgtrx_id numeric 10  √  null Performing or initiating organization
a_processed bpchar 1  √  null Processed
c_charge_id numeric 10  √  null Additional document charges
c_orderline_id numeric 10  √  null Sales Order Line
c_tax_id numeric 10  √  null Tax identifier
c_invoiceline_c_uom_id numeric 10  √  null c_invoiceline_c_uom_id
c_invoiceline_description varchar 255  √  null c_invoiceline_description
isdescription bpchar 1  √  null if true, the line is just description and no transaction
isprinted bpchar 1  √  null Indicates if this document / line is printed
line numeric 10  √  null Unique line for this document
c_invoiceline_linenetamt numeric 0  √  null c_invoiceline_linenetamt
linetotalamt numeric 0  √  null Total line amount incl. Tax
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_rmaline_id numeric 10  √  null Return Material Authorization Line
processed bpchar 1  √  null The document has been processed
ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
rramt numeric 0  √  null Revenue Recognition Amount
rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
s_resourceassignment_id numeric 10  √  null Resource Assignment
taxamt numeric 0  √  null Tax Amount for a document
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
m_product_ad_org_id numeric 10  √  null m_product_ad_org_id
classification varchar 12  √  null Classification for grouping
m_product_copyfrom bpchar 1  √  null m_product_copyfrom
m_product_created timestamp 29,6  √  null m_product_created
m_product_createdby numeric 10  √  null m_product_createdby
c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_subscriptiontype_id numeric 10  √  null Type of subscription
c_taxcategory_id numeric 10  √  null Tax Category
m_productline_c_uom_id numeric 10  √  null m_productline_c_uom_id
m_product_description varchar 255  √  null m_product_description
descriptionurl varchar 120  √  null URL for the description
discontinued bpchar 1  √  null This product is no longer available
discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
documentnote varchar 2000  √  null Additional information for a Document
group1 varchar 255  √  null Group1
group2 varchar 255  √  null Group2
guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
help varchar 2000  √  null Comment or Hint
imageurl varchar 120  √  null URL of image
m_product_isactive bpchar 1  √  null m_product_isactive
isdropship bpchar 1  √  null Drop Shipments are sent directly to the Drop Shipment Location
isexcludeautodelivery bpchar 1  √  null Exclude from automatic Delivery
isinvoiceprintdetails bpchar 1  √  null Print detail BOM elements on the invoice
ispicklistprintdetails bpchar 1  √  null Print detail BOM elements on the pick list
ispurchased bpchar 1  √  null Organization purchases this product
isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
issold bpchar 1  √  null Organization sells this product
isstocked bpchar 1  √  null Organization stocks this product
m_product_issummary bpchar 1  √  null m_product_issummary
isverified bpchar 1  √  null The BOM configuration has been verified
iswebstorefeatured bpchar 1  √  null If selected, the product is displayed in the initial or any empty search
lowlevel numeric 10  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product_m_attributeset_id numeric 10  √  null Product Attribute Set
m_freightcategory_id numeric 10  √  null Category of the Freight
m_locator_id numeric 10  √  null Warehouse Locator
m_product_m_product_id numeric 10  √  null m_product_m_product_id
m_product_processing bpchar 1  √  null m_product_processing
producttype bpchar 1  √  null Type of product
r_mailtext_id numeric 10  √  null Text templates for mailings
m_product_salesrep_id numeric 10  √  null m_product_salesrep_id
s_expensetype_id numeric 10  √  null Expense report type
shelfdepth numeric 10  √  null Shelf depth required
shelfheight numeric 0  √  null Shelf height required
shelfwidth numeric 10  √  null Shelf width required
sku varchar 30  √  null Stock Keeping Unit
s_resource_id numeric 10  √  null Resource
unitsperpack numeric 10  √  null The Units Per Pack indicates the no of units of a product packed together.
unitsperpallet numeric 0  √  null Units Per Pallet
m_product_updated timestamp 29,6  √  null m_product_updated
m_product_updatedby numeric 10  √  null m_product_updatedby
versionno varchar 20  √  null Version Number
volume numeric 0  √  null Volume of a product
weight numeric 0  √  null Weight of a product
m_asi_ad_org_id numeric 10  √  null m_attributesetinstance_ad_org_id
m_attributesetinstance_created timestamp 29,6  √  null m_attributesetinstance_created
m_asi_createdby numeric 10  √  null M_ASI_CreatedBy
m_asi_description varchar 255  √  null m_attributesetinstance_description
m_attributesetinstance_isacti bpchar 1  √  null m_attributesetinstance_isactive
m_attributesetinstance_serno varchar 40  √  null m_attributesetinstance_serno
m_attributesetinstance_updated timestamp 29,6  √  null m_attributesetinstance_updated
m_asi_updatedby numeric 10  √  null M_AttributeSetInstance_UpdatedBy
m_product_category_parent_id numeric 10  √  null Parent Product Category

Analyzed at 2024-01-03 13:44 +0100