TABLE DETAIL REFERENCE: ReceivePaymentLine
(USA 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
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 15TrueTrueTrueFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.8f
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
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
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