Skip to main content
Version: 2.2.2

IPREC - Receiving import

This import template allows insertion/editing/sending to next step/deletion for:

  • Receiving data

For the insertion of each one of these items, the standard documented below must be followed.

Insert/edit/delete receiving

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
34 - Code of the SoftExpert Inspection component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
3 - Add;
4 - Edit;
5 - Delete.
NMFIELD01TEXT255Inspection form ID #
NMFIELD02TEXT255Customer company ID.
NMFIELD03TEXT255Lot number
NMFIELD04TEXT255Invoice number
NMFIELD05TEXT255Invoice date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD06TEXT255Order number
NMFIELD07TEXT255Order date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD08TEXT255Request order number
NMFIELD09TEXT255Request order date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD10TEXT255Production order number
NMFIELD11TEXT255Production order date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD12TEXT255Estimated date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD13TEXT255Actual date
Patterns for date-type data input:
dd-mm-yyyy;
yyyy-mm-dd;
NMFIELD14XTEXT255Expected amount
NMFIELD15XTEXT255Actual quantity
NMFIELD16TEXT255Estimated cost
NMFIELD17TEXT255Actual cost
NMFIELD18X⁴TEXT255Inspection flow ID #
NMFIELD19TEXT255Send to the next step (only for editing):
1 - Send to next step;
2 - Do not send to next step.
NMFIELD20X⁵TEXT255Workflow instance ID #
NMFIELD21X⁶TEXT255Receiving ID # (number)
NMFIELD22TEXT255Estimated time
NMFIELD23TEXT255Actual time
NMFIELD24TEXT255Description
info

Note:

  • X¹ - Required for insertion; disregarded for other actions.
  • X² - Required for inspections of Supplies, Services, and External finished products; ignored for other object types.
  • X³ - Required, non-required or ignored, depending on the type configurations for the defined inspection form.
  • X⁴ - Required if the "Allow editing flow during receiving" option is checked on the inspection form, or ignored otherwise.
  • X⁵ - Required if the inspection object is a Workflow process instance, or ignored otherwise.
  • X⁶ - Required for editing and deletion.