APPROCLEV

Accounts Payable Process Level

The Accounts Payable Process Level file contains records for each process level defined for a company in the Lawson Accounts Payable system. A company that has Yes selected in the Process Levels Required field must have at least one process level defined. Companies that have No selected in the Process Levels Required field cannot define or use process levels. Process levels can be used to default accounts used for posting transactions, break and subtotal reports, and process payments.

REFERENCED BY
AC42.1 AC42.2 AP01.4 AP02.2 AP10.7 AP102
AP115 AP125 AP126 AP131 AP135 AP150
AP151 AP156 AP170 AP175 AP176 AP178
AP180 AP181 AP190 AP191 AP193 AP198
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP20.8 AP200 AP201 AP21.1 AP23.1
AP230 AP235 AP240 AP245 AP246 AP25.1
AP25.2 AP250 AP251 AP252 AP26.1 AP27.1
AP270 AP271 AP275 AP28.1 AP28.2 AP295
AP30.1 AP30.2 AP30.3 AP30.4 AP30.5 AP35.1
AP45.2 AP45.3 AP45.4 AP510 AP52.1 AP52.3
AP52.7 AP520 AP56.1 AP56.2 AP80.1 AP90.1
AP90.2 AP90.5 AP92.3 AP92.4 AP93.3 AP93.4
AP95.2 AP95.3 AP96.1 AP98.3 API1.1 API2.1
API6.1 CB06.2 CB07.1 CB54.1 CB55.1 CB554
CB56.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE11.1
EE135 EE20.1 EE20.2 EE20.3 EE20.4 EE230
EE35.1 EE35.2 EE520 DR100 IC02.1 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 EX12.1
EX14.1 EX14.2 MA05.1 MA05.4 MA180 MA205
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.1 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA54.1 MA54.2 MA54.9 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA64.9 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO139
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.1
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO295 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 PR198 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ504 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 TX101 TX226
TX301 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
CB186 CB187 CB286 AP265 AP40.1


UPDATED BY
AP00.5 AP00.4 AP101 AP305 AP702 AP161
AP195 ZA161 PD130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APR-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid accounts payable company with Yes selected in the Process Levels Required field.
AP00.5 AP193
APR-PROC-LEVEL
Element: Process Level
Alpha 5
A user-defined code representing a reporting and processing level in the accounts payable company.
AP00.5 AP193
APR-NAME
Element: Name
Alpha 30 (Lower Case)
The process level name or description.
AP00.5 AP135
APR-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
The first line of address information for the process level.
AP00.5
APR-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
The second line of address information for the process level.
AP00.5
APR-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
The third line of address information for the process level.
AP00.5
APR-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
The fourth line of address information for the process level.
AP00.5
APR-CITY-ADDR5
Element: City or Address 5
Alpha 18 (Lower Case)
The city or fifth line of address information for the process level.
AP00.5
APR-STATE-PROV
Element: State or Province
Alpha 2
The state or province for the process level address.
AP00.5
APR-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
The postal code for the process level address.
AP00.5
APR-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP00.5
APR-COUNTRY
Element: Country
Alpha 30 (Lower Case)
The country for the process level address. Can also be used for additional information such as attention name.
AP00.5
APR-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
AP00.5
APR-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP00.5
APR-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
The invoice accrual code assigned to the process level. Used to default a general ledger accrual account to an invoice during invoice entry. Must be a valid record in the Invoice Accrual Code file. If left blank, the process level uses the invoice accrual code assigned to the company.
AP00.5
APR-CASH-CODE
Element: Cash Code
Alpha 4
The cash code assigned to the process level. Represents a bank account. Must be a valid record in the Cash Code file. If left blank, the cash code assigned to the company, if assigned, or the pay group defaults on invoices entered for the process level.
AP00.5
APR-INC-ACCR-CODE
Income Withholding
Code
Alpha 10
The income withholding code assigned to the process level. Used to default an income withholding accrual account to an invoice during entry to track reportable withholding for a vendor. Must be a valid record in the Income Withholding Code file. If left blank, the process level uses the income withholding code assigned to the company.
AP00.5
APR-DISCOUNT-CODE
Element: Discount Code
Alpha 10
The discount code assigned to the process level. Used to default a general discount account to an invoice during entry. Must be a valid record in the Discount Code file. If left blank, the process level uses the discount code assigned to the company.
AP00.5
APR-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group assigned to the process level. A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group. Must be a valid record in the Pay Group file. If left blank, the process level uses the pay group assigned to the company.
AP00.5 AP101
APR-DEF-PROC-LEVEL
Default Process
Level
Alpha 1
Indicates whether this is the default process level for the company. A company can have only one default process level.
Y = Yes
N = No
AP00.5
APR-HANDLING-CODE
Invoice Handling
Code
Alpha 4
Handling code. Contains processing rules for invoice matching.
AP00.5
APR-MATCH-PROC-LEV
Element: Match Process Level
Alpha 1
Matching process level.
AP00.5
APR-DIST-CODE
Element: Dist Code
Alpha 9
A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.
AP00.5
APR-RET-ACCR-CODE
Element: Accr Code
Alpha 4
AP00.5
APR-SEC-WTH-CODE1
Element: Sec Wth Code
Alpha 10
AP00.5
APR-SEC-WTH-CODE2
Element: Sec Wth Code
Alpha 10
AP00.5
APR-SEC-WTH-CODE3
Element: Sec Wth Code
Alpha 10
AP00.5
APR-ACTIVE-STATUS
Element: Active Status
Alpha 1

A = Active
I = Inactive
AP00.5 AP702


APPROCLEV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APRSET1 COMPANY
PROC-LEVEL
...
AC42.1 AC42.2
AP00.4 AP00.5
AP00.6 AP01.4
AP02.2 AP10.7
AP101 AP102
AP115 AP125
AP126 AP131
AP135 AP150
AP151 AP156
AP161 AP170
AP175 AP176
AP178 AP180
AP181 AP190
AP191 AP193
AP195 AP198
APRSET2 PROC-LEVEL
COMPANY
KeyChange
AP230 AP250
AP251 CB186
CB187 CB286
MA540
APRSET3 PAY-GROUP
PROC-LEVEL
COMPANY
KeyChange
AP150 AP151
AP161 AP230
AP250 AP251
AP265 AP40.1
AP56.2
APRSET4 HANDLING-CODE
COMPANY
PROC-LEVEL
...
AC42.1 AC42.2
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506


APPROCLEV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APR-COMPANY->CPY-COMPANY
Maproclev PROCLEV Not Required, Delete Cascades
Valid When APR-MATCH-PROC-LEV ="Y"
APR-COMPANY->MAZ-COMPANY
APR-PROC-LEVEL->MAZ-PROC-LEVEL


APPROCLEV FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Proc Audit APPRCLVAUD
APR-COMPANY->LVA-COMPANY
APR-PROC-LEVEL->LVA-PROCESS-LEVEL
  LVA-ACTION
  LVA-DATE
  LVA-TIME
  LVA-UNIQUE-I-D


File created: Thu Jun 09 02:07:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.