|
|
APCOMMENTS FILE
Comments
The Comments file contains comment records for vendors and invoices.
REFERENCED BY
AP212 AP912 AP10.1 AP230 AP240 AP245
AP250 AP252 AP35.1 AP36.2 AP40.1 AP40.2
AP92.1 AP95.1 AP96.1 AP150 AP155 AP160
AP161
UPDATED BY
AP115 AP12.1 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 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 AP30.2 AP30.4 AP305
AP510 AP90.1 AP91.1 API1.1 API2.1 API3.1
API4.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 MX123 MX500 MA180 MA279 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
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 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO23.1 PO233 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO254 PO27.2
PO278 PO29.1 PO30.1 PO30.2 PO30.3 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 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 WH20.2
WH20.7
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 The vendor associated with the comment.
Must be a valid record in the Vendor
file.
APC-LOCATION-CODE Alpha 4 AP115 AP12.1
Element: Location Code The alternate vendor location
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: Seq Nbr A 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: Beg Date The date the comment becomes valid.
APC-END-DATE Numeric 8 (yyyymmdd) AP12.1 AP252
Element: End Date The last date the comment is valid.
APC-DATE-ENTERED Numeric 8 (yyyymmdd) AP115 AP12.1
Element: Date Entered 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 AP12.1 AP212
COMPANY AP220 AP300
VENDOR AP912
LOCATION-CODE
SEQ-NBR
APCSET2 REC-TYPE KeyChange, Subset AC160 AM115
VENDOR-GROUP Where PRINT-CODE = "A" AM117 AM15.1
VENDOR Or PRINT-CODE = "D" AM15.2 AM15.3
LOCATION-CODE AM15.4 AM19.1
COMPANY AM19.2 AM20.1
SEQ-NBR AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
...
APCSET3 REC-TYPE KeyChange, Subset AP150 AP155
COMPANY Where PRINT-CODE = "A" AP160 AP161
VENDOR Or PRINT-CODE = "C"
LOCATION-CODE
SEQ-NBR
APCSET4 REC-TYPE KeyChange AP115 AP12.1
COMPANY
VENDOR
LOCATION-CODE
SEQ-NBR*
APCSET5 REC-TYPE KeyChange, Subset AP150
VENDOR-GROUP Where (PRINT-CODE = "A" )
VENDOR Or (PRINT-CODE = "C" )
LOCATION-CODE
SEQ-NBR
COMPANY
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
|
