Oracle E-Business Suite · Schema
Oracle EBS Invoice
Schema representing an Accounts Payable invoice in Oracle E-Business Suite. Maps to AP_INVOICES_ALL and AP_INVOICE_LINES_ALL tables. Covers standard invoices, credit memos, debit memos, and prepayments.
Business ApplicationsE-Business SuiteEnterpriseERPOracle
Properties
| Name | Type | Description |
|---|---|---|
| invoiceId | integer | Unique identifier for the invoice (AP_INVOICES_ALL.INVOICE_ID) |
| invoiceNum | string | Supplier invoice number (AP_INVOICES_ALL.INVOICE_NUM) |
| invoiceDate | string | Invoice date |
| invoiceReceivedDate | stringnull | Date the invoice was received |
| invoiceType | string | Invoice type lookup code |
| vendorId | integer | Supplier/vendor identifier (AP_SUPPLIERS.VENDOR_ID) |
| vendorName | string | Supplier/vendor name |
| vendorNum | string | Vendor number |
| vendorSiteId | integer | Vendor site identifier (AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID) |
| vendorSiteCode | string | Vendor site code |
| invoiceAmount | number | Total invoice amount in invoice currency |
| invoiceCurrencyCode | string | Invoice currency code (ISO 4217) |
| paymentCurrencyCode | string | Payment currency code (ISO 4217) |
| exchangeRate | numbernull | Currency exchange rate |
| exchangeRateType | stringnull | Exchange rate type (Corporate, Spot, User) |
| exchangeDate | stringnull | Exchange rate date |
| baseAmount | numbernull | Invoice amount in functional/base currency |
| termsId | integer | Payment terms identifier (AP_TERMS.TERM_ID) |
| termsName | string | Payment terms name |
| termsDate | stringnull | Payment terms date |
| description | stringnull | Invoice description |
| source | string | Invoice source (Manual, EDI, ERS, etc.) |
| paymentStatusFlag | string | Payment status: Y=Fully Paid, N=Not Paid, P=Partially Paid |
| paymentMethodCode | stringnull | Payment method lookup code |
| approvalStatus | string | Approval status |
| wfapprovalStatus | stringnull | Workflow approval status |
| amountPaid | number | Total amount paid against this invoice |
| discountAmountTaken | numbernull | Total discount amount taken |
| amountApplicableToDiscount | numbernull | Amount applicable to discount |
| taxAmount | numbernull | Total tax amount |
| poHeaderId | integernull | Matched purchase order header ID |
| goodsReceivedDate | stringnull | Date goods were received |
| glDate | string | General Ledger accounting date |
| payGroupLookupCode | stringnull | Pay group |
| cancelledDate | stringnull | Date the invoice was cancelled |
| cancelledAmount | numbernull | Cancelled amount |
| lines | array | Invoice lines |
| payments | array | Payment records associated with this invoice |
| holds | array | Active holds on this invoice |
| orgId | integer | Operating unit identifier |
| createdBy | integer | User who created the record |
| creationDate | string | Record creation date |
| lastUpdatedBy | integer | User who last updated the record |
| lastUpdateDate | string | Record last update date |