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 |
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. |
|
||||
APC-COMPANY Element: Company | Numeric 4 The company associated with the comment. Must be a valid record in the Accounts Payable Company file. |
|
||||
APC-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor associated with the comment. Must be a valid record in the Vendor file. |
|
||||
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. |
|
||||
APC-SEQ-NBR Element: Seq Nbr | Numeric 4 A unique sequence number assigned by the system to the comment. |
|
||||
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. |
|
||||
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. |
|
||||
APC-COMMENT Element: Comment | Alpha 40 (Lower Case) The comment narrative. |
|
||||
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. |
|
||||
APC-BEG-DATE Element: Beg Date | Numeric 8 (yyyymmdd) The date the comment becomes valid. |
|
||||
APC-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The last date the comment is valid. |
|
||||
APC-DATE-ENTERED Element: Date Entered | Numeric 8 (yyyymmdd) The system date the comment was created. |
|
||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
APCSET1 |
REC-TYPE COMPANY VENDOR LOCATION-CODE SEQ-NBR |
|
| ||||||||||||||||||||||||
APCSET2 |
REC-TYPE VENDOR-GROUP VENDOR LOCATION-CODE COMPANY SEQ-NBR |
|
|||||||||||||||||||||||||
APCSET3 |
REC-TYPE COMPANY VENDOR LOCATION-CODE SEQ-NBR |
|
| ||||||||||||||||||||||||
APCSET4 |
REC-TYPE COMPANY VENDOR LOCATION-CODE SEQ-NBR* |
|
| ||||||||||||||||||||||||
APCSET5 |
REC-TYPE VENDOR-GROUP VENDOR LOCATION-CODE SEQ-NBR COMPANY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| |||||||||||||||
Apvenloc | APVENLOC |
Required
| |||||||||||||||
Apvenmast | APVENMAST |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.