invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

CompanyCurrentSchedules : Nmbrs Company Current Schedule

read only per partition XML

  • Catalogue : Nmbrs
  • Schéma : Company
  • Libellé : Company Current Schedule

Les données de cette table sont partitionnées en fonction de la valeur de la colonne COMPANY_CODE.

Permet uniquement de récupérer des données.

Source de l'API

  • Service XML : CompanyService.asmx
  • Rubrique XML : Schedule_GetCurrent
  • Chemin XML : /ncs:Schedule_GetCurrentResult

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 48

Le résultat peut être mis en cache côté client.

Colonnes de table

Les colonnes de la table CompanyCurrentSchedules sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
COMPANY_CODE int64 ID de l'entreprise
FULLTIMESCHEDULEFOURHOURSFRIDAY decimal Annexe 4, vendredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursFriday
FULLTIMESCHEDULEFOURHOURSFRIDAY2 decimal Annexe 4, vendredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursFriday2
FULLTIMESCHEDULEFOURHOURSMONDAY decimal Annexe 4 Lundi 1 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursMonday
FULLTIMESCHEDULEFOURHOURSMONDAY2 decimal Annexe 4 Lundi 2 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursMonday2
FULLTIMESCHEDULEFOURHOURSSATURDAY decimal Annexe 4, samedi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSaturday
FULLTIMESCHEDULEFOURHOURSSATURDAY2 decimal Annexe 4, samedi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncses:HoursSaturday2
FULLTIMESCHEDULEFOURHOURSSUNDAY decimal Annexe 4 – Dimanche 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSunday
FULLTIMESCHEDULEFOURHOURSSUNDAY2 decimal Annexe 4 – Dimanche 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursSunday2
FULLTIMESCHEDULEFOURHOURSTHURSDAY decimal Annexe 4, jeudi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursThursday
FULLTIMESCHEDULEFOURHOURSTHURSDAY2 decimal Annexe 4, jeudi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursThursday2
FULLTIMESCHEDULEFOURHOURSTUESDAY decimal Annexe 4, mardi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursTuesday
FULLTIMESCHEDULEFOURHOURSTUESDAY2 decimal Annexe 4, mardi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursTuesday2
FULLTIMESCHEDULEFOURHOURSWEDNESDAY decimal Annexe 4, mercredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursWednesday
FULLTIMESCHEDULEFOURHOURSWEDNESDAY2 decimal Annexe 4, mercredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:HoursWednesday2
FULLTIMESCHEDULEFOURSCHEDULECALCMETHOD varchar2 Annexe 4 : Méthode de calcul /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleFour/ncs:ScheduleCalcMethod
FULLTIMESCHEDULEONEHOURSFRIDAY decimal Annexe 1, vendredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursFriday
FULLTIMESCHEDULEONEHOURSFRIDAY2 decimal Annexe 1, vendredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursFriday2
FULLTIMESCHEDULEONEHOURSMONDAY decimal Annexe 1 Lundi 1 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursMonday
FULLTIMESCHEDULEONEHOURSMONDAY2 decimal Annexe 1 Lundi 2 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursMonday2
FULLTIMESCHEDULEONEHOURSSATURDAY decimal Annexe 1, samedi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSaturday
FULLTIMESCHEDULEONEHOURSSATURDAY2 decimal Annexe 1, samedi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSaturday2
FULLTIMESCHEDULEONEHOURSSUNDAY decimal Annexe 1 – Dimanche 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSunday
FULLTIMESCHEDULEONEHOURSSUNDAY2 decimal Annexe 1 – Dimanche 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursSunday2
FULLTIMESCHEDULEONEHOURSTHURSDAY decimal Annexe 1, jeudi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursThursday
FULLTIMESCHEDULEONEHOURSTHURSDAY2 decimal Annexe 1, jeudi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursThursday2
FULLTIMESCHEDULEONEHOURSTUESDAY decimal Annexe 1, mardi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursTuesday
FULLTIMESCHEDULEONEHOURSTUESDAY2 decimal Annexe 1, mardi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursTuesday2
FULLTIMESCHEDULEONEHOURSWEDNESDAY decimal Annexe 1, mercredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursWednesday
FULLTIMESCHEDULEONEHOURSWEDNESDAY2 decimal Annexe 1, mercredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:HoursWednesday2
FULLTIMESCHEDULEONESCHEDULECALCMETHOD varchar2 Annexe 1 : Méthode de calcul /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FulltimeScheduleOne/ncs:ScheduleCalcMethod
FULLTIMESCHEDULETHREEHOURSFRIDAY decimal Annexe 3, vendredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursFriday
FULLTIMESCHEDULETHREEHOURSFRIDAY2 decimal Annexe 3, vendredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursFriday2
FULLTIMESCHEDULETHREEHOURSMONDAY decimal Annexe 3 Lundi 1 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursMonday
FULLTIMESCHEDULETHREEHOURSMONDAY2 decimal Annexe 3 Lundi 2 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursMonday2
FULLTIMESCHEDULETHREEHOURSSATURDAY decimal Annexe 3, samedi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSaturday
FULLTIMESCHEDULETHREEHOURSSATURDAY2 decimal Annexe 3, samedi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSaturday2
FULLTIMESCHEDULETHREEHOURSSUNDAY decimal Annexe 3 – Dimanche 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSunday
FULLTIMESCHEDULETHREEHOURSSUNDAY2 decimal Annexe 3 – Dimanche 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursSunday2
FULLTIMESCHEDULETHREEHOURSTHURSDAY decimal Annexe 3, jeudi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursThursday
FULLTIMESCHEDULETHREEHOURSTHURSDAY2 decimal Annexe 3, jeudi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursThursday2
FULLTIMESCHEDULETHREEHOURSTUESDAY decimal Annexe 3, mardi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursTuesday
FULLTIMESCHEDULETHREEHOURSTUESDAY2 decimal Annexe 3, mardi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursTuesday2
FULLTIMESCHEDULETHREEHOURSWEDNESDAY decimal Annexe 3, mercredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursWednesday
FULLTIMESCHEDULETHREEHOURSWEDNESDAY2 decimal Annexe 3, mercredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:HoursWednesday2
FULLTIMESCHEDULETHREESCHEDULECALCMETHOD varchar2 Annexe 3 : Méthode de calcul /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleThree/ncs:ScheduleCalcMethod
FULLTIMESCHEDULETWOHOURSFRIDAY decimal Annexe 2, vendredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursFriday
FULLTIMESCHEDULETWOHOURSFRIDAY2 decimal Annexe 2, vendredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursFriday2
FULLTIMESCHEDULETWOHOURSMONDAY decimal Annexe 2 Lundi 1 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursMonday
FULLTIMESCHEDULETWOHOURSMONDAY2 decimal Annexe 2 Lundi 2 (Horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursMonday2
FULLTIMESCHEDULETWOHOURSSATURDAY decimal Annexe 2, samedi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSaturday
FULLTIMESCHEDULETWOHOURSSATURDAY2 decimal Annexe 2, samedi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSaturday2
FULLTIMESCHEDULETWOHOURSSUNDAY decimal Annexe 2 – Dimanche 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSunday
FULLTIMESCHEDULETWOHOURSSUNDAY2 decimal Annexe 2 – Dimanche 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursSunday2
FULLTIMESCHEDULETWOHOURSTHURSDAY decimal Annexe 2, jeudi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursThursday
FULLTIMESCHEDULETWOHOURSTHURSDAY2 decimal Annexe 2, jeudi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursThursday2
FULLTIMESCHEDULETWOHOURSTUESDAY decimal Annexe 2, mardi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursTuesday
FULLTIMESCHEDULETWOHOURSTUESDAY2 decimal Annexe 2, mardi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursTuesday2
FULLTIMESCHEDULETWOHOURSWEDNESDAY decimal Annexe 2, mercredi 1 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursWednesday
FULLTIMESCHEDULETWOHOURSWEDNESDAY2 decimal Annexe 2, mercredi 2 (horaires) /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:HoursWednesday2
FULLTIMESCHEDULETWOSCHEDULECALCMETHOD varchar2 Annexe 2 : Méthode de calcul /soap:Envelope/soap:Body/ncs:Schedule_GetCurrentResponse/ncs:Schedule_GetCurrentResult/ncs:FullTimeScheduleTwo/ncs:ScheduleCalcMethod

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :