Lawson Insight Technical Documentation |
|
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 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 MA43.2 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APB-COMPANY Numeric 4 AP170 AP25.1
Element: Company The company number. Must be a valid AP25.2 API1.1
record in the Accounts Payable Company API2.1
file.
APB-BATCH-NUM Numeric 6 AP170 AP25.1
Element: Batch Nbr The batch number. This number is AP25.2 API1.1
system-assigned or user-assigned API2.1
depending on the option selected for the
company in the Auto Batch Numbering
field.
APB-BATCH-DATE Numeric 8 (yyyymmdd) AP170 AP25.1
Element: Batch Date The system date the batch was created. API1.1 API2.1
APB-DISTRIB-DATE Numeric 8 (yyyymmdd) AP170 AP25.1
Element: Post Date The general ledger posting date API1.1 API2.1
assigned to the batch. Used to default a
post date to all invoices entered for
the batch.
APB-CTL-NET-TOT Signed 18.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 18.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 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 MA43.2
MA61.1 MAI1.1
APB-ACT-DB-TOT Signed 18.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
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
MA43.2 MA61.1
MAI1.1
APB-ACT-CR-TOT Signed 18.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
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
MA43.2 MA61.1
MAI1.1
APB-ACT-NBR-INV Numeric 15 AP125 AP126
Actual Number of The actual total number of invoices AP170 AP20.1
Invoices entered for the batch. 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
MA43.2 MAI1.1
APB-ACT-VEND-HASH Numeric 15 AP125 AP126
Element: Actual Vendor The actual total sum of vendor numbers AP170 AP20.1
entered for the batch. Used with numeric AP20.2 AP20.3
vendor numbering only. 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
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 AP00.4 AP125
BATCH-NUM 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 MA43.2
MA540 MA61.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
|