TABLE DETAIL REFERENCE: ReceivePaymentLineLinkedTxn
(Canada VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CustomerRefListID | 12 | VARCHAR | 36 | True | False | False | True | %s | Yes |
| CustomerRefFullName | 12 | VARCHAR | 209 | True | False | False | True | %s | Yes |
| ARAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| ARAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| TxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | 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 | |
| RefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| TotalAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 17 | True | False | False | False | %6.8f | |
| TotalAmountInHomeCurrency | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| PaymentMethodRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PaymentMethodRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| Memo | 12 | VARCHAR | 4095 | True | False | False | False | %s | |
| DepositToAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| DepositToAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| CreditCardTxnInfoInputCreditCardNumber | 12 | VARCHAR | 25 | True | False | False | False | %s | |
| CreditCardTxnInfoInputExpirationMonth | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardTxnInfoInputExpirationYear | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardTxnInfoInputNameOnCard | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CreditCardTxnInfoInputCreditCardAddress | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CreditCardTxnInfoInputCreditCardPostalCode | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| CreditCardTxnInfoInputCommercialCardCode | 12 | VARCHAR | 50 | True | False | False | False | %s | |
| CreditCardTxnInfoInputTransactionMode | 12 | VARCHAR | 14 | True | False | False | False | CardNotPresent CardPresent | |
| CreditCardTxnInfoInputCreditCardTxnType | 12 | VARCHAR | 18 | True | False | False | False | Authorization Capture Charge Refund VoiceAuthorization | |
| CreditCardTxnInfoResultResultCode | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardTxnInfoResultResultMessage | 12 | VARCHAR | 500 | True | False | False | False | %s | |
| CreditCardTxnInfoResultCreditCardTransID | 12 | VARCHAR | 24 | True | False | False | False | %s | |
| CreditCardTxnInfoResultMerchantAccountNumber | 12 | VARCHAR | 32 | True | False | False | False | %s | |
| CreditCardTxnInfoResultAuthorizationCode | 12 | VARCHAR | 12 | True | False | False | False | %s | |
| CreditCardTxnInfoResultAVSStreet | 12 | VARCHAR | 12 | True | False | False | False | Pass Fail NotAvailable | |
| CreditCardTxnInfoResultAVSZip | 12 | VARCHAR | 12 | True | False | False | False | Pass Fail NotAvailable | |
| CreditCardTxnInfoResultCardSecurityCodeMatch | 12 | VARCHAR | 12 | True | False | False | False | Pass Fail NotAvailable | |
| CreditCardTxnInfoResultReconBatchID | 12 | VARCHAR | 84 | True | False | False | False | %s | |
| CreditCardTxnInfoResultPaymentGroupingCode | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardTxnInfoResultPaymentStatus | 12 | VARCHAR | 9 | True | False | False | False | Unknown Completed | |
| CreditCardTxnInfoResultTxnAuthorizationTime | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| CreditCardTxnInfoResultTxnAuthorizationStamp | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| CreditCardTxnInfoResultClientTransID | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| IsAutoApply | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| UnusedPayment | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| UnusedCredits | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnTxnID | 12 | VARCHAR | 36 | True | False | False | True | %s | |
| AppliedToTxnPaymentAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | 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 | |
| AppliedToTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AppliedToTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| AppliedToTxnBalanceRemaining | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnSetCreditCreditTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| AppliedToTxnSetCreditAppliedAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnDiscountAmount | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| AppliedToTxnDiscountAccountRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| AppliedToTxnDiscountAccountRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| AppliedToTxnDiscountClassRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| AppliedToTxnDiscountClassRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| AppliedToTxnLinkedTxnTxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| AppliedToTxnLinkedTxnTxnType | 12 | VARCHAR | 14 | True | False | False | False | 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 | |
| AppliedToTxnLinkedTxnTxnDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AppliedToTxnLinkedTxnRefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| AppliedToTxnLinkedTxnLinkType | 12 | VARCHAR | 14 | True | False | False | False | AMTTYPE QUANTYPE | |
| AppliedToTxnLinkedTxnAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| FQPrimaryKey | 12 | VARCHAR | 73 | True | False | False | False | FQPrimaryKey |