Lease Invoice
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 |
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. |
|
||
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 |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INVSET1 |
COMPANY LEASE PMT-NBR PMT-VENDOR CANCEL-SEQ |
|
| |||||||||||||||||||
INVSET10 |
COMPANY LEASE FISCAL-YEAR* PERIOD* PMT-NBR* PMT-VENDOR CANCEL-SEQ |
|
||||||||||||||||||||
INVSET11 |
COMPANY LEASE DUE-DATE* PMT-NBR* PMT-VENDOR CANCEL-SEQ |
|
||||||||||||||||||||
INVSET2 |
COMPANY AUTH-CODE PMT-VENDOR LEASE PMT-NBR DUE-DATE |
|
||||||||||||||||||||
INVSET3 |
COMPANY LEASE PMT-VENDOR PMT-NBR |
|
||||||||||||||||||||
INVSET4 |
COMPANY APPROVED-FLAG AUTH-CODE LEASE PMT-NBR PMT-VENDOR |
|
||||||||||||||||||||
INVSET6 |
COMPANY LEASE DUE-DATE PMT-NBR PMT-VENDOR CANCEL-SEQ |
|
||||||||||||||||||||
INVSET7 |
COMPANY PMT-VENDOR INVOICE SUFFIX CANCEL-SEQ |
|
| |||||||||||||||||||
INVSET8 |
COMPANY PMT-VENDOR LEASE PMT-NBR |
|
||||||||||||||||||||
INVSET9 |
COMPANY LEASE FISCAL-YEAR PERIOD PMT-VENDOR PMT-NBR CANCEL-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapihist | APAPIHIST |
Not Required
| |||||||||||||||
Apcompany | APCOMPANY |
Required
| |||||||||||||||
Apinvoice | APINVOICE |
Not Required
| |||||||||||||||
Apvenmast | APVENMAST |
Required
| |||||||||||||||
Lmlease | LMLEASE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Lmdistrib | LMDISTRIB |
| |||||||||||||||||||||||||||
Lminvau | LMINVAU |
| |||||||||||||||||||||||||||
Lmpaydtl | LMPAYDTL |
| |||||||||||||||||||||||||||
Lmtrans | LMTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.