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

TABLE: JA.JAI_ST_INVOICE_REVERSAL

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


This table contains the reversal transactions after reversal for service tax.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_ST_INVOICE_REVERSAL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSAL_ID
JAI_ST_INVOICE_REVERSAL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE
ColumnINVOICE_ID
ColumnLINE_NUM
Columns
Name Datatype Length Mandatory Comments
REVERSAL_ID NUMBER
Yes Sequence
INVOICE_ID NUMBER
Yes Invoice Id/Customer Trx Id
LINE_NUM NUMBER
Yes Line number of AP/AR Invoice
BATCH_ID NUMBER
Yes Batch id for reversal/refund.
BATCH_NAME VARCHAR2 (50) Yes Batch Name for reversal/refund.
SOURCE VARCHAR2 (10) Yes 'AP' or 'AR'
MATCH_TYPE VARCHAR2 (30)
'Item To PO' or 'Item to Receipt'.
ORGANIZATION_ID NUMBER

Organization id
LOCATION_ID NUMBER

Location id
CUSTOMER_TRX_LINE_ID NUMBER

Line ID of AR only
ACCOUNTING_DATE DATE

GL date
ORIGINAL_LINE_AMT NUMBER

Original amount of the transaction including all taxes.
RCV_SVC_TAX NUMBER

All the service tax amount for the line.
PARTY_ID NUMBER

Vendor id or customer id.
PARTY_SITE_ID NUMBER

Vendor site id or customer site id.
MAX_CLAIM_PAYMENT_ID NUMBER

Max claimed payment id
TAX_TO_BE_ADJUSTED NUMBER

Amount of service tax to be adjusted for the line
REVERSAL_AMOUNT NUMBER

Reversal Amount for the lines.
OPEN_AMT NUMBER

Open Amount
DATE_OF_REVERSAL DATE

Reversal date
REFUND_TYPE VARCHAR2 (50)
Refund type
AUTHORIZATION_DATE DATE

Authorization date
AUTHORIZATION_DETAILS VARCHAR2 (240)
Authorization details
REMARKS VARCHAR2 (150)
Remarks
ATTRIBUTE1 VARCHAR2 (150)
Other Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Other Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Other Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Other Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Other Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Other Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Other Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Other Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Other Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Other Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Other Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Other Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Other Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Other Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Other Attribute15
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
CREATION_DATE DATE
Yes Creation date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_DATE DATE
Yes Last update date
LAST_UPDATE_LOGIN NUMBER
Yes Last update login
LAST_UPDATED_BY NUMBER
Yes Last updated by
REVERSAL_SETUP_FLAG VARCHAR2 (2)
REVERSAL_SETUP_FLAG
Query Text

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


SELECT REVERSAL_ID
,      INVOICE_ID
,      LINE_NUM
,      BATCH_ID
,      BATCH_NAME
,      SOURCE
,      MATCH_TYPE
,      ORGANIZATION_ID
,      LOCATION_ID
,      CUSTOMER_TRX_LINE_ID
,      ACCOUNTING_DATE
,      ORIGINAL_LINE_AMT
,      RCV_SVC_TAX
,      PARTY_ID
,      PARTY_SITE_ID
,      MAX_CLAIM_PAYMENT_ID
,      TAX_TO_BE_ADJUSTED
,      REVERSAL_AMOUNT
,      OPEN_AMT
,      DATE_OF_REVERSAL
,      REFUND_TYPE
,      AUTHORIZATION_DATE
,      AUTHORIZATION_DETAILS
,      REMARKS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      REVERSAL_SETUP_FLAG
FROM JA.JAI_ST_INVOICE_REVERSAL;

Dependencies

[top of page]

JA.JAI_ST_INVOICE_REVERSAL does not reference any database object

JA.JAI_ST_INVOICE_REVERSAL is referenced by following:

SchemaJA
ViewJAI_ST_INVOICE_REVERSAL#