|
|
ARCUSTGRP FILE
AR Customer Group
AR Customer Group
REFERENCED BY
AC115 AC15.2 AC450 AP10.1 AP10.4 AP90.9
AR02.1 AR08.1 AR10.1 AR10.2 AR100 AR105
AR11.1 AR110 AR115 AR12.1 AR12.2 AR13.1
AR13.2 AR130 AR131 AR135 AR136 AR137
AR150 AR155 AR16.1 AR160 AR17.1 AR17.2
AR170 AR190 AR194 AR20.1 AR200 AR201
AR21.1 AR21.2 AR21.3 AR21.4 AR21.7 AR210
AR211 AR216 AR217 AR222 AR230 AR232
AR233 AR234 AR235 AR24.1 AR25.1 AR250
AR251 AR252 AR253 AR255 AR256 AR260
AR261 AR275 AR28.1 AR28.7 AR29.1 AR29.3
AR290 AR292 AR294 AR295 AR30.1 AR30.2
AR30.3 AR30.4 AR30.6 AR30.8 AR300 AR301
AR31.6 AR35.1 AR35.2 AR37.2 AR37.4 AR37.5
AR37.6 AR37.7 AR42.1 AR42.2 AR42.6 AR42.7
AR42.8 AR43.1 AR44.1 AR44.3 AR45.1 AR50.1
AR502 AR503 AR504 AR505 AR506 AR53.1
AR560 AR570 AR575 AR580 AR70.1 AR70.2
AR72.1 AR73.1 AR75.1 AR80.1 AR80.2 AR82.1
AR90.1 AR95.1 BL00.1 BL01.1 BL02.1 BL02.2
BL04.1 BL05.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL204 BL21.2
BL21.5 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 BL80.1 BL80.3
BL802 BL81.1 BL820 BL85.1 BL85.2 BL85.3
BL90.1 BL902 BL92.1 BL940 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 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE112 OE113 OE114
OE129 OE130 OE14.3 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE230 OE254
OE260 OE270 OE271 OE272 OE280 OE281
OE284 OE285 OE286 OE290 OE291 OE292
OE293 OE294 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE330 OE510
OE53.1 OE54.1 OE60.1 OE80.1 OE80.2 OE81.1
OE81.2 OE810 OE830 OE85.1 OE90.1 OE90.2
OE920 OE950 PBIP.1 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 TX140 TX40.1 WH110
WH120 WH130 WH132 WH190 WH20.2 WH20.7
WH21.2 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2
WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO235
UPDATED BY
AR00.1 AR01.1 AR09.1 AR501 AR550 AR700
AR977 AR980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACG-CUST-GROUP Alpha 5 AR00.1 AR977
Customer Group Customer group. A group that customers
belong to that transcends companies.
ACG-NAME Alpha 30 (Lower Case) AR00.1 AR977
Customer Group Name The name or description of the customer
group.
ACG-CUST-ALP-NBR Alpha 1 AR00.1 AR977
Customer Numbering Alphanumeric or numeric customer number
option. Valid values are:
A = Alphanumeric customer numbers
N = Numeric customer numbers
ACG-AUTO-CUSTOMER Alpha 1 AR00.1 AR977
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 AR501 AR550
Number customer numbering. One will be added to AR977
this number to get the next customer
number when a new customer is added.
ACG-CURRENCY-CD Alpha 5 AR00.1 AR01.1
Currency Code The default currency for displays and AR977
reports, when viewing customer amounts
across company lines.
ACG-AGE-CREDITS Alpha 1 AR00.1 AR977
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 AR977
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 AR977
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 AR977
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 AR977
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 AR977
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 AR977
Decimals customer group currency.
ACG-DISPLAY-DATE Alpha 1 AR00.1 AR977
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 AR977
Transaction Sequence 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
ACG-DRAFT-PROCESS Alpha 1 AR00.1 AR977
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 AR977
EFT Processing Indicates whether this customer group AR980
will process EFT transactions. Valid
values are:
N = No EFT Processing
Y = EFT Processing
ACG-CALENDAR Alpha 15 AR00.1 AR977
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 AR977
Due Days The number of days used to calculate
the ending due date range in EFT
processing.
ACG-DUE-TYPE Alpha 1 AR00.1 AR977
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 AR977
GL Days The number of days used to calculate
the ending GL date range.
ACG-GL-TYPE Alpha 1 AR00.1 AR977
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 AR977
Deposit Days The number of days used to calculate
the end deposit days date range.
ACG-DEPOSIT-TYPE Alpha 1 AR00.1 AR977
Deposit Days Type The 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 AR700
Currency Display You can choose whether to display AR980
amounts through the system in base
currency or transaction currency.
Valid values are:
B = Base currency
T = Transaction currency
ARCUSTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACGSET1 CUST-GROUP This is the primary path used to access AC115 AC15.2
customer group records. AC450 AP10.1
AP10.4 AP90.9
AR00.1 AR00.2
AR01.1 AR02.1
AR08.1 AR09.1
AR09.2 AR09.4
AR09.5 AR09.7
AR09.8 AR10.1
AR10.2 AR100
AR105 AR11.1
AR110 AR115
AR12.1 AR12.2
AR13.1 AR13.2
AR130 AR131
...
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
|