增值税表

五六零网校小于 1 分钟

示例代码

SELECT T1.[Account], T2.[AcctName], T0.[Number] AS '日记账单号', T0.[RefDate], T0.[Memo]
	, T1.[Debit], T1.[Credit], T1.[BalDueCred], T1.[BalDueDeb]
FROM OJDT T0
	INNER JOIN JDT1 T1 ON T0.[TransId] = T1.[TransId]
	INNER JOIN OACT T2 ON T1.[Account] = T2.[AcctCode]
WHERE T1.[Account] LIKE '%%222101%%'
	AND T0.[RefDate] >= [%0]
	AND T0.[RefDate] <= [%1]