Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             APAPPHIST FILE

REFERENCED BY

AP260     AP245     AP270     AP93.2    AP265     AP255

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP28.1
AP28.2    AP300     AP45.1    AP305

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AH3-COMPANY          Numeric 4                                   AP198   AP260
Company              The company number represents an
                     established company and is entered on
                     all function codes.


AH3-VENDOR           Alpha 9  (Right Justified)                  AP115   AP198
Vendor ID            The vendor's identification code.           AP260



AH3-INVOICE          Alpha 22                                    AP115   AP198
Invoice Number       Used to identify the invoice.               AP260

AH3-SUFFIX           Numeric 3                                   AP198   AP260
Invoice Suffix       This is the suffix for the invoice.

AH3-CANCEL-SEQ       Numeric 4                                   AP198   AP260
Cancel Sequence      The sequence number assigned upon a
                     cancellation of a distributed invoice.
                     The first sequence assigned is 9999.

AH3-SEQ-NBR          Numeric 4                                   AP198
Sequence Number      An automatically assigned sequence
                     number.

AH3-VOID-SEQ         Numeric 4                                   AP198
Void Sequence

AH3-VOID-DATE        Numeric 8  (yyyymmdd)                       AP198
Void Date

AH3-INV-CURRENCY     Alpha 5                                     AP198
Invoice Currency

AH3-PAY-VENDOR       Alpha 9  (Right Justified)                  AP115   AP198
Paid Vendor

AH3-REMIT-TO-CODE    Alpha 4                                     AP115   AP198
Remit To Location    A user-defined code that represents a
Code                 vendor's remittance address.

AH3-PAY-COMPANY      Numeric 4                                   AP198
Pay Company

AH3-CASH-CODE        Alpha 4                                     AP115   AP198
Cash Code            A cash code represents a bank account.
                     More than one company can use the same
                     cash code.  The cash code must be linked
                     to a bank in the Lawson Cash Ledger
                     system.


AH3-DUE-DATE         Numeric 8  (yyyymmdd)                       AP198
Due Date             The transaction due date.

AH3-ENCLOSURE        Alpha 1                                     AP198
Enclosure

AH3-HOLD-FLAG        Alpha 1                                     AP198
On Hold Flag         This field enables this entire lot to
                     be put on hold, not allowing any issues
                     or transfers to be made for this lot.

AH3-VEN-CLASS        Alpha 3                                     AP115   AP198
Vendor Class         A user-defined code representing a
                     subset of vendors within a vendor group.



AH3-VEN-PRIORITY     Numeric 2                                   AP115   AP198
Vendor Priority      The payment priority of a vendor, where
                     1 = the highest priority and 99 = the
                     lowest.

AH3-PROC-GRP         Alpha 4  (Lower Case)                       AP115   AP198
Process Group        A process group is an identifier used
                     for separating vendors into different
                     groups to enable concurrent processing
                     within the cash payment cycle.

AH3-BASE-PMT-AMT     Signed 15.2                                 AP198
Base Payment Amount  Company base currency payment amount.

AH3-BASE-ACT-AMT     Signed 15.2                                 AP198
Base Amount

AH3-BASE-ND          Numeric 1                                   AP198
Base Number Of       The number of decimal positions defined
Decimals             for the company base currency.

AH3-TRAN-PMT-AMT     Signed 15.2                                 AP198
Payment Amount       Transaction amount of invoices paid in
                     the currency of the invoice.

AH3-TRAN-ND          Numeric 1                                   AP198
Transaction Number   The number of decimal positions defined
of Decimals          for the transaction currency.

AH3-BANK-CHK-AMT     Signed 15.2                                 AP198
Bank Payment Amount

AH3-BANK-ND          Numeric 1                                   AP198
Bank Currency Nbr
of Decimals

AH3-BASE-DISC-AMT    Signed 15.2                                 AP198
Base Discount Amount

AH3-TRAN-DISC-AMT    Signed 15.2                                 AP198
Discount Amount

AH3-BASE-CHK-AMT     Signed 15.2                                 AP198
Base Payment Amount

AH3-TRAN-CHK-AMT     Signed 15.2                                 AP198
Payment Amount

AH3-BASE-INC-WH      Signed 15.2                                 AP198
Base Income Withheld

AH3-TRAN-INC-WH      Signed 15.2                                 AP198
Income Withholding

AH3-TRAN-INC-AMT     Signed 15.2                                 AP198
Income Amount

AH3-GAINLOS-AMT      Signed 15.2                                 AP198
Gain/Loss Amount

