APRECON – Invoice Accrual Reconciliation

System
Accounts Payable (AP)
Prefix
APN
Primary key
COMPANY, RECON-DATE, ACCR-CODE, INV-CURRENCY
Fields
5
Updated by
2 programs
Referenced by
0 programs

APRECON is the Invoice Accrual Reconciliation table in Lawson Accounts Payable (prefix APN). It is indexed by COMPANY, RECON-DATE, ACCR-CODE, INV-CURRENCY (APNSET1); alternate indexes: APNSET3 and APNSET4. It is updated by AP136 and AP232. The table has 5 fields, 3 indexes and 0 documented relations.

About APRECON

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the APN- 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
#APN-COMPANY PK
COMPANY		Numeric 4The accounts payable company number used to run AP260 (Invoice Accrual Reconciliation). Must be a valid record in the Accounts Payable Company file.AP136, AP232
#APN-RECON-DATE PK
RECON_DATE		Numeric 8 (yyyymmdd)The reconciliation date used to run AP260 (Invoice Accrual Reconciliation) for the company.AP136, AP232
#APN-ACCR-CODE PK
ACCR_CODE		Alpha 4A user-defined code representing a general ledger accrual account.AP136, AP232
#APN-INV-CURRENCY PK
INV_CURRENCY		Alpha 5—AP136, AP232
#APN-REPORT-TOTAL
REPORT_TOTAL		Signed 18.2—AP136

Indexes (3)

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
APNSET1
  1. COMPANY
  2. RECON-DATE
  3. ACCR-CODE
  4. INV-CURRENCY
PrimaryAP136, AP232
APNSET3
  1. COMPANY
  2. RECON-DATE
  3. ACCR-CODE
KeyChange, SubsetWhere (INV-CURRENCY = Spaces)AP232
APNSET4
  1. COMPANY
  2. RECON-DATE
  3. INV-CURRENCY
KeyChange, SubsetWhere (ACCR-CODE = Spaces)AP232

Programs

Updated by (2)