| Entity | InvoiceLine |
| 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 |
| AmountInclDiscExclVAT | AmountInclDiscExclVAT | Amount including discount excluding VAT | Double | |||||
| Area | Area | Area | String | |||||
| Property starting with C | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| CityOfLoading | CityOfLoading | Intrastat | String | |||||
| CostCenter | Cost center | Cost center | String | |||||
| CostUnit | CostUnit | Cost unit | String | |||||
| Country | Country | Country | String | |||||
| CountryISO | CountryISO | Country ISO | String | |||||
| CountryOrigin | CountryOrigin | Country origin | 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 | DeliveryMethod | Delivery method | String | |||||
| Description | Description | Description | String | |||||
| DiscountPercentage | Discount percentage | Discount percentage | Number | |||||
| 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 | Number | |||||
| InvoicePeriodEndDate | InvoicePeriodEndDate | Invoice period end date | Date | |||||
| InvoiceProposalID | Invoice Proposal ID | Invoice Proposal ID | String | |||||
| IsTextItem | Is Text Item | Is Text Item | Boolean | |||||
| ItemCode | Item code | Item code | String | |||||
| ItemType | ItemType | 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 | |||||
| LineNumberLink | Line number link | Line number link | GUID | |||||
| LongDescription | Long description | Long description | String | |||||
| 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 | NetWeight | 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 |
| Option | Option | Option | String | |||||
| Property starting with P | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Price | Price | Price | Double | |||||
| PriceList | PriceList | Price list | String | |||||
| Project | Project | Project | 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 | |||||
| Property starting with R | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| RequestID | Request ID | Request ID | Number | |||||
| Resource | Resource | Resource | Number | |||||
| Property starting with S | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| SalesOrderLine | SalesOrderLine | Sales order line | Integer | |||||
| SalesOrderNumber | SalesOrderNumber | Sales Order number | String | |||||
| SequenceNumber | SequenceNumber | Sequence number | String | |||||
| SerialNumber | SerialNumber | Serial number | String | |||||
| SMSInvoiceLine | SMSInvoiceLine | SMS invoice line ID | GUID | |||||
| StatisticalCode | StatisticalCode | Statistical code | String | |||||
| StatisticalSystem | StatisticalSystem | Statistical system | String | |||||
| StatisticalUnits | StatisticalUnits | Statistical units | Double | |||||
| Property starting with T | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| TransactionA | TransactionA | Search code transaction A | String | |||||
| TransactionB | TransactionB | Search code transaction B | String | |||||
| TransactionKey | Transaction key | Transaction key | GUID |
|
||||
| Transportation | Transportation | Transportation | String | |||||
| TransShipment | TransShipment | Transshipment search code | String | |||||
| 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 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 |
| AmountInclDiscExclVAT | bdr_ev_ed_val | Double | 8 | 2 |
|
|
|
||||||||||
| Area | int_regio | String | 10 | 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 |
|
|
|
||||||||||
| CostUnit | kstdrcode | String | 8 | 0 |
|
||||||||||||
| Country | landbest | String | 3 | 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 | 0 | 0 |
|
||||||||||||
| DeliveryMethod | intra_lvcd | String | 10 | 0 |
|
|
|||||||||||
| Description | oms45 | String | 60 | 0 |
|
||||||||||||
| DiscountPercentage | korting | Number | 6 | 2 | 0.0 |
|
|||||||||||
| 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 | Number | 0 | 0 | |||||||||||||
| InvoicePeriodEndDate | eind_dat_c | Date | 0 | 0 | |||||||||||||
| InvoiceProposalID | _InvoiceProposalID | String | 0 | 0 | |||||||||||||
| IsTextItem | _IsTextItem | Boolean | 0 | 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 |
|
|
|||||||||||
| LineNumberLink | SalesOrderLine | GUID | 34 | 0 | |||||||||||||
| LongDescription | TextDescription | String | 125 | 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 | 16 | 4 |
|
|
|
||||||||||
| 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 |
| Option | _Option | String | 3 | 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 |
| Price | prijs83 | Double | 16 | 4 |
|
|
|
||||||||||
| PriceList | prijslijst | String | 15 | 0 |
|
|
|||||||||||
| Project | projectnr | String | 20 | 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 | 16 | 4 |
|
||||||||||||
| 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 |
| RequestID | RequestID | Number | 10 | 0 |
|
|
|||||||||||
| Resource | res_id | Number | 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 |
| SalesOrderLine | ordreg | Integer | 1 | 0 |
|
||||||||||||
| SalesOrderNumber | ordernr | String | 8 | 0 |
|
|
|||||||||||
| SequenceNumber | volgnr5 | String | 5 | 0 |
|
|
|||||||||||
| SerialNumber | serie_num | String | 22 | 0 |
|
|
|||||||||||
| SMSInvoiceLine | SMSInvoiceLine | GUID | 34 | 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 |
|
34 | 0 | ||||||||||||
| Transportation | vervoer | String | 10 | 0 |
|
|
|||||||||||
| TransShipment | trsshpm_cd | String | 10 | 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 |
|
|
|
||||||||||