 |
Lawson Insight Technical Documentation |
|
APAUDIT FILE
Vendor-Invoice Audit
The Vendor-Invoice Audit file contains audit records for additions, changes,
deletions, and cancellations for vendor and invoice records. Changes to
vendors are recorded for vendor groups that audit vendor changes. Changes to
released invoices are recorded for companies that audit invoice changes.
UPDATED BY
AP10.1 AP10.3 AP10.5 AP10.6 AP10.9 AP115
AP135 AP30.1 AP30.2 AP30.3 AP30.4 AP32.2
AP40.1 AP40.2 AP43.1 AP45.1 API3.1 API4.1
IC840 MA70.1 PO10.1 PO10.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APA-VENDOR-GROUP Alpha 4 AP10.1 AP10.3
Vendor Group If the audit record is for a vendor, AP10.5 AP10.6
this field contains the vendor group AP10.9 AP115
assigned to the vendor. Must be a valid AP30.1 AP30.2
record in the Vendor Group file. AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-COMPANY Numeric 4 AP10.1 AP10.3
Company If the audit record is for an invoice, AP10.5 AP10.6
this field contains the company number AP10.9 AP115
assigned to the invoice. Must be a valid AP30.1 AP30.2
record in the Accounts Payable Company AP30.3 AP30.4
file. AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-PROC-LEVEL Alpha 5 AP30.1 AP30.2
Process Level The process level associated with the AP30.3 AP30.4
invoice audit record. Must be a valid AP32.2 AP40.1
record in the Accounts Payable Process AP40.2 AP43.1
Level file. AP45.1 MA70.1
APA-VENDOR Alpha 9 (Right Justified) AP10.1 AP10.3
Vendor ID The vendor number associated with the AP10.5 AP10.6
audit record. Must be a valid record in AP10.9 AP115
the Vendor file. AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-INVOICE Alpha 22 AP30.1 AP30.2
Invoice Number The invoice number associated with the AP30.3 AP30.4
invoice audit record. AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 MA70.1
APA-SUFFIX Numeric 3 AP30.1 AP30.2
Invoice Suffix The invoice suffix number associated AP30.3 AP30.4
with the invoice audit record. A suffix AP32.2 AP40.1
number is assigned by the system to AP40.2 AP43.1
recurring invoices or system-generated AP45.1 MA70.1
credit memos.
APA-CANCEL-SEQ Numeric 4 AP30.1 AP30.2
Cancel Sequence The sequence number assigned upon a AP30.3 AP30.4
cancellation of a distributed invoice. AP32.2 AP40.1
The first sequence assigned is 9999. AP40.2 AP43.1
AP45.1 MA70.1
APA-SEQ-NBR Numeric 4 AP10.1 AP10.3
Sequence Number The invoice payment sequence number. AP10.5 AP10.6
AP10.9 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-TRANS-DATE Numeric 8 (yyyymmdd) AP10.1 AP10.3
Transaction Date The date the audit record was created. AP10.5 AP10.6
AP10.9 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-TRANS-TIME Numeric 6 (hhmmss) AP10.1 AP10.3
Transaction Time The system time the audit record was AP10.5 AP10.6
created. AP10.9 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-REC-TYPE Alpha 1 AP10.1 AP10.3
Record Type Indicates the type of audit record. AP10.5 AP10.6
Valid values are: AP10.9 AP115
AP30.1 AP30.2
I = Invoice Audit Record. AP30.3 AP30.4
V = Vendor Audit Record. AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-VENDOR-SNAME Alpha 30 AP10.1 AP10.3
Vendor Search Name The search name defined for the vendor AP10.5 AP10.6
in the Vendor file at the time the audit AP10.9 AP115
record was created. AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-VEN-CLASS Alpha 3 AP10.1 AP10.3
Vendor Class The vendor class the vendor was AP10.5 AP10.6
assigned to at the time the audit record AP10.9 AP115
was created. Must be a valid record in AP30.1 AP30.2
the Vendor Class file. AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-LOCATION-CODE Alpha 4 AP10.1 AP10.5
Location Code The alternate vendor location code AP10.6 AP10.9
associated with the audit record. Must AP115 AP30.1
be a valid record in the Vendor Location AP30.2 AP30.3
file. AP30.4 AP32.2
AP40.1 AP40.2
AP43.1 AP45.1
API3.1 API4.1
IC840 MA70.1
PO10.1 PO10.2
APA-OPERATOR Alpha 10 AP10.1 AP10.3
Operator Code The operator associated with the AP10.5 AP10.6
invoice audit record. AP10.9 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP43.1 AP45.1
API3.1 API4.1
IC840 MA70.1
PO10.1 PO10.2
APA-FIELD-ID Numeric 3 AP10.1 AP10.3
Field ID The value for this field comes from a AP10.5 AP10.6
table in working storage. Indicates the AP10.9 AP115
vendor or invoice field that was AP30.1 AP30.2
changed. AP30.3 AP30.4
001 = Vendor Class AP32.2 AP40.1
002 = Vendor Name AP40.2 AP43.1
003 = Vendor Search Name AP45.1 API3.1
004 = Vendor Contact API4.1 IC840
005 = Address 1 MA70.1 PO10.1
006 = Address 2 PO10.2
007 = Address 3
008 = Address 4
009 = City/Address 5
010 = State/Province
011 = Postal Code
012 = Country
013 = Normal Remit-To Flag
014 = Normal Purchase-From Flag
015 = Pay Vendor
016 = Vendor Status
017 = Vendor Priority
018 = Phone Prefix
019 = Phone Number
020 = Phone Extension
021 = FAX Prefix
022 = FAX Number
023 = FAX Extension
024 = Telex Number
025 = Terms Code
026 = Invoice Currency
027 = Balance Currency
028 = Tax Code
029 = Hold Code
030 = Distribution Code
031 = Accrual Code
032 = Payment Type
033 = Bank Code
034 = Bank Identification Number
035 = Bank Account Number
036 = Bank Account Type
037 = Income Code
038 = Tax Identification Number
039 = Income Withholding Flag
040 = EDI Prefix
041 = EDI Number
042 = Vendor Legal Name
044 = ACH Prenotification Flag
045 = Maximum Invoice Amount
046 = Origin Date
047 = Operator
048 = User Field 1
049 = User Field 2
050 = User Field 3
051 = User Field 4
052 = User Field 5
053 = User Field 6
054 = Currency Recalculation Flag
055 = Region
056 = Country Code
090 = Vendor Added
091 = Vendor Location Added
098 = One-Time Vendor Added
099 = Vendor Location Deleted
100 = Location Type
101 = Normal Remit-To Flag
102 = Normal Purchase-From Flag
103 = Remit-To Code
501 = Invoice Canceled
502 = Process Level
503 = Accrual Code
504 = Voucher Number
505 = Pay To Vendor
506 = Purchase Order
507 = Remit To Code
510 = Invoice Description
511 = Invoice Amount
512 = Base Invoice Amount
513 = Discount Amount
514 = Base Discount Amount
515 = Tax Amount
519 = Bank Code
520 = Hold Code
521 = Income Code
522 = Payment Group
523 = Pay Immediately Flag
524 = Separate Payment Flag
525 = Enclosure Flag
526 = Number of Recurring Payments
527 = Recurring Frequency
APA-BEFORE-IMAGE Alpha 32 AP10.1 AP10.5
Before Change Image The image of the field before the AP10.6 AP10.9
change. AP115 AP30.1
AP30.2 AP30.3
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-AFTER-IMAGE Alpha 32 AP10.1 AP10.3
After Change Image The image of the field after the change. AP10.5 AP10.6
AP10.9 AP115
AP30.1 AP30.2
AP30.3 AP30.4
AP32.2 AP40.1
AP40.2 AP43.1
AP45.1 API3.1
API4.1 IC840
MA70.1 PO10.1
PO10.2
APA-PRT-STATUS Numeric 1
Print Status This field is not currently used.
APAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APASET1 VENDOR-GROUP This is a unique index used to access AP135 AP40.2
COMPANY audit file records.
PROC-LEVEL KeyChange
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
TRANS-DATE
TRANS-TIME
APASET2 VENDOR-GROUP This index is used to access vendor AP10.1 AP10.3
VENDOR audit records. AP10.5 AP10.6
LOCATION-CODE KeyChange, Subset AP10.9 AP115
TRANS-DATE Where REC-TYPE = "V" AP135 API3.1
TRANS-TIME API4.1 IC840
SEQ-NBR PO10.1 PO10.2
APASET3 COMPANY This index is used to access invoice AP135 AP30.1
PROC-LEVEL audit records. AP30.2 AP30.3
VENDOR KeyChange, Subset AP30.4 AP32.2
INVOICE Where REC-TYPE = "I" AP40.1 AP43.1
SUFFIX AP45.1 MA70.1
CANCEL-SEQ
TRANS-DATE
TRANS-TIME
SEQ-NBR
APAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When APA-REC-TYPE = "I"
APA-COMPANY -> CPY-COMPANY
Approclev APPROCLEV Required
When APA-REC-TYPE = "I"
APA-COMPANY -> APR-COMPANY
APA-PROC-LEVEL -> APR-PROC-LEVEL
Apvenclass APVENCLASS Not Required
APA-VENDOR-GROUP -> VCL-VENDOR-GROUP
APA-VEN-CLASS -> VCL-VEN-CLASS
Apvengroup APVENGROUP Required
When APA-REC-TYPE = "V"
APA-VENDOR-GROUP -> VGP-VENDOR-GROUP
Apvenloc APVENLOC Required
When APA-REC-TYPE = "V"
APA-VENDOR-GROUP -> VLO-VENDOR-GROUP
APA-VENDOR -> VLO-VENDOR
APA-LOCATION-CODE -> VLO-LOCATION-CODE
Apvenmast APVENMAST Required
APA-VENDOR-GROUP -> VEN-VENDOR-GROUP
APA-VENDOR -> VEN-VENDOR
|