|
|
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
AP52.1 AP52.3 AP520 PR199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVI-COMPANY Numeric 4 AP52.1 PR199
Company Required. The company number. Must be a
valid record in the Accounts Payable
Company file.
CVI-VENDOR Alpha 9 AP52.1 PR199
Vendor ID 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 PR199
EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
CVI-INVOICE Alpha 22 AP52.1 PR199
Invoice Number Required. A unique invoice number for
the vendor.
CVI-SUFFIX Numeric 3 AP52.1 PR199
Invoice Suffix The occurrence value of the invoice.
Used to identify the recurrence value of
a recurring invoice.
CVI-BATCH-NUM Numeric 6 AP52.1 PR199
Batch Number 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 PR199
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 PR199
Authority Code The 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 PR199
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 PR199
Invoice Accrual Code The 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 PR199
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 PR199
Old Vendor ID THIS FIELD IS NOT CURRENTLY USED.
CVI-INV-CURRENCY Alpha 5 AP52.1 PR199
Invoice Currency 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 PR199
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) PR199
Tax Point 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 PR199
Purchase From The vendor's purchase-from location.
Location Code 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-NUM Alpha 7 (Right Justified) AP52.1 PR199
PO Number The purchase order number.
CVI-PO-RELEASE Numeric 6 AP52.1 PR199
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
CVI-AUTO-MATCH Alpha 1 PR199
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 PR199
Description The invoice description. This field
accepts both upper and lower case
entries.
CVI-BASE-INV-AMT Signed 15.2 AP52.1 PR199
Base Invoice Amount 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 15.2 AP52.1 PR199
Invoice Amount Required. The amount of the invoice in
the currency of the invoice.
CVI-TRAN-ALOW-AMT Signed 15.2 AP52.1 PR199
Allowable Amount 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 15.2 AP52.1 PR199
Taxable Amount The taxable amount of the invoice in
the currency of the invoice.
CVI-TRAN-TAX-AMT Signed 15.2 AP52.1 PR199
Tax Amount 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 15.2 AP52.1 PR199
Discount Amount 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 12.6 AP52.1 PR199
Exchange 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 PR199
Anticipation Flag 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 Signed 5.3 AP52.1 PR199
Discount Rate 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 PR199
Discount Date The discount date assigned to the
invoice. Used by AP150 (Cash
Requirements) 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 PR199
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 PR199
Number of Indicates the number of times a
Recurrences 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 PR199
Recurring Frequency Indicates 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 PR199
Remit To Location The remit-to location associated with
Code 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 PR199
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 PR199
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 PR199
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 PR199
Enclosure Option Indicates 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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
Distribution 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 PR199
Terms 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 PR199
Invoice Status Required. 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 PR199
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 PR199
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 AP52.1 PR199
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 PR199
Payment Number The 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 CB500 (Bank
Transaction Interface) to convert
payment records before you convert
associated invoices.
CVI-BANK-INST-CODE Alpha 3 AP52.1 PR199
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 PR199
Payment Date The payment date. Valid only for
historical status invoice records with
no payment (check) records.
CVI-INVOICE-GROUP Alpha 4 AP52.1 PR199
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.
AP150 (Cash Requirements) has an option
to select all invoices assigned the same
invoice group.
CVI-ONE-TIME-VEND Alpha 1 AP52.1 PR199
One-Time Vendor Indicates 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 PR199
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 PR199
Vendor 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 PR199
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 PR199
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 PR199
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 PR199
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 PR199
City/Address 5 The 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 PR199
State or Province The state or province for the vendor.
Used only if the One-Time Vendor field =
Yes.
CVI-POSTAL-CODE Alpha 10 (Lower Case) AP52.1 PR199
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-COUNTRY Alpha 30 (Lower Case) AP52.1 PR199
Country Name 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-JRNL-BOOK-NBR Alpha 12 AP52.1 PR199
Journal Book If using journal books, the journal
book assigned to the transaction.
CVI-BANK-CHK-AMT Signed 15.2 PR199
Bank Payment Amount 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 PR199
Bank Currency Nbr The number of decimal positions defined
of Decimals for the bank account currency assigned
to the cash code. Used for historical
status invoices only.
CVI-BNK-CNV-RATE Signed 12.6 PR199
Bank Currency The currency exchange rate used to
Exchange Rate convert the invoice currency to the bank
account currency. Used for historical
status invoices only.
CVI-DISCOUNT-CODE Alpha 10 AP52.1 PR199
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 PR199
Invoice Source Indicates the source for creation of
the invoice: manual (default), EDI, ERS.
E = EDI
R = ERS
" " = Manual
P = Payroll
T = Tax
G = Garnishment
CVI-APPROVED-FLAG Alpha 1 AP52.1 PR199
Approved If the invoice requires approval, this
field indicates whether the invoice is
approved.
CVI-INC-ACCR-CODE Alpha 10 PR199
Income Withholding The income withholding code assigned to
Code 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-JBK-SEQ-NBR Numeric 10 AP52.1
Journal Book The journal book sequence number
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-COUNTRY-CODE Alpha 2 AP52.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CVI-REGION Alpha 2 AP52.1
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
CVI-INTRASTAT-FL Alpha 1 AP52.1
Intrastat Flag Indicates whether the invoice is
subject to Intrastat reporting. (Yes or
No).
CVI-SHIP-TO-CTRY Alpha 2 AP52.1
Ship To Country The ship-to country code. Must be a
valid Intrastat country code, defined in
IN01.1 (Country Maintenance)
CVI-SHIP-TO-REGION Alpha 2 AP52.1
Ship To Region The ship-to region code.
Must be a valid region for the country,
defined in IN02.1 (Region
Maintenance).
CVI-UNLOADING-PORT Alpha 5 AP52.1
Port of Unloading The port where the goods are unloaded
if required. Must be defined in
IN04.1 (Port Maintenance).
CVI-NOTC Alpha 2 AP52.1
Nature Of The Nature Of Transaction Code. This
Transaction Code code must be defined in IN07.1 (NOTC
Maintenance).
CVI-DLVRY-TRMS Alpha 1 AP52.1
Delivery Terms The terms of delivery
1 = EXW 4 = DDU 9 = XXX
2 = FDB 5 = CFR
3 = CIF 6 = CIP
CVI-TRANSPORT-MODE Alpha 1 AP52.1
Transport Mode The mode of transportation at the border
crossing. Code 7 is used for the
Channel Tunnel.
1 - Sea
2 - Rail
3 - Road
4 - Air
5 - Post
7 - Fixed Installations
8 - Inland Waterway
9 - Own Propulsion
CVI-DROP-SHIP-IND Alpha 1 AP52.1
Drop Ship Indicator Specifies whether the shipment is a
drop (triangulated) shipment, that is a
shipment where goods are shipped from
one EC country to another, but a
principal in the transaction is based
elsewhere.
CVI-STAT-PROC Alpha 6 AP52.1
Statistical The statistical procedure code applied
Procedure to the data. The code must be defined
in IN06.1 (Statistical Procedure
Maintenance).
CVI-BOE-CODE Alpha 2 AP52.1
BOE Code A 2-digit term referring to energy,
required in some countries.
CVI-AFFILIATION-CD Alpha 1 AP52.1
Affiliation Code Specifies whether there is a
affiliation between the declarnt and
vendor or customer. No is the default.
CVI-CSA-CODE Alpha 1 AP52.1
CSA Code Required in some countries for energy
transactions. Select Yes if the
transactions is under contractual
agreement. No is the default.
CVI-SEGMENT-BLOCK Alpha 103 AP52.1
User Analysis 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.
APCINVOICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVISET1 COMPANY This index is used to access invoice AP52.1 AP52.2
VENDOR conversion or interface records that do AP52.3 AP520
EDI-NBR not have a batch number assigned. PR199
INVOICE
SUFFIX
CVISET2 COMPANY This index is used to access invoice AP520
BATCH-NUM conversion or interface records that do
VENDOR not have a batch number assigned.
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
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
|