DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D
This table tracks all the attributes associated with supplier accounts.
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ACCT_CLERK_NAME | VARCHAR2 | 80 CHAR | Accounting clerk name | |||
| ACCT_CLERK_NUM | VARCHAR2 | 30 CHAR | Accounting clerk | |||
| ACTIVE_FLG | VARCHAR2 | 1 CHAR | Active Flag | |||
| ALLOC_SORT_KEY | VARCHAR2 | 30 CHAR | Key for sorting according to allocation number | |||
| ALT_ACCT_NAME | VARCHAR2 | 80 CHAR | Alternative payee name | |||
| ALT_ACCT_NUM | VARCHAR2 | 30 CHAR | Account number of the alternative payee | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BOE_LIMIT_AMT | NUMBER | 28,10 | Bill of exchange limit | |||
| BU_ID | NUMBER | 18 | BU identifier | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CHECK_PAID_TIME | NUMBER | 28,10 | Probable time until check is paid | |||
| CITY_CODE | VARCHAR2 | 120 CHAR | City Code | |||
| COMPANY_CODE | VARCHAR2 | 120 CHAR | Company code | |||
| CONTINENT_CODE | VARCHAR2 | 120 CHAR | Contitent code | |||
| COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Country region code | |||
| COUNTY_CODE | VARCHAR2 | 120 CHAR | County code | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous. | |||
| CUSTOMER_NUM | VARCHAR2 | 30 CHAR | Customer number | |||
| C_CITY_CODE | VARCHAR2 | 120 CHAR | Country city code | |||
| C_CONTINENT_CODE | VARCHAR2 | 120 CHAR | Country continent code | |||
| C_COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Country region code | |||
| C_COUNTY_CODE | VARCHAR2 | 120 CHAR | Country county code | |||
| C_REGION_CODE | VARCHAR2 | 120 CHAR | Country region code | |||
| C_STATE_PROV_CODE | VARCHAR2 | 120 CHAR | Country state province code | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| FAX_NUM | VARCHAR2 | 30 CHAR | Fax number | |||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_RECNCL_ACCT_NUM | VARCHAR2 | 30 CHAR | Reconciliation account number in general ledger | |||
| HEAD_OFFC_ACCT_NAME | VARCHAR2 | 80 CHAR | Head office account name | |||
| HEAD_OFFC_ACCT_NUM | VARCHAR2 | 30 CHAR | Head office account number | |||
| HOUSE_BANK_CODE | VARCHAR2 | 120 CHAR | Short key for a house bank | |||
| LOCATION_ID | NUMBER | 18 | Location identifier | |||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| OUR_ACCT_NUM | VARCHAR2 | 30 CHAR | Our account number at the vendor | |||
| PARTY_ID | NUMBER | 18 | Party identifier | |||
| PARTY_SITE_ID | NUMBER | 18 | Party site identifier | |||
| PAYMENT_GRP_CODE | VARCHAR2 | 120 CHAR | Key for payment grouping | |||
| PAY_TERMS_CODE | VARCHAR2 | 120 CHAR | Code for Terms of payment | |||
| PERSONNEL_NAME | VARCHAR2 | 80 CHAR | Personnel name | |||
| PERSONNEL_NUM | VARCHAR2 | 30 CHAR | Personnel number | |||
| PHONE_NUM | VARCHAR2 | 30 CHAR | Phone number | |||
| PLAN_GROUP_CODE | VARCHAR2 | 120 CHAR | Planning group | |||
| POSTAL_CODE | VARCHAR2 | 120 CHAR | Postal code | |||
| PREV_SPLR_NUM | VARCHAR2 | 30 CHAR | Previous master record number | |||
| PYMNT_MTHD_LKP_CODE | VARCHAR2 | 30 CHAR | Payment Method Lookup Code | |||
| REGION_CODE | VARCHAR2 | 120 CHAR | Region code | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| SET_ID | VARCHAR2 | 30 CHAR | This column represents an unique identifier often used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily. | |||
| SPLR_ACCT_NAME | VARCHAR2 | 255 CHAR | Vendor (creditor) account name | |||
| SPLR_ACCT_NUM | VARCHAR2 | 30 CHAR | Vendor (creditor) account number | |||
| SPLR_RECPT_TYPE_CODE | VARCHAR2 | 120 CHAR | Vendor recipient type | |||
| SPLR_USER_NAME | VARCHAR2 | 80 CHAR | User at vendor | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| STATE_PROV_CODE | VARCHAR2 | 120 CHAR | State province code | |||
| ST_ADDRESS1 | VARCHAR2 | 255 CHAR | Represents street number and street name of the address | |||
| ST_ADDRESS2 | VARCHAR2 | 255 CHAR | Represents street description of the address | |||
| SUPPLIER_ID | NUMBER | 18 | Supplier identifier | |||
| SUPPLIER_SITE_CODE | VARCHAR2 | 120 CHAR | Supplier Site code | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TOLERANCE_GRP_CODE | VARCHAR2 | 120 CHAR | Tolerance group for the business partner | |||
| W_COUNTRY_CODE | VARCHAR2 | 120 CHAR | Warehouse counrty code | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |