Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WORDER


                              WORDER FILE

                           Work Order Header

The Work Order Header file contains the primary information associated with
producing a finished good.

REFERENCED BY

IC01.1    WHD2.1    IC02.1

UPDATED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
WH20.7    WHD3.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WOR-COMPANY            Numeric 4
Element: Company       This field contains the company number,
                       as defined in the Inventory Control
                       system.

WOR-LOCATION           Alpha 5
Element: Location      This field contains a valid stock
                       location within the company inventory.
                       It is also the production facility
                       where finished goods are produced.

WOR-WORK-ORDER         Numeric 8
Element: Work Order    This identifies the work order and may
                       be automatically assigned or manually
                       assigned, depending on the option
                       defined for each production (inventory)
                       location.

WOR-WORK-ORDER-SUF     Numeric 2
Element: Work Order SufThis will normally be zero for a work
                       order.  If you chose to split a work
                       order so the completed part of the
                       finished goods can be available for
                       allocation, the work order created for
                       the remaining quantity will have a
                       non-zero value in this field.


WOR-ITEM               Alpha 32
Element: Item          This field contains the item identifier
                       of the finished good produced for the
                       work order, as defined in the Inventory
                       Control system.

WOR-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date    This is the production start date for
                       the work order.

WOR-END-DATE           Numeric 8  (yyyymmdd)
Element: End Date      This is the production end date for the
                       work order.

WOR-EXP-DELIV-DT       Numeric 8  (yyyymmdd)
Element: Date          This is the date needed for the
                       finished good.

WOR-STATUS             Numeric 1
Element: Status        The work order statuses indicate the
                       progression of the work order through
                       pre and post production stages.
                       1 = Unreleased
                       2 = Released
                       3 = Exploded
                       4 = In Production
                       8 = Canceled
                       9 = Completed

WOR-PICK-FDBK-STAT     Numeric 1
Element: Pick Fdbk StatEach picking feedback status indicates
                       a stage within the picking feedback
                       process.
                       0 = Picking Fdbk Not Started
                       1 = Picking Fdbk In Process
                       2 = Picking Fdbk Finished
                       3 = Picking Fdbk Complete

WOR-PROD-FDBK-STAT     Numeric 1
Element: Prod Fdbk StatEach production feedback status
                       indicates a stage within the production
                       feedback process for the work order.
                       0 = Production Fdbk Not Started
                       1 = Production Fdbk In Process
                       2 = Production Fdbk Finished
                       3 = Production Fdbk Completed

WOR-WALK-THRU-REQ      Alpha 1
Element: Req Comments  This field indicates that a transaction
                       line is out of balance.  For example, if
                       lot, bin, or serial number quantities do
                       not equal the transaction quantity,
                       select the WalkThru form action to
                       balance the transaction quantities.

WOR-HOLD-CODE          Alpha 4
Element: Hold Code     This is the offsite hold code which
                       indicates if the work order is currently
                       sent offsite during the production
                       process to be performed by a vendor.

WOR-PRINTED-FL         Alpha 1
Element: Printed Fl    This flag indicates if this work order
                       has been printed by the work order print
                       program.
                       Y = Yes
                       " " = No

WOR-PRTED-PL-FL        Alpha 1
Element: Prted Pl Fl   This flag indicates if this work order
                       has been printed by the work order pick
                       list program.
                       Y = Yes
                       " " = No

WOR-OPR-CODE           Alpha 10  (Lower Case)
Element: Opr Code      This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

WOR-SYSTEM-CD          Alpha 2                                   BL120   BL122
Element: System Cd     This field indicates on what system the   BL130   BL20.1
                       transaction originated.                   BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

WOR-DOC-NBR-NUM        Numeric 10                                BL120   BL122
Element: Doc Nbr Num   This is the order or requisition number   BL130   BL20.1
                       when the work order is for a specific     BL20.3  BL21.2
                       order or requisition.                     BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

WOR-LINE-NBR           Numeric 6                                 BL120   BL122
Element: Line Nbr      This field contains the line number of    BL130   BL20.1
                       the order or requisition when the work    BL20.3  BL21.2
                       order is for a specific order or          BL21.5  BL29.1
                       requisition.                              BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 WH20.7

WOR-ORIG-WORK-ORDR     Numeric 8
Element: Work Order    This is the original work order that is
                       being reversed by this work order. This
                       field will only have a value on reverse
                       work orders.

WOR-ORIG-WO-SUF        Numeric 2
Element: Work Order SufThis is the suffix of original work
                       order that is being reversed by this
                       work order. This field will only have a
                       value on reverse work orders.

WOR-PLAN-QTY           Signed 13.4
Element: Quantity      This field contains the planned
                       quantity for the finished good being
                       produced by this work order.

WOR-ACTUAL-QTY         Signed 13.4
Element: Quantity      This field contains the actual quantity
                       of the finished good produced by this
                       work order.

WOR-DETAIL-QTY         Signed 13.4
Element: Quantity      This field shows the total quantity of
                       details defined for a detail tracked
                       item.  It is matched against the line
                       quantity field to determine if details
                       are in balance.

WOR-SHRINK-QTY         Signed 13.4
Element: Quantity      Shrinkage quantity is the difference
                       between the total of the components and
                       the total of the finished good when all
                       components are in the same unit of
                       measure as the finished good.  This is a
                       quantity that may be entered at
                       production feedback and is for
                       information only.

WOR-EST-COMP-COST      Signed 18.5
Element: Intl Cost     This is the total of the estimated
                       costs for 'C' type components that will
                       used to produce the finished goods.

WOR-ACT-COMP-COST      Signed 18.5
Element: Intl Cost     This is the total of actual component
                       inventory costs for 'C' type components
                       that were used (not wasted) to produce
                       the finished goods.

WOR-EST-PACK-COST      Signed 18.5
Element: Intl Cost     This is the total of the estimated cost
                       for packaging components that will be
                       used for the finished goods.

WOR-ACT-PACK-COST      Signed 18.5
Element: Intl Cost     This is the total of the actual costs
                       for packaging components that were used
                       for the finished goods.

WOR-EST-BRDN-COST      Signed 18.2
Element: Intl Amt      This is the total estimated burden cost
                       related to producing the finished goods.

WOR-ACT-BRDN-COST      Signed 18.2
Element: Intl Amt      This is the total actual burden cost
                       related to producing the finished goods.

WOR-FGV-AMOUNT         Signed 18.5
Element: Intl Cost     The finished good variance amount is
                       used only on reverse work orders. It is
                       used when the cost of the finished good
                       returned from inventory is not the same
                       as the cost of producing the finished
                       good on  the original work order.  This
                       field will contain the difference, which
                       will post to the variance account set up
                       for the finished good.

WOR-VENDOR             Alpha 9  (Right Justified)
Element: Vendor        This is the identification code of the
                       vendor that is currently doing all or
                       part of the production process while the
                       work order is on offsite hold.

WOR-OFFSITE-DATE       Numeric 8  (yyyymmdd)
Element: Date          This is the date that the work order
                       was sent offsite if it is currently on
                       offsite hold.

WOR-RETURNED-DATE      Numeric 8  (yyyymmdd)
Element: Date          This is the date the work order was
                       returned from a vendor performing a
                       process that had placed the work order
                       on offsite hold.

WOR-REVERSED-BY-WO     Numeric 8
Element: Work Order    This is the number of the work order
                       that reverses this work order.

WOR-WF-PROD-FL         Alpha 1
Element: All Flag      The Workflow Management system
                       production flag is set to Yes when the
                       work order is in the production process.
                       Y = Yes
                       N = No

WOR-WF-OFFSITE-FL      Alpha 1
Element: All Flag      The Workflow Management system offsite
                       flag is set to Yes when the work order
                       is in the offsite production process.
                       Y = Yes
                       N = No

WOR-LAST-COMP-SEQ      Numeric 3
Element: Seq           This is the last sequence number used
                       for components added to the work order
                       item file for this work order.

WOR-LAST-BRDN-SEQ      Numeric 3
Element: Seq           This is the last sequence used for
                       burdens added to this work order.

WOR-LAST-BYPRO-SEQ     Numeric 3
Element: Seq           This is the last sequence number used
                       for byproducts added to this work order.

WOR-WO-ALPHA           Derived
Element: Wo Alpha      The system displays a group field that
                       contains work order (WORK-ORDER) and
                       work order suffix (WORK-ORDER-SUF).

WOR-DISP-DOC           Derived
Element: Disp Doc      The system displays a conditional field
                       that contains a label stating that it is
                       a customer order or requisition if the
                       system code (SYSTEM-CD) is Order Entry
                       or Requisition.

WOR-EST-FG-COST        Derived
Element: Est Fg Cost   The system displays the result of
                       estimated component cost + estimated
                       packaging cost + estimated burden cost
                       (computed as EST-COMP-COST +
                       EST-PACK-COST +  EST-BRDN-COST).

