c_invoicepayschedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_invoicepayschedule_id numeric 10 null
c_allocationline.c_invoicepayschedule_id Implied Constraint R
c_dunning_line_v.c_invoicepayschedule_id Implied Constraint R
c_dunning_line_vt.c_invoicepayschedule_id Implied Constraint R
c_dunningrunline.c_invoicepayschedule_id cinvoicepayschedule_cdunningru R
c_payment.c_invoicepayschedule_id cinvoicepayschedule_cpayment R
c_paymentallocate.c_invoicepayschedule_id cinvoicepayschedule_cpaymental R
c_payselectionline.c_invoicepayschedule_id cinvoicepayschedule_cpayselect R
cof_c_checkallocate.c_invoicepayschedule_id cinvoicepayschedule_cofcchecka R
cof_rv_checkallocate.c_invoicepayschedule_id Implied Constraint R
cof_rv_titulos.c_invoicepayschedule_id Implied Constraint R
cof_titulo.c_invoicepayschedule_id cinvoicepayschedule_coftitulo 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_invoice_id numeric 10 null
c_invoice.c_invoice_id cinvoice_cinvoicepaysched C
c_payschedule_id numeric 10 √ null
c_payschedule.c_payschedule_id cpayschedule_cinvoicepaysched R
duedate timestamp 29,6 null
dueamt numeric 0 0
discountdate timestamp 29,6 null
discountamt numeric 0 0
isvalid bpchar 1 'N'::bpchar
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
c_invoicepayschedule_uu varchar 36 √ NULL::character varying
ispaid bpchar 1 √ 'N'::bpchar
c_payment_id numeric 10 √ NULL::numeric
c_payment.c_payment_id Implied Constraint R
cof_payscheduleno varchar 20 √ NULL::character varying
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_cinvoicepayschedul R
cof_datescheduled timestamp 29,6 √ null
cof_processing bpchar 1 √ NULL::bpchar
cof_isrescheduled bpchar 1 √ 'N'::bpchar
pag_tpag varchar 2 √ NULL::character varying
pag_card_tpintegra bpchar 1 √ '2'::bpchar
cof_c_cardnetwork_id numeric 10 √ NULL::numeric
cof_c_cardnetwork.cof_c_cardnetwork_id cofccardnetwork_cinvoicepaysch R
pag_card_caut varchar 20 √ NULL::character varying
cof_dataoriginal timestamp 29,6 √ null
cof_valoracrescimo numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
c_invoicepayschedule_pkey Primary key Asc c_invoicepayschedule_id
c_invoicepayschedule_invoice Performance Asc c_invoice_id
c_invoicepayschedule_uu_idx Must be unique Asc c_invoicepayschedule_uu

Check Constraints

Constraint Name Constraint
c_invoicepayschedule_cof_isrescheduled_check ((cof_isrescheduled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoicepayschedule_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoicepayschedule_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoicepayschedule_ispaid_check ((ispaid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation