DW_EB_X_EBS_AP_W_AP_AGN_INV_BKP_A

No table description is available in the supplied metadata.

Details

Module: Payables (EBS_AP)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments
POSTED_ON_DT_WID	NUMBER		38	Posting Date key
REF_DOC_NUM	VARCHAR2	80 CHAR		Reference Document Number
SNAPSHOT_DT_WID	NUMBER		38	Surrogate key for the AP fact record
SPLR_ACCT_ID	VARCHAR2	100 CHAR		Key to the Supplier Accounts dimension
SUPPLIER_ID	VARCHAR2	100 CHAR		Key to the Suppliers dimension
TRANSACTION_DT_WID	NUMBER		38	Transaction Date key
ACCOUNTING_DT_WID	NUMBER		38
ACCT_DOC_ITEM	NUMBER		15	Line item number within the accounting document
ACCT_DOC_NUM	VARCHAR2	80 CHAR		Accounting document number
ACCT_DOC_SUB_ITEM	NUMBER		15	Sub item within a line item of the accounting document
ACTIVE_HOLD_STATUS_FLAG	VARCHAR2	1 CHAR
ACTUAL_DT_WID	NUMBER		38
ALLOCATION_NUM	VARCHAR2	80 CHAR		Application Number
APPR_STATUS_ID	VARCHAR2	80 CHAR
AP_DOC_AMT	NUMBER		38,10	Amount in document Currency
AP_GLOBAL1_AMT	NUMBER		38,10	Amount in group currency1
AP_GLOBAL2_AMT	NUMBER		38,10	Amount in group currency2
AP_GLOBAL3_AMT	NUMBER		38,10	Amount in group currency3
AP_LOC_AMT	NUMBER		38,10	Amount in local currency
BALANCING_SEGMENT_ID	VARCHAR2	200 CHAR		Key to the Profit Centers dimension
BASELINE_DT_WID	NUMBER		38	Baseline Date Key
BUSN_AREA_ORG_ID	VARCHAR2	100 CHAR		Key to the Business Area Organization in Business Organizations dimension
CHANGED_BY_ID	VARCHAR2	100 CHAR		This is a key to the IA_USERS dimension indicating the user who last updated the record in the source system.
CHANGED_ON_DT	TIMESTAMP		6	This is the date, in Julian format, on which the record was last updated in the source system. This column also functions as a key to IA_DATES.
COMPANY_LOC_ID	VARCHAR2	100 CHAR		Key to the Company location in Business Locations dimension
COMPANY_ORG_ID	VARCHAR2	100 CHAR		Key to the Company organization in Business Organizations dimension
COST_CENTER_ID	VARCHAR2	200 CHAR		Key to the Cost Centers dimension
CREATED_BY_ID	VARCHAR2	100 CHAR		This is a key to the IA_USERS dimension indicating the user who created the record in the source system.
CREATED_ON_DT	TIMESTAMP		6	This is the date, in Julian format, on which the record was created in the source system. This column also functions as a key to IA_DATES.
CTRL_AREA_ORG_ID	VARCHAR2	100 CHAR		Key to the Controlling area organization in Business Area Organizations dimension
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.
DB_CR_IND	VARCHAR2	30 CHAR		Debit/credit indicator
DOC_CURR_CODE	VARCHAR2	30 CHAR		Document Currency Code
DOC_HEADER_TEXT	VARCHAR2	255 CHAR		Document header text
DOC_TYPE_ID	VARCHAR2	100 CHAR		Key to Xact Types dimension for the accounting document
ELAPSED_DAYS_DUE	NUMBER		10
ELAPSED_DAYS_OPEN	NUMBER		10
ETL_PROC_WID	NUMBER		38	This column is the unique identifier for the specific ETL process used to create or update this data.
EXPENDITURE_ORG_ID	VARCHAR2	100 CHAR		Expenditure Organization
INVENTORY_PROD_ID	VARCHAR2	100 CHAR		Key to the Manufacturing Products dimension
INVOICED_ON_DT_WID	NUMBER		38	Invoice Date Key
INVOICE_RECEIPT_DT_WID	NUMBER		38	Invoice Receipt Date Key
ISSUE_ORG_ID	VARCHAR2	100 CHAR		Key to the Issue organization in Business Organizations dimension
LEDGER_ID	VARCHAR2	100 CHAR
LINE_ITEM_TEXT	VARCHAR2	255 CHAR		Line Item text
LOC_CURR_CODE	VARCHAR2	30 CHAR		Local Currency Code
MCAL_CAL_ID	VARCHAR2	100 CHAR		Fiscal Calendar
OPERATING_UNIT_ORG_ID	VARCHAR2	100 CHAR
OVERDUE_FLG	VARCHAR2	1 CHAR		Flag indicating the transaction is overdue
PAYABLES_ORG_ID	VARCHAR2	100 CHAR
PAYMENT_DUE_DT_WID	NUMBER		38	Payment Due Date Key
PAYMENT_METHOD_ID	VARCHAR2	100 CHAR		Key to the Payment methods in the Methods Dimension
PAY_TERMS_ID	VARCHAR2	100 CHAR		Key to the Payment terms in the Terms Dimension
PLANT_LOC_ID	VARCHAR2	100 CHAR		Key to the Inventory plant in Business Locations dimension
POSTING_TYPE_ID	VARCHAR2	100 CHAR		Key to Xact Types dimension for the type of posting of accounting document
PRODUCT_ID	VARCHAR2	100 CHAR		Key to the Products dimension
PROFIT_CENTER_ID	VARCHAR2	100 CHAR		Key to the Profit Centers dimension
PROJECT_ID	VARCHAR2	100 CHAR		Project
PURCH_INVOICE_ITEM	NUMBER		15	Purchase Invoice Item
PURCH_INVOICE_NUM	VARCHAR2	80 CHAR		Purchase Invoice number
PURCH_ORDER_DT_WID	NUMBER		38	Purchase Order Date Key
PURCH_ORDER_ITEM	NUMBER		15	Purchase Order Item
PURCH_ORDER_NUM	VARCHAR2	80 CHAR		Purchase Order Number
PURCH_ORG_ID	VARCHAR2	100 CHAR		Key to the Purchase organization in Business Organizations dimension
PURCH_REP_ID	VARCHAR2	100 CHAR		Key to the Purchase representative in Business Contacts dimension
REF_DOC_ITEM	NUMBER		15	Reference Document Text
REF_DOC_TYPE_ID	VARCHAR2	100 CHAR		Key to Xact Types dimension for reference document
REMAINING_DOC_AMT	NUMBER		38,10	Remaining Invoice Amount in Document currency
REMAINING_GLOBAL1_AMT	NUMBER		38,10	Remaining Invoice Amount in Group currency1
REMAINING_GLOBAL2_AMT	NUMBER		38,10	Remaining Invoice Amount in Group currency2
REMAINING_GLOBAL3_AMT	NUMBER		38,10	Remaining Invoice Amount in Group currency3
REMAINING_LOC_AMT	NUMBER		38,10	Remaining Invoice Amount in Local currency
SOURCE_ID	VARCHAR2	100 CHAR
SPLR_ORDER_DT_WID	NUMBER		38	Suppliers Order Date Key
SUPPLIER_PROD_ID	VARCHAR2	300 CHAR		Key to the Supplier Products dimension
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.
THIRD_PARTY_ID	VARCHAR2	80 CHAR
VALD_STATUS_ID	VARCHAR2	80 CHAR
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