Activities and Cost Analysis

This complex folder is created for advanced cost accounting reports generated from Cost Analyzer fact. It is used in calculating the activities and cost analysis.

Gross Revenue

Calculated item that stores the information of sum of net balance transaction amount for level 4 object account. Level 4 being the level in the account hierarchy.

Custom SQL Item − GROSSREVENUE

Custom SQL Item is needed in this case since there is a unique join that needs to be created in order to calculate Gross Revenue.

Total Activities Cost

Calculation used for obtaining cost of total activities for customers.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Total Activities as a Percentage of Revenue

Calculates percentage of total activities to revenue for customers. Displays revenue by different activity.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMTCustom SQL Item - GROSSREVENUE

Net Balance Transaction Amount

Calculates net balance amount in transaction currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Net Balance

Contains the sum of net balance transaction amounts for various object accounts.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Costs

Contains transaction amount that is used for direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor

Contains transaction amount that is used to derive the value of labor costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery

Contains transaction amount that is used to derive the value of machinery costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Material

Contains transaction amount that is used to derive the value of material costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor as a Percentage of Direct Costs

Contains calculation of the percentage of direct labor related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery as a Percentage of Direct Costs

Contains the calculation of the percentage of direct machinery related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Materials as a Percentage of Direct Costs

Contains the calculation of the percentage of direct materials related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Dimension Account

This dimension includes details of an account

PS_V_ACCOUNT

Dimension Activity

Includes information about an activity. An activity groups the advanced cost accounting analysis, such as “pull inventory from warehouse” and “inspect warehouse.“

PS_D_ACTIVITY

Dimension Business Unit

The business unit dimension details the name of the Business Unit.

PS_D_BUSINESS_UNIT

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Detail Period

Detail Period Dimension.

PS_D_DET_PERIOD

Dimension Item

Contains information on inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Ledger

Includes the ID and description of ledgers that are defined based on templates. Detailed information about E1 ledger type such as 'AA-Actual Amount' and 'BA-Budgeting Amount' are also stored.

PS_D_LEDGER

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension View

Includes information about a view that groups the advanced cost accounting analysis, such as profit and loss, by item and by customer.

PS_D_VIEW

Activities and Cost Analysis

This complex folder is created for advanced cost accounting reports generated from Cost Analyzer. It is used in calculating the activities and cost analysis.

Profitability Analysis

This complex folder is used to generate advanced cost accounting reports and customer and product profitability analysis, which are based on fact table Cost Analyzer.

Custom Gross Revenue

This custom folder calculates the sum of net balance transaction amounts and stores that amount in Gross Revenue.

Fact Cost Analyzer Balance

Includes information on cost analyzer balance facts. It captures the cost analyzer balance amount at the fiscal period level.

PS_F_CST_ANLYZ_BAL

Fact Cost Analyzer Balance Join

Used to build the join between the Customer dimension folder Gross Revenue and fact folder Cost Analyzer Balance.

Custom SQL Item − DUMMY

Gross Revenue

Calculated item that stores the information of sum of net balance transaction amount for level 4 object account.

Custom SQL Item − GROSSREVENUE

Custom SQL Item is needed in this case since there is a unique join that needs to be created in order to calculate Gross Revenue.

Total Activities Cost

Calculation used for obtaining cost of total activities for customers.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Total Activities as a Percentage of Revenue

Calculates percentage of total activities to revenue by customers.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMTCustom SQL Item - GROSSREVENUE

Net Balance R1 Amount (Net Balance Reporting1 Amount)

Includes the net balance amount in the first reporting currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_R1_AMT

Net Balance R2 Amount (New Balance Reporting2 Amount)

Includes the net balance amount in second reporting currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_R2_AMT

Net Balance Transaction Amount

Includes the net balance amount in the transaction currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Net Balance

Contains the sum of net balance transaction amounts for various object accounts.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Calculated Net Balance Start

Contains the calculated net balance.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Net Balance Transaction Amount

Includes the net balance amount in the transaction currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Percentage Of Revenue

Calculates the percentage of revenue relating to gross revenue and ledger.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Custom SQL Item − GROSSREVENUE

Direct Costs

Contains transaction amount that is used for direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor

Contains transaction amount that is used to derive the value of labor costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery

Contains transaction amount that is used to derive the value of machinery costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Material

Contains transaction amount that is used to derive the value of material costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor as a Percentage of Direct Costs

Contains the calculation of the percentage of direct labor related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery as a Percentage of Direct Costs

Contains the calculation of the percentage of direct machinery related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Materials as a Percentage of Direct Costs

Contains the calculation of the percentage of direct materials related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Custom Gross Revenue Join

Join created to retrieve Gross Revenue.

This item is not based on a database column.

Profitability Analysis

This complex folder is used to generate advanced cost accounting reports, customer and product profitability analysis, which are based on fact table Cost Analyzer.

Custom Gross Revenue

This custom folder calculates the sum of net balance transaction amount and stores it in the gross revenue column.

Fact Cost Analyzer Balance Join

Used to build the join between the Customer dimension folder Gross Revenue and fact folder Cost Analyzer Balance.

Custom SQL Item − DUMMY

Gross Revenue

Calculated item that stores the information of sum of net balance transaction amount for level 4 object account.

Custom SQL Item − GROSSREVENUE

Custom SQL Item is needed in this case since there is a unique join that needs to be created in order to calculate Gross Revenue.

Net Balance Transaction Amount

Includes the net balance amount in the transaction currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Net Balance

Contains the sum of net balance transaction amounts for various object accounts.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Percentage Of Revenue

Calculates the percentage of revenue relating to gross revenue and ledger.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Custom SQL Item − GROSSREVENUE

Dimension Activity

Includes information about an activity. An activity groups the advanced cost accounting analysis, such as “pull inventory from warehouse” and “inspect warehouse.”

PS_D_ACTIVITY

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Detail Period

Detail Period Dimension.

PS_D_DET_PERIOD

Dimension Driver

Includes information on a driver, which is used to group the advanced cost accounting analysis.

PS_D_DRIVER

Dimension Item

Contains information on inventory and non-inventory items. An inventory item is a tangible commodity that is physically stocked in inventory.

PS_D_INV_ITEM

Dimension Ledger

Includes the ID and description of ledgers that are defined based on templates. Detailed information about E1 ledger type such as 'AA-Actual Amount' and 'BA-Budgeting Amount' are also stored.

PS_D_LEDGER

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Activities and Cost Analysis

This complex folder is used for advanced cost accounting reports, which are generated from fact Cost Analyzer for calculating the activities and cost analysis.

Gross Revenue

Calculated item that stores the information of sum of net balance transaction amount for level 4 object account.

Custom SQL Item − GROSSREVENUE

Custom SQL Item is needed in this case since there is a unique join that needs to be created in order to calculate Gross Revenue.

Total Activities Cost

Calculation used for obtaining cost of total activities for customers.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Total Activities as a Percentage of Revenue

Calculates percentage of total activities to revenue for customers.

PS_D_ACTIVITY.ACTVTY_ID

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMTCustom SQL Item - GROSSREVENUE

Net Balance Transaction Amount

Includes the net balance amount in the transaction currency.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Net Balance

Contains the sum of net balance transaction amounts for various object accounts.

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Costs

Contains transaction amount that is used for direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor

Contains transaction amount that is used to derive the value of labor costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery

Contains transaction amount that is used to derive the value of machinery costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Material

Contains transaction amount that is used to derive the value of material costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Labor as a Percentage of Direct Costs

Contains calculation of the percentage of direct labor related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Machinery as a Percentage of Direct Costs

Contains the calculation of the percentage of direct machinery related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Direct Materials as a Percentage of Direct Costs

Contains the calculation of the percentage of direct materials related to direct costs.

PS_V_ACCOUNT.LVL_04_OBJCT

PS_V_ACCOUNT.SUBSIDIARY

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

PS_V_ACCOUNT.LVL_04_OBJCT

PS_F_CST_ANLYZ_BAL.NET_BAL_TRAN_AMT

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Alternate Account

Includes alternate accounts that are used as an alternate to the original accounts. This dimension can be used for internal reporting.

PS_D_ALTACCT

Dimension Book Code

Includes details about book codes that represent an account attribute and a balancing ChartField.

PS_D_BOOK_CODE

Dimension Budget Reference

Includes a description relating to budgets.

PS_D_BUDGET_REF

Dimension Business Unit AP (Business Unit Accounts Payable

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Affiliate

The affiliate business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension ChartField1

Includes user defined ChartField details.

PS_D_ChartField1

Dimension ChartField2

Includes user defined ChartField details.

PS_D_ChartField2

Dimension ChartField3

Includes user defined ChartField details.

PS_D_ChartField3

Dimension Class Field

Includes expense classification codes and descriptions.

PS_D_CLASS_FIELD

Dimension Day Post Date

The post date day dimension is a role-playing dimension based on the day dimension

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Fund

Includes details about fund codes and their description.

PS_D_FUND

Dimension Fund Affiliate

Includes details about affiliate fund codes and their description.

PS_D_FUND

Dimension GL Adjustment Type (General Ledger Adjustment Type)

Includes types of GL adjustments.

PS_D_GL_ADJ_TYPE

Dimension GL Offset

Includes information on GL offset. Offset Accounts “offset” the debit or credit entry in a transaction.

PS_D_GL_OFFSET

Dimension Journal Source

Includes details about the source of journal entries created in the general ledger.

PS_D_JRNL_SOURCE

Dimension Ledger

Includes the ID and description of ledgers that are defined based on templates. Detailed information about E1 ledger type such as 'AA-Actual Amount' and 'BA-Budgeting Amount' are also stored.

PS_D_LEDGER

Dimension Operating Unit

Includes details about operating units, such as a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Operating Unit Affiliate

Includes details about affiliate operating units.

PS_D_OPER_UNIT

Dimension Pattern Day Journal

The pattern or fiscal day journal dimension is a role-playing dimension based on the pattern day dimension.

PS_D_PATTERN_DAY

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Program FDM (Financial Data Mart)

Keeps track of programs that can be tracked in the general ledger.

PS_D_PROGRAM_FDM

Dimension Project

Includes information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Dimension Scenario

Includes details of historical budgeting and forecast scenarios.

PS_D_SCENARIO

Dimension Statistics Code

This dimension includes details about statistical information such as floor space, full-time equivalent workdays, shipment size, etc. They can be associated with a monetary account.

PS_D_STAT_CODE

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Supplier

Includes detail information on suppliers

PS_D_SUPPLIER

Fact AP Account Line (Accounts Payable Account Line)

Includes all of the AP accounting entries posted by the AP module. This fact helps you to answer questions such as “What are the posting details of the AP transactions to GL in a specified time period? “

PS_F_AP_ACCOUNT_LN

Age Range

Contains the age classification of the employee.

PS_D_PERSON.BIRTH_DT_SID

Age

Contains the age of the employee.

PS_D_PERSON.BIRTH_DT_SID

Birth Date

Contains date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Death Date

Contains the date of death of a person.

PS_D_PERSON.DEATH_DT_SID

Number of Years Experience

Contains the years of work experience of the person.

PS_D_PERSON.EXP_YR_NUM

Benefit Amount

The benefit amount.

PS_D_PRJ.BNFT_AMT

Benefit R1 Amount (Benefit Reporting 1 Amount)

The reporting 1 benefit amount.

PS_D_PRJ.BNFT_R1_AMT

Benefit R2 Amount (Benefit Reporting 2 Amount)

The reporting2) benefit amount.

PS_D_PRJ.BNFT_R2_AMT

Discount Rate

Used to calculate the estimated net present value and the estimated return on investment.

PS_D_PRJ.DSCNT_RT

Maintenance Cost Amount

Contains the project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_AMT

Maintenance Cost R1 Amount

Contains the reporting 1 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R1_AMT

Maintenance Cost R2 Amount

Contains the reporting 2 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R2_AMT

NPV Amount

Contains the estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_AMT

NPV R1 Amount

Contains the reporting 1 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R1_AMT

NPV R2 Amount

Contains the reporting 2 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R2_AMT

Project Cost Amount

Contains the project estimated cost amount.

PS_D_PRJ.PRJ_CST_AMT

Project Cost R1 Amount

Contains the reporting 1 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R1_AMT

Project Cost R2 Amount

Contains the reporting 2r project estimated cost amount.

PS_D_PRJ.PRJ_CST_R2_AMT

ROI Amount

Contains the estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_AMT

ROI R1 Amount

Contains the reporting 1 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R1_AMT

ROI R2 Amount

Contains the reporting 2 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R2_AMT

Journal Base Amount

Contains the journal monetary amount in base currency. Journal monetary amount. With this fact, you can answer questions such as "What is the journal amount posted to the general ledger for the selected accounts receivable account by accounts receivable transactions?"

PS_F_AR_ACCOUNT_LN.JRNL_BASE_AMT

Journal R1 Amount

