VRM_SOURCE_DOCUMENTS
This object stores the documents from the upstream applications. The document lines are used for VSOE price calculation and also for creating multiple element arrangements in the Revenue Management application
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_SOURCE_DOCUMENTS_PK |
DOCUMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_ID | NUMBER | 18 | Yes | Source document identifier for a sales order, invoice, project or service contract. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Oracle Application identifier of source document. Foreign key to FND applications table. For example, 222 for Receivables invoices, or users can optionally use -1. | |
| DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type identifier of various source systems which integrate with revenue management. | ||
| DOC_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_2 | NUMBER | Second numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_3 | NUMBER | Third numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies source document in source application. | |||
| DOC_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_3 | VARCHAR2 | 30 | Third character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies source document in source application. | ||
| DOCUMENT_DATE | DATE | Yes | Date of source document, such as book date for sales order, or invoice date for invoice. | ||
| DOCUMENT_NUMBER | VARCHAR2 | 300 | Yes | Source document number. For example, a sales order number or receivables invoice number. | |
| DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | Document type of the source document. | |
| DOCUMENT_CREATION_DATE | TIMESTAMP | Yes | Date and time of the creation of source document. | ||
| DOCUMENT_UPDATE_DATE | TIMESTAMP | Yes | Date and time of the last update of source document. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of source document. This value must match currency codes in Oracle Fusion General Ledger. | ||
| SALESREP_ID | NUMBER | 18 | Oracle internal use only. | ||
| SALESREP_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| BILL_TO_CUSTOMER_PARTY_ID | NUMBER | 18 | Party identifier of bill-to customer on source document. | ||
| BILL_TO_CUSTOMER_PARTY_NUM | VARCHAR2 | 30 | Party number of bill-to customer. | ||
| BILL_TO_CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Party name of bill-to customer on source document. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Account identifier of bill-to customer on source document. | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Account identifier of ship-to customer on source document. | ||
| BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of bill-to customer on source document. | ||
| SHIP_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of ship-to customer on source document. | ||
| BILL_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Name of the Bill To Customer associated with source document. | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Name of ship-to customer on source document. | ||
| BILL_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Site identifier of bill-to customer on source document. | ||
| BILL_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of bill-to customer on source document. | ||
| SHIP_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Site identifier of ship-to customer on source document. | ||
| SHIP_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of ship-to customer on source document. | ||
| BILL_TO_COUNTRY | VARCHAR2 | 60 | Country code of bill-to customer on source document. | ||
| SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country code of ship-to customer on source document. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Business unit name on source document. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Ledger name of source document. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier on source document. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Legal entity name on source document. | ||
| CUST_PO_NUMBER | VARCHAR2 | 50 | Customer purchase order on source document. | ||
| CUSTOMER_CONTRACT_NUMBER | VARCHAR2 | 120 | Oracle internal use only. | ||
| SALES_AGREEMENT_NUMBER | VARCHAR2 | 120 | Oracle internal use only. | ||
| QUOTE_NUMBER | VARCHAR2 | 120 | Oracle internal use only. | ||
| EXCHANGE_RATE | NUMBER | Conversion rate to convert amounts in local currency to the ledger currency for source document. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Currency conversion rate type on source document. Possible values are predefined rate types such as spot, corporate, and user, or any user-defined rate type. | ||
| EXCHANGE_DATE | DATE | Conversion rate date to convert amounts in local currency to the ledger currency for source document. | |||
| BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State code of bill-to customer on source document. | ||
| BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of bill-to customer on source document. | ||
| BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of bill-to customer on source document. | ||
| BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | 60 | Postal code of bill-to customer on source document. | ||
| BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | 60 | Customer classification of bill-to customer on source document. Values are from the lookup CUSTOMER_CLASS. Value at source document line level takes precedence over value at source document level. | ||
| PAYMENT_TERM_NAME | VARCHAR2 | 15 | Payment term name on source document. | ||
| ORIG_SYS_BILL_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application bill-to customer site reference on source document. | ||
| ORIG_SYS_SHIP_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application ship-to customer site reference on source document. | ||
| ORIG_SYS_BILL_TO_CUST_REF | VARCHAR2 | 255 | Original application bill-to customer reference on source document. | ||
| ORIG_SYS_SHIP_TO_CUST_REF | VARCHAR2 | 255 | Original application ship-to customer reference on source document. | ||
| SOURCE_LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Oracle internal use only. | ||
| SOURCE_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| SOURCE_ORGANIZATION_NAME | VARCHAR2 | 240 | Oracle internal use only. | ||
| SOURCE_SALESREP_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| SOURCE_PAYMENT_TERM_NAME | VARCHAR2 | 15 | Oracle internal use only. | ||
| SOURCE_BILL_TO_CUST_NUM | VARCHAR2 | 30 | Oracle internal use only. | ||
| SOURCE_BILL_TO_CUST_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| SOURCE_BILL_TO_CUST_SITE_NUM | VARCHAR2 | 240 | Oracle internal use only. | ||
| SOURCE_BILL_TO_CUST_ADDRESS | VARCHAR2 | 960 | Oracle internal use only. | ||
| SOURCE_SHIP_TO_CUST_NUM | VARCHAR2 | 30 | Oracle internal use only. | ||
| SOURCE_SHIP_TO_CUST_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| SOURCE_SHIP_TO_CUST_SITE_NUM | VARCHAR2 | 240 | Oracle internal use only. | ||
| SOURCE_SHIP_TO_CUST_ADDRESS | VARCHAR2 | 960 | Oracle internal use only. | ||
| DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
| DATA_TRANS_ERROR_MESSAGE | VARCHAR2 | 1000 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | ||
| SRC_ATTRIBUTE_NUMBER1 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER2 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER3 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER4 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER5 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER6 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER7 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER8 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER9 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER10 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER11 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER12 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER13 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER14 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER15 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER16 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER17 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER18 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER19 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_NUMBER20 | NUMBER | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE1 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE2 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE3 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE4 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE5 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE6 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE7 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE8 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE9 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| SRC_ATTRIBUTE_DATE10 | DATE | Generic column to store source document attribute. These extensible columns are used to pass additional information from the source instance into Oracle Fusion Revenue Management not covered by the standard attributes. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | |
| 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. | ||
| LEGAL_ENTITY_COUNTRY | VARCHAR2 | 60 | Country of legal entity on source document. | ||
| LEGAL_ENTITY_ADDRESS | VARCHAR2 | 960 | Legal entity address of source document. | ||
| PAYMENT_TERM_ID | NUMBER | 18 | Payment term identifier on source document line. | ||
| INVOICING_RULE_ID | NUMBER | 18 | Oracle internal use only. | ||
| ACCOUNTING_RULE_ID | NUMBER | 18 | Oracle internal use only. | ||
| ACCOUNTING_RULE_DURATION | NUMBER | Oracle internal use only. | |||
| CANCELLED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| OPEN_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| RETURN_REASON_CODE | VARCHAR2 | 60 | Oracle internal use only. | ||
| MEA_FLAG | VARCHAR2 | 1 | Indicates whether single line MEA is created for source document line. | ||
| SRC_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the source document header attributes. | ||
| SOURCE_ORG_ID | NUMBER | 18 | Oracle internal use only. | ||
| ACCOUNTING_EFFECT_FLAG | VARCHAR2 | 1 | Indicates whether revenue accounting on source document is complete or in draft. Possible values are Y, N and D. This value determines whether the revenue management application creates accounting for revenue document. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SOURCE_TYPE_CODE | VARCHAR2 | 30 | Sales order type code. Possible values are INTERNAL and EXTERNAL. This column is valid for sales orders from Oracle E-Business Suite Order Management to generate costing data. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | Source application of document data to identify source document sub line. Each integrating application has a unique value, such as EBIZ. | ||
| SP_FIRST_NAME | VARCHAR2 | 360 | Oracle internal use only | ||
| SP_MIDDLE_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| SP_LAST_NAME | VARCHAR2 | 150 | Oracle internal use only. | ||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
| ORIGINAL_DOCUMENT_ID | NUMBER | 18 | Original source document identifier used to create the recurring source document. | ||
| RECUR_HEADER_COPY_NUM | NUMBER | 18 | Number of times the recurring source document header was copied. | ||
| RECUR_HEADER_PROCESSED_FLAG | VARCHAR2 | 1 | Indicates the source document's recurring lines were processed. Valid values are from the lookup type VRM_YES/NO. | ||
| REFERENCE_EXCHANGE_RATE_DATE | DATE | The date used to convert the source document line entered currency amounts to reference currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_SOURCE_DOCUMENTS | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| vrm_revenue_doc_lines_all | vrm_source_documents | DOCUMENT_ID |
| vrm_revenue_documents_all | vrm_source_documents | DOCUMENT_ID |
| vrm_source_doc_sub_lines | vrm_source_documents | DOCUMENT_ID |
| vrm_source_doc_sub_lines | vrm_source_documents | PARENT_DOCUMENT_LINE_ID |
| vrm_mea_doc_lines | vrm_source_documents | DOCUMENT_ID |
| vrm_standalone_sales | vrm_source_documents | DOCUMENT_ID |
| vrm_pricing_lines | vrm_source_documents | DOCUMENT_ID |
| vrm_source_doc_lines | vrm_source_documents | DOCUMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_SOURCE_DOCUMENTS_N1 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| VRM_SOURCE_DOCUMENTS_N2 | Non Unique | Default | BILL_TO_CUSTOMER_PARTY_NAME, CURRENCY_CODE, LEGAL_ENTITY_NAME |
| VRM_SOURCE_DOCUMENTS_N3 | Non Unique | Default | DOCUMENT_TYPE_ID, ORG_ID |
| VRM_SOURCE_DOCUMENTS_N4 | Non Unique | Default | DATA_TRANSFORMATION_STATUS |
| VRM_SOURCE_DOCUMENTS_N5 | Non Unique | Default | NVL("DOC_ID_INT_1",(-1)), NVL("DOC_ID_INT_2",(-1)), NVL("DOC_ID_INT_3",(-1)), NVL("DOC_ID_INT_4",(-1)), NVL("DOC_ID_INT_5",(-1)), NVL("DOC_ID_CHAR_1",'X'), NVL("DOC_ID_CHAR_2",'X'), NVL("DOC_ID_CHAR_3",'X'), NVL("DOC_ID_CHAR_4",'X'), NVL("DOC_ID_CHAR_5",'X'), NVL("RECUR_HEADER_COPY_NUM",(-1)), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
| VRM_SOURCE_DOCUMENTS_N6 | Non Unique | Default | ORIGINAL_DOCUMENT_ID |
| VRM_SOURCE_DOCUMENTS_U1 | Unique | Default | DOCUMENT_ID |