| Name | Description | Type | Additional information |
|---|---|---|---|
| ID | integer |
None. |
|
| ordernr | string |
None. |
|
| debnr | string |
None. |
|
| fakdebnr | string |
None. |
|
| verzdebnr | string |
None. |
|
| naldebnr | string |
None. |
|
| einddebnr | string |
None. |
|
| refer | string |
None. |
|
| refer1 | string |
None. |
|
| refer2 | string |
None. |
|
| refer3 | string |
None. |
|
| orddat | date |
None. |
|
| afldat | date |
None. |
|
| afl_week | string |
None. |
|
| magcode | string |
None. |
|
| selcode | string |
None. |
|
| kstplcode | string |
None. |
|
| fiattering | string |
None. |
|
| afgehandld | byte |
None. |
|
| nettoprijs | byte |
None. |
|
| inv_in_vv | byte |
None. |
|
| btw_code | string |
None. |
|
| btw_cd_ord | string |
None. |
|
| valcode | string |
None. |
|
| koers | decimal number |
None. |
|
| betcond | string |
None. |
|
| levwijze | string |
None. |
|
| stat_code | string |
None. |
|
| vrachtkost | decimal number |
None. |
|
| orderkost | decimal number |
None. |
|
| order_kort | decimal number |
None. |
|
| colli | string |
None. |
|
| bruto_gew | decimal number |
None. |
|
| netto_gew | decimal number |
None. |
|
| tot_bdr | decimal number |
None. |
|
| user_id | string |
None. |
|
| krgtext | integer |
None. |
|
| industrie | string |
None. |
|
| betaald | byte |
None. |
|
| faknr | string |
None. |
|
| pakbon_nr | string |
None. |
|
| pakbon_dat | date |
None. |
|
| status | string |
None. |
|
| prod_order | string |
None. |
|
| type_prod | string |
None. |
|
| offerte_nr | string |
None. |
|
| iso_taalcd | string |
None. |
|
| iso_taalcd_f | string |
None. |
|
| fakt_code | string |
None. |
|
| vrz_adrcd | string |
None. |
|
| vrz_adrnr | string |
None. |
|
| nal_adrcd | string |
None. |
|
| nal_adrnr | string |
None. |
|
| represent_id | integer |
None. |
|
| eca_type | string |
None. |
|
| cntr_id | string |
None. |
|
| ecaordernr | string |
None. |
|
| notesunid | string |
None. |
|
| productline | string |
None. |
|
| productversion | string |
None. |
|
| productrelease | string |
None. |
|
| int_vrw | string |
None. |
|
| represent_id2 | integer |
None. |
|
| represent_ideca | integer |
None. |
|
| crdnr | string |
None. |
|
| klantn_lev | string |
None. |
|
| calc_meth_pc | string |
None. |
|
| calc_incl_vat | string |
None. |
|
| fakcrdnr | string |
None. |
|
| bdr_vat_ord_val | decimal number |
None. |
|
| bdr_vat_ship_val | decimal number |
None. |
|
| bdr_kb_val | decimal number |
None. |
|
| bdr_disc_val | decimal number |
None. |
|
| bdr_val | decimal number |
None. |
|
| bstwijze | string |
None. |
|
| bdr_ev_val | decimal number |
None. |
|
| bdr_vat_val | decimal number |
None. |
|
| docnumber | string |
None. |
|
| paymentmethod | string |
None. |
|
| projectnr | string |
None. |
|
| ord_debtor_name | string |
None. |
|
| ord_soort | string |
None. |
|
| ord_AddressLine1 | string |
None. |
|
| ord_AddressLine2 | string |
None. |
|
| ord_AddressLine3 | string |
None. |
|
| ord_PostCode | string |
None. |
|
| ord_City | string |
None. |
|
| ord_StateCode | string |
None. |
|
| ord_landcode | string |
None. |
|
| ord_Phone | string |
None. |
|
| ord_Fax | string |
None. |
|
| ord_contactperson | string |
None. |
|
| ord_predcode | string |
None. |
|
| ord_cnt_job_desc | string |
None. |
|
| ord_Initials | string |
None. |
|
| del_debtor_name | string |
None. |
|
| del_AddressLine1 | string |
None. |
|
| del_AddressLine2 | string |
None. |
|
| del_AddressLine3 | string |
None. |
|
| del_PostCode | string |
None. |
|
| del_City | string |
None. |
|
| del_StateCode | string |
None. |
|
| del_landcode | string |
None. |
|
| del_Phone | string |
None. |
|
| del_Fax | string |
None. |
|
| del_contactperson | string |
None. |
|
| del_predcode | string |
None. |
|
| del_cnt_job_desc | string |
None. |
|
| del_Initials | string |
None. |
|
| inv_debtor_name | string |
None. |
|
| inv_AddressLine1 | string |
None. |
|
| inv_AddressLine2 | string |
None. |
|
| inv_AddressLine3 | string |
None. |
|
| inv_PostCode | string |
None. |
|
| inv_City | string |
None. |
|
| inv_StateCode | string |
None. |
|
| inv_landcode | string |
None. |
|
| inv_Phone | string |
None. |
|
| inv_Fax | string |
None. |
|
| inv_contactperson | string |
None. |
|
| inv_predcode | string |
None. |
|
| inv_cnt_job_desc | string |
None. |
|
| inv_Initials | string |
None. |
|
| Approver | integer |
None. |
|
| Approved | date |
None. |
|
| DocumentID | globally unique identifier |
None. |
|
| resulttype | string |
None. |
|
| ServiceCall_ID | globally unique identifier |
None. |
|
| invoice_method | string |
None. |
|
| ord_contactemail | string |
None. |
|
| del_contactemail | string |
None. |
|
| inv_contactemail | string |
None. |
|
| freefield1 | string |
None. |
|
| freefield2 | string |
None. |
|
| freefield3 | string |
None. |
|
| freefield4 | decimal number |
None. |
|
| freefield5 | decimal number |
None. |
|
| Picked | byte |
None. |
|
| ApplyLinkItem | byte |
None. |
|
| del_County | string |
None. |
|
| ConfirmedBy | integer |
None. |
|
| Confirmed | date |
None. |
|
| DueDate | date |
None. |
|
| FulfilmentDateInInvoice | string |
None. |
|
| syscreated | date |
None. |
|
| syscreator | integer |
None. |
|
| sysmodified | date |
None. |
|
| sysmodifier | integer |
None. |
|
| sysguid | globally unique identifier |
None. |
orkrg