Payment

Table:
payment
Model Version:
99b2264e89f68dd2
JSON Schema:
Payment
amountCents
integer
bulkPaymentId
Nullable
string
cardConfirmation
Nullable
string
cardDigits
Nullable
string
cardName
Nullable
string
cardType
Nullable
string
chargeFromPublicPage
boolean
chargeId
Nullable
string
checkNumber
Nullable
string
companyId
string
createdDate
date-time
debitCard
boolean
deposit
boolean
disputedPaymentId
Nullable
string
disputedReason
Nullable
string
disputedStatus
Nullable
Warning, NeedsResponse, UnderReview, Refunded, Won, Lost, Unknown
disputedType
Nullable
Deduction, Fee, ReversedDeduction, ReversedFee
duesAndAssessmentsFee
Nullable
number
id
Primary Key
string
idempotencyKey
Nullable
string
imported
boolean
interchangeFee
Nullable
integer
locationId
string
metadata
Nullable
object
note
string
orderId
string
payerId
Nullable
string
paymentMode
Manual, Online, InPerson
paymentType
Check, Cash, Card, Other, ACH, Financing, PayPal, Venmo, Zelle, Insurance, Warranty, Internal, Mechanical_Installment, Policy, Reconditioning, Vehicle_Service_Contract, Account_Receivable, BNPL, BNPL_Sunbit, BNPL_Affirm, Interac_e__Transfer, Customer_Credit, Progressive, Acima, Snap_Finance, Care_Car_One, Home_Design, Wholesale, Quantum_Financing, Synchrony_Financing, Koalafi_Financing, Pay2Tomorrow, Work_Order_Adjustment, XPEL_Deals
payoutId
Nullable
string
provider
Nullable
Finix, FirstMile, Manual, Stripe, Sunbit
providerData
Nullable
object
providerFee
Nullable
integer
receiptNumber
integer
recordedDate
Nullable
date-time
refundReason
Nullable
Duplicate, Fraudulent, RequestedByCustomer
refunded
Nullable
boolean
refundedAmountCents
Nullable
integer
settlementId
Nullable
string
statementId
Nullable
string
status
Canceled, Failed, Pending, Processing, Succeeded
statusDetails
Nullable
string
surchargeFee
Nullable
integer
transactionType
Charge, Refund, Transfer, Dispute
transactionalFeeAmountCents
Nullable
integer
updatedDate
Nullable
date-time
userData
Nullable
object