FTCUSTGRP – EFT Customer Group

System
Accounts Receivable (AR)
Prefix
FTG
Primary key
CUST-GROUP, COMPANY, CR-CUSTOMER, CUSTOMER
Fields
4
Updated by
1 program
Referenced by
5 programs

FTCUSTGRP is the EFT Customer Group table in Lawson Accounts Receivable (prefix FTG). It is indexed by CUST-GROUP, COMPANY, CR-CUSTOMER, CUSTOMER (FTGSET1); alternate indexes: FTGSET2. It is updated by AR09.7 and referenced by AR10.1, AR301, AR501, AR550 and TX140. The table has 4 fields, 2 indexes and 0 documented relations.

About FTCUSTGRP

The EFT Customer Group file is used to group customers together at the customer group level for EFT processing.

Fields (4)

Column = COBOL field name without the FTG- 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
#FTG-CUST-GROUP PK
CUST_GROUP		Alpha 5Customer group. Used to identify a group of EFT customer associated with one or more companies.AR09.7
#FTG-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR09.7
#FTG-CR-CUSTOMER PK
CR_CUSTOMER		Alpha 9 (Right Justified)Parent EFT customer.AR09.7
#FTG-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Related customer number to parent customer.AR09.7

Indexes (2)

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
FTGSET1
  1. CUST-GROUP
  2. COMPANY
  3. CR-CUSTOMER
  4. CUSTOMER
PrimaryAR09.5, AR09.7
FTGSET2
  1. CUSTOMER
  2. COMPANY
  3. CUST-GROUP
  4. CR-CUSTOMER
AR09.1, AR09.2, AR09.5, AR09.7, AR10.1, AR301, AR501, AR550 +1 more

Programs

Updated by (1)

Referenced by (5)