View idempiere9.adempiere.rv_projectlineissue
Project Line Issue

 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 Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
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_project_id numeric 10  √  null Financial Project
m_product_id numeric 10  √  null Product, Service, Item
c_projectline_id numeric 10  √  null Task or step in a project
line numeric 10  √  null Unique line for this document
description varchar 255  √  null Optional short description of the record
plannedqty numeric 0  √  null Planned quantity for this project
plannedprice numeric 0  √  null Planned price for this project line
plannedamt numeric 0  √  null Planned amount for this project
plannedmarginamt numeric 0  √  null Project's planned margin amount
committedqty numeric 0  √  null The (legal) commitment Quantity
c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_locator_id numeric 10  √  null Warehouse Locator
movementqty numeric 0  √  null Quantity of a product moved.
movementdate timestamp 29,6  √  null Date a product was moved in or out of inventory
issueline numeric 10  √  null Line number of the issue
issuedescription varchar 255  √  null Description of the Issue line
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
s_timeexpenseline_id numeric 10  √  null Time and Expense Report Line
c_acctschema_id numeric 10  √  null Rules for accounting
account_id numeric 10  √  null Account used
amtsourcedr numeric 0  √  null Source Debit Amount
amtsourcecr numeric 0  √  null Source Credit Amount
amtacctdr numeric 0  √  null Accounted Debit Amount
amtacctcr numeric 0  √  null Accounted Credit Amount
linemargin numeric 0  √  null Margin of the line - Planned Amount minus Costs

Analyzed at 2021-12-25 14:43 +0100