Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FTWORK


                              FTWORK FILE

                                EFT Work

The EFT Work file is the work file used during EFT adjustment processing.
Records in this file have been created by actions within AR25 EFT Adjustments.

UPDATED BY

AR115     AR25.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FTW-CUST-GROUP         Alpha 5                                   AR25.1
Element: Customer GroupCustomer group. Used to identify a
                       group of customer associated with one or
                       more companies.

FTW-CR-COMPANY         Numeric 4                                 AR25.1
Element: EFT Company   This is the company number that
                       represents the processing company of an
                       EFT transaction.

FTW-COMPANY            Numeric 4                                 AR25.1
Element: Company       The company which owns the open item
                       transaction.

FTW-TRANS-TYPE         Alpha 1                                   AR25.1
Element: Transaction TyIndicates the transaction type. Valid
                       values are:

                       C = Credit memo
                       D = Debit memo
                       I = Invoice

FTW-INVOICE            Alpha 22                                  AR25.1
Element: Invoice       Used to identify the invoice.

FTW-PAYMENT-SEQ        Numeric 6                                 AR25.1
Element: Payment SequenA unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

FTW-CUST-PO-NBR        Alpha 22                                  AR25.1
Element: Customer PO NuCustomer purchase order number.

FTW-TRANS-USER1        Alpha 10                                  AR25.1
Element: Trans User1   This the customer defined user one
                       field from the open item header file.

FTW-NET-AMT            Signed 18.2                               AR25.1
Element: EFT Amount    The net amount of the EFT transaction.

FTW-PROCESS-LEVEL      Alpha 5                                   AR25.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

FTW-TRAN-DATE          Numeric 8  (yyyymmdd)                     AR25.1
Element: Tran Date     The date of the transaction.

FTW-DISC-DATE          Numeric 8  (yyyymmdd)                     AR25.1
Element: Date          The discount date of the transaction.

FTW-DUE-DATE           Numeric 8  (yyyymmdd)                     AR25.1
Element: Due Date      The due date of the transaction.

FTW-EFT-ACTION         Alpha 1                                   AR25.1
Element: EFT Action    The EFT action taken on the
                       transaction. Valid values are:

                       Blank = Not within due date range
                       0 = Eligible
                       1 = Added
                       2 = Postponed
                       3 = Deleted
                       5 = Added Postponed
                       6 = Hold

FTW-EFT-NOTE           Numeric 1                                 AR25.1
EFT Notification       Indicates if the prenote or the final
Status                 note has been sent. Valid values are:

                       1 = Prenote sent
                       2 = Final note sent

FTW-WORK-ACTION        Alpha 1                                   AR25.1
Element: Work Record AcThe action that will be taken with this
                       work record. Valid values are:

                       A = Add
                       C = Hold
                       D = Delete
                       P = Postpone

                         FTWORK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FTWSET1   CUST-GROUP                                             AR115   AR25.1
          CR-COMPANY
          COMPANY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