 |
Lawson Insight Technical Documentation |
|
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
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 MA43.2 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APB-COMPANY Numeric 4 AP25.1 AP25.2
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
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
Batch Date The system date the batch was created. API2.1
APB-DISTRIB-DATE Numeric 8 (yyyymmdd) AP25.1 API1.1
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
Control Net Amount The 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
Control Vendor Hash The 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 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
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
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
Actual Vendor Hash 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 MA43.2
MA61.1 MAI1.1
APB-INV-CURRENCY Alpha 5 AP25.1 API1.1
Batch Currency The 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
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
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 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
MA43.2 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
|