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 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 The Currency for this record
convertedamt numeric 0  √  0 Converted Amount
s_resourceassignment_id numeric 10  √  null 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 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 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 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:54 +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

Close relationships  within of separation: