Entity | SalesOrderHeader |
Key property | SalesOrderNumber |
Property starting with A | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ApplyLinkItem | ApplyLinkItem | ApplyLinkItem | Boolean | |||||
ApplyShippingCharges | Apply shipping charges | Apply shipping charges | Boolean | |||||
Property starting with C | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Completed | Completed | Completed | Boolean | |||||
CostCenter | Cost center | Cost center | String | |||||
CurrencyCode | Currency code | Currency code | String | |||||
CurrencyRate | XRate | XRate | String | |||||
Property starting with D | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
DeletionReason | DeletionReason | String |
![]() |
|||||
DeliveryDate | Delivery date | Delivery date | Date | |||||
DeliveryDebtor | Delivery debtor number | Delivery debtor number | String | |||||
DeliveryDebtorAddress1 | Address line 1 | Address line 1 | String | |||||
DeliveryDebtorAddress2 | Address line 2 | Address line 2 | String | |||||
DeliveryDebtorAddress3 | Address line 3 | Address line 3 | String | |||||
DeliveryDebtorCity | City | City | String | |||||
DeliveryDebtorContactEmail | Delivery address contact person's email | Delivery address contact person's email | String | |||||
DeliveryDebtorContactPerson | Contact | Contact | String | |||||
DeliveryDebtorCountryCode | Country code | Country code | String | |||||
DeliveryDebtorCounty | County | County | String | |||||
DeliveryDebtorFax | Fax | Fax | String | |||||
DeliveryDebtorInitials | Initials | Initials | String | |||||
DeliveryDebtorJobDescription | Job description | Job description | String | |||||
DeliveryDebtorName | Delivery Debtor Name | Delivery Debtor Name | String | |||||
DeliveryDebtorPhone | Phone | Phone | String | |||||
DeliveryDebtorPostCode | Postcode | Postcode | String | |||||
DeliveryDebtorStateCode | State | State | String | |||||
DeliveryDebtorTitle | Title | Title | String | |||||
Description1 | Description 1 | Description 1 | String | |||||
Description2 | Description 2 | Description 2 | String | |||||
Description3 | Description 3 | Description 3 | String | |||||
Property starting with E | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ExtraItemDescription | Extra item description code | Extra item description code | String | |||||
Property starting with F | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
FreeField1 | Sales Order: free field 1 | Sales Order: free field 1 | String | |||||
FreeField2 | Sales Order: free field 2 | Sales Order: free field 2 | String | |||||
FreeField3 | Sales Order: free field 3 | Sales Order: free field 3 | String | |||||
FreeField4 | Sales Order: free field 4 | Sales Order: free field 4 | Double | |||||
FreeField5 | Sales Order: free field 5 | Sales Order: free field 5 | Double | |||||
Property starting with G | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
GrossWeight | Gross weight | Gross weight | Double | |||||
Property starting with I | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
ID | ID | ID | Integer | |||||
InvoiceCode | Invoice code | Invoice code | String | |||||
InvoiceDebtor | Invoice debtor | Invoice debtor | String | |||||
InvoiceDebtorAddress1 | Address line 1 | Address line 1 | String | |||||
InvoiceDebtorAddress2 | Address line 2 | Address line 2 | String | |||||
InvoiceDebtorAddress3 | Address line 3 | Address line 3 | String | |||||
InvoiceDebtorCity | City | City | String | |||||
InvoiceDebtorContactEmail | Invoice address contact person's email | Invoice address contact person's email | String | |||||
InvoiceDebtorContactPerson | Contact | Contact | String | |||||
InvoiceDebtorCountryCode | Country code | Country code | String | |||||
InvoiceDebtorFax | Fax | Fax | String | |||||
InvoiceDebtorInitials | Initials | Initials | String | |||||
InvoiceDebtorJobDescription | Job description | Job description | String | |||||
InvoiceDebtorName | Invoice Debtor Name | Invoice Debtor Name | String | |||||
InvoiceDebtorPhone | Phone | Phone | String | |||||
InvoiceDebtorPostCode | Postcode | Postcode | String | |||||
InvoiceDebtorStateCode | State | State | String | |||||
InvoiceDebtorTitle | Title | Title | String | |||||
IsEDI | EDI | EDI | Boolean | |||||
Property starting with N | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
NetWeight | Net weight | Net weight | Double | |||||
Property starting with O | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
OrderConfirmation | Print sales order confirmation | Print sales order confirmation | Boolean | |||||
OrderDebtor | Debtor number | Debtor number | String |
![]() |
||||
OrderDebtorAddress1 | Address line 1 | Address line 1 | String | |||||
OrderDebtorAddress2 | Address line 2 | Address line 2 | String | |||||
OrderDebtorAddress3 | Address line 3 | Address line 3 | String | |||||
OrderDebtorCity | City | City | String | |||||
OrderDebtorContactEmail | Order address contact person's email | Order address contact person's email | String | |||||
OrderDebtorContactPerson | Contact | Contact | String | |||||
OrderDebtorCountryCode | Country code | Country code | String | |||||
OrderDebtorFax | Fax | Fax | String | |||||
OrderDebtorInitials | Initials | Initials | String | |||||
OrderDebtorJobDescription | Job description | Job description | String | |||||
OrderDebtorName | Order Debtor Name | Order Debtor Name | String | |||||
OrderDebtorPhone | Phone | Phone | String | |||||
OrderDebtorPostCode | Postcode | Postcode | String | |||||
OrderDebtorStateCode | State | State | String | |||||
OrderDebtorTitle | Title | Title | String | |||||
OrderLines | Order lines | Order lines | String | |||||
OurReference | Our reference | Our reference | String | |||||
Property starting with P | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Packages | Packages | Packages | Number | |||||
ParentProject | ParentProject | ParentProject | String | |||||
PartialDelivery | Partial delivery allowed | Partial delivery allowed | Boolean | |||||
PaymentCondition | Payment condition | Payment condition | String | |||||
PaymentMethod | Payment method | Payment method | String | |||||
ProductLine | Product line | Origin of order created | String | |||||
Project | Project number | Project number | String | |||||
Property starting with R | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Reference | Description | Description | String | |||||
Resource | Representative | Representative | Integer | |||||
Route | Route | Route | String | |||||
Property starting with S | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
SalesOrderDate | Sales order date | Sales order date | Date | |||||
SalesOrderNumber | Sales order number | Sales order number | String | |||||
SelectionCode | Selection code | Selection code | String | |||||
ShippingVia | Delivery method | Delivery method | String | |||||
Property starting with T | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
TotalAmount | Total amount | Total amount | Double | |||||
TotalAmountExcludingVAT | Total amount excluding VAT | Total amount excluding VAT | Double | |||||
TotalVATAmount | Total VAT amount | Total VAT amount | Double | |||||
TransactionKey | Transaction key | Transaction key | GUID |
![]() |
||||
Property starting with W | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
Warehouse | Warehouse | Warehouse | String | |||||
Property starting with Y | ||||||||
Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
YourReference | Your reference | Your reference | String |
![]() |
Property starting with A | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
ApplyLinkItem | ApplyLinkItem | Boolean | 1 | 0 |
![]() |
![]() |
|||||||||||
ApplyShippingCharges | ApplyShippingCharges | Boolean | 1 | 1 |
![]() |
![]() |
|||||||||||
Property starting with C | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
Completed | afgehandld | Boolean | 1 | 0 |
![]() |
![]() |
|||||||||||
CostCenter | kstplcode | String | 8 | 0 |
![]() |
![]() |
|||||||||||
CurrencyCode | valcode | String | 3 | 0 |
![]() |
![]() |
|||||||||||
CurrencyRate | koers | String | 5 | 6 | |||||||||||||
Property starting with D | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
DeletionReason | DeletionReason | String |
![]() |
160 | 0 | ||||||||||||
DeliveryDate | afldat | Date | 6 | 0 |
![]() |
||||||||||||
DeliveryDebtor | verzdebnr | String | 6 | 0 |
![]() |
![]() |
|||||||||||
DeliveryDebtorAddress1 | del_AddressLine1 | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorAddress2 | del_AddressLine2 | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorAddress3 | del_AddressLine3 | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorCity | del_City | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorContactEmail | del_contactemail | String | 128 | 0 |
![]() |
||||||||||||
DeliveryDebtorContactPerson | del_ContactPerson | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorCountryCode | del_landcode | String | 3 | 0 |
![]() |
||||||||||||
DeliveryDebtorCounty | del_County | String | 100 | 0 |
![]() |
||||||||||||
DeliveryDebtorFax | del_Fax | String | 50 | 0 |
![]() |
||||||||||||
DeliveryDebtorInitials | del_Initials | String | 10 | 0 |
![]() |
||||||||||||
DeliveryDebtorJobDescription | del_cnt_job_desc | String | 50 | 0 |
![]() |
||||||||||||
DeliveryDebtorName | del_debtor_name | String | 50 | 0 |
![]() |
||||||||||||
DeliveryDebtorPhone | del_Phone | String | 50 | 0 |
![]() |
||||||||||||
DeliveryDebtorPostCode | del_PostCode | String | 20 | 0 |
![]() |
||||||||||||
DeliveryDebtorStateCode | del_StateCode | String | 3 | 0 |
![]() |
||||||||||||
DeliveryDebtorTitle | del_Predcode | String | 4 | 0 |
![]() |
![]() |
|||||||||||
Description1 | refer1 | String | 20 | 0 |
![]() |
||||||||||||
Description2 | refer2 | String | 20 | 0 |
![]() |
||||||||||||
Description3 | refer3 | String | 20 | 0 |
![]() |
||||||||||||
Property starting with E | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
ExtraItemDescription | ex_artcode | String | 2 | 0 |
![]() |
![]() |
|||||||||||
Property starting with F | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
FreeField1 | freefield1 | String | 75 | 0 |
![]() |
||||||||||||
FreeField2 | freefield2 | String | 75 | 0 |
![]() |
||||||||||||
FreeField3 | freefield3 | String | 75 | 0 |
![]() |
||||||||||||
FreeField4 | freefield4 | Double | 8 | 2 |
![]() |
||||||||||||
FreeField5 | freefield5 | Double | 8 | 2 |
![]() |
||||||||||||
Property starting with G | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
GrossWeight | bruto_gew | Double | 6 | 2 | |||||||||||||
Property starting with I | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
ID | ID | Integer | 0 | 0 |
![]() |
||||||||||||
InvoiceCode | fakt_code | String | 3 | 0 |
![]() |
![]() |
|||||||||||
InvoiceDebtor | fakdebnr | String | 6 | 0 |
![]() |
![]() |
|||||||||||
InvoiceDebtorAddress1 | inv_AddressLine1 | String | 100 | 0 |
![]() |
||||||||||||
InvoiceDebtorAddress2 | inv_AddressLine2 | String | 100 | 0 |
![]() |
||||||||||||
InvoiceDebtorAddress3 | inv_AddressLine3 | String | 100 | 0 |
![]() |
||||||||||||
InvoiceDebtorCity | inv_City | String | 100 | 0 |
![]() |
||||||||||||
InvoiceDebtorContactEmail | inv_contactemail | String | 128 | 0 |
![]() |
||||||||||||
InvoiceDebtorContactPerson | inv_ContactPerson | String | 100 | 0 |
![]() |
||||||||||||
InvoiceDebtorCountryCode | inv_landcode | String | 3 | 0 |
![]() |
||||||||||||
InvoiceDebtorFax | inv_Fax | String | 50 | 0 |
![]() |
||||||||||||
InvoiceDebtorInitials | inv_Initials | String | 10 | 0 |
![]() |
||||||||||||
InvoiceDebtorJobDescription | inv_cnt_job_desc | String | 50 | 0 |
![]() |
||||||||||||
InvoiceDebtorName | inv_debtor_name | String | 50 | 0 |
![]() |
||||||||||||
InvoiceDebtorPhone | inv_Phone | String | 50 | 0 |
![]() |
||||||||||||
InvoiceDebtorPostCode | inv_PostCode | String | 20 | 0 |
![]() |
||||||||||||
InvoiceDebtorStateCode | inv_StateCode | String | 3 | 0 |
![]() |
||||||||||||
InvoiceDebtorTitle | inv_Predcode | String | 4 | 0 |
![]() |
![]() |
|||||||||||
IsEDI | IsEDI | Boolean | 1 | 0 |
![]() |
![]() |
|||||||||||
Property starting with N | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
NetWeight | netto_gew | Double | 6 | 2 | |||||||||||||
Property starting with O | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
OrderConfirmation | ordbv_afdr | Boolean | 1 | 0 |
![]() |
![]() |
|||||||||||
OrderDebtor | debnr | String |
![]() |
6 | 0 |
![]() |
![]() |
||||||||||
OrderDebtorAddress1 | ord_AddressLine1 | String | 100 | 0 |
![]() |
||||||||||||
OrderDebtorAddress2 | ord_AddressLine2 | String | 100 | 0 |
![]() |
||||||||||||
OrderDebtorAddress3 | ord_AddressLine3 | String | 100 | 0 |
![]() |
||||||||||||
OrderDebtorCity | ord_City | String | 100 | 0 |
![]() |
||||||||||||
OrderDebtorContactEmail | ord_contactemail | String | 128 | 0 |
![]() |
||||||||||||
OrderDebtorContactPerson | ord_ContactPerson | String | 100 | 0 |
![]() |
||||||||||||
OrderDebtorCountryCode | ord_landcode | String | 3 | 0 |
![]() |
||||||||||||
OrderDebtorFax | ord_Fax | String | 50 | 0 |
![]() |
||||||||||||
OrderDebtorInitials | ord_Initials | String | 10 | 0 |
![]() |
||||||||||||
OrderDebtorJobDescription | ord_cnt_job_desc | String | 50 | 0 |
![]() |
||||||||||||
OrderDebtorName | ord_debtor_name | String | 50 | 0 |
![]() |
||||||||||||
OrderDebtorPhone | ord_Phone | String | 50 | 0 |
![]() |
||||||||||||
OrderDebtorPostCode | ord_PostCode | String | 20 | 0 |
![]() |
||||||||||||
OrderDebtorStateCode | ord_StateCode | String | 3 | 0 |
![]() |
||||||||||||
OrderDebtorTitle | ord_Predcode | String | 4 | 0 |
![]() |
![]() |
|||||||||||
OrderLines | _OrderLines | String | 0 | 0 | |||||||||||||
OurReference | _OurReference | String | 0 | 0 |
![]() |
||||||||||||
Property starting with P | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
Packages | colli | Number | 5 | 0 |
![]() |
![]() |
|||||||||||
ParentProject | _ParentProject | String | 0 | 0 | |||||||||||||
PartialDelivery | betaald | Boolean | 1 | 0 |
![]() |
![]() |
|||||||||||
PaymentCondition | betcond | String | 2 | 0 |
![]() |
![]() |
|||||||||||
PaymentMethod | paymentmethod | String | 1 | 0 |
![]() |
![]() |
|||||||||||
ProductLine | productline | String | 20 | 0 |
![]() |
![]() |
|||||||||||
Project | projectnr | String | 20 | 0 |
![]() |
||||||||||||
Property starting with R | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
Reference | refer | String | 20 | 0 |
![]() |
||||||||||||
Resource | represent_id | Integer | 10 | 0 |
![]() |
![]() |
|||||||||||
Route | routecode | String | 2 | 0 |
![]() |
![]() |
|||||||||||
Property starting with S | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
SalesOrderDate | orddat | Date | 6 | 0 |
![]() |
||||||||||||
SalesOrderNumber | ordernr | String | 8 | 0 |
![]() |
![]() |
|||||||||||
SelectionCode | selcode | String | 2 | 0 |
![]() |
![]() |
|||||||||||
ShippingVia | levwijze | String | 5 | 0 |
![]() |
![]() |
|||||||||||
Property starting with T | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
TotalAmount | bdr_val | Double | 8 | 2 |
![]() |
![]() |
![]() |
||||||||||
TotalAmountExcludingVAT | bdr_ev_val | Double | 8 | 2 |
![]() |
![]() |
![]() |
||||||||||
TotalVATAmount | bdr_vat_val | Double | 8 | 2 |
![]() |
![]() |
![]() |
||||||||||
TransactionKey | _TransactionKey | GUID |
![]() |
0 | 0 | ||||||||||||
Property starting with W | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
Warehouse | magcode | String | 4 | 0 |
![]() |
![]() |
|||||||||||
Property starting with Y | |||||||||||||||||
Name | Source name | Type | Mandatory | Length | Scale | Default value | Lower range | Upper range | Allowed characters | Auto increment | Numeric string | Right aligned | Unsigned | Upper case | Zero equals null | Zero fill | Selection values |
YourReference | docnumber | String |
![]() |
30 | 0 |
![]() |