Table idempiere9.adempiere.a_asset_addition
Asset Addition

 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
a_asset_addition_id numeric 10
a_asset_change.a_asset_addition_id aaaddition_aachange R
a_depreciation_exp.a_asset_addition_id aassetaddition_adepreciationex R
Asset Addition
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
a_asset_id numeric 10
a_asset.a_asset_id aasset_aassetaddition R
Asset used internally or by customers
assetvalueamt numeric 0 Book Value of the asset
c_invoiceline_id numeric 10  √  null
c_invoiceline.c_invoiceline_id cinvoiceline_aassetaddition R
Invoice Detail Line
a_qty_current numeric 0 (0)::numeric Current Qty
description varchar 510  √  null Optional short description of the record
gl_journalbatch_id numeric 10  √  null
gl_journalbatch.gl_journalbatch_id gljournalbatch_aassetaddition R
General Ledger Journal Batch
line numeric 10  √  null Unique line for this document
postingtype bpchar 1 'A'::bpchar The type of posted amount for the transaction
m_inoutline_id numeric 10  √  null
m_inoutline.m_inoutline_id minoutline_aassetaddition R
Line on Shipment or Receipt document
documentno varchar 30  √  null Document sequence number of the document
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_aassetaddition R
Invoice Identifier
a_sourcetype varchar 3 'INV'::character varying Source Type
a_capvsexp varchar 3 'Cap'::character varying Capital/Expense
a_asset_addition_uu varchar 36  √  NULL::character varying A_Asset_Addition_UU
processed bpchar 1 'N'::bpchar The document has been processed
docstatus varchar 2 'DR'::character varying The current status of the document
docaction bpchar 2  √  'CO'::bpchar The targeted status of the document
a_createasset bpchar 1 'N'::bpchar Create Asset
isapproved bpchar 1 Indicates if this document requires approval
m_matchinv_id numeric 10  √  NULL::numeric
m_matchinv.m_matchinv_id mmatchinv_aassetaddition R
Match Shipment/Receipt to Invoice
m_product_id numeric 10  √  NULL::numeric
m_product.m_product_id mproduct_aassetaddition R
Product, Service, Item
m_attributesetinstance_id numeric 10  √  NULL::numeric
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_aassetad R
Product Attribute Set Instance
m_locator_id numeric 10  √  NULL::numeric
m_locator.m_locator_id mlocator_aassetaddition R
Warehouse Locator
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_aassetaddition R
The Currency for this record
c_conversiontype_id numeric 10
c_conversiontype.c_conversiontype_id cconversiontype_aassetaddition R
Currency Conversion Rate Type
assetsourceamt numeric 0  √  null Source Amount
deltauselifeyears numeric 10 (0)::numeric Delta Use Life Years
deltauselifeyears_f numeric 10 (0)::numeric Delta Use Life Years (fiscal)
datedoc timestamp 29,6 Date of the Document
i_fixedasset_id numeric 10  √  NULL::numeric
i_fixedasset.i_fixedasset_id ifixedasset_aassetaddition R
Imported Fixed Asset
dateacct timestamp 29,6  √  null Accounting Date
currencyrate numeric 0  √  null Currency Conversion Rate
a_accumulated_depr numeric 0 (0)::numeric Accumulated Depreciation
a_accumulated_depr_f numeric 0 (0)::numeric Accumulated Depreciation (fiscal)
c_project_id numeric 10  √  NULL::numeric
c_project.c_project_id cproject_aassetaddition R
Financial Project
processing bpchar 1  √  NULL::bpchar Process Now
a_accumulated_depr_adjust bpchar 1 'N'::bpchar Adjust Accumulated Depreciation
assetamtentered numeric 0 (0)::numeric Entered Amount
posted bpchar 1 'N'::bpchar Posting status
a_period_start numeric 10 (0)::numeric A_Period_Start
c_charge_id numeric 10  √  NULL::numeric
c_charge.c_charge_id ccharge_aassetaddition R
Additional document charges
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
a_salvage_value numeric 0  √  null Asset Salvage Value
c_doctype_id numeric 10  √  NULL::numeric
c_doctype.c_doctype_id cdoctype_aassetaddition R
Document type or rules

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

Indexes:
Column(s) Type Sort Constraint Name
a_asset_addition_id Primary key Asc a_asset_addition_pkey
a_asset_addition_uu Must be unique Asc a_asset_addition_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.