|
|
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
Element: Last Closed YeThis 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
Element: Budget Number The Budget Number field contains the AC45.1 ACDR.1
budget number.
TOX-ACTIVITY-GRP Alpha 15 AC190 AC20.7
Element: Group AC45.1 ACDR.1
TOX-ACTIVITY Alpha 15 AC190 AC20.7
Element: 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
Element: 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
Element: 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
Element: Current PeriodThis 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
Element: Parent Actv AC45.1 ACDR.1
TOX-AMOUNT Currency 15.2 AC190 AC20.7
Element: Amount This is the amounts by period for the AC310 AC45.1
specified record. ACDR.1
TOX-UNIT Signed 15.2 AC190 AC20.7
Element: 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
|
