TABLE DETAIL REFERENCE: ReceivePaymentLine
(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 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
ThisFiscalYeCC
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
TotalAmountInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%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 15TrueFalseFalseFalse%10.2f
UnusedCredits3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnTxnID12 VARCHAR 36TrueTrueTrueTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjusoNKv  ۅT ۅT HۅTHۅT 
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueTrueTrueFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnDiscountAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey