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.

Field / column	Type	Description & values	Updated by
`FTT-CUST-GROUP` PK CUST_GROUP	Alpha 5	Customer group. Used to identify a group of customer associated with one or more companies.	—
`FTT-CR-COMPANY` PK CR_COMPANY	Numeric 4	This is the company number that represents the processing company of an EFT transaction.	—
`FTT-COMPANY` PK COMPANY	Numeric 4	The company that owns the open item transaction.	—
`FTT-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	Transaction type. Valid values are `C` Credit memo `D` Debit memo `I` Invoice	—
`FTT-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	—
`FTT-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	—
`FTT-EFT-TYPE` PK EFT_TYPE	Alpha 1	This 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 6	Used to keep EFT transaction records unique.	—
`FTT-CR-CUSTOMER` 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.2	The amount of the EFT transaction.	—
`FTT-BANK-ENTITY` BANK_ENTITY	Alpha 15	Represents a bank institution location.	—
`FTT-BANK-ACCT-NBR` BANK_ACCT_NBR	Alpha 35	The bank-assigned account number identification to be used for the cash code.	—
`FTT-EFT-NOTE` EFT_NOTE	Numeric 1	Indicates 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 1	Indicates the status of the EFT extraction. Valid values are `0` Not extracted `8` Adjustment made `9` Extracted	—
`FTT-EFT-ACTION` EFT_ACTION	Alpha 1	Indicates 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 1	Indicates 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`FTTSET1`	`CUST-GROUP`, `CR-COMPANY`, `COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `EFT-TYPE`, `EFT-SEQ`	Primary		AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
`FTTSET2`	`CUST-GROUP`, `CR-COMPANY`, `CR-CUSTOMER`, `COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `EFT-TYPE`, `EFT-SEQ`			—

Programs

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