AH3-UNRL-REV-DATE    Numeric 8  (yyyymmdd)                       AP198
Last Revaluation
Date

AH3-ACT-CNV-RATE     Signed 12.6                                 AP198
Actual Exchange Rate The currency exchange rate of the
                     transaction.

AH3-DSC-ACCT-UNIT    Alpha 15                                    AP198
Discount Accounting
Unit

AH3-DSC-ACCOUNT      Numeric 6                                   AP198
Discount Account

AH3-DSC-SUB-ACCT     Numeric 4                                   AP198
Discount Subaccount
Number

AH3-DISCOUNT-RT      Percent 5.3  (Percent)                      AP198
Discount Rate

AH3-DISC-DATE        Numeric 8  (yyyymmdd)                       AP198
Discount Date

AH3-TRANS-IDENT      Numeric 10                                  AP198
Trans Ident          A unique system-generated
                     identification value assigned to the
                     transaction to make this record unique.

AH3-ACCR-CODE        Alpha 4                                     AP198
Accrual Code         A user-defined code representing a
                     general ledger accrual account.

AH3-PROC-LEVEL       Alpha 5                                     AP198
Process Level        The process level represents a
                     reporting level below company.

AH3-REC-STATUS       Numeric 1                                   AP198
Record Status        The record status.

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


AH3-CHK-SUFFIX       Numeric 3                                   AP198
Chk Suffix

AH3-BANK-INST-CODE   Alpha 3                                     AP115   AP198
Transaction Code     A transaction code represents a type of
                     cash payment, bill of exchange payment,
                     or bank service transaction.

AH3-CHECK-DATE       Numeric 8  (yyyymmdd)                       AP198
Payment Date         The payment date.

AH3-INCOME-CODE      Alpha 4                                     AP198
Income Code          A user-defined code that represents a
                     type of income withholding. Used to
                     track reportable income for reporting or
                     withholding.

AH3-SEP-CHK-FLAG     Alpha 1                                     AP198
Separate Payment
Flag

AH3-PAY-IMM-FLAG     Alpha 1                                     AP198
Pay Immediately Flag

AH3-DISC-LOST-FLG    Alpha 1                                     AP198
Discount Lost Flag

AH3-ANTICIPATION     Alpha 1                                     AP198
Anticipation Flag    The anticipation flag.

AH3-INVOICE-GROUP    Alpha 4                                     AP115   AP198
Invoice Group        A user-defined character expression. An
                     invoice group can be assigned to one
                     more invoices. AP150 (Cash Requirements)
                     has an option to select all invoices
                     assigned the same invoice group.

AH3-VENDOR-GROUP     Alpha 4                                     AP198
Vendor Group         A vendor group represents a group of
                     vendors that can be shared by one or
                     more companies.

AH3-PAY-GROUP        Alpha 4                                     AP198
Pay Group            A pay group is used for processing
                     accounts payable payments. A pay group
                     lets you create a single payment for a
                     vendor to pay invoices received by all
                     company process levels assigned to the
                     pay group.

AH3-DISCOUNT-CODE    Alpha 10                                    AP198
Discount Code        A user-defined code that represents a
                     general ledger discount account.

AH3-INC-ACCR-CODE    Alpha 10                                    AP198
Income Withholding   A user-defined code representing a
Code                 general ledger income withholding
                     accrual account.

AH3-RECON-STMT-NBR   Numeric 12                                  AP198
Reconciliation       The bank-assigned reconciliation
Statement            statement number. Used only for cash
                     codes that require reconciliation
                     statements.


AH3-MATCH-DISC-TAK   Alpha 1                                     AP198
Match Disc Tak

AH3-OPEN-BASE-PMT    Derived
Open Base Invoice
Amount

AH3-OPEN-TRAN-PMT    Derived
Open Invoice Amount

AH3-BASE-NET-PMT     Derived
Base Invoice Amount
Paid

AH3-TRAN-NET-PMT     Derived
Invoice Amount Paid

AH3-PMT-STATUS       Derived
Pmt Status

AH3-BANK-STATUS      Derived
Bank Status

AH3-NO-REINSTATE     Derived
No Reinstate

AH3-PAID-DOC-DATE    Derived
Paid Doc Date

AH3-DRAFT-ACCRUED    Derived
Bill of Exchange
Accrued

AH3-AP-INV-DATE      Derived
Ap Inv Date

AH3-AP-PO-NBR        Derived
Ap Po Nbr

AH3-AP-INV-TYPE      Derived
Ap Inv Type

AH3-AP-BASE-INV      Derived
Ap Base Inv

