Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| lbr_taxline_id | numeric | 10 | null |
|
|
||||||
| ad_org_id | numeric | 10 | null |
|
|
||||||
| ad_client_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 |
|
|
||||||
| lbr_tax_id | numeric | 10 | null |
|
|
||||||
| lbr_taxrate | numeric | 0 | √ | null |
|
|
|||||
| lbr_taxbase | numeric | 0 | √ | null |
|
|
|||||
| lbr_taxamt | numeric | 0 | √ | null |
|
|
|||||
| lbr_taxname_id | numeric | 10 | null |
|
|
||||||
| lbr_taxbaseamt | numeric | 0 | √ | null |
|
|
|||||
| istaxincluded | bpchar | 1 | 'N'::bpchar |
|
|
||||||
| lbr_legalmessage_id | numeric | 10 | √ | null |
|
|
|||||
| lbr_taxstatus_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| ismanual | bpchar | 1 | √ | NULL::bpchar |
|
|
|||||
| cof_overridetaxrate | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridetaxbase | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridetaxstatus | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridetaxlm | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| lbr_taxline_uu | varchar | 36 | √ | NULL::character varying |
|
|
|||||
| cof_modbc_id | numeric | 10 | √ | null |
|
|
|||||
| cof_overridemodbc | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridelistamt | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridemvarate | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_mvarate | numeric | 0 | √ | (0)::numeric |
|
|
|||||
| cof_listamt | numeric | 0 | √ | (0)::numeric |
|
|
|||||
| cof_printondelivery | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_taxstatusdelivery_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_cenq_id | numeric | 10 | √ | null |
|
|
|||||
| cof_overridecenq | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| lbr_formula_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_overrideformula | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_cnpjprod | varchar | 14 | √ | NULL::character varying |
|
|
|||||
| cof_vdespadu | numeric | 0 | √ | (0)::numeric |
|
|
|||||
| cof_viof | numeric | 0 | √ | null |
|
|
|||||
| cof_siscomexamt | numeric | 0 | √ | null |
|
|
|||||
| cof_overridemotdeson | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_overridedesonrate | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_desonrate | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_desonamt | numeric | 0 | √ | null |
|
|
|||||
| cof_motdeson_id | numeric | 10 | √ | NULL::numeric |
|
|
|||||
| cof_overridedifrate | bpchar | 1 | √ | 'N'::bpchar |
|
|
|||||
| cof_difrate | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_difamt | numeric | 0 | √ | '0'::numeric |
|
|
|||||
| cof_valornaoretido | numeric | 0 | '0'::numeric |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| lbr_taxline_key | Primary key | Asc | lbr_taxline_id |
| lbr_taxline_key2 | Must be unique | Asc/Asc | lbr_tax_id + lbr_taxname_id |
| lbr_taxline_uu_idx | Must be unique | Asc | lbr_taxline_uu |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| lbr_taxline_cof_overridetaxlm_check | ((cof_overridetaxlm = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_istaxincluded_check | ((istaxincluded = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridetaxbase_check | ((cof_overridetaxbase = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_ismanual_check | ((ismanual = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridelistamt_check | ((cof_overridelistamt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_printondelivery_check | ((cof_printondelivery = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridemvarate_check | ((cof_overridemvarate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridemodbc_check | ((cof_overridemodbc = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridetaxstatus_check | ((cof_overridetaxstatus = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridetaxrate_check | ((cof_overridetaxrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridedesonrate_check | ((cof_overridedesonrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overrideformula_check | ((cof_overrideformula = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridecenq_check | ((cof_overridecenq = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridedifrate_check | ((cof_overridedifrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
| lbr_taxline_cof_overridemotdeson_check | ((cof_overridemotdeson = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |