QuickBooks SQL Mirror: The 'receivepayment' Table

TxnID				(Required. If adding a new Receive Payment, you can make this up and QuickBooks will replace it when it's added to QuickBooks. Do not update.)
TimeCreated			(This field will be overwritten by QuickBooks when the object is added to QuickBooks.)
TimeModified			(This field will be overwritten by QuickBooks when the object is modified in QuickBooks.)
EditSequence			(Read-only. Do not update.)
TxnNumber			(Read-only.)
Customer_ListID			(Either this field or the Customer_FullName field are required to indicate which customer the payment was applied to.)
Customer_FullName		(Either this field or the Customer_ListID field are required to indicate which customer the payment was applied to.)
ARAccount_ListID
ARAccount_FullName
TxnDate				(The date the payment was received on.)
RefNumber			(The payment reference number - usually a check or transaction number.)
TotalAmount
PaymentMethod_ListID		(If you are supplying CreditCardTxnInfo information from a QuickBooks Merchant Services transaction, then you must specify either this field or the PaymentMethod_FullName field, and the PaymentMethod reference must be of type CreditCard.)
PaymentMethod_FullName
Memo
DepositToAccount_ListID
DepositToAccount_FullName
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber		(You can only use the CreditCardTxnInfo fields if you have an active QuickBooks Merchant Services account. This information comes straight from the QuickBooks Merchant Services transaction.)
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch
CreditCardTxnInfo_CreditCardTxnResultInfo_ReconBatchID
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentGroupingCode
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentStatus
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationStamp
CreditCardTxnInfo_CreditCardTxnResultInfo_ClientTransID
quickbooks_integration_php_consolibyte_sqlmirror_table_receivepayment.txt · Last modified: 2013/01/21 12:44 (external edit)