DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_OM_REP_JAINEXFR_T

Object Details
Object Name: JAI_OM_REP_JAINEXFR_T
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_OM_REP_JAINEXFR_T
Subobject Name:
Status: VALID


Used as a intermediate table for holding register balace information tax record information during transaction processing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RECORD_SEQUENCE NUMBER (15)
Record Sequence
LINE_LOCATION_ID NUMBER (15)
Line Location Identifier
SHIPMENT_LINE_ID NUMBER (15)
Shipment line identifier
ORDER_LINE_ID NUMBER (15)
Order line identifier
PICKING_LINE_ID NUMBER (15)
No longer used
TRANSACTION_ID NUMBER (15)
Transaction Identiifier
EXPECTED_DATE DATE

Expected date
ADD_LESS VARCHAR2 (5)
Add less
DOC_TYPE VARCHAR2 (20)
Type of Document
DOC_NUM VARCHAR2 (30)
Document Number
DESCRIPTION VARCHAR2 (50)
Description
EXCISE_AMOUNT NUMBER

Excise Amount
RG23A_OP_BAL NUMBER

RG23A Opening Balance
RG23A_AMOUNT NUMBER

RG23A amount
RG23A_CL_BAL NUMBER

RG23A Closing Balance
RG23C_OP_BAL NUMBER

Opening Balance of RG23C register
RG23C_AMOUNT NUMBER

Amount in RG23C register for a particular line
RG23C_CL_BAL NUMBER

RG23C Closing balance
PLA_OP_BAL NUMBER

Pla opening balnace
PLA_AMOUNT NUMBER

Amount in PLA register for a particular line
PLA_CL_BAL NUMBER

PLA Closing balance
REMARKS VARCHAR2 (100)
Remarks
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
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECORD_SEQUENCE
,      LINE_LOCATION_ID
,      SHIPMENT_LINE_ID
,      ORDER_LINE_ID
,      PICKING_LINE_ID
,      TRANSACTION_ID
,      EXPECTED_DATE
,      ADD_LESS
,      DOC_TYPE
,      DOC_NUM
,      DESCRIPTION
,      EXCISE_AMOUNT
,      RG23A_OP_BAL
,      RG23A_AMOUNT
,      RG23A_CL_BAL
,      RG23C_OP_BAL
,      RG23C_AMOUNT
,      RG23C_CL_BAL
,      PLA_OP_BAL
,      PLA_AMOUNT
,      PLA_CL_BAL
,      REMARKS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_OM_REP_JAINEXFR_T;

Dependencies

[top of page]

JA.JAI_OM_REP_JAINEXFR_T does not reference any database object

JA.JAI_OM_REP_JAINEXFR_T is referenced by following:

SchemaAPPS
SynonymJAI_OM_REP_JAINEXFR_T