PJC_CROSS_CHARGE_TXN_GT
PJC_CROSS_CHARGE_TXN_GT is a global temporary table which is use for process the cross charge transaction in the identify cross charge transaction process
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJC_CROSS_CHARGE_TXN_GT_PK |
CROSS_CHARGE_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CROSS_CHARGE_TXN_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the cross charge transaction | |
| LE_BU_ORGZ_SAME | VARCHAR2 | 1 | Flag to identify the Provider and receiver Legal Entity, Business Unit and Oraganizations are same | ||
| SEGMENT_CODE | VARCHAR2 | 30 | Balance Segment Code | ||
| DEFAULT_PRVDR_LE_ID | NUMBER | 18 | Provider Legal entity for the expenditure oprating unit | ||
| CC_PROCESS_IO_CODE | VARCHAR2 | 1 | Indicates whether perform cross charge processing for intra-operating unit transactions, which are within the same operating unit but not the same provider and receiver organization. | ||
| CC_PROCESS_IU_CODE | VARCHAR2 | 1 | Indicates if the operating unit may incur inter operating cross charge with in legal entity | ||
| BU_REL_FLAG | VARCHAR2 | 1 | Provider and Receiver BU relationships overrride flag | ||
| SEGMENT_VALUE | VARCHAR2 | 25 | Balance Segment Value | ||
| IC_FLAG | VARCHAR2 | 1 | This flag indicates that whether intercompany setup is exists if the value is Y | ||
| DISTRIBUTION_ID1 | NUMBER | 18 | Source distribution identifier for the product | ||
| DISTRIBUTION_ID2 | NUMBER | 18 | Line number for Source distribution identifier | ||
| DISTRIBUTION_TYPE | VARCHAR2 | 30 | Line type for the distribution | ||
| APPLICATION_ID | NUMBER | 18 | Identifier of the functional area within a software suite of products | ||
| LEDGER_ID | NUMBER | 18 | Identifier of a self-contained accounting information set for single or multiple legal entities. | ||
| ACCOUNT_TYPE | VARCHAR2 | 30 | Type of the account | ||
| CC_PROCESS_FLAG | VARCHAR2 | 1 | Cross charge process flag for task or project | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| HISTORICAL_FLAG | VARCHAR2 | 1 | Historical Flag | ||
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Yes | The identifier of the expenditure item | |
| LINE_NUM | NUMBER | 18 | Yes | The sequential number that identifies the cost distribution line for an expenditure item | |
| EXPENDITURE_ITEM_DATE | DATE | Yes | The date on which the work occurred | ||
| PROJECT_ID | NUMBER | 18 | Yes | The identifier of the project | |
| TASK_ID | NUMBER | 18 | Yes | The identifier of the tasks to which the expenditure item is charged | |
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 3 | Yes | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type. | |
| CARRYING_OUT_ORGANZ_ID | NUMBER | 18 | Identifier of the receiver organization | ||
| CC_PRVDR_ORGANIZATION_ID | NUMBER | 18 | Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overriden by the client extension to derive provider organization | ||
| CC_RECVR_ORGANIZATION_ID | NUMBER | 18 | Identifier of the receiver organization. This may be different than the project organization, if it is overriden by the client extension to derive receiver organization | ||
| INCURRED_BY_PERSON_ID | NUMBER | 18 | Incurred by person id | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| EXPENDITURE_ORGANZ_ID | NUMBER | 18 | Expenditure organization for expenditure item | ||
| RECEIVER_ORG_ID | NUMBER | 18 | Identifier of the receiver business unit | ||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Identifier of the transaction source | ||
| CC_RECVR_ORG_ID | NUMBER | 18 | Identifier of the Receiver operating unit | ||
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. | ||
| PRVDR_LEGAL_ENTITY_ID | NUMBER | 18 | Identifier of the Provider Legal Entity | ||
| RECVR_LEGAL_ENTITY_ID | NUMBER | 18 | Identifier of the Receiver Legal Entity | ||
| CC_CROSS_CHARGE_CODE | VARCHAR2 | 1 | Indicates the method of cross charge processing that will be or has been performed on an Expenditure Item | ||
| CC_CROSS_CHARGE_TYPE | VARCHAR2 | 2 | Cross charge type of the expenditure item | ||
| CC_BL_DISTRIBUTED_CODE | VARCHAR2 | 1 | Indicates the processing status of the expenditure item by the distribute borrwed and lent account process | ||
| CC_REJECTION_CODE | VARCHAR2 | 30 | Code indicating rejection reason encountered while processing cross charge | ||
| IC_REVENUE_RECOGNIZED_FLAG | VARCHAR2 | 1 | Revenue recognized flag for inter company | ||
| IC_BILLABLE_FLAG | VARCHAR2 | 1 | Billable flag for inter company | ||
| IC_INVOICED_FLAG | VARCHAR2 | 1 | Invoiced flag for inter company | ||
| DOCUMENT_ID | NUMBER | 18 | Projects-related categorization of the document type that is creating this transaction | ||
| DOC_ENTRY_ID | NUMBER | 18 | Projects-related sub categorization of the document type that is creating this transaction | ||
| ACCT_EVENT_ID | NUMBER | 18 | Identifier of Accounting Event | ||
| LINE_TYPE | VARCHAR2 | 1 | The type of the cost distribution line | ||
| ACCOUNTING_STATUS_CODE | VARCHAR2 | 5 | The status of the distribution line as the cost information is transferred to another application | ||
| RAW_COST_DR_CCID | NUMBER | 18 | Identifier of Raw cost debit account code combination | ||
| ACCT_SOURCE_CODE | VARCHAR2 | 10 | Code used to identify accounting transactions, which are not migrated to SLA | ||
| ADJUSTED_EXP_ITEM_ID | NUMBER | 18 | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item,or are system created to reverse a transferred item. | ||
| LINE_NUM_REVERSED | NUMBER | 18 | The distribution line number that is reversed by this distribution line | ||
| RAW_LINE_NUM_REVERSED | NUMBER | 18 | Reversed line number for raw cost | ||
| PARENT_LINE_NUM | NUMBER | 18 | Line number for the raw cost distribution line. Valid for I line types only | ||
| ORIGINAL_HEADER_ID | NUMBER | 18 | identifier of the original header | ||
| ORIGINAL_LINE_NUMBER | NUMBER | 18 | identifier of the original line number | ||
| ORIGINAL_DIST_ID | NUMBER | 18 | Identifier of the original distribution | ||
| PARENT_LINE_NUMBER | NUMBER | 18 | parent Line Number | ||
| ACCOUNT_CCID | NUMBER | 18 | Identifier of account code combination. | ||
| PARENT_HEADER_ID | NUMBER | 18 | Identifier of the Parent Header | ||
| PARENT_DIST_ID | NUMBER | 18 | Identifier of the parent distribution | ||
| PROJFUNC_RAW_COST | NUMBER | Raw cost in project functional currency | |||
| SL_LABOR_NL_FLAG | VARCHAR2 | 1 | Flag to identify if system linkage is labor related | ||
| PRJ_CC_PROCESS_LABOR_FLAG | VARCHAR2 | 1 | Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. | ||
| PRJ_CC_PROCESS_NL_FLAG | VARCHAR2 | 1 | Flag that indicates cross charge processing is to be performed for non labor transactions charged to the project. | ||
| TASK_CC_PROCESS_LABOR_FLAG | VARCHAR2 | 20 | Flag that indicates cross charge processing is to be performed for labor transactions charged to the task. | ||
| TASK_CC_PROCESS_NL_FLAG | VARCHAR2 | 1 | Flag that indicates cross charge processing is to be performed for non labor transactions charged to the task. | ||
| DOC_CC_PROCESS_FLAG | VARCHAR2 | 1 | Indicates that transactions from this document entry are eligible for cross-charge processing | ||
| TP_SCHEDULE_ID | NUMBER | 18 | Identifier of the transfer price schedule | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PJC_CROSS_CHARGE_TXN_GT_N1 | Non Unique | EXPENDITURE_ITEM_ID, LINE_NUM |
| PJC_CROSS_CHARGE_TXN_GT_N2 | Non Unique | DISTRIBUTION_ID1, DISTRIBUTION_ID2, DISTRIBUTION_TYPE, APPLICATION_ID |
| PJC_CROSS_CHARGE_TXN_GT_N3 | Non Unique | ACCOUNT_CCID |
| PJC_CROSS_CHARGE_TXN_GT_N4 | Non Unique | EXPENDITURE_ITEM_ID, OBJECT_VERSION_NUMBER |
| PJC_CROSS_CHARGE_TXN_GT_U1 | Unique | CROSS_CHARGE_TXN_ID |