c_dunninglevel

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_dunninglevel_id numeric 10 null
c_dunning_header_v.c_dunningrun_c_dunninglevel_id Implied Constraint R
c_dunning_header_vt.c_dunningrun_c_dunninglevel_id Implied Constraint R
c_dunning_line_v.c_dunninglevel_id Implied Constraint R
c_dunning_line_vt.c_dunninglevel_id Implied Constraint R
c_dunninglevel_trl.c_dunninglevel_id cdunninglevel_cdltrl R
c_dunningrun.c_dunninglevel_id cdunninglevel_cdunningrun R
c_dunningrunentry.c_dunninglevel_id cdunninglevel_cdunningrunentry R
c_invoice.c_dunninglevel_id cdunninglevel_cinvoice R
c_invoice_header_v.c_dunninglevel_id Implied Constraint R
c_invoice_header_vt.c_dunninglevel_id Implied Constraint R
c_payselection_remittance_v.c_dunninglevel_id Implied Constraint R
c_payselection_remittance_vt.c_dunninglevel_id Implied Constraint R
cof_dunningdetails_v.c_dunninglevel_id Implied Constraint R
cof_rv_itenspago.c_dunninglevel_id Implied Constraint R
rv_c_invoice.c_dunninglevel_id Implied Constraint R
rv_c_invoicetax.c_dunninglevel_id Implied Constraint R
rv_commissionrundetail.c_dunninglevel_id Implied Constraint R
rv_openitem.c_dunninglevel_id Implied Constraint R
t_invoicegl_v.c_dunninglevel_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_dunning_id numeric 10 null
c_dunning.c_dunning_id cdunning_cdunninglevel R
printname varchar 60 null
daysafterdue numeric 10 null
daysbetweendunning numeric 10 null
note varchar 2000 √ null
chargeinterest bpchar 1 'Y'::bpchar
interestpercent numeric 0 √ 0
chargefee bpchar 1 'Y'::bpchar
feeamt numeric 0 √ 0
dunning_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_cdunninglevel R
name varchar 60 'x'::character varying
description varchar 255 √ null
isshowalldue bpchar 1 'N'::bpchar
isshownotdue bpchar 1 'N'::bpchar
issetcreditstop bpchar 1 'N'::bpchar
issetpaymentterm bpchar 1 'N'::bpchar
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_cdunninglevel R
invoicecollectiontype bpchar 1 √ NULL::bpchar
isstatement bpchar 1 'N'::bpchar
c_dunninglevel_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_dunninglevel_pkey Primary key Asc c_dunninglevel_id
c_dunninglevel_uu_idx Must be unique Asc c_dunninglevel_uu

Check Constraints

Constraint Name Constraint
c_dunninglevel_chargeinterest_check ((chargeinterest = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_dunninglevel_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_dunninglevel_isstatement_check ((isstatement = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_dunninglevel_chargefee_check ((chargefee = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation