Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOBRDN


                              WOBRDN FILE

                           Work Order Burdens

The Work Order Burdens file contains burdens associated with a work order to
designate non-inventory costs associated with producing the finished good.

REFERENCED BY

WO120     WO133     WO140     WO20.1    WO252     WO255

UPDATED BY

WO30.1    WO300     WO35.1    WO40.1    WO40.2    WO40.3
WO40.4    WO40.5    WO41.1    WO41.2    WO41.3    WO41.4
WO42.1    WO42.2    WO42.3    WO42.4    WO42.5    WO45.1
WOD0.1    WOEX.1    WOSP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WBN-COMPANY            Numeric 4                                 WO30.1  WO35.1
Element: Company       This field contains the company number,   WO40.1  WOEX.1
                       as defined in the Inventory Control
                       system.

WBN-LOCATION           Alpha 5                                   WO30.1  WO35.1
Element: Location Code This field contains a valid stock         WO40.1  WOEX.1
                       location within the company inventory.
                       It is also the production facility
                       where finished goods are produced.

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


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

WBN-SEQ                Numeric 3                                 WO30.1  WO35.1
Element: Sequence NumbeThis field contains the record sequence   WO40.1  WOEX.1
                       number of the burden for this work
                       order.

WBN-BURDEN-CODE        Alpha 4                                   WO30.1  WO35.1
Accounts Receivable    Burden code identifies a burden that      WO40.1  WOEX.1
Code                   has cost and rate information which is
                       used to determine costs in addition to
                       inventory item costs associated with a
                       simple production process.

WBN-VENDOR             Alpha 9  (Right Justified)                WO30.1  WO35.1
Element: Vendor ID     This field contains the identification    WO40.1  WOEX.1
                       code of the vendor who performs all or
                       part of the production process offsite
                       for this work order.

WBN-EST-AMT            Signed 13.2                               WO30.1  WOEX.1
Element: Act Amt       This is the estimated flat amount
                       burden costs of the finished good for
                       this work order.

WBN-EST-AMT-PER-U      Signed 13.2                               WO30.1  WOEX.1
Element: Act Amt       This is the estimated amount used in
                       the calculation of per finished good
                       burdens and per burden unit burdens when
                       the work order is created.

WBN-EST-QTY            Signed 13.2                               WO30.1  WOEX.1
Element: Act Qty       This is the estimated quantity used
                       along with estimated amount per unit and
                       estimated multiplier for the calculation
                       of per burden unit burdens when the work
                       order is created.

WBN-EST-MULT           Signed 4.1                                WO30.1  WOEX.1
Element: Act Mult      This is the estimated multiplier used
                       along with estimated amount per unit and
                       estimated quantity for calculation of
                       per burden unit burdens when the work
                       order is created.

WBN-EST-PCT            Percent 5.2  (Percent)                    WO30.1  WOEX.1
Element: Percent       This is the estimated percentage used
                       along with inventory cost for the
                       calculation of percentage of inventory
                       cost burdens when the work order is
                       created.

WBN-ACT-AMT            Signed 13.2                               WO35.1  WO40.1
Element: Act Amt       This is the actual amount for flat        WO40.2  WO40.3
                       amount burdens, determined after          WO40.4  WO40.5
                       production has been completed.            WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WBN-ACT-AMT-PER-U      Signed 13.2                               WO35.1  WO40.1
Element: Act Amt       This is the actual amount per unit used   WO40.2  WO40.3
                       in the calculation of per finished good   WO40.4  WO40.5
                       burdens and per burden unit burdens,      WO41.1  WO41.2
                       determined after production has been      WO41.3  WO41.4
                       completed.                                WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WBN-ACT-QTY            Signed 13.2                               WO35.1  WO40.1
Element: Act Qty       This is the actual quantity used along    WO40.2  WO40.3
                       with actual amount per unit and actual    WO40.4  WO40.5
                       multiplier for the calculation of per     WO41.1  WO41.2
                       burden unit burdens, determined after     WO41.3  WO41.4
                       production has been completed.            WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WBN-ACT-MULT           Signed 4.1                                WO35.1  WO40.1
Element: Act Mult      This is the actual multiplier used        WO40.2  WO40.3
                       along with actual amount per unit and     WO40.4  WO40.5
                       actual quantity for calculation of per    WO41.1  WO41.2
                       burden unit burdens, determined after     WO41.3  WO41.4
                       production has been completed.            WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WBN-ACT-PCT            Percent 5.2  (Percent)                    WO35.1  WO40.1
Element: Percent       This is the actual percentage used        WO40.2  WO40.3
                       along with inventory cost for the         WO40.4  WO40.5
                       calculation of percentage of inventory    WO41.1  WO41.2
                       cost burdens, determined after            WO41.3  WO41.4
                       production has been completed.            WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WOSP.1

WBN-COST-TOL-PCT       Percent 5.3  (Percent)                    WO30.1  WO35.1
Element: Cost Pct      This is the cost tolerance percent for    WOEX.1
                       a burden on a work order.

