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

AP260     AP195     MA01.1

UPDATED BY

AP176     AP177     AP180     AP181     AP190     AP198
AP28.1    AP28.2    AP300     AP45.1    APDS.1    MA70.1
MA75.1    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 ID     The vendor's identification code.         AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 APDS.1

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

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

DSK-CANCEL-SEQ         Numeric 4                                 AP180   AP181
Element: Sequence NumbeThe 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
Element: Sequence NumbeAn automatically assigned sequence        AP190   AP28.1
                       number.                                   AP28.2  AP45.1
                                                                 APDS.1

DSK-VOID-SEQ           Numeric 4                                 AP180   AP181
Element: Sequence NumbeThe 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 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

                       1 = Open
                       2 = Posted

DSK-GLT-OBJ-ID         Numeric 12                                AP176   AP180
Object                 This is a subsystem GL interface          AP181   AP190
Identification         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
Element: Journal Book  The journal book assigned to the          AP190   AP28.1
                       transaction.                              AP28.2  AP45.1

DSK-API-OBJ-ID         Numeric 12
Object
Identification

DSK-TRAN-BASE-ND       Numeric 1
Account Currency
Code

DSK-PROC-LEVEL         Alpha 5
Element: Process Level The process level represents a
                       reporting level 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                                                AP176   AP190
          VENDOR                                                 AP198   AP260
          INVOICE                                                AP300   AP305
          SUFFIX                                                 APDS.1  MA70.1
          CANCEL-SEQ                                             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