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_dunning_header_v.c_bpartner_c_paymentterm_id Implied Constraint R
c_dunning_header_v.c_paymentterm_id Implied Constraint R
c_dunning_header_v.salesrep_bp_c_paymentterm_id Implied Constraint R
c_dunning_header_vt.c_bpartner_c_paymentterm_id Implied Constraint R
c_dunning_header_vt.c_paymentterm_id Implied Constraint R
c_dunning_header_vt.salesrep_bp_c_paymentterm_id Implied Constraint R
c_dunning_line_v.c_paymentterm_id Implied Constraint R
c_dunning_line_vt.c_paymentterm_id Implied Constraint R
c_dunninglevel.c_paymentterm_id cpaymentterm_cdunninglevel R
c_invoice.c_paymentterm_id cpaymentterm_cinvoice R
c_invoice_header_v.bp_c_paymentterm_id Implied Constraint R
c_invoice_header_v.bpartner_c_paymentterm_id Implied Constraint R
c_invoice_header_v.c_paymentterm_id Implied Constraint R
c_invoice_header_vt.bp_c_paymentterm_id Implied Constraint R
c_invoice_header_vt.bpartner_c_paymentterm_id Implied Constraint R
c_invoice_header_vt.c_paymentterm_id Implied Constraint R
c_invoice_v.c_paymentterm_id Implied Constraint R
c_invoice_v1.c_paymentterm_id Implied Constraint R
c_order.c_paymentterm_id cpaymentterm_soheader R
c_order.cof_paymentterm_id cofpaymentterm_corder R
c_order_header_v.bill_bp_c_paymentterm_id Implied Constraint R
c_order_header_v.bp_c_paymentterm_id Implied Constraint R
c_order_header_v.c_paymentterm_id Implied Constraint R
c_order_header_v.salesrep_bp_c_paymentterm_id Implied Constraint R
c_order_header_vt.bill_bp_c_paymentterm_id Implied Constraint R
c_order_header_vt.bp_c_paymentterm_id Implied Constraint R
c_order_header_vt.c_paymentterm_id Implied Constraint R
c_order_header_vt.salesrep_bp_c_paymentterm_id Implied Constraint R
c_paymentterm_trl.c_paymentterm_id cpaymentterm_cpaytermtrl C
c_payschedule.c_paymentterm_id cpaymentterm_cpayschedule R
c_payselection_check_v.c_bp_c_paymentterm_id Implied Constraint R
c_payselection_check_vt.c_bp_c_paymentterm_id Implied Constraint R
c_payselection_remittance_v.c_paymentterm_id Implied Constraint R
c_payselection_remittance_vt.c_paymentterm_id Implied Constraint R
c_project.c_paymentterm_id cpaymentterm_cproject R
c_project_details_v.c_paymentterm_id Implied Constraint R
c_project_details_vt.c_paymentterm_id Implied Constraint R
c_project_header_v.c_bp_c_paymentterm_id Implied Constraint R
c_project_header_v.c_paymentterm_c_paymentterm_id Implied Constraint R
c_project_header_v.c_project_c_paymentterm_id Implied Constraint R
c_project_header_v.salesrep_bp_c_paymentterm_id Implied Constraint R
c_project_header_vt.c_bp_c_paymentterm_id Implied Constraint R
c_project_header_vt.c_paymentterm_c_paymentterm_id Implied Constraint R
c_project_header_vt.c_project_c_paymentterm_id Implied Constraint R
c_project_header_vt.salesrep_bp_c_paymentterm_id Implied Constraint 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
cof_rv_contract.c_paymentterm_id Implied Constraint R
cof_rv_docfiscal.c_paymentterm_id Implied Constraint R
cof_rv_gencnab.c_paymentterm_id Implied Constraint R
cof_rv_itenspago.c_paymentterm_id Implied Constraint R
cof_rv_mapa_pedido.c_paymentterm_id Implied Constraint R
i_invoice.c_paymentterm_id cpaymentterm_iinvoice N
i_order.c_paymentterm_id cpaymentterm_iorder N
lbr_docfiscal.c_paymentterm_id Implied Constraint R
m_inout_header_v.c_bp_c_paymentterm_id Implied Constraint R
m_inout_header_vt.c_bp_c_paymentterm_id Implied Constraint R
rv_bpartner.c_paymentterm_id Implied Constraint R
rv_c_invoice.c_bp_c_paymentterm_id Implied Constraint R
rv_c_invoice.c_paymentterm_id Implied Constraint R
rv_c_invoicetax.c_bp_c_paymentterm_id Implied Constraint R
rv_c_invoicetax.c_invoice_c_paymentterm_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_paymentterm_id Implied Constraint R
rv_fact_acct.c_bp_c_paymentterm_id Implied Constraint R
rv_invoicepayschedule.c_paymentterm_id Implied Constraint R
rv_openitem.c_paymentterm_id Implied Constraint R
rv_openitemtodate.c_paymentterm_id Implied Constraint R
rv_orderdetail.c_paymentterm_id Implied Constraint R
t_invoicegl_v.c_paymentterm_id Implied Constraint R
t_rv_reconciliation.c_bp_c_paymentterm_id Implied Constraint 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

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

Check Constraints

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

Relationships

Close relationships within degrees of separation