Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDISCACC


                             APDISCACC FILE

                                Discount

The Accounts Payable Discount

REFERENCED BY

AP136     MA01.1

UPDATED BY

AP176     AP177     AP180     AP181     AP190     AP195
AP28.1    AP28.2    AP300     AP45.1    APDS.1    MA70.1
MA75.1    AP198     AP305

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DSK-COMPANY            Numeric 4                                 AP180   AP181
Element: Company       Identifies the AP company if the          AP190   AP28.1
                       resource type = V.  Identifies the HR     AP28.2  AP45.1
                       company if the resource type = E.  It is  APDS.1
                       blank for type A, P or Q resources.

DSK-VENDOR             Alpha 9  (Right Justified)                AP180   AP181
Element: Vendor        The vendor's identification code.         AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 APDS.1

DSK-INVOICE            Alpha 22                                  AP180   AP181
Element: Invoice       Invoice number.                           AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 APDS.1

DSK-SUFFIX             Numeric 3                                 AP180   AP181
Element: Suffix        The invoice suffix.                       AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 APDS.1  MA70.1
                                                                 MA75.1

DSK-CANCEL-SEQ         Numeric 4                                 AP180   AP181
Element: Seq Nbr       An automatically assigned sequence        AP190   AP28.1
                       number.                                   AP28.2  AP45.1
                                                                 APDS.1

DSK-SEQ-NBR            Numeric 4                                 AP180   AP181
Element: Seq Nbr       An automatically assigned sequence        AP190   AP28.1
                       number.                                   AP28.2  AP45.1
                                                                 APDS.1

DSK-VOID-SEQ           Numeric 4                                 AP180   AP181
Element: Seq Nbr       The sequence number assigned to voided    AP190   AP28.1
                       payments.                                 AP28.2  AP45.1
                                                                 APDS.1

DSK-POST-DATE          Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Post Date     The date general ledger entries for the   AP190   AP195
                       transaction will be posted to the         AP28.1  AP28.2
                       general ledger.                           AP45.1  APDS.1


DSK-TRAN-DISC-AMT      Signed 18.2                               AP180   AP181
Element: Intl Amt      The discount amount in the currency of    AP190   AP28.1
                       the transaction.                          AP28.2  AP45.1
                                                                 APDS.1

DSK-BASE-DISC-AMT      Signed 18.2                               AP180   AP181
Element: Intl Amt      The discount amount in company base       AP190   AP28.1
                       currency.                                 AP28.2  AP45.1
                                                                 APDS.1

DSK-PROCESS-LEVEL      Alpha 5                                   AP180   AP181
Element: Process Level This field contains the process level,    AP190   AP28.1
                       which is the reporting hierarchy below    AP28.2  AP45.1
                       company.                                  APDS.1

DSK-DISC-TYPE          Alpha 1                                   AP180   AP181
Element: Discount Type Indicates the discount type.              AP190   AP28.1
                                                                 AP28.2  AP45.1
                       Valid values are:                         APDS.1

                       M = Match
                       R = Reverse

DSK-STATUS             Numeric 1                                 AP176   AP180
Element: Status        The transaction status.                   AP181   AP190
                                                                 AP28.1  AP28.2
                       Valid values are:                         AP45.1  APDS.1
                                                                 MA70.1  MA75.1
                       1 = Open
                       2 = Posted

DSK-GLT-OBJ-ID         Numeric 12                                AP176   AP180
Element: Obj Id        This is the object identifier. It is      AP181   AP190
                       used to relate commitments or posted      AP28.1  AP28.2
                       transactions back to the originating      AP45.1  APDS.1
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

DSK-JRNL-BOOK-NBR      Alpha 12                                  AP180   AP181
Element: Jrnl Book Nbr The journal book assigned to the          AP190   AP28.1
                       transaction.                              AP28.2  AP45.1

DSK-API-OBJ-ID         Numeric 12
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

DSK-TRAN-BASE-ND       Numeric 1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


DSK-PROC-LEVEL         Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

DSK-PULL-FOR-FR-FL     Alpha 1                                   AP176   AP177
Element: Pull For Fr Fl

                         APDISCACC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DSKSET1   COMPANY                                                AP136   AP176
          VENDOR                                                 AP190   AP195
          INVOICE                                                AP198   AP300
          SUFFIX                                                 AP305   APDS.1
          CANCEL-SEQ                                             MA70.1  MA75.1
          SEQ-NBR
          VOID-SEQ
          DISC-TYPE

DSKSET2   STATUS        KeyChange                                AP176   AP195
          COMPANY                                                MA01.1
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ

DSKSET3   COMPANY       Subset                                   AP177
          VENDOR        Where (PULL-FOR-FR-FL = "Y" )
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          DISC-TYPE

                         APDISCACC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apinvoice      APINVOICE    Required

                            DSK-COMPANY       -> API-COMPANY
                            DSK-VENDOR        -> API-VENDOR
                            DSK-INVOICE       -> API-INVOICE
                            DSK-SUFFIX        -> API-SUFFIX
                            DSK-CANCEL-SEQ    -> API-CANCEL-SEQ

Appayment      APPAYMENT    Not Required

                            DSK-COMPANY       -> APP-COMPANY
                            DSK-VENDOR        -> APP-VENDOR
                            DSK-INVOICE       -> APP-INVOICE
                            DSK-SUFFIX        -> APP-SUFFIX
                            DSK-CANCEL-SEQ    -> APP-CANCEL-SEQ
                            DSK-SEQ-NBR       -> APP-SEQ-NBR
                            DSK-VOID-SEQ      -> APP-VOID-SEQ