[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_RG_I_TRXS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGISTER_ID | NUMBER | (15) | Yes | |
REGISTER_ID_PART_II | NUMBER | (15) | ||
FIN_YEAR | NUMBER | (9) | Yes | |
SLNO | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
LOCATION_ID | NUMBER | (15) | Yes | |
TRANSACTION_DATE | DATE | Yes | ||
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | |
TRANSACTION_TYPE | VARCHAR2 | (10) | Yes | |
MANUFACTURED_QTY | NUMBER | |||
MANUFACTURED_PACKED_QTY | NUMBER | |||
MANUFACTURED_LOOSE_QTY | NUMBER | |||
FOR_HOME_USE_PAY_ED_QTY | NUMBER | |||
FOR_HOME_USE_PAY_ED_VAL | NUMBER | |||
FOR_EXPORT_PAY_ED_QTY | NUMBER | |||
FOR_EXPORT_PAY_ED_VAL | NUMBER | |||
FOR_EXPORT_N_PAY_ED_QTY | NUMBER | |||
FOR_EXPORT_N_PAY_ED_VAL | NUMBER | |||
OTHER_PURPOSE | VARCHAR2 | (30) | ||
TO_OTHER_FACTORY_N_PAY_ED_QTY | NUMBER | |||
TO_OTHER_FACTORY_N_PAY_ED_VAL | NUMBER | |||
OTHER_PURPOSE_N_PAY_ED_QTY | NUMBER | |||
OTHER_PURPOSE_N_PAY_ED_VAL | NUMBER | |||
OTHER_PURPOSE_PAY_ED_QTY | NUMBER | |||
OTHER_PURPOSE_PAY_ED_VAL | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
TRANSACTION_UOM_CODE | VARCHAR2 | (3) | ||
BALANCE_PACKED | NUMBER | |||
BALANCE_LOOSE | NUMBER | |||
ISSUE_TYPE | VARCHAR2 | (10) | ||
EXCISE_DUTY_AMOUNT | NUMBER | |||
EXCISE_INVOICE_NUMBER | VARCHAR2 | (200) | ||
EXCISE_INVOICE_DATE | DATE | |||
PAYMENT_REGISTER | VARCHAR2 | (10) | ||
CHARGE_ACCOUNT_ID | NUMBER | (15) | ||
RANGE_NO | VARCHAR2 | (50) | ||
DIVISION_NO | VARCHAR2 | (50) | ||
REMARKS | VARCHAR2 | (100) | ||
BASIC_ED | NUMBER | |||
ADDITIONAL_ED | NUMBER | |||
OTHER_ED | NUMBER | |||
EXCISE_DUTY_RATE | NUMBER | |||
VENDOR_ID | NUMBER | (15) | ||
VENDOR_SITE_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_SITE_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
POSTED_FLAG | VARCHAR2 | (1) | ||
MASTER_FLAG | VARCHAR2 | (1) | ||
BOL_ID | NUMBER | (10) | ||
BOLLINE_NO | NUMBER | (5) | ||
TRANSACTION_SOURCE_NUM | NUMBER | (15) | ||
REF_DOC_NO | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
CESS_AMT | NUMBER | |||
SOURCE | VARCHAR2 | (30) | ||
SH_CESS_AMT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REGISTER_ID
, REGISTER_ID_PART_II
, FIN_YEAR
, SLNO
, ORGANIZATION_ID
, LOCATION_ID
, TRANSACTION_DATE
, INVENTORY_ITEM_ID
, TRANSACTION_TYPE
, MANUFACTURED_QTY
, MANUFACTURED_PACKED_QTY
, MANUFACTURED_LOOSE_QTY
, FOR_HOME_USE_PAY_ED_QTY
, FOR_HOME_USE_PAY_ED_VAL
, FOR_EXPORT_PAY_ED_QTY
, FOR_EXPORT_PAY_ED_VAL
, FOR_EXPORT_N_PAY_ED_QTY
, FOR_EXPORT_N_PAY_ED_VAL
, OTHER_PURPOSE
, TO_OTHER_FACTORY_N_PAY_ED_QTY
, TO_OTHER_FACTORY_N_PAY_ED_VAL
, OTHER_PURPOSE_N_PAY_ED_QTY
, OTHER_PURPOSE_N_PAY_ED_VAL
, OTHER_PURPOSE_PAY_ED_QTY
, OTHER_PURPOSE_PAY_ED_VAL
, PRIMARY_UOM_CODE
, TRANSACTION_UOM_CODE
, BALANCE_PACKED
, BALANCE_LOOSE
, ISSUE_TYPE
, EXCISE_DUTY_AMOUNT
, EXCISE_INVOICE_NUMBER
, EXCISE_INVOICE_DATE
, PAYMENT_REGISTER
, CHARGE_ACCOUNT_ID
, RANGE_NO
, DIVISION_NO
, REMARKS
, BASIC_ED
, ADDITIONAL_ED
, OTHER_ED
, EXCISE_DUTY_RATE
, VENDOR_ID
, VENDOR_SITE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, POSTED_FLAG
, MASTER_FLAG
, BOL_ID
, BOLLINE_NO
, TRANSACTION_SOURCE_NUM
, REF_DOC_NO
, OBJECT_VERSION_NUMBER
, CESS_AMT
, SOURCE
, SH_CESS_AMT
FROM JA.JAI_CMN_RG_I_TRXS#;
|
|
|