AH3-AP-FORMAT-NBR    Derived
Ap Format Nbr

                         APAPPHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AH3SET1   COMPANY                                                AP115   AP260
          VENDOR                                                 AP300   AP305
          INVOICE                                                AP45.1
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ

AH3SET10  REC-STATUS    KeyChange                                AP245   AP270
          COMPANY
          PROC-LEVEL
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          PAY-GROUP

AH3SET2   PAY-GROUP     KeyChange                                AP270   AP93.2
          REC-STATUS
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

AH3SET6   PAY-GROUP     KeyChange, Subset                        AP180   AP181
          BANK-INST-CODEWhere TRANS-IDENT != Zeroes              AP190   AP265
          TRANS-IDENT                                            AP28.1  AP28.2
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ
          COMPANY

AH3SET8   PAY-GROUP     KeyChange                                AP255
          CASH-CODE
          TRANS-NBR
          BANK-INST-CODE
          COMPANY
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ
          SEQ-NBR
          VOID-SEQ

                         APAPPHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST    Required

                            AH3-COMPANY           -> AH1-COMPANY
                            AH3-VENDOR            -> AH1-VENDOR
                            AH3-INVOICE           -> AH1-INVOICE
                            AH3-SUFFIX            -> AH1-SUFFIX
                            AH3-CANCEL-SEQ        -> AH1-CANCEL-SEQ

Apcompany      APCOMPANY    Required

                            AH3-COMPANY           -> CPY-COMPANY

Apdrafts       APDRAFTS     Not Required

                            AH3-BANK-INST-CODE    -> APT-BANK-INST-CODE
                            AH3-TRANS-IDENT       -> APT-TRANS-IDENT

Apvenmast      APVENMAST    Required

                            AH3-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            AH3-VENDOR            -> VEN-VENDOR

Cbbankinst     CBBANKINST   Required

                            AH3-BANK-INST-CODE    -> CBI-BANK-INST-CODE

Cbcashcode     CBCASHCODE   Required

                            AH3-CASH-CODE         -> CBC-CASH-CODE

Cbcashform     CBCASHFORM   Not Required

                            AH3-CASH-CODE         -> CCF-CASH-CODE
                            AH3-BANK-INST-CODE    -> CCF-BANK-INST-CODE

Cbcheck        CBCHECK      Required

                            AH3-CASH-CODE         -> CHK-CASH-CODE
                            AH3-BANK-INST-CODE    -> CHK-BANK-INST-CODE
                            AH3-TRANS-IDENT       -> CHK-TRANS-IDENT

Cbtrans        CBTRANS      Not Required
                            Valid When AH3-SERIAL-NUM = Zeroes

                            AH3-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            AH3-TRANS-IDENT       -> CBT-TRANS-IDENT

                         APAPPHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ah3set6        APAPPHIST

                            AH3-PAY-GROUP         -> AH3-PAY-GROUP
                            AH3-BANK-INST-CODE    -> AH3-BANK-INST-CODE
                            AH3-TRANS-IDENT       -> AH3-TRANS-IDENT
                                                     AH3-VENDOR
                                                     AH3-INVOICE
                                                     AH3-SUFFIX
                                                     AH3-CANCEL-SEQ
                                                     AH3-SEQ-NBR
                                                     AH3-VOID-SEQ
                                                     AH3-COMPANY

Apdskhist      APDSKHIST

                            AH3-COMPANY           -> AH8-COMPANY
                            AH3-VENDOR            -> AH8-VENDOR
                            AH3-INVOICE           -> AH8-INVOICE
                            AH3-SUFFIX            -> AH8-SUFFIX
                            AH3-CANCEL-SEQ        -> AH8-CANCEL-SEQ
                            AH3-SEQ-NBR           -> AH8-SEQ-NBR
                                                     AH8-VOID-SEQ
                                                     AH8-DISC-TYPE

Aphldinv       APHLDINV     Delete Cascades
                            Valid When AH3-HOLD-FLAG = "Y"

                            "P"                   -> HLI-REC-TYPE
                            AH3-VENDOR-GROUP      -> HLI-VENDOR-GROUP
                            AH3-COMPANY           -> HLI-COMPANY
                            AH3-VENDOR            -> HLI-VENDOR
                            AH3-INVOICE           -> HLI-INVOICE
                            AH3-SUFFIX            -> HLI-SUFFIX
                            AH3-CANCEL-SEQ        -> HLI-CANCEL-SEQ
                            AH3-SEQ-NBR           -> HLI-SEQ-NBR
                            AH3-VOID-SEQ          -> HLI-VOID-SEQ
                                                     HLI-HLD-CODE