c_paymentterm_trl

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_paymentterm_id numeric 10 null
c_paymentterm.c_paymentterm_id cpaymentterm_cpaytermtrl C
ad_language varchar 6 null
ad_language.ad_language adlanguage_cpaymenttermtrl R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
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
documentnote varchar 2000 null
istranslated bpchar 1 'N'::bpchar
c_paymentterm_trl_uu varchar 36 NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_paymentterm_trl_pkey Primary key Asc/Asc c_paymentterm_id + ad_language
c_paymentterm_trl_uu_idx Must be unique Asc c_paymentterm_trl_uu

Check Constraints

Constraint Name Constraint
c_paymentterm_trl_istranslated_check ((istranslated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_trl_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships