Table idempiere9.adempiere.t_aging
T_Aging

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_pinstance_id numeric 10
ad_pinstance.ad_pinstance_id adpinstance_taging C
Instance of the process
c_bpartner_id numeric 10
c_bpartner.c_bpartner_id cbpartner_taging C
Identifies a Business Partner
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_taging C
The Currency for this record
c_invoice_id numeric 10 Invoice Identifier
c_invoicepayschedule_id numeric 10 Invoice Payment Schedule
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
statementdate timestamp 29,6 Date of the statement
duedate timestamp 29,6 Date when the payment is due
daysdue numeric 10  √  0 Number of days due (negative: due in number of days)
islistinvoices bpchar 1 'N'::bpchar Include List of Invoices
issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_bp_group_id numeric 10
c_bp_group.c_bp_group_id cbpgroup_taging C
Business Partner Group
invoicedamt numeric 0 0 The amount invoiced
openamt numeric 0 0 Open item amount
pastdue91_plus numeric 0 0 Past Due > 91
pastdue61_90 numeric 0 0 Past Due 61-90
pastdue61_plus numeric 0 0 Past Due > 61
pastdue31_60 numeric 0 0 Past Due 31-60
pastdue31_plus numeric 0 0 Past Due > 31
pastdue1_30 numeric 0 0 Past Due 1-30
pastdue8_30 numeric 0 0 Past Due 8-30
pastdue1_7 numeric 0 0 Past Due 1-7
pastdueamt numeric 0 0 Past Due
dueamt numeric 0 0 Amount of the payment due
due0 numeric 0 0 Due Today
due0_7 numeric 0 0 Due Today-7
due1_7 numeric 0 0 Due 1-7
due8_30 numeric 0 0 Due 8-30
due0_30 numeric 0 0 Due Today-30
due31_plus numeric 0 0 Due > 31
due31_60 numeric 0 0 Due 31-60
due61_plus numeric 0 0 Due > 61
due61_90 numeric 0 0 Due 61-90
due91_plus numeric 0 0 Due > 91
c_project_id numeric 10  √  null
c_project.c_project_id cproject_taging C
Financial Project
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_taging C
Marketing Campaign
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_taging C
Business Activity
dateacct bpchar 1  √  'N'::bpchar Accounting Date
t_aging_uu varchar 36  √  NULL::character varying T_Aging_UU
convertamountsincurrency_id numeric 10  √  null Convert Amounts in Currency

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

Indexes:
Column(s) Type Sort Constraint Name
ad_pinstance_id + c_bpartner_id + c_currency_id + c_invoice_id + c_invoicepayschedule_id Primary key Asc/Asc/Asc/Asc/Asc t_aging_pkey
t_aging_uu Must be unique Asc t_aging_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.