|
|
APCOMMENTS FILE
Comments
The Comments file contains comment records for vendors and invoices.
REFERENCED BY
AP212 AP220 AP912 AP10.1 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.6 AP20.7 AP20.8
AP210 AP23.1 AP230 AP240 AP245 AP250
AP252 AP30.1 AP30.2 AP30.3 AP32.2 AP35.1
AP40.1 AP40.2 AP90.1 AP90.2 AP90.3 AP90.4
AP91.1 AP92.1 AP95.1 AP96.1 MA41.2 MA43.2
AP150 AP155 AP160 AP161
UPDATED BY
AP115 AP12.1 AP300 AM115 AM15.1 AM15.2
AM15.3 AM15.4 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 API3.1 API4.1
IC840 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APC-REC-TYPE Alpha 1 AP115 AP12.1
Element: Record Type The file record type. Indicates the
type of comment. Valid values are:
I = Invoice Comment.
V = Vendor Comment.
APC-COMPANY Numeric 4 AP115 AP12.1
Element: Company The company associated with the
comment. Must be a valid record in the
Accounts Payable Company file.
APC-VENDOR Alpha 9 (Right Justified) AP115 AP12.1
Element: Vendor ID The vendor associated with the comment.
Must be a valid record in the Vendor
file.
APC-LOCATION-CODE Alpha 4 AP115 AP12.1
Purchase From The alternate vendor location
Location Code associated with the comment. Used only
for vendor comments. Must be a valid
record in the Vendor Location file.
APC-SEQ-NBR Numeric 4 AP12.1
Element: Sequence NumbeA unique sequence number assigned by
the system to the comment.
APC-VENDOR-GROUP Alpha 4 AP115 AP12.1
Element: Vendor Group The vendor group associated with the
vendor. Must be a valid record in the
Vendor Group file.
APC-PROC-LEVEL Alpha 5 AP115 AP12.1
Element: Process Level The process level associated with the
invoice. Used only for invoice comments.
Must be a valid record in the Accounts
Payable Process Level file.
APC-COMMENT Alpha 40 (Lower Case) AP12.1
Element: Comment The comment narrative.
APC-PRINT-CODE Alpha 1 AP115 AP12.1
Element: Comment Type Indicates the type of comment.
Indicates where the comment displays
and/or prints. Valid values are:
A = All. Comment line displays on
inquiry screens and prints on payment
forms, reports, and listings.
C = Check/Cheque. Comment line prints
on payment forms only.
D = Display and Print. Comment line
displays on inquiry screens and prints
on reports and listings, but does not
print on payment forms.
N = Notation. Comment line does not
display or print.
APC-BEG-DATE Numeric 8 (yyyymmdd) AP115 AP12.1
Element: Date The date the comment becomes valid.
APC-END-DATE Numeric 8 (yyyymmdd) AP12.1 AP252
Element: Date The last date the comment is valid.
APC-DATE-ENTERED Numeric 8 (yyyymmdd) AP115 AP12.1
Element: Date The system date the comment was created.
APC-PAY-GROUP Alpha 4 AP115 AP12.1
Element: Pay Group The pay group associated with the
comment. Must be a valid record in the
Pay Group file.
APCOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APCSET1 REC-TYPE This index is used to add comment lines AP12.1 AP212
COMPANY or determine whether comments exist for AP220 AP300
VENDOR a particular invoice or vendor. AP912
LOCATION-CODE
SEQ-NBR
APCSET2 REC-TYPE This index is used to determine whether AM115 AM15.1
VENDOR-GROUP a message display indicating that AM15.2 AM15.3
VENDOR comments exist should display. AM15.4 AM20.1
LOCATION-CODE KeyChange, Subset AM20.3 AM21.1
COMPANY Where PRINT-CODE = "A" AM21.3 AM500
SEQ-NBR Or PRINT-CODE = "D" AM51.1 AM551
AM97.1 AP10.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP210 AP23.1
AP230 AP240
AP245 AP250
AP252 AP30.1
...
APCSET3 REC-TYPE This index is used to access comments AP150 AP155
COMPANY lines for printing on a vendor's AP160 AP161
VENDOR remittance.
LOCATION-CODE KeyChange, Subset
SEQ-NBR Where PRINT-CODE = "A"
Or PRINT-CODE = "C"
APCSET4 REC-TYPE This index is used in AP12 for AP115 AP12.1
COMPANY resequencing purposes.
VENDOR KeyChange
LOCATION-CODE
SEQ-NBR*
APCSET5 REC-TYPE This index is used to determine if a AP150
VENDOR-GROUP comment exists for a vendor, regardless
VENDOR of the company origin.
LOCATION-CODE KeyChange, Subset
SEQ-NBR Where (PRINT-CODE = "A" )
COMPANY Or (PRINT-CODE = "C" )
APCOMMENTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
APC-COMPANY -> CPY-COMPANY
Apvenloc APVENLOC Required
When APC-LOCATION-CODE != Spaces
APC-VENDOR-GROUP -> VLO-VENDOR-GROUP
APC-VENDOR -> VLO-VENDOR
APC-LOCATION-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Not Required
APC-VENDOR-GROUP -> VEN-VENDOR-GROUP
APC-VENDOR -> VEN-VENDOR
|
