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 AC17.4 AC210 ACAC.1 AM18.1
AP02.1 AP02.2 AP05.2 AP05.3 AP05.6 AP05.7
AP06.1 AP12.1 AP130 AP133 AP135 AP136
AP151 AP155 AP156 AP160 AP161 AP170
AP176 AP178 AP180 AP181 AP185 AP190
AP191 AP193 AP195 AP197 AP199 AP201
AP205 AP211 AP212 AP213 AP214 AP221
AP233 AP235 AP236 AP237 AP240 AP251
AP252 AP265 AP272 AP275 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
AP912 AP92.3 AP92.4 AP93.3 AP93.4 AP95.1
AP95.2 AP95.3 AP96.1 AP96.2 AP96.3 AP96.4
AP97.2 AP98.3 AR01.1 AR08.1 AR10.1 AR501
AR550 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 EE05.1 EE05.2 EE11.1 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 ICLM.1 EX175
EX542 EX545 MA05.1 MA05.6 MA08.1 MA208
MA54.1 MA54.2 MA54.3 MA54.8 MA54.9 MA540
MAED.1 PO01.1 PO53.4 PO64.1 POED.1 POI7.1
POIF.1 POIG.1 POIM.1 PR198 MM280 IN120
IN20.1 TX04.1 TX140 TX40.1


UPDATED BY
AP00.4 AP00.6 AP00.1 AP101 AP175 AP198
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP305
AP520 API1.1 API2.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 AM115 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 AP01.1
AP102 AP115 AP125 AP126 AP131 AP141
AP150 AP200 AP220 AP230 AP250 AP26.1
AP27.1 AP270 AP30.2 AP30.4 AP300 AP40.1
AP510 AP90.1 AP91.1 MX500 MAI1.1 PO10.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 AP03.3 AP10.1
AP110 AP145 AP146 AP210 AP245 API3.1
API4.1 MX123

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
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 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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.
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
AC17.4 AC210
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
AP00.4 AP00.5
AP00.6 AP01.4
AP02.1 AP02.2
AP05.2 AP05.3
CPYSET2 VENDOR-GROUP
COMPANY
KeyChange
...
AM115 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 AP141
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: Wed Jun 08 20:47:28 2016

Home
Contact Us



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