|
|
APCINVOICE FILE
Invoice Interface
The Invoice Interface file is used by the Invoice Interface program to
convert or interface invoice records to the Lawson Accounts Payable system.
When you run AP520 (Invoice Interface), the system reads records in this file
for conversion or interface into the Accounts Payable Invoice file. When the
Invoice Interface records and associated Distribution Interface records are
successfully converted or interfaced, the invoice interface records are purged
from this file. You can use AP52.1 (Invoice Interface) to add records to this
file or maintain records already loaded into this file before conversion or
interface to the Lawson Accounts Payable system.
UPDATED BY
AP305 AP52.1 AP52.3 AP520 PR198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVI-COMPANY Numeric 4 AP52.1 PR198
Element: Company Required. The company number. Must be a
valid record in the Accounts Payable
Company file.
CVI-VENDOR Alpha 9 (Right Justified) AP52.1 PR198
Element: Vendor Required. The invoiced vendor number.
Must be a valid record in the Vendor
file.
This field may be left blank if the
One-Time Vendor field is Yes or if the
EDI Number field has a value.
CVI-EDI-NBR Alpha 15 AP52.1 PR198
Element: EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
CVI-INVOICE Alpha 22 AP52.1 PR198
Element: Invoice Required. A unique invoice number for
the vendor.
CVI-SUFFIX Numeric 3 AP52.1 PR198
Element: Suffix The occurrence value of the invoice.
Used to identify the recurrence value of
a recurring invoice.
CVI-BATCH-NUM Numeric 6 AP52.1 PR198
Element: Batch The batch number associated with the
invoice. This field is used only for
companies that have Yes selected in the
Batch Release field. Can be left blank
for released (open) or historical status
invoice records.
CVI-VOUCHER-NBR Alpha 10 AP52.1 PR198
Element: Voucher The voucher number associated with the
invoice. This field is used only for
companies that have Yes selected in the
Invoice Approval field. If the company
has Yes selected in the Auto Voucher
Numbering field, leave this field blank.
Can be left blank for released (open) or
historical status invoice records.
CVI-AUTH-CODE Alpha 3 AP52.1 PR198
Element: Authority CodeThe authority code assigned to the
invoice. This field is used only for
companies that have Yes selected in the
Invoice Approval field. Represents the
person or department responsible for
approving a registered invoice. Must be
a valid record in the Authority Code
file.
CVI-PROC-LEVEL Alpha 5 AP52.1 PR198
Element: Process Level The process level assigned to the
invoice. Must be a valid record in the
Accounts Payable Process Level file.
This field is required if the company
does not have a default process level
assigned.
CVI-ACCR-CODE Alpha 4 AP52.1 PR198
Element: Invoice AccruaThe invoice accrual code assigned to
the invoice. Used to default a general
ledger invoice accrual account to the
invoice. Must be a valid record in the
Invoice Accrual Code file. If left
blank, the invoice accrual code assigned
to the vendor, if assigned, or the
process level defaults.
CVI-INVOICE-TYPE Alpha 1 AP52.1 PR198
Element: Invoice Type Identifies the type of invoice. Valid
values are:
Blank = Invoice. Default value.
C = Credit Memo.
D = Debit Memo.
CVI-OLD-VENDOR Alpha 9 (Right Justified) PR198
Element: Vendor THIS FIELD IS NOT CURRENTLY USED.
CVI-INV-CURRENCY Alpha 5 AP52.1 PR198
Element: To Base Curr The currency code representing the
currency of the invoice. Must be a valid
record in the Currency Codes file. If
left blank, the currency defaults from
the remit-to location, vendor, vendor
class, company (base currency defined in
the General Ledger Company file), or pay
group (posting company base currency).
CVI-INVOICE-DTE Numeric 8 (yyyymmdd) AP52.1 PR198
Element: Invoice Date Required. The invoice date. May be the
date the vendor created the invoice or
the date the invoice was received. Used
when updating the vendor's purchase
balance.
CVI-TAX-PNT-DATE Numeric 8 (yyyymmdd) PR198
Element: Date Tax point date is used to update the
Lawson Tax system for released (open)
and historical status invoices with a
tax code.
CVI-PURCH-FR-LOC Alpha 4 AP52.1 PR198
Element: Purchase From The vendor's purchase-from location.
Must be a valid record in the Vendor
Location file. If left blank, the normal
purchase-from location defined for the
vendor defaults.
CVI-PO-NUMBER Alpha 14 (Right Justified) AP52.1 PR198
Element: Po Number This field contains the number
representing the purchase order.
CVI-PO-RELEASE Numeric 4 AP52.1 PR198
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
CVI-PO-CODE Alpha 4 AP52.1
Element: Purchase OrderPurchase order number code. Used to
keep purchase orders unique. Can be used
for reporting purposes.
CVI-AUTO-MATCH Alpha 1 PR198
Element: Auto Match This field is not currently used. The
intent of this field will be to receive
electronic invoices and automatically
match the invoice to the purchase order.
Valid values are:
Y = Yes.
N = No.
CVI-DESCRIPTION Alpha 30 (Lower Case) AP52.1 PR198
Element: Description The invoice description. This field
accepts both upper and lower case
entries.
CVI-BASE-INV-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt The amount of the invoice in the
company base currency. This field is
required for non-base currency invoices
with an historical status when no
currency exchange rate is entered.
CVI-TRAN-INV-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt Required. The amount of the invoice in
the currency of the invoice.
CVI-TRAN-ALOW-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt The amount of the invoice available for
discount in the currency of the invoice.
If left blank, the Invoice Amount
defaults.
CVI-TRAN-TXBL-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt The taxable amount of the invoice in
the currency of the invoice.
CVI-TRAN-TAX-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt The tax amount of the invoice in the
currency of the invoice. If left blank
and you enter a Taxable Amount and Tax
Code for the invoice, the system will
calculate this amount.
CVI-TRAN-DISC-AMT Signed 18.2 AP52.1 PR198
Element: Intl Amt The discount amount of the invoice in
the currency of the invoice. If left
blank, the Terms Code assigned to the
invoice, alternate location (type P or
B), or vendor, if assigned, will be used
to calculate the discount amount.
CVI-ORIG-CNV-RATE Signed 14.7 AP52.1 PR198
Element: Acct Rate The currency exchange rate used to
convert the invoice amount to the
company base currency. This field is
required for non-base currency invoices
with an historical status.
CVI-ANTICIPATION Alpha 1 AP52.1 PR198
Element: Anticipate Indicates whether anticipation criteria
will be used to calculate the discount
amount of the invoice. If left blank,
this value defaults from the Terms Code
assigned to the invoice, alternate
location (type P or B), or vendor, if
assigned. Valid values are:
Y = Yes.
N = No.
CVI-DISCOUNT-RT Percent 5.3 (Percent) AP52.1 PR198
Element: Discount Rt The rate used to calculate the discount
amount of the invoice. If left blank,
the Terms Code assigned to the invoice,
alternate location (type P or B),
vendor, or vendor class, if assigned,
will be used to calculate due date and
discount information.
CVI-DISC-DATE Numeric 8 (yyyymmdd) AP52.1 PR198
Element: Date The discount date assigned to the
invoice. Used by Cash Requirements
(AP150) to determine whether a discount
will be taken on the invoice. If left
blank, the Terms Code assigned to the
invoice, alternate location (type P or
B), or vendor, if assigned, will be used
to calculate due date and discount
information.
CVI-DUE-DATE Numeric 8 (yyyymmdd) AP52.1 PR198
Element: Due Date Required. The invoice due date. Used by
AP150 (Cash Requirements) or AP151 (Bill
of Exchange Generation) to select the
invoice for payment. If left blank, the
Terms Code assigned to the invoice,
alternate location (type P or B), or
vendor, if assigned, will be used to
calculate due date and discount
information. This field is required if
the vendor or location does not have a
terms code assigned and you do not
assign a terms code to the invoice.
CVI-NBR-RECUR-PMT Numeric 3 AP52.1 PR198
Element: Nbr Of Invcs Indicates the number of times a
recurring invoice is to be recreated by
AP170 (Payment Closing). This field is
required if you enter a value in the
Recurring Frequency field.
CVI-RECUR-FREQ Alpha 1 AP52.1 PR198
Element: Recurrence SchIndicates how often the invoice should
recur. The invoice, due, discount, and
distribution dates of the invoice will
be incremented by this frequency each
time AP170 (Payment Closing) creates the
next recurrence of the invoice. This
field is required if you enter a value
in the Number of Recurrences field.
Valid values are:
W = Weekly.
M = Monthly.
Q = Quarterly.
S = Semiannually.
A = Annually.
CVI-REMIT-TO-CODE Alpha 4 AP52.1 PR198
Element: Remit To Code The remit-to location associated with
the invoice. Must be a valid record in
the Vendor Location file. If entered,
the invoice payment will be remitted the
address defined for the remit-to
location. If left blank, the normal
remit-to location defined for the vendor
defaults.
CVI-CASH-CODE Alpha 4 AP52.1 PR198
Element: Cash Code The cash code assigned to the invoice.
Represents a bank account. Must be a
valid record in the Cash Code file. If
left blank, the cash code assigned to
the remit-to location, vendor, vendor
class, process level, company, or pay
group defaults.
CVI-SEP-CHK-FLAG Alpha 1 AP52.1 PR198
Separate Payment Indicates whether the invoice requires
Option a separate payment form. If left blank,
the separate payment option defined for
the vendor defaults. Valid values are:
Y = Yes.
N = No.
CVI-PAY-IMM-FLAG Alpha 1 AP52.1 PR198
Pay Immediately Indicates whether the invoice will be
Option selected for immediate payment
regardless of the due date. Valid values
are:
N = No. Default value.
Y = Yes.
CVI-ENCLOSURE Alpha 1 AP52.1 PR198
Element: Enclosure OptiIndicates whether the invoice requires
an enclosure with its payment. If you
select Yes, you have the option to group
payments that require enclosures when
you run AP150 (Cash Requirements). Valid
values are:
N = No. Default value.
Y = Yes.
CVI-CURR-RECALC Alpha 1 AP52.1 PR198
Currency Indicates whether the invoice currency
Recalculation should be revalued against the company's
base currency at the time of payment to
account for currency exchange rate
fluctuations. If you select Yes,
currency gain or loss transactions may
be created for the invoice. If left
blank, the revalue option defined for
the vendor defaults. Valid values are:
N = No.
Y = Yes.
CVI-DISC-LOST-FLG Alpha 1 AP52.1 PR198
Element: Discount Lost For historical status invoices,
indicates whether the available discount
was lost. Valid values are:
N = No. Default value.
Y = Yes.
CVI-TAX-CODE Alpha 10 AP52.1 PR198
Element: Tax Code The tax code assigned to the invoice.
Used to calculate the Tax Amount for the
invoice based on the tax rates defined
for the tax code and to automatically
create distribution lines for the
applied amounts. Must be a valid record
in the Tax Code file. If left blank, you
can assign tax codes to individual tax
distributions or the tax code defaults
from the vendor, if assigned.
CVI-INCOME-CODE Alpha 4 AP52.1 PR198
Element: Income Code The income code assigned to the
invoice. Represents a type of reportable
income. Must be valid record in the
Income Code file. If left blank, the
income code assigned to the vendor or
vendor class, if assigned, defaults.
CVI-HLD-CODE Alpha 4 AP52.1 PR198
Element: Hold Code The hold code assigned to the invoice.
Used to prevent the invoice from being
scheduled for payment. Must be a valid
invoice hold code record in the Hold
Code file.
CVI-DIST-CODE Alpha 9 AP52.1 PR198
Element: Dist Code The distribution code assigned to the
invoice. Used to automatically create
expense distribution lines for the
invoice. Must be a valid record in the
Distribution Code file. If left blank,
the distribution code assigned to the
vendor, if assigned, defaults.
CVI-TERM-CODE Alpha 5 AP52.1 PR198
Element: Term Code The terms code assigned to the invoice.
Used to calculate invoice due date and
discount information. Must be a valid
record in the Terms Code file. If left
blank, the terms code assigned to the
location (type B or P) or vendor, if
assigned, defaults.
CVI-REC-STATUS Numeric 1 AP52.1 PR198
Element: Invoice StatusRequired. The invoice record status.
Valid values are:
0 = Unreleased. Invoice not available
for payment.
1 = Released (open). Invoice available
for payment.
9 = Historical. Invoice paid and closed.
Note: If the invoice status is
Unreleased, the Distribution Posting
Status must be Unreleased. If the
invoice status is Released, the
Distribution Posting Status must be
Unposted or Posted. If the invoice
status is Historical, the Distribution
Posting Status must be Posted.
CVI-POSTING-STATUS Numeric 1 AP52.3 PR198
Distribution Required. The posting status of
Posting Status associated invoice distributions. Valid
values are:
0 = Unreleased. Distributions not
available for posting.
1 = Unposted. Distributions available
for posting.
9 = Posted. Distributions posted to
general ledger.
Note: If the Invoice Status is
Unreleased, the Distribution Posting
Status must be Unreleased. If the
invoice status is Released, the
Distribution Posting Status must be
Unposted or Posted. If the invoice
status is Historical, the Distribution
Posting Status must be Posted.
CVI-DISTRIB-DATE Numeric 8 (yyyymmdd) AP52.1 PR198
Element: Post Date The date used for posting invoice
distributions to the general ledger. If
left blank, either the post date defined
for the batch or the invoice date
defaults.
CVI-PAY-VENDOR Alpha 9 (Right Justified) AP52.1 PR198
Element: Pay Vendor The pay vendor for the invoice. Used to
send invoice payments to another vendor
within the same vendor group. Although
payments are sent to the pay vendor, the
original or invoiced vendor will
accumulate the payment balance; pay
vendor balances are not updated. If
multiple invoices share the same pay
vendor, a single payment form will be
created for the pay vendor. The payment
remittance lists individual invoiced
vendors and invoice numbers included in
the payment. Must be a valid record in
the Vendor file.
CVI-TRANS-NBR Alpha 10 (Right Justified) AP52.1 PR198
Element: Payment NumberThe payment number used to pay the
invoice. Required only for historical
status invoice records with no payment
records. If entered, the Payment Code
assigned to the invoice must be a valid
cash payment type transaction code
record in the Bank Transaction Code
file.
Note: If you are converting a historical
status invoice and want to link
associated payment records to the
invoice, you must run Bank Transaction
Interface (CB500) to convert payment
records before you convert associated
invoices.
CVI-BANK-INST-CODE Alpha 3 AP52.1 PR198
Element: Payment Code The bank transaction code associated
with the invoice. Represents a type of
cash or bill of exchange payment.
Required for historical status invoice
records. If left blank for an unreleased
or released (open) status invoice
record, the payment code assigned to the
vendor, vendor class, or pay group
defaults. Must be a valid cash payment
or bill of exchange payment type bank
transaction code record in the Bank
Transaction Code file.
CVI-CHECK-DATE Numeric 8 (yyyymmdd) AP52.1 PR198
Element: Check Date The payment date. Valid only for
historical status invoice records with
no payment (check) records.
CVI-INVOICE-GROUP Alpha 4 AP52.1 PR198
Element: Invoice Group The invoice group assigned to the
transaction. An invoice group is a
user-defined character expression that
can be assigned to one more invoices.
Cash Requirements (AP150) has an option
to select all invoices assigned the same
invoice group.
CVI-ONE-TIME-VEND Alpha 1 AP52.1 PR198
Element: One-Time VendoIndicates whether a one-time vendor
record is to be created for the invoiced
vendor. Valid values are:
N = No. Default value.
Y = Yes.
CVI-VENDOR-VNAME Alpha 30 (Lower Case) AP52.1 PR198
Element: Vendor Name The vendor name. Required only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-VENDOR-SNAME Alpha 30 AP52.1 PR198
Element: Search Name The search name for the vendor.
Required only if the One-Time Vendor
field = Yes. If left blank, the Vendor
Name defaults.
CVI-ADDR1 Alpha 30 (Lower Case) AP52.1 PR198
Element: Address 1 The first line of address information
for the vendor. Required only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-ADDR2 Alpha 30 (Lower Case) AP52.1 PR198
Element: Address 2 The second line of address information
for the vendor. Used only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-ADDR3 Alpha 30 (Lower Case) AP52.1 PR198
Element: Address 3 The third line of address information
for the vendor. Used only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-ADDR4 Alpha 30 (Lower Case) AP52.1 PR198
Element: Address 4 The fourth line of address information
for the vendor. Used only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-CITY-ADDR5 Alpha 18 (Lower Case) AP52.1 PR198
Element: City/Address 5The city or fifth line of address
information for the vendor. Used only if
the One-Time Vendor field = Yes. This
field accepts both upper and lower case
entries.
CVI-STATE-PROV Alpha 2 AP52.1 PR198
Element: State or ProviThe state or province for the vendor.
Used only if the One-Time Vendor field =
Yes.
CVI-POSTAL-CODE Alpha 10 (Lower Case) AP52.1 PR198
Element: Postal Code The postal code for the vendor address.
Used only if the One-Time Vendor field =
Yes. This field accepts both upper and
lower case entries.
CVI-COUNTY Alpha 25 (Lower Case) AP52.1
Element: County The county for the company address.
CVI-COUNTRY Alpha 30 (Lower Case) AP52.1 PR198
Element: Country The country for the vendor address. Can
also be used for additional information
such as attention name. Used only if the
One-Time Vendor field = Yes. This field
accepts both upper and lower case
entries.
CVI-LEGAL-NAME Alpha 80 (Lower Case) AP52.1
Element: Legal Name Institution's legal name used on the
GM269 and GM272 reports.
CVI-VEN-INC-CODE Alpha 4 AP52.1
Element: Income Code
CVI-TAX-ID Alpha 20 AP52.1
Element: Tax ID
CVI-JRNL-BOOK-NBR Alpha 12 AP52.1 PR198
Element: Journal Book If using journal books, the journal
book assigned to the transaction.
CVI-BANK-CHK-AMT Signed 18.2 PR198
Element: Intl Amt The amount of the invoice payment in
the currency of the cash code (bank
account). Used for historical status
invoices only.
CVI-BANK-ND Numeric 1 PR198
Element: Acct Nd The number of decimal positions defined
for the bank account currency assigned
to the cash code. Used for historical
status invoices only.
CVI-BNK-CNV-RATE Signed 14.7 PR198
Element: Acct Rate The currency exchange rate used to
convert the invoice currency to the bank
account currency. Used for historical
status invoices only.
CVI-DISCOUNT-CODE Alpha 10 AP52.1 PR198
Element: Discount Code The discount code assigned to the
invoice. Represents a general ledger
discount account. If left blank, the
discount code assigned to the vendor,
process level, or company defaults. Must
be a valid record in the Discount Code
file.
CVI-INVOICE-SOURCE Alpha 1 PR198
Element: Invoice SourceIndicates the source for creation of
the invoice: manual (default), EDI, ERS.
E = EDI
R = ERS
" " = Manual
P = Payroll
T = Tax
G = Garnishment
L = Lease
C = AR Transfer
S = Sub Contractor
CVI-INVC-REF-TYPE Alpha 2 AP52.1
Element: Invc Ref Type Indicates the type of number the vendor
is providing to reference the invoice.
CVI-APPROVED-FLAG Alpha 1 AP52.1 PR198
Element: Approved Flag If the invoice requires approval, this
field indicates whether the invoice is
approved.
N = No
Y = Yes
CVI-INC-ACCR-CODE Alpha 10 PR198
Element: Invoice AccruaThe income withholding code assigned to
the invoice. Represents a general ledger
income withholding accrual account. If
left blank, the income withholding code
assigned to the process level or company
defaults. Must be a valid record in the
Income Withholding Code file.
CVI-OPERATOR Alpha 10
Element: Operator This field is used to store the login
id of the person who entered the record.
CVI-INV-USR-FLD-01 Alpha 20 AP52.1
Element: Invoice User FInvoice user field number 1.
CVI-INV-USR-FLD-02 Alpha 20 AP52.1
Element: Invoice User FInvoice user field number 2.
CVI-INV-USR-FLD-03 Alpha 20 AP52.1
Element: Invoice User FInvoice user field number 3.
CVI-INV-USR-FLD-04 Alpha 20 AP52.1
Element: Invoice User FInvoice user field number 4.
CVI-INV-USR-FLD-05 Alpha 20 AP52.1
Element: Invoice User FInvoice user field number 5.
CVI-HANDLING-CODE Alpha 4 AP52.1
Invoice Handling Invoice handling code. Determines the
Code processing rules for invoice matching.
CVI-RCPT-INV-DATE Numeric 8 (yyyymmdd) AP52.1
Receipt of Invoice The day the invoice was received. If
Date left blank, the system date defaults.
CVI-RECORD-ERROR Alpha 1 AP52.1 AP520
Element: Record Error Indicates if the invoice record has not
passed the edit due to errors.
Valid values are
N = No
Y = Yes
" "
CVI-REASON-CODE Alpha 4 AP52.1
Element: Reason Code Reason code. Indicates the cause for
credit memos.
CVI-CBPRINT-FL Alpha 1 AP52.1
Element: Print ChargebaDetermines whether to print chargebacks.
N = No
Y = Yes
CVI-RETAIL-AMT Signed 18.2 AP52.1
Element: Retail Amount
CVI-SEGMENT-BLOCK Alpha 103 AP52.1
Element: Segment Block This field identifies the user analysis
values included in the transaction.
You can either type up to four values or
use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
CVI-JBK-SEQ-NBR Numeric 10 AP52.1
Element: Jbk Seq Nbr The journal book sequence number
assigned to a journal book transaction
when it is added or interfaced to the
Lawson system. Used only when Auto
Journal Book Seq Nbr is set to Yes in
GL10.1 (Company).
CVI-VAT-REG-CTRY Alpha 2 AP52.1
Element: Vat Reg Ctry The country component of the VAT
Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
CVI-VAT-REG-NBR Alpha 12 AP52.1
Element: Vat Reg Nbr The number component of the VAT
Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
CVI-DIVERSE-CODE Alpha 5 AP52.1
Element: Diverse Code Diversity Code for Account Payable
Vendors
CVI-FLEX-FLAG Alpha 1 AP52.1
Element: Flex Flag
CVI-NOTC Alpha 2 AP52.1
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
CVI-STAT-PROC Alpha 6 AP52.1
Element: Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
CVI-FOB-CODE Alpha 3 AP52.1
Element: Fob Code The user defined Free On Board Code.
CVI-SHIP-VIA Alpha 12 (Lower Case) AP52.1
Element: Ship Via
CVI-UNLOADING-PORT Alpha 5 AP52.1
Element: Unloading PortThe prot where the goods are unloaded if
required. Must be defined in IN04.1
(Port Maintenance)
CVI-DROPSHIP-FL Alpha 1 AP52.1
Element: Dropship Fl This flag indicates whether goods being
shipped by the vendor directly to a non
standard location need to have the
receiving process performed.
CVI-TRANSPORT-MODE Alpha 1
Element: Transport ModeThe mode of transportation at the
border crossing. Code 7 is used for the
Channel Tunnel.
APCINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVISET1 COMPANY AP305 AP52.1
VENDOR AP52.2 AP52.3
EDI-NBR AP520 PR198
INVOICE
SUFFIX
CVISET2 COMPANY KeyChange AP520
BATCH-NUM
VENDOR
EDI-NBR
INVOICE
SUFFIX
CVISET3 COMPANY Subset AP52.1 AP52.6
VENDOR Where RECORD-ERROR = "Y" AP520
EDI-NBR
INVOICE
SUFFIX
CVISET4 COMPANY Subset AP520
VENDOR Where (RECORD-ERROR != "Y" )
EDI-NBR
INVOICE
SUFFIX
CVISET5 COMPANY KeyChange, Subset AP520
BATCH-NUM Where (RECORD-ERROR != "Y" )
VENDOR
EDI-NBR
INVOICE
SUFFIX
APCINVOICE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcdistrib APCDISTRIB
CVI-COMPANY -> CVD-COMPANY
CVI-VENDOR -> CVD-VENDOR
CVI-EDI-NBR -> CVD-EDI-NBR
CVI-INVOICE -> CVD-INVOICE
CVI-SUFFIX -> CVD-SUFFIX
CVD-DIST-SEQ-NBR
Apcinverr APCINVERR
CVI-COMPANY -> AER-COMPANY
CVI-VENDOR -> AER-VENDOR
CVI-EDI-NBR -> AER-EDI-NBR
CVI-INVOICE -> AER-INVOICE
CVI-SUFFIX -> AER-SUFFIX
AER-DIST-SEQ
AER-RECORD-TYPE
AER-SEQ-NBR
Apcpayment APCPAYMENT
CVI-COMPANY -> CVP-COMPANY
CVI-VENDOR -> CVP-VENDOR
CVI-EDI-NBR -> CVP-EDI-NBR
CVI-INVOICE -> CVP-INVOICE
CVI-SUFFIX -> CVP-SUFFIX
CVP-SEQ-NBR
|
