lbr_taxname

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_taxname_id numeric 10 null
c_tax.lbr_taxname_id Implied Constraint R
cof_c_adjustment_code.lbr_taxname_id lbrtaxname_cofcadjustmentcode R
cof_c_determination_group.lbr_taxname_id lbrtaxname_cofcdeterminationgr R
cof_c_taxclassification.lbr_taxname_id lbrtaxname_cofctaxclassificati R
cof_c_taxdetermination_hdr.lbr_taxname_id lbrtaxname_cofctaxdeterminatio R
cof_cenq.lbr_taxname_id lbrtaxname_cofcenq R
cof_modbc.lbr_taxname_id lbrtaxname_cofmodbc R
cof_motdeson.lbr_taxname_id lbrtaxname_cofmotdeson R
cof_retentionconfig.lbr_taxname_id lbrtaxname_cofretentionconfig R
cof_rv_confimpostos.lbr_taxname_id Implied Constraint R
lbr_taxformula.lbr_taxname_id Implied Constraint R
lbr_taxline.lbr_taxname_id Implied Constraint R
lbr_taxstatus.lbr_taxname_id Implied Constraint R
ad_org_id numeric 10 null
ad_client_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
lbr_taxtype bpchar 1 'P'::bpchar
haswithhold bpchar 1 'N'::bpchar
withholdthreshold numeric 0 √ null
lbr_taxsubstitution_id numeric 10 √ null
lbr_withholdfrequency bpchar 1 'M'::bpchar
lbr_taxname_uu varchar 36 √ NULL::character varying
cof_duedate timestamp 29,6 √ null
cof_calcbase bpchar 1 √ 'I'::bpchar
cof_hastaxstatus bpchar 1 √ 'Y'::bpchar
cof_hasmodbc bpchar 1 √ 'Y'::bpchar
cof_hascenq bpchar 1 √ 'N'::bpchar
cof_hasmotdeson bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
lbr_taxname_key Primary key Asc lbr_taxname_id
lbr_taxname_uniquetax Must be unique Asc/Asc/Asc ad_client_id + ad_org_id + name
lbr_taxname_uu_idx Must be unique Asc lbr_taxname_uu

Check Constraints

Constraint Name Constraint
lbr_taxname_cof_hastaxstatus_check ((cof_hastaxstatus = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_taxname_cof_hasmotdeson_check ((cof_hasmotdeson = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_taxname_cof_hasmodbc_check ((cof_hasmodbc = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_taxname_haswithhold_check ((haswithhold = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_taxname_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
lbr_taxname_cof_hascenq_check ((cof_hascenq = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation