ShopOrderRoutingStepPlansAvailableToWork: Exact Online Shop Order Routing Step Plans Available to Work
read only per partition REST
- Catalogue :
ExactOnlineREST - Schéma :
Manufacturing - Clés primaires :
RoutingStep - Label: Shop Order Routing Step Plans Available to Work
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet uniquement de récupérer des données.
Source de l'API
- Point de terminaison :
/api/v1/{division}/read/manufacturing/ShopOrderRoutingStepPlansAvailableToWork - Métadonnées :
/api/v1/{division}/read/manufacturing/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |
Le résultat peut être mis en cache côté client.
Paramètres
| Name | Type de données | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
ID of the division to retrieve data for. | ||
employee |
guid |
|||
employee |
int32 |
|||
end |
datetime |
|||
is |
char |
|||
operations |
varchar2 |
|||
start |
datetime |
|||
workcenters |
varchar2 |
Colonnes de table
Les colonnes de la table ShopOrderRoutingStepPlansAvailableToWork 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 |
|---|---|---|---|---|---|
Customer |
varchar2 |
Code client | filters on the platform, writable | ||
Customer |
int32 |
Nombre de clients | filters on the platform, writable | ||
Customer |
varchar2 |
Nom du client | filters on the platform, writable | ||
Data |
int16 |
itgen_eol_datatype | filters on the platform, writable | ||
Date |
int32 |
itgen_eol_dateascendingorder | filters on the platform, writable | ||
Date |
int32 |
itgen_eol_datedescendingorder | filters on the platform, writable | ||
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nom du titulaire de l'abonnement | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
Extra |
varchar2 |
Description supplémentaire | filters on the platform, writable | ||
Is |
char |
Les fractions sont-elles autorisées sur cet article ? | filters on the platform, writable | ||
Is |
char |
Est sorti | filters on the platform, writable | ||
Is |
char |
itgen_eol_isrunoperationfinished | filters on the platform, writable | ||
Is |
char |
itgen_eol_issetupoperationfinished | filters on the platform, writable | ||
Item |
guid |
Item | filters on the platform, writable | ||
Item |
varchar2 |
Code de l'article | filters on the platform, writable | ||
Item |
int32 |
itgen_eol_itemcodeascendingorder | filters on the platform, writable | ||
Item |
int32 |
itgen_eol_itemcodedescendingorder | filters on the platform, writable | ||
Item |
varchar2 |
Description de l’article | filters on the platform, writable | ||
Item |
guid |
Version de l'élément | filters on the platform, writable | ||
Item |
varchar2 |
Remarques sur la version de l'élément | filters on the platform, writable | ||
Line |
int32 |
Numéro de ligne | filters on the platform, writable | ||
Mode |
int32 |
Mode | filters on the platform, writable | ||
Notes |
varchar2 |
Notes | filters on the platform, writable | ||
Operation |
guid |
Operation | filters on the platform, writable | ||
Operation |
varchar2 |
Code d'opération | filters on the platform, writable | ||
Picture |
varchar2 |
itgen_eol_picturethumbnailpath | filters on the platform, writable | ||
Planned |
datetime |
Date prévue | filters on the platform, writable | ||
Planned |
double |
Quantité prévue | filters on the platform, writable | ||
Planned |
double |
Heures prévues pour la mise en place | filters on the platform, writable | ||
Priority |
int32 |
Priority | filters on the platform, writable | ||
Priority |
int32 |
itgen_eol_prioritydescendingorder | filters on the platform, writable | ||
Project |
guid |
Project | filters on the platform, writable | ||
Project |
varchar2 |
Code de projet | filters on the platform, writable | ||
Project |
varchar2 |
Description du projet | filters on the platform, writable | ||
Quantity |
double |
Quantité réalisée | filters on the platform, writable | ||
Routing |
guid |
Étape de routage | filters on the platform, writable | ||
Routing |
varchar2 |
itgen_eol_routingstepdescription | filters on the platform, writable | ||
Routing |
varchar2 |
itgen_eol_routingsteprealizationnotes | filters on the platform, writable | ||
Routing |
int32 |
Statut de l'étape de routage | filters on the platform, writable | ||
Routing |
varchar2 |
itgen_eol_routingstepstatusdescription | filters on the platform, writable | ||
Routing |
int32 |
Type d'étape de routage | filters on the platform, writable | ||
Run |
datetime |
Heure de début de la course | filters on the platform, writable | ||
Run |
int32 |
État de l'exécution | filters on the platform, writable | ||
Run |
guid |
itgen_eol_runtimedtimetransaction | filters on the platform, writable | ||
Sales |
int32 |
Nombre de commandes client | filters on the platform, writable | ||
Sales |
int32 |
Numéro de ligne de commande client | filters on the platform, writable | ||
Sales |
int32 |
Numéro de commande client | filters on the platform, writable | ||
Setup |
double |
itgen_eol_setuppercentcomplete | filters on the platform, writable | ||
Setup |
datetime |
Définir l'heure de début | filters on the platform, writable | ||
Setup |
int32 |
État de la configuration | filters on the platform, writable | ||
Setup |
guid |
itgen_eol_setuptimedtimetransaction | filters on the platform, writable | ||
Shop |
guid |
Commande d'atelier | filters on the platform, writable | ||
Shop |
varchar2 |
itgen_eol_shoporderdescription | filters on the platform, writable | ||
Shop |
int32 |
Numéro de commande | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordernumberascendingorder | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordernumberdescendingorder | filters on the platform, writable | ||
Shop |
int32 |
Statut de la commande | filters on the platform, writable | ||
Unit |
varchar2 |
Unit | filters on the platform, writable | ||
Warehouse |
guid |
Warehouse | filters on the platform, writable | ||
Workcenter |
guid |
Workcentre | filters on the platform, writable | ||
Workcenter |
varchar2 |
Code du centre de travail | filters on the platform, writable |
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 :