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
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CPY-COMPANY Element: Company | Numeric 4 The company number. Must be a valid company in General Ledger. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| CPY-BASE-CURRENCY Element: Base Currency | Alpha 5 The base currency defined for the company in General Ledger. |
|
||||||||||||||||||||||
| CPY-CURR-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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 |
|
||||||||||||||||||||||
| CPY-VOUCHER-REQ Element: Voucher Required | Alpha 1 Indicates if a voucher is required. Valid values are: N = No Y = Yes |
|
||||||||||||||||||||||
| CPY-BEST-TERMS Element: Recalculate Terms | Alpha 1 Indicates whether to recalculate the terms during matching. N = No Y = Yes |
|
||||||||||||||||||||||
| CPY-LAST-ARCH-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||||||||||||
| CPY-CREATE-TR-DIST Element: Create Tr Dist | Alpha 1 |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| CPY-WKFL-DST-ADJ Element: Wkfl Dst Adj | Alpha 1 N = No Y = Yes |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| CPY-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| 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. |
|
||||||||||||||||||||||
| CPY-TAX-TOL-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
| CPY-HOLD-CODE Element: Hold Code | Alpha 4 The hold code. |
|
||||||||||||||||||||||
| CPY-PCARD-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||||||||||||||||||||
| CPY-RET-ACCR-CODE Element: Accr Code | Alpha 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CPYSET1 |
COMPANY |
|
|||||||||
| CPYSET2 |
VENDOR-GROUP COMPANY |
|
|||||||||
| CPYSET3 |
PAY-GROUP COMPANY |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Addrdata | ADDRDATA |
Not Required
| ||||||
| Apvengroup | APVENGROUP |
Required
| ||||||
| Cucodes | CUCODES |
Required
| ||||||
| Gladdress | GLADDRESS |
Required
| ||||||
| Glsystem | GLSYSTEM |
Required
| ||||||
| Macompany | MACOMPANY |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apaudit | APAUDIT |
| |||||||||||||||||||||||||||||||||
| Apauthor | APAUTHOR |
| |||||||||||||||||||||||||||||||||
| Apbatch | APBATCH |
| |||||||||||||||||||||||||||||||||
| Apcinvoice | APCINVOICE |
| |||||||||||||||||||||||||||||||||
| Apdistcode | APDISTCODE |
| |||||||||||||||||||||||||||||||||
| Apinvoice | APINVOICE |
| |||||||||||||||||||||||||||||||||
| Apmonitor | APMONITOR |
| |||||||||||||||||||||||||||||||||
| Appayment | APPAYMENT |
| |||||||||||||||||||||||||||||||||
| Approclev | APPROCLEV |
Required
| |||||||||||||||||||||||||||||||||
| Apvcomments | APCOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||
| Apvenmast | APVENMAST |
Required
| |||||||||||||||||||||||||||||||||
| Cbcheck | CBCHECK |
| |||||||||||||||||||||||||||||||||
| Cbcpycash | CBCPYCASH |
| |||||||||||||||||||||||||||||||||
| Draft Accepted | APDRAFTS |
| |||||||||||||||||||||||||||||||||
| Draft Unaccept | APDRAFTS |
| |||||||||||||||||||||||||||||||||
| Draft Unrel | APDRAFTS |
| |||||||||||||||||||||||||||||||||
| Open Payments | APPAYMENT |
|
All trademarks and registered trademarks are the property of their
respective owners.