[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_AR_INVOICES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TRX_AR_INVOICES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
Collection of all OKL transaction which generate Receivables invoices
EXAMPLE
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Transaction status |
TRX_NUMBER | VARCHAR2 | (240) | Invoice number if required | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
SET_OF_BOOKS_ID | NUMBER | Accounting books defining column | ||
TRY_ID | NUMBER | Yes | Foreign key to table OKL_TRX_TYPES_B | |
KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
CRA_ID | NUMBER | Foreign key to table OKL_CURE_REPORT_AMOUNTS | ||
POX_ID | NUMBER | Foreign key to table OKL_POOL_TRANSACTIONS | ||
TAP_ID | NUMBER | Foreign key to table OKL_TRX_AP_INVOICES_B | ||
QTE_ID | NUMBER | Foreign key to table OKL_TRX_QUOTES_B | ||
TCN_ID | NUMBER | Foreign key to table OKL_TRX_CONTRACTS | ||
CPY_ID | NUMBER | Foreign key to table OKL_CURE_PAYMENTS_B | ||
TAI_ID_REVERSES | NUMBER | Foreign Key to table OKL_TRX_AR_INVOICES_B | ||
IBT_ID | NUMBER | Foreign Key to view OKX_CUST_SITE_USES_V | ||
IXX_ID | NUMBER | Foreign Key to view OKX_CUSTOMER_ACCOUNTS_V | ||
IRM_ID | NUMBER | Foreign Key to view OKX_RECEIPT_METHODS_V | ||
IRT_ID | NUMBER | Foreign Key to view OKX_RECEIVABLES_TERMS_V | ||
SVF_ID | NUMBER | Foreign key to table OKL_SERVICE_FEES_B | ||
IPY_ID | NUMBER | Foreign key to table OKL_INS_POLICIES_B | ||
AMOUNT | NUMBER | (14) | Yes | Amount |
CLG_ID | NUMBER | Foreign key to table OKL_CNTR_LVLNG_GRPS_B | ||
DATE_INVOICED | DATE | Yes | Date when transaction should be invoiced | |
AMOUNT_APPLIED | NUMBER | (14) | Amount paid by customer for the invoice | |
DESCRIPTION | VARCHAR2 | (1995) | General description, usually supplied by orginiating transaction | |
SOURCE_TABLE | VARCHAR2 | (90) | Source Table | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
DATE_ENTERED | DATE | Yes | Creation date | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES | ||
INF_ID | NUMBER | Foreign key of okl_invoice_formats_b.ID | ||
INVOICE_PULL_YN | VARCHAR2 | (3) | Foreign key of OKL_CNSLD_AR_HDRS_B.invoice_pull_yn | |
DUE_DATE | DATE | Foreign key of OKL_CNSLD_AR_HDRS_B.due_date | ||
ISI_ID | NUMBER | Foreign key of RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID | ||
RECEIVABLES_INVOICE_ID | NUMBER | Foreign key of ra_customer_trx_all.trx_number | ||
CUST_TRX_TYPE_ID | NUMBER | (15) | Foreign key of ra_customer_trx_lines_all.cust_trx_type_id | |
CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | Foreign key of AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID | |
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax exempt flag | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Foreign key: lookup_code of fnd_lookups.lookup_type = 'OKL_TAX_EXEMPT' | |
REFERENCE_LINE_ID | NUMBER | (15) | For credit memos, to point to original invoice | |
PRIVATE_LABEL | VARCHAR2 | (4000) | Private Label to be displayed on the invoice | |
CONSOLIDATED_INVOICE_NUMBER | VARCHAR2 | (90) | OKL Consolidated bill number | |
OKL_SOURCE_BILLING_TRX | VARCHAR2 | (30) | Source of OKL billing transaction. Refer to fnd_lookups.lookup_type = 'OKL_SOURCE_BILLING_TRX' | |
INVESTOR_AGREEMENT_NUMBER | VARCHAR2 | (120) | Foreign key of okc_k_headers_b.contract_number | |
INVESTOR_NAME | VARCHAR2 | (360) | foreign key of hz_parties.party_name | |
TRANSACTION_DATE | DATE | Stores the date on which the transaction occurred. Equivalent of the the creation date column and is used in reconciliation reports. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, TRX_STATUS_CODE
, TRX_NUMBER
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SET_OF_BOOKS_ID
, TRY_ID
, KHR_ID
, CRA_ID
, POX_ID
, TAP_ID
, QTE_ID
, TCN_ID
, CPY_ID
, TAI_ID_REVERSES
, IBT_ID
, IXX_ID
, IRM_ID
, IRT_ID
, SVF_ID
, IPY_ID
, AMOUNT
, CLG_ID
, DATE_INVOICED
, AMOUNT_APPLIED
, DESCRIPTION
, SOURCE_TABLE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DATE_ENTERED
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LEGAL_ENTITY_ID
, INF_ID
, INVOICE_PULL_YN
, DUE_DATE
, ISI_ID
, RECEIVABLES_INVOICE_ID
, CUST_TRX_TYPE_ID
, CUSTOMER_BANK_ACCOUNT_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_REASON_CODE
, REFERENCE_LINE_ID
, PRIVATE_LABEL
, CONSOLIDATED_INVOICE_NUMBER
, OKL_SOURCE_BILLING_TRX
, INVESTOR_AGREEMENT_NUMBER
, INVESTOR_NAME
, TRANSACTION_DATE
FROM APPS.OKL_TRX_AR_INVOICES_V;
|
|
|