APCINVOICE

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
Element: Company
Numeric 4
Required. The company number. Must be a valid record in the Accounts Payable Company file.
AP52.1 PR198
CVI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
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.
AP52.1 PR198
CVI-EDI-NBR
Element: EDI Number
Alpha 15
The electronic data interchange (EDI) number assigned to the vendor.
AP52.1 PR198
CVI-INVOICE
Element: Invoice
Alpha 22
Required. A unique invoice number for the vendor.
AP52.1 PR198
CVI-SUFFIX
Element: Suffix
Numeric 3
The occurrence value of the invoice. Used to identify the recurrence value of a recurring invoice.
AP52.1 PR198
CVI-BATCH-NUM
Element: Batch
Numeric 6
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.
AP52.1 PR198
CVI-VOUCHER-NBR
Element: Voucher
Alpha 10
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.
AP52.1 PR198
CVI-AUTH-CODE
Element: Authority Code
Alpha 3
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.
AP52.1 PR198
CVI-PROC-LEVEL
Element: Process Level
Alpha 5
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.
AP52.1 PR198
CVI-ACCR-CODE
Element: Invoice Accrual Code
Alpha 4
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.
AP52.1 PR198
CVI-INVOICE-TYPE
Element: Invoice Type
Alpha 1
Identifies the type of invoice. Valid values are: Blank = Invoice. Default value. C = Credit Memo. D = Debit Memo.
AP52.1 PR198
CVI-OLD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
THIS FIELD IS NOT CURRENTLY USED.
PR198
CVI-INV-CURRENCY
Element: To Base Curr
Alpha 5
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).
AP52.1 PR198
CVI-INVOICE-DTE
Element: Invoice Date
Numeric 8 (yyyymmdd)
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.
AP52.1 PR198
CVI-TAX-PNT-DATE
Element: Date
Numeric 8 (yyyymmdd)
Tax point date is used to update the Lawson Tax system for released (open) and historical status invoices with a tax code.
PR198
CVI-PURCH-FR-LOC
Element: Purchase From
Alpha 4
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.
AP52.1 PR198
CVI-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP52.1 PR198
CVI-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP52.1 PR198
CVI-PO-CODE
Element: Purchase Order Code
Alpha 4
Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.
AP52.1
CVI-AUTO-MATCH
Element: Auto Match
Alpha 1
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.
PR198
CVI-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The invoice description. This field accepts both upper and lower case entries.
AP52.1 PR198
CVI-BASE-INV-AMT
Element: Intl Amt
Signed 18.2
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.
AP52.1 PR198
CVI-TRAN-INV-AMT
Element: Intl Amt
Signed 18.2
Required. The amount of the invoice in the currency of the invoice.
AP52.1 PR198
CVI-TRAN-ALOW-AMT
Element: Intl Amt
Signed 18.2
The amount of the invoice available for discount in the currency of the invoice. If left blank, the Invoice Amount defaults.
AP52.1 PR198
CVI-TRAN-TXBL-AMT
Element: Intl Amt
Signed 18.2
The taxable amount of the invoice in the currency of the invoice.
AP52.1 PR198
CVI-TRAN-TAX-AMT
Element: Intl Amt
Signed 18.2
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.
AP52.1 PR198
CVI-TRAN-DISC-AMT
Element: Intl Amt
Signed 18.2
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.
AP52.1 PR198
CVI-ORIG-CNV-RATE
Element: Acct Rate
Signed 14.7
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.
AP52.1 PR198
CVI-ANTICIPATION
Element: Anticipate
Alpha 1
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.
AP52.1 PR198
CVI-DISCOUNT-RT
Element: Discount Rt
Percent 5.3 (Percent)
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.
AP52.1 PR198
CVI-DISC-DATE
Element: Date
Numeric 8 (yyyymmdd)
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.
AP52.1 PR198
CVI-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
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.
AP52.1 PR198
CVI-NBR-RECUR-PMT
Element: Nbr Of Invcs
Numeric 3
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.
AP52.1 PR198
CVI-RECUR-FREQ
Element: Recurrence Schedule
Alpha 1
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.
AP52.1 PR198
CVI-REMIT-TO-CODE
Element: Remit To Code
Alpha 4
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.
AP52.1 PR198
CVI-CASH-CODE
Element: Cash Code
Alpha 4
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.
AP52.1 PR198
CVI-SEP-CHK-FLAG
Separate Payment
Option
Alpha 1
Indicates whether the invoice requires a separate payment form. If left blank, the separate payment option defined for the vendor defaults. Valid values are: Y = Yes. N = No.
AP52.1 PR198
CVI-PAY-IMM-FLAG
Pay Immediately
Option
Alpha 1
Indicates whether the invoice will be selected for immediate payment regardless of the due date. Valid values are: N = No. Default value. Y = Yes.
AP52.1 PR198
CVI-ENCLOSURE
Element: Enclosure Option
Alpha 1
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.
AP52.1 PR198
CVI-CURR-RECALC
Currency
Recalculation
Alpha 1
Indicates whether the invoice currency 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.
AP52.1 PR198
CVI-DISC-LOST-FLG
Element: Discount Lost
Alpha 1
For historical status invoices, indicates whether the available discount was lost. Valid values are: N = No. Default value. Y = Yes.
AP52.1 PR198
CVI-TAX-CODE
Element: Tax Code
Alpha 10
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.
AP52.1 PR198
CVI-INCOME-CODE
Element: Income Code
Alpha 4
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.
AP52.1 PR198
CVI-HLD-CODE
Element: Hold Code
Alpha 4
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.
AP52.1 PR198
CVI-DIST-CODE
Element: Dist Code
Alpha 9
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.
AP52.1 PR198
CVI-TERM-CODE
Element: Term Code
Alpha 5
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.
AP52.1 PR198
CVI-REC-STATUS
Element: Invoice Status
Numeric 1
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.
AP52.1 PR198
CVI-POSTING-STATUS
Distribution
Posting Status
Numeric 1
Required. The posting status of 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.
AP52.3 PR198
CVI-DISTRIB-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
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.
AP52.1 PR198
CVI-PAY-VENDOR
Element: Pay Vendor
Alpha 9 (Right Justified)
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.
AP52.1 PR198
CVI-TRANS-NBR
Element: Payment Number
Alpha 10 (Right Justified)
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 Bank Transaction Interface (CB500) to convert payment records before you convert associated invoices.
AP52.1 PR198
CVI-BANK-INST-CODE
Element: Payment Code
Alpha 3
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.
AP52.1 PR198
CVI-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
The payment date. Valid only for historical status invoice records with no payment (check) records.
AP52.1 PR198
CVI-INVOICE-GROUP
Element: Invoice Group
Alpha 4
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.
AP52.1 PR198
CVI-ONE-TIME-VEND
Element: One-Time Vendor
Alpha 1
Indicates whether a one-time vendor record is to be created for the invoiced vendor. Valid values are: N = No. Default value. Y = Yes.
AP52.1 PR198
CVI-VENDOR-VNAME
Element: Vendor Name
Alpha 30 (Lower Case)
The vendor name. Required only if the One-Time Vendor field = Yes. This field accepts both upper and lower case entries.
AP52.1 PR198
CVI-VENDOR-SNAME
Element: Search Name
Alpha 30
The search name for the vendor. Required only if the One-Time Vendor field = Yes. If left blank, the Vendor Name defaults.
AP52.1 PR198
CVI-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
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.
AP52.1 PR198
CVI-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
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.
AP52.1 PR198
CVI-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
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.
AP52.1 PR198
CVI-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
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.
AP52.1 PR198
CVI-CITY-ADDR5
Element: City/Address 5
Alpha 18 (Lower Case)
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.
AP52.1 PR198
CVI-STATE-PROV
Element: State or Province
Alpha 2
The state or province for the vendor. Used only if the One-Time Vendor field = Yes.
AP52.1 PR198
CVI-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
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.
AP52.1 PR198
CVI-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP52.1
CVI-COUNTRY
Element: Country
Alpha 30 (Lower Case)
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.
AP52.1 PR198
CVI-LEGAL-NAME
Element: Legal Name
Alpha 80 (Lower Case)
Institution's legal name used on the GM269 and GM272 reports.
AP52.1
CVI-VEN-INC-CODE
Element: Income Code
Alpha 4
AP52.1
CVI-TAX-ID
Element: Tax ID
Alpha 20
AP52.1
CVI-JRNL-BOOK-NBR
Element: Journal Book
Alpha 12
If using journal books, the journal book assigned to the transaction.
AP52.1 PR198
CVI-BANK-CHK-AMT
Element: Intl Amt
Signed 18.2
The amount of the invoice payment in the currency of the cash code (bank account). Used for historical status invoices only.
PR198
CVI-BANK-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the bank account currency assigned to the cash code. Used for historical status invoices only.
PR198
CVI-BNK-CNV-RATE
Element: Acct Rate
Signed 14.7
The currency exchange rate used to convert the invoice currency to the bank account currency. Used for historical status invoices only.
PR198
CVI-DISCOUNT-CODE
Element: Discount Code
Alpha 10
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.
AP52.1 PR198
CVI-INVOICE-SOURCE
Element: Invoice Source
Alpha 1
Indicates 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
PR198
CVI-INVC-REF-TYPE
Element: Invc Ref Type
Alpha 2
Indicates the type of number the vendor is providing to reference the invoice.
AP52.1
CVI-APPROVED-FLAG
Element: Approved Flag
Alpha 1
If the invoice requires approval, this field indicates whether the invoice is approved.
N = No
Y = Yes
AP52.1 PR198
CVI-INC-ACCR-CODE
Element: Invoice Accrual Code
Alpha 10
The 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.
PR198
CVI-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
CVI-INV-USR-FLD-01
Element: Invoice User Field 1
Alpha 20
Invoice user field number 1.
AP52.1
CVI-INV-USR-FLD-02
Element: Invoice User Field 2
Alpha 20
Invoice user field number 2.
AP52.1
CVI-INV-USR-FLD-03
Element: Invoice User Field 3
Alpha 20
Invoice user field number 3.
AP52.1
CVI-INV-USR-FLD-04
Element: Invoice User Field 4
Alpha 20
Invoice user field number 4.
AP52.1
CVI-INV-USR-FLD-05
Element: Invoice User Field 5
Alpha 20
Invoice user field number 5.
AP52.1
CVI-HANDLING-CODE
Invoice Handling
Code
Alpha 4
Invoice handling code. Determines the processing rules for invoice matching.
AP52.1
CVI-RCPT-INV-DATE
Receipt of Invoice
Date
Numeric 8 (yyyymmdd)
The day the invoice was received. If left blank, the system date defaults.
AP52.1
CVI-RECORD-ERROR
Element: Record Error
Alpha 1
Indicates if the invoice record has not passed the edit due to errors. Valid values are N = No Y = Yes
" "
AP52.1 AP520
CVI-REASON-CODE
Element: Reason Code
Alpha 4
Reason code. Indicates the cause for credit memos.
AP52.1
CVI-CBPRINT-FL
Element: Print Chargebacks
Alpha 1
Determines whether to print chargebacks.
N = No
Y = Yes
AP52.1
CVI-RETAIL-AMT
Element: Retail Amount
Signed 18.2
AP52.1
CVI-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
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.
AP52.1
CVI-JBK-SEQ-NBR
Element: Jbk Seq Nbr
Numeric 10
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).
AP52.1
CVI-VAT-REG-CTRY
Element: Vat Reg Ctry
Alpha 2
The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.
AP52.1
CVI-VAT-REG-NBR
Element: Vat Reg Nbr
Alpha 12
The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.
AP52.1
CVI-DIVERSE-CODE
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
AP52.1
CVI-FLEX-FLAG
Element: Flex Flag
Alpha 1
AP52.1
CVI-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
AP52.1
CVI-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
AP52.1
CVI-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
AP52.1
CVI-SHIP-VIA
Element: Ship Via
Alpha 12 (Lower Case)
AP52.1
CVI-UNLOADING-PORT
Element: Unloading Port
Alpha 5
The prot where the goods are unloaded if required. Must be defined in IN04.1 (Port Maintenance)
AP52.1
CVI-DROPSHIP-FL
Element: Dropship Fl
Alpha 1
This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed.
AP52.1
CVI-TRANSPORT-MODE
Element: Transport Mode
Alpha 1
The mode of transportation at the border crossing. Code 7 is used for the Channel Tunnel.
CVI-TAX-TYPE
Element: Tax Type
Alpha 1

I = Invoice
A = Accrued
CVI-COUNTRY-CODE
Element: Country Code
Alpha 2
AP52.1
CVI-DEST-COUNTRY
Element: Dest Country
Alpha 2
CVI-ORIGIN-COUNTRY
Element: Origin Country
Alpha 2
CVI-FOR-ECON-CODE
Element: Code
Alpha 10
AP52.1
CVI-DISCOUNT-RT1
Element: Discount Rt
Percent 5.3 (Percent)
CVI-DISCOUNT-RT2
Element: Discount Rt
Percent 5.3 (Percent)
CVI-DISCOUNT-RT3
Element: Discount Rt
Percent 5.3 (Percent)
CVI-BASE-DISC-AMT1
Element: Intl Amt
Signed 18.2
CVI-BASE-DISC-AMT2
Element: Intl Amt
Signed 18.2
CVI-BASE-DISC-AMT3
Element: Intl Amt
Signed 18.2
CVI-TRAN-DISC-AMT1
Element: Intl Amt
Signed 18.2
CVI-TRAN-DISC-AMT2
Element: Intl Amt
Signed 18.2
CVI-TRAN-DISC-AMT3
Element: Intl Amt
Signed 18.2
CVI-DISC-DATE1
Element: Date
Numeric 8 (yyyymmdd)
CVI-DISC-DATE2
Element: Date
Numeric 8 (yyyymmdd)
CVI-DISC-DATE3
Element: Date
Numeric 8 (yyyymmdd)
CVI-CARRIER-FLAG
Element: All Flag
Alpha 1
AP52.1
CVI-GLBL-DOC-TYPE
Element: Glbl Doc Type
Alpha 10
AP52.1
CVI-REF-TYPE
Element: Ref Type
Alpha 1
AP52.1
CVI-CUSTOMER-ID
Element: Customer Id
Alpha 27
AP52.1
CVI-PMT-CAT-CODE
Element: Pmt Cat Code
Alpha 6
AP52.1
CVI-NO-PAY-CONCERN
Element: No Pay Concern
Alpha 60
CVI-REFERENCE-NO
Element: Upn2 Nbr
Alpha 25 (Right Justified)


APCINVOICE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVISET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
AP305 AP52.1
AP52.2 AP52.3
AP520 PR198
CVISET2 COMPANY
BATCH-NUM
VENDOR
EDI-NBR
INVOICE
SUFFIX
KeyChange
AP520
CVISET3 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
Subset
WhereRECORD-ERROR ="Y"
AP52.1 AP52.6
AP520
CVISET4 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
Subset
Where(RECORD-ERROR !="Y")
AP520
CVISET5 COMPANY
BATCH-NUM
VENDOR
EDI-NBR
INVOICE
SUFFIX
KeyChange, Subset
Where(RECORD-ERROR !="Y")
AP520


APCINVOICE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:06:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.