cof_c_checkallocate

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofccheckallocate R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofccheckallocate R
amount numeric 0 null
c_invoice_id numeric 10 null
c_invoice.c_invoice_id cinvoice_cofccheckallocate R
c_invoicepayschedule_id numeric 10 √ NULL::numeric
c_invoicepayschedule.c_invoicepayschedule_id cinvoicepayschedule_cofcchecka R
cof_c_checkallocate_id numeric 10 null
cof_c_checkallocate_uu varchar 36 √ NULL::character varying
cof_c_controlcheck_id numeric 10 null
cof_c_controlcheck.cof_c_controlcheck_id cofccontrolcheck_cofccheckallo R
cof_interestamt numeric 0 null
cof_penaltyamt numeric 0 √ 0
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
ad_user.ad_user_id createdby_cofccheckallocate R
discountamt numeric 0 null
invoiceamt numeric 0 √ null
isactive bpchar 1 null
overunderamt numeric 0 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofccheckallocate R
writeoffamt numeric 0 null

Indexes

Constraint Name Type Sort Column(s)
cof_c_checkallocate_key Primary key Asc cof_c_checkallocate_id
cof_c_checkallocate_uu_idx Must be unique Asc cof_c_checkallocate_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation