gl_distribution

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_distribution_id numeric 10 null
gl_distributionline.gl_distribution_id gldistribution_gldistline C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_gldist R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
postingtype bpchar 1 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_gldistribution R
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_gldist R
anyorg bpchar 1 'Y'::bpchar
org_id numeric 10 √ null
ad_org.ad_org_id adorgorg_gldist R
anyacct bpchar 1 'Y'::bpchar
account_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueacct_gldist R
anyproduct bpchar 1 'Y'::bpchar
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_gldist R
anybpartner bpchar 1 'Y'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_gldist R
anyproject bpchar 1 'Y'::bpchar
c_project_id numeric 10 √ null
c_project.c_project_id cproject_gldist R
anycampaign bpchar 1 'Y'::bpchar
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_gldist R
anyactivity bpchar 1 'Y'::bpchar
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_gldist R
anysalesregion bpchar 1 'Y'::bpchar
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregopn_gldist R
anyorgtrx bpchar 1 'Y'::bpchar
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_gldist R
anylocto bpchar 1 'Y'::bpchar
c_locto_id numeric 10 √ null
c_location.c_location_id clocto_gldist R
anylocfrom bpchar 1 'Y'::bpchar
c_locfrom_id numeric 10 √ null
c_location.c_location_id clocfrom_gldist R
anyuser1 bpchar 1 'Y'::bpchar
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueuser1_gldist R
anyuser2 bpchar 1 'Y'::bpchar
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id cevalueuser2_gldist R
percenttotal numeric 0 null
isvalid bpchar 1 'N'::bpchar
processing bpchar 1 √ null
iscreatereversal bpchar 1 'Y'::bpchar
gl_distribution_uu varchar 36 √ NULL::character varying
cof_anycfop bpchar 1 'Y'::bpchar
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfop_gldistribution R
cof_processing bpchar 10 √ 'Y'::bpchar
seqno numeric 10 '0'::numeric
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
gl_distribution_pkey Primary key Asc gl_distribution_id
gl_distribution_uu_idx Must be unique Asc gl_distribution_uu

Check Constraints

Constraint Name Constraint
gl_distribution_anyacct_check ((anyacct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyproduct_check ((anyproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_cof_anycfop_check ((cof_anycfop = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anycampaign_check ((anycampaign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anysalesregion_check ((anysalesregion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anylocto_check ((anylocto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyproject_check ((anyproject = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyuser2_check ((anyuser2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyorgtrx_check ((anyorgtrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyactivity_check ((anyactivity = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anylocfrom_check ((anylocfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_iscreatereversal_check ((iscreatereversal = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyuser1_check ((anyuser1 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anybpartner_check ((anybpartner = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_distribution_anyorg_check ((anyorg = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation