ARCUSTGRP

Accounts Receivable Cust 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
AC160 AC56.1 AC560 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 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 AP271 AP30.2 AP30.4 AP300 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 ARLL.1 BR00.1 BR00.2 BR02.3
BR10.1 BR10.9 BR11.1 BR120 BR121 BR122
BR123 BR131 BR140 BR145 BR151 BR152
BR155 BR156 BR157 BR16.1 BR16.2 BR17.1
BR180 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.1 BR21.2 BR210 BR211
BR216 BR217 BR220 BR245 BR251 BR252
BR253 BR300 BR400 BR420 BR45.1 BR450
BR46.1 BR46.2 BR46.4 BR48.1 BR49.1 BR51.1
BR51.2 BR52.1 BR52.2 BR521 BR53.1 BR55.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 CB06.1
CB06.2 CB191 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC02.1 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 IC840 ICLM.1 MX123 MX500
MA126 MA180 MA278 MA279 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
MA53.1 MA530 MA531 MA540 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO192
PO195 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.2
PO22.3 PO22.4 PO22.5 PO220 PO222 PO223
PO224 PO225 PO229 PO23.1 PO230 PO233
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO253 PO254 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO278 PO28.2 PO280 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 PO529 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 TX101 TX226 TX301
TX40.1 WH110 WH120 WH130 WH132 WH190
WH20.1 WH20.2 WH20.7 WH21.2 WH222 WH224
WH226 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


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
...
AC160 AC56.1
AC560 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
AP03.3 AP10.1
AP10.4 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1


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: Thu Jun 09 02:09:00 2016

Home
Contact Us



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