ARUSADJUST FILE

The Cash Application Adjustment Select (User Analysis) file connectsuser
analysis values to adjustment information for open items that have been
selected for cash application, but not yet processed into adjustment records.

UPDATED BY

AR31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SGM-COMPANY          Numeric 4                                   AR31.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SGM-TRANS-TYPE       Alpha 1                                     AR31.1
Transaction Type     Determines if amounts or units are
                     processed in each transaction.


SGM-TRANS-NBR        Alpha 10  (Right Justified)                 AR31.1
Trans Nbr            A unique, user-defined value used to
                     identify the transaction.

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

SGM-ADJ-SEQ          Numeric 3                                   AR31.1
Adj Seq              Adjustment sequence number.

SGM-SEGMENT-BLOCK    Alpha 103                                   AR31.1
User Analysis        This field identifies the user analysis
                     values included in the transaction.

                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     to select the user analysis values you
                     want to include in the transaction. If
                     you choose to type values, use commas to
                     separate them. For example:
                     value1,value2,value3,value4

                     There are three conditions that affect
                     how you can select user analysis values.
                     See the User Analysis Entry form help or
                     the Strategic Ledger procedures manual
                     for additional information.

                         ARUSADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGMSET1   COMPANY       This is the primary index for this file. AR31.1
          TRANS-TYPE
          TRANS-NBR
          PAYMENT-SEQ
          ADJ-SEQ

                         ARUSADJUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arsadjust      ARSADJUST    Not Required

                            SGM-COMPANY        -> ASJ-COMPANY
                            SGM-TRANS-TYPE     -> ASJ-TRANS-TYPE
                            SGM-TRANS-NBR      -> ASJ-TRANS-NBR
                            SGM-PAYMENT-SEQ    -> ASJ-PAYMENT-SEQ
                            SGM-ADJ-SEQ        -> ASJ-ADJ-SEQ