DataConnector | ComponentOne
In This Topic
    PurchaseOrders
    In This Topic
    Name Type ReadOnly Filterable Description
    Id [KEY] string true true The Id of the purchase order.
    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 The reference number for the transaction.
    TxnDate date false true The date entered by the user 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.
    LinkedTxn string false false A json aggregate of transactions linked to the estimate.
    Line string false false A json aggregate of line items in the transaction.
    CustomField string false false A json aggregate of custom field information.
    VendorRef string false false The Id of the vendor.
    VendorRef_Name string true false The name of the vendor.
    APAccountRef string false true The Id of the accounts-payable account to which the bill is credited. This account is implied when a company has a single accounts-payable account. When specified, the account must be a Liability account and the subtype must be of type Payables.
    APAccountRef_Name string true false The name of the accounts-payable account to which the bill is credited. This account is implied when a company has a single accounts-payable account. When specified, the account must be a Liability account and the subtype must be of type Payables.
    TotalAmt decimal true true The total amount due, determined by the sum of the line item amounts. This includes all charges, allowances, taxes, and discounts.
    VendorAddr_Id string true false Id of the Intuit entity for the vendor address, mainly used for modifying the address. This field is assigned by the data service.
    VendorAddr_Line1 string true false First line of the address.
    VendorAddr_Line2 string true false Second line of the address.
    VendorAddr_Line3 string true false Third line of the address.
    VendorAddr_Line4 string true false Fourth line of the address.
    VendorAddr_Line5 string true false Fifth line of the address.
    VendorAddr_City string true false City name.
    VendorAddr_Country string true false Country name.
    VendorAddr_CountrySubDivisionCode string true false Region within a country. For example, the state name for the USA and the province name for Canada.
    VendorAddr_PostalCode string true false Postal code. For example, the zip code for the USA and Canada.
    VendorAddr_Note string true false Note for the customer.
    VendorAddr_Lat string true false Latitude coordinate of the geocoded vendor address.
    VendorAddr_Long string true false Longitude coordinate of the geocoded vendor address.
    ShipAddr_Id string false false Id of the Intuit entity for the shipping address, mainly used for modifying the address. Read-only; assigned by the data service.
    ShipAddr_Line1 string false false First line of the address.
    ShipAddr_Line2 string false false Second line of the address.
    ShipAddr_Line3 string false false Third line of the address.
    ShipAddr_Line4 string false false Fourth line of the address.
    ShipAddr_Line5 string false false Fifth line of the address.
    ShipAddr_City string false false City name.
    ShipAddr_Country string false false Country name.
    ShipAddr_CountrySubDivisionCode string false false Region within a country. For example, state name for USA, province name for Canada.
    ShipAddr_PostalCode string false false Postal code. For example, zip code for USA and Canada.
    ShipAddr_Note string false false Note for the customer.
    ShipAddr_Lat string false false Latitude coordinate of the Geocode (Geospacial Entity Object Code).
    ShipAddr_Long string false false Longitude coordinate of the Geocode (Geospacial Entity Object Code).
    ShipMethodRef string false false Reference type of all Ids that are taken as input or output.
    ShipMethodRef_Name string true false Reference type of all Ids that are taken as input or output.
    POStatus string false false Enumeration of the purchase order status.
    POEmail_Address string false false Enumeration of the purchase order status.
    TxnTaxDetail_TxnTaxCodeRef string false false The tax code of the transaction.
    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 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 The method used to apply the tax. This field is valid in the UK, AU, IN, and CA editions.
    EmailStatus string false false The email status of the purchase order.