|
|
APCOMPANY FILE
Accounts Payable Company
The Accounts Payable Company file contains information for each Accounts
Payable company. An accounts payable company must first exist as a valid
company in the Lawson General Ledger system. The accounts payable company uses
the name and base currency defined for the company in the General Ledger
system.
REFERENCED BY
AC03.4 AC440 AC50.1 AC500 AC52.1 AC520
AM18.1 AP01.4 AP01.1 AP02.2 AP05.2 AP05.3
AP05.6 AP102 AP12.1 AP12.2 AP125 AP126
AP135 AP150 AP151 AP155 AP156 AP157
AP160 AP161 AP170 AP175 AP180 AP181
AP185 AP190 AP191 AP193 AP195 AP197
AP199 AP200 AP201 AP205 AP212 AP213
AP214 AP225 AP226 AP230 AP236 AP239
AP240 AP250 AP26.1 AP260 AP265 AP270
AP275 AP28.1 AP28.2 AP282 AP284 AP285
AP30.1 AP30.2 AP30.3 AP30.4 AP300 AP32.1
AP32.2 AP35.1 AP36.1 AP40.1 AP45.1 AP510
AP52.1 AP52.2 AP52.3 AP55.1 AP55.2 AP56.1
AP56.2 AP57.2 AP80.1 AP80.2 AP90.1 AP90.2
AP90.3 AP90.4 AP90.6 AP90.8 AP90.7 AP92.3
AP92.4 AP95.1 AP95.2 AP95.3 AP950 AP952
AP953 AP954 AP959 AP962 AR08.1 AR10.1
AR115 AR124 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4
AR42.1 AR42.2 AR42.7 AR43.1 AR501 AR550
AR560 AR570 AR575 AR580 AR82.1 BL02.1
BL122 BL140 BL141 BL202 BL240 BL340
BL41.1 BL80.1 BL802 BL902 BL92.1 CB06.1
CB06.2 CB10.1 CB180 CB191 CB20.1 CB30.1
CB500 CB951 CB981 CX05.1 CX05.2 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CX805 CXCP.1 DT180 DT181
EE05.1 EE05.2 EE12.1 EE12.2 EE135 EE175
EE20.1 EE20.2 EE20.3 EE20.4 EE220 EE230
EE235 EE275 EE30.1 EE35.1 EE35.2 EE52.1
EE52.2 EE520 EE90.1 EE90.2 EE90.3 GL284
GL285 HR00.1 HR01.1 DR100 IC02.1 IC10.1
IC10.2 IC12.1 IC140 IC141 IC142 IC145
IC16.4 IC226 IC263 IC45.1 IC522 IC523
IC526 IC527 IC530 IC531 IC62.1 IC63.1
IC81.1 IC81.2 IC812 IC82.1 IC83.1 IC840
IN120 IN20.1 MA00.1 MA00.4 MA140 MA190
MA200 MA203 MA204 MA205 MA206 MA208
MA278 MA300 MA520 MA95.1 MA95.2 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
OE112 OE113 OE114 OE129 OE13.1 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 PBIP.1 PO10.1 PO10.2 PO100 PO115
PO120 PO121 PO122 PO123 PO13.1 PO130
PO131 PO132 PO133 PO135 PO14.1 PO15.1
PO150 PO16.1 PO16.2 PO180 PO20.1 PO202
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO21.6
PO210 PO212 PO213 PO214 PO216 PO22.1
PO22.2 PO22.3 PO220 PO221 PO223 PO224
PO225 PO226 PO227 PO23.1 PO23.2 PO230
PO231 PO233 PO236 PO24.1 PO25.1 PO25.2
PO25.3 PO25.4 PO251 PO26.1 PO272 PO274
PO275 PO276 PO277 PO28.1 PO28.3 PO28.4
PO28.5 PO28.6 PO28.7 PO28.8 PO280 PO29.1
PO295 PO30.1 PO32.1 PO32.2 PO32.4 PO32.5
PO33.1 PO34.1 PO35.1 PO37.1 PO39.1 PO50.1
PO52.1 PO529 PO53.1 PO53.2 PO530 PO560
PO590 PO60.1 PO61.1 PO62.1 PO63.1 PO64.1
PO66.1 PO67.1 PO68.1 PO69.1 PO72.1 PO72.2
PO81.1 PO813 PO820 PO821 PO822 PO85.1
PO94.1 POA2.1 PR05.1 PR05.3 PR150 PR195
PR199 PR26.1 PR514 PR82.1 PR85.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ111 RQ125 RQ20.1
RQ20.2 RQ20.3 RQ20.4 RQ35.1 RQ500 SEA2.1
TX04.1 TX140 TX225 TX40.1 WH02.1 WH130
WH132 WH140 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH38.1 WH40.1 WH40.2
WH520 WH830 WO132 WO140 WO235 WO252
WO30.1 WO35.1 WO40.1 AP10.1 AP10.2 AP10.5
AP10.6 AP10.7
UPDATED BY
AP00.4 AP00.8 AP101 AP20.1 AP20.2 AP20.5
AP20.6 AP20.7 AP23.1 AP25.1 AP305 AP520
AP956 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.1 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPY-COMPANY Numeric 4 AP00.4 AP956
Company The company number. Must be a valid
company in the Lawson General Ledger
system.
CPY-NAME Alpha 30 (Lower Case) AP00.4 AP956
Name The company name or description. An
accounts payable company uses the name
defined for the company in the Lawson
General Ledger system.
CPY-DEFAULT-REF Alpha 1 AP00.4 AP956
Default The default reference value for the
Distribution Referenccompany. Used to default a value in the
Reference field on distributions during
invoice entry. Valid values are:
I = Invoice.
P = Purchase Order.
V = Voucher.
CPY-VENDOR-GROUP Alpha 4 AP00.4 AP125
Vendor Group The vendor group assigned to the AP126 AP170
company. Must be a valid record in the AP180 AP181
Vendor Group file. AP190 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 AP32.2
AP520 AP956
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR560 AR570
AR575 AR580
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
IC81.2 IC82.1
MA530 MA540
PBIP.1 PO31.1
TX04.1 WH30.3
WH31.3 WH32.3
...
CPY-PAY-GROUP Alpha 4 AP00.4 AP101
Pay Group The pay group assigned to the company. AP956
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. The company must have
the same base currency as the posting
company assigned to the pay group.
CPY-BATCH-OPTION Alpha 1 AP00.4 AP956
Batch Release Indicates whether the company batch
option to enter and releases invoices.
If this field is No, the company must
have Yes selected in the Invoice
Approval field. If the company has Yes
selected in both the Batch Release and
Invoice Approval fields, the company
assigns vouchers to invoices but still
enters and releases invoices in batches.
Valid values are:
N = No.
Y = Yes.
CPY-AUTO-BATCH Alpha 1 AP00.4 AP956
Automatic Batch Indicates whether the system
Numbering automatically assigns numbers to batches
in AP25.1 (Batch Control). Used only if
the company has Yes selected in the
Batch Release Option field. Valid values
are:
N = No.
Y = Yes.
CPY-BATCH-CONTROL Alpha 1 AP00.4 AP956
Batch Control Indicates whether the company uses
batch control, which indicates whether
entry totals must match control totals
before a batch can be released. Used
only if the company has Yes selected in
the Batch Release Option field. Valid
values are:
Y = Yes.
N = No.
CPY-LAST-BATCH Numeric 6 AP00.4 AP25.1
Last Batch Number The last batch number used by the AP956
company. Used only if the company has
Yes selected in the Automatic Batch
Numbering field.
CPY-INV-APPROVAL Alpha 1 AP00.4 AP956
Invoice Approval Indicates whether the company uses the
invoice registration entry option (the
assignment of an authority code and a
voucher to an invoice). If this field is
No, the company must have Yes selected
in the Batch Release field. If the
company has Yes selected in both the
Invoice Approval and Batch Release
fields, the company assigns vouchers to
invoices but enters and releases
invoices in batches. Valid values are:
N = No.
Y = Yes.
CPY-NUMERIC-VOUCH Alpha 1 AP00.4 AP956
Numeric Voucher Indicates whether voucher values will
Numbers be numeric. Used only if the company has
Yes selected in the Invoice Approval
field. Valid values are:
Y = Yes.
N = No.
CPY-DUP-VOUCHER Alpha 1 AP00.4 AP956
Duplicate Voucher Indicates whether duplicate voucher
Numbers numbers are allowed within the company.
Used only if the company has Yes
selected in the Invoice Approval field.
Valid values are:
Y = Yes.
N = No.
CPY-AUTO-VOUCHER Alpha 1 AP00.4 AP956
Auto Voucher Indicates whether the system
Numbering automatically assigns voucher numbers to
invoices during entry. Used only if the
company has Yes selected in both the
Invoice Approval and the Numeric Voucher
Numbering fields. Valid values are:
Y = Yes.
N = No.
CPY-LAST-VOUCHER Numeric 10 AP00.4 AP20.1
Last Voucher Number The last voucher number assigned by the AP20.2 AP20.5
company. Used only if the company has AP20.6 AP20.7
Yes selected in both the Invoice AP23.1 AP520
Approval and Numeric Voucher Numbers AP956 MA40.1
fields. The system assigns voucher MA40.2 MA41.1
numbers beginning with the next MA41.2 MA41.4
sequential number. If left blank, the MA41.5 MA41.6
system assigns voucher numbers beginning MA43.1 MA43.2
with 1. MA43.3 MA43.4
MA52.1 MA530
MA540 PO31.1
CPY-POST-OPTION Alpha 1 AP00.4 AP956
Posting Option The posting option for the company.
Determines the volume of invoice expense
distribution information that AP175
(Invoice Distribution Closing) transfers
to the general ledger. Valid values are:
S = Summary.
D = Detail.
CPY-INVOICE-AUDIT Alpha 1 AP00.4 AP956
Audit Invoice Indicates whether the system creates
Changes audit records when released invoices are
changed. Valid values are:
Y = Yes.
N = No.
CPY-ACCR-CODE Alpha 4 AP00.4 AP956
Invoice Accrual Code The invoice accrual code assigned to
the company. Represents the default
general ledger accrual account for the
company. A unique entry in this field
creates a record in the Invoice Accrual
Code file.
CPY-CASH-CODE Alpha 4 AP00.4 AP956
Cash Code The cash code assigned to the company.
Represents a bank account. Must be a
valid record in the Cash Code file.
Valid relationship records must exist
between the cash code and both the
company and the posting company assigned
to the company's pay group in the
Company-Cash Code Relationship file. If
left blank, the cash code assigned to
the company's pay group defaults on
invoices entered for the company.
CPY-BASE-CURRENCY Alpha 5 AP00.4 AP956
Base Currency The base currency defined for the
company in the Lawson General Ledger
system.
CPY-CURR-ND Numeric 1 AP00.4 AP956
Currency Number of The number of decimal positions defined
Decimals for the company base currency.
CPY-ADV-EXP-OPT Alpha 1 AP00.4 AP956
Advance-Expense Indicates how the Lawson Accounts
Matching Payable system processes employee
advances and expenses entered in the
Lawson Employee Advance and Expense
system.
If the company has the Open option
selected, specific matching is not
performed. All open items for the
employee are considered during
reconciliation. If the company has the
Matching option selected, each open
employee advance is matched to its
corresponding open expense. Valid values
are:
O = Open.
M = Matching.
CPY-PURGE-FL Alpha 1 AP00.4 AP956
Status Indicates the status of the company.
Used to determine whether the company
and associated data can be deleted from
the Lawson Accounts Payable system by
AP305 (AP Company Purge). Valid values
are:
A = Active.
D = Delete.
CPY-DISCOUNT-CODE Alpha 10 AP00.4 AP956
Discount Code The discount code assigned to the
company. Represents a general ledger
discount account. A unique entry in this
field creates a record in the Discount
Code file.
CPY-INC-ACCR-CODE Alpha 10 AP00.4 AP956
Income Withholding The income withholding code assigned to
Code the company. Represents the general
ledger income withholding account for
the company. Used to track reportable
withholding for vendors. A unique entry
in this field creates a record in the
Income Withholding Code file.
CPY-INC-WH-PCT Signed 5.3 AP00.4 AP956
Withholding Rate The reportable income withholding rate
for the company. The system applies this
rate to payments for vendors marked for
income withholding.
CPY-RET-MEMO-FL Alpha 1 AP00.4 AP956
Create Debit Memo Indicates whether to make a reduction
to a vendor's payment for an item that
is returned to the vendor. Valid values
are:
N = No (default).
Y = Yes.
CPY-ERS-AUTO-REL Alpha 1 AP00.4 AP956
ERS Invoice Auto Indicates whether the company
Release automatically releases invoices created
from receipts in the evaluated receipts
settlements process (pay on receipt).
Valid values are:
N = No.
Y = Yes.
CPY-EDI-AUTO-REL Alpha 1 AP00.4 AP956
EDI Invoice Auto Indicates whether the company
Release automatically releases EDI invoices in
MA540 (EDI Line Level Match). If this
field is Yes, then invoices that are
matched or interfaced cleanly are
interfaced in a released status. Valid
values are:
N = No.
Y = Yes.
CPY-ERS-LOC-CNTRL Alpha 1 AP00.4 AP956
ERS Location Control Indicates whether the company controls
ERS by ship-to location. Valid values
are:
N = No.
Y = Yes.
CPY-OUT-BAL-FL Alpha 1 AP00.4 AP956
Release Out of Indicates whether out of balance
Balance invoices can be released. This field can
be Yes only if the Workflow field is
Yes. Valid values are:
N = No.
Y = Yes.
CPY-APPRVL-EXISTS Alpha 1 AP00.8 AP956
Approval Exists Indicates whether approval criteria is
defined for the company. If Yes, an
associated record exists for the company
in the Invoice Approval file. Valid
values are:
N = No.
Y = Yes.
CPY-DISC-TAX-RCV Alpha 1 AP00.4 AP956
Tax Recovery on If discounts are to be taken for the
Discount company exclusive of tax, this field
indicates whether tax recovery is
required when discounts are taken. Valid
values are:
N = No.
Y = Yes.
CPY-WORKFLOW Alpha 1 AP00.4 AP956
Workflow Indicates whether the company uses
Workflow. If Yes, invoices that meet or
exceed approval criteria defined for the
company are routed to a workflow system
for approval. Valid values are:
N = No.
Y = Yes.
CPY-ERS-COST-UPD Alpha 1 AP00.4 AP956
ERS Cost Update Indicates whether the company can
adjust invoice cost at receipt time.
Valid values are:
N = No.
Y = Yes.
CPY-VAT-RPTG-RQD Alpha 1 AP00.4
VAT Reporting Indicates whether VAT reporting is
Required required for the AP company.
Y = Yes
N = No
CPY-CREATE-TR-DIST Alpha 1 AP00.4
Create Transit Create in-transit-distributions.
Distributions When this field is set to "Y" (yes),
expenses pertaining to an invoice at the
time of entry (AP23) will be assigned an
in-transit expense account. This will
support a method needed to allow AP
invoices to be quickly entered to the
system so that the tax liability can be
recorded as quickly as possible. Due to
a high volume of invoices that can be
received, it is important that a quick
invoice entry screen (AP23.1) allow key
information for invoices to be entered
as quickly as possible with a minimum of
key-strokes. Key information to be
included will be the invoice number,
vendor, voucher number, invoice amount,
payment terms, tax code, and tax amount.
The actual account to which expenses are
to be posted is not entered when the
invoice is entered. This method
therefore will assign the expense to an
in-transit expense account.
Y = Assign to in-transit exp. acct
N = Do not assign to in-transit.
CPY-DIST-CODE Alpha 9 AP00.4
Distribution Code 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.
CPY-BRANCH-ID Alpha 3
Branch ID Use this field if you need to provide a
company branch ID on your Intrastat
report.
CPY-VAT-REG-CTRY Alpha 2
VAT Registration The country component of the VAT
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
CPY-VAT-REG-NBR Alpha 12
VAT Registration The number component of the VAT
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
CPY-VAT-NBR Derived
VAT Number The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
APCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPYSET1 COMPANY This index is used to verify or access AC03.4 AC440
an accounts payable company record. AC50.1 AC500
AC52.1 AC520
AM18.1 AP00.4
AP00.6 AP00.7
AP00.8 AP01.4
AP02.2 AP05.2
AP05.3 AP05.6
AP101 AP102
AP12.1 AP12.2
AP125 AP126
AP135 AP150
AP151 AP155
AP156 AP157
AP160 AP161
...
CPYSET2 VENDOR-GROUP This index is used to identify which AP00.1 AP01.1
COMPANY accounts payable companies are assigned AP10.1 AP10.2
to a specific vendor group. AP10.5 AP10.6
AP10.7 AP102
KeyChange AP200 AP230
AP250 AP300
AP90.7
CPYSET3 PAY-GROUP This index is used to verify or access
COMPANY company records for a specific pay
group.
KeyChange
APCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvengroup APVENGROUP Required
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP (VGPSET1)
Cucodes CUCODES Required
CPY-BASE-CURRENCY -> CUC-CURRENCY-CODE
Gladdress GLADDRESS Required
CPY-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Spaces -> GAD-ADDR-TYPE
Glsystem GLSYSTEM Required
CPY-COMPANY -> GLS-COMPANY
APCOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apaudit APAUDIT
CPY-VENDOR-GROUP -> APA-VENDOR-GROUP
CPY-COMPANY -> APA-COMPANY
APA-PROC-LEVEL
APA-VENDOR
APA-INVOICE
APA-SUFFIX
APA-CANCEL-SEQ
APA-SEQ-NBR
APA-TRANS-DATE
APA-TRANS-TIME
Apauthor APAUTHOR
CPY-COMPANY -> ATR-COMPANY
ATR-AUTH-CODE
Apbatch APBATCH
CPY-COMPANY -> APB-COMPANY
APB-BATCH-NUM
Apcomments APCOMMENTS Delete Cascades
"I" -> APC-REC-TYPE
CPY-COMPANY -> APC-COMPANY
APC-VENDOR
APC-LOCATION-CODE
APC-INVOICE
APC-SUFFIX
APC-SEQ-NBR
Apdistcode APDISTCODE
CPY-COMPANY -> DTC-COMPANY
DTC-DIST-CODE
DTC-SEQ-NBR
Apinvoice APINVOICE
CPY-COMPANY -> API-COMPANY
API-VENDOR
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
Apmonitor APMONITOR
CPY-COMPANY -> MON-COMPANY
MON-BATCH-NUM
MON-AUTH-CODE
MON-RUN-PROG
MON-PROC-LEVEL
MON-PAY-GROUP
MON-PROC-GRP
Appayment APPAYMENT
CPY-COMPANY -> APP-COMPANY
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
Approclev APPROCLEV Required
CPY-COMPANY -> APR-COMPANY
APR-PROC-LEVEL
Apvcomments APCOMMENTS Delete Cascades
"V" -> APC-REC-TYPE
CPY-COMPANY -> APC-COMPANY
APC-VENDOR
APC-LOCATION-CODE
APC-INVOICE
APC-SUFFIX
APC-SEQ-NBR
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
VEN-VENDOR
Cbcheck CBCHECK
CPY-PAY-GROUP -> CHK-PAY-GROUP
CHK-REC-STATUS
CHK-CASH-CODE
CHK-BANK-INST-CODE
CHK-TRANS-NBR
CHK-TRANS-IDENT
Cbcpycash CBCPYCASH
CPY-COMPANY -> CBY-COMPANY
CBY-CASH-CODE
Draft Accepted APDRAFTS
CPY-PAY-GROUP -> APT-PAY-GROUP
2 -> APT-REC-STATUS
APT-DRAFT-DATE
APT-BANK-INST-CODE
APT-DRAFT-NBR
APT-SUFFIX
APT-TRANS-IDENT
Draft Unaccept APDRAFTS
CPY-PAY-GROUP -> APT-PAY-GROUP
1 -> APT-REC-STATUS
APT-DRAFT-DATE
APT-BANK-INST-CODE
APT-DRAFT-NBR
APT-SUFFIX
APT-TRANS-IDENT
Draft Unrel APDRAFTS
CPY-PAY-GROUP -> APT-PAY-GROUP
Zeroes -> APT-REC-STATUS
APT-DRAFT-DATE
APT-BANK-INST-CODE
APT-DRAFT-NBR
APT-SUFFIX
APT-TRANS-IDENT
Open Payments APPAYMENT
CPY-COMPANY -> APP-COMPANY
APP-VENDOR
APP-INVOICE
APP-SUFFIX
APP-CANCEL-SEQ
APP-SEQ-NBR
APP-VOID-SEQ
|