TABLE DETAIL REFERENCE: ReceivePaymentLineLinkedTxn
(UK VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
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 36TrueFalseFalseTrue%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseTrue%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeCC
RefNumber12 VARCHAR 20TrueFalseFalseFalse%s
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.6f
TotalAmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
PaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
Memo12 VARCHAR 4095TrueFalseFalseFalse%s
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
CreditCardTxnInfoInputCreditCardNumber12 VARCHAR 25TrueFalseFalseFalse%s
CreditCardTxnInfoInputExpirationMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardTxnInfoInputExpirationYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardTxnInfoInputNameOnCard12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardTxnInfoInputCreditCardAddress12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardTxnInfoInputCreditCardPostalCode12 VARCHAR 41TrueFalseFalseFalse%s
CreditCardTxnInfoInputCommercialCardCode12 VARCHAR 50TrueFalseFalseFalse%s
CreditCardTxnInfoInputTransactionMode12 VARCHAR 14TrueFalseFalseFalse
CardNotPresent
CardPresent
CreditCardTxnInfoInputCreditCardTxnType12 VARCHAR 18TrueFalseFalseFalse
Authorization
Capture
Charge
Refund
VoiceAuthorization
CreditCardTxnInfoResultResultCode4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardTxnInfoResultResultMessage12 VARCHAR 500TrueFalseFalseFalse%s
CreditCardTxnInfoResultCreditCardTransID12 VARCHAR 24TrueFalseFalseFalse%s
CreditCardTxnInfoResultMerchantAccountNumber12 VARCHAR 32TrueFalseFalseFalse%s
CreditCardTxnInfoResultAuthorizationCode12 VARCHAR 12TrueFalseFalseFalse%s
CreditCardTxnInfoResultAVSStreet12 VARCHAR 12TrueFalseFalseFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultAVSZip12 VARCHAR 12TrueFalseFalseFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultCardSecurityCodeMatch12 VARCHAR 12TrueFalseFalseFalse
Pass
Fail
NotAvailable
CreditCardTxnInfoResultReconBatchID12 VARCHAR 84TrueFalseFalseFalse%s
CreditCardTxnInfoResultPaymentGroupingCode4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardTxnInfoResultPaymentStatus12 VARCHAR 9TrueFalseFalseFalse
Unknown
Completed
CreditCardTxnInfoResultTxnAuthorizationTime11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardTxnInfoResultClientTransID12 VARCHAR 16TrueFalseFalseFalse%s
IsAutoApply-7 BIT 1TrueFalseFalseFalse
1
0
true
false
UnusedPayment3 DECIMAL 15TrueFalseFalseFalse%10.2f
UnusedCredits3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnLinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
ARRefundCreditCard
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEoNKv  ۅT ۅT HۅTHۅT 
AppliedToTxnLinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnLinkType12 VARCHAR 14TrueFalseFalseFalse
AMTTYPE
QUANTYPE
AppliedToTxnLinkedTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey