Invoices

This file stores the invoices generated from a lease payment schedule. These invoices can be edited and sent on to the Accounts Payable system.

REFERENCED BY

APCP.1

UPDATED BY

AP30.4

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
INV-COMPANY Element: Company	Numeric 4 This field contains the Accounts Payable company associated with the invoice.
INV-LEASE Element: Lease	Alpha 19 This is the lease ID as defined using LM21.1 or LM21.2.
INV-PMT-VENDOR Element: Payment Vendor	Alpha 9 (Right Justified) This is the payment vendor or lessor associated with the lease payment.
INV-PMT-NBR Element: Payment Number	Numeric 6 This is the payment number for the lease invoice, derived from the lease payment schedule.
INV-INVOICE Element: Invoice	Alpha 22 The field contains the unique invoice number associated with the invoice. For Lease Management, it consists of the lease ID and payment number.
INV-SUFFIX Element: Suffix	Numeric 3 This field contains the invoice suffix used to make a recurring invoice instance unique.
INV-CANCEL-SEQ Invoice Cancellation Number	Numeric 4 An automatically assigned sequence number.	AP30.4
INV-STATUS Element: Status	Numeric 1 This field contains the invoice status. Valid values are: 0 = Unreleased 1 = Released 9 = Posted NOTE: If the status of the invoice is Unreleased, the distribution posting status must be Unposted.
INV-AUTH-CODE Element: Authority Code	Alpha 3 This field contains the authority code of the person responsible for releasing the invoice for payment. This code is defined in theAccounts Payable system.
INV-PROC-LEVEL Element: Process Level	Alpha 5 This field contains the process level assigned to the invoice. Must be a valid record in the Accounts Payable system.
INV-HANDLING-CODE Element: Handling Code	Alpha 4 This field contains the handling code specifying invoice rules. The handling code is defined in the Invoice Matching (MA) system.
INV-VOUCHER-NBR Element: Voucher Number	Alpha 10 This field containd the user-defined voucher number for the invoice.
INV-ACCR-CODE Element: Accrual Code	Alpha 4
INV-INVOICE-TYPE Element: Invoice Type	Alpha 1 This field contains the invoice type. Valid values are: Blank = Regular Invoice C = Credit Memo H = Historical D = Debit Memo. Processed just like an invoice. Increases the amount owed to the vendor.
INV-TRAN-INV-AMT Lease Currency Invoice Amount	Signed 18.2 This field contains the amount of the invoice in the invoice currency (which is also the lease currency).
INV-TRAN-CURR Element: Lease Currency Code	Alpha 5 This field contains the transaction currency.
INV-TRAN-ND Element: Number of Decimals	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
INV-BASE-INV-AMT Base Currency Invoice Amount	Signed 18.2 This field contains the invoice amount in compaby base currency.
INV-BASE-CURR Element: Base Currency Code	Alpha 5 This field contains the company base currency.
INV-BASE-ND Base Currency Nber of Decimals	Numeric 1 The number of decimal positions defined for the company base currency.
INV-ORIG-CNV-RATE Original Exchange Rate	Signed 14.7
INV-INVOICE-DATE Element: Invoice Date	Numeric 8 (yyyymmdd) This field contains the date of the invoice. It can be the date on which the vendor created the invoice or the date on which it was received. This is the date used when updating vendor balances.
INV-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field contains the description of the invoice.
INV-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) This field contains the invoice due date. It is used by the Accounts Payable system to select the invoice for payment.
INV-DISTRIB-DATE Element: Posting Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.
INV-FISCAL-YEAR Element: Fiscal Year	Numeric 4 Contains the fiscal year for the data stored on this record.
INV-PERIOD Element: Period	Numeric 2 This is the current accounting period. This field is updated by Period Closing (GL199).
INV-APPROVED-FLAG Element: Approved Flag	Alpha 1 If the invoice requires approval, this field indicates the approval status of the invoice. Valid values are: Y = Yes (approved) N = No (not yet approved) D = Disapproved (authorization denied)
INV-CANCELLED-FL Element: Cancellation Flag	Alpha 1 This field contains the canceled flag. Vaid values are: Y = Yes N = No	AP30.4
INV-CANCELLED-AP Element: AP Cancellation Flag	Derived This flag is set in the Accounts Payable system if Cancelled Flag is set to Yes.
INV-CANCELLED-LM Element: LM Cancellation Flag	Derived This flag is set in the Lease management system if Canceled Flag is set to Yes.
INV-REMIT-TO-CODE Element: Remit To Code	Alpha 4 A user-defined code that represents a vendor's remittance address.
INV-TRAN-TAX-AMT Element: Intl Amt	Signed 18.2
INV-BASE-TAX-AMT Element: Intl Amt	Signed 18.2
INV-TRAN-TAXABLE Element: Intl Amt	Signed 18.2

LMINVOICE FILE INDEX

LMINVOICE FILE RELATIONS

ONE TO ONE RELATIONS

LMINVOICE FILE RELATIONS

ONE TO MANY RELATIONS

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