參照︰假設科目設定

科目詳細資料

欄位	說明
代碼	A unique combination of letters, numbers, and underscores. You can't use spaces or other special characters. If left blank for imports, Adaptive Planning auto-generates the code.
名稱	Displays on sheets, reports, and charts. The name doesn’t need to be unique. For words to avoid and other guidelines, see Reference: Naming Conventions Best Practices.
簡稱	Any combination of letters, numbers, and special characters. Overrides the display name of the account for dashboard charts when the account name is long.
彙總至	選取新建科目時，填入醒目提示的科目或群組。 Indicates the parent account.
類型	「定期」︰任何指定時段內的值均等於該期間的淨活動「連結」︰模型科目或 Cube 科目會填入此科目的值請參閱「」 Concept: Type Setting for Accounts 和概念︰來源連結科目。
顯示	僅 Cube 假設科目可使用。指出您可在何處檢視科目資料︰「只有在最上層時」︰僅在最上層檢視和輸入資料「在所有層級上」︰在任何層級僅可檢視，可在最上層輸入資料
連結到	Available for linked leaf accounts. 不適用於 Cube 或模型科目階層。 Lists modeled and cube accounts that populate the account as an aggregated value.
新增來源連結科目或編輯來源連結科目	Available for linked leaf accounts. 不適用於 Cube 或模型科目階層。 Displays when you add or edit links in the Links to content box. Use the prompts to select source sheets, then the accounts on the sheet.
變更正負號 +/-	Available for linked leaf accounts. 不適用於 Cube 或模型科目階層。 Pulls the inverse value of the highlighted link, which subtracts rather than sums. Example: Accumulated depreciation is a positive value in a modeled sheet. When linked to a General Ledger account, you can flip the sign so that it displays as a negative value in your General Ledger.
套用維度值	Available for linked leaf accounts. 不適用於 Cube 或模型科目階層。 Applies dimension values that don't exist on the highlighted source sheet to the data.
連結篩選條件	Available for linked leaf accounts. 不適用於 Cube 或模型科目階層。 Pulls in only the data that tagged with the dimension or attribute that you select from the drop-down prompts.
時間彙總	不適用於模型假設。設定科目如何計算時間彙總值︰「彙總值的總和」︰加總期間的所有值。範例︰第一季彙總會加總 1 月至 3 月的值。「彙總值的平均」︰採用時段的平均值。範例︰將 1 月至 3 月的值加總，並除以 3 做為第一季度彙總。「彙總值的加權平均」︰在計算平均值之前，使用科目或假設的值對每個期間進行加權。範例︰依據人員編制時間的平均費用彙總，將根據人員編制進行加權。
層級/維度彙總	Sets how the account calculates the totals for level and dimension rollups. Example: Total Company is a level that has 3 child levels: Sales, Manufacturing, and IT. You enter 100, 200, and zero for each level respectively. At the top-level, select how you would like Total Company to display the rollup value: Sum of rolled up values : Sums all the values for the level or dimension. Example: The level rollup is 300 (100+200+0). Non-Blank average of rolled up values : Takes the average of the data, excluding blanks. If a cell contains zero (not blank), the zero is calculated in the average. Example: The level rollup is 100 ((100+200)/3). Weighted average of roll up values : Uses the values of an account or assumption to weigh each dimension before averaging. Example: If Sales has twice the weight of the other 2 departments, the weighted average for the departments, the rollup for the departments is 133 ((2100+200)/3). For cube-entered accounts, you must select this option from the custom account hierarchy. Text* : Displays text that you specify for the dimension rollup. Select this option if you don't want to display data for dimension rollups. 來源連結科目會繼承來源科目的層級和維度彙總。
加權依據	Required when the Level/Dimension Rollup is Weighted average of rollup values . Provides the weighted average of the time or dimension rollup.
顯示文字	當層級/維度彙總為「文字」時為必填。 Provides the text that displays for dimension rollups. Enter any kind of text, such as NA or --, or leave blank.
啟用實際值	Available for leaf accounts. Unavailable for linked accounts. Displays actuals data over the plan data of plan versions.
科目沒有實際值	Available for leaf accounts that aren't linked. Displays only plan data in plan versions. Formulas for accounts without actuals overlay result in blank data when the formula references actuals data, including cells in the sheet with actuals overlay.
針對連結啟用實際值	Available for linked leaf accounts. Displays actuals data over the plan data for plan versions in both the source and target accounts.
如果來源連結科目有實際值則顯示	Available for linked leaf accounts. Displays actuals data over the plan data for plan versions only when the source account has actuals enabled already.
檢視依存關係	Indicates where the model references the account: Calculated Accounts : Lists accounts that refer to this account in the formula of the account settings. Shared Formulas : Lists the accounts by version and level that refer to this account with shared formulas. Cube Entries : Lists the accounts by cube sheet name that refer to this account with formulas entered on cube sheets. Other Entries : Lists the accounts by version, level, and time period that refer to this account with formulas entered on modeled and standard sheets. Rules : Lists the allocation and elimination rules that refer to this account Journal Entries Available for Cosolidation only. Lists the journal entries that refer to this account by journal entry number, version, and level. Reports : Lists the report names that refer to this account with custom calculations.

科目屬性內容

欄位	說明
包含模型中可用科目屬性內容的提示。根據實例而有所不同。	Available if your model has account attributes. Tags the account with attributes. The number of drop-down prompts match the number of account attributes available in your model.

資料類型

欄位	說明
科目時間級別	Read-only indication of the time strata intersection where data exists.
顯示為	Required. Read-only for child accounts or linked accounts. 表示資料在工作表上的顯示方式︰ Number : The data displays numerical values. Percent : The data displays as percents.
小數位數	Indicates the number of decimal places for the data: Any number 0-9. Currency's precision : Follows the setting for the currency. You can use the link to review the decimal places for all your currencies.

工作表

欄位	說明
可以在值為零或空白時隱藏科目	不適用於模型假設。 Hides the account on sheets when all values are zero or blank.
即使值為零或空白時也不隱藏科目	不適用於模型假設。 Always displays the account on sheets.
開始時展開	適用於彙總科目，但不適用於 Cube 或模型假設。表示彙總科目在工作表上的顯示方式︰ Yes : Expands rollup or group accounts on sheets to display child accounts. No : Collapses rollup or group accounts on sheets. Each person who opens a sheet can change their sheet view and save it as their default, which overrides this setting.
用於攤回	不適用於 Cube 或模型假設。將假設設為工作表中時間彙總的攤回選項，以及「一般設定」中的自動攤回。
在工作表上為唯讀	僅 Cube 假設可使用。鎖定工作表中的科目資料，以防止使用者變更。

資料隱私保護

欄位	說明
資料隱私保護	Workday 不會顯示此欄位。所有假設科目均已配置，以便任何層級上的公式都可參照最上層彙總值，但無法參照任何其他層級上的層級特定值。