Lawson - Lawson Software Technical Library - Data File Text for ACTOTBAL

ACTOTBAL

REFERENCED BY

ACTA.1

UPDATED BY

AC10.1 AC121 AC123 AC127 AC145 AC20.1

AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7

AC21.5 AC22.1 AC300 AC45.1 ACDR.1 AC93.2

AC93.3 AC93.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY

TOT-FISCAL-YEAR
Element: Year Numeric 4
Contains the fiscal year for the data stored on this record.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-BUDGET-NBR
Element: Budget Nbr Numeric 3
The Budget Number field contains the budget number.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-ACTIVITY-GRP
Element: Activity Grp Alpha 15
The activity group is the overall project.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-ACTIVITY
Element: Activity Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-CATEGORY-TYPE
Element: Category Type Alpha 1
This Field is used to set up the default category type for the Distribution File. (EEDISTRIB)
A = Accrual
C = Cost
R = Revenue
F = Fee

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-CURRENCY-CODE
Element: Currency Code Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-LEVEL-DEPTH
Element: Level Depth Numeric 1
The number of variable levels pertaining to this record.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-VAR-LEVELS
Element: Var Levels Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-PARENT-ACTV
Element: Parent Actv Alpha 15
The parent activity field contains the activity name of the member parent.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-BALANCE-AMOUNT
Element: Intl Amt Signed 18.2

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-BALANCE-UNIT
Element: Balance Unit Signed 17.2

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-BEGIN-BAL-AMT
Element: Intl Amt Signed 18.2

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-BEGIN-BAL-UNT
Element: Begin Bal Unt Signed 15.2
The units beginning balance.

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-PERIOD-AMT
Element: Intl Amt Signed 18.2 Occurs 13 Times

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

TOT-PERIOD-UNIT
Element: Unit Signed 15.2 Occurs 13 Times

AC121 AC123

AC127 AC20.1

AC20.2 AC20.3

AC20.4 AC20.5

AC20.6 AC20.7

AC21.5 AC22.1

ACDR.1

ACTOTBAL FILE INDEX

NAME

KEY FIELDS

DESCRIPTION / SUBSET CONDITION

USED IN

TOTSET1

FISCAL-YEAR
BUDGET-NBR
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
CATEGORY-TYPE

AC10.1	AC121
AC123	AC127
AC20.1	AC20.2
AC20.3	AC20.4
AC20.5	AC20.6
AC20.7	AC21.5
AC22.1	ACDR.1
ACTA.1

TOTSET2

ACTIVITY-GRP
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*
ACTIVITY

KeyChange

AC300

TOTSET4

ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR*

AC121	AC123
AC127	AC20.1
AC20.2	AC20.3
AC20.4	AC20.5
AC20.6	AC20.7
AC21.5	AC22.1
AC93.2	AC93.3
AC93.4	ACDR.1
ACTA.1

TOTSET5

ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR

KeyChange

AC10.1	AC121
AC123	AC127
AC145	AC20.1
AC20.2	AC20.3
AC20.4	AC20.5
AC20.6	AC20.7
AC21.5	AC22.1
AC45.1	ACDR.1

ACTOTBAL FILE RELATIONS

ONE TO ONE RELATIONS

RELATION
NAME

RELATED FILE

INTEGRITY RULES / FIELD MATCH

Acactgrp

ACACTGRP

Required

TOT-ACTIVITY-GRP

AGP-ACTIVITY-GRP

Acactivity

ACACTIVITY

Required

TOT-ACTIVITY

ACV-ACTIVITY

Actotbal Parnt

ACTOTBAL

Not Required

Valid When

TOT-ACTIVITY

Spaces

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
TOT-PARENT-ACTV	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-CATEGORY-TYPE	->	TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR	->	TOT-FISCAL-YEAR

ACTOTBAL FILE RELATIONS

ONE TO MANY RELATIONS

RELATION
NAME

RELATED FILE

INTEGRITY RULES / FIELD MATCH

Acconsol

ACCONSOL

Valid When		ACV-POSTING-FLAG	=	"S"
Or		ACV-POSTING-FLAG	=	"C"

TOT-FISCAL-YEAR	->	CSL-FISCAL-YEAR
TOT-BUDGET-NBR	->	CSL-BUDGET-NBR
TOT-ACTIVITY-GRP	->	CSL-ACTIVITY-GRP
TOT-ACTIVITY	->	CSL-ACTIVITY
TOT-CURRENCY-CODE	->	CSL-CURRENCY-CODE
		CSL-ACCT-CATEGORY

Acconsol Grp

ACCONSOL

TOT-FISCAL-YEAR	->	CSL-FISCAL-YEAR
TOT-BUDGET-NBR	->	CSL-BUDGET-NBR
TOT-ACTIVITY-GRP	->	CSL-ACTIVITY-GRP
Spaces	->	CSL-ACTIVITY
TOT-CURRENCY-CODE	->	CSL-CURRENCY-CODE
		CSL-ACCT-CATEGORY

Accuamt

ACCUAMT

TOT-ACTIVITY-GRP	->	ACU-ACTIVITY-GRP
TOT-ACTIVITY	->	ACU-ACTIVITY
TOT-BUDGET-NBR	->	ACU-BUDGET-NBR
TOT-CURRENCY-CODE	->	ACU-CURRENCY-CODE
TOT-FISCAL-YEAR	->	ACU-FISCAL-YEAR
		ACU-ACCT-CATEGORY

Acmaster

ACMASTER

Valid When

ACV-POSTING-FLAG

"P"

TOT-ACTIVITY-GRP	->	MST-ACTIVITY-GRP
TOT-ACTIVITY	->	MST-ACTIVITY
TOT-FISCAL-YEAR	->	MST-FISCAL-YEAR
		MST-ACCT-CATEGORY

Actotbal Child

ACTOTBAL

Valid When

TOT-ACTIVITY

Spaces

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
TOT-ACTIVITY	->	TOT-PARENT-ACTV
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-CATEGORY-TYPE	->	TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR	->	TOT-FISCAL-YEAR
		TOT-ACTIVITY

Actotbal Type

ACTOTBAL

TOT-FISCAL-YEAR	->	TOT-FISCAL-YEAR
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
TOT-ACTIVITY	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
		TOT-CATEGORY-TYPE

Actotbal Year

ACTOTBAL

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
TOT-ACTIVITY	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-CATEGORY-TYPE	->	TOT-CATEGORY-TYPE
		TOT-FISCAL-YEAR

Actotbal Yr Tp

ACTOTBAL

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
TOT-ACTIVITY	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
		TOT-CATEGORY-TYPE
		TOT-FISCAL-YEAR

Tot Type Grp

ACTOTBAL

TOT-FISCAL-YEAR	->	TOT-FISCAL-YEAR
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
Spaces	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
		TOT-CATEGORY-TYPE

Tot Year Grp

ACTOTBAL

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
Spaces	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
TOT-CATEGORY-TYPE	->	TOT-CATEGORY-TYPE
		TOT-FISCAL-YEAR

Tot Yr Tp Grp

ACTOTBAL

TOT-ACTIVITY-GRP	->	TOT-ACTIVITY-GRP
Spaces	->	TOT-ACTIVITY
TOT-CURRENCY-CODE	->	TOT-CURRENCY-CODE
TOT-BUDGET-NBR	->	TOT-BUDGET-NBR
		TOT-CATEGORY-TYPE
		TOT-FISCAL-YEAR

File created: Thu Jun 09 02:03:16 2016

Home
Contact Us

All trademarks and registered trademarks are the property of their respective owners.