Παραδείγματα SQL Παραστατικών

SELECT
FINDOC AS FID,
VARCHAR02 as VOUCHER,
FINCODE AS FN,
FORMAT (TRNDATE,"yyyy-MM-dd") AS FD,
ISPRINT AS ISPRINT,
CASE WHEN FINDOC.SHIPMENT=4 THEN "ACS" END AS M,
SUMAMNT AS AN,
case when findoc.TRDBRANCH!=0 then TRDBRANCH.NAME else TRDR.NAME end AS P,
CASE WHEN INT01 IS NULL THEN 1 ELSE INT01 END AS Q,
NUM01 AS W,
case when findoc.TRDBRANCH is not null then TRDBRANCH.ADDRESS else TRDR.ADDRESS end AS A,
case when findoc.TRDBRANCH is not null then TRDBRANCH.DISTRICT else TRDR.DISTRICT end AS D,
case when findoc.TRDBRANCH is not null then TRDBRANCH.ZIP else TRDR.ZIP end AS ZP,
"." AS N,
"ΑΜ" AS SE,
"191919" AS WO,
TRDR.EMAIL AS EM,
"CUSTOM 1" AS C1,
"CUSTOM 2" AS C2,
"CUSTOM 3" AS C3,
FINDOC.REMARKS AS C,
case
when findoc.TRDBRANCH is null and substring(TRDR.PHONE01,0,3) = "69" then TRDR.PHONE01
when findoc.TRDBRANCH is null and substring(TRDR.PHONE02,0,3) = "69" then TRDR.PHONE02
when findoc.TRDBRANCH is not null and substring(TRDBRANCH.PHONE1,0,3) = "69" then TRDBRANCH.PHONE1
when findoc.TRDBRANCH is not null and substring(TRDBRANCH.PHONE2,0,3) = "69" then TRDBRANCH.PHONE2
else ""
end as MO,
case
when findoc.TRDBRANCH is null and substring(TRDR.PHONE01,0,3) != "69" then TRDR.PHONE01
when findoc.TRDBRANCH is null and substring(TRDR.PHONE02,0,3) != "69" then TRDR.PHONE02
when findoc.TRDBRANCH is not null and substring(TRDBRANCH.PHONE1,0,3) != "69" then TRDBRANCH.PHONE1
when findoc.TRDBRANCH is not null and substring(TRDBRANCH.PHONE2,0,3) != "69" then TRDBRANCH.PHONE2
else ""
end as T,
"Company Name" AS CO
FROM FINDOC
LEFT JOIN SHIPMENT ON SHIPMENT.SHIPMENT = FINDOC.SHIPMENT
INNER JOIN TRDR ON TRDR.TRDR = FINDOC.TRDR
left join TRDBRANCH on TRDBRANCH.TRDBRANCH = findoc.TRDBRANCH
WHERE SERIES IN (7062) AND FINDOC.SHIPMENT IN (4)

SELECT
FINTRADE.ID AS FID,
JUSTIFICATION as VOUCHER,
TRADECODE AS FN,
FORMAT (ftrdate,'yyyy-MM-dd') AS FD,
1 AS ISPRINT,
CASE WHEN storetrade.SHVID=1 THEN 'ACS' END AS M,
TOTAMOUNT AS AN,
CUSTOMER.NAME AS P,
1 AS Q,
0 AS W,
STREET1 AS A,
'.' AS N,
DISTRICT1 AS D,
ZIPCODE1 AS ZP,
'ΑΜ' AS SE,
TRADECODE AS WO,
CUSTOMER.EMAIL AS EM,
'CUSTOM 1' AS C1,
'CUSTOM 2' AS C2,
'CUSTOM 3' AS C3,
'Shipping comments' AS C,
case
when substring(PHONE12,0,3) = '69' then PHONE12
when substring(PHONE11,0,3) = '69' then PHONE11
else ''
end as MO,
case
when substring(PHONE12,0,3) != '69' then PHONE12
when substring(PHONE11,0,3) != '69' then PHONE11
else ''
end as T,
'Company Name' AS CO
FROM FINTRADE
INNER JOIN CUSTOMER ON CUSTOMER.ID = FINTRADE.CUSID
inner join storetrade on storetrade.ftrid =FINTRADE.ID
where dsrid=1304
AND storetrade.SHVID IN (1)

select sdFileId as FID,
sdComment as VOUCHER,
sdDocum AS FN,
CAST(sdDate AS VARCHAR(10)) AS FD,
CASE WHEN sdDelivMode='001' THEN 'ACS' END AS M,
sdTotVal AS AN,
cName AS P,
'3' AS W,
cAddress11 AS A,
'.' AS N,
cFeatCode1 AS D,
cZipCode1 AS ZP,
'ΑΜ' AS SE,
'' AS WO,
cEmail AS EM,
'' AS C1,
'' AS C2,
'' AS C3,
'' AS C ,
1 AS Q,
case
when substring(cMobile,0,2) = '69' then cMobile
when substring(cPhone1,0,2) = '69' then cPhone1
else ''
end as MO,
case
when substring(cMobile,0,2) <> '69' then cMobile
when substring(cPhone1,0,2) <> '69' then cPhone1
else ''
end as T,
'Company Name' AS CO
FROM VMAST1
left join cmast on cmast.cFileId = VMAST1.cFileId
where VMAST1.cFileId >=1