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 |
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
APB-BATCH-DATE Element: Batch Date | Numeric 8 (yyyymmdd) The system date the batch was created. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
APB-CTL-NBR-INV Control Number of Invoices | Numeric 15 The control total number of invoices, debit memos, and credit memos in the batch. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
APB-ACT-INV-TOT Actual Net Invoice Amount | Signed 18.2 The actual net total of all invoices entered for the batch. |
|||||||||||||||||||||||||||||||
APB-ACT-DB-TOT Actual Net Debit Memo Amount | Signed 18.2 The actual net total of all debit memos entered for the batch. |
|
||||||||||||||||||||||||||||||
APB-ACT-CR-TOT Actual Net Credit Memo Amount | Signed 18.2 The actual net total of all credit memos entered for the batch. |
|
||||||||||||||||||||||||||||||
APB-ACT-NBR-INV Actual Number of Invoices | Numeric 15 The actual total number of invoices entered for the batch. |
|
||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
APB-ACT-NET-AMT Element: Actual Net Amount | Derived The actual net amount of invoices, debit memos, and credit memos entered for the batch. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
---|---|---|---|---|---|---|---|---|---|
APBSET1 |
COMPANY BATCH-NUM |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apibatch | APINVOICE |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Apinvoice | APINVOICE |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Pomessage | POMESSAGE |
|
All trademarks and registered trademarks are the property of their
respective owners.