invantive documentation
Forum di supporto InvantiveAccedi / Registrati

OperationResourcesEx: Exact Online Operation Resources

insert update per partition XML

  • Catalogo: ExactOnlineXML
  • Schema: XML
  • Label: Operation Resources

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile recuperare e modificare i dati utilizzando insert e update.

Additional where-clause columns supported:

  • division
  • downloadid
  • type

Codice sorgente dell'API

  • Servizio XML: OperationResources
  • Argomento XML: OperationResources
  • Percorso XML: /

Parametri

Name Tipo di dati Required Default Documentation
division int32 Company code.
Params_DownloadID varchar2 Data subscription token.
Params_Status varchar2 Multi-select; 10: work center, 20: supplier.

Colonne della tabella

Di seguito sono riportate le colonne della tabella OperationResourcesEx. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
DIVISION_CODE varchar2 ID amministrativo Numero univoco interno dell'amministrazione di Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nome dell'amministrazione Name of the Exact Online administration.Not guaranteed to be unique.
ID_ATTR varchar2 ID /eExact/OperationResources/OperationResource/ID
INTERFACE_URL varchar2(4000) URL dell'interfaccia URL utilizzato per collegare questa riga a Exact Online.
ISACTIVE boolean Active /eExact/OperationResources/OperationResource/IsActive/
ISPRIMARY boolean Primary /eExact/OperationResources/OperationResource/IsPrimary/
OPERATION_CODE_ATTR varchar2 Codice operazione /eExact/OperationResources/OperationResource/Operation/code
OPERATION_ID_ATTR varchar2 Operation ID /eExact/OperationResources/OperationResource/Operation/ID
ROWNUM int64 Numero di riga Numero della riga all'interno dei risultati, a partire da 1.
SUPPLIER_CODE_ATTR varchar2 Codice fornitore /eExact/OperationResources/OperationResource/Supplier/code
SUPPLIER_ID_ATTR varchar2 ID fornitore /eExact/OperationResources/OperationResource/Supplier/ID
SUPPLIER_MINIMUMCHARGE number Supplier Minimum Charge /eExact/OperationResources/OperationResource/Supplier/MinimumCharge/
SUPPLIER_PURCHASELEADDAYS number Supplier Purchase Lead Days /eExact/OperationResources/OperationResource/Supplier/PurchaseLeadDays/
SUPPLIER_PURCHASEUNIT varchar2 Supplier Purchase Unit /eExact/OperationResources/OperationResource/Supplier/PurchaseUnit/
SUPPLIER_PURCHASEVATCODE varchar2 Supplier Purchase VAT Code /eExact/OperationResources/OperationResource/Supplier/PurchaseVATCode/
TYPE varchar2 Type /eExact/OperationResources/OperationResource/Type/ 10=Workcenter, 20=Supplier
WORKCENTER_ATTENDEDPERCENTAGE number Workcentre Attended Percentage /eExact/OperationResources/OperationResource/Workcenter/AttendedPercentage/
WORKCENTER_CODE_ATTR varchar2 Codice del centro di lavoro /eExact/OperationResources/OperationResource/Workcenter/code
WORKCENTER_EFFICIENCYPERCENTAGE number Workcentre Efficiency Percentage /eExact/OperationResources/OperationResource/Workcenter/EfficiencyPercentage/
WORKCENTER_ID_ATTR varchar2 Workcentre ID /eExact/OperationResources/OperationResource/Workcenter/ID
WORKCENTER_PLANNEDRUNHOURS number Workcentre Planned Production Run Hours /eExact/OperationResources/OperationResource/Workcenter/PlannedRunHours/
WORKCENTER_PLANNEDSETUPHOURS number Workcentre Planned Setup Hours /eExact/OperationResources/OperationResource/Workcenter/PlannedSetupHours/
WORKCENTER_RUN number Workcentre Production Run /eExact/OperationResources/OperationResource/Workcenter/Run/
WORKCENTER_RUNMETHOD varchar2 Workcentre Production Run Method /eExact/OperationResources/OperationResource/Workcenter/RunMethod/ 10=Fixed hours, 20=Fixed minutes, 25=Fixed days, 30=Hours/Item, 40=Minutes/Item, 50=Seconds/Item, 60=Items/Hour, 70=Items/Minute
WORKCENTER_SETUP number Workcentre Setup /eExact/OperationResources/OperationResource/Workcenter/Setup/
WORKCENTER_SETUPCOUNT number Workcentre Setup Count /eExact/OperationResources/OperationResource/Workcenter/SetupCount/
WORKCENTER_SETUPUNIT varchar2 Workcentre Setup Unit /eExact/OperationResources/OperationResource/Workcenter/SetupUnit/ hh=Hour, mi=Minute, ss=Second

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: