Table idempiere9.adempiere.s_timeexpenseline
Time and Expense Report Line

 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
s_timeexpenseline_id numeric 10
c_projectissue.s_timeexpenseline_id stimeexpline_cprojectissue R
Time and Expense Report Line
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
s_timeexpense_id numeric 10
s_timeexpense.s_timeexpense_id stimeexpense_line C
Time and Expense Report
line numeric 10 Unique line for this document
istimereport bpchar 1 'N'::bpchar Line is a time report only (no expense)
dateexpense timestamp 29,6  √  null Date of expense
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_stimeexpenseline R
Product, Service, Item
qty numeric 0  √  0 Quantity
expenseamt numeric 0  √  0 Amount for this expense
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_stimeexpenseline R
The Currency for this record
convertedamt numeric 0  √  0 Converted Amount
s_resourceassignment_id numeric 10  √  null
s_resourceassignment.s_resourceassignment_id sresourceassign_steline R
Resource Assignment
description varchar 255  √  null Optional short description of the record
note varchar 255  √  null Optional additional user defined information
isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_stimeexpenseline R
Identifies a Business Partner
c_project_id numeric 10  √  null
c_project.c_project_id cproject_stimeexpenseline R
Financial Project
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_stimeexpenseline R
Business Activity
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_stimeexpenseline R
Marketing Campaign
c_invoiceline_id numeric 10  √  null
c_invoiceline.c_invoiceline_id cinvoiceline_stimeexpenseline R
Invoice Detail Line
invoiceprice numeric 0  √  0 Unit price to be invoiced or 0 for default price
c_uom_id numeric 10  √  null
c_uom.c_uom_id cuom_stimeexpenseline R
Unit of Measure
c_orderline_id numeric 10  √  null
c_orderline.c_orderline_id corderline_stimeexpenseline R
Sales Order Line
c_projectphase_id numeric 10  √  null
c_projectphase.c_projectphase_id cprojectphase_stimeexpenseline R
Phase of a Project
c_projecttask_id numeric 10  √  null
c_projecttask.c_projecttask_id cprojecttask_stimeexpenseline R
Actual Project Task in a Phase
s_timetype_id numeric 10  √  null
s_timetype.s_timetype_id stimetype_stimeexpenseline R
Type of time recorded
processed bpchar 1 'N'::bpchar The document has been processed
qtyinvoiced numeric 0  √  null Invoiced Quantity
qtyreimbursed numeric 0  √  null The reimbursed quantity
priceinvoiced numeric 0  √  null The priced invoiced to the customer (in the currency of the customer's AR price list) - 0 for default price
pricereimbursed numeric 0  √  null The reimbursed price (in currency of the employee's AP price list)
s_timeexpenseline_uu varchar 36  √  NULL::character varying S_TimeExpenseLine_UU

Table contained 4 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
s_timeexpenseline_id Primary key Asc s_timeexpenseline_pkey
s_timeexpenseline_uu Must be unique Asc s_timeexpenseline_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.