[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#;
|
|
|