|
APPROCLEV FILE
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 AP01.4 AP02.2 AP10.7 AP115 AP125
AP126 AP131 AP135 AP151 AP156 AP161
AP170 AP175 AP176 AP180 AP181 AP190
AP191 AP193 AP195 AP200 AP201 AP230
AP235 AP240 AP245 AP25.1 AP25.2 AP250
AP251 AP252 AP26.1 AP27.1 AP270 AP275
AP28.1 AP28.2 AP295 AP30.1 AP30.2 AP30.3
AP30.4 AP35.1 AP45.2 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
API1.1 API2.1 AR48.3 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 CB06.2 EE135 EE20.1
EE20.2 EE20.3 EE20.4 EE230 EE35.1 EE35.2
EE520 IC02.1 IC28.1 MA05.1 MA05.4 MA180
MA205 MA530 MA531 MA54.1 MA54.9 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO27.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 PR198 RQ01.1 RQ10.1 RQ10.2 RQ810
TX101 TX226 TX301 WH20.2 WH20.7 AP150
AP178 AP265 AP40.1
UPDATED BY
AP00.5 AP00.4 AP101 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APR-COMPANY Numeric 4 AP00.5 AP193
Element: Company The company number. Must be a valid
accounts payable company with Yes
selected in the Process Levels Required
field.
APR-PROC-LEVEL Alpha 5 AP00.5 AP193
Element: Process Level A user-defined code representing a
reporting and processing level in the
accounts payable company.
APR-NAME Alpha 30 (Lower Case) AP00.5 AP135
Element: Name The process level name or description.
APR-ADDR1 Alpha 30 (Lower Case) AP00.5
Element: Address 1 The first line of address information
for the process level.
APR-ADDR2 Alpha 30 (Lower Case) AP00.5
Element: Address 2 The second line of address information
for the process level.
APR-ADDR3 Alpha 30 (Lower Case) AP00.5
Element: Address 3 The third line of address information
for the process level.
APR-ADDR4 Alpha 30 (Lower Case) AP00.5
Element: Address 4 The fourth line of address information
for the process level.
APR-CITY-ADDR5 Alpha 30 (Lower Case) AP00.5
Element: City or AddresThe city or fifth line of address
information for the process level.
APR-STATE-PROV Alpha 2 AP00.5
Element: State or ProviThe state or province for the process
level address.
APR-POSTAL-CODE Alpha 10 (Lower Case) AP00.5
Element: Postal Code The postal code for the process level
address.
APR-COUNTY Alpha 25 (Lower Case) AP00.5
Element: County The county for the company address.
APR-COUNTRY Alpha 30 (Lower Case) AP00.5
Element: Country The country for the process level
address. Can also be used for additional
information such as attention name.
APR-REGION Alpha 2 AP00.5
Element: Region Code The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
APR-COUNTRY-CODE Alpha 2 AP00.5
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
APR-ACCR-CODE Alpha 4 AP00.5
Element: Invoice AccruaThe 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.
APR-CASH-CODE Alpha 4 AP00.5
Element: Cash Code 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.
APR-INC-ACCR-CODE Alpha 10 AP00.5
Income Withholding The income withholding code assigned to
Code 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.
APR-DISCOUNT-CODE Alpha 10 AP00.5
Element: Discount Code 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.
APR-PAY-GROUP Alpha 4 AP00.5 AP101
Element: Pay Group 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.
APR-DEF-PROC-LEVEL Alpha 1 AP00.5
Default Process Indicates whether this is the default
Level process level for the company. A company
can have only one default process level.
Y = Yes
N = No
APR-HANDLING-CODE Alpha 4 AP00.5
Invoice Handling Handling code. Contains processing
Code rules for invoice matching.
APR-MATCH-PROC-LEV Alpha 1 AP00.5
Element: Match Process Matching process level.
APR-DIST-CODE Alpha 9 AP00.5
Element: Distribution CA user-defined code used to
automatically create expense
distributions or expense distribution
"shells" for invoices or to split an
invoice distribution into multiple
distributions.
APPROCLEV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APRSET1 COMPANY This index is used to access process AC42.1 AP00.4
PROC-LEVEL level records for a specific company. AP00.5 AP00.6
AP01.4 AP02.2
AP10.7 AP101
AP115 AP125
AP126 AP131
AP135 AP151
AP156 AP161
AP170 AP175
AP176 AP180
AP181 AP190
AP191 AP193
AP195 AP200
AP201 AP230
AP235 AP240
...
APRSET2 PROC-LEVEL This index is used to validate whether AP230 AP250
COMPANY a process level exists. AP251 MA540
KeyChange
APRSET3 PAY-GROUP This index is used to verify or access AP150 AP151
PROC-LEVEL process level records for a specific pay AP178 AP230
COMPANY group. AP250 AP251
KeyChange AP265 AP40.1
AP56.2
APRSET4 HANDLING-CODE AC42.1 AP125
COMPANY AP126 AP131
PROC-LEVEL AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 AR48.3
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA05.1
MA05.4 MA180
MA205 MA530
MA531 MA54.9
...
APRSET99 POSTAL-CODE
PROC-LEVEL
COMPANY
APPROCLEV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APR-COMPANY -> CPY-COMPANY (CPYSET1)
Maproclev PROCLEV Not Required, Delete Cascades
Valid When APR-MATCH-PROC-LEV = "Y"
APR-COMPANY -> MAZ-COMPANY
APR-PROC-LEVEL -> MAZ-PROC-LEVEL
|