Accounts Receivable Company
The AR Company file contains the accounts receivable company records. A company record contains the highest set of processing rules that are used for customers that have been identified with that company. Prior to adding a company to this file, the same company number must be a valid company in the Lawson General Ledger or General Ledger Interface system.
REFERENCED BY
AR01.1 | ARLL.1 | CB06.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
ACO-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
||||
ACO-CUST-GROUP Element: Customer Group | Alpha 5 Customer group assigned to this company. Only customers initially defined with this customer group are eligible to be customers of this company. |
|
||||
ACO-NAME Element: Company Name | Alpha 30 (Lower Case) The name or description of the Accounts Receivable company. The name defaults from General Ledger unless you override it in Accounts Receivable. |
|
||||
ACO-ADDR1 Element: Address 1 | Alpha 30 (Lower Case) First line of address information. Defaults from the general ledger or interface company address and will be maintainable once it is initially added. |
|
||||
ACO-ADDR2 Element: Address 2 | Alpha 30 (Lower Case) Second line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-ADDR3 Element: Address 3 | Alpha 30 (Lower Case) Third line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-ADDR4 Element: Address 4 | Alpha 30 (Lower Case) Fourth line of address information. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-CITY Element: City | Alpha 18 (Lower Case) City Name. Defaults from the general ledger or interface company address and will be maintainable once it is initially added. |
|
||||
ACO-STATE Element: State or Province | Alpha 2 State or province abbreviation. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-ZIP Element: Postal Code | Alpha 10 Postal code. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-COUNTRY Element: Country or other | Alpha 30 (Lower Case) Country name. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-COUNTY Element: County | Alpha 25 (Lower Case) County. Defaults from the general ledger or interface company address, and will be maintainable once it is initially added. |
|
||||
ACO-PHONE-NMBR Element: Telephone Number | Alpha 15 The company phone number. |
|
||||
ACO-FAX-NMBR Element: Fax Number | Alpha 15 The company fax number. |
|
||||
ACO-CHRG-BACK-NBR Element: Chargeback Number | Numeric 7 This field will contain the last used transaction number for created chargebacks. The chargebacks will be in the form of debit memos in the open item file. This number will be prefixed by "CB-". |
|
||||
ACO-INV-BTCH-FL Auto Number Trans Batches | Alpha 1 Specifies whether the manual invoice batches will be automatically assigned. Valid values are: N = No automatic batch numbering Y = Automatic batch numbering |
|
||||
ACO-INV-BTCH-NBR Last Transaction Batch Number | Numeric 6 The last batch number assigned for manual invoice entry. |
|
||||
ACO-INV-BTCH-TL Trans Batch Control Totals | Alpha 1 This option allows system batch totals to be force balanced to header totals prior to release. Valid values are: N = No total balancing required Y = Total balancing required |
|
||||
ACO-AUTO-BTCH-FL Auto Number Cash Batches | Alpha 1 This option will specify whether or not automatic batch numbering will be used in cash entry. Valid values are: N = No automatic batch numbering Y = Automatic batch numbering |
|
||||
ACO-AUTO-BAT-NBR Last Auto Batch Number Used | Numeric 6 The last number assigned for the payment batch header. When a new batch is assigned, 1 will be added to this number and used to create the new batch record. This number can be maintained but cannot be changed to a value less than the highest batch number used. Note: This number sequence will also be used for lock box interfaced cash. |
|
||||
ACO-BTCH-CNTRL-TL Cash Batch Control Total | Alpha 1 This cash option allows system batch totals to be force balanced to control totals. Valid values are: N = No total balancing required Y = Control balancing required |
|
||||
ACO-SUMM-BTCH-NBR Element: Summary Batch Number | Numeric 6 The last system-assigned batch number used when creating chargeback records. |
|
||||
ACO-LAST-RTM-NBR Element: Last RTM Number | Numeric 7 Return-to-maker debit memo number. This is the numeric portion of the last RTM document to be generated by the system. RTM debit memos are identified by a preceding "RM-" followed by this ascending seven digit number. |
|
||||
ACO-LAST-CONV-BTCH Last Converted Batch Number | Numeric 3 The last payment batch number the system assigned to converted payments. The last 999 batch numbers (999000 - 999999) are reserved for this purpose. The system will not allow users to use batch numbers greater that 999000. |
|
||||
ACO-RISK-CD Element: Risk Code | Alpha 1 The default risk code that will be assigned to all new customers being added for this company. |
|
||||
ACO-OFFSET-FL Automatic Application | Alpha 1 Specifies if application will occur for cross referenced debits from a credit memo. Valid values are: N = No automatic memo application Y = Automatic memo application allowed |
|
||||
ACO-AR-CODE Element: AR Code | Alpha 4 The default accounts receivable code for the company level. |
|
||||
ACO-NOT-APPLD-CD Received Not Applied Code | Alpha 4 The default received not applied code at the company level. |
|
||||
ACO-PRE-PAY-CODE Element: Prepayment Code | Alpha 4 Prepayment code. This is the default code to be used for a check entered as a prepayment. This will be the offset instead of RNA to cash. |
|
||||
ACO-CUST-RETEN Last Customer Activity | Numeric 3 The number of months that must elapse, after the last customer activity date, before a customer can be automatically deleted. |
|
||||
ACO-AGE-CREDITS Element: Age Credits | Alpha 1 Specifies how credit memos should be aged. Valid values are: L = Aged to last debit-containing column N = Not aged - aged in current column R = Aged respective to credit memo date |
|
||||
ACO-AGE-PYMNT Element: Age Payment | Alpha 1 Specifies how payments should be aged. Valid values are: L = Aged to last debit-containing column N = Not aged - aged in current column R = Aged respective to payment date |
|
||||
ACO-AGE-DISPUTES Element: Age Disputes | Alpha 1 Specifies how disputed transactions will be aged. Valid values are: N = Not aged - aged in current column Y = Aged respective to transaction date |
|
||||
ACO-AGE-TYPE Element: Age Type | Alpha 1 Default aging method respecting either invoice date or due date. Valid values are: D = Age by due date T = Age by transaction date |
|
||||
ACO-AGE-CURRENT Element: Age Current | Numeric 3 This field will be used to define the transactions going into the "current" and "future" aging buckets. This provides the ability to have two aging columns (current and future) that reflect transactions that are not past invoice (for an invoice date based aging) or not past due (for a due date based aging). |
|
||||
ACO-AGE-PERIODS Element: Age Periods | Numeric 3 Occurs 4 Times Aging periods established by entering the last day of each period in these fields. If left blank, these periods will default from this company's assigned customer group. Future and current aging periods will be defined with a separate field. |
|
||||
ACO-DISPUTES-FIN Element: Finance Disputes | Alpha 1 Specifies if disputed transactions are exempt from being assessed finance charges. Valid values are: N = No finance charges on disputed items Y = Yes, subject to finance charges |
|
||||
ACO-OI-DISP-SEQ Element: Oi Disp Seq | Alpha 1 Indicates the default display sequence of the open items. Valid values are: 1 = Trans Type Number 2 = Due Date 3 = Open Amount 4 = Process Level 5 = Trans User 1 6 = Activity 7 = Customer PO |
|
||||
ACO-AUDIT-APP-FL Cash Application Operator Code | Alpha 1 Indicates if the operator code field is required during the entry of cash and during the application of cash. Valid values are: N = No - operator code not required Y = Yes - operator code required |
|
||||
ACO-AUDIT-MEMO-FL Memo/Invoice Operator Code | Alpha 1 Indicates if operator code is required during the entry of debit/credit memos or the entry of invoices. Valid values are: N = No - operator code not required Y = Yes - operator code required |
|
||||
ACO-APP-REVIEW-FL Element: Application Review | Alpha 1 Indicates if applications are required to go through an audit listing prior to applications being posted to the general ledger. Valid values are: N = No Y = Yes |
|
||||
ACO-DISC-GRACE-PD Discount Grade Period | Numeric 2 Number of grace days added to discount date to allow automatic discount during cash application. |
|
||||
ACO-LATE-PAY-FL Late Payment & Finance Charges | Alpha 1 Indicates what type of charges will be assessed. This option can be overridden at the default codes and customer levels. Valid values are: Blank = No charges F = Finance charges assessed L = Late payments charges assessed B = Both finance and late payment charges will be assessed |
|
||||
ACO-FIN-CALC-TYPE Finance Charge Calculation | Alpha 1 Determines how finance charges will be calculated. Depending upon this calculation type, finance charges will either be assessed individually for each overdue open item (Detail option) or one summary charge for the net amount of overdue open items (Net option). Valid values are: D = Detail calculation N = Net calculation |
|
||||
ACO-FIN-AUTO-NBR Last Finance Charge Number | Numeric 7 This field will hold the last finance charge number used by the system. It will contain an ascending seven digit number. The finance charge debit memo number will be prefixed with "FC-". |
|
||||
ACO-FIN-CHRG-CD Element: Finance Charge Code | Alpha 2 Finance charge code. This code must be predefined and will contain a monthly finance charge percentage rates. |
|
||||
ACO-FIN-GRAC-DAYS Finance Charge Grace Days | Numeric 2 The number of grace days added to a transaction's due date before finance charges will be assessed. |
|
||||
ACO-FIN-MIN-CHRG Minimum Finance Charge | Signed 7.2 Override minimum finance charge amount assessed if calculated finance charge is less than this minimum amount. If a minimum is zero, no override will occur. |
|
||||
ACO-FIN-DOC-PRNT Element: Fin Doc Prnt | Alpha 1 This option will specify whether or not finance charge documents are required to be printed. Valid values are: N = No finance charge documents printed Y = Yes, print finance charge documents |
|
||||
ACO-FIN-GL-CODE Element: Finance GL Code | Alpha 4 This is the default GL code to be used for finance charges at the company level. It is tied to the finance charge general ledger account. |
|
||||
ACO-CURRENCY-CD Element: Currency Code | Alpha 5 The base currency defined for the company in the Lawson General Ledger system. Used by the accounts receivable company for processing and reporting. Transactions entered in a non-base currency retain their original, transaction amounts and are converted to the company base currency. |
|
||||
ACO-MULTI-CURR-FL Element: Multi Currency Flag | Alpha 1 Determines if transactions in currencies differing from company base currency will be allowed. N = Not Multi Currency Y = Multi Currency |
|
||||
ACO-RATE-OVR-FL Conversion Rate Override | Alpha 1 Determines whether or not user will be able to override conversion rate tolerances when adding non company-based currency transactions. Valid values are: N = No Y = Yes |
|
||||
ACO-INV-CUR-OVR Invoice Currency Override | Alpha 1 Indicates whether users will be able to override the default customer invoice currency code when entering manual invoices. N = No Y = Yes |
|
||||
ACO-VERIFY-GLDATE Element: Verify GL Date | Alpha 1 Establishes whether the system should edit transaction's GL date against the GL date range set up in IF01 (System Control). Valid values are: N = No - do not general date editing Y = Yes - edit general ledger date |
|
||||
ACO-DFLT-APP-DATE Default Application Date | Alpha 1 Defines what default general ledger date the application records should have. Valid values are: P = Payment general ledger date S = System date |
|
||||
ACO-HOLD-CODE Element: Hold Code | Alpha 4 The Hold Code found on the company record is the default Hold Code to be used by AR70.2 (Analyst Review Detail). This code is available to be used by order processing systems to help make a decision on whether or not to process a particular customer's orders. |
|
||||
ACO-OVER-APP-FL Over Application Flag | Alpha 1 Determines whether users should be able to over apply a short payment to fully exhaust an invoice and create a chargeback for the remaining portion of the invoice. Valid values are: N = No, over-application not allowed Y = Yes, over-application allowed |
|
||||
ACO-DISC-DSP-FL Discount Display Flag | Alpha 1 Determines if past-due discount amounts will display during cash application. Valid values are: N = No past due discount amounts displayed Y = Display past due discounts |
|
||||
ACO-UPD-DUE-DATE Update Trans Date / Due Date | Alpha 1 Determines if transactions will be allowed to have their transaction or due date changed. This affects AR42.6 (Obligations), AR45.1 (Disputes), and DT42.1 (Bill of Exchange Maintenance). Valid values are: N = No, due date change not allowed Y = Yes, due date change allowed |
|
||||
ACO-INCOMPLETE-FL Element: Incomplete Company | Alpha 1 Indicates that the AR company is only partially set up. |
|
||||
ACO-BASE-ND Base Number of Decimals | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||
ACO-DISPLAY-DATE Element: Display Date | Alpha 1 Display date. This field will control the open obligation data displayed on the aging reports. It will work independently from the date used for aging. The transaction date will be the default with an option to display the due date. Payments and credits will always use GL date. Valid values are: T = Transaction date D = Due date (obligations only) |
|
||||
ACO-TRANS-SEQUENCE Element: Transaction Sequence | Alpha 1 Transaction sequence. This field will control the display sequence of the transactions in aging reports. This is within the runtime indicated report sequence. The due date option will use due dates from open obligation and GL dates from payments and credits. Valid values are: T = Transaction sequence D = Due date sequence |
|
||||
ACO-BANK-RISK-OPT Element: Bank Risk Option | Alpha 1 Bank risk option. This field will be used if the company is using bill of exchange processing. If so, this option will indicate if bank risk processing should be done. Valid values are: N = No; don't check bank risk Y = Yes; check bank risk |
|
||||
ACO-ACCEPT-ACCTING Acceptance Accounting | Alpha 1 Acceptance accounting. This option is only used if the company is doing bill of exchange processing. If so, the options are to post to bill of exchange receivable upon acceptance or to level the value in accounts receivable. Valid values are: Y = Yes; GL required at acceptance N = No; GL not required at acceptance |
|
||||
ACO-DT-ACCPT-CODE Element: BOE Acceptance Code | Alpha 4 Bill of exchange acceptance code. This option is only used if the company is processing bills of exchange. If so, this code will be required if the accept accounting option is equal to yes. It represents the BOE receivable account. This will edit to the GL Codes file in AR. |
|
||||
ACO-FIN-REV-CODE Financial Revenue Code | Alpha 4 Financial revenue code. This will be used if the company is processing bills of exchange. If so, this code will edit to the AR Codes file and will be used to post financial revenue. |
|
||||
ACO-FIN-EXP-CODE Financial Expense Code | Alpha 4 Financial expense code. This code will be used if the company is processing bills of exchange. If so, the code will edit to the AR GL Code file and be used to post the financial expenses to GL. |
|
||||
ACO-DIS-EXP-CODE Dishonored Expense Code | Alpha 4 Dishonored expense code. This code will be used if the company is processing bills of exchange. If so, the code will be used to post to GL any dishonored bill of exchange expenses. |
|
||||
ACO-LAST-DRAFT-NBR Last Bill of Exchange Number | Numeric 10 Last bill of exchange number assigned. This will be used only if the company will be processing bills of exchange. If so, it will contain the last bill of exchange number assigned for this company if bill of exchange numbers are to be automatically assigned. |
|
||||
ACO-REMIT-NUMBER Element: Remittance Number | Numeric 7 Remittance number. This will be used if the company is processing bills of exchange. If so, this will contain the last remittance number assigned for the company. |
|
||||
ACO-REASSIGN-NBR Element: Reassignment Number | Numeric 7 Reassignment number. Contains the last DB number used in the reassignment of open obligations. It will have a prefix of "GP-". |
|
||||
ACO-DRAFT-NBR-OPT Bill of Exchange Numbering | Alpha 1 Indicates the type of bill of exchange numbering that will be used for the company. Valid values are: A = Automatic BOE numbering M = Manual BOE numbering |
|
||||
ACO-DEP-INST-CODE Element: Deposit Code | Alpha 3 Default deposit bank code. Must be a valid bank service transaction code in the Lawson Cash Ledger system. |
|
||||
ACO-RTM-INST-CODE Element: RTM Payment Code | Alpha 3 Default return-to-maker payment code. Must be a valid bank service transaction code in the Lawson Cash Ledger system. |
|
||||
ACO-ADJ-INST-CODE Additional Bank Charges | Alpha 3 Default additional bank charges code. Must be a valid bank service transaction code in the Lawson Cash Ledger system. |
|
||||
ACO-EFT-INST-CODE Element: Deposit Payment Code | Alpha 3 The EFT deposit payment code. |
|
||||
ACO-EFTPAY-INST-CD Element: Credit Payment Code | Alpha 3 The EFT credit payment code. |
|
||||
ACO-DSC-REMIT-INST Discounted Remittance | Alpha 3 Default payment code when a discounted remittance is cashed. Must be a valid bank service transaction code in the Lawson Cash Ledger system. |
|
||||
ACO-DTL-PAYMENT Element: Payment GL Interface | Alpha 1 Detail payment accrual general ledger interface record option. Valid values are: N = No; detail payment general ledger interface records not created. Default. Y = Yes; create detail payment general ledger interface records. |
|
||||
ACO-DTL-APPL Application GL Interface | Alpha 1 Detail application accrual general ledger interface record option. Valid values are: N = No; detail application accrual general ledger interface records not created. Default. Y = Yes; create detail application accrual general ledger interface records. |
|
||||
ACO-DTL-FIN-CHRG Finance Charge GL Interface | Alpha 1 Detail finance charge accrual general ledger interface record option. Valid values are: N = No; detail finance charge accrual general ledger interface records not created. Default. Y = Yes; create detail finance charge accrual general ledger interface records. |
|
||||
ACO-MINIMUM Minimum Finance Charge | Alpha 1 Determines if a minimum finance charge will be assessed. Valid values are Y = Use minimum amount N = Minimum amount not used |
|
||||
ACO-FIN-CYCLE Finance Charge Cycle Code | Alpha 2 Finance charge cycle code. |
|
||||
ACO-HIST-PER Element: History Periods | Numeric 2 The number of periods (as defined by the run requency of AR198 Transaction Status Update) before the status of a fully applied payment or transaction is updated. This has two results: 1. This value is the number of periods until the status of a payment or transaction will be updated from Fully Applied to Closed. 2. This value is also the number of periods until the status of a payment or transaction will be updated from Closed to Historical. Therefore, a payment or transaction is elgible for "as of reporting" for the number of periods equal to two times the value of this field. 01 12 |
|
||||
ACO-CASH-CODE Element: Cash Code | Alpha 4 A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system. |
|
||||
ACO-CR-CASH-CODE Element: Credit Cash Code | Alpha 4 The credit cash code. Must be a valid cash code in the Lawson Cash Ledger system. |
|
||||
ACO-ACH-COMP-ID Element: EFT Company ID | Alpha 10 EFT company ID number. Used for ACH processing to identify the entity that is sending or receiving funds. |
|
||||
ACO-LAST-EFT-NBR Last EFT Debit Memo Number | Numeric 7 Last EFT debit memo number. Used for cash application purposes for credit balance processing. As funds are withdrawn or sent to a customer for a credit balance, a zero check is created with a corresponding debit memo for the funds amount. This is used for accounting purposes, and as a balancing record to complete the cash application/removal process of a credit balance. |
|
||||
ACO-CURR-DISPLAY Element: Currency Display | Alpha 1 You can choose to display transaction amounts throughout the system in base currency or transaction currency. Valid values are: B = Base currency T = Transaction currency |
|
||||
ACO-EDIT-REMIT Element: Edit Remittance | Alpha 1 Determines if payment remittance will be edited against existing transactions. N = No Y = Yes |
|
||||
ACO-SUM-LINE Element: Summary Line | Alpha 1 Determines whether to display multi line open items in detail or summary. N = No Y = Yes |
|
||||
ACO-THIRD-PARTY Element: Third Party | Alpha 1 This field indicates if this customer's payments may be applied to any customer's open transactions. N = No third party payment Y = Third party payment allowed |
|
||||
ACO-INT-BY-DATE-FL Element: Int By Date Fl | Alpha 1 Indicates if finance charegs will be assessed by potentailly multiple finance charge rates, over a period of time, for a past due or paid late transaction. |
|
||||
ACO-DUN-CYCLE-ID Element: Dun Cycle Id | Numeric 6 Last Dunning Letter Cycle ID. Gets incremented by 1 when you run AR140 (Dunning Letter Selection). You can view the last dunning cycle ID on AR01.1 (Company). |
|
||||
ACO-DUN-CYCLE-STAT Element: Dun Cycle Stat | Alpha 1 The dunning cycle status. Values are: 1 = Selected (after running AR140) 2 = Printed (after running AR141) 3 = Dunning History Produced 4 = Cycle complete (after running AR145) |
|
||||
ACO-OB-DRF-FL Element: Ob Drf Fl | Alpha 1 Select whether to include or exclude BOE item balances. Yes means to include BOE items in balances. No means to exclude BOE items from balances. Y = Include BOE items N = Do not include BOE items |
|
||||
ACO-REMIT-CNTL Element: Remit Cntl | Alpha 1 Y = Process Draft on Remittance N = Do Not process Draft on remitt |
|
||||
ACO-DISC-TAX-RCV Element: All Flag | Alpha 1 Determines if a prorated amount of tax will be recognized from cash application discounting on transactions that have tax-based distribution records. Valid values are: N = No Y = Yes |
|
||||
ACO-COUNTRY-CODE Element: Country Code | Alpha 2 The country code representing the country of the company. Y = Yes recover tax on discount N = Do not recover tax on discount |
|
||||
ACO-REGION Element: Region | Alpha 2 The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance) |
|
||||
ACO-LATE-CH-RND-FL Element: Late Ch Rnd Fl | Alpha 1 Interest by date charges rounding preference. If set to "Y", any resulting interest charge invoices will be rounded to the nearest currency unit. |
|
||||
ACO-VEN-CLASS Element: Ven Class | Alpha 3 A user-defined code representing a subset of vendors within a vendor group. Used in AR48 AR to AP Interface. |
|
||||
ACO-VEND-AR-TO-AP Element: Vend Ar To Ap | Alpha 1 Controls if the interface between AR and AP is allowed, as well as the automatic vendor creation aspect of this interface. Y = Allow Vendor creation AR to AP N = No Vendor creation AR to AP |
|
||||
ACO-EFT-PROCESS Element: Eft Process | Alpha 1 Indicates whether this company will process EFt tranascations. Valid values are: N = No EFT processing Y = EFT processing |
|
||||
ACO-CALENDAR Element: Calendar | Alpha 15 The calendar used for EFT processing. The calendar must be defined in the Universe calendar definition program. |
|
||||
ACO-DUE-DAYS Element: Due Days | Numeric 3 The number of days used to calculate the ending due date range in EFT processing. |
|
||||
ACO-DUE-TYPE Element: Due Type | Alpha 1 The type of days used to calulate the ending due date range. Valid values are. A= Actual Days M= Marked Days A = Actual Days M = Marked Days |
|
||||
ACO-GL-DAYS Element: Gl Days | Numeric 3 The number of days used to calculate the ending GL date range. |
|
||||
ACO-GL-TYPE Element: Gl Type | Alpha 1 The type of days used to calculate the ending GL date range. Valid values are: A = Actual Days M = Marked Days |
|
||||
ACO-DEPOSIT-DAYS Element: Deposit Days | Numeric 3 The number of days used to calculate the end deposit days date range. |
|
||||
ACO-DEPOSIT-TYPE Element: Deposit Type | Alpha 1 The type of days used to calculate the ending deposit days date reange. Valid values are: A = Actual Days M = Marked Days |
|
||||
ACO-CUST-AUDIT Element: Cust Audit | Alpha 1 Indicates whether customer changes will be tracked at the company level. Valid values are: N = No changes audited Y = Changes audited |
|
||||
ACO-NA-TRAN-FL Element: Flag | Alpha 1 Indicates whether national account transaction records will be created or deleted in AR12 National Account, or in AR112 National Account Transaction Update. If a company will have national accounts with a very high number of open transactions amongst a national account relationship, for performance considerations, it is recommended that this option = "Y". Valid values are: N = AR12 will maintain transactions Y = AR112 will maintain transactions |
|
||||
ACO-PROCURE-GROUP Element: Procure Group | Alpha 4 This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together. |
|
||||
ACO-CREDIT-CB-PRFX Element: Credit Cb Prfx | Alpha 2 |
|
||||
ACO-CREDIT-CB-NBR Element: Credit Cb Nbr | Numeric 7 |
|
||||
ACO-INTRF-DST-CREA Element: Flag | Alpha 1 Indicates whether interface transactions will have a historical AR Code based distribution record created, used for reporting purposes in AR197 Self Balancing Report. " " = Space N = No Y = Yes |
|
||||
ACO-INTRF-DST-SUM Element: Flag | Alpha 1 Indicates whether interface transactions will create historical AR Code based distribution records in detail or in summary. " " = Space N = No Y = Yes |
|
||||
ACO-VERIFY-DEP-DTE Element: Flag | Alpha 1 Y = Yes N = No |
|
||||
ACO-DUNS-NUMBER Element: Duns Number | Numeric 9 |
|
||||
ACO-EIN Element: Emp Acct Nbr | Alpha 20 |
|
||||
ACO-FIN-CHG-PRFX Element: Final Rank | Alpha 3 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ACOSET1 |
COMPANY |
|
|||||||||||||
ACOSET2 |
CUST-GROUP COMPANY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Arcustgrp | ARCUSTGRP |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Agingcode | AGINGCODE |
| ||||||||||||
Arcategory | ARCATEGORY |
| ||||||||||||
Archgbaktx | ARCHGBAKTX |
Delete Restricted
| ||||||||||||
Arcode | ARCODE |
Delete Cascades
| ||||||||||||
Arcompaud | ARCOMPAUD |
| ||||||||||||
Arcustomers | ARCUSTOMER |
Delete Restricted
| ||||||||||||
Aroitems | AROITEMS |
Delete Restricted
| ||||||||||||
Arpaynottx | ARPAYNOTTX |
Delete Restricted
| ||||||||||||
Arproclevels | ARPROCLEVL |
Delete Restricted
| ||||||||||||
Arpymntheaders | ARPYMNTHDR |
Delete Restricted
| ||||||||||||
Arreasons | ARREASON |
Delete Cascades
| ||||||||||||
Arrtmtx | ARRTMTX |
Delete Restricted
| ||||||||||||
Arstmprttx | ARSTMPRTTX |
Delete Restricted
| ||||||||||||
Arsummary | ARSUMMARY |
Delete Cascades
| ||||||||||||
Cranalyst | CRANALYST |
Delete Restricted
| ||||||||||||
Cust Defaults | CUSTDEFLTS |
Delete Cascades
| ||||||||||||
Salesrep | SALESREP |
Delete Cascades
| ||||||||||||
Staticcust | STATICCUST |
| ||||||||||||
Territory | TERITORY |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.