VRM_CONTRACT_INTERIM_GT
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_CONTRACT_INTERIM_GT_PK |
DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Source dcoument line identifier. | |
| DOCUMENT_ID | NUMBER | 18 | Source document 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 reference used to identify a customer contract. | ||
| 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 a 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. | ||
| L_BILL_TO_CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Party name of a bill-to customer on source document line. | ||
| H_BILL_TO_CUSTOMER_PARTY_ID | NUMBER | 18 | Unique identifier of a bill-to customer party. | ||
| H_BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a bill-to customer. | ||
| L_BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | 30 | Account number of a bill-to customer on source document line. | ||
| 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 item. 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 | Unique identifier of a purchase order. | ||
| L_ITEM_NUMBER | VARCHAR2 | 300 | Inventory item number. | ||
| L_MEMO_LINE_NAME | VARCHAR2 | 50 | Memo line name. | ||
| L_SALESREP_NAME | VARCHAR2 | 360 | 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. | ||
| 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 | Element is a deliverable or separate unit of accounting. Used to group element types for FMV sets. 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. | ||
| CONTRACT_RULE_NAME | VARCHAR2 | 100 | Customer contract identification rule name. | ||
| OBLIGATION_RULE_NAME | VARCHAR2 | 100 | Performance obligation identification rule name. | ||
| OBLIGATION_TEMPLATE_NAME | VARCHAR2 | 100 | Performance obligation identification template name. | ||
| 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 obligation reference. | ||
| L_QUANTITY | NUMBER | Quantity of inventory item or memo line on source document line. | |||
| L_LINE_AMOUNT | NUMBER | Extended line amount on source document line. | |||
| L_SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country code of ship-to customer on source document line. | ||
| L_BILL_TO_COUNTRY | VARCHAR2 | 60 | Country code of bill-to customer on source document line. | ||
| L_BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State code of bill-to customer on source document line. | ||
| L_BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of bill-to customer on source document line. | ||
| L_BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of bill-to customer on source document line. | ||
| L_BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | 60 | Postal code of bill-to customer on source document line. | ||
| L_BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | 60 | Customer classification of bill-to customer on source document line. Values are from the lookup CUSTOMER_CLASS. Value at source document line level takes precedence over value at source document level. | ||
| L_UOM_CODE | VARCHAR2 | 200 | Unit of measure of inventory item or memo line on source document line. | ||
| 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. | ||
| INITIAL_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the parent source document line for the current line. | ||
| TOP_PARENT_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the top most parent document line for the current line. | ||
| LINE_TYPE_CODE | VARCHAR2 | 30 | Source document line type for a project line. Possible values are ORIGINAL for initial baselined approved version, and REVISION for subsequent changes including changes to the revenue budget or for project status changed to closed. | ||
| NET_LINE_AMOUNT | NUMBER | Line amount after adjusting return amount. | |||
| PRICING_COMBINATION_ID | NUMBER | 18 | Identifier of the pricing dimension combination. | ||
| REVENUE_RULE_ID | NUMBER | 18 | Revenue scheduling rule identifier on source document line. Revenue scheduling rule determines the timing of revenue recognition. | ||
| SATISFACTION_MEASUREMENT_MODEL | VARCHAR2 | 30 | Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from the lookup type ORA_VRM_SATIS_MEAS_MODEL. | ||
| REVENUE_START_DATE | DATE | Revenue recoginition start date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| REVENUE_RULE_DURATION | NUMBER | Number of periods in which revenue of this performance obligation line is to be recognized. | |||
| REVENUE_END_DATE | DATE | Revenue recoginition end date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Ledger Currency code of customer contract. This value must match currency codes in Oracle Fusion General Ledger. | ||
| ADD_TO_CONTRACT_PROCESSED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line. | |||
| UNIT_LIST_PRICE | NUMBER | List price per unit of measure of the inventory item or memo line. | |||
| BASE_PRICE | NUMBER | Base price per unit of measure of the inventory item or memo line. | |||
| COST_AMOUNT | NUMBER | Cost of inventory item or memo line. This column is used to calculate gross margin percent. | |||
| MANUAL_REVIEW_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if contract review should be queued for manual review. Possible values are Y and N. | ||
| IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| CONTRACT_MODIFICATION_DATE | DATE | The date on which the revenue contract was modified. | |||
| TERMINATION_DATE | DATE | The date on which the revenue line was terminated. | |||
| NET_QUANTITY | NUMBER | Net quantity of a promised detail line. | |||
| RECUR_LINE_COPY_NUM | NUMBER | 18 | Sequence number of the recurring source document line. | ||
| CONTRACT_GROUP_NUMBER | VARCHAR2 | 320 | Concatenation of the original customer contract's source document number and customer contract number for the recurring line. | ||
| DOCUMENT_GROUP_ID | NUMBER | 18 | Source document group identifier used to group the initial recurring source document header and system-generated recurring source document headers. Value is the source document identifier for the original source document. | ||
| ORIGINAL_DOCUMENT_LINE_ID | NUMBER | 18 | Original source document line identifier used to create the recurring source document line. | ||
| REVENUE_RULE_TYPE | VARCHAR2 | 30 | Specifies the rule type for the satisfaction plan of the source document line. | ||
| RESIDUAL_APPROACH_FLAG | VARCHAR2 | 1 | Indicates the pricing for the goods or services is variable or missing and the standalone selling price for the resulting performance obligation is estimated using the residual approach. Valid values are from the lookup type VRM_YES/NO. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used for converting amounts from the entered currency to the ledger currency. | ||
| EXCHANGE_DATE | DATE | Conversion date used for converting amounts from the entered currency to the ledger currency. | |||
| EXCHANGE_RATE | NUMBER | Conversion rate used for converting amounts from the entered currency to the ledger currency. | |||
| LIST_PRICE_AMOUNT | NUMBER | List price amount of the item or memo line | |||
| PO_TEMPLATE_GROUPING_CODE | VARCHAR2 | 100 | Performance Obligation Template grouping code | ||
| SERVICE_UOM | VARCHAR2 | 200 | Unit of measure of the service item on the source document line. Valid values are from the Price Periodicity UOM Class defined in Oracle Fusion Pricing. | ||
| SERVICE_DURATION | NUMBER | Duration of the service item in terms of the service unit of measure. | |||
| H_REFERENCE_EXCHANGE_RATE_DATE | DATE | The source document reference currency conversion rate date. | |||
| L_REFERENCE_EXCHANGE_RATE_DATE | DATE | The source document line reference currency conversion rate date. | |||
| REFERENCE_CURRENCY_CODE | VARCHAR2 | 15 | Currency used as the reference currency to convert entered currency amounts to the reference currency. | ||
| REFERENCE_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert entered currency amounts to the reference currency. | ||
| REFERENCE_EXCHANGE_RATE_DATE | DATE | Date used to convert entered currency amounts to the reference currency. | |||
| REFERENCE_EXCHANGE_RATE | NUMBER | Rate used to convert entered currency amounts to the reference currency. | |||
| REFERENCE_CURR_DATE_TYPE_CODE | VARCHAR2 | 30 | Date type used to convert entered currency amounts to the reference currency, Valid values are from the lookup type ORA_REF_CONVERSION_RATE_DATE. | ||
| PERF_OBLIG_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of a performance obligation. Values are from the lookup type ORA_VRM_OBLIG_CLASSIF_CODE. | ||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| H_ORGANIZATION_ID | NUMBER | 30 | Business unit identifier of source document. | ||
| CUSTOMER_CREDIT_CLASSIFICATION | VARCHAR2 | 30 | Measure of customer credit worthiness,Valid values are from the lookup type AR_CMGT_CREDIT_CLASSIFICATION. | ||
| ASE_RULE_ID | NUMBER | 18 | Identifier of the additional satisfaction event rule. | ||
| H_SRC_ATTRIBUTE_DATE1 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE2 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE3 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE4 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE5 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE6 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE7 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE8 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE9 | DATE | Generic column to store a source document header attribute. | |||
| H_SRC_ATTRIBUTE_DATE10 | DATE | Generic column to store a source document header attribute. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CONTRACT_INTERIM_GT_N1 | Non Unique | LINE_TYPE_CODE, DOCUMENT_LINE_TYPE_CODE, CONTRACT_HASH_CODE, CONTRACT_RULE_ID |
| VRM_CONTRACT_INTERIM_GT_N2 | Non Unique | OBLIGATION_TYPE, OBLIG_RULE_ID |
| VRM_CONTRACT_INTERIM_GT_N3 | Non Unique | OBLIG_HASH_CODE, H_CURRENCY_CODE, OBLIG_RULE_ID, CONTRACT_HASH_CODE |
| VRM_CONTRACT_INTERIM_GT_N4 | Non Unique | CONTRACT_HASH_CODE, PERF_OBLIGATION_TEMPLATE_ID, NVL("PRICING_COMBINATION_ID",(-99)) |
| VRM_CONTRACT_INTERIM_GT_U1 | Unique | DOCUMENT_LINE_ID |