cof_c_controlcheck

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofccontrolcheck R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofccontrolcheck R
c_bank_id numeric 10 √ NULL::numeric
c_bank.c_bank_id cbank_cofccontrolcheck C
cof_c_controlcheck_id numeric 10 null
c_payment.cof_c_controlcheck_id cofccontrolcheck_cpayment R
cof_c_checkallocate.cof_c_controlcheck_id cofccontrolcheck_cofccheckallo R
cof_c_controlcheck.cof_checkchangeto_id cofcheckchangeto_cofccontrolch R
cof_rv_checkallocate.cof_c_controlcheck_id Implied Constraint R
cof_rv_controlcheck.cof_c_controlcheck_id Implied Constraint R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofccontrolcheck R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofccontrolcheck R
cof_agencyno varchar 40 √ NULL::character varying
cof_agencydigit varchar 20 √ NULL::character varying
cof_accountno varchar 20 √ NULL::character varying
cof_accountdigit varchar 20 √ NULL::character varying
cof_serie varchar 5 √ NULL::character varying
totalamt numeric 0 √ (0)::numeric
datedoc timestamp 29,6 √ null
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofccontrolcheck R
cof_c_alinea_id numeric 10 √ NULL::numeric
cof_c_alinea.cof_c_alinea_id cofcalinea_cofccontrolcheck R
cof_c_alinea2_id numeric 10 √ NULL::numeric
cof_c_alinea.cof_c_alinea_id cofcalinea2_cofccontrolcheck R
cof_reasonchange varchar 250 √ NULL::character varying
isreconciled bpchar 1 √ NULL::bpchar
changetype bpchar 1 √ NULL::bpchar
changedate timestamp 29,6 √ null
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofccontrolc R
cof_changecheck bpchar 1 √ NULL::bpchar
cof_checkchangeto_id numeric 10 √ NULL::numeric
cof_c_controlcheck.cof_c_controlcheck_id cofcheckchangeto_cofccontrolch R
cof_isclearedcheck bpchar 1 √ 'N'::bpchar
cof_datecleared timestamp 29,6 √ null
cof_dateresubmit timestamp 29,6 √ null
cof_checkclearing bpchar 1 √ NULL::bpchar
cof_resubmitcheck bpchar 1 √ NULL::bpchar
processed bpchar 1 √ 'N'::bpchar
c_payment_id numeric 10 √ NULL::numeric
c_payment.c_payment_id cpayment_cofccontrolcheck R
cof_thirdcheck bpchar 1 √ null
cof_issuingname varchar 60 √ NULL::character varying
cof_cedente_cpfcnpj varchar 22 √ NULL::character varying
address1 varchar 60 √ NULL::character varying
cof_resetcheckclearing bpchar 1 √ NULL::bpchar
cof_c_controlcheck_uu varchar 36 √ NULL::character varying
cof_payment_id numeric 10 √ NULL::numeric
c_payment.c_payment_id cofpayment_cofccontrolcheck R
cof_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofbpartner_cofccontrolcheck R
isreceipt bpchar 1 √ 'Y'::bpchar
cof_dateresubmit2 timestamp 29,6 √ null
dateto timestamp 29,6 √ null
cof_ischangecheck bpchar 1 √ 'N'::bpchar
chequeno numeric 10 √ NULL::numeric
cof_processed bpchar 1 √ NULL::bpchar
bankname varchar 255 √ null
comments varchar 255 √ NULL::character varying
reference varchar 255 √ NULL::character varying
cof_c_checkcustody_id numeric 10 √ NULL::numeric
cof_c_checkcustody.cof_c_checkcustody_id cofccheckcustody_cofccontrolch R
cof_isowncheck bpchar 1 √ 'N'::bpchar
cof_useforpayment bpchar 1 √ 'N'::bpchar
c_bankaccount_id numeric 10 √ NULL::numeric
c_bankaccount.c_bankaccount_id cbankaccount_cofccontrolcheck R
cof_codbarracheque varchar 150 √ NULL::character varying
cof_isreconciled bpchar 1 √ 'N'::bpchar
routingno varchar 20 √ NULL::character varying
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cofccontrolcheck R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cofccontrolcheck R
cof_isprinted bpchar 1 'N'::bpchar
cof_faturareapresentacao_id numeric 10 √ null
c_invoice.c_invoice_id coffaturareapresentacao_cofcco R

Indexes

Constraint Name Type Sort Column(s)
cof_c_controlcheck_key Primary key Asc cof_c_controlcheck_id
cof_c_controlcheck_uu_idx Must be unique Asc cof_c_controlcheck_uu

Check Constraints

Constraint Name Constraint
cof_c_controlcheck_cof_thirdcheck_check ((cof_thirdcheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_useforpayment_check ((cof_useforpayment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_isreceipt_check ((isreceipt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_isreconciled_check ((isreconciled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_isowncheck_check ((cof_isowncheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_isclearedcheck_check ((cof_isclearedcheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_isprinted_check ((cof_isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_ischangecheck_check ((cof_ischangecheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_cof_isreconciled_check ((cof_isreconciled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_c_controlcheck_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation