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 |
![]() |
![]() |