[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JAI_RCV_TRANSACTIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | JA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SHIPMENT_HEADER_ID | NUMBER | Yes | ||
| SHIPMENT_LINE_ID | NUMBER | Yes | ||
| TRANSACTION_ID | NUMBER | Yes | ||
| TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | |
| TRANSACTION_DATE | DATE | |||
| QUANTITY | NUMBER | |||
| UOM_CODE | VARCHAR2 | (3) | ||
| PARENT_TRANSACTION_ID | NUMBER | |||
| PARENT_TRANSACTION_TYPE | VARCHAR2 | (25) | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
| RECEIPT_NUM | VARCHAR2 | (30) | ||
| ORGANIZATION_ID | NUMBER | (15) | ||
| LOCATION_ID | NUMBER | (15) | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | ||
| EXCISE_INVOICE_NO | VARCHAR2 | (30) | ||
| EXCISE_INVOICE_DATE | DATE | |||
| TAX_AMOUNT | NUMBER | |||
| ASSESSABLE_VALUE | NUMBER | |||
| CENVAT_AMOUNT | NUMBER | |||
| CENVAT_CLAIMED_PTG | NUMBER | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| ITEM_CLASS | VARCHAR2 | (4) | ||
| ITEM_CENVATABLE | VARCHAR2 | (2) | ||
| ITEM_EXCISABLE | VARCHAR2 | (2) | ||
| ITEM_TRADING_FLAG | VARCHAR2 | (1) | ||
| INV_ITEM_FLAG | VARCHAR2 | (1) | ||
| INV_ASSET_FLAG | VARCHAR2 | (1) | ||
| LOC_SUBINV_TYPE | VARCHAR2 | (2) | ||
| ORGANIZATION_TYPE | VARCHAR2 | (2) | ||
| EXCISE_IN_TRADING | VARCHAR2 | (2) | ||
| COSTING_METHOD | NUMBER | |||
| BOE_APPLIED_FLAG | VARCHAR2 | (1) | ||
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | ||
| PROCESS_MESSAGE | VARCHAR2 | (1000) | ||
| CENVAT_RG_MESSAGE | VARCHAR2 | (1000) | ||
| PROCESS_DATE | DATE | |||
| CODEPATH | VARCHAR2 | (1996) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| TAX_TRANSACTION_ID | NUMBER | (15) | ||
| PROCESS_VAT_MESSAGE | VARCHAR2 | (1000) | ||
| VAT_INVOICE_NO | VARCHAR2 | (100) | ||
| VAT_INVOICE_DATE | DATE | |||
| BASE_ASSET_INVENTORY | NUMBER | (9) | ||
| PROCESS_STATUS | VARCHAR2 | (2) | ||
| CENVAT_RG_STATUS | VARCHAR2 | (2) | ||
| PROCESS_VAT_STATUS | VARCHAR2 | (2) | ||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| TAX_APPORTION_FACTOR | NUMBER | |||
| QUANTITY_REGISTER_FLAG | VARCHAR2 | (1) | ||
| OPM_COSTING_FLAG | VARCHAR2 | (1) | ||
| OPM_COSTING_AMOUNT | NUMBER | (22) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| EXCISE_INV_GEN_STATUS | VARCHAR2 | (150) | ||
| VAT_INV_GEN_STATUS | VARCHAR2 | (150) | ||
| EXCISE_INV_GEN_NUMBER | VARCHAR2 | (150) | ||
| VAT_INV_GEN_NUMBER | VARCHAR2 | (150) | ||
| CENVAT_COSTED_FLAG | VARCHAR2 | (150) | ||
| TRX_INFORMATION | VARCHAR2 | (30) | ||
| GST_INVOICE_NO | VARCHAR2 | (150) | ||
| GST_INVOICE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, TRANSACTION_ID
, TRANSACTION_TYPE
, TRANSACTION_DATE
, QUANTITY
, UOM_CODE
, PARENT_TRANSACTION_ID
, PARENT_TRANSACTION_TYPE
, DESTINATION_TYPE_CODE
, RECEIPT_NUM
, ORGANIZATION_ID
, LOCATION_ID
, INVENTORY_ITEM_ID
, EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE
, TAX_AMOUNT
, ASSESSABLE_VALUE
, CENVAT_AMOUNT
, CENVAT_CLAIMED_PTG
, CURRENCY_CONVERSION_RATE
, ITEM_CLASS
, ITEM_CENVATABLE
, ITEM_EXCISABLE
, ITEM_TRADING_FLAG
, INV_ITEM_FLAG
, INV_ASSET_FLAG
, LOC_SUBINV_TYPE
, ORGANIZATION_TYPE
, EXCISE_IN_TRADING
, COSTING_METHOD
, BOE_APPLIED_FLAG
, THIRD_PARTY_FLAG
, PROCESS_MESSAGE
, CENVAT_RG_MESSAGE
, PROCESS_DATE
, CODEPATH
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, TAX_TRANSACTION_ID
, PROCESS_VAT_MESSAGE
, VAT_INVOICE_NO
, VAT_INVOICE_DATE
, BASE_ASSET_INVENTORY
, PROCESS_STATUS
, CENVAT_RG_STATUS
, PROCESS_VAT_STATUS
, OBJECT_VERSION_NUMBER
, TAX_APPORTION_FACTOR
, QUANTITY_REGISTER_FLAG
, OPM_COSTING_FLAG
, OPM_COSTING_AMOUNT
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EXCISE_INV_GEN_STATUS
, VAT_INV_GEN_STATUS
, EXCISE_INV_GEN_NUMBER
, VAT_INV_GEN_NUMBER
, CENVAT_COSTED_FLAG
, TRX_INFORMATION
, GST_INVOICE_NO
, GST_INVOICE_DATE
FROM JA.JAI_RCV_TRANSACTIONS#;
JA
JAI_RCV_TRANSACTIONS
APPS
JAI_RCV_TRANSACTIONS
|
|
|
|