VRM_SOURCE_DOC_HEADER_GT
Oracle internal use only. This global temporary table is used in validate customer contracts source data job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
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 | Oracle Application identifier of source document. Foreign key to FND applications table. For example, 222 for Receivables invoices, or users can optionally use -1. | ||
SOURCE_SYSTEM | VARCHAR2 | 120 | Source application of document data to identify source document. Each integrating application has a unique value, such as EBIZ. | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
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 | Date of source document, such as book date for sales order, or invoice date for invoice. | |||
DOCUMENT_NUMBER | VARCHAR2 | 300 | Source document number. For example, a sales order number or receivables invoice number. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code of source document. This value must match currency codes in Oracle Fusion General Ledger. | ||
ORIG_SYS_BILL_TO_CUST_REF | VARCHAR2 | 255 | Original application bill-to customer reference on source document. | ||
ORIG_SYS_BILL_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application ship-to customer reference on source document. | ||
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. | ||
BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number 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. | ||
BILL_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Site identifier of bill-to customer on 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_COUNTRY | VARCHAR2 | 60 | Country code of bill-to customer on source document. | ||
ORIG_SYS_SHIP_TO_CUST_REF | VARCHAR2 | 255 | Original application ship-to customer reference on source document. | ||
ORIG_SYS_SHIP_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application ship-to customer site reference on source document. | ||
SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Account identifier of ship-to customer on source document. | ||
SHIP_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of ship-to customer on source document. | ||
SHIP_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Site identifier 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 of 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. | ||
SRC_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the source document header attributes. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
RECUR_HEADER_COPY_NUM | NUMBER | 18 | Number of times the recurring source document header was copied. | ||
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. |