| Jméno |
Typ |
Velikost |
Výraz |
CLSID |
Popis |
| IssuedOrderQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(ior.Quantity AS Numeric(15,6)) - CAST(ior.deliveredQuantity AS Numeric(15,6)))
FROM
IssuedOrders2 IOR
JOIN IssuedOrders IO ON IO.ID = IOR.Parent_ID
WHERE
((IOR.StoreCard_ID = a.StoreCard_ID) and
(io.closed = 'N') and (IOR.Revided_id is null) and
((ior.Quantity - ior.deliveredQuantity) > 0))
)
|
|
Množství na objednávkách vydaných |
| JobOrderQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(MI2.Quantity as Numeric(15,6))
* CAST(MIPL2.Quantity as Numeric(15,6))
* (CAST(1 AS Float) + (CAST(MIPL2.WastePercentage as Numeric(15,6)) / CAST(100 as Float)))
)
FROM PLMJOInputItems MIPL2
JOIN PLMJONodes NMIPL ON NMIPL.ID = MIPL2.Owner_ID
JOIN PLMJONodes NMI ON NMI.ID = NMIPL.Master_ID
JOIN PLMJOOutputItems MI2 ON MI2.Owner_ID = NMI.ID
JOIN PLMJobOrders JO ON JO.ID = NMIPL.Parent_ID
where
(JO.FinishedAt$Date = 0 and NMIPL.Issue = 0
and NMIPL.Storecard_ID = a.storecard_ID)
)
|
|
Množství požadované výrobními příkazy |
| JOMatDistribQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(sd21.quantity AS Numeric(15,6)))
FROM storedocuments2 sd21
JOIN plmmiplmaterialdistrib md1 ON md1.storedocument2_id = sd21.id
JOIN PLMJOInputItems mipl1 on mipl1.id = md1.parent_id
JOIN PLMJONodes NMIPL ON NMIPL.ID = mipl1.Owner_id
JOIN plmjoborders jo1 on jo1.id = NMIPL.parent_id
WHERE
(JO1.FinishedAt$Date = 0 and NMIPL.Issue = 0 and sd21.storecard_ID = a.storecard_ID)
)
|
|
Výrobní příkazy - vydané množství |
| JORMatDistribQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(sd22.quantity AS Numeric(15,6)))
FROM storedocuments2 sd22
JOIN plmmiplrmaterialdistrib md2 ON md2.storedocument2_id = sd22.id
JOIN PLMJOInputItems mipl2 on mipl2.id = md2.parent_id
JOIN PLMJONodes NMIPL ON NMIPL.ID = mipl2.Owner_ID
JOIN plmjoborders jo2 on jo2.id = NMIPL.Parent_ID
WHERE
(JO2.FinishedAt$Date = 0 and NMIPL.Issue = 0 and sd22.storecard_ID = a.storecard_ID)
)
|
|
Výrobní příkazy - vrácené množství |
| OutLevel |
dtInteger |
10 |
a.outlevel
|
|
Zanoření |
| outQuantity |
dtFloat |
15 |
a.Quantity
|
|
Množství |
| outUnit |
dtString |
5 |
a.qUnit
|
|
Jednotka |
| outUnitRate |
dtFloat |
15 |
a.UnitRate
|
|
Vztah jednotky |
| OverallQuantity |
dtFloat |
15 |
a.OverallQuantity
|
|
Kumulované množství |
| PLCount |
dtInteger |
10 |
(
select count(id)
from
PLMPieceLists2
where
parent_id = R.Parent_ID
)
|
|
Počet řádků PL |
| ProduceRequestQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(MI1.Quantity as Numeric(15,6))
* CAST(MIPL1.Quantity as Numeric(15,6))
* (CAST(1 AS Float) + (CAST(MIPL1.WastePercentage as Numeric(15,6)) / CAST(100 as Float)))
)
FROM PLMReqInputItems MIPL1
JOIN PLMReqNodes NMIPL ON NMIPL.ID = MIPL1.Owner_ID
JOIN PLMReqNodes NMI ON NMI.ID = NMIPL.Master_ID
JOIN PLMReqOutputItems MI1 ON MI1.Owner_ID = NMI.ID
JOIN PLMProduceRequests PR ON PR.ID = NMIPL.Parent_ID
WHERE
(PR.joborder_id is null and NMIPL.Issue = 0
and NMIPL.Storecard_ID = a.storecard_ID)
)
|
|
Množství požadované požadavky na výrobu |
| RecievedOrderQuantity |
dtFloat |
15 |
(
SELECT SUM(CAST(ror.Quantity AS Numeric(15,6)) - CAST(ror.deliveredQuantity AS Numeric(15,6)))
FROM
ReceivedOrders2 ROR
JOIN ReceivedOrders RO ON RO.ID = ROR.Parent_ID
WHERE
((ROR.StoreCard_ID = a.StoreCard_ID) and
(ro.closed = 'N') and (ROR.Revided_id is null) and
((ror.Quantity - ror.deliveredQuantity) > 0))
)
|
|
Množství na objednávkách přijatých |
| StoreQuantity |
dtFloat |
15 |
(
SELECT SUM(SC1.Quantity)
FROM
StoreSubCards SC1
WHERE
SC1.StoreCard_ID = a.StoreCard_ID
)
|
|
Množství na všech skladech |