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
AP225
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.5 AP20.6
AP20.7 AP23.1 AP25.1 AP25.2 AP25.3 AP26.1
AP305 AP520 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APB-COMPANY Numeric 4 AP25.1 AP25.2
Company The company number. Must be a valid MA530 MA540
record in the Accounts Payable Company PO31.1
file.
APB-BATCH-NUM Numeric 6 AP25.1 AP25.2
Batch Number The batch number. This number is MA530 MA540
system-assigned or user-assigned PO31.1
depending on the option selected for the
company in the Auto Batch Numbering
field.
APB-BATCH-DATE Numeric 8 (yyyymmdd) AP25.1 MA530
Batch Date The system date the batch was created. MA540 PO31.1
APB-DISTRIB-DATE Numeric 8 (yyyymmdd) AP25.1 MA530
Post Date The general ledger posting date MA540 PO31.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 AP25.1 AP25.2
Control Net Amount The control net total of all invoices,
debit memos, and credit memos in the
batch.
APB-CTL-NBR-INV Numeric 15 AP25.1 AP25.2
Control Number of The control total number of invoices,
Invoices debit memos, and credit memos in the
batch.
APB-CTL-VEND-HASH Numeric 15 AP25.1 AP25.2
Control Vendor Hash The control total sum of all vendor
numbers in the batch. Used with numeric
vendor numbering only.
APB-ACT-INV-TOT Signed 15.2 AP20.1 AP20.2
Entry Net Invoice The actual net total of all invoices AP20.5 AP20.6
Amount entered for the batch. AP20.7 AP23.1
AP25.3 AP520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APB-ACT-DB-TOT Signed 15.2 AP20.1 AP20.2
Entry Net Debit The actual net total of all debit memos AP20.5 AP20.7
Memo Amount entered for the batch. AP23.1 AP25.3
AP520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APB-ACT-CR-TOT Signed 15.2 AP20.1 AP20.2
Entry Net Credit The actual net total of all credit AP20.5 AP20.7
Memo Amount memos entered for the batch. AP23.1 AP25.3
AP520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
APB-ACT-NBR-INV Numeric 15 AP20.1 AP20.2
Entry Number of The actual total number of invoices AP20.5 AP20.6
Invoices entered for the batch. AP20.7 AP23.1
AP25.3 AP520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APB-ACT-VEND-HASH Numeric 15 AP20.1 AP20.2
Entry Vendor Hash The actual total sum of vendor numbers AP20.5 AP20.6
entered for the batch. Used with numeric AP20.7 AP23.1
vendor numbering only. AP25.3 AP520
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
MA530 MA540
PO31.1
APB-INV-CURRENCY Alpha 5 AP25.1 MA530
Batch Currency The currency code assigned to the MA540 PO31.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 MA530
Origin Code Indicates the system the batch was MA540 PO31.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
Entry Net Amount 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 This index is used to validate a unique AP125 AP126
BATCH-NUM batch number within an accounts payable AP20.1 AP20.2
company. AP20.5 AP20.6
AP20.7 AP225
AP23.1 AP25.1
AP25.2 AP25.3
AP26.1 AP305
AP520 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.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
|