View idempiere9.adempiere.c_project_details_v
Project Print View

 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
ad_language varchar 6  √  null Language for this entity
c_project_id numeric 10  √  null Financial Project
c_projectline_id numeric 10  √  null Task or step in a project
line numeric 10  √  null Unique line for this document
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
committedamt numeric 0  √  null The (legal) commitment amount
m_product_id numeric 10  √  null Product, Service, Item
name varchar 255  √  null Alphanumeric identifier of the entity
description varchar 2147483647  √  null Optional short description of the record
documentnote varchar 2000  √  null Additional information for a Document
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
productvalue varchar 40  √  null Key of the Product
m_product_category_id numeric 10  √  null Category of a Product
invoicedamt numeric 0  √  null The amount invoiced
invoicedqty numeric 0  √  null The quantity invoiced
committedqty numeric 0  √  null The (legal) commitment Quantity
c_order_id numeric 10  √  null Order
c_orderpo_id numeric 10  √  null Purchase Order
c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
c_projectphase_id numeric 10  √  null Phase of a Project
c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
dopricing bpchar 1  √  null Pricing
isprinted bpchar 1  √  null Indicates if this document / line is printed
c_projectline_processed bpchar 1  √  null c_projectline_processed
c_project_ad_org_id numeric 10  √  null c_project_ad_org_id
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_campaign_id numeric 10  √  null Marketing Campaign
c_currency_id numeric 10  √  null The Currency for this record
c_project_committedamt numeric 0  √  null c_project_committedamt
c_project_committedqty numeric 0  √  null c_project_committedqty
c_project_copyfrom bpchar 1  √  null c_project_copyfrom
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_projecttype_id numeric 10  √  null Type of the project
c_project_created timestamp 29,6  √  null c_project_created
c_project_createdby numeric 10  √  null c_project_createdby
datecontract timestamp 29,6  √  null The (planned) effective date of this document.
datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_project_description varchar 255  √  null c_project_description
generateto bpchar 1  √  null Generate To
c_project_invoicedamt numeric 0  √  null c_project_invoicedamt
c_project_invoicedqty numeric 0  √  null c_project_invoicedqty
c_project_isactive bpchar 1  √  null c_project_isactive
iscommitceiling bpchar 1  √  null The commitment amount/quantity is the chargeable ceiling
iscommitment bpchar 1  √  null Is this document a (legal) commitment?
c_project_issummary bpchar 1  √  null c_project_issummary
m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
c_project_name varchar 60  √  null c_project_name
c_project_note varchar 2000  √  null c_project_note
c_project_plannedamt numeric 0  √  null c_project_plannedamt
c_project_plannedmarginamt numeric 0  √  null c_project_plannedmarginamt
c_project_plannedqty numeric 0  √  null c_project_plannedqty
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project_processed bpchar 1  √  null c_project_processed
c_project_processing bpchar 1  √  null c_project_processing
projectbalanceamt numeric 0  √  null Total Project Balance
projectcategory bpchar 1  √  null Project Category
projectlinelevel bpchar 1  √  null Project Line Level
projinvoicerule bpchar 1  √  null Invoice Rule for the project
c_project_salesrep_id numeric 10  √  null c_project_salesrep_id
c_project_updated timestamp 29,6  √  null c_project_updated
c_project_updatedby numeric 10  √  null c_project_updatedby
c_project_value varchar 40  √  null c_project_value
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
c_uom_id numeric 10  √  null Unit of Measure
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
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_attributeset_id numeric 10  √  null Product Attribute Set
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_freightcategory_id numeric 10  √  null Category of the Freight
m_locator_id numeric 10  √  null Warehouse Locator
m_product_m_prod_category_id numeric 10  √  null m_product_m_prod_category_id
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
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

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