c_paymentterm

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_paymentterm_id numeric 10 null
c_bpartner.c_paymentterm_id cpaymentterm_cbpartner R
c_bpartner.po_paymentterm_id cpopaymentterm_cbpartner R
c_dunninglevel.c_paymentterm_id cpaymentterm_cdunninglevel R
c_invoice.c_paymentterm_id cpaymentterm_cinvoice R
c_order.c_paymentterm_id cpaymentterm_soheader R
c_order.cof_paymentterm_id cofpaymentterm_corder R
c_paymentterm_trl.c_paymentterm_id cpaymentterm_cpaytermtrl C
c_payschedule.c_paymentterm_id cpaymentterm_cpayschedule R
c_project.c_paymentterm_id cpaymentterm_cproject R
c_withholding.c_paymentterm_id cpaymentterm_cwithholding R
cof_c_custody.c_paymentterm_id cpaymentterm_cofccustody R
cof_contract.c_paymentterm_id cpaymentterm_cofcontract R
cof_preferenciaxml.c_paymentterm_id cpaymentterm_cofpreferenciaxml R
cof_retentionconfig.c_paymentterm_id cpaymentterm_cofretentionconfi R
cof_retentionconfig.cof_paymentterm_id cofpaymentterm_cofretentioncon R
cof_rps.c_paymentterm_id cpaymentterm_cofrps R
i_invoice.c_paymentterm_id cpaymentterm_iinvoice N
i_order.c_paymentterm_id cpaymentterm_iorder N
t_aging.c_paymentterm_id cpaymentterm_taging R
w_store.c_paymentterm_id cpaymentterm_wstore 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
afterdelivery bpchar 1 'N'::bpchar
isduefixed bpchar 1 'N'::bpchar
netdays numeric 10 null
gracedays numeric 10 null
fixmonthcutoff numeric 10 √ null
fixmonthday numeric 10 √ null
fixmonthoffset numeric 10 √ null
discountdays numeric 10 null
discount numeric 0 null
discountdays2 numeric 10 null
discount2 numeric 0 null
isnextbusinessday bpchar 1 √ 'Y'::bpchar
isdefault bpchar 1 √ 'N'::bpchar
value varchar 40 null
netday bpchar 1 √ null
isvalid bpchar 1 'N'::bpchar
processing bpchar 1 √ null
paymenttermusage bpchar 1 'B'::bpchar
c_paymentterm_uu varchar 36 √ NULL::character varying
cof_indpag bpchar 1 √ NULL::bpchar
ispreviousbusinessday bpchar 1 √ NULL::bpchar
cof_createpayschedule bpchar 12 √ NULL::bpchar
cof_juros numeric 0 '0'::numeric
cof_jurosmensal numeric 0 '0'::numeric
cof_paymentminvalue numeric 0 '0'::numeric
cof_isdiafixo bpchar 1 'N'::bpchar
cof_qtdesemanas numeric 10 √ NULL::numeric
cof_diasdasemana bpchar 1 √ NULL::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_paymentterm_pkey Primary key Asc c_paymentterm_id
c_paymentterm_name Must be unique Asc/Asc ad_client_id + name
c_paymentterm_uu_idx Must be unique Asc c_paymentterm_uu
c_paymentterm_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
c_paymentterm_afterdelivery_check ((afterdelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_isnextbusinessday_check ((isnextbusinessday = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_ispreviousbusinessday_check ((ispreviousbusinessday = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_isduefixed_check ((isduefixed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_paymentterm_cof_isdiafixo_check ((cof_isdiafixo = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation