MCTE Header

MCTE Header (W7158MCTEHdr)

Column Description
SEQUENCE1 This column is the Key for the table.

This is a line number, it does not have any relationship to other data in GP. Think of this as “each instance” of opening the MCTE window in GP to create and post a transaction. Increment by 1 for each new MCTE transaction.
MCTEType Allowed values are:

  1. Issue
  2. Reverse Issue
  3. Allocate
  4. Reverse Allocate
  5. Scrap
  6. Reverse Scrap

At this time only ISSUE (1) is supported. Any other value will be an error. MCTEType is required.
DATE1 The Document Date of the Pick Document. If left blank the GP User Date will be used.
PSTGDATE The Pick Document Posting Date. If left blank the GP User Date will be used. MCTE will validate that the PSTGDATE is in an open period in both the Inventory and Financial modules in GP.
StrFrom/StrTo fields At this time only StrFrom_1 is used.

These fields will be used to provide the ability to enter the ranges available on the MCTE window:

  • MO Number from/to,
  • Component From/To
  • Issue Site From/To
  • Work Center From/To

Provide the MO Number in StrFrom_1. MO Number is required. MO Number will be validated. It must exist in WO010032 and have MOSTATUS_1 of 3, 6, or 7.
From-Date/TODATE Not used at this time. These fields will be used to provide the Required Date ranges available on the MCTE window.
MCTERestrict This is the Restrict Items To setting on the MCTE window. The options are:

  1. None
  2. Shortages
  3. Lot-Tracked
  4. Serial-Tracked
  5. Alternates
  6. Phantom Components
  7. Show All

At this time the only option supported is 7 (Show All). Always use 7.
BACKFLUSHCB Not used at this time.
PickedBy When the MarkAll flag is TRUE, PickedBy is used to populate the “Picked By” field on each Picklist Line.

When MarkAll is FALSE and components are provided in the MCTEItems table, if the MCTEItems.PickedBy field is blank it will be populated with the MCTEHdr.PickedBy.

This is not required.
PickedDate When the MarkAll flag is TRUE, PickedDate is used to populate the “Date Picked” field on each Picklist Line.

When MarkAll is FALSE and components are provided in the MCTEItems table, if the MCTEItems.PickedDate field is blank it will be populated with the MCTEHdr.PickedDate.

This is not required.
MarkAll TRUE (1) – all items from the picklist will be Issued. Do not populate the MCTEItems or MCTEItemDtl tables. If there is data in these tables it will be reported as an error.

FALSE (0) – you must populate the MCTEItems table, and when using multi-bins/serials/lots you must also populate the MCTEItemDtl table. If there is no data in these tables it will be reported as an error.
STRGA255 Any information here will be added to the Pick Document NOTE.
NOTEINDX Always use 0 (zero).

Processing will set the NOTEINDX and errors will be recorded in a text note in SY03900.
Status Always use 0 (zero).

The first step in processing is to validate the integrated data. The Status will be set to 9999 while this is happening.

If there are any errors the Status will be set to 1.

If the MCTE transaction was successful, Status will be set to 2.

If the process fails (i.e. power loss during integration) records will be left at 9999. These should be set back to zero (0) before restarting the processor.