APCOMMENTS

Comments

The Comments file contains comment records for vendors and invoices.
UPDATED BY
AP115 AP12.1 AP300 AP212 AP220 AP912
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
AP110 AP125 AP126 AP131 AP150 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP20.8 AP21.1 AP210 AP23.1 AP230 AP240
AP245 AP25.1 AP25.2 AP250 AP252 AP26.1
AP27.1 AP30.1 AP30.2 AP30.3 AP30.4 AP305
AP35.1 AP36.2 AP40.1 AP40.2 AP510 AP90.1
AP90.2 AP90.3 AP90.4 AP91.1 AP92.1 AP95.1
AP96.1 API1.1 API2.1 API3.1 API4.1 MX123
MX500 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO10.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POII.1 POIJ.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1 AP155
AP160 AP161

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APC-REC-TYPE
Element: Record Type
Alpha 1
The file record type. Indicates the type of comment. Valid values are: I = Invoice Comment. V = Vendor Comment.
AP115 AP12.1
APC-COMPANY
Element: Company
Numeric 4
The company associated with the comment. Must be a valid record in the Accounts Payable Company file.
AP115 AP12.1
APC-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor associated with the comment. Must be a valid record in the Vendor file.
AP115 AP12.1
APC-LOCATION-CODE
Element: Location Code
Alpha 4
The alternate vendor location associated with the comment. Used only for vendor comments. Must be a valid record in the Vendor Location file.
AP115 AP12.1
APC-SEQ-NBR
Element: Seq Nbr
Numeric 4
A unique sequence number assigned by the system to the comment.
AP12.1
APC-VENDOR-GROUP
Element: Vendor Group
Alpha 4
The vendor group associated with the vendor. Must be a valid record in the Vendor Group file.
AP115 AP12.1
APC-PROC-LEVEL
Element: Process Level
Alpha 5
The process level associated with the invoice. Used only for invoice comments. Must be a valid record in the Accounts Payable Process Level file.
AP115 AP12.1
APC-COMMENT
Element: Comment
Alpha 40 (Lower Case)
The comment narrative.
AP12.1
APC-PRINT-CODE
Element: Comment Type
Alpha 1
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.
AP115 AP12.1
APC-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
The date the comment becomes valid.
AP115 AP12.1
APC-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The last date the comment is valid.
AP12.1 AP252
APC-DATE-ENTERED
Element: Date Entered
Numeric 8 (yyyymmdd)
The system date the comment was created.
AP115 AP12.1
APC-PAY-GROUP
Element: Pay Group
Alpha 4
The pay group associated with the comment. Must be a valid record in the Pay Group file.
AP115 AP12.1


APCOMMENTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APCSET1 REC-TYPE
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR
AP12.1 AP212
AP220 AP300
AP912
APCSET2 REC-TYPE
VENDOR-GROUP
VENDOR
LOCATION-CODE
COMPANY
SEQ-NBR
KeyChange, Subset
WherePRINT-CODE ="A"
OrPRINT-CODE ="D"
...
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
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
APCSET3 REC-TYPE
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR
KeyChange, Subset
WherePRINT-CODE ="A"
OrPRINT-CODE ="C"
AP150 AP155
AP160 AP161
APCSET4 REC-TYPE
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR*
KeyChange
AP115 AP12.1
APCSET5 REC-TYPE
VENDOR-GROUP
VENDOR
LOCATION-CODE
SEQ-NBR
COMPANY
KeyChange, Subset
Where(PRINT-CODE ="A")
Or(PRINT-CODE ="C")
AP150


APCOMMENTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:47:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.