cof_rv_checkallocate

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
cof_c_controlcheck_id numeric 10 √ null
cof_c_controlcheck.cof_c_controlcheck_id Implied Constraint R
cof_codbarracheque varchar 150 √ null
c_payment_id numeric 10 √ null
c_payment.c_payment_id Implied Constraint R
cof_payment_id numeric 10 √ null
isreconciled bpchar 1 √ null
cof_isreconciled bpchar 1 √ null
comments varchar 255 √ null
reference varchar 255 √ null
isactive bpchar 1 √ null
isreceipt bpchar 1 √ null
cof_useforpayment bpchar 1 √ null
cof_isowncheck bpchar 1 √ null
c_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id Implied Constraint R
cof_thirdcheck bpchar 1 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
cof_issuingname varchar 60 √ null
cof_cedente_cpfcnpj varchar 22 √ null
address1 varchar 60 √ null
cof_bpartner_id numeric 10 √ null
c_bank_id numeric 10 √ null
c_bank.c_bank_id Implied Constraint R
bankname varchar 255 √ null
cof_agencyno varchar 40 √ null
cof_agencydigit varchar 20 √ null
cof_accountno varchar 20 √ null
cof_accountdigit varchar 20 √ null
routingno varchar 20 √ null
chequeno numeric 10 √ null
cof_serie varchar 5 √ null
cof_datecleared timestamp 29,6 √ null
datedoc timestamp 29,6 √ null
dateto timestamp 29,6 √ null
totalamt numeric 0 √ null
cof_c_checkcustody_id numeric 10 √ null
cof_c_checkcustody.cof_c_checkcustody_id Implied Constraint R
cof_isclearedcheck bpchar 1 √ null
cof_c_alinea_id numeric 10 √ null
cof_c_alinea.cof_c_alinea_id Implied Constraint R
cof_c_alinea2_id numeric 10 √ null
cof_dateresubmit timestamp 29,6 √ null
cof_dateresubmit2 timestamp 29,6 √ null
changetype bpchar 1 √ null
cof_checkchangeto_id numeric 10 √ null
changedate timestamp 29,6 √ null
cof_ischangecheck bpchar 1 √ null
cof_reasonchange varchar 250 √ null
user2_id numeric 10 √ null
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
c_invoicepayschedule_id numeric 10 √ null
c_invoicepayschedule.c_invoicepayschedule_id Implied Constraint R
amount numeric 0 √ null
writeoffamt numeric 0 √ null
cof_interestamt numeric 0 √ null
invoiceamt numeric 0 √ null
discountamt numeric 0 √ null
overunderamt numeric 0 √ null
cof_penaltyamt numeric 0 √ null
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id Implied Constraint R
cof_tipoparceiro_id numeric 10 √ null
cof_tipoparceiro.cof_tipoparceiro_id Implied Constraint R
cof_classeparceiro_id numeric 10 √ null
cof_classeparceiro.cof_classeparceiro_id Implied Constraint R
numpedido varchar 30 √ null
numdocfiscal varchar 30 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views