APDISCACC – Discount

System
Accounts Payable (AP)
Prefix
DSK
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPE
Fields
19
Updated by
16 programs
Referenced by
3 programs

APDISCACC is the Discount table in Lawson Accounts Payable (prefix DSK). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPE (DSKSET1); alternate indexes: DSKSET2 and DSKSET3. It is related 1:1 to APINVOICE and APPAYMENT. It is updated by AP115, AP176, AP177, AP180, AP181, AP190, AP195, AP198 and 8 more and referenced by AP136, AP232 and MA01.1. The table has 19 fields, 3 indexes and 2 documented relations.

About APDISCACC

The Accounts Payable Discount

Fields (19)

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

Field / columnTypeDescription & valuesUpdated by
DSK-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-INVOICE PK
INVOICE		Alpha 22Invoice number.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-SUFFIX PK
SUFFIX		Numeric 3The invoice suffix.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1, MA70.1 +1 more
DSK-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-VOID-SEQ PK
VOID_SEQ		Numeric 4The sequence number assigned to voided payments.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)The date general ledger entries for the transaction will be posted to the general ledger.AP180, AP181, AP190, AP195, AP28.1, AP28.2, AP45.1, APDS.1
DSK-TRAN-DISC-AMT
TRAN_DISC_AMT		Signed 18.2The discount amount in the currency of the transaction.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-BASE-DISC-AMT
BASE_DISC_AMT		Signed 18.2The discount amount in company base currency.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-DISC-TYPE PK
DISC_TYPE		Alpha 1Indicates the discount type. Valid values are:
  • M Match
  • R Reverse
AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-STATUS
STATUS		Numeric 1The transaction status. Valid values are:
  • 1 Open
  • 2 Posted
AP176, AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1 +2 more
DSK-GLT-OBJ-ID
GLT_OBJ_ID		Numeric 12This 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.AP176, AP180, AP181, AP190, AP28.1, AP28.2, AP45.1, APDS.1
DSK-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.AP180, AP181, AP190, AP28.1, AP28.2, AP45.1
DSK-API-OBJ-ID
API_OBJ_ID		Numeric 12This 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
TRAN_BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
DSK-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.—
DSK-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1—AP176, AP177

Indexes (3)

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

IndexKeysFlagsConditionUsed in
DSKSET1COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPEPrimaryAP115, AP136, AP176, AP190, AP195, AP198, AP232, AP300 +4 more
DSKSET2STATUS, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQKeyChangeAP176, AP195, MA01.1
DSKSET3COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPESubsetWhere (PULL-FOR-FR-FL = "Y")AP177

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ApinvoiceAPINVOICERequiredDSK-COMPANY → API-COMPANY, DSK-VENDOR → API-VENDOR, DSK-INVOICE → API-INVOICE, DSK-SUFFIX → API-SUFFIX, DSK-CANCEL-SEQ → API-CANCEL-SEQ
AppaymentAPPAYMENTNot RequiredDSK-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

Programs

Updated by (16)

Referenced by (3)