TABLE DETAIL REFERENCE: ReceivePaymentLineLinkedTxn
(Canada 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
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
RefNumber12 VARCHAR 20TrueFalseFalseFalse%s
TotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 17TrueFalseFalseFalse%6.8f
TotalAmountInHomeCurrency3 DECIMAL 18TrueFalseFalseFalse%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 17TrueFalseFalseFalse%10.2f
UnusedCredits3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueFalseFalseFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnDiscountAmount3 DECIMAL 17TrueFalseFalseFalse%10.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
AppliedToTxnLinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
ARRefundCreditCard
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
AppliedToTxnLinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnLinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnLinkedTxnLinkType12 VARCHAR 14TrueFalseFalseFalse
AMTTYPE
QUANTYPE
AppliedToTxnLinkedTxnAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey