|
|
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 AC59.1 AP01.4 AP02.2 AP10.7 AP115
AP125 AP126 AP131 AP135 AP151 AP156
AP161 AP170 AP175 AP176 AP180 AP181
AP190 AP191 AP193 AP195 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.6 AP20.7 AP20.8
AP200 AP201 AP23.1 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 AP32.2
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 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
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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
PO100 PO101 PO122 PO131 PO139 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.1
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 PR198 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ810 RQIE.1 TX226 WH20.2 WH20.7 AP150
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 18 (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 AC59.1
PROC-LEVEL level records for a specific company. AP00.4 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
AP20.1 AP20.2
AP20.3 AP20.4
...
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 AP230 AP250
COMPANY group. AP251 AP265
KeyChange AP40.1 AP56.2
APRSET4 HANDLING-CODE AC42.1 AC59.1
COMPANY AP125 AP126
PROC-LEVEL AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR48.3 IC28.1
MA05.1 MA05.4
MA180 MA205
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
...
APPROCLEV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
