7.28125in
1.055in
true
true
=Fields!CHECK_PAYEE.Value
HTML
CHECK_PAYEE
0.805in
0.25in
5.38542in
2pt
2pt
2pt
2pt
true
true
=Fields!BILL_AMNT_WORDS.Value
BILL_AMNT_WORDS
0.35986in
0.2175in
0.25in
7.04167in
1
2pt
2pt
2pt
2pt
true
true
=Fields!AMOUNT.Value
AMOUNT
5.88417in
0.25in
1.375in
2
2pt
2pt
2pt
2pt
en-US
true
DataSet1
1.055in
7.28125in
true
true
=First(Fields!SOURCE_INFO.Value, "DataSet1")
CHECK_PAYEE
1.63688in
0.15in
7.25917in
1
2pt
2pt
2pt
2pt
1.78688in
7.28125in
3.65625in
true
true
true
true
=First(Fields!CHECK_DATE.Value, "DataSet1")
ExecutionTime
3.35292in
4.26958in
0.25in
1.33334in
2pt
2pt
2pt
2pt
true
true
=First(Fields!MEMO.Value, "DataSet1")
MEMO
1.83208in
0.2175in
0.25in
6.54166in
1
Black
1pt
2pt
2pt
2pt
2pt
0.5in
0.5in
1in
1in
0
SQL
="data source=" & Parameters!ReportSvr.Value & "; Initial Catalog=" & Parameters!ReportDB.Value
true
Integrated
64cb04ce-cf16-4401-aa46-0b3e477b862b
GatcsDB
=Parameters!CHECK_NO.Value
SELECT C.*, D.CONAME
, CASE WHEN C.AMOUNT < 1.00 THEN 'Zero Dollars' ELSE DBO.FNINTEGERTOWORDS( C.AMOUNT ) END
+ ' AND ' +
CASE
WHEN CONVERT(INT,C.AMOUNT) = C.AMOUNT
THEN '00'
ELSE
LEFT(CONVERT(VARCHAR(5),
ROUND((C.AMOUNT -CONVERT(BIGINT,C.AMOUNT))*100,2)
),2)
END
+ '/100'
AS BILL_AMNT_WORDS
FROM CHECK_REGISTER C
LEFT JOIN DEFAULTS D ON 1=1
WHERE CHECK_NO=@CHECK_NO
true
CONAME
System.String
RECID
System.Int32
BILL_AMNT_WORDS
System.String
CHECK_NO
System.Int64
PAYEE
System.String
MEMO
System.String
AMOUNT
System.Decimal
CHECK_DATE
System.DateTime
PRINT_DATE
System.DateTime
REPRINT_DATE
System.DateTime
LOGINID
System.String
COMP_NAME
System.String
REPRINT_LOGINID
System.String
REPRINT_COMP_NAME
System.String
VOIDED
System.Boolean
VOIDED_DATE
System.DateTime
VOIDED_LOGINID
System.String
VOIDED_COMP_NAME
System.String
VOIDED_COMMENTS
System.String
DATE_FROM
System.DateTime
CHECK_PAYEE
System.String
DATE_TO
System.DateTime
SOURCE_INFO
System.String
GatcsDB
=Parameters!BILLNO.Value
=Parameters!BILLYR.Value
SELECT ACCT_CODE
, DESCRIP
, DEBIT
, CREDIT
, BILL_NO
, BILL_YEAR
FROM GENERAL_LEDGER
WHERE BILL_NO=@BILLNO AND BILL_YEAR=@BILLYR AND
ISNULL(REFUND,0)=1 AND
ISNULL(REVERSAL,0)=1 AND
ISNULL(PAID_OUT,0)=0 AND
ISNULL(COMMISSION,0)=0 AND
ACCT_CODE IN (SELECT ACCT_CODE FROM DBO.CHART_ACCOUNTS WHERE DISBURSEMENT=1 AND ACCT_TYPE='L')
true
ACCT_CODE
System.String
DESCRIP
System.String
DEBIT
System.Decimal
CREDIT
System.Decimal
BILL_NO
System.Int32
BILL_YEAR
System.Int16
String
ReportSvr
String
ReportDB
String
CHECK NO
String
BILLNO
String
BILLYR
en-US
true
Inch
246ff5bc-ba45-459d-8f68-9a8bd029ac60