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.

UPDATED BY

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   The company which will own the EFT
                       transaction.

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

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 NumberUsed to identify the invoice.

FTW-PAYMENT-SEQ        Numeric 6                                 AR25.1
Element: Payment SequenPayment Sequence. This is the generated
                       sequence number to separate individual
                       invoice payment requirements.


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: Transaction DaThe 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    This is the primary index for the file.  AR25.1
          CR-COMPANY
          COMPANY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