APCOMMENTS

Comments

The Comments file contains comment records for vendors and invoices.

REFERENCED BY
AP912


UPDATED BY
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 AP12.1 AP125
AP126 AP131 AP150 AP155 AP160 AP161
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP20.8 AP21.1 AP210 AP212 AP220
AP23.1 AP230 AP240 AP245 AP25.1 AP25.2
AP250 AP252 AP26.1 AP27.1 AP271 AP30.1
AP30.2 AP30.3 AP30.4 AP300 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 ZA161 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC140 IC142
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 MA180 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
MA530 MA531 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 PO10.1 PO100 PO101 PO120
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.2 PO22.3 PO22.4 PO22.5
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO28.2 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
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
UK47.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ260 RQ35.1 RQ500 RQIF.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 ZW130

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"
...
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
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 11:07:16 2016

Home
Contact Us



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