EFT Transaction

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

REFERENCED BY

AR09.1	AR09.4	AR10.1	AR11.1	AR12.1	AR12.2
AR13.1	AR13.2	AR210	AR301	AR501	AR550
ARLL.1	CB06.2	CB191	TX140

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
FTT-CUST-GROUP Element: Customer Group	Alpha 5 Customer group. Used to identify a group of customer associated with one or more companies.
FTT-CR-COMPANY Element: EFT Company	Numeric 4 This is the company number that represents the processing company of an EFT transaction.
FTT-COMPANY Element: Company	Numeric 4 The company that owns the open item transaction.
FTT-TRANS-TYPE Element: Trans Type	Alpha 1 Transaction type. Valid values are C = Credit memo D = Debit memo I = Invoice
FTT-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.
FTT-PAYMENT-SEQ Element: Payment Sequence	Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system.
FTT-EFT-TYPE Element: 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 Element: EFT Sequence Number	Numeric 6 Used to keep EFT transaction records unique.
FTT-CR-CUSTOMER Element: EFT Customer	Alpha 9 (Right Justified) The customer which owns the EFT transaction.
FTT-PROCESS-DATE Element: EFT Processing Date	Numeric 8 (yyyymmdd) The date the EFT transaction was generated.
FTT-EFT-DATE Element: EFT Date	Numeric 8 (yyyymmdd) The date the funds will be drawn from the customer's bank account.
FTT-NET-AMT Element: EFT Amount	Signed 18.2 The amount of the EFT transaction.
FTT-BANK-ENTITY Element: Bank Entity	Alpha 15 Represents a bank institution location.
FTT-BANK-ACCT-NBR Element: Bank Acct Nbr	Alpha 35 The bank-assigned account number identification to be used for the cash code.
FTT-EFT-NOTE Element: EFT Note Status	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 Element: EFT Extract Status	Numeric 1 Indicates the status of the EFT extraction. Valid values are 0 = Not extracted 8 = Adjustment made 9 = Extracted
FTT-EFT-ACTION EFT Transaction Status	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 Generation Status	Alpha 1 Indicates if the EFT transaction has been generated. Valid values are N = EFT not created Y = EFT created
FTT-TEMP-HOLD Element: Temp Hold	Alpha 1 A = Approved by Engine S = Sent for Approval

FTTRANS FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.