| Entity | InvoiceHeader |
| 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 |
| ApplyLinkItem | ApplyLinkItem | Apply environment tax | Boolean | |||||
| Property starting with C | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| CalculateIncludingVAT | CalculateIncludingVAT | Calculate including VAT | String | |||||
| CostCenter | CostCenter | Cost center | String | |||||
| CreditJournal | CreditJournal | Credit journal | String | |||||
| CreditorInvoiceNumber | CreditorInvoiceNumber | Creditor invoice number | String | |||||
| CurrencyCode | Currency Code | Currency Code | String | |||||
| CurrencyRate | CurrencyRate | Currency rate | Double | |||||
| Property starting with D | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| DeliveryAddressLine1 | DeliveryAddressLine1 | Delivery address line1 | String | |||||
| DeliveryAddressLine2 | DeliveryAddressLine2 | Delivery address line2 | String | |||||
| DeliveryAddressLine3 | DeliveryAddressLine3 | Delivery address line3 | String | |||||
| DeliveryCity | DeliveryCity | Delivery city | String | |||||
| DeliveryContactJobDescription | DeliveryContactJobDescription | Delivery contact job description | String | |||||
| DeliveryCountryCode | DeliveryCountryCode | Delivery country code | String | |||||
| DeliveryCountyCode | DeliveryCountyCode | Delivery county code | String | |||||
| DeliveryDate | Delivery Date | Delivery Date | Date | |||||
| DeliveryDebtor | Delivery Debtor | Delivery Debtor | String | |||||
| DeliveryDebtorName | DeliveryDebtorName | Delivery debtor name | String | |||||
| DeliveryFax | DeliveryFax | Delivery fax | String | |||||
| DeliveryInitials | DeliveryInitials | Delivery initials | String | |||||
| DeliveryPhone | DeliveryPhone | Delivery phone | String | |||||
| DeliveryPostCode | DeliveryPostCode | Delivery postcode | String | |||||
| DeliveryStateCode | DeliveryStateCode | Delivery state code | String | |||||
| Description1 | Description1 | Description 1 | String | |||||
| Description2 | Description2 | Description 2 | String | |||||
| Description3 | Description3 | 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 | ExtraItemDescription | Extra item description | String | |||||
| Property starting with F | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| FreeField1 | FreeField1 | Free field 1 | String | |||||
| FreeField2 | FreeField2 | Free field 2 | String | |||||
| FreeField3 | FreeField3 | Free field 3 | String | |||||
| FreeField4 | FreeField4 | Free field 4 | Double | |||||
| FreeField5 | FreeField5 | 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 | GrossWeight | 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 | Number | |||||
| InvoiceCity | InvoiceCity | Invoice city | String | |||||
| InvoiceCode | Invoice code | Invoice code | String |
|
||||
| InvoiceContactJobDescription | InvoiceContactJobDescription | Invoice contact job description | String | |||||
| InvoiceCountryCode | InvoiceCountryCode | Invoice country code | String | |||||
| InvoiceDebtor | Invoice Debtor | Invoice Debtor | String | |||||
| InvoiceDebtorName | InvoiceDebtorName | Invoice debtor name | String | |||||
| InvoiceFax | InvoiceFax | Invoice fax | String | |||||
| InvoiceInitials | InvoiceInitials | Invoice initials | String | |||||
| InvoicePhone | InvoicePhone | Invoice phone | String | |||||
| InvoicePostCode | InvoicePostCode | Invoice post code | String | |||||
| InvoiceStateCode | InvoiceStateCode | Invoice state code | String | |||||
| InvoiceType | Invoice type | Invoice type | String | |||||
| Property starting with N | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| 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 |
| OrderAddressLine1 | OrderAddressLine1 | Order address line 1 | String | |||||
| OrderAddressLine2 | OrderAddressLine2 | Order address line 2 | String | |||||
| OrderAddressLine3 | OrderAddressLine3 | Order address line 3 | String | |||||
| OrderCity | OrderCity | Order city | String | |||||
| OrderContactJobDescription | OrderContactJobDescription | Order contact job description | String | |||||
| OrderCountryCode | OrderCountryCode | Order country code | String | |||||
| OrderDebtor | Order Debtor | Order Debtor | String |
|
||||
| OrderDebtorName | OrderDebtorName | Order debtor name | String | |||||
| OrderFax | OrderFax | Order fax | String | |||||
| OrderInitials | OrderInitials | Order initials | String | |||||
| OrderPhone | OrderPhone | Order phone | String | |||||
| OrderPostCode | OrderPostCode | Order post code | String | |||||
| OrderStateCode | OrderStateCode | Order state code | 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 | |||||
| PaymentCondition | PaymentCondition | Payment condition | String | |||||
| PaymentMethod | PaymentMethod | Payment method | String | |||||
| Project | Project | Project | String | |||||
| Property starting with R | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| Reference | Reference | Reference | String | |||||
| Resource | Resource | 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 | SalesOrderNumber | Sales order number | String | |||||
| SelectionCode | SelectionCode | Selection code | String | |||||
| SequenceNumber | Sequence number | Sequence number | Number | |||||
| ShippingVia | ShippingVia | Shipping via | String | |||||
| Property starting with T | ||||||||
| Name | Caption | Description | Type | Mandatory | Available since release | Introduced by which team | Introduced for which project | Additional remarks |
| TotalAmount | TotalAmount | Total amount | Double | |||||
| TotalAmountExclVAT | TotalAmountExclVAT | Total amount excl VAT | Double | |||||
| TotalVAT | TotalVAT | Total VAT | Double | |||||
| TransactionKey | Transaction key | Transaction key | GUID |
|
||||
| TranscationDate | Transcation Date | Transcation Date | Date | |||||
| 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 |
|
|
|||||||||||
| 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 |
| CalculateIncludingVAT | calc_incl_vat | String | 1 | 0 |
|
|
|||||||||||
| CostCenter | kstplcode | String | 8 | 0 |
|
|
|||||||||||
| CreditJournal | crd_dgbknr | String | 3 | 0 | |||||||||||||
| CreditorInvoiceNumber | crd_faktnr | String | 8 | 0 |
|
||||||||||||
| CurrencyCode | valcode | String | 3 | 0 |
|
||||||||||||
| CurrencyRate | koers | Double | 8 | 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 |
| DeliveryAddressLine1 | del_AddressLine1 | String | 100 | 0 |
|
||||||||||||
| DeliveryAddressLine2 | del_AddressLine2 | String | 100 | 0 |
|
||||||||||||
| DeliveryAddressLine3 | del_AddressLine3 | String | 100 | 0 |
|
||||||||||||
| DeliveryCity | del_City | String | 100 | 0 |
|
||||||||||||
| DeliveryContactJobDescription | del_cnt_job_desc | String | 50 | 0 |
|
||||||||||||
| DeliveryCountryCode | del_landcode | String | 3 | 0 |
|
||||||||||||
| DeliveryCountyCode | del_county | String | 100 | 0 |
|
||||||||||||
| DeliveryDate | afldat | Date | 0 | 0 |
|
||||||||||||
| DeliveryDebtor | verzdebnr | String | 6 | 0 |
|
|
|||||||||||
| DeliveryDebtorName | del_debtor_name | String | 50 | 0 |
|
||||||||||||
| DeliveryFax | del_Fax | String | 50 | 0 |
|
||||||||||||
| DeliveryInitials | del_Initials | String | 10 | 0 |
|
||||||||||||
| DeliveryPhone | del_Phone | String | 50 | 0 |
|
||||||||||||
| DeliveryPostCode | del_PostCode | String | 20 | 0 |
|
||||||||||||
| DeliveryStateCode | del_StateCode | String | 3 | 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 | Number | 10 | 0 | |||||||||||||
| InvoiceCity | inv_City | String | 100 | 0 |
|
||||||||||||
| InvoiceCode | fakt_code | String |
|
3 | 0 |
|
|
|
|||||||||
| InvoiceContactJobDescription | inv_cnt_job_desc | String | 50 | 0 |
|
||||||||||||
| InvoiceCountryCode | inv_landcode | String | 3 | 0 |
|
||||||||||||
| InvoiceDebtor | fakdebnr | String | 6 | 0 |
|
|
|||||||||||
| InvoiceDebtorName | inv_debtor_name | String | 50 | 0 |
|
||||||||||||
| InvoiceFax | inv_Fax | String | 50 | 0 |
|
||||||||||||
| InvoiceInitials | inv_Initials | String | 10 | 0 |
|
||||||||||||
| InvoicePhone | inv_Phone | String | 50 | 0 |
|
||||||||||||
| InvoicePostCode | inv_PostCode | String | 20 | 0 |
|
||||||||||||
| InvoiceStateCode | inv_StateCode | String | 3 | 0 |
|
||||||||||||
| InvoiceType | fak_soort | String | 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 |
| OrderAddressLine1 | ord_AddressLine1 | String | 100 | 0 |
|
||||||||||||
| OrderAddressLine2 | ord_AddressLine2 | String | 100 | 0 |
|
||||||||||||
| OrderAddressLine3 | ord_AddressLine3 | String | 0 | 0 |
|
||||||||||||
| OrderCity | ord_City | String | 100 | 0 |
|
||||||||||||
| OrderContactJobDescription | ord_cnt_job_desc | String | 50 | 0 |
|
||||||||||||
| OrderCountryCode | ord_landcode | String | 3 | 0 |
|
||||||||||||
| OrderDebtor | debnr | String |
|
6 | 0 |
|
|
||||||||||
| OrderDebtorName | ord_debtor_name | String | 50 | 0 |
|
||||||||||||
| OrderFax | ord_Fax | String | 50 | 0 |
|
||||||||||||
| OrderInitials | ord_Initials | String | 10 | 0 |
|
||||||||||||
| OrderPhone | ord_Phone | String | 50 | 0 |
|
||||||||||||
| OrderPostCode | ord_PostCode | String | 20 | 0 |
|
||||||||||||
| OrderStateCode | ord_StateCode | String | 3 | 0 |
|
||||||||||||
| OurReference | faknr | String | 8 | 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 |
|
|
|||||||||||
| PaymentCondition | betcond | String | 2 | 0 |
|
|
|||||||||||
| PaymentMethod | paymentmethod | String | 1 | 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 | 30 | 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 | 0 | 0 |
|
||||||||||||
| SalesOrderNumber | ordernr | String | 8 | 0 |
|
|
|||||||||||
| SelectionCode | selcode | String | 2 | 0 |
|
|
|||||||||||
| SequenceNumber | volgnr5 | Number | 5 | 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 |
|
|
|
||||||||||
| TotalAmountExclVAT | bdr_ev_val | Double | 0 | 2 |
|
|
|
||||||||||
| TotalVAT | bdr_vat_val | Double | 8 | 2 |
|
|
|
||||||||||
| TransactionKey | _TransactionKey | GUID |
|
34 | 0 | ||||||||||||
| TranscationDate | datum | Date | 0 | 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 |
|
|||||||||||