Parameter List for Package Input Excel File

« Importing and Exporting Submission Route Contents | User Accounts and Licenses »

Parameter List for Package Input Excel File

This manual is in pilot operation.

When you launch a package input Excel file from the [Contributor], various parameter values (data items determined at runtime) are embedded in the cells on the sheet of the opened Excel file. Each parameter has a specific name, and the value is embedded in the cell named with that parameter. You do not need to embed all parameters; you can name only the cells for the parameters you need. The parameter names and the data values embedded are as follows:

Parameter Name (Excel Cell Range Name)	Embedded Data Value
_PPR_APP_LABEL	Application label
_PPR_APP_NAME	Application name
_PPR_FY_LABEL	Label of the fiscal year to which the currently selected process belongs
_PPR_FY_NAME	Fiscal year name
_PPR_VPT_LABEL	Label of the querying participant^[1]
_PPR_VPT_NAME	Name of the querying participant
_PPR_RPT_LABEL	Label of the submitting participant for the package data
_PPR_RPT_NAME	Name of the submitting participant
_PPR_INC_LABEL	User account name of the responsible person of the submitting participant for the package data
_PPR_INC_NAME	Name of the responsible person of the submitting participant for the package data
_PPR_RK_LABEL	Label of the responsibility splitter dimension member assigned to the submitting participant for the package data^[2]
_PPR_RK_NAME	Name of the responsibility splitter dimension member
_PPR_POV_（Dimension Label）_LABEL	Member key (perspective) specifying the range of the package data. It relates to either the fiscal year, relative period, responsibility key of the participant, or additional keys. The fiscal year, relative period, and responsibility key of the participant can be obtained from other parameters, but additional keys can only be obtained with this parameter. In the parameter name, "（Dimension Label）" is replaced with the label of each dimension. However, the “#” character in the dimension label is replaced with "." (since the “#” character cannot be used as an Excel range name).
_PPR_POV_（Dimension Label）_NAME	Name of the above
_PPR_VPTW_LKEY	Ledger edition key of the workspace of the querying participant (indicated by _PPR_VPT_LABEL).
_PPR_VPTW_DESC	Description for the above.
_PPR_CUR_LKEY	Ledger edition key of the currently selected target data. The specific content is as follows: (When the Excel is launched with a specified submission package) The ledger edition key of the specified submission package. Note that each submission package is considered a special ledger edition and given a ledger edition key. (When the Excel is launched with a specified participant’s workspace) The key of the ledger edition linked to the participant’s workspace.
_PPR_CUR_DESC	Description of the currently selected target data. The specific content is as follows: (When the Excel is launched with a specified submission package) Description of the specified submission package. (When the Excel is launched with a specified participant’s workspace) Description of the specified participant’s workspace.
_PPR_CUR_SUBDT	Submission date of the currently selected target data. It is set only when the Excel is launched with a specified submission package. If the Excel is launched with a specified participant’s workspace, the cell is set to blank.
_PPR_CUR_APDT	Final approval date of the currently selected target data⚠. It is set only when the Excel is launched with a specified submission package and the submission package is finally approved. If the final approval is pending or the Excel is launched with a specified participant’s workspace, the cell is set to blank.
_PPR_PREVAP_LKEY	Ledger edition key of the immediately preceding submission package of the currently selected target data (this means the latest submission package if the currently selected target data is the participant’s workspace). However, if such a submission package does not exist, the cell is set to blank.
_PPR_PREVAP_DESC	Description of the above submission package. However, if such a submission package does not exist, the cell is set to blank.
_PPR_PREVAP_SUBDT	Submission date of the above submission package. However, if such a submission package does not exist, the cell is set to blank.
_PPR_PREVAP_APDT	Final approval date of the above submission package⚠. However, if such a submission package does not exist, or if it exists but the final approval is pending, the cell is set to blank.
_PPR_CUR_PKGKEY	Key of the currently selected package. The package key is set only when the workspace is selected. The structure of the package key is as follows: (Process definition label).(Fiscal year label).(Relative period label).(Participant label).(Submission package definition label)

