Exact Online API Data Model
GoodsDeliveryLinesBulk: Exact Online Goods Delivery Lines |
Catalog: ExactOnlineREST
Schema: SalesOrder
Primary Keys: ID
Label: Goods Delivery Lines
The data in this table is partitioned per value of the Division column.
This is a read-only table. The Exact Online API may not support changing the data or the Invantive SQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API.
Webhook Topic: GoodsDeliveries
Webhook Key Field: EntryID
Select Exact Online API URL: /api/v1/{division}/bulk/salesorder/GoodsDeliveryLines
Insert Exact Online API URL: /api/v1/{division}/bulk/salesorder/GoodsDeliveryLines
Update Exact Online API URL: /api/v1/{division}/bulk/salesorder/GoodsDeliveryLines
Delete Exact Online API URL: /api/v1/{division}/bulk/salesorder/GoodsDeliveryLines
Exact Online API Metadata URL: /api/v1/{division}/bulk/salesorder/$metadata
Field Selection Method: RequiredExpanded
Table Columns
The columns of the table GoodsDeliveryLinesBulk are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
Created |
datetime |
Created |
☐ |
Creation date. |
CreatedUtc |
datetime |
Created (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Creator |
☐ |
User ID of creator. |
CreatorFullName |
string |
Creator Full Name |
☐ |
Name of creator. |
CustomerItemCode |
string |
|
☐ |
Code the customer uses for this item. |
DeliveryDate |
datetime |
Delivery Date |
☐ |
Date of goods delivery. |
Description |
string |
Description |
☐ |
Description of sales order delivery. |
Division |
int32 |
Division |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(20) |
Division Chamber of Commerce Number |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Division IBAN Number |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Division Company Name |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Division RSIN Number |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Division VAT Number |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Division Wage Tax Number |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Division Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administration Name |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Subscription Holder Name |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Subscription Holder Number |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Division Short Name |
☑ |
Short name of the Exact Online division. |
EntryID |
guid |
Entry ID |
☐ |
The EntryID identifies the goods delivery. All the lines of a goods delivery have the same EntryID. |
ID |
guid |
ID |
☑ |
The unique identifier of a stock transaction for a goods delivery line. A goods delivery line can be split into multiple storage locations. In this case, multiple storage locations will have the same stock transaction ID. |
Item |
guid |
Item |
☐ |
Reference to item. |
ItemCode |
string |
Item Code |
☐ |
Item code. |
ItemDescription |
string |
Item Description |
☐ |
Description of item. |
LineNumber |
int32 |
Line Number |
☐ |
Line number. |
Modified |
datetime |
Modified |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Modified (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Modifier |
☐ |
User ID of modifier. |
ModifierFullName |
string |
Modified Full Name |
☐ |
Name of modifier. |
Notes |
string |
Notes |
☐ |
Notes. |
QuantityDelivered |
double |
Quantity Delivered |
☐ |
Quantity delivered. |
QuantityOrdered |
double |
Quantity Ordered |
☐ |
Quantity ordered. |
SalesOrderLineID |
guid |
Sales Order Line ID |
☐ |
Reference to sales order. |
SalesOrderLineNumber |
int32 |
Sales Order Line Number |
☐ |
Sales order line number. |
SalesOrderNumber |
int32 |
Sales Order Number |
☐ |
Sales order number. |
StorageLocation |
guid |
Storage Location |
☐ |
Reference to storage location. |
StorageLocationCode |
string |
Storage Location Code |
☐ |
Storage location code. |
StorageLocationDescription |
string |
Storage Location Description |
☐ |
Storage location description. |
TrackingNumber |
string |
Tracking Number |
☐ |
Reference to tracking number. |
Unitcode |
string |
Unit Code |
☐ |
Code of item unit. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
