gl_journalline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_journalline_id numeric 10 null
gl_journalline_acct_v.gl_journalline_id Implied Constraint R
i_fajournal.gl_journalline_id gljournalline_ifajournal R
i_gljournal.gl_journalline_id gljourbelline_igljournal N
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_gljournalline R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_gljournalline R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
gl_journal_id numeric 10 null
gl_journal.gl_journal_id gljournal_gljournalline C
line numeric 10 null
isgenerated bpchar 1 'N'::bpchar
description varchar 255 √ null
amtsourcedr numeric 0 0
amtsourcecr numeric 0 0
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_gljournalline R
currencyrate numeric 0 0
dateacct timestamp 29,6 null
amtacctdr numeric 0 0
amtacctcr numeric 0 0
c_uom_id numeric 10 √ null
c_uom.c_uom_id cuom_gljournalline R
qty numeric 0 √ 0
c_validcombination_id numeric 10 √ null
c_validcombination.c_validcombination_id cvc_gljournalline R
c_conversiontype_id numeric 10 null
c_conversiontype.c_conversiontype_id cconversiontype_gljournalline R
processed bpchar 1 'N'::bpchar
a_asset_group_id numeric 10 √ null
a_asset_group.a_asset_group_id aassetgroup_gljournalline R
a_asset_id numeric 10 √ null
a_asset.a_asset_id aasset_gljournalline R
a_createasset bpchar 1 √ 'N'::bpchar
a_processed bpchar 1 √ 'N'::bpchar
gl_journalline_uu varchar 36 √ NULL::character varying
ad_orgtrx_id numeric 10 √ NULL::numeric
ad_org.ad_org_id adorgtrx_gljournalline R
account_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id account_gljournalline R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_gljournalline R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_gljournalline R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_gljournalline R
c_locfrom_id numeric 10 √ NULL::numeric
c_location.c_location_id clocfrom_gljournalline R
c_locto_id numeric 10 √ NULL::numeric
c_location.c_location_id clocto_gljournalline R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_gljournalline R
c_salesregion_id numeric 10 √ NULL::numeric
c_salesregion.c_salesregion_id csalesregion_gljournalline R
c_subacct_id numeric 10 √ NULL::numeric
c_subacct.c_subacct_id csubacct_gljournalline R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_gljournalline R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_gljournalline R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_gljournalline R
alias_validcombination_id numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id aliasvalidcombination_gljourna R

Indexes

Constraint Name Type Sort Column(s)
gl_journalline_pkey Primary key Asc gl_journalline_id
gl_journalline_uu_idx Must be unique Asc gl_journalline_uu

Check Constraints

Constraint Name Constraint
gl_journalline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalline_a_processed_check ((a_processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalline_a_createasset_check ((a_createasset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalline_isgenerated_check ((isgenerated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation