ARCOMMENT FILE
Customer Comments
Customer Comments
REFERENCED BY
AR10.1 AR217 AR140 AR245 AR271 AR36.2
AR45.1 AR46.1 AR72.1 AR73.1 AR75.1 AR70.2
BL92.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 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE510 OE810 OE920 WH20.7
UPDATED BY
AR141 AR161 AR17.1 AR17.2 AR29.1 AR29.3
AR300 AR301 AR501 AR503 AR506 AR560
AR976 AR42.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMT-COMPANY Numeric 4 AR141 AR161
Company The company number represents an AR17.1 AR17.2
established company and is entered on AR501 AR503
all function codes. AR506 AR560
AR976
CMT-CUSTOMER Alpha 9 (Right Justified) AR141 AR161
Customer Customer number. AR17.1 AR17.2
AR29.1 AR29.3
AR501 AR503
AR506 AR560
AR976
CMT-SEQ-NBR Numeric 4 AR141 AR161
Sequence Number Sequence number that identifies each AR17.1 AR17.2
unique line of a comment. AR29.1 AR29.3
AR501 AR503
AR506 AR560
AR976
CMT-CMMT-TYPE Alpha 1 AR141 AR161
Comment Type Type of comment entered. Valid values AR17.1 AR17.2
are: AR501 AR503
AR506 AR560
O = Order Entry comment AR976
C = Customer comment
T = Transaction comment
CMT-TRANS-TYPE Alpha 1 AR17.1 AR501
Transaction Type Identifies the type of transaction to AR503 AR506
which the comment belongs. Valid values AR560 AR976
are:
C = Credit Memo
D = Debit Memo
I = Invoice
P = Payment
CMT-TRANS-NBR Alpha 10 (Right Justified) AR17.1 AR501
Transaction Number Transaction number associated with the AR503 AR506
comment. AR560 AR976
CMT-COMMENT Alpha 40 (Lower Case) AR141 AR161
Comment Line This field contains the comment AR17.1 AR17.2
narrative. AR501 AR503
AR506 AR560
AR976
CMT-BEG-DATE Numeric 8 (yyyymmdd) AR141 AR161
Beginning Date Date at which time the comment becomes AR17.1 AR17.2
effective for online and report AR501 AR503
selection. Comments are accessible in AR506 AR560
AR17 (Comments), until they are deleted AR976
by AR17 or AR300 (Transaction Purge).
CMT-END-DATE Numeric 8 (yyyymmdd) AR141 AR161
Ending Date Date at which time the comment becomes AR17.1 AR17.2
ineffective for online and report AR501 AR503
selection. Comments are accessible in AR506 AR560
AR17 (Comments), until they are deleted AR976
by AR17 Comments or by AR300
(Transaction Purge).
CMT-PRINT-CODE Alpha 1 AR141 AR161
Print Code The Print Code defines where the AR17.1 AR17.2
comment displays and/or prints. Valid AR501 AR503
values are: AR506 AR560
AR976
B = Both Display and Print
D = Display
P = Print
R = Order Entry forms
CMT-SYS-DATE Numeric 8 (yyyymmdd) AR141 AR161
System Date System date that the comment was added AR17.1 AR17.2
to the system. Used to determine AR501 AR503
sequence of redisplay of comments. AR506 AR560
CMT-SYS-TIME Numeric 6 (hhmmss) AR141 AR161
System Time System time that the comment was added AR17.1 AR17.2
to the system. Used to determine AR501 AR503
sequence of redisplay of comments. AR506 AR560
AR976
ARCOMMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMTSET1 COMPANY This is the primary path used to access AR10.1 AR17.1
CUSTOMER comment records. AR17.2 AR217
SEQ-NBR AR29.1 AR29.3
AR300 AR301
CMTSET2 COMPANY This path is used to access transaction AR140 AR17.1
CUSTOMER level comments. AR217 AR245
CMMT-TYPE Subset AR271 AR300
TRANS-TYPE Where CMMT-TYPE = "T" AR36.2 AR45.1
TRANS-NBR AR46.1 AR72.1
BEG-DATE
SEQ-NBR
CMTSET3 COMPANY This path is used to access customer AR17.1 AR217
CUSTOMER level comments. AR271 AR72.1
SYS-DATE* Subset AR73.1 AR75.1
SYS-TIME* Where CMMT-TYPE = "C"
SEQ-NBR
CMTSET4 COMPANY This path is used to access customer AR70.2
CUSTOMER level comments in the customer review
SYS-DATE* program.
SYS-TIME* Subset
SEQ-NBR Where CMMT-TYPE = "C"
And (PRINT-CODE = "B"
Or PRINT-CODE = "D" )
CMTSET5 COMPANY This path is used to access order entry AR17.2 AR217
CUSTOMER comments. AR42.2 BL92.1
CMMT-TYPE Subset OE10.1 OE10.2
TRANS-TYPE Where CMMT-TYPE = "O" OE10.3 OE10.4
TRANS-NBR OE10.5 OE10.6
SEQ-NBR OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
...
ARCOMMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
CMT-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
CMT-COMPANY -> ACM-COMPANY
CMT-CUSTOMER -> ACM-CUSTOMER
Aroihdr AROIHDR Required
CMT-COMPANY -> ARH-COMPANY
CMT-CUSTOMER -> ARH-CUSTOMER
CMT-TRANS-TYPE -> ARH-TRANS-TYPE
CMT-TRANS-NBR -> ARH-TRANS-NBR
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
CMT-CUSTOMER -> CUD-CUSTOMER
|