| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| fin_invoice_feedback_item | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
| inv_feedback_item_our_number | BigInt | Identificação do Título (Nosso Número) | ||||||
|
| inv_feedback_item_id | Integer |
| nextval('"URX_PUBLIC".fin_invoice_feedback_item_id_seq'::regclass) | Identificador | |||
| inv_feedback_item_feedback_id | Integer |
| Arquivo |
| ||||
| inv_feedback_item_line | Integer | Posição | ||||||
| inv_feedback_item_event | Integer | Ocorrência | ||||||
| inv_feedback_item_event_date | Date | Data da Ocorrência | ||||||
| inv_feedback_item_due_date | Date |
| Data de Vencimento | |||||
| inv_feedback_item_credit_date | Date |
| Data de Crédito | |||||
| inv_feedback_item_title_value | Numeric(10, 2) |
| Valor do Título | |||||
| inv_feedback_item_credit_value | Numeric(10, 2) |
| Valor Pago | |||||
| inv_feedback_item_invoice_number | VarChar(9) |
| Nº do Documento | |||||
| inv_feedback_item_discount_granted_value | Numeric(10, 2) |
| Valor do Desconto Concedido | |||||
| inv_feedback_item_discount_effective_value | Numeric(10, 2) |
| Valor do Desconto Efetivo | |||||
| inv_feedback_item_interest_initial_value | Numeric(10, 2) |
| Valor do Juro Cobrado | |||||
| inv_feedback_item_interest_effective_value | Numeric(10, 2) |
| Valor do Juro Efetivo | |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_fin_invoice_feedback_item_feedback | URX_PUBLIC.fin_invoice_feedback_item | inv_feedback_item_feedback_id | ||
| ix_fin_invoice_feedback_item_our_number | URX_PUBLIC.fin_invoice_feedback_item | inv_feedback_item_our_number | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_invoice_feedback_item_feedback | URX_PUBLIC.fin_invoice_feedback | URX_PUBLIC.fin_invoice_feedback_item | inv_feedback_id | inv_feedback_item_feedback_id |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_invoice_status_fin_invoice_feedback | URX_PUBLIC.fin_invoice_feedback_item | URX_PUBLIC.fin_invoice_status | inv_feedback_item_id | inv_status_feedback_id |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_fin_invoice_feedback_item_create | URX_PUBLIC.fin_invoice_feedback_item |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |