Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARSAPPLIED FILE

                        Cash Application Select

The Cash Application Select file contains the cash application select records
that have been selected but not yet processed into application records.

REFERENCED BY

AR124     AR129     AR135     AR199     AR24.1    AR29.1
AR29.2    AR29.3    AR31.1    AR48.1    AR570     AR575
AR580     AR82.1    CB191     AR131     AR42.6    AR230

UPDATED BY

AR115     AR130     AR20.1    AR21.1    AR21.2    AR21.3
AR30.1    AR30.2    AR30.3    AR30.4    AR30.6    AR30.9
CB06.2    DT520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ASG-CR-COMPANY       Numeric 4                                   AR115   AR30.1
Payment Company      The payment company number.                 AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-CR-BATCH         Numeric 6                                   AR115   AR30.1
Payment Batch        The batch of the payment.                   AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-CR-PYMNT-SEQ     Numeric 6                                   AR115   AR30.1
Payment Sequence     The sequence number of the payment.         AR30.2  AR30.3
Number                                                           AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-COMPANY          Numeric 4                                   AR115   AR30.1
Company              The company number of the transaction.      AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-TRANS-TYPE       Alpha 1                                     AR115   AR30.1
Transaction Type     The transaction type associated with        AR30.2  AR30.3
                     the selected application. Valid values      AR30.4  AR30.6
                     are:                                        AR30.9  DT520

                     C = Credit Memo
                     D = Debit Memo
                     I = Invoice
                     P = Payment

ASG-INVOICE          Alpha 22                                    AR115   AR30.1
Invoice Number       Used to identify the invoice.               AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-PAYMENT-SEQ      Numeric 6                                   AR115   AR30.1
Payment Sequence     Payment Sequence. This is the generated     AR30.2  AR30.3
                     sequence number to separate individual      AR30.4  AR30.6
                     invoice payment requirements.               AR30.9  DT520


ASG-OPEN-AMT         Signed 15.2                                 AR115   AR30.1
Open Amount          The open amount of the transaction.         AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9

ASG-ORIG-OPEN-AMT    Signed 15.2                                 AR30.1  AR30.2
Original Open Amount The open amount in transaction              AR30.3  AR30.4
                     currency.                                   AR30.6  AR30.9

ASG-CR-ORIG-AP-AMT   Signed 15.2                                 AR115   AR30.1
Cr Orig Ap Amt       The amount of the application in the        AR30.2  AR30.3
                     payment currency.                           AR30.4  AR30.6
                                                                 AR30.9  AR31.1
                                                                 DT520

ASG-ADJ-SEQ          Numeric 3                                   AR115   AR30.1
Adjustment Sequence  The sequence number of the adjustment.      AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9  DT520

ASG-GL-DATE          Numeric 8  (yyyymmdd)                       AR115   AR30.1
Posting Date         This field contains the date the            AR30.2  AR30.3
                     applications will be posted to the          AR30.4  AR30.6
                     general ledger.                             AR30.9  DT520

ASG-OPR-CODE         Alpha 10  (Lower Case)                      AR115   AR30.1
Operator Code        This field contains the operator code.      AR30.2  AR30.3
                     This is the user ID of the person who       AR30.4  AR30.6
                     last maintained this record.                AR30.9  DT520

ASG-EFT-FL           Alpha 1                                     AR115   AR30.1
EFT Application      Indicates if the open amount was            AR30.2  AR30.4
                     selected for application during EFT         AR30.6  AR30.9
                     processing. Valid values are:               DT520

                     Y = Record was written from EFT
                     processing
                     N = Record was written from online
                     processing

ASG-SELECT-SEQ       Numeric 6                                   AR115   AR30.1
Select Seq                                                       AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.9

                         ARSAPPLIED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASGSET1   CR-COMPANY    This path is used for record uniqueness. AR124   AR129
          CR-BATCH                                               AR130   AR135
          CR-PYMNT-SEQ                                           AR199   AR20.1
          COMPANY                                                AR21.1  AR21.2
          TRANS-TYPE                                             AR21.3  AR24.1
          INVOICE                                                AR29.1  AR29.2
          PAYMENT-SEQ                                            AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.6  AR30.7
                                                                 AR30.9  AR31.1
                                                                 AR48.1  AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB06.2
                                                                 CB191

ASGSET2   COMPANY       This path is used to select a            AR115   AR130
          TRANS-TYPE    transaction's application select         AR131   AR135
          INVOICE       records.                                 AR29.3  AR30.1
          PAYMENT-SEQ                                            AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.8  AR30.9
                                                                 AR42.6  AR48.1

ASGSET3   CR-COMPANY                                             AR230
          CR-BATCH
          CR-PYMNT-SEQ
          SELECT-SEQ

                         ARSAPPLIED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aroitems       AROITEMS     Required

                            ASG-COMPANY         -> ARO-COMPANY
                            ASG-TRANS-TYPE      -> ARO-TRANS-TYPE
                            ASG-INVOICE         -> ARO-INVOICE
                            ASG-PAYMENT-SEQ     -> ARO-PAYMENT-SEQ

Arpayment      ARPAYMENT    Required

                            ASG-CR-COMPANY      -> APM-COMPANY
                            ASG-CR-BATCH        -> APM-BATCH-NBR
                            ASG-CR-PYMNT-SEQ    -> APM-PAYMENT-SEQ

                         ARSAPPLIED FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arsadjust      ARSADJUST    Delete Cascades

                            ASG-COMPANY         -> ASJ-COMPANY
                            ASG-TRANS-TYPE      -> ASJ-TRANS-TYPE
                            ASG-INVOICE         -> ASJ-INVOICE
                            ASG-PAYMENT-SEQ     -> ASJ-PAYMENT-SEQ
                                                   ASJ-ADJ-SEQ