|
|
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 AC03.7 AC145 AC160 AC17.4 AC18.3
AC191 AC203 AC210 AC217 AC218 AC41.1
AC41.4 AC42.1 AC42.2 AC440 AC46.1 AC50.1
AC500 AC52.1 AC520 AC54.1 AC540 AC69.2
AC92.2 AC92.4 AC92.6 ACAC.1 AM115 AM117
AM15.1 AM15.2 AM15.3 AM15.4 AM18.1 AM19.1
AM19.2 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP01.4 AP01.1 AP02.2
AP05.2 AP05.3 AP05.6 AP05.7 AP06.1 AP102
AP115 AP12.1 AP125 AP126 AP130 AP131
AP135 AP136 AP141 AP150 AP151 AP155
AP156 AP160 AP161 AP170 AP176 AP178
AP180 AP181 AP185 AP190 AP191 AP193
AP195 AP197 AP199 AP200 AP201 AP205
AP211 AP212 AP213 AP214 AP220 AP221
AP230 AP235 AP236 AP237 AP240 AP250
AP251 AP252 AP26.1 AP265 AP27.1 AP270
AP272 AP275 AP28.1 AP28.2 AP282 AP284
AP295 AP30.1 AP30.2 AP30.3 AP30.4 AP300
AP32.1 AP35.1 AP36.1 AP36.2 AP40.1 AP41.1
AP45.1 AP510 AP52.1 AP52.2 AP52.3 AP52.6
AP52.7 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 AP91.5 AP91.6 AP91.1 AP912
AP92.3 AP92.4 AP93.3 AP93.4 AP95.1 AP95.2
AP95.3 AP96.1 AP96.2 AP96.3 AP96.4 AR01.1
AR08.1 AR10.1 AR115 AR120 AR124 AR190
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR32.1 AR34.1 AR42.1 AR42.2 AR42.7
AR43.1 AR48.1 AR48.3 AR48.4 AR501 AR550
AR560 AR570 AR575 AR580 ARLL.1 BL02.1
BL120 BL122 BL130 BL140 BL141 BL20.1
BL20.3 BL202 BL21.2 BL21.5 BL240 BL29.1
BL29.2 BL340 BL41.1 BL520 BL80.1 BL802
BL820 BL92.1 BR40.3 BR43.1 BR46.1 BRIP.1
CB06.1 CB06.2 CB10.1 CB150 CB170 CB180
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
DT180 DT181 EE05.1 EE05.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 ET09.1
ET09.2 ET175 ET530 ET540 ET542 ET545
GL284 GL285 HR00.1 HR01.1 IC02.1 IC12.1
IC12.2 IC130 IC320 IC330 IC812 ICLM.1
MX500 MA01.1 MA05.1 MA05.6 MA08.1 MA126
MA167 MA180 MA208 MA231 MA236 MA264
MA278 MA279 MA310 MA53.1 MA53.2 MA53.3
MA53.4 MA530 MA531 MA54.1 MA54.2 MA54.3
MA54.8 MA54.9 MA540 MA60.1 MA60.2 MA60.3
MA60.4 MA60.5 MA60.7 MA61.1 MA62.7 MA63.1
MA63.2 MA64.1 MA64.2 MA64.3 MA64.4 MA64.5
MA64.6 MA64.8 MA65.1 MA66.1 MA66.2 MA66.3
MA66.8 MA67.1 MA67.2 MA67.3 MA68.1 MA68.2
MA68.3 MA68.4 MA68.5 MA68.7 MA69.1 MA69.2
MA69.7 MA70.1 MA75.1 MA80.1 MA90.1 MA90.2
MA90.3 MA90.4 MA90.5 MA91.1 MA95.1 MA95.2
MAI1.1 PD01.2 PD10.1 PD10.2 PD20.1 PD20.2
PD20.3 PO01.1 PO10.1 PO10.2 PO100 PO101
PO120 PO122 PO130 PO131 PO132 PO133
PO135 PO136 PO139 PO16.1 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO224 PO228 PO23.1 PO23.7
PO230 PO231 PO233 PO234 PO24.1 PO240
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO253
PO254 PO258 PO26.1 PO27.2 PO274 PO275
PO276 PO277 PO278 PO280 PO29.1 PO295
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.1 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 PO529 PO53.4 PO536
PO54.1 PO54.2 PO54.3 PO54.4 PO58.1 PO58.2
PO63.1 PO64.1 PO66.1 PO67.1 PO81.1 PO94.1
POA2.4 POED.1 POI3.1 POI7.1 POID.1 POIF.1
POIG.1 POII.1 POIJ.1 POIM.1 POIT.1 PR05.1
PR05.3 PR198 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 PW110 PW510 MM280 MM80.1
MM80.2 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQII.1
RQIJ.1 IN120 IN20.1 TX04.1 TX140 TX40.1
WH02.1 WH130 WH132 WH140 WH190 WH20.2
WH20.7 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH38.1 WH40.1 WH40.2 WH520 WH830 AP03.3
AP10.1 AP10.5 AP10.6 AP10.7 AP110 AP145
AP146 AP210 AP245 API3.1 API4.1 MX123
PD235
UPDATED BY
AP00.4 AP00.6 AP101 AP175 AP198 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP21.1 AP23.1 AP25.1 AP305 AP520 API1.1
API2.1 MA168 MA41.1 MA41.2 MA41.4 MA41.7
MA43.2 PD130
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPY-COMPANY Numeric 4 AP00.4
Element: Company The company number. Must be a valid
company in General Ledger.
CPY-NAME Alpha 30 (Lower Case) AP00.4
Element: Name The company name or description. An
Accounts Payable company uses the name
defined for the company in General
Ledger.
CPY-DEFAULT-REF Alpha 1 AP00.4
Default The default reference value for the
Distribution Reference company. 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 WH30.4
Element: Vendor Group The vendor group assigned to the WH31.4 WH32.4
company. Must be a valid record in the WH40.1 WH40.2
Vendor Group file.
CPY-PAY-GROUP Alpha 4 AP00.4 AP101
Element: Pay Group The pay group assigned to the company.
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
Element: 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
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
Element: All Flag 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
Element: Last Batch NumThe last batch number used by the
company. Used only if the company has
Yes selected in the Automatic Batch
Numbering field.
CPY-INV-APPROVAL Alpha 1 AP00.4
Element: All Flag 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
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
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
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
Element: Last Voucher NThe last voucher number assigned by the AP20.2 AP20.3
company. Used only if the company has AP20.4 AP20.5
Yes selected in both the Invoice AP20.6 AP20.7
Approval and Numeric Voucher Numbers AP21.1 AP23.1
fields. The system assigns voucher AP520 API1.1
numbers beginning with the next API2.1 MA168
sequential number. If left blank, the MA41.1 MA41.2
system assigns voucher numbers beginning MA41.4 MA41.7
with 1. MA43.2
CPY-POST-OPTION Alpha 1 AP00.4
Element: Post 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
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
Element: Invoice AccruaThe 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
Element: 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
Element: Base Currency The base currency defined for the
company in General Ledger.
CPY-CURR-ND Numeric 1 AP00.4
Element: Acct Nd The number of decimal positions defined
for the company base currency.
CPY-ADV-EXP-OPT Alpha 1 AP00.4
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
Element: 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
Element: 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
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
Element: Withholding RaThe reportable income withholding rate
for the company. The system applies this
rate to payments for vendors marked for
income withholding.
CPY-OUT-BAL-FL Alpha 1 AP00.4
Element: Account Flag Indicates whether out of balance
invoices can be released. Valid values
are:
N = No.
Y = Yes.
CPY-APPRVL-EXISTS Alpha 1 AP00.6
Element: Apprvl 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
Element: All Flag If discounts are to be taken for the
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
Element: All Flag 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-DISC-CALC-DATE Alpha 1 AP00.4
Discount Indicates which date to use when
Calculation Date calculating discounts.
You can use the invoice date, receipt
date, or the date the invoice was
received.
Valid values are:
I = Invoice date
R = Receipt date
D = Receipt of invoice date
E = Earliest Receipt Date
S = Ship to Arrive Date
CPY-VOUCHER-REQ Alpha 1 AP00.4
Element: Voucher RequirIndicates if a voucher is required.
Valid values are:
N = No
Y = Yes
CPY-BEST-TERMS Alpha 1 AP00.4
Element: Recalculate TeIndicates whether to recalculate the
terms during matching.
N = No
Y = Yes
CPY-LAST-ARCH-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
CPY-CREATE-TR-DIST Alpha 1 AP00.4
Element: Create Tr Dist
CPY-DIST-CODE Alpha 9 AP00.4
Element: Dist 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-WKFL-DST-ADJ Alpha 1 AP00.4
Element: Wkfl Dst Adj N = No
Y = Yes
CPY-FLOAT-DAYS Numeric 3 AP00.4
Element: Float Days THis is a number of days to add to best
terms calculation if the vendor will
allow a specific number of days for
payment to reach them and still receive
the discount.
CPY-TAX-CODE Alpha 10 AP00.4
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CPY-TAX-ACCT-UNIT Alpha 15 AP00.4
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
CPY-TAX-ACCOUNT Numeric 6 AP00.4
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
CPY-TAX-SUB-ACCT Numeric 4 AP00.4
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
CPY-TAX-TOL-AMT Signed 18.2 AP00.4
Element: Intl Amt
CPY-HOLD-CODE Alpha 4 AP00.4
Element: Hold Code The hold code.
CPY-PCARD-INVOICE Alpha 22 PD130
Element: Invoice Used to identify the invoice.
APCOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPYSET1 COMPANY AC03.4 AC03.7
AC145 AC160
AC17.4 AC18.3
AC191 AC203
AC210 AC217
AC218 AC41.1
AC41.4 AC42.1
AC42.2 AC440
AC46.1 AC50.1
AC500 AC52.1
AC520 AC54.1
AC540 AC69.2
AC92.2 AC92.4
AC92.6 ACAC.1
AM115 AM117
...
CPYSET2 VENDOR-GROUP KeyChange AC160 AM115
COMPANY AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.1
AP01.1 AP03.3
AP10.1 AP10.5
AP10.6 AP10.7
AP102 AP110
AP115 AP125
AP126 AP131
...
CPYSET3 PAY-GROUP KeyChange AP141
COMPANY
APCOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Addrdata ADDRDATA Not Required
GAD-ADDR-CODE -> GDD-ADDR-CODE
Apvengroup APVENGROUP Required
CPY-VENDOR-GROUP -> VGP-VENDOR-GROUP
Cucodes CUCODES Required
CPY-BASE-CURRENCY -> CUC-CURRENCY-CODE
Gladdress GLADDRESS Required
CPY-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
Glsystem GLSYSTEM Required
CPY-COMPANY -> GLS-COMPANY
Macompany MACOMPANY Not Required
CPY-COMPANY -> MAY-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
Apcinvoice APCINVOICE
CPY-COMPANY -> CVI-COMPANY
CVI-VENDOR
CVI-EDI-NBR
CVI-INVOICE
CVI-SUFFIX
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-ADA-ACCT-STRCT
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-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
|
