ACTOTBALX FILE
UPDATED BY
AC190 AC20.7 AC300 AC310 AC45.1 ACDR.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TOX-FISCAL-YEAR Numeric 4 AC190 AC20.7
Fiscal Year This is the current fiscal year. This AC45.1 ACDR.1
field is updated by Period Closing
(GL199).
TOX-BUDGET-NBR Numeric 3 AC190 AC20.7
Budget Number The Budget Number field contains the AC45.1 ACDR.1
budget number.
TOX-ACTIVITY-GRP Alpha 15 AC190 AC20.7
Activity Group AC45.1 ACDR.1
TOX-ACTIVITY Alpha 15 AC190 AC20.7
Activity Activities are the processes or AC45.1 ACDR.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
TOX-CATEGORY-TYPE Alpha 1 AC190 AC20.7
Category Type This Field is used to set up the AC45.1 ACDR.1
default category type for the
Distribution File.
(EEDISTRIB)
A = Accrual
C = Cost
R = Revenue
F = Fee
TOX-CURRENCY-CODE Alpha 5 AC190 AC20.7
Currency Code This field contains the company base AC45.1 ACDR.1
currency code established in Company
(GL10.1 ).
TOX-PERIOD Numeric 2 AC190 AC20.7
Last Closed Period This is the current accounting period. AC45.1 ACDR.1
This field is updated by Period Closing
(GL199).
TOX-PARENT-ACTV Alpha 15 AC190 AC20.7
Parent Actv AC45.1 ACDR.1
TOX-AMOUNT Currency 15.2 AC190 AC20.7
Amount This is the amounts by period for the AC310 AC45.1
specified record. ACDR.1
TOX-UNIT Signed 15.2 AC190 AC20.7
Unit AC310 AC45.1
ACDR.1
ACTOTBALX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TOXSET1 FISCAL-YEAR AC190 AC20.7
BUDGET-NBR AC310 AC45.1
ACTIVITY-GRP ACDR.1
ACTIVITY
CURRENCY-CODE
CATEGORY-TYPE
PERIOD
TOXSET2 ACTIVITY-GRP AC300 AC310
PARENT-ACTV ACDR.1
CURRENCY-CODE
BUDGET-NBR
CATEGORY-TYPE
FISCAL-YEAR
PERIOD
ACTIVITY
ACTOTBALX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
TOX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
TOX-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
TOX-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACV-VAR-LEVELS -> LVL-VAR-LEVELS
Actotbalx Prnt ACTOTBALX Not Required
Valid When TOX-ACTIVITY != Spaces
TOX-FISCAL-YEAR -> TOX-FISCAL-YEAR
TOX-BUDGET-NBR -> TOX-BUDGET-NBR
TOX-ACTIVITY-GRP -> TOX-ACTIVITY-GRP
TOX-PARENT-ACTV -> TOX-ACTIVITY
TOX-CURRENCY-CODE -> TOX-CURRENCY-CODE
TOX-CATEGORY-TYPE -> TOX-CATEGORY-TYPE
TOX-PERIOD -> TOX-PERIOD
ACTOTBALX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acconsolx ACCONSOLX
TOX-FISCAL-YEAR -> CSX-FISCAL-YEAR
TOX-PERIOD -> CSX-PERIOD
TOX-ACTIVITY-GRP -> CSX-ACTIVITY-GRP
TOX-ACTIVITY -> CSX-ACTIVITY
TOX-CURRENCY-CODE -> CSX-CURRENCY-CODE
TOX-BUDGET-NBR -> CSX-BUDGET-NBR
CSX-ACCT-CATEGORY
Acconsolx Grp ACCONSOLX
TOX-FISCAL-YEAR -> CSX-FISCAL-YEAR
TOX-PERIOD -> CSX-PERIOD
TOX-ACTIVITY-GRP -> CSX-ACTIVITY-GRP
Spaces -> CSX-ACTIVITY
TOX-CURRENCY-CODE -> CSX-CURRENCY-CODE
TOX-BUDGET-NBR -> CSX-BUDGET-NBR
CSX-ACCT-CATEGORY
Accuamtx ACCUAMTX
TOX-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
TOX-ACTIVITY -> ACX-ACTIVITY
TOX-CURRENCY-CODE -> ACX-CURRENCY-CODE
TOX-FISCAL-YEAR -> ACX-FISCAL-YEAR
TOX-PERIOD -> ACX-PERIOD
TOX-BUDGET-NBR -> ACX-BUDGET-NBR
ACX-ACCT-CATEGORY
Acmasterx ACMASTERX
TOX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
TOX-ACTIVITY -> MSX-ACTIVITY
TOX-FISCAL-YEAR -> MSX-FISCAL-YEAR
TOX-PERIOD -> MSX-PERIOD
MSX-ACCT-CATEGORY
Actotbalx Chld ACTOTBALX
Valid When TOX-ACTIVITY != Spaces
TOX-ACTIVITY-GRP -> TOX-ACTIVITY-GRP
TOX-ACTIVITY -> TOX-PARENT-ACTV
TOX-CURRENCY-CODE -> TOX-CURRENCY-CODE
TOX-BUDGET-NBR -> TOX-BUDGET-NBR
TOX-CATEGORY-TYPE -> TOX-CATEGORY-TYPE
TOX-FISCAL-YEAR -> TOX-FISCAL-YEAR
TOX-PERIOD -> TOX-PERIOD
TOX-ACTIVITY
|
