Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PDAUDIT


                              PDAUDIT FILE

REFERENCED BY

PD260

UPDATED BY

PD10.2    PD10.3    PD20.1    PD20.2    PD20.3    PD21.1
PD22.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PDU-PCARD-PROGRAM      Alpha 10                                  PD10.2  PD10.3
Element: Pcard Program                                           PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

PDU-PCARD-NBR          Alpha 16                                  PD10.2  PD10.3
Element: Pcard Nbr                                               PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

PDU-PD-AUDIT-TYPE      Alpha 1                                   PD10.2  PD10.3
Element: Pd Audit Type 1 = Card                                  PD20.1  PD20.2
                       2 = Charge                                PD20.3  PD21.1
                                                                 PD22.1

PDU-ACTION             Alpha 1                                   PD10.2  PD10.3
Element: Flag          A = Add                                   PD20.1  PD20.2
                       C = Change                                PD20.3  PD21.1
                       L = Cancel                                PD22.1
                       D = Delete

PDU-FIELD-NBR          Numeric 3                                 PD10.2  PD10.3
Element: Field Nbr                                               PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

PDU-BEFORE-VALUE       Alpha 32                                  PD10.2  PD10.3
Element: Before Image  This field contains the field image       PD20.1  PD20.2
                       before the change.                        PD20.3  PD21.1
                                                                 PD22.1

PDU-AFTER-VALUE        Alpha 32                                  PD10.2  PD10.3
Element: Before Image  This field contains the field image       PD20.1  PD20.2
                       before the change.                        PD20.3  PD21.1
                                                                 PD22.1

PDU-USER               Alpha 10  (Lower Case)                    PD10.2  PD10.3
Element: User                                                    PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

PDU-DATE               Numeric 8  (yyyymmdd)                     PD10.2  PD10.3
Element: Update Date   This field contains the date the record   PD20.1  PD20.2
                       was updated.                              PD20.3  PD21.1
                                                                 PD22.1

PDU-TIME               Numeric 6                                 PD10.2  PD10.3
Element: Update Time   This field contains the system time       PD20.1  PD20.2
                       when the record was updated.              PD20.3  PD21.1
                                                                 PD22.1

PDU-SEQ                Numeric 3                                 PD20.1  PD20.2
Element: Seq           This field contains the record sequence   PD20.3  PD21.1
                       number.                                   PD22.1

PDU-TXN-NBR            Alpha 22                                  PD10.2  PD10.3
Element: Transaction                                             PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

PDU-STATEMENT          Alpha 22                                  PD10.2  PD10.3
Element: Invoice       Used to identify the invoice.             PD20.1  PD20.2
                                                                 PD20.3  PD21.1
                                                                 PD22.1

                         PDAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDUSET1   PCARD-PROGRAM                                          PD260
          PCARD-NBR
          PD-AUDIT-TYPE
          ACTION
          FIELD-NBR
          USER
          DATE
          TIME
          SEQ

PDUSET2   PCARD-PROGRAM Subset
          PCARD-NBR     Where PD-AUDIT-TYPE = "2"
          STATEMENT
          TXN-NBR
          PD-AUDIT-TYPE
          ACTION
          FIELD-NBR
          USER
          DATE
          TIME
          SEQ