ARUADJUST FILE

The AR Application Adjustment (User Analysis) file connects the user analysis
value to adjustment records created from the cash application process.

UPDATED BY

AR230     AR232     AR233     AR235     AR300     AR31.5
AR31.6    AR35.1    AR35.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AGM-COMPANY          Numeric 4                                   AR230   AR232
Company              The company number represents an            AR233   AR235
                     established company and is entered on       AR300   AR31.5
                     all function codes.                         AR31.6  AR35.1
                                                                 AR35.2

AGM-TRANS-TYPE       Alpha 1                                     AR230   AR232
Transaction Type     Determines if amounts or units are          AR233   AR235
                     processed in each transaction.              AR300   AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2

AGM-TRANS-NBR        Alpha 10  (Right Justified)                 AR230   AR232
Trans Nbr            A unique, user-defined value used to        AR233   AR235
                     identify the transaction.                   AR300   AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2

AGM-PAYMENT-SEQ      Numeric 6                                   AR230   AR232
Payment Seq          Payment Sequence. This is the generated     AR233   AR235
                     sequence number to separate individual      AR300   AR31.5
                     invoice payment requirements.               AR31.6  AR35.1
                                                                 AR35.2

AGM-BATCH-NBR        Numeric 6                                   AR230   AR232
Batch Number         This identifies the batch the entered       AR233   AR235
                     invoices, debit memos, and credit memos     AR300   AR31.5
                     are a part of.                              AR31.6  AR35.1
                                                                 AR35.2

AGM-APP-SEQ          Numeric 5                                   AR230   AR232
App Seq              Application sequence number.                AR233   AR235
                                                                 AR300   AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2

AGM-ADJ-SEQ          Numeric 3                                   AR230   AR232
Adj Seq              The sequence number for the adjustment.     AR233   AR235
                                                                 AR300   AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2

AGM-SEGMENT-BLOCK    Alpha 103                                   AR230   AR232
User Analysis        This field identifies the user analysis     AR233   AR235
                     values included in the transaction.         AR300   AR31.5
                                                                 AR31.6  AR35.1
                     You can either type up to four values       AR35.2
                     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.

                         ARUADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGMSET1   COMPANY       This is the primary index for this file. AR230   AR232
          TRANS-TYPE                                             AR233   AR235
          TRANS-NBR                                              AR300   AR31.5
          PAYMENT-SEQ                                            AR31.6  AR35.1
          BATCH-NBR                                              AR35.2
          APP-SEQ
          ADJ-SEQ

                         ARUADJUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aradjust       ARADJUST     Not Required

                            AGM-COMPANY        -> ADJ-COMPANY
                            AGM-TRANS-TYPE     -> ADJ-TRANS-TYPE
                            AGM-TRANS-NBR      -> ADJ-TRANS-NBR
                            AGM-PAYMENT-SEQ    -> ADJ-PAYMENT-SEQ
                            AGM-BATCH-NBR      -> ADJ-BATCH-NBR
                            AGM-APP-SEQ        -> ADJ-APP-SEQ
                            AGM-ADJ-SEQ        -> ADJ-ADJ-SEQ