TABLE DETAIL REFERENCE: ReceivePayment
(UK VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
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 | True | True | True | %s | Yes |
CustomerRefFullName | 12 | VARCHAR | 209 | True | True | True | True | %s | Yes |
ARAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
ARAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe C C | |
RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
TotalAmount | 3 | DECIMAL | 15 | True | True | True | 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 | 15 | True | True | True | False | %6.6f | |
TotalAmountInHomeCurrency | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
PaymentMethodRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
PaymentMethodRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
DepositToAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
DepositToAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
CreditCardTxnInfoInputCreditCardNumber | 12 | VARCHAR | 25 | True | True | True | False | %s | |
CreditCardTxnInfoInputExpirationMonth | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardTxnInfoInputExpirationYear | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardTxnInfoInputNameOnCard | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardTxnInfoInputCreditCardAddress | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardTxnInfoInputCreditCardPostalCode | 12 | VARCHAR | 41 | True | True | True | False | %s | |
CreditCardTxnInfoInputCommercialCardCode | 12 | VARCHAR | 50 | True | True | True | False | %s | |
CreditCardTxnInfoInputTransactionMode | 12 | VARCHAR | 14 | True | True | True | False | CardNotPresent CardPresent | |
CreditCardTxnInfoInputCreditCardTxnType | 12 | VARCHAR | 18 | True | True | True | False | Authorization Capture Charge Refund VoiceAuthorization | |
CreditCardTxnInfoResultResultCode | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardTxnInfoResultResultMessage | 12 | VARCHAR | 500 | True | True | True | False | %s | |
CreditCardTxnInfoResultCreditCardTransID | 12 | VARCHAR | 24 | True | True | True | False | %s | |
CreditCardTxnInfoResultMerchantAccountNumber | 12 | VARCHAR | 32 | True | True | True | False | %s | |
CreditCardTxnInfoResultAuthorizationCode | 12 | VARCHAR | 12 | True | True | True | False | %s | |
CreditCardTxnInfoResultAVSStreet | 12 | VARCHAR | 12 | True | True | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultAVSZip | 12 | VARCHAR | 12 | True | True | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultCardSecurityCodeMatch | 12 | VARCHAR | 12 | True | True | True | False | Pass Fail NotAvailable | |
CreditCardTxnInfoResultReconBatchID | 12 | VARCHAR | 84 | True | True | True | False | %s | |
CreditCardTxnInfoResultPaymentGroupingCode | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardTxnInfoResultPaymentStatus | 12 | VARCHAR | 9 | True | True | True | False | Unknown Completed | |
CreditCardTxnInfoResultTxnAuthorizationTime | 11 | TIMESTAMP | 16 | True | True | True | False | CCCC-MM-DDThh:mm:ssZ | |
CreditCardTxnInfoResultTxnAuthorizationStamp | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
CreditCardTxnInfoResultClientTransID | 12 | VARCHAR | 16 | True | True | True | False | %s | |
IsAutoApply | -7 | BIT | 1 | True | False | True | False | 1 0 true false | |
UnusedPayment | 3 | DECIMAL | 15 | True | False | False | False | %10.2f | |
UnusedCredits | 3 | DECIMAL | 15 | True | False | False | False | %10.2f |