APCOMMENTS

Comments

The Comments file contains comment records for vendors and invoices.

REFERENCED BY
AP212 AP912 AP10.1 AP230 AP240 AP245
AP246 AP250 AP252 AP35.1 AP36.2 AP40.1
AP40.2 AP92.1 AP95.1 AP96.1 AP155 AP160
AP161 ZA161


UPDATED BY
AP115 AP12.1 AP150 AP300 AP220 AC160
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM22.1 AM500 AM51.1 AM551 AM97.1 AP03.3
AP110 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP210
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP271
AP30.2 AP30.4 AP305 AP510 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 IC840 MX123 MX500
MA126 MA180 MA278 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO192
PO195 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.2
PO22.3 PO22.4 PO22.5 PO220 PO222 PO223
PO224 PO225 PO229 PO23.1 PO230 PO233
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO253 PO254 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO278 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO529 PO536 PO54.1 PO54.2 PO54.3
PO54.4 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830

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
AP150
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
AP150
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
AP150
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
AP150
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
AP150
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 AP150
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
AP150
APC-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
The date the comment becomes valid.
AP115 AP12.1
AP150
APC-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The last date the comment is valid.
AP12.1 AP150
AP252
APC-DATE-ENTERED
Element: Date Entered
Numeric 8 (yyyymmdd)
The system date the comment was created.
AP115 AP12.1
AP150
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
AP150


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"
...
AC160 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP03.3 AP10.1
AP110 AP115
AP125 AP126
AP131 AP150
AP20.1 AP20.2
AP20.3 AP20.4
APCSET3 REC-TYPE
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR
KeyChange, Subset
WherePRINT-CODE ="A"
OrPRINT-CODE ="C"
AP150 AP155
AP160 AP161
ZA161
APCSET4 REC-TYPE
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR*
KeyChange
AP115 AP12.1
AP150
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: Thu Jun 09 02:06:55 2016

Home
Contact Us



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