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 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.6    AR33.1    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 payment company number.               AR30.2  AR30.6
                                                                 AR33.1  AR34.1
                                                                 AR34.2  DT520

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

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

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

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

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

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

ASG-PAYMENT-SEQ        Numeric 6                                 AR115   AR30.1
Element: Payment SequenPayment Sequence. This is the generated   AR30.2  AR30.6
                       sequence number to separate individual    AR33.1  AR34.1
                       invoice payment requirements.             AR34.2  DT520


ASG-OPEN-AMT           Signed 18.2                               AR115   AR30.1
Element: Open Amount   The open amount of the transaction.       AR30.2  AR30.6
                                                                 AR33.1  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  AR33.1
                       currency.                                 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  AR31.1
                                                                 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
                                                                 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        AR33.1  AR34.1
                       general ledger.                           AR34.2  DT520

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

ASG-EFT-FL             Alpha 1                                   AR115   AR30.1
Element: EFT ApplicatioIndicates if the open amount was          AR30.2  AR30.6
                       selected for application during EFT       AR34.1  AR34.2
                       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
Element: Select Seq                                              AR30.2  AR30.6
                                                                 AR33.1  AR34.1
                                                                 AR34.2

                         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.6
                                                                 AR30.7  AR31.1
                                                                 AR33.1  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4  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.6
                                                                 AR30.8  AR33.1
                                                                 AR33.3  AR34.1
                                                                 AR34.2  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