VRM_DIMENSION_PROCESS_INT
VRM_DIMENSION_PROCESS_INT is used for pricing dimension assignment processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Internal unique identifier of a source document line. | ||
| VPL_ROWID | VARCHAR2 | 64 | Internal unique identifier of a VSOE price line within a set. | ||
| DOCUMENT_ID | NUMBER | 18 | Unique identifier of a source document. | ||
| DOCUMENT_DATE | DATE | Date of source document. | |||
| STATUS | VARCHAR2 | 30 | Pricing dimension assignment processing status. | ||
| GROUP_NUMBER | NUMBER | 18 | Internal unique identifier of a line group. | ||
| TEMPLATE_ID | NUMBER | 18 | Internal identifier of the template. | ||
| MEA_NUMBER | NUMBER | 18 | Unique number of a MEA transaction. | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Number of the pricing dimension structure. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type. | ||
| DOCUMENT_LINE_TYPE | VARCHAR2 | 30 | Type of a source document line. | ||
| PRICING_COMBINATION_ID | NUMBER | 18 | Identifier of the pricing dimension combination. | ||
| DIMENSION_FLAG | VARCHAR2 | 1 | Flag that indicates whether pricing combination is successfully derived for the given document line. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Inventory item number. | ||
| UOM_CODE | VARCHAR2 | 200 | Code name of the unit of measure. | ||
| LINE_BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a bill to customer address. | ||
| LINE_SHIP_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a ship to customer address. | ||
| LINE_BILL_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Bill-to customer name. | ||
| LINE_SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Ship-to customer name. | ||
| LINE_BILL_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of a bill to customer address. | ||
| LINE_SHIP_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of a ship to customer. | ||
| LINE_BILL_TO_COUNTRY | VARCHAR2 | 60 | Country of a bill to customer address. | ||
| LINE_SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country of a ship to customer address. | ||
| LINE_BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State of a bill to customer address. | ||
| LINE_BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of a bill to customer address. | ||
| LINE_BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of a bill to customer address. | ||
| LINE_BILL_TO_CUST_POSTAL_CODE | VARCHAR2 | 60 | Postal code of a bill to customer address. | ||
| LINE_BILL_TO_CUST_CLASSFN | VARCHAR2 | 60 | Classifcation of a bill to customer address. | ||
| LINE_SALESREP_NAME | VARCHAR2 | 360 | Salesperson name of a source document. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LINE_SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Generic column to store source document line attribute. | ||
| LINE_SRC_ATTRIBUTE_NUMBER1 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER2 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER3 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER4 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER5 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER6 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER7 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER8 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER9 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER10 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER11 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER12 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER13 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER14 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER15 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER16 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER17 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER18 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER19 | NUMBER | Generic column to store source document line attribute. | |||
| LINE_SRC_ATTRIBUTE_NUMBER20 | NUMBER | Generic column to store source document line attribute. | |||
| DOCUMENT_NUMBER | VARCHAR2 | 300 | Source document number. For example, a sales order number or receivables invoice number. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the source document. | ||
| HDR_SALESREP_NAME | VARCHAR2 | 30 | Salesperson name. | ||
| HDR_BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a bill to customer. | ||
| HDR_SHIP_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of a ship to customer address. | ||
| HDR_BILL_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Bill-to customer name. | ||
| HDR_SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 360 | Ship-to customer name. | ||
| HDR_BILL_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of a bill to customer address. | ||
| HDR_SHIP_TO_CUST_SITE_NAME | VARCHAR2 | 240 | Site name of a ship to customer. | ||
| HDR_BILL_TO_COUNTRY | VARCHAR2 | 60 | Country of a bill to customer address. | ||
| HDR_SHIP_TO_COUNTRY | VARCHAR2 | 60 | Country of a ship to customer address. | ||
| HDR_BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State of a bill to customer address. | ||
| HDR_BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of a bill to customer address. | ||
| HDR_BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of a bill to customer address. | ||
| HDR_BILL_TO_CUST_POSTAL_CODE | VARCHAR2 | 60 | Postal code of a bill to customer address. | ||
| HDR_BILL_TO_CUST_CLASSFN | VARCHAR2 | 60 | Customer classification of a bill to customer. | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Indicates the name of the business unit associated with the row. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Name of a ledger. | ||
| CUST_PO_NUMBER | VARCHAR2 | 50 | A unique identifier of a purchase order. | ||
| CUSTOMER_CONTRACT_NUMBER | VARCHAR2 | 120 | A unique identifier of a contract. | ||
| SALES_AGREEMENT_NUMBER | VARCHAR2 | 120 | Unique number of a sales agreement document. | ||
| QUOTE_NUMBER | VARCHAR2 | 120 | Unique identifier number of a quote. | ||
| HDR_SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Generic column to store source document header attribute. | ||
| HDR_SRC_ATTRIBUTE_NUMBER1 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER2 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER3 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER4 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER5 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER6 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER7 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER8 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER9 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER10 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER11 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER12 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER13 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER14 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER15 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER16 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER17 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER18 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER19 | NUMBER | Generic column to store source document header attribute. | |||
| HDR_SRC_ATTRIBUTE_NUMBER20 | NUMBER | Generic column to store source document header attribute. | |||
| LINE_TYPE | VARCHAR2 | 15 | Type of a source document line. | ||
| QUANTITY | NUMBER | Quantity of a transaction. | |||
| AMOUNT | NUMBER | Line or line group amount that is used in pricing dimension combination assignment for an amount qualifier segment. | |||
| VLG_ROWID | VARCHAR2 | 64 | Internal unique identifier of a line group. | ||
| WORKER_NUMBER | NUMBER | 3 | Oracle internal use only. | ||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BATCH_NUMBER | NUMBER | Identifies the batch to be processed. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_DIMENSION_PROCESS_INT_N1 | Non Unique | Default | REQUEST_ID, BATCH_NUMBER, LINE_TYPE |
| VRM_DIMENSION_PROCESS_INT_U1 | Unique | Default | DOCUMENT_LINE_ID |
| VRM_DIMENSION_PROCESS_INT_U2 | Unique | Default | GROUP_NUMBER |