CMR_RCV_ACCT_LINE_TYPES
this table will store the receipt accounting line types for all events
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CMR_RCV_ACCT_LINE_TYPES_PK |
ACCOUNTING_LINE_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_LINE_TYPE_ID | NUMBER | 18 | Yes | acct lint type identifier - primary key | |
| TRANSACTION_TYPE | VARCHAR2 | 40 | Yes | Single column FK: Identifies the Receiving event types associated with the transaction. | |
| ACCOUNTING_LINE_TYPE | VARCHAR2 | 40 | Yes | accounting line type - indicates type journal line type | |
| DEBIT_FLAG | VARCHAR2 | 1 | Yes | debit flag indicator-Y means debit N means credit | |
| PROCURE_BU_FLAG | VARCHAR2 | 1 | Supplier facing node business unit flag - Y means supplier node business unit N means not a non-supplier node business unit | ||
| MULTI_BU_FLAG | VARCHAR2 | 1 | multi business unit flag - Y means this PO belongs to Global procurement, N means single business unit PO | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Self Assessed Flag - Y indicates it is self assessed | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | identifies the destination type for material - INVENTORY or EXPENSE | ||
| INVOICE_LINE_TYPE | VARCHAR2 | 25 | identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc | ||
| SERVICE_LINE_TYPE_PO_FLAG | VARCHAR2 | 1 | this column value used for service line po/onetime item. Y means - service line/onetime item po we need to book IC COGS account | ||
| EVENT_COST_SOURCE | VARCHAR2 | 30 | Stores the event cost source like Purchase order, Taxes, invoice variances and maps to look up - ORA_CMR_EVENT_COST_SOURCES. | ||
| EVENT_COST_SOURCE_TYPE | VARCHAR2 | 50 | Stores event source types based on event cost source values. | ||
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Flag for intercompany invoice flag. | ||
| TAX_LIABILITY_FLAG | VARCHAR2 | 1 | Tax liability accounting line type on transaction tax line. Y means Tax Liability accounting line type and NULL or N means ACCRUAL | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Consigned flag indicator of accounted transactions. | ||
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_RCV_ACCT_LINE_TYPES_PK | Unique | FUSION_TS_TX_DATA | ACCOUNTING_LINE_TYPE_ID, ORA_SEED_SET1 |
| CMR_RCV_ACCT_LINE_TYPES_PK1 | Unique | FUSION_TS_TX_DATA | ACCOUNTING_LINE_TYPE_ID, ORA_SEED_SET2 |