ZX_REP_ACTG_EXT_T
Interface table which is an extension of ZX_REP_TRX_DETAIL_T storing accounting information tied to each product transaction table.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_REP_ACTG_EXT_T_PK |
ACTG_EXT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACTG_EXT_LINE_ID | NUMBER | 18 | Yes | Unique identifier | |
| DETAIL_TAX_LINE_ID | NUMBER | 18 | 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 | Yes or No to indicate whether the accounting for the tax line is transferred to General Ledger. | ||
| GL_TRANSFER_RUN_ID | NUMBER | 18 | 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 | 18 | 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 | General Ledger transfer code for the tax line | ||
| ACTG_DOC_SEQUENCE_ID | NUMBER | 18 | 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 | 18 | Party identifier | ||
| ACTG_PARTY_SITE_ID | NUMBER | 18 | Party site identifier | ||
| ACTG_PARTY_TYPE | VARCHAR2 | 30 | Party type | ||
| ACTG_EVENT_ID | NUMBER | 18 | Accounting event identifier | ||
| ACTG_HEADER_ID | NUMBER | 18 | Accounting journal header identifier | ||
| ACTG_SOURCE_ID | NUMBER | 18 | Transaction source identifier | ||
| ACTG_SOURCE_TABLE | VARCHAR2 | 30 | Transaction source table | ||
| ACTG_LINE_CCID | NUMBER | 18 | Account identifier on the accounting line | ||
| ACTG_TAX_LINE_CCID | NUMBER | 18 | 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 | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APP_NAME | VARCHAR2 | 240 | Application identifier of last concurrent program to update this record | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program identifier of last concurrent program to update this record | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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 description | ||
| TRX_TAXABLE_NATACCT_SEG_DESC | VARCHAR2 | 240 | Taxable account natural account segment description |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_REP_ACTG_EXT_T_N1 | Non Unique | Default | DETAIL_TAX_LINE_ID |
| ZX_REP_ACTG_EXT_T_U1 | Unique | Default | ACTG_EXT_LINE_ID |