Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARSAPPLIED


                            ARSAPPLIED FILE

                        Cash Application Select

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

REFERENCED BY

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

UPDATED BY

AR115     AR130     AR20.1    AR21.1    AR21.2    AR21.3
AR30.1    AR30.2    AR30.6    AR30.8    AR32.1    AR32.3
AR33.1    AR33.3    AR34.1    AR34.2    CB06.2    DT520


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ASG-CR-COMPANY         Numeric 4                                 AR115   AR30.1
Element: Payment CompanThe number representing an AR company.    AR30.2  AR30.6
                                                                 AR32.1  AR33.1
                                                                 AR34.1  DT520

ASG-CR-BATCH           Numeric 6                                 AR115   AR30.1
Element: Payment Batch The batch of the payment.                 AR30.2  AR30.6
                                                                 AR32.1  AR33.1
                                                                 AR34.1  DT520

ASG-CR-PYMNT-SEQ       Numeric 6                                 AR115   AR30.1
Payment Sequence       The sequence number of the payment.       AR30.2  AR30.6
Number                                                           AR32.1  AR33.1
                                                                 AR34.1  DT520

ASG-COMPANY            Numeric 4                                 AR115   AR30.1
Element: Company       The company number of the transaction.    AR30.2  AR30.6
                                                                 AR32.1  AR33.1
                                                                 AR34.1  DT520

ASG-TRANS-TYPE         Alpha 1                                   AR115   AR30.1
Element: Trans Type    The transaction type associated with      AR30.2  AR30.6
                       the selected application. Valid values    AR32.1  AR33.1
                       are:                                      AR34.1  DT520

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

ASG-INVOICE            Alpha 22                                  AR115   AR30.1
Element: Invoice       Used to identify the invoice.             AR30.2  AR30.6
                                                                 AR32.1  AR33.1
                                                                 AR34.1  DT520

ASG-PAYMENT-SEQ        Numeric 6                                 AR115   AR30.1
Element: Payment SequenA unique number assigned to each          AR30.2  AR30.6
                       transaction to be interfaced into the     AR32.1  AR33.1
                       Lawson system.                            AR34.1  DT520

ASG-OPEN-AMT           Signed 18.2                               AR115   AR30.1
Element: Open Amount   The open amount of the transaction.       AR30.2  AR30.6
                                                                 AR30.8  AR32.1
                                                                 AR32.3  AR33.1
                                                                 AR33.3  AR34.1
                                                                 AR34.2

ASG-ORIG-OPEN-AMT      Signed 18.2                               AR30.1  AR30.2
Element: Original Open The open amount in transaction            AR30.6  AR32.1
                       currency.                                 AR32.3  AR33.1
                                                                 AR34.1  AR34.2

ASG-CR-ORIG-AP-AMT     Signed 18.2                               AR115   AR30.1
Element: Intl Amt      The amount of the application in the      AR30.2  AR30.3
                       payment currency.                         AR30.6  AR32.1
                                                                 AR32.3  AR33.1
                                                                 AR34.1  AR34.2
                                                                 AR34.4  DT520

ASG-ADJ-SEQ            Numeric 3                                 AR115   AR30.1
Element: Adjustment SeqThe sequence number of the adjustment.    AR30.2  AR30.6
                                                                 AR32.1  AR32.3
                                                                 AR33.1  AR34.1
                                                                 AR34.2  DT520

ASG-GL-DATE            Numeric 8  (yyyymmdd)                     AR115   AR30.1
Element: Posting Date  This field contains the date the          AR30.2  AR30.6
                       applications will be posted to the        AR32.1  AR33.1
                       general ledger.                           AR34.1  DT520

ASG-OPR-CODE           Alpha 10  (Lower Case)                    AR115   AR30.1
Element: Opr Code      This field contains the operator code.    AR30.2  AR30.6
                       This is the user ID of the person who     AR32.1  AR33.1
                       last maintained this record.              AR34.1  DT520

ASG-EFT-FL             Alpha 1                                   AR115   AR30.1
Element: EFT ApplicatioIndicates if the open amount was          AR30.2  AR32.1
                       selected for application during EFT       AR34.1  DT520
                       processing. Valid values are:

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

ASG-SELECT-SEQ         Numeric 6                                 AR115   AR30.1
Element: Select Seq    The payment application order.            AR30.2  AR30.6
                                                                 AR32.1  AR33.1
                                                                 AR34.1

                         ARSAPPLIED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASGSET1   CR-COMPANY                                             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.6
                                                                 AR30.7  AR30.8
                                                                 AR32.1  AR33.1
                                                                 AR33.3  AR33.6
                                                                 AR34.1  AR34.3
                                                                 AR34.4  AR48.1
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 ...

ASGSET2   COMPANY                                                AR115   AR130
          TRANS-TYPE                                             AR131   AR135
          INVOICE                                                AR251   AR29.3
          PAYMENT-SEQ                                            AR30.1  AR30.2
                                                                 AR30.6  AR30.8
                                                                 AR32.1  AR32.3
                                                                 AR33.1  AR33.3
                                                                 AR34.1  AR34.2
                                                                 AR38.1  AR38.2
                                                                 AR38.3  AR39.1
                                                                 AR42.6  AR48.1
                                                                 AR91.1

ASGSET3   CR-COMPANY                                             AR230   AR251
          CR-BATCH                                               AR91.1
          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