APDSKHIST – No description in the Lawson data dictionary

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

APDSKHIST is a Lawson Accounts Payable table (prefix AH8); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, SEQ-NBR, VOID-SEQ, DISC-TYPE (AH8SET1). It is updated by AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP300, AP305 and 1 more and referenced by AP136 and AP232. The table has 19 fields, 1 index and 0 documented relations.

About APDSKHIST

No description in the Lawson data dictionary.

Fields (19)

Column = COBOL field name without the AH8- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AH8-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.AP198
#AH8-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP198
#AH8-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AP198
#AH8-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.AP198
#AH8-CANCEL-SEQ PK
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP198
#AH8-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP198
#AH8-VOID-SEQ PK
VOID_SEQ		Numeric 4An automatically assigned sequence number.AP198
#AH8-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)The date general ledger entries for the transaction will be posted to the general ledger.AP198
#AH8-TRAN-DISC-AMT
TRAN_DISC_AMT		Signed 18.2—AP198
#AH8-BASE-DISC-AMT
BASE_DISC_AMT		Signed 18.2—AP198
#AH8-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP198
#AH8-DISC-TYPE PK
DISC_TYPE		Alpha 1—AP198
#AH8-STATUS
STATUS		Numeric 1This field displays the status of the transaction.AP198
#AH8-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.AP198
#AH8-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.AP198
#AH8-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.—
#AH8-TRAN-BASE-ND
TRAN_BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
#AH8-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.—
#AH8-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1——

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AH8SET1
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. CANCEL-SEQ
  6. SEQ-NBR
  7. VOID-SEQ
  8. DISC-TYPE
PrimaryAP136, AP180, AP181, AP190, AP232, AP28.1, AP28.2, AP300 +2 more

Programs

Updated by (9)

Referenced by (2)