DW_EB_X_EBS_AR_W_AR_AGN_INV_BKP_A

No table description is available in the supplied metadata.

Details

Module: Receivables (EBS_AR)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments
CUSTOMER_ACCNT_ID	VARCHAR2	100 CHAR		Customer Account
POSTED_ON_DT_WID	NUMBER		38	Posting Date key
REF_DOC_NUM	VARCHAR2	80 CHAR		Reference Document Number
SNAPSHOT_DT_WID	NUMBER		38	Key to the Time dimension. It indicates the dates when the Aging Information is recorded
TRANSACTION_DT_WID	NUMBER		38	Transaction Date key
ACCOUNTING_DT_WID	NUMBER		38
ACCT_DOC_NUM	VARCHAR2	80 CHAR		Accounting document number
ACTUAL_DT_WID	NUMBER		38
AGREEMENT_ID	VARCHAR2	100 CHAR		Agreement
BALANCING_SEGMENT_ID	VARCHAR2	200 CHAR		Key to the Profit Centers dimension
BASELINE_DT_WID	NUMBER		38	Base line 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
CUSTOMER_BILL_TO_LOC_ID	VARCHAR2	100 CHAR		Key to the Bill to location in Customer Locations dimension
CUSTOMER_CONTACT_ID	VARCHAR2	100 CHAR		Key to the Customer Contacts dimension
CUSTOMER_ID	VARCHAR2	100 CHAR		Key to the Customers dimension
CUSTOMER_PAYER_LOC_ID	VARCHAR2	100 CHAR		Key to the Payer location in Customer Locations dimension
CUSTOMER_SHIP_TO_LOC_ID	VARCHAR2	100 CHAR		Key to the Ship to location in Customer Locations dimension
CUSTOMER_SOLD_TO_LOC_ID	VARCHAR2	100 CHAR		Key to the Sold to location in Customer Locations 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.
DOC_CURR_CODE	VARCHAR2	30 CHAR		Local Currency Code
ELAPSED_DAYS_DUE	NUMBER		28,10
ELAPSED_DAYS_OPEN	NUMBER		28,10
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
INVOICED_ON_DT_WID	NUMBER		38	Invoice Date Key
INVOICE_RECEIPT_DT_WID	NUMBER		38	Invoice Receipt Date Key
LEDGER_ID	VARCHAR2	100 CHAR
LOC_CURR_CODE	VARCHAR2	30 CHAR		Local Currency Code
MCAL_CAL_ID	VARCHAR2	100 CHAR		Fiscal Calendar
OPERATING_UNIT_ORG_ID	VARCHAR2	100 CHAR
ORIGINAL_DOC_AMT	NUMBER		38,10	Original Invoice Amount in Document currency
ORIGINAL_GLOBAL1_AMT	NUMBER		38,10	Original Invoice Amount in Group currency1
ORIGINAL_GLOBAL2_AMT	NUMBER		38,10	Original Invoice Amount in Group currency2
ORIGINAL_GLOBAL3_AMT	NUMBER		38,10	Original Invoice Amount in Group currency3
ORIGINAL_LOC_AMT	NUMBER		38,10	Original Invoice Amount in Local currency
OVERDUE_FLG	VARCHAR2	1 CHAR		Clearing Document Number
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
PRODUCT_ID	VARCHAR2	100 CHAR		Key to the Products dimension
PROFIT_CENTER_ID	VARCHAR2	100 CHAR
PROJECT_ID	VARCHAR2	100 CHAR		Project
PROJECT_ORG_ID	VARCHAR2	100 CHAR		Project Organization
RECEIVABLES_ORG_ID	VARCHAR2	100 CHAR
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
SALES_GROUP_ORG_ID	VARCHAR2	100 CHAR		Key to the Sales Group organization in Business Organizations dimension
SALES_INVOICE_NUM	VARCHAR2	80 CHAR		Clearing Document Number
SALES_OFC_LOC_ID	VARCHAR2	100 CHAR		Key to the Sales Office location in Business Locations dimension
SALES_ORG_ID	VARCHAR2	100 CHAR		Key to the Sales organization in Business Area Organizations dimension
SALES_PRODUCT_ID	VARCHAR2	100 CHAR		Key to the Sales Products dimension
SALES_REP_ID	VARCHAR2	100 CHAR		Key to the Sales representative in Business Contacts 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.
UOM_CODE	VARCHAR2	50 CHAR		Unit of Measure
XACT_QTY	NUMBER		28,10	Transaction Quantity
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