gl_distributionline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_distributionline_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_gldistline 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_distribution_id numeric 10 null
gl_distribution.gl_distribution_id gldistribution_gldistline C
line numeric 10 0
percent numeric 0 null
description varchar 255 √ null
overwriteorg bpchar 1 'N'::bpchar
org_id numeric 10 √ null
ad_org.ad_org_id adorgorg_gldistline R
overwriteacct bpchar 1 'N'::bpchar
account_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueacct_gldistline R
overwriteproduct bpchar 1 'N'::bpchar
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_gldistline R
overwritebpartner bpchar 1 'N'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_gldistline R
overwriteproject bpchar 1 'N'::bpchar
c_project_id numeric 10 √ null
c_project.c_project_id cproject_gldistline R
overwritecampaign bpchar 1 'N'::bpchar
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_gldistline R
overwriteactivity bpchar 1 'N'::bpchar
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_gldistline R
overwritesalesregion bpchar 1 'N'::bpchar
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_gldistline R
overwriteorgtrx bpchar 1 'N'::bpchar
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_gldistline R
overwritelocto bpchar 1 'N'::bpchar
c_locto_id numeric 10 √ null
c_location.c_location_id clocto_gldistline R
overwritelocfrom bpchar 1 'N'::bpchar
c_locfrom_id numeric 10 √ null
c_location.c_location_id clocfrom_gldistline R
overwriteuser1 bpchar 1 'N'::bpchar
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueuser1_gldistline R
overwriteuser2 bpchar 1 'N'::bpchar
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueuser2_gldistline R
gl_distributionline_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
gl_distributionline_pkey Primary key Asc gl_distributionline_id
gl_distributionline_uu_idx Must be unique Asc gl_distributionline_uu

Check Constraints

Constraint Name Constraint
gl_distributionline_overwritebpartner_check ((overwritebpartner = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteuser1_check ((overwriteuser1 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteorgtrx_check ((overwriteorgtrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwritelocto_check ((overwritelocto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwritelocfrom_check ((overwritelocfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteorg_check ((overwriteorg = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteactivity_check ((overwriteactivity = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteacct_check ((overwriteacct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteproduct_check ((overwriteproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwritecampaign_check ((overwritecampaign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwritesalesregion_check ((overwritesalesregion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteproject_check ((overwriteproject = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distributionline_overwriteuser2_check ((overwriteuser2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation