FTWORK FILE

                                EFT Work

EFT Work

UPDATED BY

AR25.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

FTW-CR-COMPANY       Numeric 4                                   AR25.1
EFT Company          The company which will own the EFT
                     transaction.

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

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

                     C = Credit memo
                     D = Debit memo
                     I = Invoice

FTW-TRANS-NBR        Alpha 10  (Right Justified)                 AR25.1
Transaction Number   A unique, user-defined value used to
                     identify the transaction.

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

FTW-CUST-PO-NBR      Alpha 20                                    AR25.1
Customer PO Number   Customer purchase order number.

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

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

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

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

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

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

FTW-EFT-ACTION       Alpha 1                                     AR25.1
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
Work Record Action   The 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
          TRANS-NBR
          PAYMENT-SEQ