gl_journalgeneratorline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_journalgeneratorline_id numeric 10 null
gl_journalgeneratorsource.gl_journalgeneratorline_id qssjournalgeneratorline_qssjou R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ NULL::character varying
help varchar 2000 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
gl_journalgenerator_id numeric 10 null
gl_journalgenerator.gl_journalgenerator_id qssjournalgenerator_qssjournal R
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
seqno numeric 10 null
c_elementvaluedr_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id celementvaluedr_qssjournalgene R
c_elementvaluecr_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id celementvaluecr_qssjournalgene R
bpdimensiontype bpchar 1 √ NULL::bpchar
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_qssjournalgeneratorl R
bpcolumn varchar 100 √ NULL::character varying
iscopyalldimensions bpchar 1 'N'::bpchar
issameproduct bpchar 1 'N'::bpchar
amtmultiplier numeric 0 √ (1)::numeric
roundfactor numeric 10 √ (0)::numeric
gl_journalgeneratorline_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
gl_journalgeneratorline_key Primary key Asc gl_journalgeneratorline_id
gl_journalgeneratorline_uu_idx Must be unique Asc gl_journalgeneratorline_uu

Check Constraints

Constraint Name Constraint
gl_journalgeneratorline_issameproduct_check ((issameproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalgeneratorline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalgeneratorline_iscopyalldimensions_check ((iscopyalldimensions = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation