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

TABLE: JA.JAI_CMN_ST_FORM_DTLS

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


Stores information pertaining to the sales tax forms tracking. This table stores the info for both Payables and Receivables transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_ST_FORM_DTLS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
JAI_CMN_ST_FORM_DTLS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnST_HDR_ID
ColumnINVOICE_ID
JAI_CMN_ST_FORM_DTLS_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnST_DTL_ID
Columns
Name Datatype Length Mandatory Comments
ST_HDR_ID NUMBER (38) Yes Link to ja_in_st_forms_hdr table
ST_DTL_ID NUMBER (38) Yes Sequence Generated Identifier for a row
HEADER_ID NUMBER (15)
PO/Order Header identifier
LINE_ID NUMBER (15)
PO/Order Line identifier
LOCATION_ID NUMBER (15)
Indicates the location Identifier
ORGANIZATION_ID NUMBER (15)
Indicates the organization Identifier
TAX_ID NUMBER (15)
Tax Identifier
TAX_LINE_NO NUMBER (15)
Tax Line Number
INVOICE_ID NUMBER

Identifies a AR/AP invoice identifier
ISSUE_RECEIPT_FLAG VARCHAR2 (1)
Identifies whether the record is for a Issue or receipt. Can have values like I or R. I -> Issue (AP Side) . R -> Receipt (AR Side).
TAX_TARGET_AMOUNT NUMBER

Indicates the Tax Base Amount.
MATCHED_AMOUNT NUMBER

Indicates the amount matched
PO_NUM VARCHAR2 (20)
Purchase Order Number
DOC_TYPE VARCHAR2 (30)
Document Type
PO_LINE_LOCATION_ID NUMBER (15)
Purchase Order Line Location Identifier
RCV_TRANSACTION_ID NUMBER (15)
Rcv_Transaction_identifier from the rcv_transactions table.
INVOICE_DISTRIBUTION_ID NUMBER (15)
Invoice Distribution Identifier.
ORDER_FLAG VARCHAR2 (1)
Indicates whether the receipt is an Order Manual Invoice.
ORDER_NUMBER NUMBER

Order Number
TRX_TYPE_ID NUMBER

Transaction Type Identifier. This would be populated when Receipt Side ST form functionality is carried out.
TRX_NUMBER VARCHAR2 (40)
Transaction Number
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MIGRATED_HDR NUMBER (15)
Used during migration from old st form structure to new ST for structure. This refers to the FORM_ISSUE_ID/ FORM_RECEIPT_ID for the old migrated data.
MIGRATED_DTL NUMBER (15)
Used during migration from old st form structure to new ST for structure. This refers to the St_DThdr_id for the old migrated data.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
INVOICE_LINE_NUMBER NUMBER (15)
Invoice line number
Query Text

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


SELECT ST_HDR_ID
,      ST_DTL_ID
,      HEADER_ID
,      LINE_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      TAX_ID
,      TAX_LINE_NO
,      INVOICE_ID
,      ISSUE_RECEIPT_FLAG
,      TAX_TARGET_AMOUNT
,      MATCHED_AMOUNT
,      PO_NUM
,      DOC_TYPE
,      PO_LINE_LOCATION_ID
,      RCV_TRANSACTION_ID
,      INVOICE_DISTRIBUTION_ID
,      ORDER_FLAG
,      ORDER_NUMBER
,      TRX_TYPE_ID
,      TRX_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MIGRATED_HDR
,      MIGRATED_DTL
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
FROM JA.JAI_CMN_ST_FORM_DTLS;

Dependencies

[top of page]

JA.JAI_CMN_ST_FORM_DTLS does not reference any database object

JA.JAI_CMN_ST_FORM_DTLS is referenced by following:

SchemaAPPS
SynonymJAI_CMN_ST_FORM_DTLS