DESK_JOURNAL

"localhost:/firebird/data/ILICHEVSK2.FDB". Процедуры

DESK_JOURNAL_SHIP

Входные параметры

Параметр	Тип	Описание
SAMPLERINBEGINDATE	DATE
SAMPLERINENDDATE	DATE
AOPERATIONID	INTEGER
ASTORAGEID	INTEGER

Выходные параметры

Параметр	Тип	Описание
INVENTORYID	INTEGER
REGDATE	DATE
ORDERLOADID	INTEGER
ORDERLOADITEMID	INTEGER
SAMPLERINDATE	DATE
TRANSPORTNUMBER	VARCHAR(25)
INVOICEID	INTEGER
STORAGEID	INTEGER
STORAGENAME	VARCHAR(100)
SILAGEID	INTEGER
ROUTEID	INTEGER
PLATFORMID	INTEGER
SILAGENAME	VARCHAR(255)
GROSSTIME	TIMESTAMP
TARETIME	TIMESTAMP
GROSS	INTEGER
TARE	INTEGER
NET	INTEGER
INVOICEGROSS	INTEGER
INVOICETARE	INTEGER
INVOICENET	INTEGER
WEIGHTNUMBER	INTEGER
NETDEFICITE	BIGINT
SAMPLERQUALITYID	INTEGER
TRANSPORTTYPEID	INTEGER
STATIONNAME	VARCHAR(30)
OPERATIONID	INTEGER
CROPFULLNAME	VARCHAR(100)
INVOICENUMBER	VARCHAR(31)
OWNERID	INTEGER
PROVIDERID	INTEGER
CLIENTNAME	VARCHAR(30)
SILAGEUSERNAME	VARCHAR(31)
STATE	INTEGER

Описание

(Нет описания для процедуры DESK_JOURNAL_SHIP)

Определение

CREATE PROCEDURE DESK_JOURNAL_SHIP(
    SAMPLERINBEGINDATE DATE,
    SAMPLERINENDDATE DATE,
    AOPERATIONID INTEGER,
    ASTORAGEID INTEGER)
RETURNS (
    INVENTORYID INTEGER,
    REGDATE DATE,
    ORDERLOADID INTEGER,
    ORDERLOADITEMID INTEGER,
    SAMPLERINDATE DATE,
    TRANSPORTNUMBER VARCHAR(25),
    INVOICEID INTEGER,
    STORAGEID INTEGER,
    STORAGENAME VARCHAR(100),
    SILAGEID INTEGER,
    ROUTEID INTEGER,
    PLATFORMID INTEGER,
    SILAGENAME VARCHAR(255),
    GROSSTIME TIMESTAMP,
    TARETIME TIMESTAMP,
    GROSS INTEGER,
    TARE INTEGER,
    NET INTEGER,
    INVOICEGROSS INTEGER,
    INVOICETARE INTEGER,
    INVOICENET INTEGER,
    WEIGHTNUMBER INTEGER,
    NETDEFICITE BIGINT,
    SAMPLERQUALITYID INTEGER,
    TRANSPORTTYPEID INTEGER,
    STATIONNAME VARCHAR(30),
    OPERATIONID INTEGER,
    CROPFULLNAME VARCHAR(100),
    INVOICENUMBER VARCHAR(31),
    OWNERID INTEGER,
    PROVIDERID INTEGER,
    CLIENTNAME VARCHAR(30),
    SILAGEUSERNAME VARCHAR(31),
    STATE INTEGER)
AS
BEGIN EXIT; END