APCOMPANY

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 AC17.4 AC18.3 AC191
AC203 AC210 AC217 AC218 AC297 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 AP02.1 AP02.2
AP05.2 AP05.3 AP05.6 AP05.7 AP12.1 AP130
AP133 AP135 AP136 AP151 AP155 AP156
AP160 AP161 AP170 AP176 AP178 AP180
AP181 AP190 AP191 AP193 AP195 AP197
AP199 AP205 AP211 AP212 AP213 AP221
AP233 AP240 AP251 AP252 AP265 AP272
AP28.1 AP28.2 AP282 AP284 AP295 AP32.1
AP33.1 AP35.1 AP36.1 AP36.2 AP41.1 AP45.1
AP45.3 AP45.4 AP52.1 AP52.2 AP52.3 AP52.6
AP52.7 AP55.1 AP55.2 AP56.1 AP56.2 AP57.2
AP80.1 AP80.2 AP92.3 AP92.4 AP93.3 AP93.4
AP95.1 AP95.2 AP95.3 AP96.1 AP96.2 AP96.3
AP96.4 AP97.2 ZA161 AR01.1 AR08.1 AR10.1
AR501 AR550 ARLL.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 CB56.2 CB57.1 CB80.1 CB82.1 CX05.1
CX05.2 CX205 CX805 EE05.1 EE05.2 EE11.1
EE135 EE175 EE20.1 EE20.2 EE20.3 EE20.4
EE220 EE230 EE235 EE30.1 EE35.1 EE35.2
EE52.1 EE52.2 EE520 EE90.1 EE90.2 EE90.3
HR00.1 HR01.1 IC02.1 IC10.1 IC10.2 IC12.1
IC12.2 IC125 IC130 IC141 IC145 IC175
IC182 IC225 IC226 IC263 IC266 IC270
IC281 IC282 IC285 IC320 IC330 IC331
IC36.1 IC45.1 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC598 IC62.1
IC62.4 IC63.1 IC81.1 IC81.2 IC812 IC82.1
IC84.1 IC84.2 ICLM.1 PC120 ZC522 EX12.1
EX14.1 EX14.2 EX175 EX542 EX545 MA08.1
MA126 MA208 MA231 MA236 MA26.1 MA264
MA278 MA53.1 MA53.2 MA53.3 MA53.4 MA54.1
MA54.2 MA54.3 MA54.8 MA54.9 MA540 MA62.7
MA64.1 MA64.2 MA64.3 MA64.4 MA64.5 MA64.6
MA64.8 MA64.9 MA730 MA90.1 MA90.2 MA90.3
MA90.4 MA90.5 MA90.6 MA91.1 MA95.1 MA95.2
MAED.1 PD01.2 PO01.1 PO130 PO132 PO133
PO135 PO139 PO16.1 PO222 PO224 PO228
PO230 PO231 PO234 PO251 PO258 PO26.1
PO26.2 PO26.4 PO26.5 PO274 PO275 PO276
PO277 PO280 PO295 PO529 PO53.4 PO58.1
PO58.2 PO63.1 PO64.1 PO66.1 PO67.1 PO81.1
PO94.1 POED.1 POI7.1 POIF.1 POIG.1 POIM.1
POIT.1 PR198 MM280 MM80.1 MM80.2 RQ11.1
RQ111 RQIB.1 RQIC.1 RQID.1 RQIG.1 RQIH.1
RQII.1 RQIJ.1 TX04.1 TX140 TX40.1 WH140
AM18.1 AP01.4 AP01.1 AP06.1 AP185 AP200
AP201 AP214 AP235 AP236 AP237 AP275
AP912 AP98.3 EE275 GL284 GL285 MA01.1
MA05.1 MA05.6 MA167 PO240 POA2.4 IN120
IN20.1 WH02.1 WH38.1


UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP00.1 AP00.4 AP00.6 AP03.3 AP10.1 AP10.2
AP101 AP102 AP110 AP115 AP125 AP126
AP131 AP141 AP145 AP146 AP150 AP175
AP198 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP21.1 AP210 AP220 AP23.1
AP230 AP245 AP25.1 AP25.2 AP250 AP26.1
AP27.1 AP270 AP271 AP30.2 AP30.4 AP300
AP305 AP40.1 AP510 AP520 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC140 IC142 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 IC840 MX123
MX500 MA168 MA180 MA279 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD235 PO10.1 PO100 PO101
PO120 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO223 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO27.2 PO278 PO28.2 PO29.1 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.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
PR05.1 PR05.3 PR226 PR247 PR26.1 PR47.1
PR514 UK47.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500 RQIF.1
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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPY-COMPANY
Element: Company
Numeric 4
The company number. Must be a valid company in General Ledger.
AP00.4
CPY-NAME
Element: Name
Alpha 30 (Lower Case)
The company name or description. An Accounts Payable company uses the name defined for the company in General Ledger.
AP00.4
CPY-DEFAULT-REF
Default
Distribution Reference
Alpha 1
The default reference value for the 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.
AP00.4
CPY-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group assigned to the company. Must be a valid record in the Vendor Group file.
AP00.4 IC81.2
WH30.4 WH31.4
WH32.4 WH40.1
WH40.2
CPY-PAY-GROUP
Element: Pay Group
Alpha 4
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.
AP00.4 AP101
CPY-BATCH-OPTION
Element: Batch Release
Alpha 1
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.
AP00.4
CPY-AUTO-BATCH
Automatic Batch
Numbering
Alpha 1
Indicates whether the system 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.
AP00.4
CPY-BATCH-CONTROL
Element: All Flag
Alpha 1
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.
AP00.4
CPY-LAST-BATCH
Element: Last Batch Number
Numeric 6
The last batch number used by the company. Used only if the company has Yes selected in the Automatic Batch Numbering field.
AP00.4 AP25.1
CPY-INV-APPROVAL
Element: All Flag
Alpha 1
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.
AP00.4
CPY-NUMERIC-VOUCH
Numeric Voucher
Numbers
Alpha 1
Indicates whether voucher values will be numeric. Used only if the company has Yes selected in the Invoice Approval field. Valid values are: Y = Yes. N = No.
AP00.4
CPY-DUP-VOUCHER
Duplicate Voucher
Numbers
Alpha 1
Indicates whether duplicate voucher 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.
AP00.4
CPY-AUTO-VOUCHER
Auto Voucher
Numbering
Alpha 1
Indicates whether the system 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.
AP00.4
CPY-LAST-VOUCHER
Element: Last Voucher Number
Numeric 10
The last voucher number assigned by the company. Used only if the company has Yes selected in both the Invoice Approval and Numeric Voucher Numbers fields. The system assigns voucher numbers beginning with the next sequential number. If left blank, the system assigns voucher numbers beginning with 1.
AP00.4 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP23.1
AP520 API1.1
API2.1 MA168
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA44.1 MA44.2
CPY-POST-OPTION
Element: Post Option
Alpha 1
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.
AP00.4
CPY-INVOICE-AUDIT
Audit Invoice
Changes
Alpha 1
Indicates whether the system creates audit records when released invoices are changed. Valid values are: Y = Yes. N = No.
AP00.4
CPY-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
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.
AP00.4
CPY-CASH-CODE
Element: Cash Code
Alpha 4
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.
AP00.4
CPY-BASE-CURRENCY
Element: Base Currency
Alpha 5
The base currency defined for the company in General Ledger.
AP00.4
CPY-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AP00.4
CPY-ADV-EXP-OPT
Advance-Expense
Matching
Alpha 1
Indicates how the Lawson Accounts 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.
AP00.4
CPY-PURGE-FL
Element: Status
Alpha 1
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.
AP00.4
CPY-DISCOUNT-CODE
Element: Discount Code
Alpha 10
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.
AP00.4
CPY-INC-ACCR-CODE
Income Withholding
Code
Alpha 10
The income withholding code assigned to 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.
AP00.4
CPY-INC-WH-PCT
Element: Withholding Rate
Signed 5.3
The reportable income withholding rate for the company. The system applies this rate to payments for vendors marked for income withholding.
AP00.4
CPY-OUT-BAL-FL
Element: Account Flag
Alpha 1
Indicates whether out of balance invoices can be released. Valid values are: N = No. Y = Yes.
AP00.4
CPY-APPRVL-EXISTS
Element: Apprvl Exists
Alpha 1
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.
AP00.6
CPY-DISC-TAX-RCV
Element: All Flag
Alpha 1
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.
AP00.4
CPY-WORKFLOW
Element: All Flag
Alpha 1
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.
AP00.4
CPY-DISC-CALC-DATE
Discount
Calculation Date
Alpha 1
Indicates which date to use when 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
AP00.4
CPY-VOUCHER-REQ
Element: Voucher Required
Alpha 1
Indicates if a voucher is required. Valid values are: N = No Y = Yes
AP00.4
CPY-BEST-TERMS
Element: Recalculate Terms
Alpha 1
Indicates whether to recalculate the terms during matching.
N = No
Y = Yes
AP00.4
CPY-LAST-ARCH-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
CPY-CREATE-TR-DIST
Element: Create Tr Dist
Alpha 1
AP00.4
CPY-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.4
CPY-WKFL-DST-ADJ
Element: Wkfl Dst Adj
Alpha 1

N = No
Y = Yes
AP00.4
CPY-FLOAT-DAYS
Element: Float Days
Numeric 3
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.
AP00.4
CPY-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP00.4
CPY-TAX-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
AP00.4
CPY-TAX-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AP00.4
CPY-TAX-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AP00.4
CPY-TAX-TOL-AMT
Element: Intl Amt
Signed 18.2
AP00.4
CPY-HOLD-CODE
Element: Hold Code
Alpha 4
The hold code.
AP00.4
CPY-PCARD-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
PD130
CPY-RET-ACCR-CODE
Element: Accr Code
Alpha 4
AP00.4
CPY-VERTEX-INV-TAX
Element: Vertex Inv Tax
Alpha 1
nndicates if a record should be created in the Vertex system for Invoice tax transactions. If this value is set to "1" then no record will be created in the Vertex system
1 = Do not create Vertex for Inv


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 AC297
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
CPYSET2 VENDOR-GROUP
COMPANY
KeyChange
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.1 AP01.1
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP10.7
AP102 AP110
AP115 AP125
CPYSET3 PAY-GROUP
COMPANY
KeyChange
AP141


APCOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
  APA-LOCATION-CODE
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


File created: Thu Jun 09 11:07:17 2016

Home
Contact Us



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