Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PODEFAUDIT


                            PODEFAUDIT FILE

REFERENCED BY

PO00.1    PO268     PO68.1

UPDATED BY

PO01.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PDT-COMPANY            Numeric 4                                 PO01.4
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PDT-AUDIT-TYPE         Alpha 2                                   PO01.4
Element: Audit Type    The type of source record that is being
                       audited.
                       AU = Account Unit
                       AT = Account
                       AV = Activity
                       AC = Account Category
                       VN = Vendor
                       PF = Purchase From Location
                       CT = Cost
                       SP = One Source Document to One PO

PDT-AUDIT-ACTION       Alpha 1                                   PO01.4
Element: Audit Action  The action (add, change, etc.) that is
                       being audited.
                       A = Add
                       C = Change

PDT-FLD-NBR            Numeric 4                                 PO01.4
Element: Fld Nbr       This field contains the PO dictionary
                       field number.

PDT-SEQ-NBR            Numeric 4                                 PO01.4
Element: Seq Nbr       An automatically assigned sequence
                       number.

PDT-UPDATE-DATE        Numeric 8  (yyyymmdd)                     PO01.4
Element: Update Date   This field contains the date the record
                       was updated.

PDT-UPDATE-TIME        Numeric 6                                 PO01.4
Element: Update Time   This field contains the system time
                       when the record was updated.

PDT-BEFORE-IMAGE       Alpha 32                                  PO01.4
Element: Before Image  This field contains the field image
                       before the change.

PDT-AFTER-IMAGE        Alpha 32                                  PO01.4
Element: Before Image  This field contains the field image
                       before the change.

PDT-USER-ID            Alpha 10  (Lower Case)                    PO01.4
Element: User

PDT-DESCRIPTION        Alpha 30  (Lower Case)                    PO01.4
Element: Description   This field displays the description.

                         PODEFAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDTSET1   COMPANY                                                PO00.1  PO268
          AUDIT-TYPE                                             PO68.1
          UPDATE-DATE*
          UPDATE-TIME*
          FLD-NBR
          SEQ-NBR*
          AUDIT-ACTION

PDTSET2   COMPANY
          UPDATE-DATE*
          UPDATE-TIME*
          AUDIT-TYPE
          FLD-NBR
          SEQ-NBR*
          AUDIT-ACTION