Contains the journal monetary amount in reporting 1 currency.

PS_F_AR_ACCOUNT_LN.JRNL_R1_AMT

Journal R2 Amount

Contains the journal monetary amount in reporting 2 currency.

PS_F_AR_ACCOUNT_LN.JRNL_R2_AMT

Journal Statistics Amount

Contains the journal statistics amount in Enterprise Warehouse (EW) currency.

PS_F_AP_ACCOUNT_LN.JRNL_STAT_EW_AMT

Journal Transaction Amount

Contains the journal monetary amount in transaction currency. With this fact, you can answer questions such as "What is the journal amount posted to the general ledger for the selected accounts receivable account by accounts receivable transactions?"

PS_F_AR_ACCOUNT_LN.JRNL_TRAN_AMT

Dimension Aging Category

Includes aging categories used in accounts payable and accounts receivable aging analysis. The AP AR indicator item classifies the aging category as AP or AR.

PS_D_AGING_CTGRY

Dimension Business Unit AP (Business Unit Accounts Payable

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Supplier

Includes detail information on suppliers.

PS_D_SUPPLIER

Dimension Supplier Remit Supplier

Includes information on remit to suppliers.

PS_D_SUPPLIER

Fact AP Aging (Accounts Payable Aging)

This fact contains the aging information by aging category and supplier. It can be used to answer questions such as “What percentage is past due?” and “ What money is owed in a period? “

PS_F_AP_AGING

Balance Base Amount

Contains the balance amount in base currency. Use this metric to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AP_AGING.BAL_BASE_AMT

Balance R1 Amount

Contains the balance amount in reporting 1 currency. Use this metric to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AP_AGING.BAL_R1_AMT

Balance R2 Amount

Contains the balance amount in reporting 2 currency. Use this fact to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AP_AGING.BAL_R2_AMT

Balance Transaction Amount

Contains the balance amount in transaction currency. Use this fact to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AP_AGING.BAL_TRAN_AMT

Discount Base Amount

Contains the discount amount in base currency. It is the amount that is available as discount as per the terms of the voucher. Use this fact to answer questions such as "What is the total discount amount available in AP vouchers?"

PS_F_AP_AGING.DSCNT_BASE_AMT

Discount R1 Amount

Contains the discount amount in reporting 1 currency. The amount that is available as discount as per the terms of the voucher. Use this fact to answer questions such as "What is the total discount amount available in AP vouchers?"

PS_F_AP_AGING.DSCNT_R1_AMT

Discount R2 Amount

This is the discount amount in reporting 2 currency. The amount that is available as discount as per the terms of the voucher. Use this fact to answer questions such as "What is the total discount amount available in AP vouchers?"

PS_F_AP_AGING.DSCNT_R2_AMT

Discount Transaction Amount

Contains the discount amount in transaction currency. The amount that is available as discount as per the terms of the voucher. Use this fact to answer questions such as "What is the total discount amount available in AP vouchers?"

PS_F_AP_AGING.DSCNT_TRAN_AMT

Gross Base Amount

Contains the gross amount in base currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_AGING.GROSS_BASE_AMT

Gross R1 Amount

Contains the gross amount in reporting 1 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_AGING.GROSS_R1_AMT

Gross R2 Amount

Contains the gross amount in reporting 2 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_AGING.GROSS_R2_AMT

Gross Transaction Amount

Contains the gross amount in transaction currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_AGING.GROSS_TRAN_AMT

Prepaid Base Amount

Contains the prepaid amount in base currency. This is the amount that was prepaid against this AP voucher. Use this fact to answer questions such as "What is the total prepaid amount to a specified supplier?"

PS_F_AP_AGING.PREPAID_BASE_AMT

Prepaid R1 Amount

Contains the prepaid amount in reporting 1 currency. This is the amount that was prepaid against this AP voucher. Use this fact to answer questions such as "What is the total prepaid amount to a specified supplier?"

PS_F_AP_AGING.PREPAID_R1_AMT

Prepaid R2 Amount

Contains the prepaid amount in reporting 2 currency. This is the amount that was prepaid against this AP voucher. Use this fact to answer questions such as "What is the total prepaid amount to a specified supplier?"

PS_F_AP_AGING.PREPAID_R2_AMT

Dimension AB (Address Book) Master Originator

This role-playing dimension is based on PS_D_AB_MASTER for transaction originator.

PS_D_AB_MASTER

Dimension AB (Address Book) Master Payee

This role-playing dimension based on address book master dimension for payee.

PS_D_AB_MASTER

Dimension AP Document Type

Includes details about various AP document types, such as payables prepayments, payables adjustments, and payables accruals.

PS_D_AP_DOC_TYPE

Dimension AP Payment Transaction Type

Includes AP transaction types from a payment perspective. Types include express payment, manual payment, regular payment, and so on.

PS_D_AP_PTR_TYPE

Dimension AP Posting Status

Includes AP posting status. Status values include posted, un-posted, payment not applied, and so on.

PS_D_APPOST_STATUS

Dimension AP Voucher Transaction Type

Includes AP voucher transaction types. Types include adjustment voucher, prepaid voucher, and so on.

PS_D_AP_VTR_TYPE

Dimension APAR Transaction Type

Includes accounts payable and accounts receivable transaction types. Examples of types are voucher, receipt, and payment.

PS_D_APAR_TRN_TYPE

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit AP

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Day Discount Due Date

A role-playing dimension based on dimension Day for discount due date.

PS_D_DAY

Dimension Day Due Date

A role-playing dimension based on dimension Day for due date.

PS_D_DAY

Dimension Day GL Date

A role-playing dimension based on dimension Day for general ledger date.

PS_D_DAY

Dimension Day Invoice Date

A role-playing dimension based on dimension Day for Invoice Date

PS_D_DAY

Dimension Day Payment Date

This is a role-playing dimension based dimension Day for payment date

PS_D_DAY

Dimension GL Offset

Includes information on GL offset. It is used to group billing information, such as office rent and retail rent.

PS_D_GL_OFFSET

Dimension Payment Method

Includes the details about various methods of payment, such as check, cash, and credit card.

PS_D_PYMNT_MTHD

Dimension Payment Status

Includes information on all voucher payment statuses.

PS_D_PYMT_STATUS

Dimension Payment Terms

Includes information about various payment terms such as net 30 days and due first of month.

PS_D_PYMNT_TRMS

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Supplier

Includes information on suppliers.

PS_D_SUPPLIER

Dimension Unit

Includes information on units, that is, detail information of real estate properties.

PS_D_UNIT

Fact AP Ledger

Relates AP vouchers and payments made against the vouchers.

PS_F_AP_LEDGER

Distinct Unit

Contains the distinct count of units.

PS_D_UNIT.UNIT_ID

Discount Available Base Amount

Contains the discount available amount in base currency.

PS_F_AP_LEDGER.DIAV_BASE_AMT

Discount Available R1 Amount

Contains the discount available amount in reporting1 currency.

PS_F_AP_LEDGER.DIAV_R1_AMT

Discount Available R2 Amount

Contains the discount available amount in reporting 2 currency.

PS_F_AP_LEDGER.DIAV_R2_AMT

Discount Available Transaction Amount

Contains the discount available amount in transaction currency.

PS_F_AP_LEDGER.DIAV_TRAN_AMT

Discount Taken Base Amount

Contains the discount taken amount in base currency.

PS_F_AP_LEDGER.DITK_BASE_AMT

Discount Taken R1 Amount

Contains the discount taken amount in reporting 1 currency.

PS_F_AP_LEDGER.DITK_R1_AMT

Discount Taken R2 Amount

Contains the discount taken amount in reporting 2 currency.

PS_F_AP_LEDGER.DITK_R2_AMT

Discount Taken Transaction Amount

Contains the discount taken amount in transaction currency.

PS_F_AP_LEDGER.DITK_TRAN_AMT

Gross Base Amount

Contains the gross amount in base currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_LEDGER.GROSS_BASE_AMT

Gross R1 Amount

Contains the gross amount in reporting 1 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_LEDGER.GROSS_R1_AMT

Gross R2 Amount

Contains the gross amount in reporting 2 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_LEDGER.GROSS_R2_AMT

Gross Transaction Amount

Contains the gross amount in transaction currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_AP_LEDGER.GROSS_TRAN_AMT

Non-taxable Base Amount

Contains the non- taxable amount in base currency.

PS_F_AP_LEDGER.NTAXL_BASE_AMT

Non-taxable R1 Amount

Contains the non- taxable amount in reporting 1 currency.

PS_F_AP_LEDGER.NTAXL_R1_AMT

Non-taxable R2 Amount

Contains the non- taxable amount in reporting 2 currency.

PS_F_AP_LEDGER.NTAXL_R2_AMT

Non-taxable Transaction Amount

Contains the non- taxable amount in transaction currency.

PS_F_AP_LEDGER.NTAXL_TRAN_AMT

Open Base Amount

Contains the open amount in base currency.

PS_F_AP_LEDGER.OPEN_BASE_AMT

Open R1 Amount

Contains the open amount in reporting 1 currency.

PS_F_AP_LEDGER.OPEN_R1_AMT

Open R2 Amount

Contains the open amount in reporting 2 currency.

PS_F_AP_LEDGER.OPEN_R2_AMT

Open Transaction Amount

Contains the open amount in transaction currency.

PS_F_AP_LEDGER.OPEN_TRAN_AMT

Payment Discount Base Amount

Contains the payment discount available amount in base currency

PS_F_AP_LEDGER.PDIAV_BASE_AMT

Payment Discount R1 Amount

Contains the payment available amount in reporting 1 currency

PS_F_AP_LEDGER.PDIAV_R1_AMT

Payment Discount R2 Amount

Contains the payment available amount in reporting 2 currency

PS_F_AP_LEDGER.PDIAV_R2_AMT

Payment Discount Transaction Amount

Contains the payment available amount in transaction currency

PS_F_AP_LEDGER.PDIAV_TRAN_AMT

Payment Discount Taken Base Amount

Contains the payment discount taken amount in base currency

PS_F_AP_LEDGER.PDITK_BASE_AMT

Payment Discount Taken R1 Amount

Contains the payment discount taken amount in reporting1 currency

PS_F_AP_LEDGER.PDITK_R1_AMT

Payment Discount Taken R2 Amount

Contains the payment discount taken amount in reporting2 currency.

PS_F_AP_LEDGER.PDITK_R2_AMT

Payment Discount Taken Transaction Amount

Contains the payment discount taken amount in transaction currency.

PS_F_AP_LEDGER.PDITK_TRAN_AMT

Payment Base Amount

Contains the payment amount in base currency.

PS_F_AP_LEDGER.PYMNT_BASE_AMT

Payment R1 Amount

Contains the payment amount in reporting 1 currency.

PS_F_AP_LEDGER.PYMNT_R1_AMT

Payment R2 Amount

Contains the payment amount in reporting 2 currency.

PS_F_AP_LEDGER.PYMNT_R2_AMT

Payment Transaction Amount

Contains the payment amount in transaction currency.

PS_F_AP_LEDGER.PYMNT_TRAN_AMT

Taxable Base Amount

Contains the taxable amount in base currency

PS_F_AP_LEDGER.TAXL_BASE_AMT

Taxable R1 Amount

Contains the taxable amount in reporting 1 currency

PS_F_AP_LEDGER.TAXL_R1_AMT

Taxable R2 Amount

Contains the taxable amount in reporting 2 currency

PS_F_AP_LEDGER.TAXL_R2_AMT

Taxable Transaction Amount

Contains the taxable amount in transaction currency

PS_F_AP_LEDGER.TAXL_TRAN_AMT

Tax Base Amount

Contains the tax amount in base currency.

PS_F_AP_LEDGER.TAX_BASE_AMT

Tax R1 Amount

Contains the tax amount in reporting 1 currency.

PS_F_AP_LEDGER.TAX_R1_AMT

Tax R2 Amount

Contains the tax amount in reporting 2 currency.

PS_F_AP_LEDGER.TAX_R2_AMT

Tax Transaction Amount

Contains the tax amount in transaction currency.

PS_F_AP_LEDGER.TAX_TRAN_AMT

Dimension Business Unit AP (Business Unit Accounts Payable)

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Transaction Date

A role-playing dimension based on dimension Day for transaction date.

PS_D_DAY

Dimension Supplier

Includes information on suppliers.

PS_D_SUPPLIER

Percentage of Matching Exception Analysis

This complex folder contains the distinct count of voucher IDs from AP Transaction table and Voucher Match Exception table. It is used to calculate the percentage of matching exception analysis.

AP Transaction Distinct Voucher

The distinct count of voucher identifier in AP Transaction table.

PS_F_AP_TRAN.VOUCHER_ID

Voucher Match Exp Distinct Voucher (Voucher Match Exp Distinct Voucher)

The distinct count of voucher identifiers in Voucher Match Exception fact table.

PS_F_VCHR_MTCH_EXP.VOUCHER_ID

Dimension Business Unit AP (Business Unit Accounts Payable

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Transaction Date

A role-playing dimension based on dimension Day for transaction date.

PS_D_DAY

Dimension Match Rule

Stores matching rules defined in the AP module to match AP invoices and purchase orders.

PS_D_MATCH_RULE

Dimension Person AP Operator

Includes details such name and contact details about the AP operator involved in handling the payments in the AP module.

PS_D_PERSON_APOPID

Dimension Supplier

Includes information on suppliers.

PS_D_SUPPLIER

Fact Voucher Match Exceptions

Contains information about all failed transactions of the AP matching process. You can use this fact to report on the number of exceptions generated by the process, by supplier and AP operator ID.

PS_F_VCHR_MTCH_EXP

Percentage of Matching Exception Analysis

This complex folder contains the distinct count of voucher IDs from the AP Transaction table and voucher match exception table. It is used for percentage of matching exception analysis.

AP Transaction Distinct Count Voucher

The distinct count of voucher identifier in AP transaction table.

PS_F_AP_TRAN.VOUCHER_ID

Match Exception Count

Represents the vouchers that failed in the process of matching vouchers and AP operator IDs.

PS_F_VCHR_MTCH_EXP.MTCH_EXCPT_CNT

Voucher Match Exception Distinct Voucher

The distinct count of voucher identifiers in Voucher Match Exception fact table.

PS_F_VCHR_MTCH_EXP.VOUCHER_ID

Dimension AP Document Type

Includes details about various AP document types, such as payables prepayments, payables adjustments, and payables accruals.

PS_D_AP_DOC_TYPE

Dimension AP Payment Transaction Status

Includes the AP transaction status from a payment perspective. Examples of status values include paid, stopped, and void.

PS_D_AP_PTR_STAT

Dimension AP Payment Transaction Type

Includes AP transaction types from a payment perspective. Examples of types include express payment, manual payment, and regular payment.

PS_D_AP_PTR_TYPE

Dimension AP Posting Status

Includes AP posting status. Status values include posted, unposted, payment not applied, and so on.

PS_D_APPOST_STATUS

Dimension AP Voucher Transaction Status

Includes AP voucher transaction status. Examples of status values include approved, denied, and pending.

PS_D_AP_VTR_STAT

Dimension AP Voucher Transaction Type

Includes AP voucher transaction types. Types include adjustment voucher, prepaid voucher, and so on.

PS_D_AP_VTR_TYPE

Dimension APAR Transaction Type

Includes AP and AR transaction types. Types are voucher, receipt, payment, and so on.

PS_D_APAR_TRN_TYPE

Dimension Bank Account

Includes details about bank and bank account information.

PS_D_BANK_ACCT

Dimension Business Unit AP

A role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY

Dimension Day Discount Due Date

A role-playing dimension based on dimension Day for discount due date.

PS_D_DAY

Dimension Day Due Pay Date

A role-playing dimension based on dimension Day for due pay date.

PS_D_DAY

Dimension Day Transaction Date

A role-playing dimension based on dimension Day for transaction date.

PS_D_DAY

Dimension Payment Method

Includes details about various methods of payment such as check, cash, and credit card.

PS_D_PYMNT_MTHD

Dimension Payment Terms

Includes information about various payment terms such as net 30 days and due first of month.

PS_D_PYMNT_TRMS

Dimension Person AP Operator

Includes details such name and contact details about the AP operator involved in handling the payments in the AP module.

PS_D_PERSON_APOPID

Dimension Supplier

Includes information on suppliers.

PS_D_SUPPLIER

Dimension Supplier Remit Supplier

Includes information on “remit to” suppliers.

PS_D_SUPPLIER

Fact AP Transaction

Contains the summary of accounts payable transactional information at a header level. You can use this fact to analyze vouchers and payments made by a specific supplier. Various amounts information such as Paid, Open, Discount, and Late Change are available

PS_F_AP_TRAN

Adjustment Base Amount

Contains the adjustment amount in base currency.

PS_F_AP_TRAN.ADJ_BASE_AMT

Adjustment Count

The count of number of Adjustments.

PS_F_AP_TRAN.ADJ_COUNT

Adjustment R1 Amount

Contains the adjustment amount in reporting 1 currency.

PS_F_AP_TRAN.ADJ_R1_AMT

Adjustment R2 Amount

Contains the adjustment amount in reporting 2 currency.

PS_F_AP_TRAN.ADJ_R2_AMT

Adjustment Transaction Amount

Contains the adjustment amount in transaction currency.

PS_F_AP_TRAN.ADJ_TRAN_AMT

Discount Lost On Paid Base Amount

Contains the discount lost on paid amount in base currency

PS_F_AP_TRAN.DILS_BASE_AMT

Discount Lost On Paid R1 Amount

Contains the discount lost on paid amount in reporting 1 currency.

PS_F_AP_TRAN.DILS_R1_AMT

Discount Lost On Paid R2 Amount

Contains the discount lost on paid amount in reporting 2 currency.

PS_F_AP_TRAN.DILS_R2_AMT

Discount Lost On Paid Transaction Amount

Contains the discount lost on paid amount in transaction currency.

PS_F_AP_TRAN.DILS_TRAN_AMT

Discount On Paid Base Amount

Contains the discount on paid amount in base currency.

PS_F_AP_TRAN.DIPD_BASE_AMT

Discount On Paid R1 Amount

Contains the discount on paid amount in reporting 1 currency.

PS_F_AP_TRAN.DIPD_R1_AMT

Discount On Paid R2 Amount

Contains the discount on paid amount in reporting 2 currency.

PS_F_AP_TRAN.DIPD_R2_AMT

Discount On Paid Transaction Amount

Contains the discount on paid amount in transaction currency.

PS_F_AP_TRAN.DIPD_TRAN_AMT

Discount Eligible Base Amount

Contains the discount eligible in base currency.

PS_F_AP_TRAN.DISE_BASE_AMT

Discount Eligible R1 Amount

Contains the discount eligible in reporting currency 1.

PS_F_AP_TRAN.DISE_R1_AMT

Discount Eligible R2 Amount

Contains the discount eligible in reporting currency 2.

PS_F_AP_TRAN.DISE_R2_AMT

Discount Eligible Transaction Amount

Contains the discount eligible in transaction currency.

PS_F_AP_TRAN.DISE_TRAN_AMT

Gross Paid Base Amount

Contains the gross paid amount in base currency.

PS_F_AP_TRAN.GRPD_BASE_AMT

Gross Paid R1 Amount

Contains the gross paid amount in reporting 1 currency.

PS_F_AP_TRAN.GRPD_R1_AMT

Gross Paid R2 Amount

Contains the gross paid amount in reporting 2 currency.

PS_F_AP_TRAN.GRPD_R2_AMT

Gross Paid Transaction Amount

Contains the gross paid amount in transaction currency.

PS_F_AP_TRAN.GRPD_TRAN_AMT

Late Charge Base Amount

Contains the late charge amount in base currency.

PS_F_AP_TRAN.LTCH_BASE_AMT

Late Charge R1 Amount

Contains the late charge amount in reporting 1 currency.

PS_F_AP_TRAN.LTCH_R1_AMT

Late Charge R2 Amount

Contains the late charge amount in reporting 2 currency.

PS_F_AP_TRAN.LTCH_R2_AMT

Late Charge Transaction Amount

Contains the late charge amount in transaction currency.

PS_F_AP_TRAN.LTCH_TRAN_AMT

Late Charge Denied Base Amount

Contains the late charge denied amount in base currency.

PS_F_AP_TRAN.LTDN_BASE_AMT

Late Charge Denied R1 Amount

Contains the late charge denied base amount in reporting 1 currency.

PS_F_AP_TRAN.LTDN_R1_AMT

Late Charge Denied R2 Amount

Contains the late charge denied base amount in reporting 2 currency.

PS_F_AP_TRAN.LTDN_R2_AMT

Late Charge Denied Transaction Amount

Contains the late charge denied base amount in transaction currency.

PS_F_AP_TRAN.LTDN_TRAN_AMT

Late Charge Paid Base Amount

Contains the late charge paid amount in base currency.

PS_F_AP_TRAN.LTPD_BASE_AMT

Late Charge Paid R1 Amount

Contains the late charge paid amount in reporting 1 currency.

PS_F_AP_TRAN.LTPD_R1_AMT

Late Charge Paid R2 Amount

Contains the late charge paid amount in reporting 2 currency.

PS_F_AP_TRAN.LTPD_R2_AMT

Late Charge Paid Transaction Amount

Contains the late charge paid amount in transaction currency

PS_F_AP_TRAN.LTPD_TRAN_AMT

Open Base Amount

Contains the open amount in base currency.

PS_F_AP_TRAN.OPEN_BASE_AMT

Open R1 Amount

Contains the open amount in reporting 1 currency.

PS_F_AP_TRAN.OPEN_R1_AMT

Open R2 Amount

Contains the open amount in reporting 2 currency.

PS_F_AP_TRAN.OPEN_R2_AMT

Open Transaction Amount

Contains the open amount in transaction currency.

PS_F_AP_TRAN.OPEN_TRAN_AMT

Original Payment Count

Contains the count of original payment per voucher.

PS_F_AP_TRAN.ORIG_PYMNT_CNT

Paid Base Amount

Contains the paid amount in base currency.

PS_F_AP_TRAN.PAID_BASE_AMT

Paid R1 Amount

Contains the paid amount in reporting 1 currency.

PS_F_AP_TRAN.PAID_R1_AMT

Paid R2 Amount

Contains the paid amount in reporting 2 currency.

PS_F_AP_TRAN.PAID_R2_AMT

Paid Transaction Amount

Contains the paid amount in transaction currency.

PS_F_AP_TRAN.PAID_TRAN_AMT

Prepaid Applied Payment

Contains the prepaid applied payment per voucher.

PS_F_AP_TRAN.PREPAID_APPL_PYMNT

Payment Count

Contains the count of payments per voucher.

PS_F_AP_TRAN.PYMNT_CNT

Payment Count Related

Contains the count of related payments per voucher.

PS_F_AP_TRAN.PYMNT_CNT_RELATED

Payment Held Count

Contains the count of payments held.

PS_F_AP_TRAN.PYMNT_HELD_CNT

Payment Type Express Count

Contains the count of payment type − Express.

PS_F_AP_TRAN.PYMNT_TYP_E_CNT

Payment Type Manual Count

Contains the count of payment type − Manual.

PS_F_AP_TRAN.PYMNT_TYP_M_CNT

Payment Type Regular Count

Contains the count of payment type - Regular

PS_F_AP_TRAN.PYMNT_TYP_R_CNT

Payment Type Withheld Count

Contains the count of payment type - Withheld

PS_F_AP_TRAN.PYMNT_TYP_W_CNT

Payment Type Zero Payment Count

Contains the count of payment type - Zero Payment Checks

PS_F_AP_TRAN.PYMNT_TYP_Z_CNT

Transaction Base Amount

Contains the transaction amount in base currency.

PS_F_AP_TRAN.TRAN_BASE_AMT

Transaction Count

Contains the count of number of transactions.

PS_F_AP_TRAN.TRAN_COUNT

Transaction R1 Amount

Contains the transaction amount in reporting 1 currency.

PS_F_AP_TRAN.TRAN_R1_AMT

Transaction R2 Amount

Contains the transaction amount in reporting 2 currency.

PS_F_AP_TRAN.TRAN_R2_AMT

Transaction Amount

Contains the transaction amount in transaction currency

PS_F_AP_TRAN.TRAN_TRAN_AMT

Withheld Payment Count

Contains the count of withheld payment per voucher.

PS_F_AP_TRAN.WTHD_PYMNT_CNT

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Alternate Account

Includes alternate accounts that are used as an alternate to the original accounts. This dimension can be used for internal reporting.

PS_D_ALTACCT

Dimension Book Code

Includes details about book codes that represent an account attribute and a balancing ChartField.

PS_D_BOOK_CODE

Dimension Budget Reference

Includes a description relating to budgets.

PS_D_BUDGET_REF

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Affiliate

The affiliate business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension ChartField1

Includes user defined ChartField details.

PS_D_ChartField1

Dimension ChartField2

Includes user defined ChartField details.

PS_D_ChartField2

Dimension ChartField3

Includes user defined ChartField details.

PS_D_ChartField3

Dimension Class Field

Includes expense classification codes and descriptions.

PS_D_CLASS_FIELD

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Post Date

The post date day dimension is a role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Fund

Includes details about fund codes and their description.

PS_D_FUND

Dimension Fund Affiliate

Includes details about affiliate fund codes and their description.

PS_D_FUND

Dimension GL Adjustment Type

Includes types of GL adjustments.

PS_D_GL_ADJ_TYPE

Dimension GL Offset

Includes information on GL offset. It is used to group billing information, such as office rent and retail rent.

PS_D_GL_OFFSET

Dimension Journal Source

Includes details about the source of journal entries created in the general ledger.

PS_D_JRNL_SOURCE

Dimension Ledger

Includes the ID and description of ledgers that are defined based on templates. Detailed information about E1 ledger type such as 'AA-Actual Amount' and 'BA-Budgeting Amount' are also stored.

PS_D_LEDGER

Dimension Operating Unit

Includes details about operating units, such as a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Operating Unit Affiliate

Includes details about affiliate operating units.

PS_D_OPER_UNIT

Dimension Pattern Day Journal

The pattern (fiscal) day journal dimension is a role-playing dimension based on the pattern day dimension.

PS_D_PATTERN_DAY

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Program FDM

Keeps track of programs in the Financial Data Mart that can be tracked in the general ledger.

PS_D_PROGRAM_FDM

Dimension Project

Includes information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Dimension Scenario

Includes details of historical budgeting and forecast scenarios.

PS_D_SCENARIO

Dimension Statistics Code

Includes details about statistical information such as floor space, full-time equivalent workdays, shipment size, and so on. These items can be associated with a monetary account.

PS_D_STAT_CODE

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Fact AR Account Line

This fact contains all accounts receivable accounting entries. You can use this fact to answer questions related to the journal amount posted to general ledger for the selected accounts receivable accounts by accounts receivable transactions.

PS_F_AR_ACCOUNT_LN

Age Range

Contains the age classification of the employee.

PS_D_PERSON.BIRTH_DT_SID

Age

Contains the age of the employee.

PS_D_PERSON.BIRTH_DT_SID

Birth Date

Contains date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Death Date

Contains the date of death of a person.

PS_D_PERSON.DEATH_DT_SID

Number of Years Experience

Contains the years of work experience of the person.

PS_D_PERSON.EXP_YR_NUM

Benefit Amount

Contains the benefit amount.

PS_D_PRJ.BNFT_AMT

Benefit R1 Amount (Benefit Reporting 1 Amount)

Contains the reporting 1 benefit amount.

PS_D_PRJ.BNFT_R1_AMT

Benefit R2 Amount (Benefit Reporting 2 Amount)

Contains the reporting 2 benefit amount.

PS_D_PRJ.BNFT_R2_AMT

Discount Rate

Used to calculate the estimated net present value and the estimated return on investment.

PS_D_PRJ.DSCNT_RT

Maintenance Cost Amount

Contains the project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_AMT

Maintenance Cost R1 Amount

Contains the reporting 1 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R1_AMT

Maintenance Cost R2 Amount

Contains the reporting 2 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R2_AMT

NPV Amount

Contains the estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_AMT

NPV R1 Amount

Contains the reporting 1 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R1_AMT

NPV R2 Amount

Contains the reporting 2 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R2_AMT

Project Cost Amount

Contains the project estimated cost amount.

PS_D_PRJ.PRJ_CST_AMT

Project Cost R1 Amount

Contains the reporting 1 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R1_AMT

Project Cost R2 Amount

Contains the reporting 2r project estimated cost amount.

PS_D_PRJ.PRJ_CST_R2_AMT

ROI Amount

Contains the estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_AMT

ROI R1 Amount

Contains the reporting 1 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R1_AMT

ROI R2 Amount

Contains the reporting 2 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R2_AMT

Journal Base Amount

Contains the journal monetary amount in base currency. Journal monetary amount. With this fact, you can answer questions such as "What is the journal amount posted to the general ledger for the selected accounts receivable account by accounts receivable transactions?"

PS_F_AR_ACCOUNT_LN.JRNL_BASE_AMT

Journal R1 Amount

Contains the journal monetary amount in reporting 1 currency.

PS_F_AR_ACCOUNT_LN.JRNL_R1_AMT

Journal R2 Amount

Contains the journal monetary amount in reporting 2 currency.

PS_F_AR_ACCOUNT_LN.JRNL_R2_AMT

Journal Statistics Amount

Contains the journal statistics amount in Enterprise Warehouse (EW) currency.

PS_F_AP_ACCOUNT_LN.JRNL_STAT_EW_AMT

Journal Transaction Amount

Contains the journal monetary amount in transaction currency. With this fact, you can answer questions such as "What is the journal amount posted to the general ledger for the selected accounts receivable account by accounts receivable transactions?"

PS_F_AR_ACCOUNT_LN.JRNL_TRAN_AMT

Total AR Aging Balance

Used to calculate the grand total of the aging balance that is insensitive to any filter or prompt and items on the report.

Dimension Aging Category

Includes aging categories used in accounts payable and accounts receivable aging analysis. The AP AR indicator item classifies the aging category as AP or AR.

PS_D_AGING_CTGRY

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Credit Class

Includes credit class details.

PS_D_CREDIT_CLASS

Dimension Credit Risk

Classifies credit risk values as high, low and medium.

PS_D_CREDIT_RISK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Person AR Collector

Includes details such as name and contact details about the accounts receivable collector involved in collecting the receivables amount in the accounts receivable module.

PS_D_PERSON_COLTR

Dimension Person AR Credit Analyst

Includes details such as name and contact details about the accounts receivable credit analyst involved in handling the credits given to customers.

PS_D_PERSON_CRNYST

Dimension Person AR Specialist

Includes details such as name and contact details about the accounts receivable specialist involved in handling the disputes and deductions in the accounts receivable module.

PS_D_PERSON_ARSPL

Dimension Person Sales Person

This role-playing dimension based on Person dimension includes the most current sales personal information of both employees of an organization.

PS_D_PERSON

Fact AR Aging

This fact contains the aging information by aging category and customer. Use this fact to answer questions such as “What percentage is past due?” and “What money is owned in a period?"

PS_F_AR_AGING

Total Balance Base Amount

Contains the balance amount in base currency. It is used to calculate the grand total of the aging balance that is insensitive to any filter or prompt and items on the report.

TOTAL_BAL_BASE_AMT

Birth Date

Contains date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Balance Base Amount

The balance amount in base currency.

PS_F_AP_AGING.BAL_BASE_AMT

Balance R1 Amount

Contains the balance amount in reporting 1 currency. It is the amount that is outstanding for that aging category.

PS_F_AR_AGING.BAL_R1_AMT

Balance R2 Amount

Contains the balance amount in reporting 2 currency. It is the amount that is outstanding for that aging category.

PS_F_AR_AGING.BAL_R2_AMT

Balance Transaction Amount

Contains the balance amount in transaction currency. It is the amount that is outstanding for that aging category.

PS_F_AR_AGING.BAL_TRAN_AMT

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Credit Class

Includes credit class details.

PS_D_CREDIT_CLASS

Dimension Credit Risk

Classifies credit risk values as high, low and medium.

PS_D_CREDIT_RISK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Person AR Collector

Includes details such as name and contact details about the accounts receivable collector involved in collecting the receivables amount in the accounts receivable module.

PS_D_PERSON_COLTR

Dimension Person AR Credit Analyst

Includes details such as name and contact details about the accounts receivable credit analyst involved in handling the credits given to customers.

PS_D_PERSON_CRNYST

Dimension Person AR Deduction Manager

Includes the accounts receivable deduction manager name and contact information.

PS_D_PERSON_DEDMGR

Dimension Person AR Specialist

Includes details such name and contact details about the accounts receivable specialist involved in handling the disputes and deductions in the accounts receivable module.

PS_D_PERSON_ARSPL

Fact Credit Limit

This fact contains information about credit allocated to a customer based on the customer’s credit rating. Use this fact to answer questions such as "What is the customer credit limit percentage over limit?"

PS_F_CREDIT_LIMIT

Actual Credit Limit Range

Contains the actual customer credit limit range.

PS_F_CREDIT_LIMIT.ACTL_CR_LMT_R

AR Outstanding Base Amount

Contains the accounts receivable outstanding amount in base currency.

PS_F_CREDIT_LIMIT.AR_OUT_BASE_AMT

AR Outstanding Credit Amount

Contains the accounts receivable outstanding amount in credit limit currency.

PS_F_CREDIT_LIMIT.AR_OUT_CR_AMT

AR Outstanding R1 Amount

Contains the accounts receivable outstanding amount in reporting 1 currency. Use this fact to answer questions such as "What is the outstanding balance for a customer with respect to the customer's credit limit?"

PS_F_CREDIT_LIMIT.AR_OUT_RPT1_AMT

AR Outstanding R2 Amount

Contains the accounts receivable outstanding amount in reporting 2 currency.

PS_F_CREDIT_LIMIT.AR_OUT_RPT2_AMT

Corporate Actual Credit Limit Range

Contains the actual corporate credit limit range.

PS_F_CREDIT_LIMIT.CORP_ACTL_CR_LMT_R

Corporate Available Credit Amount

Contains the available corporate credit amount in credit limit currency.

PS_F_CREDIT_LIMIT.CORP_AVL_CR_AMT

Corporate Available Credit R1 Amount

Contains the available corporate credit amount in reporting currency 1.

PS_F_CREDIT_LIMIT.CORP_AVL_CR_R1_AMT

Corporate Available Credit R2 Amount

Contains the available corporate credit amount in reporting currency 2.

PS_F_CREDIT_LIMIT.CORP_AVL_CR_R2_AMT

Corporate Credit Limit Amount

Contains the corporate credit limit amount, plus the percent over the limit in customer credit currency.

PS_F_CREDIT_LIMIT.CORP_CR_LMT_AMT

Corporate Credit Limit R1 Amount

Contains the corporate credit limit amount in reporting 1 currency.

PS_F_CREDIT_LIMIT.CORP_CR_LMT_R1_AMT

Corporate Credit Limit R2 Amount

Contains the corporate credit limit amount in reporting 2 currency.

PS_F_CREDIT_LIMIT.CORP_CR_LMT_R2_AMT

Corporate Credit Limit Range

Contains the percentage that represents a comfort level that is relative to the corporate customer's credit limit.

PS_F_CREDIT_LIMIT.CORP_CR_LMT_RANGE

Corporate Credit Percentage Over

Contains the percentage by which corporate customers are allowed to exceed their credit limits before hold processing takes effect.

PS_F_CREDIT_LIMIT.CORP_CR_PCT_OVR

Credit Limit Amount

Contains the credit limit amount in credit limit currency.

PS_F_CREDIT_LIMIT.CR_LMT_AMT

Credit Limit Corporate

Contains the corporate credit limit amount in credit limit currency.

PS_F_CREDIT_LIMIT.CR_LMT_CORP

Customer Credit Limit Range

Contains the percentage that represents a comfort level that is relative to the customer's credit limit.

PS_F_CREDIT_LIMIT.CR_LMT_RANGE

Customer Available Credit Amount

Contains the available customer credit amount in credit limit currency.

PS_F_CREDIT_LIMIT.CUST_AVL_CR_AMT

Customer Available Credit R1 Amount

Contains the available customer credit amount in reporting currency 1.

PS_F_CREDIT_LIMIT.CUST_AVL_CR_R1_AMT

Customer Available Credit R2 Amount

Contains the available customer credit amount in reporting currency 2.

PS_F_CREDIT_LIMIT.CUST_AVL_CR_R2_AMT

Customer Credit Limit Amount

Contains the customer credit limit amount, plus the percentage over limit in customer credit currency.

PS_F_CREDIT_LIMIT.CUST_CR_LMT_AMT

Customer Credit Limit R1 Amount

Contains the customer credit limit amount in reporting 1 currency.

PS_F_CREDIT_LIMIT.CUST_CR_LMT_R1_AMT

Customer Credit Limit R2 Amount

Contains the customer credit limit amount in reporting 2 currency.

PS_F_CREDIT_LIMIT.CUST_CR_LMT_R2_AMT

Customer Credit Percentage Over

Contains the percentage by which customers are allowed to exceed their credit limits before hold processing takes effect.

PS_F_CREDIT_LIMIT.CUST_CR_PCT_OVR

Dimension AB Master Alternate Payee

Contains the address book master dimension for alternate payee. This is the second choice if the payee is not available.

PS_D_AB_MASTER

Dimension APAR Transaction Type

Includes accounts payable and accounts receivable transaction types. Examples of types are voucher, receipt, and payment.

PS_D_APAR_TRN_TYPE

Dimension AR Document Type

Includes details about various accounts receivable document types, such as receivables adjustments and receivables revaluation.

PS_D_AR_DOC_TYPE

Dimension AR Item Transaction Type

Includes accounts receivable item transaction types.

PS_D_AR_ITR_TYPE

Dimension AR Payment Transaction Type

Includes accounts receivable payment transaction types.

PS_D_AR_PTR_TYPE

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Close Date

A role-playing dimension based on dimension Day for close date.

PS_D_DAY

Dimension Day Discount Due Date

A role-playing dimension based on dimension Day for discount due date.

PS_D_DAY

Dimension Day Due Date

A role-playing dimension based on dimension Day for due date.

PS_D_DAY

Dimension Day GL Date

A role-playing dimension based on dimension Day for general ledger date.

PS_D_DAY

Dimension Day Invoice Date

A role-playing dimension based on dimension Day for invoice date.

PS_D_DAY

Dimension Day Notify Payment Date

A role-playing dimension based on dimension Day for notify payment date.

PS_D_DAY

Dimension Day Statement Date

A role-playing dimension based on dimension Day for accounts receivable statement date.

PS_D_DAY

Dimension Det Period

Detail Period dimension

PS_D_DET_PERIOD

Dimension GL Offset

Includes information on GL offset account from the transaction. Offset Accounts “offset” the debit or credit entry in a transaction.

PS_D_GL_OFFSET

Dimension Payment Method

Includes the details about various methods of payment, such as check, cash, and credit card.

PS_D_PYMNT_MTHD

Dimension Payment Status

Includes information on all voucher payment statuses.

PS_D_PYMT_STATUS

Dimension Payment Terms

Includes information about various payment terms such as net 30 days and due first of month.

PS_D_PYMNT_TRMS

Dimension Person AR Specialist

Includes details such name and contact details about the accounts receivable specialist involved in handling the disputes and deductions in the accounts receivable module.

PS_D_PERSON_ARSPL

Dimension Subledger

Includes information on sub ledgers. A sub ledger is used to group the accounting information in various ways.

PS_D_SUBLEDGER

Dimension Tenant

Includes detailed information about tenants.

PS_D_TENANT

Dimension Unit

Includes information on units, that is, detail information of real estate properties.

PS_D_UNIT

Fact Customer Ledger

Stores information on account receivables detailed customer ledger fact. It captures the detail AR transactions at line item level.

PS_F_CUST_LEDGER

Distinct Unit

Contains the distinct count of units.

PS_D_UNIT.UNIT_ID

Adjustment Base Amount

Contains the adjustment amount in base currency.

PS_F_CUST_LEDGER.ADJ_BASE_AMT

Adjustment Count

Count on number of adjustments.

PS_F_CUST_LEDGER.ADJ_CNT

Adjustment R1 Amount

Contains the adjustment amount in reporting1 currency.

PS_F_CUST_LEDGER.ADJ_R1_AMT

Adjustment R2 Amount

Contains the adjustment amount in reporting 2 currency.

PS_F_CUST_LEDGER.ADJ_R2_AMT

Chargeback Base Amount

Contains the payment chargeback amount in base currency.

PS_F_CUST_LEDGER.CHARBK_BASE_AMT

Chargeback R1 Amount

Contains the payment chargeback amount in reporting1 currency.

PS_F_CUST_LEDGER.CHARBK_R1_AMT

Chargeback R2 Amount

Contains the payment chargeback amount in reporting 2 currency.

PS_F_CUST_LEDGER.CHARBK_R2_AMT

Deduct Base Amount

Contains the payment deduction amount in base currency.

PS_F_CUST_LEDGER.DEDUCT_BASE_AMT

Deduct R1 Amount

Contains the payment deduction amount in reporting1 currency.

PS_F_CUST_LEDGER.DEDUCT_R1_AMT

Deduct R2 Amount

Contains the payment deduction amount in reporting 2 currency.

PS_F_CUST_LEDGER.DEDUCT_R2_AMT

Discount Available Base Amount

Contains the discount available amount in base currency.

PS_F_CUST_LEDGER.DIAV_BASE_AMT

Discount Available R1 Amount

Contains the discount available amount in reporting 1 currency.

PS_F_CUST_LEDGER.DIAV_R1_AMT

Discount Available R2 Amount

Contains the discount available amount in reporting 2 currency.

PS_F_CUST_LEDGER.DIAV_R2_AMT

Discount Available Transaction Amount

Contains the discount available amount in transaction currency.

PS_F_CUST_LEDGER.DIAV_TRAN_AMT

Discount Taken Base Amount

Contains the discount taken amount in base currency.

PS_F_CUST_LEDGER.DITK_BASE_AMT

Discount Taken R1 Amount

Contains the discount taken amount in reporting 1 currency.

PS_F_CUST_LEDGER.DITK_R1_AMT

Discount Taken R2 Amount

Contains the discount taken amount in reporting 2 currency.

PS_F_CUST_LEDGER.DITK_R2_AMT

Discount Taken Transaction Amount

Contains the discount taken amount in transaction currency.

PS_F_CUST_LEDGER.DITK_TRAN_AMT

Gain/Loss Base Amount

Contains the gain or loss amount in base currency.

PS_F_CUST_LEDGER.GNLS_BASE_AMT

Gain/Loss R1 Amount

Contains the gain or loss amount in reporting 1 currency

PS_F_CUST_LEDGER.GNLS_R1_AMT

Gain/Loss R2 Amount

Contains the gain or loss amount in reporting 2 currency

PS_F_CUST_LEDGER.GNLS_R2_AMT

Gross Base Amount

Contains the gross amount in base currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_CUST_LEDGER.GROSS_BASE_AMT

Gross R1 Amount

Contains the gross amount in reporting 1 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_CUST_LEDGER.GROSS_R1_AMT

Gross R2 Amount

Contains the gross amount in reporting 2 currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_CUST_LEDGER.GROSS_R2_AMT

Gross Transaction Amount

Contains the gross amount in transaction currency. This is the amount that is outstanding to suppliers for that aging category. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_CUST_LEDGER.GROSS_TRAN_AMT

None Taxable Base Amount

Contains the none taxable amount in base currency.

PS_F_CUST_LEDGER.NTAXL_BASE_AMT

None Taxable R1 Amount

Contains the none taxable amount in reporting1 currency.

PS_F_CUST_LEDGER.NTAXL_R1_AMT

None Taxable R2 Amount

Contains the none taxable amount in reporting 2 currency.

PS_F_CUST_LEDGER.NTAXL_R2_AMT

None Taxable Transaction Amount

Contains the none taxable amount in transaction currency.

PS_F_CUST_LEDGER.NTAXL_TRAN_AMT

Open Base Amount

Contains the open amount in base currency.

PS_F_CUST_LEDGER.OPEN_BASE_AMT

Open R1 Amount

Contains the open amount in reporting 1 currency.

PS_F_CUST_LEDGER.OPEN_R1_AMT

Open R2 Amount

Contains the open amount in reporting 2 currency.

PS_F_CUST_LEDGER.OPEN_R2_AMT

Open Transaction Amount

Contains the open amount in transaction currency.

PS_F_CUST_LEDGER.OPEN_TRAN_AMT

Payment Discount Available Base Amount

Contains the payment discount available amount in base currency.

PS_F_CUST_LEDGER.PDIAV_BASE_AMT

Payment Discount Available R1 Amount

Contains the payment discount available amount in reporting1 currency.

PS_F_CUST_LEDGER.PDIAV_R1_AMT

Payment Discount Available R2 Amount

Contains the payment discount available amount in reporting 2 currency.

PS_F_CUST_LEDGER.PDIAV_R2_AMT

Payment Discount Taken Base Amount

Contains the payment discount taken amount in base currency

PS_F_CUST_LEDGER.PDITK_BASE_AMT

Payment Discount Taken R1 Amount

Contains the payment discount taken amount in reporting1 currency

PS_F_CUST_LEDGER.PDITK_R1_AMT

Payment Discount Taken R2 Amount

Contains the payment discount taken amount in reporting2 currency

PS_F_CUST_LEDGER.PDITK_R2_AMT

Payment Base Amount

Contains the payment amount in base currency.

PS_F_CUST_LEDGER.PYMNT_BASE_AMT

Payment R1 Amount

Contains the payment amount in reporting1 currency.

PS_F_CUST_LEDGER.PYMNT_R1_AMT

Payment R2 Amount

Contains the payment amount in reporting2 currency.

PS_F_CUST_LEDGER.PYMNT_R2_AMT

Taxable Base Amount

Contains the taxable amount in base currency

PS_F_CUST_LEDGER.TAXL_BASE_AMT

Taxable R1 Amount

Contains the taxable amount in reporting1 currency

PS_F_CUST_LEDGER.TAXL_R1_AMT

Taxable R2 Amount

Contains the taxable amount in reporting2 currency

PS_F_CUST_LEDGER.TAXL_R2_AMT

Taxable Transaction Amount

Contains the taxable amount in transaction currency

PS_F_CUST_LEDGER.TAXL_TRAN_AMT

Tax Base Amount

Contains the tax amount in base currency.

PS_F_CUST_LEDGER.TAX_BASE_AMT

Tax R1 Amount

Contains the tax amount in reporting 1 currency.

PS_F_CUST_LEDGER.TAX_R1_AMT

Tax R2 Amount

Contains the tax amount in reporting 2 currency.

PS_F_CUST_LEDGER.TAX_R2_AMT

Tax Transaction Amount

Contains the tax amount in transaction currency.

PS_F_CUST_LEDGER.TAX_TRAN_AMT

Writeoff Base Amount

Contains the payment write-off amount in base currency.

PS_F_CUST_LEDGER.WRTOFF_BASE_AMT

Writeoff R1 Amount

Contains the payment write-off amount in reporting1 currency

PS_F_CUST_LEDGER.WRTOFF_R1_AMT

Writeoff R2 Amount

Contains the payment write-off amount in reporting2 currency

PS_F_CUST_LEDGER.WRTOFF_R2_AMT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Credit Class

Includes credit class information that provides detail description on different levels of credit classification.

PS_D_CREDIT_CLASS

Dimension Credit Risk

Classifies credit risk values as high, low and medium.

PS_D_CREDIT_RISK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Supplier

Includes information on suppliers.

PS_D_SUPPLIER

Fact APAR Netting

Contains information about the AR amount outstanding from a customer and the AP amount outstanding from the company to that customer (if that customer is also a supplier to the company).

PS_F_APAR_NETTING

AP Outstanding Base Amount

Contains the AP amount that is outstanding to suppliers for that aging category in base currency. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_APAR_NETTING.AP_OUT_BASE_AMT

AP Outstanding R1 Amount

Contains the AP amount that is outstanding to suppliers for that aging category in reporting 1 currency. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_APAR_NETTING.AP_OUT_RPT1_AMT

AP Outstanding R2 Amount

Contains the AP amount that is outstanding to suppliers for that aging category in reporting 2 currency. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_APAR_NETTING.AP_OUT_RPT2_AMT

AP Outstanding Transaction Amount

Contains the AP amount that is outstanding to suppliers for that aging category in transaction currency. Use this fact to answer questions such as "What is the highest balance for a supplier?"

PS_F_APAR_NETTING.AP_OUT_TRAN_AMT

AR Outstanding Base Amount

Contains the accounts receivable outstanding amount in base currency. Use this fact to answer questions such as "What is the outstanding balance for a customer with respect to the customer's credit limit?"

PS_F_APAR_NETTING.AR_OUT_BASE_AMT

AR Outstanding R1 Amount

Contains the accounts receivable outstanding amount in reporting 1 currency. Use this fact to answer questions such as "What is the outstanding balance for a customer with respect to the customer's credit limit?"

PS_F_APAR_NETTING.AR_OUT_RPT1_AMT

AR Outstanding R2 Amount

Contains the accounts receivable outstanding amount in reporting 2 currency. Use this fact to answer questions such as "What is the outstanding balance for a customer with respect to the customer's credit limit?"

PS_F_APAR_NETTING.AR_OUT_RPT2_AMT

AR Outstanding Transaction Amount

Contains the accounts receivable outstanding amount in transaction currency. Use this fact to answer "What is the outstanding balance for a customer with respect to the customer's credit limit?"

PS_F_APAR_NETTING.AR_OUT_TRAN_AMT

Net Outstanding Base Amount

Contains the net outstanding amount (difference between the AP outstanding amount and AR outstanding amount) in base currency. This fact helps you to answer questions such as "What is the AR-AP netting balance amount for customers who are also suppliers."

PS_F_APAR_NETTING.NET_OUT_BASE_AMT

Net Outstanding R1 Amount

Contains the net outstanding amount (difference between the AP outstanding amount and AR outstanding amount) in reporting 1 currency. This fact helps you to answer questions such as "What is the AR-AP netting balance amount for customers who are also suppliers."

PS_F_APAR_NETTING.NET_OUT_RPT1_AMT

Net Outstanding R2 Amount

Contains the net outstanding amount (difference between the AP outstanding amount and AR outstanding amount) in reporting 2 currency. This fact helps you to answer questions such as "What is the AR-AP netting balance amount for customers who are also suppliers."

PS_F_APAR_NETTING.NET_OUT_RPT2_AMT

Net Outstanding Transaction Amount

Contains the net outstanding amount (difference between the AP outstanding amount and AR outstanding amount) in transaction currency. This fact helps you to answer questions such as "What is the AR-AP netting balance amount for customers who are also suppliers."

PS_F_APAR_NETTING.NET_OUT_TRAN_AMT

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Credit Class

Includes credit class details.

PS_D_CREDIT_CLASS

Dimension Credit Risk

Classifies credit risk values as high, low and medium.

PS_D_CREDIT_RISK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Det Period

Detail Period dimension.

PS_D_DET_PERIOD

Dimension Person AR Collector

Includes details such as name and contact details about the accounts receivable collector involved in collecting the receivables amount in the accounts receivable module.

PS_D_PERSON_COLTR

Dimension Person AR Credit Analyst

Includes details such as name and contact details about the accounts receivable credit analyst involved in handling the credits given to customers.

PS_D_PERSON_CRNYST

Dimension Person Sales Person

This role-playing dimension based on person dimension includes the most current sales personal information of both employees of an organization.

PS_D_PERSON

Fact AR Days Sales Outstanding

Contains days sales outstanding (DSO) information for accounting periods. Use this fact to analyze the average time taken to turn the receivables into cash.

PS_F_AR_DSO

Birth Date

Contains date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Days Sales Outstanding

Contains the days sales outstanding, which is an important financial indicator showing both the age, in terms of days, of a company's accounts receivable and the average time it takes to turn the receivables into cash.

PS_F_AR_DSO.DAYS_SALES_OUTSTDG

History Weightage

This represents weightage of the historic data, which assign a numerical value on the importance of historical data.

PS_F_AR_DSO.HIST_WEIGHT

Dimension APAR Transaction Type

Includes accounts payable and accounts receivable transaction types. Examples of types are voucher, receipt, and payment.

PS_D_APAR_TRN_TYPE

Dimension AR Document Type

Includes details about various accounts receivable document types, such as receivables adjustments and receivables revaluation.

PS_D_AR_DOC_TYPE

Dimension AR Item Transaction Status

Indicates transaction status of an item as closed or open.

PS_D_AR_ITR_STAT

Dimension AR Item Transaction Type

Includes accounts receivable item transaction types.

PS_D_AR_ITR_TYPE

Dimension AR Payment Transaction Status

Includes accounts receivable payment status. Examples of status values include applied, complete, and unidentified.

PS_D_AR_PTR_STAT

Dimension AR Payment Transaction Type

Includes accounts receivable payment transaction types.

PS_D_AR_PTR_TYPE

Dimension Bank Account

Includes details about bank and bank account information.

PS_D_BANK_ACCT

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Collect Status

Includes collection status codes and description.

PS_D_COLLECT_STAT

Dimension Customer Bill Customer

A role-playing dimension based on Customer dimension and includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Customer Remit Customer

A role-playing dimension based on Customer dimension and includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Customer Ship Customer

A role-playing dimension based on Customer dimension and includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Customer Sold Customer

A role-playing dimension based on Customer dimension and includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY

Dimension Day Discount Due1 Date

A role-playing dimension based on dimension Day for the first discount due date.

PS_D_DAY

Dimension Day Discount Due2 Date

A role-playing dimension based on dimension Day for the second discount due date.

PS_D_DAY

Dimension Day Due Pay Date

A role-playing dimension based on dimension Day for due pay date.

PS_D_DAY

Dimension Day Transaction Date

A role-playing dimension based on dimension Day for transaction date.

PS_D_DAY

Dimension Deduction Status

Includes accounts receivable deduction status information.

PS_D_DEDUCT_STAT

Dimension Dispute Status

Includes details about disputes raised in collection in accounts receivable.

PS_D_DISPUTE_STAT

Dimension Entry Reason Type

Includes types of reasons used when an entry in general ledger is created from accounts receivable. Examples of values are adjustment, overpayment, and credit memo.

PS_D_ENTRY_RSTYP

Dimension Payment Method

Includes the details about various methods of payment, such as check, cash, and credit card.

PS_D_PYMNT_MTHD

Dimension Payment Terms

Includes information about various payment terms such as net 30 days and due first of month.

PS_D_PYMNT_TRMS

Dimension Person AR Collector

Includes details such as name and contact details about the accounts receivable collector involved in collecting the receivables amount in the accounts receivable module.

PS_D_PERSON_COLTR

Dimension Person AR Credit Analyst

Includes details such as name and contact details about the accounts receivable credit analyst involved in handling the credits given to customers.

PS_D_PERSON_CRNYST

Dimension Person AR Deduction Manager

Includes the accounts receivable deduction manager name and contact information.

PS_D_PERSON_DEDMGR

Dimension Person AR Specialist

Includes details such name and contact details about the accounts receivable specialist involved in handling the disputes and deductions in the accounts receivable module.

PS_D_PERSON_ARSPL

Dimension Person Sales Org1

This role-playing dimension based on Person dimension includes the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Person Sales Org2

This role-playing dimension based on Person dimension includes the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Bank Account

Includes details about bank and bank account information.

PS_D_BANK_ACCT

Dimension Business Unit AR

The AR Business Unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Business Unit Composite

The composite business unit dimension.

PS_D_BUS_UNIT_COMP

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Collect Status

Includes collection status codes and description.

PS_D_COLLECT_STAT

Fact AR Transaction

This fact table stores summary of accounts receivable transactions and helps in analysis in areas such as total accounts receivable invoices and payments, accounts receivable invoice amount, and accounts receivable receivables amount by a customer.

PS_F_AR_TRAN

Latitude

Latitude of the Customer’s store.

PS_D_CUSTOMER.LATITUDE

Longitude

Longitude of the Customer’s store.

PS_D_CUSTOMER.LONGITUDE

Birth Date

Contains date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Adjustment Base Amount

Contains the adjustment amount in base currency.

PS_F_AR_TRAN.ADJ_BASE_AMT

Adjustment Count

Count of number of Adjustments.

PS_F_AR_TRAN.ADJ_COUNT

Adjustment R1 Amount

Contains the adjustment amount in reporting1 currency.

PS_F_AR_TRAN.ADJ_R1_AMT

Adjustment R2 Amount

Contains the adjustment amount in reporting 2 currency.

PS_F_AR_TRAN.ADJ_R2_AMT

Adjustment Transaction Amount

Contains the adjustment amount in transaction currency.

PS_F_AR_TRAN.ADJ_TRAN_AMT

Item Count

Contains the count of items sold in the transaction.

PS_F_AR_TRAN.COUNT_ITEMS

Receipt Count

Contains the count of payments. Dev: Does this mean the number of payments?

PS_F_AR_TRAN.COUNT_PAYMENTS

Discount Eligible1 Base Amount

Contains discount eligible 1 in base currency.

PS_F_AR_TRAN.DISE1_BASE_AMT

Discount Eligible1 R1 Amount

Contains discount eligible 1 in reporting1 currency.

PS_F_AR_TRAN.DISE1_R1_AMT

Discount Eligible1 R2 Amount

Contains discount eligible 1 in reporting 2 currency .

PS_F_AR_TRAN.DISE1_R2_AMT

Discount Eligible1 Transaction Amount

Contains discount eligible 1 in transaction currency.

PS_F_AR_TRAN.DISE1_TRAN_AMT

Discount Eligible2 Base Amount

Contains discount eligible 2 in base currency.

PS_F_AR_TRAN.DISE2_BASE_AMT

Discount Eligible2 R1 Amount

Contains discount eligible 2 in reporting1 currency.

PS_F_AR_TRAN.DISE2_R1_AMT

Discount Eligible2 R2 Amount

Contains discount eligible 2 in reporting 2 currency .

PS_F_AR_TRAN.DISE2_R2_AMT

Discount Eligible2 Transaction Amount

Contains discount eligible 2 in transaction currency.

PS_F_AR_TRAN.DISE2_TRAN_AMT

Dispute Base Amount

Contains dispute amount in base currency.

PS_F_AR_TRAN.DISP_BASE_AMT

Dispute R1 Amount

Contains dispute amount in reporting 1 currency.

PS_F_AR_TRAN.DISP_R1_AMT

Dispute R2 Amount

Contains dispute amount in reporting 2 currency.

PS_F_AR_TRAN.DISP_R2_AMT

Dispute Transaction Amount

Contains dispute amount in transaction currency.

PS_F_AR_TRAN.DISP_TRAN_AMT

Earned Discount Base Amount

Contains earned discount amount in base currency.

PS_F_AR_TRAN.DSCE_BASE_AMT

Earned Discount R1 Amount

Contains earned discount amount in reporting 1 currency.

PS_F_AR_TRAN.DSCE_R1_AMT

Earned Discount R2 Amount

Contains earned discount amount in reporting 2 currency.

PS_F_AR_TRAN.DSCE_R2_AMT

Earned Discount Transaction Amount

Contains earned discount amount in transaction currency.

PS_F_AR_TRAN.DSCE_TRAN_AMT

Discount Taken Base Amount

Contains the discount taken amount in base currency.

PS_F_AR_TRAN.DSCT_BASE_AMT

Discount Taken R1 Amount

Contains the discount taken amount in reporting 1 currency.

PS_F_AR_TRAN.DSCT_R1_AMT

Discount Taken R2 Amount

Contains the discount taken amount in reporting 2 currency.

PS_F_AR_TRAN.DSCT_R2_AMT

Discount Taken Transaction Amount

Contains the discount taken amount in transaction currency.

PS_F_AR_TRAN.DSCT_TRAN_AMT

Unearned Discount Base Amount

Contains the unearned discount amount in base currency.

PS_F_AR_TRAN.DSCU_BASE_AMT

Unearned Discount R1 Amount

Contains the unearned discount amount in reporting 1 currency.

PS_F_AR_TRAN.DSCU_R1_AMT

Unearned Discount R2 Amount

Contains the unearned discount amount in reporting 2 currency.

PS_F_AR_TRAN.DSCU_R2_AMT

Unearned Discount Transaction Amount

Contains the unearned discount amount in transaction currency.

PS_F_AR_TRAN.DSCU_TRAN_AMT

Due Days

Specifies the number of days beyond the due date for which payment is still considered on time. This defines a payment grace period.

PS_F_AR_TRAN.DUE_DAYS

Payment Rate Divisor

Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with Payment.

PS_F_AR_TRAN.PYMT_RATE_DIV

Payment Rate Multiplier

Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with Payment.

PS_F_AR_TRAN.PYMT_RATE_MULT

Rate Divisor

Rate Divisor.

PS_F_AR_TRAN.RATE_DIV

Rate Multiplier

Rate Multiplier.

PS_F_AR_TRAN.RATE_MULT

Remaining Base Amount

Contains the remaining amount in base currency.

PS_F_AR_TRAN.REM_BASE_AMT

Remaining R1 Amount

Contains the remaining amount in reporting 1 currency.

PS_F_AR_TRAN.REM_R1_AMT

Remaining R2 Amount

Contains the remaining amount in reporting 2 currency.

PS_F_AR_TRAN.REM_R2_AMT

Remaining Transaction Amount

Contains the remaining amount in transaction currency

PS_F_AR_TRAN.REM_TRAN_AMT

Selected Base Amount

Contains the selected amount in base currency.

PS_F_AR_TRAN.SEL_BASE_AMT

Selected R1 Amount

Contains the selected amount in reporting 1 currency.

PS_F_AR_TRAN.SEL_R1_AMT

Selected R2 Amount

Contains the selected amount in reporting 2 currency.

PS_F_AR_TRAN.SEL_R2_AMT

Selected Transaction Amount

Contains the selected amount in transaction currency

PS_F_AR_TRAN.SEL_TRAN_AMT

Transaction Base Amount

Contains the transaction amount in base currency.

PS_F_AR_TRAN.TRAN_BASE_AMT

Transaction Count

Contains number of transactions.

PS_F_AR_TRAN.TRAN_COUNT

Transaction R1 Amount

Contains the transaction amount in reporting 1 currency.

PS_F_AR_TRAN.TRAN_R1_AMT

Transaction R2 Amount

Contains the transaction amount in reporting 2 currency.

PS_F_AR_TRAN.TRAN_R2_AMT

Transaction Amount

Contains the transaction amount in transaction currency

PS_F_AR_TRAN.TRAN_TRAN_AMT

Original Balance Base Amount

Contains the original balance amount in base currency.

PS_F_AR_TRAN.XBALO_BASE_AMT

Original Balance R1 Amount

Contains the original balance amount in reporting 1 currency.

PS_F_AR_TRAN.XBALO_R1_AMT

Original Balance R2 Amount

Contains the original balance amount in reporting 2 currency.

PS_F_AR_TRAN.XBALO_R2_AMT

Original Balance Transaction Amount

Contains the original balance amount in transaction currency.

PS_F_AR_TRAN.XBALO_TRAN_AMT

Balance Base Amount

Contains the balance amount in base currency.

PS_F_AR_TRAN.XBAL_BASE_AMT

Balance R1 Amount

Contains the balance amount in reporting 1 currency. Use this fact to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AR_TRAN.XBAL_R1_AMT

Balance R2 Amount

Contains the balance amount in reporting 2 currency. Use this fact to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AR_TRAN.XBAL_R2_AMT

Balance Transaction Amount

Contains the balance amount in transaction currency. Use this fact to answer questions such as "What is the total AP outstanding amount to be paid to a specified supplier?"

PS_F_AR_TRAN.XBAL_TRAN_AMT

Discount Available Base Amount

Contains the discount available amount in base currency.

PS_F_AR_TRAN.XDISA_BASE_AMT

Discount Available R1 Amount

Contains the discount available amount in reporting1 currency.

PS_F_AR_TRAN.XDISA_R1_AMT

Discount Available R2 Amount

Contains the discount available amount in reporting 2 currency.

PS_F_AR_TRAN.XDISA_R2_AMT

Discount Available Transaction Amount

Contains the discount available amount in transaction currency.

PS_F_AR_TRAN.XDISA_TRAN_AMT

Discount Base Amount

Discount Amount in Base Currency

PS_F_AR_TRAN.XDISC_BASE_AMT

Discount R1 Amount

Discount Amount in Reporting 1 Currency

PS_F_AR_TRAN.XDISC_R1_AMT

Discount R2 Amount

Discount Amount in Reporting 2 Currency

PS_F_AR_TRAN.XDISC_R2_AMT

Discount Transaction Amount

Discount Amount in Transaction Currency

PS_F_AR_TRAN.XDISC_TRAN_AMT

Original Discount Base Amount

Contains the original discount amount in base currency.

PS_F_AR_TRAN.XDISO_BASE_AMT

Original Discount R1 Amount

Contains the original discount amount in reporting 1 currency.

PS_F_AR_TRAN.XDISO_R1_AMT

Original Discount R2 Amount

Contains the original discount amount in reporting 2 currency.

PS_F_AR_TRAN.XDISO_R2_AMT

Original Discount Transaction Amount

Contains the original discount amount in transaction currency.

PS_F_AR_TRAN.XDISO_TRAN_AMT

Cross Ref Discount Taken Base Amount (Cross Reference Discount Taken Base Amount)

Contains the discount taken amount in base currency.

PS_F_AR_TRAN.XDIST_BASE_AMT

Cross Ref Discount Taken R1 Amount

Contains the discount taken amount in reporting 1 currency.

PS_F_AR_TRAN.XDIST_R1_AMT

Cross Ref Discount Taken R2 Amount

Contains the discount taken amount in reporting 2 currency.

PS_F_AR_TRAN.XDIST_R2_AMT

Cross Ref Discount Taken Transaction Amount

Contains the discount taken amount in transaction currency.

PS_F_AR_TRAN.XDIST_TRAN_AMT

Discount Payment Base Amount

Contains the discount payment amount in base currency.

PS_F_AR_TRAN.XDIS_BASE_AMT

Discount Payment R1 Amount

Contains the discount payment amount in reporting 1 currency.

PS_F_AR_TRAN.XDIS_R1_AMT

Discount Payment R2 Amount

Contains the discount payment amount in reporting 2 currency.

PS_F_AR_TRAN.XDIS_R2_AMT

Discount Payment Transaction Amount

Contains the discount payment amount in transaction currency.

PS_F_AR_TRAN.XDIS_TRAN_AMT

Item Pay Base Amount

Contains the amount paid for an item in base currency.

PS_F_AR_TRAN.XITM_BASE_AMT

Item Pay R1 Amount

Contains the item pay amount in reporting 1 currency.

PS_F_AR_TRAN.XITM_R1_AMT

Item Pay R2 Amount

Contains the item pay amount in reporting 2 currency.

PS_F_AR_TRAN.XITM_R2_AMT

Item Pay Transaction Amount

Contains the item pay amount in transaction currency.

PS_F_AR_TRAN.XITM_TRAN_AMT

Cross Ref Payment Base Amount (Cross Reference Payment Base Amount)

Contains the cross-reference payment amount in base currency.

PS_F_AR_TRAN.XPAY_BASE_AMT

Cross Ref Payment R1 Amount

Contains the cross-reference payment amount in reporting 1 currency.

PS_F_AR_TRAN.XPAY_R1_AMT

Cross Ref Payment R2 Amount

Contains the cross-reference payment amount in reporting 2 currency.

PS_F_AR_TRAN.XPAY_R2_AMT

Cross Ref Payment Transaction Amount

Payment Amount in Transaction Currency

PS_F_AR_TRAN.XPAY_TRAN_AMT

Actual Utilization Analysis

Complex folder for Actual Utilization report.

Work Day Hour Sum

Contains the sum of hours per workday.

PS_D_EMPL_JOB.STD_DY_HR_QTY

Work Day Hours

Contains hours worked by an employee per day.

PS_D_EMPL_JOB.STD_DY_HR_QTY

Capacity Hours

Contains the number of hours that is used as a standard measure to calculate utilization percentage for a given period. It is calculated as (Standard Day Hours) * (Number of Work Days).

PS_D_EMPL_JOB.STD_DY_HR_QTY PS_F_TIME_RPT.RPT_DT_SID

Actual Utilization Rate

Contains the actual utilization rate for an employee or contractor, which is calculated as (time report billable hours)/(capacity hours).

PS_D_EMPL_JOB.STD_DY_HR_QTY PS_F_TIME_RPT.RPT_DT_SID PS_F_TIME_RPT.TM_RPT_HR_NUM

Time Report Billable Hours

Contains the total actual number of billable hours from time report.

PS_D_TRC.TRC_SID PS_F_TIME_RPT.TM_RPT_HR_NUM

Time Report Policy Hours

Contains the total number of a company's working policy hours.

PS_D_TRC.TRC_SID PS_F_TIME_RPT.TM_RPT_HR_NUM

Total Work Hour Number

Contains the total hours that a person is expected to work on a particular day.

PS_F_FCST.TOTAL_HR_NUM

Count Report Dt Sid (Count Report Date Surrogate ID)

Contains the total count for the number of report dates.

PS_F_TIME_RPT.RPT_DT_SID

Time Report Hours

Contains the number of hours that a person entered for a given day.

PS_F_TIME_RPT.TM_RPT_HR_NUM

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Amendment Reason

Provides a quick explanation as to why an amendment was initiated. The amendment reason augments the amendment type and provides additional insight as to the reason behind the amendment.

PS_D_CA_AMD_RSN

Dimension Contract Amendment Type

Includes information about the high-level classification of an amendment. Amendment types are dictated by internal amendment policies.

PS_D_CA_AMD_TYPE

Dimension Contract Miscellaneous

Includes a collection of lowest granularity of contract information.

PS_D_CA_JNK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Complete Date

A role-playing dimension based on dimension Day for complete date.

PS_D_DAY

Dimension Day Create Date

A role-playing dimension based on dimension Day for create date.

PS_D_DAY

Fact Contract Amendment

Captures the change in the obligations and entitlements of a contract. The negotiated and discount amount changes are at the contract level.

PS_F_CA_AMD

Contract Amendment Discount Surcharge Change Amount

Contains the change in the discount and surcharge applicable to a contract due to an amendment.

PS_F_CA_AMD.CA_ABDSCHG_AMT

Contract Amendment Discount Surcharge Change R1 Amount

Contains the reporting 1 change in the discount and surcharge applicable to a contract due to an amendment.

PS_F_CA_AMD.CA_ABDSCHG_R1_AMT

Contract Amendment Discount Surcharge Change R2 Amount

The reporting 2 change in the discount and surcharge applicable to a contract an amendment.

PS_F_CA_AMD.CA_ABDSCHG_R2_AMT

Contract Amendment Absolute Gross Change Amount

Contains the total change in gross or negotiated amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_ABGRSCHG_AMT

Contract Amendment Absolute Gross Change R1 Amount

The reporting 1 total change in gross or negotiated amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_ABGRSCHG_R1_AMT

Contract Amendment Absolute Gross Change R2 Amount

The reporting 2 total change in gross or negotiated amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_ABGRSCHG_R2_AMT

Contract Amendment Discount Surcharge Amount

Contains the total change in discount and surcharge amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_DSCHG_AMT

Contract Amendment Discount Surcharge R1 Amount

The reporting 1 total change in discount and surcharge amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_DSCHG_R1_AMT

Contract Amendment Discount Surcharge R2 Amount

The reporting 2 total change in discount and surcharge amount. This fact ignores the sign of the amount.

PS_F_CA_AMD.CA_DSCHG_R2_AMT

Contract Amendment Gross Change Amount

Contains the change in the gross or negotiated amount of a contract due to an amendment.

PS_F_CA_AMD.CA_GRSCHG_AMT

Contract Amendment Gross Change R1 Amount

The reporting 1 change in the gross or negotiated amount of a contract due to an amendment.

PS_F_CA_AMD.CA_GRSCHG_R1_AMT

Contract Amendment Gross Change R2 Amount

The reporting 2 change in the gross or negotiated amount of a contract due to an amendment.

PS_F_CA_AMD.CA_GRSCHG_R2_AMT

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Detail

Includes contract detail information.

PS_D_CA_DTL

Dimension Contract Miscellaneous

Includes a collection of low cardinality contract information.

PS_D_CA_JNK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day End Date

The end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Line End Date

The line end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Line Start Date

The line start date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Sign Date

The sign date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Start Date

The start date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Fund

Includes details about fund codes and their description.

PS_D_FUND

Dimension Operating Unit

Includes details about operating units, such as a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Project

Includes information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Fact Contract Detail Distribution

This fact includes information relating to accounting distributions of a contract line.

PS_F_CA_DTL_DIST

Benefit Amount

Contains the benefit amount.

PS_D_PRJ.BNFT_AMT

Benefit R1 Amount (Benefit Reporting 1 Amount)

Contains the reporting 1 benefit amount.

PS_D_PRJ.BNFT_R1_AMT

Benefit R2 Amount (Benefit Reporting 2 Amount)

Contains the reporting 2 benefit amount.

PS_D_PRJ.BNFT_R2_AMT

Discount Rate

Used to calculate the estimated net present value and the estimated return on investment.

PS_D_PRJ.DSCNT_RT

Maintenance Cost Amount

Contains the project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_AMT

Maintenance Cost R1 Amount

Contains the reporting 1 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R1_AMT

Maintenance Cost R2 Amount

Contains the reporting 2 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R2_AMT

NPV Amount

Contains the estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_AMT

NPV R1 Amount

Contains the reporting 1 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R1_AMT

NPV R2 Amount

Contains the reporting 2 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R2_AMT

Project Cost Amount

Contains the project estimated cost amount.

PS_D_PRJ.PRJ_CST_AMT

Project Cost R1 Amount

Contains the reporting 1 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R1_AMT

Project Cost R2 Amount

Contains the reporting 2 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R2_AMT

ROI Amount

Contains the estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_AMT

ROI R1 Amount

Contains the reporting 1 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R1_AMT

ROI R2 Amount

Contains the reporting 2 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R2_AMT

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Contract Forecast Analysis

Complex folder containing items for Contract Forecast report.

Contract Forecast Amount

Contains the projected revenue of a contract line for future accounting periods.

PS_F_CA_CUR_FRCST.CA_FRCST_AMT

Contract Forecast Probability Percentage

Contains the contract forecast probability displayed as a percentage (divided by 100).

PS_F_CA_CUR_FRCST.CA_FRCST_PRBBLTY

Contract Forecast Probability

Contains the average of contract forecast probability percentage.

PS_F_CA_CUR_FRCST.CA_FRCST_PRBBLTY

Contract Forecast Analysis

Complex folder containing items for Contract Forecast report.

NULL

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Detail

Includes contract detail information.

PS_D_CA_DTL

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY

Dimension Day Last Run Date

A role-playing dimension based on dimension Day for last run date.

PS_D_DAY

Dimension Day Snapshot

A role-playing dimension based on dimension Day for snapshot date.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Contract Forecast Analysis

Complex folder containing items for Contract Forecast report.

Fact Contract Forecast Current

Captures the current revenue backlog for both fixed-fee and rate-based contract lines and the probability percentage of the revenue forecast.

PS_F_CA_CUR_FRCST

Contract Forecast Amount

Contains the projected revenue of a contract line for future accounting periods.

PS_F_CA_CUR_FRCST.CA_FRCST_AMT

Contract Forecast Probability Percentage

Contains the contract forecast probability displayed as a percentage (divided by 100).

PS_F_CA_CUR_FRCST.CA_FRCST_PRBBLTY

Contract Forecast Probability

Contains the average of contract forecast probability percentage.

PS_F_CA_CUR_FRCST.CA_FRCST_PRBBLTY

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Detail

Includes contract detail information. I.e. parts or services ordered.

PS_D_CA_DTL

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY

Dimension Day Last Run Date

A role-playing dimension based on dimension Day for last run date.

PS_D_DAY

Dimension Day Snapshot

A role-playing dimension based on dimension Day for snapshot date.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Fact Contract Forecast Periodic

Captures the trend of revenue backlog for both fixed-fee and rate-based contract lines and the probability percentage of the revenue forecast.

PS_F_CA_PRDC_FRCST

Contract Forecast Amount

Contains the projected revenue of a contract line for future accounting periods.

PS_F_CA_PRDC_FRCST.CA_FRCST_AMT

Contract Forecast R1 Amount

Contains the projected revenue of a contract line for future accounting periods in reporting 1 currency.

PS_F_CA_PRDC_FRCST.CA_FRCST_R1_AMT

Contract Forecast R2 Amount

Contains the projected revenue of a contract line for future accounting periods in reporting 2 currency.

PS_F_CA_PRDC_FRCST.CA_FRCST_R2_AMT

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Miscellaneous

Includes a collection of low cardinality contract information.

PS_D_CA_JNK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day End Date

The end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Start Date

The start date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Fact Contract Renewal

Captures the contract renew amount and percentage increase over the different contracts in different renewal cycles.

PS_F_CA_RNW

Contract Forecast Amount

Contains the projected revenue of a contract line for future accounting periods.

PS_F_CA_PRDC_FRCST.CA_FRCST_AMT

Contract Forecast R1 Amount

Contains the projected revenue of a contract line for future accounting periods in reporting 1 currency.

PS_F_CA_PRDC_FRCST.CA_FRCST_R1_AMT

Contract Forecast R2 Amount

Contains the projected revenue of a contract line for future accounting periods in reporting 2 currency.

PS_F_CA_PRDC_FRCST.CA_FRCST_R2_AMT

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Class Field

Includes expense classification codes and descriptions.

PS_D_CLASS_FIELD

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Detail

Includes contract detail information.

PS_D_CA_DTL

Dimension Contract Miscellaneous

Includes a collection of low cardinality contract information.

PS_D_CA_JNK

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Fund

Includes details about fund codes and their description.

PS_D_FUND

Dimension Operating Unit

Includes details about operating units, such as a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Project Activity

Includes information about a project's activities (tasks). This dimension rolls-up to the Project dimension.

PS_D_PRJ_AC

Fact Contract Revenue Recognition

Contains the revenue recognized and reversed accounting entries for a contract line.

PS_F_CA_REV_RECOGN

Contract Revenue Amount

Depending on the distribution use, this amount represents the booked amount in the general ledger as revenue earned, or the discount given, or the deferred revenue on a contract for a particular accounting period and distribution set.

PS_F_CA_REV_RECOGN.CA_REV_AMT

Contract Revenue R1 Amount

Depending on the distribution use, this amount represents the booked amount in the general ledger as revenue earned, or the discount given, or the deferred revenue on a contract for a particular accounting period and distribution set in reporting 1 currency.

PS_F_CA_REV_RECOGN.CA_REV_R1_AMT

Contract Revenue R2 Amount

Depending on the distribution use, this amount represents the booked amount in the general ledger as revenue earned, or the discount given, or the deferred revenue on a contract for a particular accounting period and distribution set in reporting 2 currency.

PS_F_CA_REV_RECOGN.CA_REV_R2_AMT

Dimension Business Unit Project

The role-playing copy of business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Contract

Contains the details of the contract information entered into with customers.

PS_D_CA

Dimension Contract Detail

Includes contract detail information.

PS_D_CA_DTL

Dimension Customer

Includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day End Date

The end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Line End Date

The line end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Line Start Date

The line start date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Sign Date

The sign date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Start Date

The start date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Proposal

Includes information about proposals.

PS_D_PRP

Fact Contract Detail Transaction

Includes information relating to a contract line. It captures the contract terms and revenue metrics. The metrics are at the contract line level of detail.

PS_F_CA_DTL_TRANS

Contract Gross Amount

Contains the amount at which the contract line is offered. It is defaulted from the list price, but can be overridden at the contract line level. It is also known as the negotiated amount.

PS_F_CA_DTL_TRANS.CA_GRS_AMT

Contract Gross R1 Amount

Contains the amount at which the contract line is offered in reporting 1 currency. It is defaulted from the list price, but can be overridden at the contract line level. It is also known as the negotiated amount.

PS_F_CA_DTL_TRANS.CA_GRS_R1_AMT

Contract Gross R2 Amount

Contains the amount at which the contract line is offered in reporting 2 currency. It is defaulted from the list price, but can be overridden at the contract line level. It is also known as the negotiated amount.

PS_F_CA_DTL_TRANS.CA_GRS_R2_AMT

Contract List Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line.

PS_F_CA_DTL_TRANS.CA_LIST_AMT

Contract List R1 Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line in reporting 1 currency.

PS_F_CA_DTL_TRANS.CA_LIST_R1_AMT

Contract List R2 Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line in reporting 2 currency.

PS_F_CA_DTL_TRANS.CA_LIST_R2_AMT

Contract Net Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line.

PS_F_CA_DTL_TRANS.CA_NET_AMT

Contract Net R1 Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line in reporting 1 currency.

PS_F_CA_DTL_TRANS.CA_NET_R1_AMT

Contract Net R2 Amount

Contains the current gross or negotiated amount, minus any discounts and plus all non-inclusive prepaids of a contract line in reporting 2 currency.

PS_F_CA_DTL_TRANS.CA_NET_R2_AMT

Dimension Day Activity End Date

A role-playing dimension based on dimension Day for activity end date.

PS_D_DAY

Dimension Day Activity Start Date

A role-playing dimension based on dimension Day for activity start date.

PS_D_DAY

Dimension Day Current End Date

A role-playing dimension based on dimension Day for current end date.

PS_D_DAY

Dimension Day Current Start Date

A role-playing dimension based on dimension Day for current start date.

PS_D_DAY

Dimension Day Scheduled End Date

A role-playing dimension based on dimension Day for scheduled end date.

PS_D_DAY

Dimension Day Scheduled Start Date

A role-playing dimension based on dimension Day for scheduled start date.

PS_D_DAY

Dimension Day Snapshot

A role-playing dimension based on dimension Day for snapshot date.

PS_D_DAY

Dimension Project

Includes information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Dimension Project Health

Stores information about project health. This information is maintained in a separate dimension to avoid forcing type 2 changes on the Project dimension or placing degenerate dimensions in the fact table. (Note: A Type 2 change is one of the standard in slowly-changing dimension methodology in data warehouse).

PS_D_PRJ_HLTH

Dimension Project Status

Maintains information about user-defined project statuses.

PS_D_PRJ_STAT

Fact Projects Current

Includes current project measures.

PS_F_PRJ_CUR

Benefit Amount

Contains the benefit amount.

PS_D_PRJ.BNFT_AMT

Benefit R1 Amount (Benefit Reporting 1 Amount)

Contains the reporting 1 benefit amount.

PS_D_PRJ.BNFT_R1_AMT

Benefit R2 Amount (Benefit Reporting 2 Amount)

Contains the reporting 2 benefit amount.

PS_D_PRJ.BNFT_R2_AMT

Discount Rate

Used to calculate the estimated net present value and the estimated return on investment.

PS_D_PRJ.DSCNT_RT

Maintenance Cost Amount

Contains the project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_AMT

Maintenance Cost R1 Amount

Contains the reporting 1 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R1_AMT

Maintenance Cost R2 Amount

Contains the reporting 2 project's estimated maintenance cost amount.

PS_D_PRJ.MTN_CST_R2_AMT

NPV Amount

Contains the estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_AMT

NPV R1 Amount

Contains the reporting 1 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R1_AMT

NPV R2 Amount

Contains the reporting 2 estimated net present value for this project, which is calculated as (Present Value of Benefits) - (Present Value of Costs).

PS_D_PRJ.NPV_R2_AMT

Project Cost Amount

Contains the project estimated cost amount.

PS_D_PRJ.PRJ_CST_AMT

Project Cost R1 Amount

Contains the reporting 1 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R1_AMT

Project Cost R2 Amount

Contains the reporting 2 project estimated cost amount.

PS_D_PRJ.PRJ_CST_R2_AMT

ROI Amount

Contains the estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_AMT

ROI R1 Amount

Contains the reporting 1 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R1_AMT

ROI R2 Amount

Contains the reporting 2 estimated return on investment for this project, which is calculated as ((Present Value of Benefits) ÷ (Present Value of Costs)) × 100.

PS_D_PRJ.ROI_R2_AMT

FMS - ESA - Customer Profitability Analysis

Complex folder for Customer Profitability report.

Resource Amount

Contains the Resource amount associated with the project transaction.

PS_F_PRJ_TRAN.RSRC_AMT

Project Transaction Actual Amount

Contains the actual resource amount needed in a project transaction.

PS_R_ANLYS_TYP_GRP.ANLYS_GRP_CAT

Project Transaction Budget Amount

Contains the allocated budget resource amount in a project transaction.

PS_F_PRJ_TRAN.RSRC_AMT

Dimension Assignment

Includes information about assignments. Assignments pair a resource with a unit of work.

PS_D_ASGN

Dimension Billing Action

Represents information, such as Billable, Internal, and Nonbillable about billing actions.

PS_D_BLN_ACTN

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day

The day dimension.

PS_D_DAY

Dimension Day Approval Date

A role-playing dimension based on Day dimension for the approval date.

PS_D_DAY

Dimension Day Reporting Date

A role-playing dimension based on Day dimension for the reporting date.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes attributes about a department such as description, company code, location, and budget.

PS_D_DEPT

Dimension Employee Forecast

Represents information about employee headcount forecasts.

PS_D_FCST

Dimension Employee Forecast Approval

Represents information, such as Approved, Denied, Sent Back for Revision, On Hold, Initial, Resubmitted, In Process, Rerouted, and Submitted, about forecast approvals.

PS_D_FCST_APPRV

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Project Activity

Includes information about a project's activities (tasks). This dimension rolls-up to the Project dimension.

PS_D_PRJ_AC

Dimension Project Role

Represents information about roles defined for the project.

PS_D_PRJ_ROLE

Dimension Time Reporting Code

Represents information, such as Contract holiday, Floating Holiday, Illness - Paid, Jury Duty, Personal - Paid, and Vacation, about TRCs.

PS_D_TRC

Dimension Unit of Measure

The unit of measure dimension.

PS_D_UOM

Fact Employee Forecast

Represents information about employee headcount forecasts for the project.

PS_F_FCST

Actual Utilization Analysis

Complex folder for Actual Utilization report.

FMS - ESA - Employee Time Forecast Analysis

Complex folder for Employee Time Forecast report.

Forecast Utilization Analysis

Complex folder for Forecast Utilization report.

Work Day Hour Sum

Contains the sum of work hour in a given workday.

PS_D_EMPL_JOB.STD_DY_HR_QTY

Work Day Hours

Contains the number of hours worked by an employee in a workday.

PS_D_EMPL_JOB.STD_DY_HR_QTY

Capacity Hours

Contains the number of hours that is used as a standard measure to calculate utilization percentage for a given period. It is calculated as (Standard Day Hours) * (Number of Work Days).

PS_D_EMPL_JOB.STD_DY_HR_QTY

PS_F_TIME_RPT.RPT_DT_SID

Actual Utilization Rate

Contains the actual resource utilization rate, which is calculated as (time report billable hours)/(capacity hours).

PS_D_EMPL_JOB.STD_DY_HR_QTY

PS_F_TIME_RPT.RPT_DT_SID

PS_F_TIME_RPT.TM_RPT_HR_NUM

Time Report Billable Hours

Contains the total actual number of billable hours from time report.

PS_D_TRC.TRC_SID

PS_F_TIME_RPT.TM_RPT_HR_NUM

Time Report Policy Hours

Contains the total number of a company's working policy hours.

PS_D_TRC.TRC_SID

PS_F_TIME_RPT.TM_RPT_HR_NUM

Total Work Hour Number

Contains the total hours that a person is expected to work on a particular day.

PS_F_FCST.TOTAL_HR_NUM

Count Report Dt Sid (Count Report Date Surrogate ID)

Contains the total count for the number of report dates.

PS_F_TIME_RPT.RPT_DT_SID

Time Report Hours

Contains the number of hours that a person entered for a given day.

PS_F_TIME_RPT.TM_RPT_HR_NUM

FMS - ESA - Employee Time Forecast Analysis

Complex folder for Employee Time Forecast report.

Forecast Total Hours

Contains the total forecast hours for an employee.

PS_F_FCST.TOTAL_HR_NUM

Total Work Hour Number

Contains the total hours that a person is expected to work on a particular day.

PS_F_FCST.TOTAL_HR_NUM

Employee Forecast Billable Hours

Contains the total billable hours for an employee forecast.

PS_F_FCST.TRC_SID

PS_F_FCST.TOTAL_HR_NUM

Employee Forecast Policy Hours

Contains forecasted working hours for an employee based on the company's policy.

PS_F_FCST.TRC_SID

PS_F_FCST.TOTAL_HR_NUM

Dimension Account

This dimension includes details of an account that represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit General Ledger

The general ledger business unit dimension is a role-playing dimension based on the Business Unit dimension.

PS_D_BUSINESS_UNIT

Dimension Class Field

Includes expense classification codes and descriptions.

PS_D_CLASS_FIELD

Dimension Day Accounting Date

A role-playing dimension based on dimension Day for accounting day.

PS_D_DAY