fin_bank_order_feedback_item

fin_bank_order_feedback_item - Table

uranux_desenv [uranux.xml]

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	ban_order_feedback_item_id	Integer			nextval('"URX_PUBLIC".fin_bank_order_feedback_item_id_seq'::regclass)	Identificador
	ban_order_feedback_item_feedback_id	Integer				Retorno da Ordem de Pagamento
	ban_order_feedback_item_line	Integer				Posição
	ban_order_feedback_item_item_id	Integer				Item da Ordem de Pagamento
	ban_order_feedback_item_acc_agency	Integer				Agência
	ban_order_feedback_item_acc_number	Integer				Conta Corrente
	ban_order_feedback_item_planned_date	Date				Data Prevista
	ban_order_feedback_item_effective_date	Date				Data Efetiva
	ban_order_feedback_item_planned_value	Numeric(10, 2)				Valor Previsto
	ban_order_feedback_item_effective_value	Numeric(10, 2)				Valor Efetivo
	ban_order_feedback_item_name	VarChar(30)				Nome do Favorecido
	ban_order_feedback_item_add_street	VarChar(30)				Nome da Rua
	ban_order_feedback_item_our_number	VarChar(20)				Nosso Número
	ban_order_feedback_item_add_city	VarChar(20)				Cidade
	ban_order_feedback_item_add_comp	VarChar(15)				Complemento
	ban_order_feedback_item_add_neighbor	VarChar(15)				Bairro
	ban_order_feedback_item_legal	VarChar(14)				Nº de Inscrição
	ban_order_feedback_item_event	VarChar(10)				Ocorrência
	ban_order_feedback_item_add_cep	VarChar(8)				CEP
	ban_order_feedback_item_add_number	VarChar(5)				Número
	ban_order_feedback_item_acc_bank_id	VarChar(3)				Banco
	ban_order_feedback_item_add_uf	VarChar(2)				UF
	ban_order_feedback_item_acc_agency_dv	VarChar(1)				Dígito Verificador da Agência
	ban_order_feedback_item_acc_number_dv	VarChar(1)				Dígito Verificador da Conta

Indexes
Name	Table	Columns	Unique	Clustered
ix_fin_bank_order_feedback_item_feedback	URX_PUBLIC.fin_bank_order_feedback_item	ban_order_feedback_item_feedback_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_fin_bank_order_feedback_item_bank_order_item	URX_PUBLIC.fin_bank_order_item	URX_PUBLIC.fin_bank_order_feedback_item	ban_order_item_id	ban_order_feedback_item_item_id
fk_fin_bank_order_feedback_item_feedback	URX_PUBLIC.fin_bank_order_feedback	URX_PUBLIC.fin_bank_order_feedback_item	ban_order_feedback_id	ban_order_feedback_item_feedback_id

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