APELECTID – Electronic Transfer ID

System
Accounts Payable (AP)
Prefix
APE
Primary key
PAY-GROUP, BANK-INST-CODE
Fields
8
Updated by
2 programs
Referenced by
2 programs

APELECTID is the Electronic Transfer ID table in Lawson Accounts Payable (prefix APE). It is indexed by PAY-GROUP, BANK-INST-CODE (APESET1). It is updated by AP01.3 and AP161 and referenced by AP160 and ZA161. The table has 8 fields, 1 index and 0 documented relations.

About APELECTID

The Electronic Transfer ID file contains electronic transfer identification records for pay groups that create payment tapes or electronic payment file, such as the Automatic Clearing House (ACH), Bankers Automated Clearing System (BACS), or Electronic Data Interchange (EDI) 820 format.

Fields (8)

Column = COBOL field name without the APE- 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
#APE-PAY-GROUP PK
PAY_GROUP
Alpha 4The pay group associated with the Electronic Transfer ID record. A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.AP01.3
#APE-BANK-INST-CODE PK
BANK_INST_CODE
Alpha 3A transaction code used to create electronic format payments for the pay group. Must be a valid cash payment transaction code in the Transaction Code file.AP01.3
#APE-ELEC-TRANS-ID
ELEC_TRANS_ID
Alpha 18The electronic transfer identification number associated with the cash payment transaction code.AP01.3
#APE-SEQ-NBR
SEQ_NBR
Numeric 6—AP161
#APE-LAST-SEQ-NBR
LAST_SEQ_NBR
Numeric 6——
#APE-SEQ-CTR
SEQ_CTR
Numeric 5—AP161
#APE-LAST-RUN-DATE
LAST_RUN_DATE
Numeric 8 (yyyymmdd)—AP161
#APE-ORG-IDENTIFIER
ORG_IDENTIFIER
Alpha 15—AP01.3, AP161

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
APESET1
  1. PAY-GROUP
  2. BANK-INST-CODE
PrimaryAP01.3, AP160, AP161, ZA161

Programs

Updated by (2)

Referenced by (2)