| 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 |
|
|||||||||||