APBATCH

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 AP170 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.6 AP20.7 AP21.1 AP23.1
AP25.1 AP25.2 AP25.3 AP26.1 AP27.1 AP305
AP520 API1.1 API2.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.1 MA43.2 MA44.1 MA44.2
MA61.1 MA66.3 MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APB-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid record in the Accounts Payable Company file.
AP170 AP25.1
AP25.2 API1.1
API2.1
APB-BATCH-NUM
Element: Batch Nbr
Numeric 6
The batch number. This number is system-assigned or user-assigned depending on the option selected for the company in the Auto Batch Numbering field.
AP170 AP25.1
AP25.2 API1.1
API2.1
APB-BATCH-DATE
Element: Batch Date
Numeric 8 (yyyymmdd)
The system date the batch was created.
AP170 AP25.1
API1.1 API2.1
APB-DISTRIB-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The general ledger posting date assigned to the batch. Used to default a post date to all invoices entered for the batch.
AP170 AP25.1
API1.1 API2.1
APB-CTL-NET-TOT
Element: Control Net Amount
Signed 18.2
The control net total of all invoices, debit memos, and credit memos in the batch.
AP125 AP126
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
APB-CTL-NBR-INV
Control Number of
Invoices
Numeric 15
The control total number of invoices, debit memos, and credit memos in the batch.
AP125 AP126
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
APB-CTL-VEND-HASH
Element: Control Vendor Hash
Numeric 15
The control total sum of all vendor numbers in the batch. Used with numeric vendor numbering only.
AP125 AP126
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
APB-ACT-INV-TOT
Actual Net Invoice
Amount
Signed 18.2
The actual net total of all invoices entered for the batch.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP25.3
AP26.1 AP27.1
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2
MA44.1 MA44.2
MA61.1 MA66.3
MAI1.1
APB-ACT-DB-TOT
Actual Net Debit
Memo Amount
Signed 18.2
The actual net total of all debit memos entered for the batch.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP25.3 AP26.1
AP27.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APB-ACT-CR-TOT
Actual Net Credit
Memo Amount
Signed 18.2
The actual net total of all credit memos entered for the batch.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP25.3 AP26.1
AP27.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MA61.1 MAI1.1
APB-ACT-NBR-INV
Actual Number of
Invoices
Numeric 15
The actual total number of invoices entered for the batch.
AP125 AP126
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP25.3 AP26.1
AP27.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
MAI1.1
APB-ACT-VEND-HASH
Element: Actual Vendor Hash
Numeric 15
The actual total sum of vendor numbers entered for the batch. Used with numeric vendor numbering only.
AP125 AP126
AP170 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP25.3 AP26.1
AP27.1 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.1
MA43.2 MA44.1
MA44.2 MA61.1
MA66.3 MAI1.1
APB-INV-CURRENCY
Element: Batch Currency
Alpha 5
The currency code assigned to the 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.
AP25.1 API1.1
API2.1
APB-ORIGIN-CODE
Element: Origin Code
Alpha 2
Indicates the system the batch was 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.
AP25.1 API1.1
API2.1
APB-ACT-NET-AMT
Element: Actual Net Amount
Derived
The 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
BATCH-NUM
...
AP00.4 AP125
AP126 AP170
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP25.3 AP26.1
AP27.1 AP305
AP520 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.1 MA43.2


APBATCH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APB-COMPANY->CPY-COMPANY


APBATCH FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:06:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.