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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FTGSET1CUST-GROUP, COMPANY, CR-CUSTOMER, CUSTOMERPrimaryAR09.5, AR09.7
FTGSET2CUSTOMER, COMPANY, CUST-GROUP, CR-CUSTOMERAR09.1, AR09.2, AR09.5, AR09.7, AR10.1, AR301, AR501, AR550 +1 more

Programs

Updated by (1)

Referenced by (5)