[Home] [Help] [Dependency Information]
Object Name: | JAI_RGM_TRX_REFS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REFERENCE_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | ||
SOURCE | VARCHAR2 | (30) | ||
INVOICE_ID | NUMBER | (15) | ||
LINE_ID | NUMBER | (15) | ||
TAX_TYPE | VARCHAR2 | (30) | ||
TAX_ID | NUMBER | (15) | ||
TAX_RATE | NUMBER | |||
TRX_TAX_AMOUNT | NUMBER | |||
TRX_CURRENCY | VARCHAR2 | (15) | ||
CURR_CONV_DATE | DATE | |||
CURR_CONV_RATE | NUMBER | |||
TAX_AMOUNT | NUMBER | |||
RECOVERED_AMOUNT | NUMBER | |||
DISCOUNTED_AMOUNT | NUMBER | |||
TAXABLE_BASIS | NUMBER | |||
RECOVERABLE_AMOUNT | NUMBER | |||
RECOVERABLE_PTG | NUMBER | |||
PARTY_TYPE | VARCHAR2 | (2) | ||
PARTY_ID | NUMBER | (15) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
ITEM_LINE_ID | NUMBER | (15) | ||
ITEM_ID | NUMBER | (15) | ||
PARENT_REFERENCE_ID | NUMBER | (15) | ||
REVERSAL_FLAG | VARCHAR2 | (1) | ||
BATCH_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT REFERENCE_ID
, ORGANIZATION_ID
, SOURCE
, INVOICE_ID
, LINE_ID
, TAX_TYPE
, TAX_ID
, TAX_RATE
, TRX_TAX_AMOUNT
, TRX_CURRENCY
, CURR_CONV_DATE
, CURR_CONV_RATE
, TAX_AMOUNT
, RECOVERED_AMOUNT
, DISCOUNTED_AMOUNT
, TAXABLE_BASIS
, RECOVERABLE_AMOUNT
, RECOVERABLE_PTG
, PARTY_TYPE
, PARTY_ID
, PARTY_SITE_ID
, ITEM_LINE_ID
, ITEM_ID
, PARENT_REFERENCE_ID
, REVERSAL_FLAG
, BATCH_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_TRX_REFS#;
|
|
|