WOR-ACT-FG-COST        Derived
Element: Act Fg Cost   The system displays the result of
                       actual component cost + actual packaging
                       cost + actual burden cost (computed as
                       ACT-COMP-COST + ACT-PACK-COST +
                       ACT-BRDN-COST).

WOR-WO-USER-FLD-1      Alpha 10  (Lower Case)
Element: User          This field contains user-defined data
                       and can be used to cross reference work
                       order numbers.

WOR-WO-USER-FLD-2      Alpha 15  (Lower Case)
Element: User Fld3     This field contains user-defined
                       information.

WOR-WO-USER-DATE-1     Numeric 8  (yyyymmdd)
Element: Date          This field contains user-defined dates.

WOR-BA-ACCT-UNIT       Alpha 15
Element: Ba Acct Unit  This field identifies the burden
                       absorption account unit to record
                       burden expenses associated with a
                       production facility.

WOR-BA-ACCOUNT         Numeric 6
Element: Ba Account    This field identifies the burden
                       absorption account to record burden
                       expenses associated with a production
                       facility.

WOR-BA-SUB-ACCT        Numeric 4
Element: Ba Sub Acct   This field identifies the burden
                       absorption subaccount to record burden
                       expenses associated with a production
                       facility.

WOR-PC-ACCT-UNIT       Alpha 15
Element: Pc Acct Unit  This field identifies the production
                       credit account unit to record credit to
                       a production facility for finished goods
                       produced.

WOR-PC-ACCOUNT         Numeric 6
Element: Pc Account    This field identifies the production
                       credit account to record credit to a
                       production facility for finished goods
                       produced.

WOR-PC-SUB-ACCT        Numeric 4
Element: Pc Sub Acct   This field identifies the production
                       credit subaccount to record credit to a
                       production facility for finished goods
                       produced.

                         WORDER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WORSET1   COMPANY                                                BL120   BL122
          LOCATION                                               BL130   BL20.1
          WORK-ORDER                                             BL20.3  BL21.2
          WORK-ORDER-SUF                                         BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC01.1  WH20.7
                                                                 WHD2.1  WHD3.1

WORSET2   COMPANY       KeyChange                                IC02.1
          LOCATION
          STATUS
          WORK-ORDER
          WORK-ORDER-SUF

WORSET3   COMPANY       KeyChange
          LOCATION
          STATUS
          START-DATE
          WORK-ORDER
          WORK-ORDER-SUF

WORSET4   COMPANY       KeyChange
          LOCATION
          ITEM
          WORK-ORDER*
          WORK-ORDER-SUF

WORSET5   COMPANY       KeyChange
          LOCATION
          END-DATE
          WORK-ORDER
          WORK-ORDER-SUF

WORSET7   COMPANY       KeyChange, Subset
          LOCATION      Where WO-USER-FLD-1 != Spaces
          WO-USER-FLD-1
          WORK-ORDER
          WORK-ORDER-SUF

                         WORDER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Not Required
                            Valid When WOR-VENDOR != Spaces

                            WOR-COMPANY           -> -COMPANY

Apvenmast      APVENMAST    Not Required
                            Valid When WOR-VENDOR != Spaces

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            WOR-VENDOR            -> VEN-VENDOR

Arcomp         ARCOMP       Required

                            WOR-COMPANY           -> ACO-COMPANY

Custorder      CUSTORDER    Required
                            When WOR-SYSTEM-CD   =  "OE"
                            And  WOR-DOC-NBR-NUM != Zeroes

                            WOR-COMPANY           -> COR-COMPANY
                            WOR-DOC-NBR-NUM       -> COR-ORDER-NBR

Holdcodes      HOLDCODES    Required
                            When WOR-HOLD-CODE != Spaces

                            ACO-CUST-GROUP        -> HDD-CUST-GROUP
                            WOR-HOLD-CODE         -> HDD-HOLD-CODE

Iccompany      ICCOMPANY    Required

                            WOR-COMPANY           -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WOR-COMPANY           -> ICL-COMPANY
                            WOR-LOCATION          -> ICL-LOCATION

Itemloc        ITEMLOC      Required

                            WOR-COMPANY           -> ITL-COMPANY
                            WOR-LOCATION          -> ITL-LOCATION
                            WOR-ITEM              -> ITL-ITEM

Itemmast       ITEMMAST     Not Required

                            ICC-ITEM-GROUP        -> ITE-ITEM-GROUP
                            WOR-ITEM              -> ITE-ITEM

Reqheader      REQHEADER    Required
                            When WOR-SYSTEM-CD   =  "RQ"
                            And  WOR-DOC-NBR-NUM != Zeroes

                            WOR-COMPANY           -> RQH-COMPANY
                            WOR-DOC-NBR-NUM       -> RQH-REQ-NUMBER

