Define Allocation Step - Target Page

Use the Define Allocation Step - Target page (ALLOC_TARGET) to define the destination for the allocation or the target record (journal or any table) and target field values.

Navigation:

Allocations, Define and Perform Allocations, Define Allocation Step, Target

This example illustrates the fields and controls on the Define Allocation Step - Target page. You can find definitions for the fields and controls later on this page.

Field or Control	Description
Target Record Type	Select one of the following: For Journals Records, specify a target ledger group name. The system uses this definition to determine the journal line record name and other characteristics (such as calendar, multibook, and base currency). If the target is Any Table, specify the table name in the edit box that becomes available.
Time Span	Use to specify the output for a single or multiple accounting periods for the target. Relative time spans, such as PER (current period activity), create the target relative to the as of date that is specified on the Allocation Request page. If the Target Record Type value is Journals Records, you must specify the time span value. If the target record is a table that has both FISCAL_YEAR and ACCOUNTING_PERIOD fields, you have the option to specify the time span value. If the target record is a table that does not have both FISCAL_YEAR and ACCOUNTING_PERIOD fields, you cannot specify the time span value. If you do not specify the time span value, the system populates both FISCAL_YEAR and ACCOUNTING_PERIOD with a zero value in the target record.
Basis Span Opt (basis span option)	If you use a multiperiod time span for the basis and target, select one of the following in the Basis Span Optfield: Combine Periods for Basis: Combines the basis amounts for each period that is defined by the time span into one virtual period, producing a single amount. Split Basis by Period: Maps the basis amount for each period one-to-one with the target periods. For this reason, the number of periods that is in the basis and target time span must match. When you select this option, the Target Span Opt field becomes inactive.

Field or Control	Description
Target Span Opt (target span option)	If you select a multiple period time span for the target, you must specify the Target Span Opt field when the basis time span is either a single period or multiple periods (the Basis Span Opt field is Combine Periods for Basis): Repeat Target Each Period: Repeats the entire target amount for each period that is defined in the time span. Divide Target Across Periods: Divides the target amount by the number of periods that are defined in the time span and distributes it equally to each period.
Field Name	If the target record is journals, the target record name is actually the journal line record name that is defined on the ledger template for the ledger group. The Field Name prompt table lists all fields that are in the target record. The system validates the Field Name field value that is entered against the record when you save this allocation step definition. Typically, you include any fields that are required by the target record including all the keys and any fields that affect functionality and those that you might decide are mandatory.
Source	Provides a convenient way to populate the target field values, particularly if the values are from the pool or basis records. You need not reenter them here, just prompt for the appropriate option and choose from the following: Pool: Uses the field values from pool records. Basis: Uses the field values from basis records. Group By: Uses the matched field values from both the pool and basis records. Value: Specifies a fixed value for the target field. You can use this only for character- or date-type fields. You should enter a fixed date in one of these formats: mmddyy, mm/dd/yy, or mm/dd/yyyy. If you select this option, you enter the value in the Value/Mask field. Begin Pd (begin period): Uses the beginning date for the target accounting period. If you use this option, the target time span must be populated. Otherwise, the system cannot populate a date value. End Period: Uses the end date for the target accounting period. If you use this option, the target time span must be populated. Otherwise, the system cannot populate a date value. Req Date (request date): Uses the as of date that is specified on the Allocation Request page. Seq Num (sequence number): Uses the next field sequence number for the target records. The allocations process selects the maximum field sequence number for the specified target criteria and increments the number by one. This option is used if the Target Record Type field value is Any Record.
Field Mapping	If the source is from Pool, Basis, or Group by, you can specify field mapping for those occasions when the field name for the pool or basis record differs from the field name that is in the target record. For example, this could occur if the Product field value for the target record must come from the Project field value of the pool record.
Value/Mask	If you specify a fixed value in the Source field, use this Value/Mask field for character or date-type fields. You can enter a fixed date in one of the following formats: mmddyy, mm/dd/yy, or mm/dd/yyyy.