DataConnector | ComponentOne
In This Topic
    Purchases
    In This Topic
    Name Type ReadOnly Filterable Description
    Id [KEY] string true true The Id of the purchase.
    SyncToken string false false The sync token. This must be specified when executing an update or delete.
    MetaData_CreateTime datetime true true The time the record was created.
    MetaData_LastUpdatedTime datetime true true The time the record was last updated.
    DocNumber string false true Reference number for the transaction.
    TxnDate date false true The date when this transaction occurred.
    PrivateNote string false false A private note about the transaction. This note will not appear on the transaction records by default. This field maps to the Memo field on the Check and CreditCard form.
    Line string false false A line item of a transaction.
    AccountRef string false false The Id of the account associated with the purchase. Check payments should reference a bank account and credit card purchases should refer to a credit card account.
    AccountRef_Name string true false A name that identifies the account associated with the purchase. Checks should reference a bank account and credit card purchases should refer to a credit card account.
    PaymentType string false true The payment type.
    EntityRef string false false The Id of the entity for the party the expense is associated with.
    EntityRef_Name string true false A name that identifies the party the expense is associated with.
    Credit boolean false false This field is valid only for the credit card payment type.
    TotalAmt decimal true true The total amount due, determined by the sum of the line item amounts. This includes all charges, allowances, taxes, discounts, etc.
    PrintStatus string false false The print status of the purchase. This field is applicable only for checks and ignored for credit card charges or refunds.
    DepartmentRef string false false The Id of the department, which stores the location of the transaction.
    DepartmentRef_Name string true false The name of the department, which stores the location of the transaction.
    Status string true false The status of the purchase.
    TxnTaxDetail_TxnTaxCodeRef string false false The transaction tax code.
    TxnTaxDetail_TxnTaxCodeRef_Name string true false The name associated to the transaction tax code.
    TxnTaxDetail_TotalTax string false false Total tax calculated for the transaction, excluding any tax lines manually inserted into the transaction line list.
    TxnTaxDetail_TaxLine string false false A json aggregate of tax line items.
    CurrencyRef string false false The Id of the currency used in the transaction.
    CurrencyRef_Name string true false The name of the currency used in the transaction.
    ExchangeRate decimal false false The currency exchange rate. This field is valid only if the company file is set up to use the multicurrency feature. In QuickBooks, exchange rates are always recorded as the number of home currency units it takes to equal one foreign currency unit. This field is available for the UK, AU, IN, and CA editions.
    GlobalTaxCalculation string false false Method in which tax is applied. This field is valid in the UK, AU, IN, and CA editions.
    IncludeInAnnualTPAR boolean false false Include the supplier in the annual TPAR. TPAR stands for Taxable Payments Annual Report. The TPAR is mandated by ATO to get the details payments that businesses make to contractors for providing services. Some government entities also need to report the grants they have paid in a TPAR.