FIELD NAME | FIELD NAME (old) | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
TxnID | true | false | false | false | false | |
TimeCreated | true | false | false | false | false | |
TimeModified | true | false | false | false | false | |
EditSequence | true | false | false | false | false | |
TxnNumber | true | false | false | false | false | |
PayeeEntityRef_ListID | true | false | false | true | true | |
PayeeEntityRef_FullName | true | false | false | true | true | |
APAccountRef_ListID | true | false | false | true | optional | |
APAccountRef_FullName | true | false | false | true | optional | |
TxnDate | true | false | false | optional | optional | |
CreditCardAccountRef_ListID | true | false | false | optional | optional | |
CreditCardAccountRef_FullName | true | false | false | optional | optional | |
Amount | true | false | false | false | false | |
CurrencyRef_ListID | true | false | false | false | false | |
CurrencyRef_FullName | true | false | false | false | false | |
ExchangeRate | true | false | false | true | optional | |
AmountInHomeCurrency | true | false | false | false | false | |
RefNumber | true | false | false | true | optional | |
Memo | true | false | false | true | optional | |
ExternalGUID | true | false | false | true | optional | |
UserData | user field | |||||
Operation | add,refresh,delete |
- AppliedToTxnRet
Paying a bill using BillPaymentCreditCard:
I am using the Sample Rock Castle Construction company sample file.
CreditCardCharge
TxnID = 123456
AccountRef_FullName = QuickBooks Credit Card
PayeeEntityRef_FullName = Thomas Kitchen & Bath (vendor)
RefNumber = 8059 (ref no of the bill)
Operation = add
ExpenseLineRet
AccountRef_FullName = Accounts Payable
Amount = 585.00
CustomerRef_FullName = Thomas Kitchen & Bath (CustomerRef must refer to a vendor (not to a customer))
PARENT_IDKEY = 123456
Go to LetSync Desktop and run Update and Refresh on CreditCardCharge
BillPaymentCreditCard
TxnID = 123456
PayeeEntityRef_FullName = Thomas Kitchen & Bath (vendor)
APAccountRef_FullName = Accounts Payable
CreditCardAccountRef_FullName = QuickBooks Credit Card
RefNumber = 8059 (ref no of the bill)
Operation = add
AppliedToTxnRet
TxnID = 5C90-1197713660 (bill original TxnID from QuickBooks)
Amount = 585.00
PARENT_IDKEY = 123456
SetCredit
CreditTxnID = 28CC0-1702698121 (creditcardcharge original TxnID from QuickBooks)
AppliedAmount = 585.00
Override = true
PARENT_IDKEY =5C90-1197713660 (TxnID that was put on the AppliedToTxnRet table)
Go to LetSync Desktop and run Update and Refresh on BillPaymentCreditCard