c_dunningrunentry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_dunningrunentry_id numeric 10 null
c_dunning_header_v.c_dunningrunentry_id Implied Constraint R
c_dunning_header_vt.c_dunningrunentry_id Implied Constraint R
c_dunning_line_v.c_dunningrunentry_id Implied Constraint R
c_dunning_line_vt.c_dunningrunentry_id Implied Constraint R
c_dunningrunline.c_dunningrunentry_id cdunningrunentry_line C
cof_dunningdetails_v.c_dunningrunentry_id Implied Constraint 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
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_cdunningrunentry R
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cdunningrune R
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_cdunningrunentry R
c_dunningrun_id numeric 10 null
c_dunningrun.c_dunningrun_id cdunningrun_cdunningrunentry C
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cdunningrunentry R
salesrep_id numeric 10 null
ad_user.ad_user_id salesrep_cdunningrunentry R
amt numeric 0 0
qty numeric 0 0
note varchar 2000 √ null
processed bpchar 1 'N'::bpchar
c_dunninglevel_id numeric 10 NULL::numeric
c_dunninglevel.c_dunninglevel_id cdunninglevel_cdunningrunentry R
c_dunningrunentry_uu varchar 36 √ NULL::character varying
cof_dunningstatus varchar 2 √ null
cof_datescheduled timestamp 29,6 √ null
cof_processing bpchar 1 √ NULL::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_dunningrunentry_pkey Primary key Asc c_dunningrunentry_id
c_dunningrunentry_uu_idx Must be unique Asc c_dunningrunentry_uu

Check Constraints

Constraint Name Constraint
c_dunningrunentry_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_dunningrunentry_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation