ITFULL

"localhost:/firebird/data/ILICHEVSK2.FDB". Представления

ITFULL

Описание

(Нет описания для представления ITFULL)

Поля

Поле	Тип	Описание
INVENTORYID	INTEGER
PARENTID	INTEGER
PARTYID	INTEGER
REGDATE	DATE
OPERATIONID	INTEGER
OPERATIONPARAM	INTEGER
INVOICEID	INTEGER
REGISTERID	INTEGER
GROSS	INTEGER
TARE	INTEGER
NET	INTEGER
WEIGHT	INTEGER
PACKID	INTEGER
CARGOQUANTITY	INTEGER
TARETIME	TIMESTAMP
GROSSTIME	TIMESTAMP
OWNERID	INTEGER
PROVIDERID	INTEGER
RELATIONID	INTEGER
SAMPLERQUALITYID	INTEGER
LABQUALITYID	INTEGER
BUHQUALITYID	INTEGER
SILAGEID	INTEGER
SILAGEUSERID	INTEGER
ROUTEID	INTEGER
STORAGEID	INTEGER
STORINGID	INTEGER
CONTRACTID	INTEGER
UWORDERID	INTEGER
WEIGHTNUMBER	INTEGER
WEIGHTUSERID	INTEGER
LOADCONFIRMTIME	TIMESTAMP
STATE	INTEGER
COMMENT	VARCHAR(255)
ITTRANSPORTINVENTORYID	INTEGER
BARCODE	VARCHAR(31)
ORDERLOADITEMID	INTEGER
CAPACITYWEIGHT	INTEGER
CAPACITYVOLUME	INTEGER
SAMPLERINDATE	DATE
SAMPLERINTIME	TIME
SAMPLEROUTDATE	DATE
SAMPLEROUTTIME	TIME
TAREBYHAND	SMALLINT
GROSSBYHAND	SMALLINT
LOADTIME	TIMESTAMP
TRANSPORTTYPEID	INTEGER
TRANSPORTNUMBER	VARCHAR(31)
CHECKPOINTINTIME	TIMESTAMP
CHECKPOINTOUTTIME	TIMESTAMP
WEIGHTSESSION	INTEGER
INVOICEGROSS	INTEGER
INVOICETARE	INTEGER
INVOICENET	INTEGER
SENDERQUALITYID	INTEGER
OWNERFIELDID	INTEGER
BUNKERS	DECIMAL(2,1)
GRAINFIELDOUTTIME	TIMESTAMP
CHECKPOINTSESSION	INTEGER
SAMPLERSESSION	INTEGER

Триггеры

(Нет триггеров для представления ITFULL)

Определение

CREATE VIEW ITFULL(
    INVENTORYID,
    PARENTID,
    PARTYID,
    REGDATE,
    OPERATIONID,
    OPERATIONPARAM,
    INVOICEID,
    REGISTERID,
    GROSS,
    TARE,
    NET,
    WEIGHT,
    PACKID,
    CARGOQUANTITY,
    TARETIME,
    GROSSTIME,
    OWNERID,
    PROVIDERID,
    RELATIONID,
    SAMPLERQUALITYID,
    LABQUALITYID,
    BUHQUALITYID,
    SILAGEID,
    SILAGEUSERID,
    ROUTEID,
    STORAGEID,
    STORINGID,
    CONTRACTID,
    UWORDERID,
    WEIGHTNUMBER,
    WEIGHTUSERID,
    LOADCONFIRMTIME,
    STATE,
    COMMENT,
    ITTRANSPORTINVENTORYID,
    BARCODE,
    ORDERLOADITEMID,
    CAPACITYWEIGHT,
    CAPACITYVOLUME,
    SAMPLERINDATE,
    SAMPLERINTIME,
    SAMPLEROUTDATE,
    SAMPLEROUTTIME,
    TAREBYHAND,
    GROSSBYHAND,
    LOADTIME,
    TRANSPORTTYPEID,
    TRANSPORTNUMBER,
    CHECKPOINTINTIME,
    CHECKPOINTOUTTIME,
    WEIGHTSESSION,
    INVOICEGROSS,
    INVOICETARE,
    INVOICENET,
    SENDERQUALITYID,
    OWNERFIELDID,
    BUNKERS,
    GRAINFIELDOUTTIME,
    CHECKPOINTSESSION,
    SAMPLERSESSION)
AS
select
  IT.INVENTORYID,
  IT.PARENTID,
  IT.PARTYID,
  IT.REGDATE,
  IT.OPERATIONID,
  IT.OPERATIONPARAM,
  IT.INVOICEID,
  IT.REGISTERID,
  IT.GROSS,
  IT.TARE,
  IT.NET,
  IT.WEIGHT,
  IT.PACKID,
  IT.CARGOQUANTITY,
  IT.TARETIME,
  IT.GROSSTIME,
  IT.OWNERID,
  IT.PROVIDERID,
  IT.RELATIONID,
  IT.SAMPLERQUALITYID,
  IT.LABQUALITYID,
  IT.BUHQUALITYID,
  IT.SILAGEID,
  IT.SILAGEUSERID,
  IT.ROUTEID,
  IT.STORAGEID,
  IT.STORINGID,
  IT.CONTRACTID,
  IT.UWORDERID,
  IT.WEIGHTNUMBER,
  IT.WEIGHTUSERID,
  IT.LOADCONFIRMTIME,
  IT.STATE,
  IT.COMMENT,
  ITTRANSPORT.INVENTORYID as ITTRANSPORTINVENTORYID,
  ITTRANSPORT.BARCODE,
  IT.ORDERLOADITEMID,
  ITTRANSPORT.CAPACITYWEIGHT,
  ITTRANSPORT.CAPACITYVOLUME,
  ITTRANSPORT.SAMPLERINDATE,
  ITTRANSPORT.SAMPLERINTIME,
  ITTRANSPORT.SAMPLEROUTDATE,
  ITTRANSPORT.SAMPLEROUTTIME,
  ITTRANSPORT.TAREBYHAND,
  ITTRANSPORT.GROSSBYHAND,
  ITTRANSPORT.LOADTIME,
  ITTRANSPORT.TRANSPORTTYPEID,
  ITTRANSPORT.TRANSPORTNUMBER,
  ITTRANSPORT.CHECKPOINTINTIME,
  ITTRANSPORT.CHECKPOINTOUTTIME,
  ITTRANSPORT.WEIGHTSESSION,
  ITTRANSPORT.INVOICEGROSS,
  ITTRANSPORT.INVOICETARE,
  ITTRANSPORT.INVOICENET,
  ITTRANSPORT.SENDERQUALITYID,
  ITTRANSPORT.OWNERFIELDID,
  ITTRANSPORT.BUNKERS,
  ITTRANSPORT.GRAINFIELDOUTTIME,
  ITTRANSPORT.CHECKPOINTSESSION,
  ITTRANSPORT.SAMPLERSESSION
from IT
left join ITTransport on (ITTransport.InventoryID = IT.InventoryID)
;