APDISCCODE – Discount Code

System
Accounts Payable (AP)
Prefix
DSC
Primary key
DISCOUNT-CODE
Fields
8
Updated by
19 programs
Referenced by
275 programs

APDISCCODE is the Discount Code table in Lawson Accounts Payable (prefix DSC). It is indexed by DISCOUNT-CODE (DSCSET1); alternate indexes: DSCSET2. It is updated by AP00.4, AP05.7, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 11 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 267 more. The table has 8 fields, 2 indexes and 0 documented relations.

About APDISCCODE

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

Fields (8)

Column = COBOL field name without the DSC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
DSC-DISCOUNT-CODE PK
DISCOUNT_CODE
Alpha 10A user-defined code representing a general ledger discount account.AP00.4, AP05.7
DSC-COMPANY
COMPANY
Numeric 4The 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.AP00.4, AP05.7
DSC-DISC-ACCT-UNIT
DISC_ACCT_UNIT
Alpha 15The general ledger discount accounting unit assigned to the discount code. Must be a valid accounting unit in General Ledger.AP00.4, AP05.7
DSC-DISC-ACCOUNT
DISC_ACCOUNT
Numeric 6The general ledger discount account number assigned to the discount code. Must be a valid account in General Ledger.AP00.4, AP05.7
DSC-DISC-SUB-ACCT
DISC_SUB_ACCT
Numeric 4If using subaccounts, the general ledger discount subaccount number assigned to the discount code. Must be a valid subaccount in General Ledger.AP00.4, AP05.7
DSC-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1Indicates the status of the discount code. Valid values are:
  • A Active.
  • I Inactive.
AP00.4, AP05.7
DSC-USED-FLAG
USED_FLAG
Alpha 1Indicates whether the discount code has been used.AP05.7, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP21.1 +9 more
DSC-DISC-POINT
DISC_POINT
Numeric 1This 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. of goods plus the AOC. Blank will be the same as option "T".
  • T Will apply the discount to the Cost
  • 1 C - (Cost of Goods)
  • 2 T - (Total COG & AOC)
AP05.7

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DSCSET1DISCOUNT-CODEPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
DSCSET2COMPANY, DISCOUNT-CODEKeyChangeAP205, AP305

Programs

Updated by (19)

Referenced by (275)