[Home] [Help] [Dependency Information]
Object Name: | ZX_REP_ACTG_EXT_T# |
---|---|
Object Type: | VIEW |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTG_EXT_LINE_ID | NUMBER | (15) | Yes | |
DETAIL_TAX_LINE_ID | NUMBER | (15) | ||
ACTG_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
ACTG_EVENT_TYPE_MNG | VARCHAR2 | (240) | ||
ACTG_EVENT_NUMBER | NUMBER | |||
ACTG_EVENT_STATUS_FLAG | VARCHAR2 | (1) | ||
ACTG_EVENT_STATUS_MNG | VARCHAR2 | (240) | ||
ACTG_CATEGORY_CODE | VARCHAR2 | (30) | ||
ACTG_CATEGORY_MNG | VARCHAR2 | (240) | ||
ACCOUNTING_DATE | DATE | |||
GL_TRANSFER_FLAG | VARCHAR2 | (1) | ||
GL_TRANSFER_RUN_ID | NUMBER | (15) | ||
ACTG_HEADER_DESCRIPTION | VARCHAR2 | (1996) | ||
ACTG_LINE_NUM | NUMBER | (15) | ||
ACTG_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
ACTG_LINE_TYPE_MNG | VARCHAR2 | (240) | ||
ACTG_LINE_DESCRIPTION | VARCHAR2 | (1996) | ||
ACTG_STAT_AMT | NUMBER | |||
ACTG_ERROR_CODE | VARCHAR2 | (30) | ||
GL_TRANSFER_CODE | VARCHAR2 | (30) | ||
ACTG_DOC_SEQUENCE_ID | NUMBER | (15) | ||
ACTG_DOC_SEQUENCE_NAME | VARCHAR2 | (150) | ||
ACTG_DOC_SEQUENCE_VALUE | VARCHAR2 | (240) | ||
ACTG_PARTY_ID | NUMBER | (15) | ||
ACTG_PARTY_SITE_ID | NUMBER | (15) | ||
ACTG_PARTY_TYPE | VARCHAR2 | (30) | ||
ACTG_EVENT_ID | NUMBER | (15) | ||
ACTG_HEADER_ID | NUMBER | (15) | ||
ACTG_SOURCE_ID | NUMBER | (15) | ||
ACTG_SOURCE_TABLE | VARCHAR2 | (30) | ||
ACTG_LINE_CCID | NUMBER | (15) | ||
ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | ||
ACCOUNT_DESCRIPTION | VARCHAR2 | (1996) | ||
PERIOD_NAME | VARCHAR2 | (30) | ||
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
TRX_ARAP_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
TRX_ARAP_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
TRX_TAXABLE_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
TRX_TAXABLE_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
TRX_TAX_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
TRX_TAX_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
TRX_CONTROL_ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
TRX_TAXABLE_ACCOUNT | VARCHAR2 | (240) | ||
TRX_TAXABLE_ACCOUNT_DESC | VARCHAR2 | (1996) | ||
TRX_TAXABLE_BALSEG_DESC | VARCHAR2 | (240) | ||
TRX_TAXABLE_NATACCT_SEG_DESC | VARCHAR2 | (240) |
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#;
|
|
|