VRM_IDENTIFY_CONTRACT_INTERIM
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_IDENTIFY_CONTRACT_INT_PK |
DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Source document line unique identifier. | |
| DOCUMENT_ID | NUMBER | 18 | Source document unique identifier. | ||
| CONTRACT_RULE_ID | NUMBER | 18 | Customer contract identification rule identifier. | ||
| OBLIG_RULE_ID | NUMBER | 18 | Customer contract obligation rule identifier. | ||
| REFERENCE | VARCHAR2 | 1000 | User entered contract reference or grouping attribute values used to identify the contract as derived by enabling the Copy to Reference option in the Contract Identification rule. | ||
| CONTRACT_HASH_CODE | VARCHAR2 | 100 | Oracle internal use only. | ||
| OBLIG_HASH_CODE | VARCHAR2 | 100 | Oracle internal use only. | ||
| PERF_OBLIGATION_TEMPLATE_ID | NUMBER | 18 | Performance obligation template identifier. | ||
| OBLIGATION_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| CONTRACT_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| DOC_LINE_CLASSIFICATION | VARCHAR2 | 1 | Oracle internal use only. | ||
| WORKER_NUMBER | NUMBER | 3 | Oracle internal use only. | ||
| BATCH_NUMBER | NUMBER | 18 | Identifies the batch to be processed. | ||
| H_DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type. | ||
| H_DOCUMENT_DATE | DATE | Date of the source document. | |||
| H_DOCUMENT_NUMBER | VARCHAR2 | 300 | Document number of a source document. | ||
| H_DOC_ID_INT_1 | NUMBER | Source document unique identifier. | |||
| H_DOC_ID_INT_2 | NUMBER | Source document unique identifier. | |||
| H_DOC_ID_INT_3 | NUMBER | Source document unique identifier. | |||
| H_DOC_ID_INT_4 | NUMBER | Source document unique identifier. | |||
| H_DOC_ID_INT_5 | NUMBER | Source document unique identifier. | |||
| H_DOC_ID_CHAR_1 | VARCHAR2 | 30 | Source document unique identifier. | ||
| H_DOC_ID_CHAR_2 | VARCHAR2 | 30 | Source document unique identifier. | ||
| H_DOC_ID_CHAR_3 | VARCHAR2 | 30 | Source document unique identifier. | ||
| H_DOC_ID_CHAR_4 | VARCHAR2 | 30 | Source document unique identifier. | ||
| H_DOC_ID_CHAR_5 | VARCHAR2 | 30 | Source document unique identifier. | ||
| H_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the source document. | ||
| H_CONTRACT_NUMBER | NUMBER | 18 | Customer contract number. | ||
| H_SALESREP_NAME | VARCHAR2 | 360 | Salesperson name on the source document. | ||
| H_SALESREP_ID | NUMBER | 18 | Unique identifier of a salesperson. | ||
| H_BILL_TO_CUSTOMER_PARTY_NUM | VARCHAR2 | 30 | Party name of a bill-to customer. | ||
| H_BILL_TO_CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Party name of a bill-to customer. | ||
| H_BILL_TO_CUSTOMER_PARTY_ID | NUMBER | 18 | A unique identifier of a bill-to customer party. | ||
| H_BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a bill-to customer. | ||
| H_BILL_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Bill-to customer name. | ||
| H_BILL_TO_CUSTOMER_ID | NUMBER | 18 | Unique identifier of a bill-to customer. | ||
| H_BILL_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of a bill-to customer. | ||
| H_BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | Customer state of a bill-to customer address. | ||
| H_BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of a bill-to customer address. | ||
| H_BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of a bill-to customer address. | ||
| H_BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | 60 | Postal code of a bill-to customer address. | ||
| H_BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | 60 | Customer classification of a bill-to customer. | ||
| H_BILL_TO_COUNTRY | VARCHAR2 | 60 | Country of a bill-to customer address. | ||
| H_SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country of a ship-to customer address. | ||
| H_ORGANIZATION_NAME | VARCHAR2 | 240 | Name of the associated business unit. | ||
| H_LEDGER_NAME | VARCHAR2 | 30 | Name of a ledger. | ||
| H_LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier of a legal entity. | ||
| H_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of a legal entity. | ||
| H_CUST_PO_NUMBER | VARCHAR2 | 50 | Unique identifier of a purchase order. | ||
| H_CUSTOMER_CONTRACT_NUMBER | NUMBER | 18 | Unique identifier of a contract. | ||
| H_SALES_AGREEMENT_NUMBER | VARCHAR2 | 120 | Unique number of a sales agreement document. | ||
| H_QUOTE_NUMBER | VARCHAR2 | 120 | Unique identifier number of a quote. | ||
| H_LEDGER_ID | NUMBER | 18 | Unique identifier of a ledger. | ||
| H_SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Generic column to store a source document header attribute. | ||
| H_SRC_ATTRIBUTE_NUMBER1 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER2 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER3 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER4 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER5 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER6 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER7 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER8 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER9 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER10 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER11 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER12 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER13 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER14 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER15 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER16 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER17 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER18 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER19 | NUMBER | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_NUMBER20 | NUMBER | Generic column to store a source document header attribute. | |||
| ITEM_TYPE | VARCHAR2 | 30 | Indicates the type of a source document items. Valid values are from the lookup type VRM_ITEM_TYPE. | ||
| ITEM_TYPE_ID | NUMBER | 18 | Item type unique identifier. | ||
| L_DOC_LINE_ID_INT_1 | NUMBER | Source document line unique identifier. | |||
| L_DOC_LINE_ID_INT_2 | NUMBER | Source document line unique identifier. | |||
| L_DOC_LINE_ID_INT_3 | NUMBER | Source document line unique identifier. | |||
| L_DOC_LINE_ID_INT_4 | NUMBER | Source document line unique identifier. | |||
| L_DOC_LINE_ID_INT_5 | NUMBER | Source document line unique identifier. | |||
| L_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 150 | Source document line unique identifier. | ||
| L_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 150 | Source document line unique identifier. | ||
| L_DOC_LINE_ID_CHAR_3 | VARCHAR2 | 150 | Source document line unique identifier. | ||
| L_DOC_LINE_ID_CHAR_4 | VARCHAR2 | 150 | Source document line unique identifier. | ||
| L_DOC_LINE_ID_CHAR_5 | VARCHAR2 | 150 | Source document line unique identifier. | ||
| L_CUST_PO_NUMBER | VARCHAR2 | 50 | A unique identifier of a purchase order. | ||
| L_ITEM_NUMBER | VARCHAR2 | 300 | Contract line inventory item number. | ||
| L_MEMO_LINE_NAME | VARCHAR2 | 50 | Contract line memo line name. | ||
| L_SALESREP_NAME | VARCHAR2 | 360 | Line level salesperson name. | ||
| L_SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Generic column to store a source document line attribute. | ||
| L_SRC_ATTRIBUTE_NUMBER1 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER2 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER3 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER4 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER5 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER6 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER7 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER8 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER9 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER10 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER11 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER12 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER13 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER14 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER15 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER16 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER17 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER18 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER19 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_NUMBER20 | NUMBER | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE1 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE2 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE3 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE4 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE5 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE6 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE7 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE8 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE9 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_DATE10 | DATE | Generic column to store a source document line attribute. | |||
| L_SRC_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Generic column to store a source document line attribute. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | ||
| OLD_OBLIG_NUMBER | NUMBER | 18 | Old obligation number. | ||
| NEW_OBLIG_NUMBER | NUMBER | 18 | New obligation number. | ||
| H_DOCUMENT_ID | NUMBER | 18 | Source document. | ||
| L_DOCUMENT_LINE_ID | NUMBER | 18 | Source document line. | ||
| L_ELEMENT_TYPE | VARCHAR2 | 30 | The element type used to identify the nature of item. Values are from the lookup VRM_ELEMENT_TYPE. | ||
| CONTRACT_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of a contract. Values are derived from the lookup type ORA_VRM_CONTRACT_CLASSIF_CODE. | ||
| PRICING_COMBINATION_ID | NUMBER | 18 | Pricing dimension combination identifier. | ||
| L_QUANTITY | NUMBER | Quantity of inventory items or memo lines on a source document line. | |||
| L_LINE_AMOUNT | NUMBER | Extended line amount on a source document line. | |||
| L_SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country code of ship-to customer on a source document line. | ||
| L_BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State code of bill-to customer on a source document. | ||
| L_BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of bill-to customer on a source document. | ||
| L_BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of bill-to customer on a source document. | ||
| L_BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | 60 | Postal code of bill-to customer on a source document. | ||
| L_BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | 60 | Customer classification of bill-to customer on a source document. Values are from the lookup CUSTOMER_CLASS. | ||
| L_BILL_TO_COUNTRY | VARCHAR2 | 60 | Country code of bill-to customer on a source document. | ||
| L_UOM_CODE | VARCHAR2 | 3 | Unit of measure of inventory item or memo line on a source document line. | ||
| DOCUMENT_TYPE_NAME | VARCHAR2 | 60 | Name of the source document type. The name should be the same as the document type that is called in the source application | ||
| OBLIGATION_REFERENCE | VARCHAR2 | 1000 | User entered performance obligation reference or grouping attribute values used to identify the performance obligation as derived by enabling the Copy to Reference option in the Performance Obligation Identification rule. | ||
| INITIAL_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the parent source document line for the current line. | ||
| CONTRACT_UPDATE_TEMPLATE_ID | NUMBER | 18 | Revenue contract update template identifier. | ||
| DOCUMENT_LINE_TYPE_CODE | VARCHAR2 | 30 | Specifies the type of line sent from the source system. Values are derived from the lookup type ORA_VRM_DOCUMENT_LINE_TYPE. Blank is equivalent to ORA_NEW_LINE. | ||
| ADD_TO_CONTRACT_ACTION_CODE | VARCHAR2 | 30 | Specifies how a new line from the source system should be processed. Values are derived from the lookup type ORA_ADD_TO_CONTRACT_ACTION. Blank is equivalent to ORA_ADD_TO_EXISTING_PO. | ||
| TOP_PARENT_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the top most parent source document line for the current line. | ||
| ADD_TO_CONTRACT_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates whether the line of type ORA_ADD_TO_CONTRACT_NEW_LINE was processed. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_IDENTIFY_CONTRACT_INT_U1 | Unique | Default | DOCUMENT_LINE_ID |
| VRM_IDENTIFY_CONTR_INT_N1 | Non Unique | Default | REQUEST_ID, BATCH_NUMBER |
| VRM_IDENTIFY_CONTR_INT_N2 | Non Unique | Default | OBLIGATION_TYPE, OBLIG_RULE_ID |
| VRM_IDENTIFY_CONTR_INT_N3 | Non Unique | Default | CONTRACT_TYPE, CONTRACT_RULE_ID |
| VRM_IDENTIFY_CONTR_INT_N4 | Non Unique | Default | CONTRACT_HASH_CODE |
| VRM_IDENTIFY_CONTR_INT_N5 | Non Unique | Default | OBLIG_HASH_CODE, H_CURRENCY_CODE, OBLIG_RULE_ID, CONTRACT_HASH_CODE |