|
|
ARCUSTGRP FILE
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
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 AM500 AM51.1 AM551
AM97.1 AP03.3 AP10.1 AP10.4 AP110 AP115
AP125 AP126 AP131 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 AR100 AR105 AR11.1 AR110
AR115 AR12.1 AR12.2 AR120 AR129 AR13.1
AR13.2 AR130 AR131 AR135 AR136 AR137
AR150 AR155 AR16.1 AR160 AR17.1 AR170
AR180 AR190 AR194 AR195 AR20.1 AR200
AR201 AR21.1 AR21.2 AR21.3 AR21.4 AR21.7
AR210 AR211 AR216 AR217 AR219 AR222
AR223 AR23.1 AR230 AR232 AR233 AR234
AR235 AR237 AR238 AR239 AR24.1 AR25.1
AR250 AR251 AR252 AR253 AR255 AR256
AR260 AR261 AR264 AR265 AR275 AR28.1
AR28.7 AR285 AR29.1 AR29.3 AR290 AR292
AR293 AR294 AR295 AR296 AR30.1 AR30.6
AR30.8 AR300 AR32.1 AR33.1 AR33.3 AR33.6
AR34.1 AR35.1 AR35.2 AR37.2 AR37.4 AR37.5
AR37.6 AR37.7 AR38.1 AR38.2 AR38.3 AR39.1
AR39.2 AR42.1 AR42.2 AR42.6 AR42.7 AR42.8
AR43.1 AR44.1 AR44.3 AR45.1 AR48.1 AR48.2
AR48.3 AR50.1 AR502 AR503 AR504 AR505
AR506 AR53.1 AR55.1 AR560 AR570 AR575
AR580 AR70.1 AR70.2 AR72.1 AR75.1 AR80.1
AR80.2 AR82.1 AR90.1 AR95.1 ARLL.1 BL00.1
BL01.1 BL04.1 BL05.1 BL10.1 BL120 BL121
BL122 BL123 BL125 BL130 BL20.1 BL20.3
BL20.6 BL202 BL204 BL21.2 BL21.5 BL217
BL220 BL231 BL246 BL29.1 BL29.2 BL290
BL291 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL33.1 BL331 BL34.1 BL46.1
BL46.2 BL47.1 BL520 BL530 BL546 BL80.1
BL80.3 BL81.1 BL82.1 BL820 BL85.1 BL85.2
BL85.3 BL90.1 BL92.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 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
DT150 DT155 DT160 DT165 DT166 DT170
DT180 DT190 DT270 DT30.1 DT30.2 DT40.1
DT42.1 DT45.1 DT520 DT60.1 DT60.2 DT70.1
DT70.3 DT80.1 DT85.1 DT85.2 DT85.3 DT90.1
DT92.1 DT95.1 IC02.1 ICLM.1 MX123 MX500
MA180 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD235 PO10.1 PO100 PO101 PO120
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO223 PO23.1
PO233 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO254 PO27.2 PO278 PO29.1 PO30.1
PO30.2 PO30.3 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 PO536 PO54.1 PO54.2 PO54.3 PO54.4
POI3.1 POID.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
PW05.1 PW07.1 PW110 PW55.1 PW555 RQ10.1
RQ10.2 TX101 TX226 TX301 TX40.1 WH110
WH120 WH130 WH132 WH190 WH20.1 WH20.2
WH20.7 WH21.2 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 WH33.5 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 BL02.1 BL802 PW550 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACG-CUST-GROUP Alpha 5 AR00.1
Element: Customer GroupCustomer group. A group that customers
belong to that transcends companies.
ACG-NAME Alpha 30 (Lower Case) AR00.1
Element: Customer GroupThe name or description of the customer
group.
ACG-CUST-ALP-NBR Alpha 1 AR00.1
Element: Customer NumbeAlphanumeric or numeric customer number
option. Valid values are:
A = Alphanumeric customer numbers
N = Numeric customer numbers
ACG-AUTO-CUSTOMER Alpha 1 AR00.1
Automatic Customer Automatic customer numbering option.
Numbering 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
ACG-LAST-CUSTOMER Numeric 9 AR00.1 AR09.1
Last Auto Customer Last customer number used for automatic AR10.1 AR301
Number customer numbering. One will be added to AR501 AR550
this number to get the next customer BL02.1 BL802
number when a new customer is added. PW550 TX140
ACG-CURRENCY-CD Alpha 5 AR00.1 AR01.1
Element: Currency Code The default currency for displays and
reports, when viewing customer amounts
across company lines.
ACG-AGE-CREDITS Alpha 1 AR00.1
Element: Age Credits 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
ACG-AGE-PYMNT Alpha 1 AR00.1
Element: Age Payment 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
ACG-AGE-DISPUTES Alpha 1 AR00.1
Element: Age Disputes Aging default for disputes when the
aging is across companies. Valid values
are:
N = Not aged - current column
Y = Aged respective to date
ACG-AGE-TYPE Alpha 1 AR00.1
Element: Aging Type Default aging method when aging cross
companies. Valid values are:
D = Due date aging
I = Invoice date aging
T = Age by transaction date
ACG-AGE-CURRENT Numeric 3 AR00.1
Element: Current Aging Used to define the transactions going
into the "current" and "future" aging
buckets.
ACG-AGE-PERIODS Numeric 3 Occurs 4 Times AR00.1
Element: Aging Periods Aging periods are user defined and
established by entering the last day of
each aging bucket in the Age Period
field.
ACG-BASE-ND Numeric 1 AR00.1 AR01.1
Base Number of Currency decimal indicator for the
Decimals customer group currency.
ACG-DISPLAY-DATE Alpha 1 AR00.1
Element: Display Date 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
ACG-TRANS-SEQUENCE Alpha 1 AR00.1
Element: Transaction SeTransaction 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
ACG-DRAFT-PROCESS Alpha 1 AR00.1
Bill of Exchange Bill of exchange processing. Indicates
Processing 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
ACG-EFT-PROCESS Alpha 1 AR00.1
Element: EFT ProcessingIndicates whether this customer group
will process EFT transactions. Valid
values are:
N = No EFT Processing
Y = EFT Processing
ACG-CALENDAR Alpha 15 AR00.1
Element: Calendar The calendar used for EFT processing.
The calendar must be defined in the
Universe calendar definition program.
ACG-DUE-DAYS Numeric 3 AR00.1
Element: Due Days The number of days used to calculate
the ending due date range in EFT
processing.
ACG-DUE-TYPE Alpha 1 AR00.1
Element: Due Days Type The type of days used to calculate the
ending due date range. Valid values are:
A = Actual Days
M = Marked Days
ACG-GL-DAYS Numeric 3 AR00.1
Element: GL Days The number of days used to calculate
the ending GL date range.
ACG-GL-TYPE Alpha 1 AR00.1
Element: GL Days Type The type of days used to calculate the
ending GL date range. Valid values are:
A = Actual Days
M = marked Days
ACG-DEPOSIT-DAYS Numeric 3 AR00.1
Element: Deposit Days The number of days used to calculate
the end deposit days date range.
ACG-DEPOSIT-TYPE Alpha 1 AR00.1
Element: Deposit Days TThe type of days used to calculate the
ending deposit days date range. Valid
values are:
A = Actual Days
M = Marked Days
ACG-CURR-DISPLAY Alpha 1 AR00.1
Element: Currency DisplYou can choose whether to display
amounts throught the system in base
currency or transaction currency.
Valid values are:
B = Base currency
T = Transaction currency
ACG-EFT-LEVEL Alpha 1 AR00.1
Element: Eft Level C = Company level processing
G = Group level processing
" " = No EFT processing
ACG-CUST-AUDIT Alpha 1 AR00.1
Element: Cust Audit Indicates whether customer changes will
be tracked at the customer group level.
Valid values are:
N = No customer audit
Y = Customer audit
ACG-AC-OI-SELECT Alpha 1 AR00.1
Element: Ac Oi Select C = Contract
L = Letter of Credit
A = Activity
T = Activity List
G = Activity Group
" " = Space
ACG-AC-PM-APP-VIEW Alpha 1 AR00.1
Element: Ac Pm App ViewR = Restricted application
U = Unrestricted application
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 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP10.4
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
...
ARCUSTGRP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
