Import/export template >  Module Purchasing >  Import/export template PEO (Subcontract orders)  

Display all Hide all

Use this template to extract subcontract orders.

You can use it to import subcontract orders from any third party solution into your application, or to export subcontract orders from your application.

For imports, you can use this template in Creation or Modification mode. Use this GIMP(1) global variable and assign it one of the following values:

  • GIMP(1) = C: Creation mode
  • GIMP(1) = M: Modification mode

Mandatory fields in the template

GIMP(1) filed: Update code


SCOITM table:
DescriptionField code
Supplier BPRNUM
Receiving sitePRHFCY
ProductITMREF
BOM codeBOMALT
Planned quantityEXTQTY
Subcontract orderSCONUM


SCOHEAD table: Fields of the GIMP(x) type:
DescriptionField code
Order statusx=2 SCOSTA
Order datex=3 ORDDAT
Receipt datex=4 RETDAY
Order sitex=5 POHFCY
MTO networkx=6 MTOREF
Subcontract lead timex=7 SCOLTI

Local menus

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

SCOHEAD [SCO]

Subcontract order

SCOITM [SCI]

Subcontract order

SCOMAT [SCM]

Order sub-contract materials

SCOSRV [SCS]

Order sub-contract services