ARCUSTGRP

AR Customer Group

The AR Customer Group file contains customer group records. A customer group defines the customer number/numbering conventions, and allows one or more companies to use the same set of customers. There are a number of processing defaults that may be established at the group level but may also be overridden at the company level, such as aging periods and aging rules.

REFERENCED BY
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 AP03.3 AP10.1
AP10.4 AP110 AP115 AP125 AP126 AP131
AP150 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP51.1 AP51.9 AP510 AP90.1 AP90.9 AP91.1
API1.1 API2.1 API3.1 API4.1 AR02.1 AR08.1
AR11.1 AR12.1 AR12.2 AR13.1 AR13.2 AR16.1
AR17.1 AR200 AR201 AR210 AR211 AR216
AR217 AR23.1 CB06.1 CB06.2 ICLM.1 MX123
MX500 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 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 TX101
TX226 TX301 TX40.1


UPDATED BY
AR00.1 AR01.1 AR09.1 AR10.1 AR301 AR501
AR550 TX140

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACG-CUST-GROUP
Element: Customer Group		Alpha 5
Customer group. A group that customers belong to that transcends companies.
AR00.1
ACG-NAME
Element: Customer Group Name		Alpha 30 (Lower Case)
The name or description of the customer group.
AR00.1
ACG-CUST-ALP-NBR
Element: Customer Numbering		Alpha 1
Alphanumeric or numeric customer number option. Valid values are: A = Alphanumeric customer numbers N = Numeric customer numbers
AR00.1
ACG-AUTO-CUSTOMER
Automatic Customer
Numbering		Alpha 1
Automatic customer numbering option. This option can be used only if the numeric customer number option was specified. Valid values are: N = Manual customer numbering Y = Automatic customer numbering
AR00.1
ACG-LAST-CUSTOMER
Last Auto Customer
Number		Numeric 9
Last customer number used for automatic customer numbering. One will be added to this number to get the next customer number when a new customer is added.
AR00.1 AR09.1
AR10.1 AR301
AR501 AR550
TX140
ACG-CURRENCY-CD
Element: Currency Code		Alpha 5
The default currency for displays and reports, when viewing customer amounts across company lines.
AR00.1 AR01.1
ACG-AGE-CREDITS
Element: Age Credits		Alpha 1
Determines aging rules for credits for cross-company agings. Valid values are: L = Aged to last debit column N = Not aged - current column R = Aged respective to date
AR00.1
ACG-AGE-PYMNT
Element: Age Payment		Alpha 1
Determines aging rules for payments for cross-company agings. Valid values are: L = Aged to last debit column N = Not aged - current column R = Aged respective to date
AR00.1
ACG-AGE-DISPUTES
Element: Age Disputes		Alpha 1
Aging default for disputes when the aging is across companies. Valid values are: N = Not aged - current column Y = Aged respective to date
AR00.1
ACG-AGE-TYPE
Element: Aging Type		Alpha 1
Default aging method when aging cross companies. Valid values are: D = Due date aging I = Invoice date aging T = Age by transaction date
AR00.1
ACG-AGE-CURRENT
Element: Current Aging		Numeric 3
Used to define the transactions going into the "current" and "future" aging buckets.
AR00.1
ACG-AGE-PERIODS
Element: Aging Periods		Numeric 3 Occurs 4 Times
Aging periods are user defined and established by entering the last day of each aging bucket in the Age Period field.
AR00.1
ACG-BASE-ND
Base Number of
Decimals		Numeric 1
Currency decimal indicator for the customer group currency.
AR00.1 AR01.1
ACG-DISPLAY-DATE
Element: Display Date		Alpha 1
Display date. Indicates whether to display transactions by transaction date or due date on aging reports when aging across companies. Valid values are: T = Transaction date D = Due date
AR00.1
ACG-TRANS-SEQUENCE
Element: Transaction Sequence		Alpha 1
Transaction sequence. Indicates whether to display transactions by transaction number or transaction date on aging reports when aging across companies. Valid values are: T = Transaction number D = Transaction date
AR00.1
ACG-DRAFT-PROCESS
Bill of Exchange
Processing		Alpha 1
Bill of exchange processing. Indicates whether this customer group processes bills of exchange. Valid values are: N = No; don't process bills of exchange Y = Yes; process bills of exchange
AR00.1
ACG-EFT-PROCESS
Element: EFT Processing		Alpha 1
Indicates whether this customer group will process EFT transactions. Valid values are: N = No EFT Processing Y = EFT Processing
AR00.1
ACG-CALENDAR
Element: Calendar		Alpha 15
The calendar used for EFT processing. The calendar must be defined in the Universe calendar definition program.
AR00.1
ACG-DUE-DAYS
Element: Due Days		Numeric 3
The number of days used to calculate the ending due date range in EFT processing.
AR00.1
ACG-DUE-TYPE
Element: Due Days Type		Alpha 1
The type of days used to calculate the ending due date range. Valid values are: A = Actual Days M = Marked Days
AR00.1
ACG-GL-DAYS
Element: GL Days		Numeric 3
The number of days used to calculate the ending GL date range.
AR00.1
ACG-GL-TYPE
Element: GL Days Type		Alpha 1
The type of days used to calculate the ending GL date range. Valid values are: A = Actual Days M = marked Days
AR00.1
ACG-DEPOSIT-DAYS
Element: Deposit Days		Numeric 3
The number of days used to calculate the end deposit days date range.
AR00.1
ACG-DEPOSIT-TYPE
Element: Deposit Days Type		Alpha 1
The type of days used to calculate the ending deposit days date range. Valid values are: A = Actual Days M = Marked Days
AR00.1
ACG-CURR-DISPLAY
Element: Currency Display		Alpha 1
You can choose whether to display amounts throught the system in base currency or transaction currency. Valid values are: B = Base currency T = Transaction currency
AR00.1
ACG-EFT-LEVEL
Element: Eft Level		Alpha 1

C = Company level processing
G = Group level processing
" " = No EFT processing
AR00.1
ACG-CUST-AUDIT
Element: Cust Audit		Alpha 1
Indicates whether customer changes will be tracked at the customer group level. Valid values are:
N = No customer audit
Y = Customer audit
AR00.1
ACG-AC-OI-SELECT
Element: Ac Oi Select		Alpha 1

C = Contract
L = Letter of Credit
A = Activity
T = Activity List
G = Activity Group
" " = Space
AR00.1
ACG-AC-PM-APP-VIEW
Element: Ac Pm App View		Alpha 1

R = Restricted application
U = Unrestricted application
AR00.1


ARCUSTGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACGSET1 CUST-GROUP
...
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
AP03.3 AP10.1
AP10.4 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5


ARCUSTGRP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcustdesc CUSTDESC Delete Restricted
ACG-CUST-GROUP->CUD-CUST-GROUP
  CUD-CUSTOMER
Assignedcomps ARCOMP Delete Restricted
ACG-CUST-GROUP->ACO-CUST-GROUP
  ACO-COMPANY

File created: Wed Jun 08 20:47:54 2016

Home
Contact Us



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