Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| cof_c_sintegra_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 |
|
|
||||||
| datefrom | timestamp | 29,6 | null |
|
|
||||||
| dateto | timestamp | 29,6 | null |
|
|
||||||
| cof_issintegra10 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_issintegra11 | bpchar | 1 | √ | 'Y'::bpchar |
|
|
|||||
| cof_issintegra50 | bpchar | 1 | √ | null |
|
|
|||||
| cof_issintegra51 | bpchar | 1 | √ | null |
|
|
|||||
| cof_issintegra53 | bpchar | 1 | √ | null |
|
|
|||||
| cof_issintegra90 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra86 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra85 | bpchar | 1 | √ | null |
|
|
|||||
| cof_issintegra77 | bpchar | 1 | √ | null |
|
|
|||||
| cof_issintegra76 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra75 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra74 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra71 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra70 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra61 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra60 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra57 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra56 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra55 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_issintegra54 | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| file_directory | varchar | 150 | null |
|
|
||||||
| processing | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| comments | varchar | 255 | √ | NULL::character varying |
|
|
|||||
| c_period_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_finality | bpchar | 1 | null |
|
|
||||||
| cof_natop | bpchar | 1 | √ | null |
|
|
|||||
| datevalue | timestamp | 29,6 | √ | null |
|
|
|||||
| cof_c_sintegra_uu | varchar | 36 | √ | NULL::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cof_c_sintegra_key | Primary key | Asc | cof_c_sintegra_id |
| cof_c_sintegra_uu_idx | Must be unique | Asc | cof_c_sintegra_uu |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| cof_c_sintegra_cof_issintegra55_check | ((cof_issintegra55 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra90_check | ((cof_issintegra90 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra51_check | ((cof_issintegra51 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra61_check | ((cof_issintegra61 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra10_check | ((cof_issintegra10 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra11_check | ((cof_issintegra11 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra71_check | ((cof_issintegra71 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra76_check | ((cof_issintegra76 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra74_check | ((cof_issintegra74 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra56_check | ((cof_issintegra56 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra85_check | ((cof_issintegra85 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra50_check | ((cof_issintegra50 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra75_check | ((cof_issintegra75 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra86_check | ((cof_issintegra86 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra53_check | ((cof_issintegra53 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra70_check | ((cof_issintegra70 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra57_check | ((cof_issintegra57 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra60_check | ((cof_issintegra60 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra54_check | ((cof_issintegra54 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| cof_c_sintegra_cof_issintegra77_check | ((cof_issintegra77 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |