FTCUSTNOTE – EFT Customer Notification

System
Accounts Receivable (AR)
Prefix
FTN
Primary key
CUST-GROUP, COMPANY, CUSTOMER
Fields
9
Updated by
7 programs
Referenced by
0 programs

FTCUSTNOTE is the EFT Customer Notification table in Lawson Accounts Receivable (prefix FTN). It is indexed by CUST-GROUP, COMPANY, CUSTOMER (FTNSET1). It is updated by AR09.1, AR09.5, AR10.1, AR301, AR501, AR550 and TX140. The table has 9 fields, 1 index and 0 documented relations.

About FTCUSTNOTE

No description in the Lawson data dictionary.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
FTN-CUST-GROUP PK
CUST_GROUP		Alpha 5This is a valid customer group set up in the Lawson AR system.AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-PRE-NOTE
PRE_NOTE		Alpha 1Indicates if customers are pre notified of EFT transactions. Valid values are:
  • N No
  • Y Yes
  • E Exempt
AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-NOTE-METH
NOTE_METH		Alpha 1Indicated the method used to deliver a pre or final EFT notification to a customer. Valid values are:
  • A Alternate EDI
  • E EDI
  • F Fax
AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-ADJ-NOTE-METH
ADJ_NOTE_METH		Alpha 1The method to be used to deliver the EFT adjustment note to the customer. Valid values are:
  • A Alternate EDI
  • E EDI
  • F Fax
AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-USER1-FIELD
USER1_FIELD		Alpha 5This is first user defined field.AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-USER2-FIELD
USER2_FIELD		Alpha 10This is the second user defined field.AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140
FTN-PAYMENT-FORMAT
PAYMENT_FORMAT		Alpha 1Determines the format of the file output for EFT transactions. Valid values are:
  • A ACH format
  • B BACS
  • N Non formatted
  • S SEPA
AR09.1, AR09.5, AR10.1, AR301, AR501, AR550, TX140

Indexes (1)

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

IndexKeysFlagsConditionUsed in
FTNSET1CUST-GROUP, COMPANY, CUSTOMERPrimaryAR09.1, AR09.2, AR09.5, AR09.7, AR10.1, AR301, AR501, AR550 +1 more

Programs

Updated by (7)