Woworuf        WOWORUF      Not Required

                            WOR-COMPANY           -> WRU-COMPANY
                            WOR-LOCATION          -> WRU-LOCATION
                            WOR-WORK-ORDER        -> WRU-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WRU-WORK-ORDER-SUF

                         WORDER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bin Details    WODETAIL
                            Valid When ITE-LOT-TRACK-FL = "N"
                                  And  ITE-SER-TRACK-FL = "N"
                                  And  ITL-BIN-TRACK-FL = "Y"

                            WOR-COMPANY           -> WOD-COMPANY
                            WOR-LOCATION          -> WOD-LOCATION
                            WOR-WORK-ORDER        -> WOD-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "F"                   -> WOD-DETAIL-TYPE
                            Zeroes                -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Items By Loc   WOITEM

                            WOR-COMPANY           -> WOI-COMPANY
                            WOR-LOCATION          -> WOI-LOCATION
                            WOR-WORK-ORDER        -> WOI-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOI-WORK-ORDER-SUF
                                                     WOI-INV-LOCATION
                                                     WOI-COMPONENT-SEQ

Lot Details    WODETAIL
                            Valid When ITE-LOT-TRACK-FL = "Y"

                            WOR-COMPANY           -> WOD-COMPANY
                            WOR-LOCATION          -> WOD-LOCATION
                            WOR-WORK-ORDER        -> WOD-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "F"                   -> WOD-DETAIL-TYPE
                            Zeroes                -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Serial Details WODETAIL
                            Valid When ITE-SER-TRACK-FL != "N"

                            WOR-COMPANY           -> WOD-COMPANY
                            WOR-LOCATION          -> WOD-LOCATION
                            WOR-WORK-ORDER        -> WOD-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "F"                   -> WOD-DETAIL-TYPE
                            Zeroes                -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Uom Details    WODETAIL

                            WOR-COMPANY           -> WOD-COMPANY
                            WOR-LOCATION          -> WOD-LOCATION
                            WOR-WORK-ORDER        -> WOD-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "F"                   -> WOD-DETAIL-TYPE
                            Zeroes                -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Whdemand       WHDEMAND

                            WOR-COMPANY           -> WDM-COMPANY
                            WOR-LOCATION          -> WDM-LOCATION
                                                     WDM-ITEM
                                                     WDM-EST-TRAN-DT
                                                     WDM-SYSTEM-CD
                                                     WDM-DOC-NBR
                                                     WDM-LINE-NBR
                                                     WDM-COMPONENT-SEQ

Whsupply       WHDEMAND

                            WOR-COMPANY           -> WDM-COMPANY
                            WOR-LOCATION          -> WDM-LOCATION
                            "WO"                  -> WDM-SYSTEM-CD
                            WOR-WO-ALPHA          -> WDM-DOC-NBR
                                                     WDM-LINE-NBR
                                                     WDM-COMPONENT-SEQ

Wobyprod       WOBYPROD     Delete Restricted

                            WOR-COMPANY           -> WOB-COMPANY
                            WOR-LOCATION          -> WOB-LOCATION
                            WOR-WORK-ORDER        -> WOB-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOB-WORK-ORDER-SUF
                                                     WOB-SEQ

Wocomp         WOITEM       Delete Restricted

                            WOR-COMPANY           -> WOI-COMPANY
                            WOR-LOCATION          -> WOI-LOCATION
                            WOR-WORK-ORDER        -> WOI-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOI-WORK-ORDER-SUF
                                                     WOI-COMPONENT-SEQ

Wodetail       WODETAIL

                            WOR-COMPANY           -> WOD-COMPANY
                            WOR-LOCATION          -> WOD-LOCATION
                            WOR-WORK-ORDER        -> WOD-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOD-WORK-ORDER-SUF
                            "F"                   -> WOD-DETAIL-TYPE
                            Zeroes                -> WOD-COMPONENT-SEQ
                                                     WOD-BIN
                                                     WOD-LOT
                                                     WOD-SUBLOT
                                                     WOD-SERIAL
                                                     WOD-UOM

Woitem         WOITEM

                            WOR-COMPANY           -> WOI-COMPANY
                            WOR-LOCATION          -> WOI-LOCATION
                            WOR-WORK-ORDER        -> WOI-WORK-ORDER
                            WOR-WORK-ORDER-SUF    -> WOI-WORK-ORDER-SUF
                                                     WOI-COMPONENT-SEQ