Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APDISCACC FILE

                                Discount

The Accounts Payable Discount

REFERENCED BY

AP260     AP195     MA01.1

UPDATED BY

AP176     AP180     AP181     AP190     AP198     AP28.1
AP28.2    AP300     AP45.1    APDS.1    AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DSK-COMPANY          Numeric 4                                   AP180   AP181
Company              The company number represents an            AP190   AP28.1
                     established company and is entered on       AP28.2  AP45.1
                     all function codes.                         APDS.1

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

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

DSK-SUFFIX           Numeric 3                                   AP180   AP181
Invoice Suffix       The invoice suffix.                         AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 APDS.1

DSK-CANCEL-SEQ       Numeric 4                                   AP180   AP181
Cancel Sequence      The sequence number assigned upon a         AP190   AP28.1
                     cancellation of a distributed invoice.      AP28.2  AP45.1
                     The first sequence assigned is 9999.        APDS.1

DSK-SEQ-NBR          Numeric 4                                   AP180   AP181
Sequence Number      An automatically assigned sequence          AP190   AP28.1
                     number.                                     AP28.2  AP45.1
                                                                 APDS.1

DSK-VOID-SEQ         Numeric 4                                   AP180   AP181
Void Sequence        The sequence number assigned to voided      AP190   AP28.1
                     payments.                                   AP28.2  AP45.1
                                                                 APDS.1

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


DSK-TRAN-DISC-AMT    Signed 15.2                                 AP180   AP181
Discount Amount      The discount amount in the currency of      AP190   AP28.1
                     the transaction.                            AP28.2  AP45.1
                                                                 APDS.1

DSK-BASE-DISC-AMT    Signed 15.2                                 AP180   AP181
Base Discount Amount The discount amount in company base         AP190   AP28.1
                     currency.                                   AP28.2  AP45.1
                                                                 APDS.1

DSK-PROCESS-LEVEL    Alpha 5                                     AP180   AP181
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
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
Status               The transaction status.                     AP181   AP190
                                                                 AP28.1  AP28.2
                     Valid values are:                           AP45.1  APDS.1

                     1 = Open
                     2 = Posted

DSK-GLT-OBJ-ID       Numeric 12                                  AP176   AP180
Subsystem GL         This is a subsystem GL interface            AP181   AP190
Interface ID         identification number. It is used for       AP28.1  AP28.2
                     Drill Around purposes.                      AP45.1  APDS.1

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

                         APDISCACC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

                         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