# Dear

## Snapshot

| Features                        | Details                                          |
| ------------------------------- | ------------------------------------------------ |
| Release Status                  | Released                                         |
| Source API Version              | V1                                               |
| Table Selection                 | Yes                                              |
| Column Selection                | Yes                                              |
| Edit Integration                | Yes                                              |
| Replication Type Selection      | No                                               |
| Authentication Parameters       | <p>Account ID<br>Application Key</p>             |
| Replication Type                | <p>Full Replication<br>Key Based Incremental</p> |
| Replication Key                 | Datetime                                         |
| Suggested Replication Frequency | 1 hour                                           |

## Tables/APIs supported

| accounts               | customers                    |
| ---------------------- | ---------------------------- |
| suppliers              | transactions                 |
| products               | product\_availability\_list  |
| brands                 | tax                          |
| payment\_terms         | carriers                     |
| locations              | disassembly\_lists           |
| finished\_goods\_lists | inventory\_write\_off\_lists |
| purchase\_list         | sale\_list                   |

## Integrate Dear with Daton

1. Sign in to Daton&#x20;
2. Select Byrd from the list of Integrations&#x20;
3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later&#x20;
4. Provide Dear Account ID and Application Secret. These can be created on the API setup page inside DEAR Inventory application: <https://inventory.dearsystems.com/ExternalAPI>.
5. Post successful authentication, you will be prompted to choose from the list of available tables
6. Then select all required fields for each table
7. Submit the integration

## Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

## Dear Data

### accounts

Purpose: This API is used to fetch all accounts data

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/chart-of-accounts/chart-of-accounts/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Code</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>Description</td><td>STRING</td></tr><tr><td>Class</td><td>STRING</td></tr><tr><td>ForPayments</td><td>BOOLEAN</td></tr><tr><td>DisplayName</td><td>STRING</td></tr><tr><td>SystemAccount</td><td>STRING</td></tr><tr><td>SystemAccountCode</td><td>STRING</td></tr><tr><td>BankAccountId</td><td>STRING</td></tr></tbody></table>

### customers

Purpose: This API is used to fetch all customers data

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/customer/customer/get>

Replication: Key Based Incremental

Replication Key: ModifiedSince

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Currency</td><td>STRING</td></tr><tr><td>PaymentTerm</td><td>STRING</td></tr><tr><td>Discount</td><td>NUMERIC</td></tr><tr><td>TaxRule</td><td>STRING</td></tr><tr><td>Carrier</td><td>STRING</td></tr><tr><td>SalesRepresentative</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>Comments</td><td>STRING</td></tr><tr><td>AccountReceivable</td><td>STRING</td></tr><tr><td>RevenueAccount</td><td>STRING</td></tr><tr><td>PriceTier</td><td>STRING</td></tr><tr><td>TaxNumber</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>CreditLimit</td><td>NUMERIC</td></tr><tr><td>IsOnCreditHold</td><td>BOOLEAN</td></tr><tr><td>LastModifiedOn</td><td>TIMESTAMP</td></tr><tr><td>Addresses</td><td>RECORD</td></tr><tr><td>Contacts</td><td>RECORD</td></tr><tr><td>AdditionalAttribute1</td><td>STRING</td></tr><tr><td>AdditionalAttribute2</td><td>STRING</td></tr><tr><td>AdditionalAttribute3</td><td>STRING</td></tr><tr><td>AdditionalAttribute4</td><td>STRING</td></tr><tr><td>AdditionalAttribute5</td><td>STRING</td></tr><tr><td>AdditionalAttribute6</td><td>STRING</td></tr><tr><td>AdditionalAttribute7</td><td>STRING</td></tr><tr><td>AdditionalAttribute8</td><td>STRING</td></tr><tr><td>AdditionalAttribute9</td><td>STRING</td></tr><tr><td>AdditionalAttribute10</td><td>STRING</td></tr><tr><td>Tags</td><td>STRING</td></tr></tbody></table>

### suppliers

Purpose: This API is used to fetch all suppliers data

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/supplier/supplier/get>

Replication: Key Based Incremental

Replication Key: ModifiedSince

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Currency</td><td>STRING</td></tr><tr><td>PaymentTerm</td><td>STRING</td></tr><tr><td>TaxRule</td><td>STRING</td></tr><tr><td>Discount</td><td>NUMERIC</td></tr><tr><td>AccountPayable</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>LastModifiedOn</td><td>TIMESTAMP</td></tr><tr><td>Contacts</td><td>RECORD</td></tr><tr><td>Addresses</td><td>RECORD</td></tr><tr><td>TaxNumber</td><td>STRING</td></tr><tr><td>Comments</td><td>STRING</td></tr><tr><td>AdditionalAttribute1</td><td>STRING</td></tr><tr><td>AdditionalAttribute2</td><td>STRING</td></tr><tr><td>AdditionalAttribute3</td><td>STRING</td></tr><tr><td>AdditionalAttribute4</td><td>STRING</td></tr><tr><td>AdditionalAttribute5</td><td>STRING</td></tr><tr><td>AdditionalAttribute6</td><td>STRING</td></tr><tr><td>AdditionalAttribute7</td><td>STRING</td></tr><tr><td>AdditionalAttribute8</td><td>STRING</td></tr><tr><td>AdditionalAttribute9</td><td>STRING</td></tr><tr><td>AdditionalAttribute10</td><td>STRING</td></tr></tbody></table>

### transactions

Purpose: This API is used to fetch all transaction related data

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/transactions/transactions/get>

Replication: Key Based Incremental

Replication Key: FromDate, ToDate

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td><br>ID</td><td>STRING</td></tr><tr><td>TaskID</td><td>STRING</td></tr><tr><td>DebitAccountCode</td><td>STRING</td></tr><tr><td>CreditAccountCode</td><td>STRING</td></tr><tr><td>Amount</td><td>NUMERIC</td></tr><tr><td>OriginalAmount</td><td>NUMERIC</td></tr><tr><td>CurrencyRate</td><td>NUMERIC</td></tr><tr><td>EffectiveDate</td><td>DATETIME</td></tr><tr><td>Reference</td><td>STRING</td></tr><tr><td>Transaction</td><td>STRING</td></tr><tr><td>Type</td><td>STRING</td></tr></tbody></table>

### products

Purpose: This API is used to fetch all products

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/product/product/get>

Replication: Key Based Incremental

Replication Key: ModifiedSince

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>category</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>costingmethod</td><td>STRING</td></tr><tr><td>dropshipmode</td><td>STRING</td></tr><tr><td>defaultlocation</td><td>STRING</td></tr><tr><td>length</td><td>NUMERIC</td></tr><tr><td>width</td><td>NUMERIC</td></tr><tr><td>height</td><td>NUMERIC</td></tr><tr><td>weight</td><td>NUMERIC</td></tr><tr><td>uom</td><td>STRING</td></tr><tr><td>weightunits</td><td>STRING</td></tr><tr><td>dimensionsunits</td><td>STRING</td></tr><tr><td>barcode</td><td>STRING</td></tr><tr><td>minimumbeforereorder</td><td>NUMERIC</td></tr><tr><td>reorderquantity</td><td>NUMERIC</td></tr><tr><td>pricetier1</td><td>NUMERIC</td></tr><tr><td>pricetier2</td><td>NUMERIC</td></tr><tr><td>pricetier3</td><td>NUMERIC</td></tr><tr><td>pricetier4</td><td>NUMERIC</td></tr><tr><td>pricetier5</td><td>NUMERIC</td></tr><tr><td>pricetier6</td><td>NUMERIC</td></tr><tr><td>pricetier7</td><td>NUMERIC</td></tr><tr><td>pricetier8</td><td>NUMERIC</td></tr><tr><td>pricetier9</td><td>NUMERIC</td></tr><tr><td>pricetier10</td><td>NUMERIC</td></tr><tr><td>pricetiers</td><td>RECORD</td></tr><tr><td>averagecost</td><td>NUMERIC</td></tr><tr><td>shortdescription</td><td>STRING</td></tr><tr><td>internalnote</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>additionalattribute1</td><td>STRING</td></tr><tr><td>additionalattribute2</td><td>STRING</td></tr><tr><td>additionalattribute3</td><td>STRING</td></tr><tr><td>additionalattribute4</td><td>STRING</td></tr><tr><td>additionalattribute5</td><td>STRING</td></tr><tr><td>additionalattribute6</td><td>STRING</td></tr><tr><td>additionalattribute7</td><td>STRING</td></tr><tr><td>additionalattribute8</td><td>STRING</td></tr><tr><td>additionalattribute9</td><td>STRING</td></tr><tr><td>additionalattribute10</td><td>STRING</td></tr><tr><td>tags</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>stocklocator</td><td>STRING</td></tr><tr><td>cogsaccount</td><td>STRING</td></tr><tr><td>revenueaccount</td><td>STRING</td></tr><tr><td>expenseaccount</td><td>STRING</td></tr><tr><td>inventoryaccount</td><td>STRING</td></tr><tr><td>purchasetaxrule</td><td>STRING</td></tr><tr><td>saletaxrule</td><td>STRING</td></tr><tr><td>lastmodifiedon</td><td>TIMESTAMP</td></tr><tr><td>sellable</td><td>BOOLEAN</td></tr><tr><td>pickzones</td><td>STRING</td></tr><tr><td>billofmaterial</td><td>BOOLEAN</td></tr><tr><td>autoassembly</td><td>BOOLEAN</td></tr><tr><td>autodisassembly</td><td>BOOLEAN</td></tr><tr><td>quantitytoproduce</td><td>NUMERIC</td></tr><tr><td>alwaysshowquantity</td><td>NUMERIC</td></tr><tr><td>assemblyinstructionurl</td><td>STRING</td></tr><tr><td>assemblycostestimationmethod</td><td>STRING</td></tr><tr><td>billofmaterialsproducts</td><td>RECORD</td></tr><tr><td>movements</td><td>RECORD</td></tr><tr><td>bomtype</td><td>STRING</td></tr><tr><td>cartonheight</td><td>NUMERIC</td></tr><tr><td>cartonwidth</td><td>NUMERIC</td></tr><tr><td>cartonlength</td><td>NUMERIC</td></tr><tr><td>cartonquantity</td><td>NUMERIC</td></tr><tr><td>cartoninnerquantity</td><td>NUMERIC</td></tr></tbody></table>

### product\_availability\_list

Purpose: This API is used to fetch data related to product availability

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/product/product-availability/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>SKU</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Barcode</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>Batch</td><td>STRING</td></tr><tr><td>OnHand</td><td>NUMERIC</td></tr><tr><td>Allocated</td><td>NUMERIC</td></tr><tr><td>Available</td><td>NUMERIC</td></tr><tr><td>OnOrder</td><td>NUMERIC</td></tr><tr><td>StockOnHand</td><td>NUMERIC</td></tr><tr><td>InTransit</td><td>NUMERIC</td></tr></tbody></table>

### brands

Purpose: This API is used to fetch all brands

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/brand/brand/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr></tbody></table>

### tax

Purpose: This API is used to fetch all tax related data

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/tax/tax/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Account</td><td>STRING</td></tr><tr><td>IsActive</td><td>BOOLEAN</td></tr><tr><td>TaxInclusive</td><td>BOOLEAN</td></tr><tr><td>TaxPercent</td><td>NUMERIC</td></tr><tr><td>IsTaxForSale</td><td>BOOLEAN</td></tr><tr><td>IsTaxForPurchase</td><td>BOOLEAN</td></tr><tr><td>Components</td><td>RECORD</td></tr></tbody></table>

### carriers

Purpose: This API is used to fetch all carrier related information

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/carrier/carrier/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>CarrierID</td><td>STRING</td></tr><tr><td>Description</td><td>STRING</td></tr><tr><td>TrackingURL</td><td>STRING</td></tr></tbody></table>

### payment\_terms

Purpose: This API is used to fetch all payment terms of the account

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/payment-term/payment-term/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>Duration</td><td>NUMERIC</td></tr><tr><td>Method</td><td>STRING</td></tr><tr><td>IsActive</td><td>BOOLEAN</td></tr><tr><td>IsDefault</td><td>BOOLEAN</td></tr></tbody></table>

### locations

Purpose: This API is used to fetch all locations

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/location/location/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Name</td><td>STRING</td></tr><tr><td>IsDefault</td><td>BOOLEAN</td></tr><tr><td>IsDeprecated</td><td>BOOLEAN</td></tr><tr><td>FixedAssetsLocation</td><td>BOOLEAN</td></tr><tr><td>IsCoMan</td><td>BOOLEAN</td></tr><tr><td>IsShopFloor</td><td>BOOLEAN</td></tr><tr><td>IsStaging</td><td>BOOLEAN</td></tr></tbody></table>

### disassembly\_lists

Purpose: This API is used to fetch all disassembly lists

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/disassembly/disassembly-list/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>TaskID</td><td>STRING</td></tr><tr><td>DisassemblyNumber</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>ProductID</td><td>STRING</td></tr><tr><td>ProductCode</td><td>STRING</td></tr><tr><td>ProductName</td><td>STRING</td></tr><tr><td>LocationID</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>WIPAccount</td><td>STRING</td></tr><tr><td>CompletionDate</td><td>DATETIME</td></tr><tr><td>Quantity</td><td>NUMERIC</td></tr><tr><td>AssemblyInstructionURL</td><td>STRING</td></tr><tr><td>PickLines</td><td>RECORD</td></tr><tr><td>OrderLines</td><td>RECORD</td></tr></tbody></table>

### finished\_goods\_lists

Purpose: This API is used to fetch all finished goods lists

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/finished-goods/finished-goods-list/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>TaskID</td><td>STRING</td></tr><tr><td>AssemblyNumber</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>ProductID</td><td>STRING</td></tr><tr><td>ProductCode</td><td>STRING</td></tr><tr><td>ProductName</td><td>STRING</td></tr><tr><td>NonInventory</td><td>BOOLEAN</td></tr><tr><td>LocationID</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>WIPAccount</td><td>STRING</td></tr><tr><td>WIPDate</td><td>DATETIME</td></tr><tr><td>Account</td><td>STRING</td></tr><tr><td>Quantity</td><td>NUMERIC</td></tr><tr><td>AssemblyInstructionURL</td><td>STRING</td></tr><tr><td>CompletionDate</td><td>DATETIME</td></tr><tr><td>BatchSN</td><td>STRING</td></tr><tr><td>Notes</td><td>STRING</td></tr><tr><td>OrderLines</td><td>RECORD</td></tr><tr><td>PickLines</td><td>RECORD</td></tr><tr><td>Transactions</td><td>RECORD</td></tr><tr><td>CustomField1</td><td>STRING</td></tr><tr><td>CustomField2</td><td>STRING</td></tr><tr><td>CustomField3</td><td>STRING</td></tr><tr><td>CustomField4</td><td>STRING</td></tr><tr><td>CustomField5</td><td>STRING</td></tr><tr><td>CustomField6</td><td>STRING</td></tr><tr><td>CustomField7</td><td>STRING</td></tr><tr><td>CustomField8</td><td>STRING</td></tr><tr><td>CustomField9</td><td>STRING</td></tr><tr><td>CustomField10</td><td>STRING</td></tr></tbody></table>

### inventory\_write\_off\_lists

Purpose: This API is used to fetch the list of inventory write offs

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/inventory-write-off/inventory-write-off-list/get>

Replication: Full Replication

Replication Key: NA

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>TaskID</td><td>STRING</td></tr><tr><td>InventoryWriteOffNumber</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>LocationID</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>Account</td><td>STRING</td></tr><tr><td>EffectiveDate</td><td>DATETIME</td></tr><tr><td>Notes</td><td>STRING</td></tr><tr><td>Lines</td><td>RECORD</td></tr><tr><td>Transactions</td><td>RECORD</td></tr></tbody></table>

### sale\_list

Purpose: This API is used to fetch all sales list

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/sale/sale-list/get>

Replication: Key Based Incremental

Replication Key: UpdatedSince

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>Customer</td><td>STRING</td></tr><tr><td>CustomerID</td><td>STRING</td></tr><tr><td>Contact</td><td>STRING</td></tr><tr><td>Phone</td><td>STRING</td></tr><tr><td>Email</td><td>STRING</td></tr><tr><td>DefaultAccount</td><td>STRING</td></tr><tr><td>SkipQuote</td><td>BOOLEAN</td></tr><tr><td>BillingAddress</td><td>RECORD</td></tr><tr><td>ShippingAddress</td><td>RECORD</td></tr><tr><td>BaseCurrency</td><td>STRING</td></tr><tr><td>CustomerCurrency</td><td>STRING</td></tr><tr><td>TaxRule</td><td>STRING</td></tr><tr><td>TaxCalculation</td><td>STRING</td></tr><tr><td>Terms</td><td>STRING</td></tr><tr><td>PriceTier</td><td>STRING</td></tr><tr><td>ShipBy</td><td>DATETIME</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>SaleOrderDate</td><td>DATETIME</td></tr><tr><td>LastModifiedOn</td><td>TIMESTAMP</td></tr><tr><td>Note</td><td>STRING</td></tr><tr><td>CustomerReference</td><td>STRING</td></tr><tr><td>COGSAmount</td><td>NUMERIC</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>CombinedPickingStatus</td><td>STRING</td></tr><tr><td>CombinedPackingStatus</td><td>STRING</td></tr><tr><td>CombinedShippingStatus</td><td>STRING</td></tr><tr><td>FulFilmentStatus</td><td>STRING</td></tr><tr><td>CombinedInvoiceStatus</td><td>STRING</td></tr><tr><td>CombinedPaymentStatus</td><td>STRING</td></tr><tr><td>CombinedTrackingNumbers</td><td>STRING</td></tr><tr><td>CurrencyRate</td><td>NUMERIC</td></tr><tr><td>SalesRepresentative</td><td>STRING</td></tr><tr><td>ServiceOnly</td><td>BOOLEAN</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>SourceChannel</td><td>STRING</td></tr><tr><td>Quote</td><td>RECORD</td></tr><tr><td>Order</td><td>RECORD</td></tr><tr><td>Fulfilments</td><td>RECORD</td></tr><tr><td>Invoices</td><td>RECORD</td></tr><tr><td>CreditNotes</td><td>RECORD</td></tr><tr><td>ManualJournals</td><td>RECORD</td></tr><tr><td>Attachments</td><td>RECORD</td></tr><tr><td>InventoryMovements</td><td>RECORD</td></tr><tr><td>AdditionalAttributes</td><td>RECORD</td></tr><tr><td>ShippingNotes</td><td>STRING</td></tr><tr><td>Carrier</td><td>STRING</td></tr><tr><td>ExternalID</td><td>STRING</td></tr></tbody></table>

### purchase\_list

Purpose: This API is used to fetch all purchase lists

Source API Documentation: <https://dearinventory.docs.apiary.io/#reference/purchase/purchase-list/get>

Replication: Key Based Incremental

Replication Key: UpdatedSince

**Fields**

<table><thead><tr><th width="64">Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>ID</td><td>STRING</td></tr><tr><td>BlindReceipt</td><td>BOOLEAN</td></tr><tr><td>OrderNumber</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>OrderDate</td><td>DATETIME</td></tr><tr><td>InvoiceDate</td><td>DATETIME</td></tr><tr><td>Supplier</td><td>STRING</td></tr><tr><td>SupplierID</td><td>STRING</td></tr><tr><td>InvoiceNumber</td><td>STRING</td></tr><tr><td>InvoiceAmount</td><td>NUMERIC</td></tr><tr><td>PaidAmount</td><td>NUMERIC</td></tr><tr><td>InvoiceDueDate</td><td>DATETIME</td></tr><tr><td>RequiredBy</td><td>DATETIME</td></tr><tr><td>BaseCurrency</td><td>STRING</td></tr><tr><td>SupplierCurrency</td><td>STRING</td></tr><tr><td>OrderStatus</td><td>STRING</td></tr><tr><td>StockReceivedStatus</td><td>STRING</td></tr><tr><td>UnstockStatus</td><td>STRING</td></tr><tr><td>InvoiceStatus</td><td>STRING</td></tr><tr><td>CreditNoteStatus</td><td>STRING</td></tr><tr><td>LastUpdatedDate</td><td>DATETIME</td></tr><tr><td>Type</td><td>STRING</td></tr><tr><td>CombinedInvoiceStatus</td><td>STRING</td></tr><tr><td>CombinedPaymentStatus</td><td>STRING</td></tr><tr><td>CombinedReceivingStatus</td><td>STRING</td></tr><tr><td>IsServiceOnly</td><td>BOOLEAN</td></tr><tr><td>BillingAddress</td><td>RECORD</td></tr><tr><td>ShippingAddress</td><td>RECORD</td></tr><tr><td>Order</td><td>RECORD</td></tr><tr><td>StockReceived</td><td>RECORD</td></tr><tr><td>PutAway</td><td>RECORD</td></tr><tr><td>Invoice</td><td>RECORD</td></tr><tr><td>CreditNote</td><td>RECORD</td></tr><tr><td>ManualJournals</td><td>RECORD</td></tr><tr><td>AdditionalAttributes</td><td>RECORD</td></tr><tr><td>Attachments</td><td>RECORD</td></tr><tr><td>InventoryMovements</td><td>RECORD</td></tr><tr><td>Contact</td><td>STRING</td></tr><tr><td>Phone</td><td>STRING</td></tr><tr><td>InventoryAccount</td><td>STRING</td></tr><tr><td>Approach</td><td>STRING</td></tr><tr><td>TaxRule</td><td>STRING</td></tr><tr><td>TaxCalculation</td><td>STRING</td></tr><tr><td>Terms</td><td>STRING</td></tr><tr><td>Location</td><td>STRING</td></tr><tr><td>Note</td><td>STRING</td></tr><tr><td>CurrencyRate</td><td>NUMERIC</td></tr><tr><td>LastUpdatedDate_ts</td><td>TIMESTAMP</td></tr></tbody></table>