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

TABLE: ZX.ZX_REP_ACTG_EXT_T

Object Details
Object Name: ZX_REP_ACTG_EXT_T
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_REP_ACTG_EXT_T
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_REP_ACTG_EXT_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTG_EXT_LINE_ID
ZX_REP_ACTG_EXT_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_TAX_LINE_ID
Columns
Name Datatype Length Mandatory Comments
ACTG_EXT_LINE_ID NUMBER (15) Yes Unique identifier
DETAIL_TAX_LINE_ID NUMBER (15)
Detail tax line identifier
ACTG_EVENT_TYPE_CODE VARCHAR2 (30)
Accounting event type code
ACTG_EVENT_TYPE_MNG VARCHAR2 (240)
Accounting event type meaning
ACTG_EVENT_NUMBER NUMBER

Accounting event number
ACTG_EVENT_STATUS_FLAG VARCHAR2 (1)
Lookup code to indicate accounting event status
ACTG_EVENT_STATUS_MNG VARCHAR2 (240)
Accounting event status meaning
ACTG_CATEGORY_CODE VARCHAR2 (30)
Accounting category code
ACTG_CATEGORY_MNG VARCHAR2 (240)
Accounting category meaning
ACCOUNTING_DATE DATE

Accounting date
GL_TRANSFER_FLAG VARCHAR2 (1)
Y or N to indicate whether the accounting for the tax line is transferred to Genral Ledger
GL_TRANSFER_RUN_ID NUMBER (15)
Request identifier of concurrent program that has transferred the accounting information for the tax line to General Ledger
ACTG_HEADER_DESCRIPTION VARCHAR2 (1996)
Accounting header description
ACTG_LINE_NUM NUMBER (15)
Accounting line number
ACTG_LINE_TYPE_CODE VARCHAR2 (30)
Accounting journal line type code
ACTG_LINE_TYPE_MNG VARCHAR2 (240)
Accounting journal line type meaning
ACTG_LINE_DESCRIPTION VARCHAR2 (1996)
Accounting journal line type description
ACTG_STAT_AMT NUMBER

Statistical amount
ACTG_ERROR_CODE VARCHAR2 (30)
Accounting error code
GL_TRANSFER_CODE VARCHAR2 (30)
Genral Ledger transfer code for the tax line
ACTG_DOC_SEQUENCE_ID NUMBER (15)
Accounting document sequence identifier
ACTG_DOC_SEQUENCE_NAME VARCHAR2 (150)
Accounting document sequence name
ACTG_DOC_SEQUENCE_VALUE VARCHAR2 (240)
Accounting document sequence value
ACTG_PARTY_ID NUMBER (15)
Party identifier
ACTG_PARTY_SITE_ID NUMBER (15)
Party site identifier
ACTG_PARTY_TYPE VARCHAR2 (30)
Party type
ACTG_EVENT_ID NUMBER (15)
Accounting event identifier
ACTG_HEADER_ID NUMBER (15)
Accounting journal header identifier
ACTG_SOURCE_ID NUMBER (15)
Transaction source identifier
ACTG_SOURCE_TABLE VARCHAR2 (30)
Transaction source table
ACTG_LINE_CCID NUMBER (15)
Account identifier on the accounting line
ACCOUNT_FLEXFIELD VARCHAR2 (2000)
Account flexfield
ACCOUNT_DESCRIPTION VARCHAR2 (1996)
Account description
PERIOD_NAME VARCHAR2 (30)
Accounting period name
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
Balancing segment value
TRX_ARAP_BALANCING_SEGMENT VARCHAR2 (240)
Balancing segment value
TRX_ARAP_NATURAL_ACCOUNT VARCHAR2 (240)
Natural account segment value
TRX_TAXABLE_BALANCING_SEGMENT VARCHAR2 (240)
Balancing segment value for taxable amount
TRX_TAXABLE_NATURAL_ACCOUNT VARCHAR2 (240)
Natural account segment value for taxable amount
TRX_TAX_BALANCING_SEGMENT VARCHAR2 (240)
Balancing segment value for tax amount
TRX_TAX_NATURAL_ACCOUNT VARCHAR2 (240)
Natural account segment value for tax amount
TRX_CONTROL_ACCOUNT_FLEXFIELD VARCHAR2 (2000)
Control account
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
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID NUMBER

Login user identifier of last concurrent program to update this record
TRX_TAXABLE_ACCOUNT VARCHAR2 (240)
Taxable account
TRX_TAXABLE_ACCOUNT_DESC VARCHAR2 (1996)
Taxable account description
TRX_TAXABLE_BALSEG_DESC VARCHAR2 (240)
Taxable account balancing segment descripton
TRX_TAXABLE_NATACCT_SEG_DESC VARCHAR2 (240)
Taxable account natural account segment descripton
Query Text

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


SELECT ACTG_EXT_LINE_ID
,      DETAIL_TAX_LINE_ID
,      ACTG_EVENT_TYPE_CODE
,      ACTG_EVENT_TYPE_MNG
,      ACTG_EVENT_NUMBER
,      ACTG_EVENT_STATUS_FLAG
,      ACTG_EVENT_STATUS_MNG
,      ACTG_CATEGORY_CODE
,      ACTG_CATEGORY_MNG
,      ACCOUNTING_DATE
,      GL_TRANSFER_FLAG
,      GL_TRANSFER_RUN_ID
,      ACTG_HEADER_DESCRIPTION
,      ACTG_LINE_NUM
,      ACTG_LINE_TYPE_CODE
,      ACTG_LINE_TYPE_MNG
,      ACTG_LINE_DESCRIPTION
,      ACTG_STAT_AMT
,      ACTG_ERROR_CODE
,      GL_TRANSFER_CODE
,      ACTG_DOC_SEQUENCE_ID
,      ACTG_DOC_SEQUENCE_NAME
,      ACTG_DOC_SEQUENCE_VALUE
,      ACTG_PARTY_ID
,      ACTG_PARTY_SITE_ID
,      ACTG_PARTY_TYPE
,      ACTG_EVENT_ID
,      ACTG_HEADER_ID
,      ACTG_SOURCE_ID
,      ACTG_SOURCE_TABLE
,      ACTG_LINE_CCID
,      ACCOUNT_FLEXFIELD
,      ACCOUNT_DESCRIPTION
,      PERIOD_NAME
,      BALANCING_SEGMENT_VALUE
,      TRX_ARAP_BALANCING_SEGMENT
,      TRX_ARAP_NATURAL_ACCOUNT
,      TRX_TAXABLE_BALANCING_SEGMENT
,      TRX_TAXABLE_NATURAL_ACCOUNT
,      TRX_TAX_BALANCING_SEGMENT
,      TRX_TAX_NATURAL_ACCOUNT
,      TRX_CONTROL_ACCOUNT_FLEXFIELD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      TRX_TAXABLE_ACCOUNT
,      TRX_TAXABLE_ACCOUNT_DESC
,      TRX_TAXABLE_BALSEG_DESC
,      TRX_TAXABLE_NATACCT_SEG_DESC
FROM ZX.ZX_REP_ACTG_EXT_T;

Dependencies

[top of page]

ZX.ZX_REP_ACTG_EXT_T does not reference any database object

ZX.ZX_REP_ACTG_EXT_T is referenced by following:

SchemaAPPS
SynonymZX_REP_ACTG_EXT_T