WBN-ZERO-COST-FL       Alpha 1                                   WO30.1  WO35.1
Element: All Flag      The zero cost tolerance flag is used to   WOEX.1
                       indicate if zero tolerance is allowed
                       for burden cost tolerance checking.  If
                       no tolerance checking is needed, this
                       field defaults to No.
                       Y = Yes
                       N = No

WBN-PERFGESTTOT        Derived
Element: Perfgesttot   The system displays the result of
                       estimated amount per unit * planned
                       quantity (computed as EST-AMT-PER-U *
                       WOR-PLAN-QTY).

WBN-PERBRDNESTTOT      Derived
Element: Perbrdnesttot The system displays the result of
                       estimated amount per unit * estimated
                       quantity *  estimated multiplier
                       (computed as  EST-AMT-PER-U * EST-QTY *
                       EST-MULT).

WBN-PCTINVESTTOT       Derived
Element: Pctinvesttot  The system displays the result of
                       estimated percentage * (estimated
                       component cost + estimated packaging
                       cost). Computed as  EST-PCT *
                       (WOR-EST-COMP-COST + WOR-EST-PACK-COST).


WBN-ESTIMATEDTOT       Derived
Element: Estimatedtot  The system displays a conditional field
                       that will contain the estimated burden
                       cost based on the burden type and the
                       appropriate computed field.

WBN-PERFGACTTOT        Derived
Element: Perfgacttot   The system displays the result of
                       actual amount per unit * actual quantity
                       (computed as ACT-AMT-PER-U *
                       WOR-ACTUAL-QTY).

WBN-PERBRDNACTTOT      Derived
Element: Perbrdnacttot The system displays the result of
                       actual amount per unit * actual quantity
                       * actual multiplier (computed as
                       ACT-AMT-PER-U * ACT-QTY * ACT-MULT).

WBN-PCTINVACTTOT       Derived
Element: Pctinvacttot  The system displays the result of
                       actual percentage * (actual component
                       cost + actual packaging cost). Computed
                       as ACT-PCT * (WOR-ACT-COMP-COST +
                       WOR-ACT-PACK-COST).

WBN-ACTUALTOT          Derived
Element: Actualtot     The system displays a conditional field
                       that will contain the actual burden cost
                       based on the burden type and the
                       appropriate computed field.

WBN-EST-UOM            Alpha 4                                   WO30.1  WOEX.1
Element: Est Uom       A unit of measure other than stock
                       (alternate UOM), that is used to
                       determine burden costs associated with
                       producing a finished  good. This amount
                       is an estimate, defaulted from the
                       finished good definition.

WBN-ACT-UOM            Alpha 4                                   WO40.1
Element: Act Uom       This field is the actual unit of
                       measure.

                         WOBRDN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WBNSET1   COMPANY       This index is used to access Work Order  WO120   WO133
          LOCATION      burden records for a specific work order WO140   WO20.1
          WORK-ORDER    and burden sequence number for a         WO252   WO255
          WORK-ORDER-SUFproduction location.                     WO30.1  WO300
          SEQ                                                    WO35.1  WO40.1
                                                                 WO40.2  WO40.3
                                                                 WO40.4  WO40.5
                                                                 WO41.1  WO41.2
                                                                 WO41.3  WO41.4
                                                                 WO42.1  WO42.2
                                                                 WO42.3  WO42.4
                                                                 WO42.5  WO45.1
                                                                 WOD0.1  WOEX.1
                                                                 WOSP.1

WBNSET2   COMPANY       This index is used to access Work Order
          LOCATION      burden records for a specific burden
          BURDEN-CODE   code, work order, and burden sequence
          WORK-ORDER    number for a production location.
          WORK-ORDER-SUFKeyChange
          SEQ

                         WOBRDN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                            WBN-COMPANY           -> CPY-COMPANY

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

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            WBN-VENDOR            -> VEN-VENDOR

Icbrdntmpl     ICBRDNTMPL   Required

                            WBN-COMPANY           -> IBT-COMPANY
                            WBN-LOCATION          -> IBT-LOCATION
                            WBN-BURDEN-CODE       -> IBT-BURDEN-CODE

Worder         WORDER       Required

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

Wosgblk        WOSGBLK      Not Required

                            WBN-COMPANY           -> WSB-COMPANY
                            WBN-LOCATION          -> WSB-LOCATION
                            WBN-WORK-ORDER        -> WSB-WORK-ORDER
                            WBN-WORK-ORDER-SUF    -> WSB-WORK-ORDER-SUF
                            Zeroes                -> WSB-COMPONENT-SEQ
                            WBN-SEQ               -> WSB-SEQ

Wowbnuf        WOWBNUF      Not Required

                            WBN-COMPANY           -> WBU-COMPANY
                            WBN-LOCATION          -> WBU-LOCATION
                            WBN-WORK-ORDER        -> WBU-WORK-ORDER
                            WBN-WORK-ORDER-SUF    -> WBU-WORK-ORDER-SUF
                            WBN-SEQ               -> WBU-SEQ