| Název | Popis | Datový typ |
|---|---|---|
| InAudited | Char(1) | |
| InAccDateFrom | Float(0, 0) | |
| InAccDateTo | Float(0, 0) | |
| InDivisionSelID | Char(10) | |
| InBusOrderSelID | Char(10) | |
| InBusOrdersWithChilds | Char(1) | |
| InBusTransactionSelID | Char(10) | |
| InBusTransactionsWithChilds | Char(1) | |
| InBusProjectSelID | Char(10) | |
| InBusProjectsWithChilds | Char(1) | |
| InFirmSelID | Char(10) | |
| InIncludeRequests | Char(1) | |
| InDivisionsWithChilds | Char(1) |
| Název | Popis | Datový typ |
|---|---|---|
| AccountCode | VarChar(10) | |
| Taxable | Char(1) | |
| Short | Char(1) | |
| AccountType | Char(1) | |
| DivisionCode | VarChar(5) | |
| DebitBeginning | Numeric(15, 2) | |
| CreditBeginning | Numeric(15, 2) | |
| DebitTurnover | Numeric(15, 2) | |
| CreditTurnover | Numeric(15, 2) | |
| Account_ID | Char(10) | |
| IsIncomplete | Char(1) | |
| Division_ID | Char(10) | |
| TypeOfActivity | Integer | |
| Firm_ID | Char(10) |
| Název | Popis | Třída |
|---|---|---|
| GetFirstPeriodByDates | Vrátí první možné období dle zadaných datumů. Zohledňuje první možné období kvůli pokladnám (které začínají od určitého období) | Procedures |
| RepAccStatementsPKP1 | Procedures |
BEGIN
Period_ID = NULL;
SELECT P.ID, P.DateFrom$Date
FROM Periods P
WHERE P.ID = (SELECT RPeriod_ID FROM GetFirstperiodByDates(:InAccDateFrom, :InAccDateTo, ''))
INTO :Period_ID, mDateFrom;
IF (Period_ID IS NOT NULL) THEN BEGIN
FOR
SELECT
A.Account_ID,
MAX(AC.Code) AS AccountCode,
A.Division_ID,
MAX(D.Code) AS DivisionCode,
SUM(A.DebitBeginning),
SUM(A.CreditBeginning),
SUM(A.DebitTurnover),
SUM(A.CreditTurnover),
MAX(AC.Taxable),
MAX(AC.Short),
MAX(AC.AccountType),
MAX(AC.IsIncomplete),
MAX(AC.TypeOfActivity),
A.Firm_ID
FROM
RepAccStatementsPKP1(:InAudited, :Period_ID, :mDateFrom, :InAccDateFrom, :InAccDateTo,
:InDivisionSelID, :InBusOrderSelID, :InBusOrdersWithChilds,
:InBusTransactionSelID, :InBusTransactionsWithChilds,
:InBusProjectSelID, :InBusProjectsWithChilds,
:InFirmSelID, :InIncludeRequests, :InDivisionsWithChilds) A
LEFT join Divisions D ON A.Division_ID = D.ID
LEFT join Accounts AC ON A.Account_ID = AC.ID
GROUP BY
A.Account_ID, A.Division_ID, A.Firm_ID
INTO
:Account_ID, :AccountCode, :Division_ID, :DivisionCode, :DebitBeginning,
:CreditBeginning, :DebitTurnover, :CreditTurnover, :Taxable,:Short, :AccountType,
:IsIncomplete, :TypeOfActivity, :Firm_ID
DO
IF (Account_ID is not null ) THEN
SUSPEND;
END
END;Generated by ABRA Software a.s. 27.10.2021 16:34:17