| Entity | SalesOrderLine |
| Key property | ID |
| Property starting with A | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| AmountExcludingDiscountIncludingVAT | Amount excluding discount including VAT | Amount excluding discount including VAT | Double | |||||
| Area | Search code area | Search code area | String | |||||
| Property starting with B | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| BlanketOrderLine | Line number main item | Line number main item | GUID | |||||
| Property starting with C | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| CityOfLoading | Search code city of loading/unloading | Search code city of loading/unloading | String | |||||
| CostCenter | Cost center | Cost center | String | |||||
| CostPrice | Standard cost price | Standard cost price | Double | |||||
| CostUnit | Cost unit | Cost unit | String | |||||
| CountryISO | ISO country | ISO country | String | |||||
| CountryOrigin | Country of assembly | Country of assembly | String | |||||
| Property starting with D | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| DeliveryDate | Delivery date | Delivery date | Date | |||||
| DeliveryMethod | Search code delivery method | Search code delivery method | String | |||||
| Description | Description | Description | String | |||||
| DestinationCountry | Destination country | Destination country | String | |||||
| DiscountPercentage | Discount percentage | Discount percentage | 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 | |||||
| Instruction | Instruction | Instruction | String | |||||
| Itemcode | Item code | Item code | String | |||||
| ItemType | Item type | Item type | String | |||||
| Property starting with L | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| LineNumber | Line number | Line number | Number | |||||
| Property starting with N | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| NetPrice | Net price | Net price | Double | |||||
| NetWeight | Weight / statistical unit | Weight / statistical unit | Double | |||||
| Property starting with O | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| OriginalPlannedDate | Originally planneddate | Originally planneddate | Date | |||||
| Property starting with P | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| PlannedDate | Planned date | Planned date | Date | |||||
| Price | Price | Price | Double | |||||
| PriceList | Price list | Price list | String | |||||
| Project | Project number | Project number | String | |||||
| PurchaseOrderLine | Line number main item | Line number main item | Number | |||||
| PurchaseOrderNumber | Purchase order number | Purchase order number | String | |||||
| Property starting with Q | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Quantity | Quantity | Quantity | Double | |||||
| QuantityDelivered | Quantity delivered | Quantity delivered | Double | |||||
| Property starting with R | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| RequestedDate | Requested date | Requested date | Date | |||||
| Resource | Resource | Resource | Integer | |||||
| Property starting with S | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| SalesOrderNumber | Sales order number | Sales order number | String | |||||
| SerialNumber | Service number | Service number | String | |||||
| StatisticalCode | Stats. number | Stats. number | String | |||||
| StatisticalSystem | Search code statistical system | Search code statistical system | String | |||||
| StatisticalUnits | Statistical units / sales unit | Statistical units / sales unit | Double | |||||
| Property starting with T | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| TransactionA | Search code transaction A | Search code transaction A | String | |||||
| TransactionB | Search code transaction B | Search code transaction B | String | |||||
| TransactionKey | TransactionKey | Transaction key | GUID |
|
||||
| Transportation | Transport method search code | Transport method search code | String | |||||
| TransShipment | Transshipment search code | Transshipment search code | String | |||||
| Property starting with U | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Unit | Unit | Unit | String | |||||
| UpdateDeliveryDate | Update delivery date | Update delivery date | Boolean | |||||
| Property starting with V | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| VATCode | VAT code | VAT code | String | |||||
| 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 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 |
| AmountExcludingDiscountIncludingVAT | bdr_ev_ed_val | Double | 8 | 2 |
|
|
|
||||||||||
| Area | int_regio | String | 10 | 0 |
|
|
|||||||||||
| Property starting with B | |||||||||||||||||
| 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 |
| BlanketOrderLine | BlanketPoline | GUID | 1 | 0 |
|
|
|||||||||||
| 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 |
| CityOfLoading | plts_ll | String | 10 | 0 |
|
|
|||||||||||
| CostCenter | kstplcode | String | 8 | 0 |
|
|
|||||||||||
| CostPrice | vvp | Double | 8 | 3 |
|
|
|
||||||||||
| CostUnit | kstdrcode | String | 8 | 0 |
|
|
|||||||||||
| CountryISO | land_iso | String | 3 | 0 |
|
|
|||||||||||
| CountryOrigin | landoorspr | String | 3 | 0 |
|
|
|||||||||||
| 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 |
| DeliveryDate | afldat | Date | 6 | 0 |
|
||||||||||||
| DeliveryMethod | intra_lvcd | String | 10 | 0 |
|
|
|||||||||||
| Description | oms45 | String | 60 | 0 |
|
||||||||||||
| DestinationCountry | landbest | String | 3 | 0 |
|
|
|||||||||||
| DiscountPercentage | korting | Double | 3 | 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 | 0 |
|
|||||||||||
| Instruction | instruction | String | 160 | 0 |
|
||||||||||||
| Itemcode | artcode | String | 30 | 0 |
|
|
|||||||||||
| ItemType | ar_soort | String | 1 | 0 |
|
|
|||||||||||
| Property starting with L | |||||||||||||||||
| 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 |
| LineNumber | regel | Number | 4 | 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 |
| NetPrice | prijs_n | Double | 8 | 3 |
|
|
|||||||||||
| NetWeight | gewicht_bi | Double | 13 | 4 |
|
||||||||||||
| 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 |
| OriginalPlannedDate | Originalplanneddate | Date | 6 | 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 |
| PlannedDate | PlannedDate | Date | 6 | 0 |
|
||||||||||||
| Price | prijs83 | Double | 8 | 3 |
|
|
|||||||||||
| PriceList | prijslijst | String | 15 | 0 |
|
|
|||||||||||
| Project | projectnr | String | 20 | 0 |
|
||||||||||||
| PurchaseOrderLine | regel_hfda | Number | 4 | 0 |
|
|
|||||||||||
| PurchaseOrderNumber | purchaseordernr | String | 8 | 0 |
|
|
|||||||||||
| Property starting with Q | |||||||||||||||||
| 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 |
| Quantity | esr_aantal | Double | 6 | 3 |
|
||||||||||||
| QuantityDelivered | aant_gelev | Double | 6 | 3 |
|
||||||||||||
| 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 |
| RequestedDate | Requesteddate | Date | 6 | 0 |
|
||||||||||||
| Resource | res_id | Integer | 10 | 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 |
| SalesOrderNumber | ordernr | String | 8 | 0 |
|
|
|||||||||||
| SerialNumber | serie_num | String | 22 | 0 |
|
|
|||||||||||
| StatisticalCode | statistnr | String | 9 | 0 |
|
|
|||||||||||
| StatisticalSystem | stelsel | String | 10 | 0 |
|
|
|||||||||||
| StatisticalUnits | stateenh_i | Double | 12 | 3 |
|
||||||||||||
| 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 |
| TransactionA | transact_a | String | 10 | 0 |
|
|
|||||||||||
| TransactionB | transact_b | String | 10 | 0 |
|
|
|||||||||||
| TransactionKey | _TransactionKey | GUID |
|
0 | 0 | ||||||||||||
| Transportation | vervoer | String | 10 | 0 |
|
|
|||||||||||
| TransShipment | trsshpm_cd | String | 10 | 0 |
|
|
|||||||||||
| Property starting with U | |||||||||||||||||
| 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 |
| Unit | unit | String | 5 | 0 |
|
||||||||||||
| UpdateDeliveryDate | Boolean | 0 | 0 | ||||||||||||||
| Property starting with V | |||||||||||||||||
| 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 |
| VATCode | btw_code | String | 3 | 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 |
|
|
|||||||||||