| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| fin_billing_tax | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| bil_tax_id | Integer |
| nextval('"URX_PUBLIC".fin_billing_tax_id_seq'::regclass) | Identificador | |||
| bil_tax_billing_id | SmallInt | Nota Fiscal |
|
|
||||
| bil_tax_tax_id | SmallInt | Imposto |
|
|
||||
| bil_tax_delete_bit | SmallInt | 0 | Bit de Exclusão |
|
||||
| bil_tax_percent | Numeric(10, 2) | Alíquota | ||||||
| bil_tax_value | Numeric(10, 2) | 0 | Valor | |||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_billing_tax_fin_invoice | URX_PUBLIC.fin_invoice | URX_PUBLIC.fin_billing_tax | inv_id | bil_tax_billing_id |
| fk_fin_billing_tax_fin_taxing | URX_PUBLIC.fin_taxing | URX_PUBLIC.fin_billing_tax | tax_id | bil_tax_tax_id |
| Parent Relations (none) |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_fin_billing_tax_create | URX_PUBLIC.fin_billing_tax |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |