Power BI Connector for Exact Online

Build 24.0.9062

PurchaseReturnLines

Use this endpoint to create a new purchase return line, retrieve an existing purchase return line and update an existing purchase return line

Columns

Name Type ReadOnly Description
ID [KEY] String True

ID of PurchaseReturnLines

CreateCredit Bool False

Credit NOte

Created Datetime False

Creation Date

Creator String False

User ID of the creator

CreatorFullName String False

Name of the creator

Division Int False

Division Code

EntryID String False

EntryID identifies the purchase return.

Expense String False

Expense related to the Work Breakdown Structure of the selected project.

ExpenseDescription String False

Description of expense.

GoodsReceiptLineID String False

ID of the goods receipts line

Item String False

The unique identifier of the item being returned

ItemCode String False

Code of the returned item

ItemDescription String False

Item Description

LineNumber Int False

LineNumber

Location String False

ID of the storage location in the warehouse where the item is returned

LocationCode String False

Code of the storage location in the warehouse where the item is returned

LocationDescription String False

Description of the storage location in the warehouse where the item is returned

Modified Datetime False

Last modified date

Modifier String False

User ID of the last modifier

ModifierFullName String False

Name of the last modifier

Notes String False

Notes related to the return

Project String False

Reference to project.

ProjectCode String False

Project Code

ProjectDescription String False

Description of the project.

PurchaseOrderLineID String False

ID of the purchase order line that is returned

PurchaseOrderNumber Int False

Order number of the purchase order that is returned

Rebill Bool False

Indicates whether the purchase order line needs to be rebilled.

ReceiptNumber Int False

Receipt number of the return

ReceivedQuantity Double False

Quantity received

ReturnQuantity Double False

Quantity returned

ReturnReasonCodeDescription String False

Description of ReasonCode

ReturnReasonCodeID String False

Indicates the reason why the purchase was returned

SupplierItemCode String False

Supplier item code

UnitCode String False

Unit code of the purchase

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062