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
UPDATED BY
AP305 AP520 API1.1 API2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APB-COMPANY Numeric 4 API1.1 API2.1
Company The company number. Must be a valid
record in the Accounts Payable Company
file.
APB-BATCH-NUM Numeric 6 API1.1 API2.1
Batch Number 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.
APB-BATCH-DATE Numeric 8 (yyyymmdd) API1.1 API2.1
Batch Date The system date the batch was created.
APB-DISTRIB-DATE Numeric 8 (yyyymmdd) API1.1 API2.1
Post Date The general ledger posting date
assigned to the batch. Used to default a
post date to all invoices entered for
the batch.
APB-CTL-NET-TOT Signed 15.2 API1.1 API2.1
Control Net Amount The control net total of all invoices,
debit memos, and credit memos in the
batch.
APB-CTL-NBR-INV Numeric 15 API1.1 API2.1
Control Number of The control total number of invoices,
Invoices debit memos, and credit memos in the
batch.
APB-CTL-VEND-HASH Numeric 15 API1.1 API2.1
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 AP520 API1.1
Actual Net Invoice The actual net total of all invoices API2.1
Amount entered for the batch.
APB-ACT-DB-TOT Signed 15.2 AP520 API1.1
Actual Net Debit The actual net total of all debit memos API2.1
Memo Amount entered for the batch.
APB-ACT-CR-TOT Signed 15.2 AP520 API1.1
Actual Net Credit The actual net total of all credit API2.1
Memo Amount memos entered for the batch.
APB-ACT-NBR-INV Numeric 15 AP520 API1.1
Actual Number of The actual total number of invoices API2.1
Invoices entered for the batch.
APB-ACT-VEND-HASH Numeric 15 AP520 API1.1
Actual Vendor Hash The actual total sum of vendor numbers API2.1
entered for the batch. Used with numeric
vendor numbering only.
APB-INV-CURRENCY Alpha 5 API1.1 API2.1
Batch Currency 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.
APB-ORIGIN-CODE Alpha 2 API1.1 API2.1
Origin Code 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.
APB-ACT-NET-AMT Derived
Actual 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 AP00.4 AP220
BATCH-NUM batch number within an accounts payable AP305 AP520
company. API1.1 API2.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
|
