|
|
EECOMMENTS FILE
Expense Comment
The Expense Comments file contains comment records for employee advances,
expenses, and expense detail lines.
REFERENCED BY
AP150 AP230 AP240 AP245 AP250 AP30.1
AP30.4 AP36.1 AP40.1 AP90.1 AP90.2 AP90.3
AP90.4 AP92.1 AP92.2 EE220 EE275 EE90.1
EE90.2 EE90.3 AP155 AP157 AP160
UPDATED BY
AP300 EE12.1 EE12.2 EE20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EEC-RECORD-TYPE Alpha 1 EE12.1 EE12.2
Record Type Identifies the type of record defined. EE20.3
Indicates whether the comment is defined
for an employee advance, expense, or
expense detail line.
EEC-COMPANY Numeric 4 EE12.1 EE12.2
Company The company number. Must be a valid EE20.3
record in the Accounts Payable Company
file.
EEC-VENDOR Alpha 9 EE12.1 EE12.2
Vendor ID The employee number. Must be a valid EE20.3
record in the Vendor file.
EEC-LOCATION-CODE Alpha 4 EE12.1 EE12.2
Location Code The alternate location code associated EE20.3
with the comment. Must be a valid
location for the employee in the Vendor
Location file.
EEC-EXP-ADV-NBR Alpha 10 EE12.1 EE12.2
Expense or Advance The advance or expense number EE20.3
Number associated with the comment. Must be a
valid record in the Employee Advance or
Employee Expense file.
EEC-SEQ-NBR Numeric 4 EE12.1 EE12.2
Sequence Number An automatically assigned sequence EE20.3
number assigned to the comment.
EEC-DIST-SEQ-NBR Numeric 4 EE12.1 EE12.2
Distribution A unique sequence number assigned to EE20.3
Sequence Number the comment.
EEC-DIST-LINE-NBR Numeric 4 EE12.1 EE12.2
Distribution Line A unique sequence number assigned to a EE20.3
Number distribution comment.
EEC-PROC-LEVEL Alpha 5 EE12.1 EE12.2
Process Level The process level associated with the EE20.3
company. Must be a valid record in the
Accounts Payable Process Level file.
EEC-COMMENT Alpha 40 (Lower Case) EE12.1 EE12.2
Comment Line This field contains the comment EE20.3
narrative.
EEC-PRINT-COMMENT Alpha 1 EE12.1 EE12.2
Print Comment Indicates the type of comment. EE20.3
Determines how the comment text displays
or prints. Valid values are:
D = Display and Print. A message
displays on various forms indicating
that comments exist and the comment text
prints on various listings and reports.
C = Check. Comment text prints on the
remittance advice forms.
N = Notation Only. Comments print only
when you run AP212 (Comments Listing) to
print comments.
A = All. A message indicating that
comments exist displays on various
forms, and the comment text prints on
various reports and listings including
remittance advice forms.
EEC-BEG-DATE Numeric 8 (yyyymmdd) EE12.1 EE12.2
Beginning Date The first date the comment is EE20.3
effective.
EEC-END-DATE Numeric 8 (yyyymmdd) EE12.1 EE12.2
Ending Date The last date the comment is effective. EE20.3
EEC-DATE-ENTERED Numeric 8 (yyyymmdd) EE12.1 EE12.2
Date Entered The date the comment was created. EE20.3
EEC-VENDOR-GROUP Alpha 4 EE12.1 EE12.2
Vendor Group The vendor group associated with the EE20.3
company. Must be a valid record in the
Vendor Group file.
EEC-PAY-GROUP Alpha 4 EE12.1 EE12.2
Pay Group The pay group associated with the EE20.3
company. Must be a valid record in the
Pay Group file.
EECOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EECSET1 RECORD-TYPE This index is used to add comment lines AP150 AP300
COMPANY or determine if comment lines exist for EE12.1 EE12.2
VENDOR a particular transaction or employee. EE20.3
LOCATION-CODE
EXP-ADV-NBR
SEQ-NBR
DIST-SEQ-NBR
DIST-LINE-NBR
EECSET2 RECORD-TYPE This index is used to determine whether AP230 AP240
VENDOR-GROUP a message display indicating that AP245 AP250
VENDOR comments exist should display. AP30.1 AP30.4
LOCATION-CODE KeyChange, Subset AP36.1 AP40.1
COMPANY Where (PRINT-COMMENT = "A" ) AP90.1 AP90.2
EXP-ADV-NBR Or (PRINT-COMMENT = "D" ) AP90.3 AP90.4
SEQ-NBR AP92.1 AP92.2
DIST-SEQ-NBR EE20.1 EE20.2
DIST-LINE-NBR EE20.3 EE20.4
EE220 EE275
EE90.1 EE90.2
EE90.3
EECSET3 RECORD-TYPE This index is used to access comment AP150 AP155
COMPANY lines for print on an employee's AP157 AP160
VENDOR remittance.
LOCATION-CODE KeyChange, Subset
EXP-ADV-NBR Where (PRINT-COMMENT = "A" )
SEQ-NBR Or (PRINT-COMMENT = "C" )
DIST-SEQ-NBR
DIST-LINE-NBR
EECSET4 RECORD-TYPE This index is used for resequencing EE12.1 EE12.2
COMPANY purposes.
VENDOR KeyChange
LOCATION-CODE
EXP-ADV-NBR
SEQ-NBR*
DIST-SEQ-NBR
DIST-LINE-NBR*
|