SELECT pDeposit_temp.*,pPayer.Pay_Name FROM #Request.prefix_db_lookup#.pDeposit_temp
JOIN #Request.prefix_db_agency#.pPayer ON pDeposit_temp.Payer_ID = pPayer.Pay_ID
WHERE pDeposit_temp.Status = 0
AND pDeposit_temp.Dep_ID =
SELECT Invoice_ID,Internal_Control_number FROM #Request.prefix_db_agency#.Invoices
WHERE deleted = 0
AND Invoice_ID =
INSERT INTO #Request.prefix_db_agency#.pDeposit
( Status, Payer_ID, Date_Create, Date_Deposit, Date_Check, Deposit_Type, Check_Total, Remit_No,
Internal_Control_number, Pay_Name,
Net_Total, Record_Created_Date, Record_Created_By, Record_Modified_Date, Record_Modified_By)
VALUES(
,
,
,
,
,
'Check',
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.Payments (
invoice_id, patientpayer_id, paymentdate, amount, paymentmethod, comments, writeoffamount,EFT_Amount,EFT_No,
Claim, writeofftype,Record_Created_By,Record_Created_Date,Record_Modified_By,Record_Modified_Date
) VALUES (
,
,
,
,'Check'
,NULL
,0.00
,0.00
,
,
,NULL
,'#Session.EmployeeId#'
,#now()#
,'#Session.EmployeeId#'
,#now()#
)
Something wen wrong. So please click here to back