Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APBATCH


                              APBATCH FILE

                                 Batch

The Batch file contains unreleased invoice batches. This file is used only by
companies that have the batch invoice entry option selected. A batch is a
unique numeric value within a company for a group of unreleased invoices.
Batch numbers are automatically assigned by the system or entered manually
depending on the batch entry options selected for the company.

REFERENCED BY

AP00.4    AP220     MA540

UPDATED BY

AP125     AP126     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.6    AP20.7    AP23.1    AP25.1    AP25.2
AP25.3    AP26.1    AP27.1    AP305     AP520     API1.1
API2.1    MA41.2    MA41.7    MA43.2    MA61.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APB-COMPANY            Numeric 4                                 AP25.1  AP25.2
Element: Company       The company number. Must be a valid       API1.1  API2.1
                       record in the Accounts Payable Company
                       file.

APB-BATCH-NUM          Numeric 6                                 AP25.1  AP25.2
Element: Batch Number  The batch number. This number is          API1.1  API2.1
                       system-assigned or user-assigned
                       depending on the option selected for the
                       company in the Auto Batch Numbering
                       field.

APB-BATCH-DATE         Numeric 8  (yyyymmdd)                     AP25.1  API1.1
Element: Date          The system date the batch was created.    API2.1

APB-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP25.1  API1.1
Element: Post Date     The general ledger posting date           API2.1
                       assigned to the batch. Used to default a
                       post date to all invoices entered for
                       the batch.

APB-CTL-NET-TOT        Signed 15.2                               AP125   AP126
Element: Control Net AmThe control net total of all invoices,    AP25.1  AP25.2
                       debit memos, and credit memos in the      AP26.1  AP27.1
                       batch.                                    API1.1  API2.1

APB-CTL-NBR-INV        Numeric 15                                AP125   AP126
Control Number of      The control total number of invoices,     AP25.1  AP25.2
Invoices               debit memos, and credit memos in the      AP26.1  AP27.1
                       batch.                                    API1.1  API2.1

APB-CTL-VEND-HASH      Numeric 15                                AP125   AP126
Element: Control VendorThe control total sum of all vendor       AP25.1  AP25.2
                       numbers in the batch. Used with numeric   AP26.1  AP27.1
                       vendor numbering only.                    API1.1  API2.1

APB-ACT-INV-TOT        Signed 15.2                               AP125   AP126
Actual Net Invoice     The actual net total of all invoices      AP20.1  AP20.2
Amount                 entered for the batch.                    AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP25.3  AP26.1
                                                                 AP27.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APB-ACT-DB-TOT         Signed 15.2                               AP125   AP126
Actual Net Debit       The actual net total of all debit memos   AP20.1  AP20.2
Memo Amount            entered for the batch.                    AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP25.3
                                                                 AP26.1  AP27.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APB-ACT-CR-TOT         Signed 15.2                               AP125   AP126
Actual Net Credit      The actual net total of all credit        AP20.1  AP20.2
Memo Amount            memos entered for the batch.              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP25.3
                                                                 AP26.1  AP27.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APB-ACT-NBR-INV        Numeric 15                                AP125   AP126
Actual Number of       The actual total number of invoices       AP20.1  AP20.2
Invoices               entered for the batch.                    AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP25.3  AP26.1
                                                                 AP27.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  MA43.2
                                                                 MAI1.1

APB-ACT-VEND-HASH      Numeric 15                                AP125   AP126
Element: Actual Vendor The actual total sum of vendor numbers    AP20.1  AP20.2
                       entered for the batch. Used with numeric  AP20.3  AP20.4
                       vendor numbering only.                    AP20.5  AP20.6
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP25.3  AP26.1
                                                                 AP27.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APB-INV-CURRENCY       Alpha 5                                   AP25.1  API1.1
Element: Batch CurrencyThe currency code assigned to the         API2.1
                       batch. If assigned, the batch is
                       restricted to invoices, debit memos, and
                       credit memos with the currency selected.
                       If left blank, invoice currency is not
                       restricted for the batch. Must be a
                       valid record in the Currency Code file.

APB-ORIGIN-CODE        Alpha 2                                   AP25.1  API1.1
Element: Origin Code   Indicates the system the batch was        API2.1
                       created in. Must be a valid record in
                       the General Ledger Codes file. Valid
                       values are:

                       AP = Lawson Accounts Payable system.
                       PO = Lawson Purchase Order system.

APB-ACT-NET-AMT        Derived
Element: Actual Net AmoThe actual net amount of invoices,
                       debit memos, and credit memos entered
                       for the batch.

                         APBATCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APBSET1   COMPANY       This index is used to validate a unique  AP00.4  AP125
          BATCH-NUM     batch number within an accounts payable  AP126   AP20.1
                        company.                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP25.3  AP26.1
                                                                 AP27.1  AP305
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA540   MA61.1
                                                                 MAI1.1

                         APBATCH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APB-COMPANY      -> CPY-COMPANY

                         APBATCH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apibatch       APINVOICE    Delete Cascades

                            Zeroes           -> API-REC-STATUS
                            APB-COMPANY      -> API-COMPANY
                            APB-BATCH-NUM    -> API-BATCH-NUM
                                                API-AUTH-CODE
                                                API-OPERATOR
                                                API-CREATE-DATE
                                                API-CREATION-TIME
                                                API-VENDOR
                                                API-INVOICE
                                                API-SUFFIX
                                                API-CANCEL-SEQ

Apinvoice      APINVOICE    Delete Cascades

                            Zeroes           -> API-REC-STATUS
                            APB-COMPANY      -> API-COMPANY
                            APB-BATCH-NUM    -> API-BATCH-NUM
                                                API-AUTH-CODE
                                                API-OPERATOR
                                                API-CREATE-DATE
                                                API-CREATION-TIME
                                                API-VENDOR
                                                API-INVOICE
                                                API-SUFFIX
                                                API-CANCEL-SEQ

Pomessage      POMESSAGE

                            APB-COMPANY      -> POM-COMPANY
                            APB-BATCH-NUM    -> POM-BATCH-NBR
                                                POM-VENDOR
                                                POM-INVOICE
                                                POM-SUFFIX
                                                POM-PO-NUMBER
                                                POM-PO-RELEASE
                                                POM-LINE-NBR