|
|
APCOMMENTS FILE
Comments
The Comments file contains comment records for vendors and invoices.
REFERENCED BY
AP212 AP225 AP226 AP57.2 AP210 AP230
AP240 AP245 AP250 AP30.1 AP30.4 AP35.1
AP36.1 AP40.1 AP40.2 AP90.1 AP90.2 AP90.3
AP90.4 AP92.1 AP92.2 AP95.1 EE30.1 AP150
AP155 AP157 AP160 AP161
UPDATED BY
AP12.1 AP12.2 AP125 AP126 AP20.6 AP20.1
AP20.2 AP20.5 AP20.7 AP25.1 AP25.2 AP26.1
AP300 AP953 EE35.1 EE35.2 MA530 MA540
PO31.1 PR199 AP23.1 AP32.1 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 AP10.1 AP10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APC-REC-TYPE Alpha 1 AP12.1 AP12.2
Record Type The file record type. Indicates the AP953 MA530
type of comment. Valid values are: MA540 PO31.1
PR199
I = Invoice Comment.
V = Vendor Comment.
APC-COMPANY Numeric 4 AP12.1 AP12.2
Company The company associated with the AP953 MA530
comment. Must be a valid record in the MA540 PO31.1
Accounts Payable Company file. PR199
APC-VENDOR Alpha 9 AP12.1 AP12.2
Vendor ID The vendor associated with the comment. AP953 MA530
Must be a valid record in the Vendor MA540 PO31.1
file. PR199
APC-LOCATION-CODE Alpha 4 AP12.1 AP12.2
Location Code The alternate vendor location AP953 MA530
associated with the comment. Used only MA540 PO31.1
for vendor comments. Must be a valid PR199
record in the Vendor Location file.
APC-INVOICE Alpha 22 AP12.1 AP12.2
Invoice Number The invoice number associated with the AP953 MA530
comment. Used only for invoice comments. MA540 PO31.1
Must be a valid record in the Accounts PR199
Payable Invoice file.
APC-SUFFIX Numeric 3 AP12.1 AP12.2
Invoice Suffix The invoice suffix number associated AP953 MA530
with the comment. Represents the MA540 PO31.1
occurrence value assigned by the system PR199
for recurring invoices or system-
generated credit memos. Used only for
invoice comments. Must be a valid record
in the Accounts Payable Invoice file.
APC-SEQ-NBR Numeric 4 AP12.1 AP12.2
Sequence Number A unique sequence number assigned by AP953 MA530
the system to the comment. MA540 PO31.1
PR199
APC-VENDOR-GROUP Alpha 4 AP12.1 AP12.2
Vendor Group The vendor group associated with the AP953 MA530
vendor. Must be a valid record in the MA540 PO31.1
Vendor Group file. PR199
APC-PROC-LEVEL Alpha 5 AP12.1 AP12.2
Process Level The process level associated with the AP953 MA530
invoice. Used only for invoice comments. MA540 PO31.1
Must be a valid record in the Accounts PR199
Payable Process Level file.
APC-COMMENT Alpha 40 (Lower Case) AP12.1 AP12.2
Comment The comment narrative. AP953 MA530
MA540 PO31.1
PR199
APC-PRINT-CODE Alpha 1 AP12.1 AP12.2
Comment Type Indicates the type of comment. AP953 MA530
Indicates where the comment displays MA540 PO31.1
and/or prints. Valid values are: PR199
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) AP12.1 AP12.2
Beginning Date The date the comment becomes valid. AP953 MA530
MA540 PO31.1
PR199
APC-END-DATE Numeric 8 (yyyymmdd) AP12.1 AP12.2
Ending Date The last date the comment is valid. AP953 MA530
MA540 PO31.1
PR199
APC-DATE-ENTERED Numeric 8 (yyyymmdd) AP12.1 AP12.2
Date Entered The system date the comment was created. AP953 MA530
MA540 PO31.1
PR199
APC-PAY-GROUP Alpha 4 AP12.1 AP12.2
Pay Group The pay group associated with the AP953 MA530
comment. Must be a valid record in the MA540 PO31.1
Pay Group file. PR199
APCOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APCSET1 REC-TYPE This index is used to add comment lines AP12.1 AP12.2
COMPANY or determine whether comments exist for AP125 AP126
VENDOR a particular invoice or vendor. AP20.1 AP20.2
LOCATION-CODE AP20.5 AP20.6
INVOICE AP20.7 AP212
SUFFIX AP225 AP226
SEQ-NBR AP23.1 AP25.1
AP25.2 AP26.1
AP300 AP32.1
AP57.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
...
APCSET2 REC-TYPE This index is used to determine whether AP10.1 AP10.2
VENDOR-GROUP a message display indicating that AP12.2 AP20.1
VENDOR comments exist should display. AP20.2 AP20.5
LOCATION-CODE AP20.6 AP20.7
COMPANY KeyChange, Subset AP20.8 AP210
INVOICE Where PRINT-CODE = "A" AP23.1 AP230
SUFFIX Or PRINT-CODE = "D" AP240 AP245
SEQ-NBR AP250 AP26.1
AP30.1 AP30.4
AP35.1 AP36.1
AP40.1 AP40.2
AP90.1 AP90.2
AP90.3 AP90.4
AP92.1 AP92.2
AP95.1 EE30.1
...
APCSET3 REC-TYPE This index is used to access comments AP150 AP155
COMPANY lines for printing on a vendor's AP157 AP160
VENDOR remittance. AP161
LOCATION-CODE
INVOICE KeyChange, Subset
SUFFIX Where PRINT-CODE = "A"
SEQ-NBR Or PRINT-CODE = "C"
APCSET4 REC-TYPE This index is used in AP12 for AP12.1 AP12.2
COMPANY resequencing purposes.
VENDOR
LOCATION-CODE KeyChange
INVOICE
SUFFIX
SEQ-NBR*
APCSET5 REC-TYPE This index is used to determine if a AP150
VENDOR-GROUP comment exists for a vendor, regardless
VENDOR of the company origin.
LOCATION-CODE
SEQ-NBR KeyChange, Subset
COMPANY Where (PRINT-CODE = "A" )
INVOICE Or (PRINT-CODE = "C" )
SUFFIX
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
Eeadvance EEADVANCE Not Required
APC-COMPANY -> EEA-COMPANY
APC-VENDOR -> EEA-VENDOR
APC-INVOICE -> EEA-ADVANCE-NBR
Eeexpense EEEXPENSE Not Required
APC-COMPANY -> EXP-COMPANY
APC-VENDOR -> EXP-VENDOR
APC-INVOICE -> EXP-EXPENSE-NBR
APCOMMENTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE
APC-COMPANY -> API-COMPANY
APC-VENDOR -> API-VENDOR
APC-INVOICE -> API-INVOICE
APC-SUFFIX -> API-SUFFIX
API-CANCEL-SEQ
|