TABLE DETAIL REFERENCE: ReceivePayment
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueTrueTrueTrue%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 18TrueTrueTrueFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 17TrueTrueTrueFalse%6.8f
TotalAmountInHomeCurrency3 DECIMAL 18TrueFalseFalseFalse%10.2f
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueTrueTrueFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueTrueTrueFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueTrueTrueFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueTrueTrueFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueTrueTrueFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueTrueTrueFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueTrueTrueFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueTrueTrueFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueTrueTrueFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueTrueTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueTrueTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueTrueTrueFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueTrueTrueFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueTrueTrueFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueTrueTrueFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueTrueTrueFalse%s
IsAutoApply-7 BIT 1TrueFalseTrueFalse
1
0
true
false
UnusedPayment3 DECIMAL 17TrueFalseFalseFalse%10.2f
UnusedCredits3 DECIMAL 17TrueFalseFalseFalse%10.2f