Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| cof_c_sped_contabil_id | numeric | 10 | null |
|
|
||||||
| ad_client_id | numeric | 10 | null |
|
|
||||||
| ad_org_id | numeric | 10 | null |
|
|
||||||
| isactive | bpchar | 1 | 'Y'::bpchar |
|
|
||||||
| created | timestamp | 29,6 | null |
|
|
||||||
| createdby | numeric | 10 | null |
|
|
||||||
| updated | timestamp | 29,6 | null |
|
|
||||||
| updatedby | numeric | 10 | null |
|
|
||||||
| c_period_id | numeric | 10 | √ | null |
|
|
|||||
| datefrom | timestamp | 29,6 | null |
|
|
||||||
| dateto | timestamp | 29,6 | null |
|
|
||||||
| processing | bpchar | 1 | √ | null |
|
|
|||||
| cof_isspedcontabil0 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isspedcontabili | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isspedcontabilj | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isspedcontabil9 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| comments | varchar | 255 | √ | NULL::character varying |
|
|
|||||
| cof_isr0001 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isr0007 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr0020 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr0150 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr0180 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr0990 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri001 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri010 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri015 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri020 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri030 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri050 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri051 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri052 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri075 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri100 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri155 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri200 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri250 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri300 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri310 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri350 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri355 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri500 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri510 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri555 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri550 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj001 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isrj005 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj100 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj150 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj800 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj900 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isrj930 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj990 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isr9001 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isr9900 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr9990 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri012 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri150 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri990 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isri151 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isr0000 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_isr9999 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_indesc | bpchar | 1 | NULL::bpchar |
|
|
||||||
| documentno | varchar | 10 | NULL::character varying |
|
|
||||||
| cof_natureofbook | varchar | 80 | √ | NULL::character varying |
|
|
|||||
| cof_inddec | bpchar | 1 | '0'::bpchar |
|
|
||||||
| cof_ind_sit_esp | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_elementdre_id | numeric | 10 | √ | null |
|
|
|||||
| cof_elementbal_id | numeric | 10 | √ | null |
|
|
|||||
| ad_orgdoc_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| ad_orgto_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_c_sped_contabil_uu | varchar | 36 | √ | NULL::character varying |
|
|
|||||
| cof_isr0035 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri053 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isri157 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj200 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj210 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj215 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrj935 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_elementfrom_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| c_element_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_elementcostcentre_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_codplanref | varchar | 2 | '1'::character varying |
|
|
||||||
| cof_iddem | bpchar | 1 | '1'::bpchar |
|
|
||||||
| cof_ind_fin_esc | bpchar | 1 | '0'::bpchar |
|
|
||||||
| cof_tip_ecd | bpchar | 1 | '0'::bpchar |
|
|
||||||
| c_acctschema_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_isspedcontabilk | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk001 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk030 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk100 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk110 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk115 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk200 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk210 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk300 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk310 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk315 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isk990 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_notabalanco | varchar | 200 | √ | NULL::character varying |
|
|
|||||
| cof_notadlpa | varchar | 200 | √ | NULL::character varying |
|
|
|||||
| cof_notadre | varchar | 200 | √ | NULL::character varying |
|
|
|||||
| cof_indmudancpc | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_codverlc | varchar | 7 | √ | NULL::character varying |
|
|
|||||
| cof_indcentralizada | bpchar | 1 | '0'::bpchar |
|
|
||||||
| cof_isspedcontabilc | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_isrc001 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrc040 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_isrc150 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_isrc155 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_isrc600 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_isrc650 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_isrc990 | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_apuracaoresultado | bpchar | 1 | 'A'::bpchar |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cof_c_sped_contabil_key | Primary key | Asc | cof_c_sped_contabil_id |
| cof_c_sped_contabil_uu_idx | Must be unique | Asc | cof_c_sped_contabil_uu |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| cof_c_sped_contabil_cof_isr0150_check | ((cof_isr0150 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri250_check | ((cof_isri250 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk310_check | ((cof_isk310 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc001_check | ((cof_isrc001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr9900_check | ((cof_isr9900 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0007_check | ((cof_isr0007 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri200_check | ((cof_isri200 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri075_check | ((cof_isri075 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0180_check | ((cof_isr0180 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj150_check | ((cof_isrj150 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk001_check | ((cof_isk001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri050_check | ((cof_isri050 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri500_check | ((cof_isri500 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri010_check | ((cof_isri010 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri051_check | ((cof_isri051 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0035_check | ((cof_isr0035 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk110_check | ((cof_isk110 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj001_check | ((cof_isrj001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc040_check | ((cof_isrc040 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabilj_check | ((cof_isspedcontabilj = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri015_check | ((cof_isri015 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri150_check | ((cof_isri150 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri300_check | ((cof_isri300 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj930_check | ((cof_isrj930 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0001_check | ((cof_isr0001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk030_check | ((cof_isk030 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri355_check | ((cof_isri355 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk210_check | ((cof_isk210 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr9001_check | ((cof_isr9001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk300_check | ((cof_isk300 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri155_check | ((cof_isri155 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj100_check | ((cof_isrj100 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabil9_check | ((cof_isspedcontabil9 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0990_check | ((cof_isr0990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri555_check | ((cof_isri555 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk315_check | ((cof_isk315 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri001_check | ((cof_isri001 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri151_check | ((cof_isri151 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj005_check | ((cof_isrj005 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj200_check | ((cof_isrj200 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri310_check | ((cof_isri310 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabili_check | ((cof_isspedcontabili = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk200_check | ((cof_isk200 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri510_check | ((cof_isri510 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabil0_check | ((cof_isspedcontabil0 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk100_check | ((cof_isk100 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri030_check | ((cof_isri030 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabilc_check | ((cof_isspedcontabilc = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc155_check | ((cof_isrc155 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri012_check | ((cof_isri012 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri020_check | ((cof_isri020 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc650_check | ((cof_isrc650 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri550_check | ((cof_isri550 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj210_check | ((cof_isrj210 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri157_check | ((cof_isri157 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj800_check | ((cof_isrj800 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isspedcontabilk_check | ((cof_isspedcontabilk = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0020_check | ((cof_isr0020 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr9999_check | ((cof_isr9999 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr9990_check | ((cof_isr9990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc990_check | ((cof_isrc990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri350_check | ((cof_isri350 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri052_check | ((cof_isri052 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isr0000_check | ((cof_isr0000 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj215_check | ((cof_isrj215 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk990_check | ((cof_isk990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj900_check | ((cof_isrj900 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj935_check | ((cof_isrj935 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc150_check | ((cof_isrc150 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrc600_check | ((cof_isrc600 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri100_check | ((cof_isri100 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri990_check | ((cof_isri990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isrj990_check | ((cof_isrj990 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isk115_check | ((cof_isk115 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sped_contabil_cof_isri053_check | ((cof_isri053 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |