Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | √ | null |
|
|
||
| ad_org_id | numeric | 10 | √ | null |
|
|
||
| createdby | numeric | 10 | √ | null |
|
|
||
| c_payment_id | numeric | 10 | √ | null |
|
|
||
| documentno | varchar | 30 | √ | null |
|
|
||
| c_bankaccount_id | numeric | 10 | √ | null |
|
|
||
| c_doctype_id | numeric | 10 | √ | null |
|
|
||
| c_bpartner_id | numeric | 10 | √ | null |
|
|
||
| descricaopagamento | varchar | 255 | √ | null |
|
|
||
| dateacct | timestamp | 29,6 | √ | null |
|
|
||
| cof_creditdate | timestamp | 29,6 | √ | null |
|
|
||
| cof_finalidadepagamento_id | numeric | 10 | √ | null |
|
|
||
| checkno | varchar | 20 | √ | null |
|
|
||
| payamt | numeric | 0 | √ | null |
|
|
||
| c_allocationhdr_id | numeric | 10 | √ | null |
|
|
||
| c_allocationline_id | numeric | 10 | √ | null |
|
|
||
| amount | numeric | 0 | √ | null |
|
|
||
| cof_interestamt | numeric | 0 | √ | null |
|
|
||
| cof_penaltyamt | numeric | 0 | √ | null |
|
|
||
| discountamt | numeric | 0 | √ | null |
|
|
||
| cof_alocacaofinalidade_id | numeric | 10 | √ | null |
|
|
||
| c_invoice_id | numeric | 10 | √ | null |
|
|
||
| lbr_docfiscal_id | numeric | 10 | √ | null |
|
|
||
| c_invoicepayschedule_id | numeric | 10 | √ | null |
|
|
||
| descricaofatura | varchar | 500 | √ | null |
|
|
||
| isreconciled | bpchar | 1 | √ | null |
|
|
||
| isreceipt | bpchar | 1 | √ | null |
|
|
||
| cof_payscheduleno | varchar | 20 | √ | null |
|
|