| Name | Description | Type | Additional information |
|---|---|---|---|
| ID | integer |
None. |
|
| faknr | string |
None. |
|
| fakdat | date |
None. |
|
| dagbknr | string |
None. |
|
| debnr | string |
None. |
|
| fakdebnr | string |
None. |
|
| einddebnr | string |
None. |
|
| refer | string |
None. |
|
| refer1 | string |
None. |
|
| refer2 | string |
None. |
|
| refer3 | string |
None. |
|
| ordernr | string |
None. |
|
| orddat | date |
None. |
|
| afldat | date |
None. |
|
| magcode | string |
None. |
|
| ex_artcode | string |
None. |
|
| inv_in_vv | byte |
None. |
|
| valcode | string |
None. |
|
| koers | decimal number |
None. |
|
| orddeb | string |
None. |
|
| selcode | string |
None. |
|
| nettoprijs | byte |
None. |
|
| betcond | string |
None. |
|
| levwijze | string |
None. |
|
| vrachtkost | decimal number |
None. |
|
| orderkost | decimal number |
None. |
|
| kstplcode | string |
None. |
|
| fakt_kort | decimal number |
None. |
|
| user_id | string |
None. |
|
| colli | string |
None. |
|
| bruto_gew | decimal number |
None. |
|
| netto_gew | decimal number |
None. |
|
| bkjrcode | integer |
None. |
|
| btw_code | string |
None. |
|
| pakbon_nr | string |
None. |
|
| tot_bdr | decimal number |
None. |
|
| fak_soort | string |
None. |
|
| iso_taalcd | string |
None. |
|
| btw_cd_ord | string |
None. |
|
| pakbon_dat | date |
None. |
|
| fak_adrnr | string |
None. |
|
| ordkost_vv | decimal number |
None. |
|
| vrachtk_vv | decimal number |
None. |
|
| tot_bdr_vv | decimal number |
None. |
|
| tot_bdrb | decimal number |
None. |
|
| tot_bdrbvv | decimal number |
None. |
|
| afl_week | string |
None. |
|
| routecode | string |
None. |
|
| represent_id | integer |
None. |
|
| calc_meth_pc | string |
None. |
|
| calc_incl_vat | 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. |
|
| docnumber | string |
None. |
|
| projectnr | string |
None. |
|
| paymentmethod | string |
None. |
|
| syscreated | date |
None. |
|
| DocAttachmentID | globally unique identifier |
None. |
|
| ord_debtor_name | 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. |
|
| CashRegisterAccount | string |
None. |
|
| inv_contactemail | string |
None. |
|
| freefield1 | string |
None. |
|
| freefield2 | string |
None. |
|
| freefield3 | string |
None. |
|
| freefield4 | decimal number |
None. |
|
| freefield5 | decimal number |
None. |
|
| TNTPostAmount | decimal number |
None. |
|
| TNTPostNrOfPages | string |
None. |
|
| TNTPostQtySent | string |
None. |
|
| TNTPostUserName | integer |
None. |
|
| TNTPostDateSent | date |
None. |
|
| TNTPostSession | integer |
None. |
|
| GoldenTaxInvoiceNumber | string |
None. |
|
| ExternalNumber | string |
None. |
|
| Division | integer |
None. |
|
| OfficialExchangeRate | decimal number |
None. |
|
| ApplyLinkItem | byte |
None. |
|
| del_County | string |
None. |
|
| AvalaraIsReconciled | boolean |
None. |
|
| UseAvalaraTaxation | boolean |
None. |
|
| IsEDI | boolean |
None. |
|
| Printed | boolean |
None. |
|
| DueDate | date |
None. |
|
| CIPaymentCondition | string |
None. |
|
| ExcludePrinting | boolean |
None. |
|
| IsUseAdditionalFields | boolean |
None. |
|
| AdditionalStatus | string |
None. |
|
| VATNumber | string |
None. |
|
| eSignature | string |
None. |
|
| syscreator | integer |
None. |
|
| sysmodified | date |
None. |
|
| sysmodifier | integer |
None. |
|
| sysguid | globally unique identifier |
None. |
|
| timestamp | Collection of byte |
None. |
|
| CSPickITCWStatusCWDB | string |
None. |
frhkrg