PARMPERDATRANSF

Tabela do sistema

DDL: docs/schema/tables/PARMPERDATRANSF.sql

Chave primaria: (CD_PERDATRANSF)

Total de colunas: 11

Campos

Campo	Tipo	Obrig
CD_PERDATRANSF	INTEGER	✓
DS_PERDATRANSF	VARCHAR(60)	✓
CD_ITEMORIG	INTEGER	✓
CD_TPLOCALORIG	INTEGER
CD_LOCALORIG	INTEGER	✓
CD_ITEMDEST	INTEGER	✓
CD_TPLOCALDEST	INTEGER
CD_LOCALDEST	INTEGER	✓
CD_OPERACAO	INTEGER	✓
CD_HISTORICO	INTEGER
DT_REGISTRO	TIMESTAMP	✓

Relacionamentos (Foreign Keys)

Constraint	Coluna(s)	Referencia
FK_HISTOPARMTRANSF_HISTORICO	CD_HISTORICO	HISTORICO (CD_HISTORICO)
FK_ITEMDEST_ITEM	CD_ITEMDEST	ITEM (CD_ITEM)
FK_ITEMORIG_ITEM	CD_ITEMORIG	ITEM (CD_ITEM)
FK_LOCALDEST_TPLOCDEST_LOCAL	CD_LOCALDEST, CD_TPLOCALDEST	LOCALESTOQUE (CD_LOCAL, CD_TIPOLOCAL)
FK_LOCALORIG_TPLOCORIG_LOCAL	CD_LOCALORIG, CD_TPLOCALORIG	LOCALESTOQUE (CD_LOCAL, CD_TIPOLOCAL)
FK_OPERACAOPARMTRANSF_OPERACAO	CD_OPERACAO	OPERACAO (CD_OPERACAO)