Values

The following table defines the preset variables that are available for use in conditional script expressions:

API—Object reference to the running API

strLoc—String value that contains the name of the location being processed

VarValues—A variant array that contains the record values that are being mapped and the record values that were previously mapped

Variable

Record Value Mapped

Variable Type

varValues(1) =

Current Location ID number

Long Integer

varValues(2) =

Current Category ID number

Long Integer

varValues(3) =

Current Period Key value

Date

varValues(4) =

Current Data View

String (default = YTD)

varValues(5) =

Currency key assigned to the location

String

varValues(6) =

Calculation type for the current record

Long Integer: 9 = Base, 5 = Logic Export, -1 = Logic Non-Export

Logic

(No Export)

 

varValues(7) =

Sign Change flag for the current record

Boolean: 0 = False, -1 = True

varValues(8) =

Journal ID for the current record

String (NULL, if not a journal)

varValues(9) =

Amount for the current record

Double

varValues(10) =

Supplemental Amount for the current record

Double (0, unless populated by a custom script)

varValues(11) =

Account description for the current record

String

varValues(12) =

Supplemental Account description for the current record

String (NULL, unless populated by a custom script)

varValues(13) =

Source Account

String

varValues(14) =

Target Account

String (NULL if the current dimension has not been processed)

varValues(15) =

Source Entity

String

varValues(16) =

Target Entity

String (NULL, if the current dimension has not been processed)

varValues(17) =

Source ICP

String

varValues(18) =

Target ICP

String (NULL, if the current dimension has not been processed)

varValues(19) =

Source UD1

String

varValues(20) =

Target UD1

String (NULL, if the current dimension has not been processed)

varValues(21) =

Source UD2

String

varValues(22) =

Target UD2

String (NULL, if the current dimension has not been processed)

varValues(23) =

Source UD3

String

varValues(24) =

Target UD3

String (NULL, if the current dimension has not been processed)

varValues(25) =

Source UD4

String

varValues(26) =

Target UD4

String (NULL, if the current dimension has not been processed)

varValues(27) =

Source UD5

String

varValues(28) =

Target UD5

String (NULL, if the current dimension has not been processed)

varValues(29) =

Source UD6

String

varValues(30) =

Target UD6

String (NULL, if the current dimension has not been processed)

varValues(31) =

Source UD7

String)

varValues(32) =

Target UD7

String (NULL, if the current dimension has not been processed)

varValues(33) =

Source UD8

String

varValues(34) =

Target UD8

String (NULL, if the current dimension has not been processed)

varValues(35) =

Source UD9

String

varValues(36) =

Target UD9

String (NULL, if the current dimension has not been processed)

varValues(37) =

Source UD10

String

varValues(38) =

Target UD10

String (NULL, if the current dimension has not been processed)

varValues(39) =

Source UD11

String

varValues(40) =

Target UD11

String (NULL, if the current dimension has not been processed)

varValues(41) =

Source UD12

String

varValues(42) =

Target UD12

String (NULL, if the current dimension has not been processed)

varValues(43) =

Source UD13

String

varValues(44) =

Target UD13

String (NULL, if the current dimension has not been processed)

varValues(45) =

Source UD14

String

varValues(46) =

Target UD14

String, Null if this dimension has not processed yet

varValues(47) =

Source UD15

String

varValues(48) =

Target UD15

String, Null if this dimension has not processed yet

varValues(49) =

Source UD16

String

varValues(50) =

Target UD16

String, Null if this dimension has not processed yet

varValues(51) =

Source UD17

String

varValues(52) =

Target UD17

String, Null if this dimension has not processed yet

varValues(53) =

Source UD18

String

varValues(54) =

Target UD18

String, Null if this dimension has not processed yet

varValues(55) =

Source UD19

String

varValues(56) =

Target UD19

String, Null if this dimension has not processed yet

varValues(57) =

Source UD20

String

varValues(58) =

Target UD20

String (NULL, if the current dimension has not been processed)

varValues(59) =

Archive Document ID number for the current record

Long Integer