Exact Online API Data Model
StageForDeliveryReceipts: Exact Online Stage for Delivery Receipts |
Catalog: ExactOnlineREST
Schema: Manufacturing
Primary Keys: Id
Label: Stage for Delivery Receipts
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Select Exact Online API URL: /api/v1/{division}/manufacturing/StageForDeliveryReceipts
Insert Exact Online API URL: /api/v1/{division}/manufacturing/StageForDeliveryReceipts
Update Exact Online API URL: /api/v1/{division}/manufacturing/StageForDeliveryReceipts
Delete Exact Online API URL: /api/v1/{division}/manufacturing/StageForDeliveryReceipts
Exact Online API Metadata URL: /api/v1/{division}/manufacturing/$metadata
Field Selection Method: Required
Table Columns
The columns of the table StageForDeliveryReceipts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CreatedBy |
guid |
|
☐ |
ID of creating user. |
CreatedByFullName |
string(240) |
|
☐ |
Name of the creating user. |
CreatedDate |
datetime |
|
☐ |
Date this Stage for delivery wa created. |
Division |
int32 |
Division ID |
☑ |
Unique number of the Exact Online division. |
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. |
HasReversibleQuantity |
boolean |
|
☑ |
Indicates if this StageForDeliveryReceipt has a quantity eligible to be reversed via StageForDeliveryReversals. |
Id |
guid |
ID |
☑ |
ID of staged for delivery entry. |
IsBatch |
int16 |
|
☑ |
Does the shop order receipt's item use batch numbers. |
IsFractionAllowedItem |
int16 |
Is Fraction Allowed on Item |
☑ |
Indicates if fractions (for example 0.35) are allowed for quantities of the stage for delivery receipt's item. |
IsSerial |
int16 |
|
☑ |
Does the shop order receipt's item use serial numbers. |
Item |
guid |
Item |
☐ |
Item staged for delivery. |
ItemCode |
string(30) |
Item Code |
☐ |
Code of item staged for delivery. |
ItemDescription |
string(60) |
Item Description |
☐ |
Description of item staged for delivery. |
ItemPictureUrl |
string |
|
☐ |
Picture url of shop order item. |
Quantity |
double |
Quantity |
☐ |
Quantity of this StageForDeliveryReceipt. |
RelatedId |
guid |
|
☐ |
ID of the original stage for delivery entry. |
ShopOrder |
guid |
Shop Order |
☑ |
Shop order staged for delivery. |
ShopOrderNumber |
int32 |
|
☐ |
Number of shop order staged for delivery. |
TransactionDate |
datetime |
|
☐ |
Effective date of this stage for delivery receipt. |
Unit |
string(8) |
Unit |
☐ |
Unit of measurement abbreviation of item finished. |
UnitDescription |
string(60) |
Unit Description |
☐ |
Unit of measurement of item finished. |
Warehouse |
guid |
Warehouse |
☐ |
ID of the shop order warehouse. |
WarehouseCode |
string |
Warehouse Code |
☐ |
Code of the shop order warehouse. |
WarehouseDescription |
string |
Warehouse Description |
☐ |
Description of the shop order warehouse. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
