Function Arguments

To calculate properly, each function requires one or more arguments. You can further define an argument by including different switches and values.

Argument Example Description
account_number "101" An account number
class_id "TR"

A class identification number

See Class IDs for more information.

clp_code For the Operating Name of the linked client file, enter "CLP2"

A CLP code

See CLP Codes for more information.

expression 5*2 A mathematical expression
form "DISTRICT" A form name in the CaseView Database, used in conjunction with GROUP and Identifier
group "AREA" A group name in the CaseView Database, used in conjunction with FORM and Identifier
group_id "AA" A Working Papers group/leadsheet ID
group_number "1" A Working Papers group/leadsheet number
id "ALPHACELL" An identifier in the CaseView Database, used in conjunction with GROUP and FORM
map_number "2115" A map number
balance_type "BR"

The type of balance requested

See Balance Types for more information.

database_identifier

A universal argument
column_heading A universal argument
row_identifier A universal argument
tax_export_code "7125" A tax export code
user_defined_code "UD1" A user defined data code in CaseView
entity_id "ABC" Represents the ID code (abbreviation) for the entity entered in the Entity Properties dialog of the consolidated file
client_file "C:\Program Files\CaseWare\Data\Samp01"

Client File Path or GUID

Note: Hard-coded links, where the client_file argument is specified, are not modified during a copy template or year end close in the Working Papers file. If a new file is created after a year end close, the link paths will need to be modified to point to the new file.

document_number "FS" The document number
description_type "2"

0 - The report heading

1 - The extended description

2 - The extended description if it exists, otherwise the report heading

Switches

Use the following switches to modify linkage functions.

Switch Definition Example Description
:PAR Parent Only Balances

UDF

cw_map("BR:PAR", "100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:PAR", "100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:PAR", "100")|'

Links the report balance for map number 100 with all sub entity balances excluded.
:FX Include Foreign Exchange

UDF

cw_map("BR:FX","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:FX","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:FX","100")|'

Links the report balance for map number 100 with the foreign exchange rate applied.
:OBA Include Other Basis Adjustments

UDF

cw_map("BR:OBA","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:OBA","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:OBA","100")|'

Links the report balance for map number 100 with other basis adjustments included.
:SUB Include Sub Balances

UDF

cw_map("BR:SUB","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:SUB","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:SUB","100")|'

Links the report balance for map number 100 with all sub mapping balances included.

Sub mappings in this case include map numbers such as 100.1, 100.2 and 100.3 (if applicable).

:DISC Period Only

UDF

cw_map("BR:DISC","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:DISC","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:DISC","100")|'

Links the report balance for map number 100 for period only balances.
:PER0 Opening Period

UDF

cw_map("BR:PER0","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:PER0","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:PER0","100")|'

Links the report balance for map number 100 for the opening period.
:PP1 Prior Period

UDF

cw_map("BR:PP1","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:PP1","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:PP1","100")|'

Links the report balance for map number 100 for the prior period.
:Y:PER1 Yearly

UDF

cw_map("BR:Y:PER1","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:Y:PER1","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:Y:PER1","100")|'

Links the report balance for map number 100 for the yearly period.
:YRx

Where, x, is an integer value that represents the prior year.

Prior Year

UDF

cw_map("BR:YR1","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:YR1","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:YR1","100")|'

Links the report balance for map number 100 for prior year 1.
:USESIGN Use Sign

UDF

cw_map("BR:USESIGN","100")

DDE

The Microsoft Word document icon as displayed in the Document Manager map("BR:USESIGN","100")

The Microsoft Excel worksheet icon as displayed in the Document Manager cwin32|Data!'CWEval|active|map("BR:USESIGN","100")|'

Links the report balance for map number 100 with the sign property in the client file.

Balance Types

Use the following values to define the type of balances required by a linkage formula.

Value Description
BU Unadjusted Balance
BA Adjusted Balance
BR Report Balance
BC Consolidated Balance
BTC Consolidated Balance + Tax - Federal Adjustments
BTS Consolidated Balance + Tax - State Adjustments
BTC Consolidated Balance + Tax - City Adjustments
BB Budget Balance
BF Forecast Balance
BT Federal Tax Balance
AN Normal Adjustments
AE Eliminating Adjustments
AR Reclassifying Adjustments
AU Unrecorded Factual Adjustments
AL Unrecorded Projected Adjustments
AG Unrecorded Judgmental Adjustments
AF Federal Tax Adjustments
AS State Tax Adjustments
AC City Tax Adjustments
AB Other Basis Adjustments

Cxx

Where xx represents the custom balance identifier.

Custom Balance

Budget, Forecast and Custom Balances

Balance Type Budget Forecast Custom
Unadjusted Balance BBU BFU CxxU
Adjusted Balance BBA BFA CxxA
Report Balance BBR BFR CxxR
Consolidated Balance BBC BFC CxxC
Federal Tax Balance BBT BFT CxxT
Normal Adjustments AN:ADJB AN:ADJF AN:ADJCxx
Eliminating Adjustments AE:ADJB AE:ADJF AE:ADJCxx
Reclassifying Adjustments AR:ADJB AR:ADJF AR:ADJCxx
Unrecorded Factual Adjustments AU:ADJB AU:ADJF AU:ADJCxx
Unrecorded Projected Adjustments AL:ADJB AL:ADJF AL:ADJCxx
Unrecorded Judgmental Adjustments AG:ADJB AG:ADJF AG:ADJCxx
Federal Tax Adjustments AF:ADJB AF:ADJF AF:ADJCxx
State Tax Adjustments AS:ADJB AS:ADJF AS:ADJCxx
City Tax Adjustments AC:ADJB AC:ADJF AC:ADJCxx
Other Basis Adjustments AB:ADJB AB:ADJF AB:ADJCxx

Class IDs

Use the following values to define the class required by a linkage formula.

Value Description
TR Assets - Current - trade receivable
QA Assets - Current - other quick
IN Assets - Current - inventory
CA Assets - Current – other
FD Assets - Capital - amortized cost
FN Assets - Capital non-amortized cost
FA Assets - Capital - accumulated amortization
IA Assets - Capital asset
OA Assets - Other asset
TP Liabilities - Current - trade payable
CL Liabilities - Current - other
LL Liabilities - Long term
DI Equity – Dividend
RE Equity - Retained earnings
EQ Equity – Other
SA Revenue - Credit sales
SO Revenue - Other sales
RO Revenue – Other
CD Expense - cost of sales - amortization
CN Expense - cost of sales - non-cash
CI Expense - cost of sales - interest
PU Expense - cost of sales - purchase
CR Expense - cost of sales - repair and maintenance
CS Expense - cost of sales - other cost of sales
OD Expenses - other - amortization
ON Expenses - other - non-cash
IT Expenses - other - income tax expense
OI Expenses - other - interest
OR Expenses - other - repairs and maintenance
OE Expenses - other - other expenses