# Tabel t_tra_ord

[Kennisbank](https://knowledgebase.syntec-it.nl/index.md) › [Syntec Enterprise](https://knowledgebase.syntec-it.nl/enterprise.md) › [Velden](https://knowledgebase.syntec-it.nl/enterprise/velden.md) › t_tra_ord

96 velden en waar hun waarde vandaan kan komen.

Hoort bij de module [Transport](https://knowledgebase.syntec-it.nl/enterprise/transport.md).

## Gekoppelde tabellen

- [`t_tra_ord_block`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_block.md) · 6 velden
- [`t_tra_ord_ext_tra`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_ext_tra.md) · 9 velden
- [`t_tra_ord_img`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_img.md) · 10 velden
- [`t_tra_ord_img_damage_type`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_img_damage_type.md) · 7 velden
- [`t_tra_ord_log`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_log.md) · 8 velden
- [`t_tra_ord_prt_assignment`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_prt_assignment.md) · 9 velden
- [`t_tra_ord_remark`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_remark.md) · 8 velden
- [`t_tra_ord_src`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_src.md) · 8 velden
- [`t_tra_ord_status`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord_status.md) · 9 velden

## Velden van t_tra_ord

| Veld | Naam | Type | Bronnen |
| --- | --- | --- | --- |
| [`a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_bra_id.md) | Merk | integer | 7 |
| [`a_car_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_car_id.md) | Auto | integer | 3 |
| [`a_costlocations_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_costlocations_id.md) | Kostenplaats | integer | 2 |
| [`a_loc_delivery_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_loc_delivery_id.md) | Afleverlocatie | integer | 1 |
| [`a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_mod_id.md) | Model | integer | 8 |
| [`a_ord_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_ord_id.md) | Order ID | integer | 2 |
| [`a_pah_intake_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_pah_intake_id.md) | PAH inname koppeling | integer | 4 |
| [`a_pol_extra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_pol_extra_id.md) | a_pol_extra_id | integer | 1 |
| [`a_rental_intake_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_rental_intake_id.md) | Verhuur inname koppeling | integer | 4 |
| [`a_rental_request_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.a_rental_request_id.md) | Verhuur aanvraag ID | integer | 1 |
| [`approved`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.approved.md) | Goedgekeurd | boolean | 1 |
| [`as_wo_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.as_wo_id.md) | Werkorder | integer | 0 |
| [`car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.car_description.md) | Auto omschrijving | text | 6 |
| [`chassisnr`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.chassisnr.md) | Chassisnr | text | 6 |
| [`completed`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.completed.md) | Afgeleverd | boolean | 4 |
| [`created`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.created.md) | Aangelegd | timestamp | 2 |
| [`decline_remarks`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.decline_remarks.md) | Afwijzingsopmerking | text | 0 |
| [`delivery_a_loc_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_a_loc_id.md) | Aflever locatie naam | integer | 1 |
| [`delivery_city`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_city.md) | Aflever plaats | text | 5 |
| [`delivery_contact`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_contact.md) | Aflever contactpersoon | text | 5 |
| [`delivery_contact_email`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_contact_email.md) | Aflever contact e-mail | text | 2 |
| [`delivery_contact_mail`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_contact_mail.md) | Aflever contact emailen | boolean | 1 |
| [`delivery_contact_phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_contact_phone.md) | Aflever contactpersoon telefoon | text | 5 |
| [`delivery_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_customer.md) | Afleveren klantnaam | text | 5 |
| [`delivery_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_date.md) | Aflever datum | date | 6 |
| [`delivery_end_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_end_time.md) | Aflever eind tijd | time | 3 |
| [`delivery_houseno`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_houseno.md) | Aflever huisnr | text | 5 |
| [`delivery_latitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_latitude.md) | Aflever latitude | decimal | 2 |
| [`delivery_location`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_location.md) | Aflever locatie | text | 5 |
| [`delivery_longitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_longitude.md) | Aflever longitude | decimal | 2 |
| [`delivery_s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_s_est_id.md) | Aflever vestiging | integer | 6 |
| [`delivery_start_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_start_time.md) | Aflever start tijd | time | 3 |
| [`delivery_street`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_street.md) | Aflever straat | text | 5 |
| [`delivery_whole_day`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_whole_day.md) | Aflever hele dag | boolean | 5 |
| [`delivery_zipcode`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.delivery_zipcode.md) | Aflever postcode | text | 5 |
| [`description`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.description.md) | description |  (niet in de tabeldefinitie) | 1 |
| [`estimated_kms`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.estimated_kms.md) | Kms. | decimal | 2 |
| [`estimated_min`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.estimated_min.md) | Tijd (min) | integer | 2 |
| [`explanation_needed`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.explanation_needed.md) | Uitleg nodig? | boolean | 1 |
| [`guid`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.guid.md) | Guid | text | 2 |
| [`id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.id.md) | Id | integer | 0 |
| [`is_on_truck`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.is_on_truck.md) | Op truck geladen | boolean | 1 |
| [`komnummer`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.komnummer.md) | Komummer | text | 7 |
| [`licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.licenseplate.md) | Kenteken | text | 8 |
| [`licenseplate_retour`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.licenseplate_retour.md) | licenseplate_retour | text | 2 |
| [`mileage`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.mileage.md) | KM-stand | integer | 1 |
| [`modified`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.modified.md) | Gemodificeerd | timestamp | 2 |
| [`order_nr_ext`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.order_nr_ext.md) | order_nr_ext | text | 1 |
| [`order_nr_vsb`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.order_nr_vsb.md) | VSB-nummer | integer | 2 |
| [`pickup_a_loc_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_a_loc_id.md) | Ophaal locatie naam | integer | 2 |
| [`pickup_city`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_city.md) | Ophaal plaats | text | 6 |
| [`pickup_contact`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_contact.md) | Ophaal contactpersoon | text | 6 |
| [`pickup_contact_email`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_contact_email.md) | Ophaal contact e-mail | text | 2 |
| [`pickup_contact_mail`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_contact_mail.md) | Ophaal contact e-mailen | boolean | 1 |
| [`pickup_contact_phone`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_contact_phone.md) | Ophaal contactpersoon telefoon | text | 6 |
| [`pickup_customer`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_customer.md) | Ophalen klantnaam | text | 6 |
| [`pickup_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_date.md) | Ophaal datum | date | 8 |
| [`pickup_date_max`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_date_max.md) | Ophaal datum (Max) | date | 6 |
| [`pickup_delivery_prio`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_delivery_prio.md) | pickup_delivery_prio | text | 1 |
| [`pickup_end_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_end_time.md) | Ophaal eind tijd | time | 4 |
| [`pickup_houseno`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_houseno.md) | Ophaal huisnr | text | 6 |
| [`pickup_latitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_latitude.md) | Ophaal latitude | decimal | 3 |
| [`pickup_location`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_location.md) | Ophaal locatie | text | 6 |
| [`pickup_longitude`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_longitude.md) | Ophaal longitude | decimal | 3 |
| [`pickup_s_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_s_est_id.md) | Ophaal vestiging | integer | 7 |
| [`pickup_start_time`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_start_time.md) | Ophaal start tijd | time | 4 |
| [`pickup_street`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_street.md) | Ophaal straat | text | 6 |
| [`pickup_whole_day`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_whole_day.md) | Ophaal hele dag | boolean | 6 |
| [`pickup_zipcode`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.pickup_zipcode.md) | Ophaal postcode | text | 6 |
| [`rental_car_description`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.rental_car_description.md) | Omscrhijving | text | 2 |
| [`rental_car_licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.rental_car_licenseplate.md) | Kenteken | text | 2 |
| [`rental_car_pickup_est_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.rental_car_pickup_est_id.md) | Ophalen op vestiging | integer | 1 |
| [`retour_a_bra_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.retour_a_bra_id.md) | Retour merk | integer | 1 |
| [`retour_a_mod_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.retour_a_mod_id.md) | Retour model | integer | 1 |
| [`retour_brand`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.retour_brand.md) | Retour merk | text | 1 |
| [`retour_licenseplate`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.retour_licenseplate.md) | Retour kenteken | text | 1 |
| [`retour_model`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.retour_model.md) | Retour model | text | 1 |
| [`road_transp_not_alllowed`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.road_transp_not_alllowed.md) | road_transp_not_alllowed | boolean | 0 |
| [`s_prt_approved_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.s_prt_approved_id.md) | Goedgekeurd door | integer | 1 |
| [`s_prt_completed_date`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.s_prt_completed_date.md) | Afgeleverd datum | timestamp | 6 |
| [`s_prt_completed_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.s_prt_completed_id.md) | Afgeleverd door | integer | 6 |
| [`s_prt_created_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.s_prt_created_id.md) | Aangelegd door | integer | 5 |
| [`s_prt_transporter_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.s_prt_transporter_id.md) | Transporteur | integer | 4 |
| [`send_cc_s_prt_created`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.send_cc_s_prt_created.md) | Ontv.kopie mails | boolean | 1 |
| [`sorter`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.sorter.md) | Dag volgorde | integer | 1 |
| [`status`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.status.md) | Status | integer | 3 |
| [`t_tra_accountability_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_accountability_id.md) | t_tra_accountability_id | integer | 1 |
| [`t_tra_car_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_car_typ_id.md) | Soort auto transport | integer | 1 |
| [`t_tra_cost_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_cost_id.md) | Transport kosten voorkeur | integer | 3 |
| [`t_tra_ord_parent_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_ord_parent_id.md) | t_tra_ord_parent_id | integer | 0 |
| [`t_tra_ord_status_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_ord_status_id.md) | Transport status | integer | 5 |
| [`t_tra_typ_id`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.t_tra_typ_id.md) | Type | integer | 5 |
| [`transport_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.transport_cost.md) | Transport kosten | decimal | 3 |
| [`urgent`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.urgent.md) | Spoed | boolean | 4 |
| [`urgent_surplus_cost`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.urgent_surplus_cost.md) | Toeslag spoed | decimal | 4 |
| [`vehicle_mass`](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord.vehicle_mass.md) | Massa ledig voertuig | integer | 4 |

---

Kennisbank Syntec-IT · [Deze pagina op de website](https://knowledgebase.syntec-it.nl/enterprise/velden/t_tra_ord) · [Overzicht voor AI-clients](https://knowledgebase.syntec-it.nl/llms.txt)
