A big part of what our application does is post payments for our customers after credit card transactions.
I noticed the payment end point @ https://opendental.com/site/apipayments.html doesn't really allow for this.
We post both pre-payment and allocated payments.
These are the fields that we use to write to the database
Code: Select all
`INSERT INTO Payment
(
ClinicNum,
IsRecurringCC,
IsSplit,
PatNum,
PayAmt,
PayDate,
PaymentSource,
PayType,
ProcessStatus,
Receipt,
PayNote
)
VALUES
(
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
)`,
[
clinicNum,
isRecurringCC,
isSplit,
patNum,
payAmt,
payDate,
paymentSource,
payType,
processStatus,
receipt,
payNote,
]
Code: Select all
Insert PaySplit
(
ClinicNum,
DatePay,
PatNum,
PayNum,
ProvNum,
SplitAmt,
UnearnedType,
ProcNum
)
VALUES
(
?,
?,
?,
?,
?,
?,
?,
?
);`,
[
clinicNum,
datePay,
patNum,
payNum,
provNum,
splitAmt,
unearnedTypeDefNum,
procNum,
]
Thank you,
Marty