FTTRANS – EFT Transaction

System
Accounts Receivable (AR)
Prefix
FTT
Primary key
CUST-GROUP, CR-COMPANY, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, EFT-TYPE, EFT-SEQ
Fields
19
Updated by
0 programs
Referenced by
0 programs

FTTRANS is the EFT Transaction table in Lawson Accounts Receivable (prefix FTT). It is indexed by CUST-GROUP, CR-COMPANY, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, EFT-TYPE, EFT-SEQ (FTTSET1); alternate indexes: FTTSET2. The table has 19 fields, 2 indexes and 0 documented relations.

About FTTRANS

The EFT Transaction file contains the records used in processing EFT transactions.

Fields (19)

Column = COBOL field name without the FTT- 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
#FTT-CUST-GROUP PK
CUST_GROUP		Alpha 5Customer group. Used to identify a group of customer associated with one or more companies.—
#FTT-CR-COMPANY PK
CR_COMPANY		Numeric 4This is the company number that represents the processing company of an EFT transaction.—
#FTT-COMPANY PK
COMPANY		Numeric 4The company that owns the open item transaction.—
#FTT-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Transaction type. Valid values are
  • C Credit memo
  • D Debit memo
  • I Invoice
—
#FTT-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.—
#FTT-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.—
#FTT-EFT-TYPE PK
EFT_TYPE		Alpha 1This is the type of EFT transaction. Valid values are
  • A Adjusted
  • D Extracted
  • N Final Note
  • P Prenote
—
#FTT-EFT-SEQ PK
EFT_SEQ		Numeric 6Used to keep EFT transaction records unique.—
#FTT-CR-CUSTOMER SET2
CR_CUSTOMER		Alpha 9 (Right Justified)The customer which owns the EFT transaction.—
#FTT-PROCESS-DATE
PROCESS_DATE		Numeric 8 (yyyymmdd)The date the EFT transaction was generated.—
#FTT-EFT-DATE
EFT_DATE		Numeric 8 (yyyymmdd)The date the funds will be drawn from the customer's bank account.—
#FTT-NET-AMT
NET_AMT		Signed 18.2The amount of the EFT transaction.—
#FTT-BANK-ENTITY
BANK_ENTITY		Alpha 15Represents a bank institution location.—
#FTT-BANK-ACCT-NBR
BANK_ACCT_NBR		Alpha 35The bank-assigned account number identification to be used for the cash code.—
#FTT-EFT-NOTE
EFT_NOTE		Numeric 1Indicates the status of the EFT note. Valid values are
  • 0 Prenote not sent
  • 1 Prenote sent
  • 2 Final note sent
  • 9 Not printed
—
#FTT-EFT-EXTRACT
EFT_EXTRACT		Numeric 1Indicates the status of the EFT extraction. Valid values are
  • 0 Not extracted
  • 8 Adjustment made
  • 9 Extracted
—
#FTT-EFT-ACTION
EFT_ACTION		Alpha 1Indicates the status of the EFT transaction. Valid values are
  • Blank Not in due date range
  • 0 Eligible
  • 1 Added
  • 2 Postponed
  • 3 Deleted
  • 5 Added Postponed
  • 6 Hold
—
#FTT-EFT-CREATED
EFT_CREATED		Alpha 1Indicates if the EFT transaction has been generated. Valid values are
  • N EFT not created
  • Y EFT created
—
#FTT-TEMP-HOLD
TEMP_HOLD		Alpha 1—
  • A Approved by Engine
  • S Sent for Approval
—

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
FTTSET1
  1. CUST-GROUP
  2. CR-COMPANY
  3. COMPANY
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. EFT-TYPE
  8. EFT-SEQ
PrimaryAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
FTTSET2
  1. CUST-GROUP
  2. CR-COMPANY
  3. CR-CUSTOMER
  4. COMPANY
  5. TRANS-TYPE
  6. INVOICE
  7. PAYMENT-SEQ
  8. EFT-TYPE
  9. EFT-SEQ
—

Programs

No Lawson programs are documented as updating or referencing this table.