Parameter Name (Excel Cell Range Name)

Embedded Data Value

_PPR_APP_LABEL

Application label

_PPR_APP_NAME

Application name

_PPR_FY_LABEL

Label of the fiscal year to which the currently selected process belongs

_PPR_FY_NAME

Fiscal year name

_PPR_VPT_LABEL

Label of the querying participant^[1]

_PPR_VPT_NAME

Name of the querying participant

_PPR_RPT_LABEL

Label of the submitting participant for the package data

_PPR_RPT_NAME

Name of the submitting participant

_PPR_INC_LABEL

User account name of the responsible person of the submitting participant for the package data

_PPR_INC_NAME

Name of the responsible person of the submitting participant for the package data

_PPR_RK_LABEL

Label of the responsibility splitter dimension member assigned to the submitting participant for the package data^[2]

_PPR_RK_NAME

Name of the responsibility splitter dimension member

_PPR_POV_（Dimension Label）_LABEL

Member key (perspective) specifying the range of the package data. It relates to either the fiscal year, relative period, responsibility key of the participant, or additional keys. The fiscal year, relative period, and responsibility key of the participant can be obtained from other parameters, but additional keys can only be obtained with this parameter.

In the parameter name, "（Dimension Label）" is replaced with the label of each dimension. However, the “#” character in the dimension label is replaced with "." (since the “#” character cannot be used as an Excel range name).

_PPR_POV_（Dimension Label）_NAME

Name of the above

_PPR_VPTW_LKEY

Ledger edition key of the workspace of the querying participant (indicated by _PPR_VPT_LABEL).

_PPR_VPTW_DESC

Description for the above.

_PPR_CUR_LKEY

Ledger edition key of the currently selected target data. The specific content is as follows:

(When the Excel is launched with a specified submission package)

The ledger edition key of the specified submission package. Note that each submission package is considered a special ledger edition and given a ledger edition key.

(When the Excel is launched with a specified participant’s workspace)

The key of the ledger edition linked to the participant’s workspace.

_PPR_CUR_DESC

Description of the currently selected target data. The specific content is as follows:

(When the Excel is launched with a specified submission package)

Description of the specified submission package.

(When the Excel is launched with a specified participant’s workspace) Description of the specified participant’s workspace.

_PPR_CUR_SUBDT

Submission date of the currently selected target data. It is set only when the Excel is launched with a specified submission package. If the Excel is launched with a specified participant’s workspace, the cell is set to blank.

_PPR_CUR_APDT

Final approval date of the currently selected target data⚠. It is set only when the Excel is launched with a specified submission package and the submission package is finally approved. If the final approval is pending or the Excel is launched with a specified participant’s workspace, the cell is set to blank.

_PPR_PREVAP_LKEY

Ledger edition key of the immediately preceding submission package of the currently selected target data (this means the latest submission package if the currently selected target data is the participant’s workspace).
However, if such a submission package does not exist, the cell is set to blank.

_PPR_PREVAP_DESC

Description of the above submission package.
However, if such a submission package does not exist, the cell is set to blank.

_PPR_PREVAP_SUBDT

Submission date of the above submission package.
However, if such a submission package does not exist, the cell is set to blank.

_PPR_PREVAP_APDT

Final approval date of the above submission package⚠.
However, if such a submission package does not exist, or if it exists but the final approval is pending, the cell is set to blank.

_PPR_CUR_PKGKEY

Key of the currently selected package.
The package key is set only when the workspace is selected. The structure of the package key is as follows:
(Process definition label).(Fiscal year label).(Relative period label).(Participant label).(Submission package definition label)

⚠ The final approval of a submission package refers to the approval by the participant who has the authority to approve the submission package last on the submission route.

1. A querying participant refers to the participant currently querying the package data, regardless of the package’s submitter.

2. This is a member of the "Responsibility Splitter Dimension" used in the "Submission Route Definition" linked to the submission package definition with which the Excel file is associated, among the responsibility keys (set for each dimension) assigned to the participant.