APCRMHIST – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
AH6
Primary key
COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR
Fields
9
Updated by
9 programs
Referenced by
0 programs

APCRMHIST is a Lawson Accounts Payable table (prefix AH6); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBR (AH6SET1); alternate indexes: AH6SET2. It is updated by AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP300, AP305 and 1 more. The table has 9 fields, 2 indexes and 0 documented relations.

About APCRMHIST

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
AH6-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
AH6-VENDOR PK
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP198
AH6-CR-MEMO-NBR PK
CR_MEMO_NBR
Alpha 22Used to identify the invoice.AP198
AH6-CR-MEMO-SUFFIX PK
CR_MEMO_SUFFIX
Numeric 3This is the suffix for the invoice.AP198
AH6-CR-SEQ-NBR PK
CR_SEQ_NBR
Numeric 4AP198
AH6-INVOICE PK
INVOICE
Alpha 22Used to identify the invoice.AP198
AH6-SUFFIX PK
SUFFIX
Numeric 3This is the suffix for the invoice.AP198
AH6-SEQ-NBR PK
SEQ_NBR
Numeric 4An automatically assigned sequence number.AP198
AH6-AMT-APPLIED
AMT_APPLIED
Signed 18.2AP198

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AH6SET1COMPANY, VENDOR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBR, INVOICE, SUFFIX, SEQ-NBRPrimaryAP300, AP305
AH6SET2COMPANY, VENDOR, INVOICE, SUFFIX, SEQ-NBR, CR-MEMO-NBR, CR-MEMO-SUFFIX, CR-SEQ-NBRAP180, AP181, AP190, AP28.1, AP28.2, AP300, AP45.1

Programs

Updated by (9)