a_asset_addition

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_addition_id numeric 10 null
a_asset_change.a_asset_addition_id aaaddition_aachange R
a_depreciation_exp.a_asset_addition_id aassetaddition_adepreciationex R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
a_asset_id numeric 10 null
a_asset.a_asset_id aasset_aassetaddition R
assetvalueamt numeric 0 null
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id cinvoiceline_aassetaddition R
a_qty_current numeric 0 (0)::numeric
description varchar 510 √ null
gl_journalbatch_id numeric 10 √ null
gl_journalbatch.gl_journalbatch_id gljournalbatch_aassetaddition R
line numeric 10 √ null
postingtype bpchar 1 'A'::bpchar
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_aassetaddition R
documentno varchar 30 √ null
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_aassetaddition R
a_sourcetype varchar 3 'INV'::character varying
a_capvsexp varchar 3 'Cap'::character varying
a_asset_addition_uu varchar 36 √ NULL::character varying
processed bpchar 1 'N'::bpchar
docstatus varchar 2 'DR'::character varying
docaction bpchar 2 √ 'CO'::bpchar
a_createasset bpchar 1 'N'::bpchar
isapproved bpchar 1 null
m_matchinv_id numeric 10 √ NULL::numeric
m_matchinv.m_matchinv_id mmatchinv_aassetaddition R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_aassetaddition R
m_attributesetinstance_id numeric 10 √ NULL::numeric
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_aassetad R
m_locator_id numeric 10 √ NULL::numeric
m_locator.m_locator_id mlocator_aassetaddition R
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_aassetaddition R
c_conversiontype_id numeric 10 null
c_conversiontype.c_conversiontype_id cconversiontype_aassetaddition R
assetsourceamt numeric 0 √ null
deltauselifeyears numeric 10 (0)::numeric
deltauselifeyears_f numeric 10 (0)::numeric
datedoc timestamp 29,6 null
i_fixedasset_id numeric 10 √ NULL::numeric
i_fixedasset.i_fixedasset_id ifixedasset_aassetaddition R
dateacct timestamp 29,6 √ null
currencyrate numeric 0 √ null
a_accumulated_depr numeric 0 (0)::numeric
a_accumulated_depr_f numeric 0 (0)::numeric
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_aassetaddition R
processing bpchar 1 √ NULL::bpchar
a_accumulated_depr_adjust bpchar 1 'N'::bpchar
assetamtentered numeric 0 (0)::numeric
posted bpchar 1 'N'::bpchar
a_period_start numeric 10 (0)::numeric
c_charge_id numeric 10 √ NULL::numeric
c_charge.c_charge_id ccharge_aassetaddition R
processedon numeric 0 √ null
a_salvage_value numeric 0 √ null
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctype_aassetaddition R

Indexes

Constraint Name Type Sort Column(s)
a_asset_addition_pkey Primary key Asc a_asset_addition_id
a_asset_addition_uu_idx Must be unique Asc a_asset_addition_uu

Check Constraints

Constraint Name Constraint
a_asset_addition_a_createasset_check ((a_createasset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_addition_processing_check ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_addition_a_accumulated_depr_adjust_check ((a_accumulated_depr_adjust = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_addition_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_addition_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_asset_addition_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation