uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

fin_debt

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	deb_id	Integer			nextval('"URX_PUBLIC".fin_debt_id_seq'::regclass)	Identificador
	deb_supplier_id	Integer				Fornecedor
	deb_unit_id	Integer				Unidade
	deb_credit_cell_id	Integer				Célula debitada
	deb_issue_date	Date				Data de Emissão
	deb_due_date	Date				Data de Vencimento
	deb_payment_date	Date				Data de Pagamento
	deb_group_id	SmallInt				Grupo
	deb_transaction_type_id	SmallInt				Forma de Pagamento
	deb_is_approved	SmallInt			0	Aprovado
	deb_is_loaded	SmallInt			0	Processado
	deb_status_id	SmallInt			1	Situação
	deb_delete_bit	SmallInt			0	Bit de Exclusão
	deb_value	Numeric(10, 2)			0	Valor Devido
	deb_interest_value	Numeric(10, 2)			0	Valor do Juro
	deb_total_value	Numeric(10, 2)			0	Valor Total
	deb_transaction_number	VarChar(50)				Nº. da Transação de Pagamento
	deb_description	VarChar(50)				Descrição
	deb_desc_short	VarChar(4)				Grupo (Legado)
	deb_number_legacy	VarChar(6)				Nº. do Lançamento do Legado

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_debt_credit_cell	URX_PUBLIC.fin_credit_cell	URX_PUBLIC.fin_debt	cre_id	deb_credit_cell_id
fk_fin_debt_group	URX_PUBLIC.fin_debt_group	URX_PUBLIC.fin_debt	deb_group_id	deb_group_id
fk_fin_debt_supplier	URX_PUBLIC.fin_supplier	URX_PUBLIC.fin_debt	sup_id	deb_supplier_id
fk_fin_debt_transaction_type	URX_PUBLIC.fin_transaction_type	URX_PUBLIC.fin_debt	tra_type_id	deb_transaction_type_id
fk_fin_debt_unit	URX_PUBLIC.adm_unit	URX_PUBLIC.fin_debt	uni_person_id	deb_unit_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_cash_flow_debt	URX_PUBLIC.fin_debt	URX_PUBLIC.fin_cash_flow	deb_id	cas_flow_debt_id
fk_fin_debt_check_debt	URX_PUBLIC.fin_debt	URX_PUBLIC.fin_debt_check	deb_id	deb_check_debt_id
fk_fin_debt_status_debt	URX_PUBLIC.fin_debt	URX_PUBLIC.fin_debt_status	deb_id	deb_status_deb_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL
tg_fin_debt_create	URX_PUBLIC.fin_debt				AFTER	FOR EACH ROW	"URX_PUBLIC"."_u ...

Used in Diagrams

Diagram Name

diagramA