Skip to main content

Posts

Showing posts with the label OBAW AP

BI Apps Financials — Accounts Payable Facts and Aggregates

DIMENSION/FACT BUSINESS NAME DESCRIPTION W_AP_AGING_INVOICE_A   Fact Table AP Aging Aggregate Table by Invoice   This table stores the accounts payable aging information at the invoice and association dimension levels. Each record in this table indicates the aging information at a particular date in time. The SNAPSHOT_DT_WID column indicates the date when the aging information is recorded   W_AP_AGING_SUPPLIER_A   Fact Table AP Aging Aggregate Table by Supplier This table stores the accounts payable aging information at the supplier andassociation dimension levels. Each record in this table indicates the aging information at a particular date in time. The SNAPSHOT_DT_WID column indicates the date when the aging information is recorded   W_AP_BALANCE_F   Fact Table Accounts payable balance   This table stores account payable balance information for supplier accounts. Only Posted records are considered for calculating the balances and Balance amts can be...