Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FTTRANS


                              FTTRANS FILE

                            EFT Transaction

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

UPDATED BY

AR100     AR105     AR110     AR115     AR180     AR25.1
AR300     AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FTT-CUST-GROUP         Alpha 5                                   AR100   AR110
Element: Customer Group

FTT-CR-COMPANY         Numeric 4                                 AR100   AR110
Element: EFT Company   This is the company that owns the EFT
                       transaction.

FTT-COMPANY            Numeric 4                                 AR100   AR110
Element: Company       The company that owns the open item.

FTT-TRANS-TYPE         Alpha 1                                   AR100   AR110
Element: Transaction TyTransaction type. Valid values are

                       C = Credit memo
                       D = Debit memo
                       I = Invoice

FTT-INVOICE            Alpha 22                                  AR100   AR110
Element: Invoice NumberUsed to identify the invoice.

FTT-PAYMENT-SEQ        Numeric 6                                 AR100   AR110
Element: Payment Sequence

FTT-EFT-TYPE           Alpha 1                                   AR100   AR110
Element: EFT Type      This is the type of EFT transaction.
                       Valid values are

                       A = Adjusted
                       D = Extracted
                       N = Final Note
                       P = Prenote

FTT-EFT-SEQ            Numeric 6                                 AR100   AR110
Element: EFT Sequence NUsed to keep EFT transaction records
                       unique.

FTT-CR-CUSTOMER        Alpha 9  (Right Justified)                AR100   AR110
Element: EFT Customer  The customer which owns the EFT
                       transaction.

FTT-PROCESS-DATE       Numeric 8  (yyyymmdd)                     AR100   AR110
Element: EFT ProcessingThe date the EFT transaction was
                       generated.

FTT-EFT-DATE           Numeric 8  (yyyymmdd)                     AR100   AR110
Element: EFT Date      The date the funds will be drawn from
                       the customer's bank account.

FTT-NET-AMT            Signed 15.2                               AR100   AR110
Element: EFT Amount    The amount of the EFT transaction.

FTT-BANK-ENTITY        Alpha 15                                  AR100   AR110
Element: Bank          Represents a bank institution location.

FTT-BANK-ACCT-NBR      Alpha 17                                  AR100   AR110
Element: Bank Account NThe bank-assigned account number
                       identification to be used for the cash
                       code.

FTT-EFT-NOTE           Numeric 1                                 AR100   AR105
Element: EFT Note StatuIndicates the status of the EFT note.     AR110
                       Valid values are

                       0 = Prenote not sent
                       1 = Prenote sent
                       2 = Final note sent
                       9 = Not printed

FTT-EFT-EXTRACT        Numeric 1                                 AR100   AR110
Element: EFT Extract StIndicates the status of the EFT
                       extraction. Valid values are

                       0 = Not extracted
                       8 = Adjustment made
                       9 = Extracted

FTT-EFT-ACTION         Alpha 1                                   AR100   AR110
EFT Transaction        Indicates the status of the EFT
Status                 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        Alpha 1                                   AR100   AR110
EFT Generation         Indicates if the EFT transaction has      AR115
Status                 been generated. Valid values are

                       N = EFT not created
                       Y = EFT created

                         FTTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FTTSET1   CUST-GROUP    This path is used for record uniqueness. AR105   AR110
          CR-COMPANY                                             AR180   AR25.1
          COMPANY                                                AR300   AR37.1
          TRANS-TYPE                                             AR37.2  AR37.3
          INVOICE                                                AR37.4  AR37.5
          PAYMENT-SEQ                                            AR37.6  AR37.7
          EFT-TYPE
          EFT-SEQ

FTTSET2   CUST-GROUP    This path is used to select EFT records  AR115
          CR-COMPANY    for a customer at a company level.
          CR-CUSTOMER
          COMPANY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          EFT-TYPE
          EFT-SEQ