Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDISCCODE


                            APDISCCODE FILE

                             Discount Code

The Discount Code file contains discount codes. A discount code is used to
link a general ledger discount account to an invoice.

REFERENCED BY

AC160     AM115     AM117     AM15.1    AM15.2    AM15.3
AM15.4    AM19.1    AM19.2    AM20.1    AM20.3    AM21.1
AM21.3    AM500     AM51.1    AM551     AM97.1    AP03.3
AP10.1    AP10.2    AP10.5    AP110     AP115     AP125
AP126     AP131     AP170     AP190     AP200     AP205
AP210     AP220     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.3    AP30.4    AP510     AP520     AP90.1
AP91.1    API1.1    API2.1    API3.1    API4.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    MX123
MX500     MA180     MA279     MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA63.1    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PD235     PO10.1
PO100     PO101     PO120     PO122     PO131     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO223     PO23.1    PO233     PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO253     PO254     PO27.2
PO278     PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO32.4    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     PO54.1
PO54.2    PO54.3    PO54.4    POI3.1    POID.1    POII.1
POIJ.1    PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    PR514     UK47.1    RQ10.1    RQ10.2    WH20.2
WH20.7

UPDATED BY

AP00.4    AP05.7    AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP21.1    AP23.1    AP305     MA41.1
MA41.2    MA41.4    MA41.7    MA43.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DSC-DISCOUNT-CODE      Alpha 10                                  AP00.4  AP05.7
Element: Discount Code A user-defined code representing a
                       general ledger discount account.

DSC-COMPANY            Numeric 4                                 AP00.4  AP05.7
Element: Posting CompanThe general ledger company number used
                       for posting the discount entry to the
                       general ledger. Must be a valid record
                       in the General ledger Company file.

DSC-DISC-ACCT-UNIT     Alpha 15                                  AP00.4  AP05.7
Discount Accounting    The general ledger discount accounting
Unit                   unit assigned to the discount code. Must
                       be a valid accounting unit in General
                       Ledger.


DSC-DISC-ACCOUNT       Numeric 6                                 AP00.4  AP05.7
Discount Account       The general ledger discount account
Number                 number assigned to the discount code.
                       Must be a valid account in General
                       Ledger.


DSC-DISC-SUB-ACCT      Numeric 4                                 AP00.4  AP05.7
Discount Subaccount    If using subaccounts, the general
Number                 ledger discount subaccount number
                       assigned to the discount code. Must be a
                       valid subaccount in General Ledger.


DSC-ACTIVE-FLAG        Alpha 1                                   AP00.4  AP05.7
Element: Status        Indicates the status of the discount
                       code. Valid values are:

                       A = Active.
                       I = Inactive.

DSC-USED-FLAG          Alpha 1                                   AP05.7  AP20.1
Element: Used          Indicates whether the discount code has   AP20.2  AP20.3
                       been used.                                AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

DSC-DISC-POINT         Numeric 1                                 AP05.7
Element: Disc Point    This flag indicates whether you want
                       thediscount applied to the Cost of
                       goodsonly, or Cost of goods plus the
                       AOCamount on the AP invoice. C = Will
                       apply the discount to the Cost    of
                       goods  only.
                       T = Will apply the discount to the Cost
                           of goods plus the AOC.
                       Blank will be the same as option "T".
                       1 = C - (Cost of Goods)
                       2 = T - (Total COG & AOC)

                         APDISCCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DSCSET1   DISCOUNT-CODE                                          AC160   AM115
                                                                 AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.4
                                                                 AP00.5  AP03.3
                                                                 AP05.7  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 ...

DSCSET2   COMPANY       KeyChange                                AP205   AP305
          DISCOUNT-CODE