|
ACIFCAT FILE
UPDATED BY
AC58.1 AC58.3 AC558
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CIF-STRUCTURE Alpha 15 AC58.1
Element: Structure The name of the category structure.
CIF-SUM-ACCT-CAT Alpha 5 AC58.1
Element: Sum Acct Cat The name of the summary account
category.
CIF-DESCRIPTION Alpha 30 (Lower Case) AC58.1
Element: Description This field displays the description.
CIF-DEPTH Numeric 2 AC58.1
Element: Depth The level depth of the summary account
category.
CIF-SEQ-NUMBER Numeric 6 AC58.1
Element: Seq Number A unique number assigned to each
transaction to be interfaced into the
Lawson system.
CIF-PARENT-SUM-CAT Alpha 5 AC58.1
Element: Parent Sum CatIdentifies the parent summary account
category of summary account categories
at a depth > 1. If a summary category
is located at level 1, there will be no
parent.
CIF-CATEGORY-TYPE Alpha 1 AC58.1
Element: Category Type This Field is used to set up the
default category type for the
Distribution File.
(EEDISTRIB)
R = Revenue
C = Cost
P = Pass Thru
A = Accrual
CIF-BUD-FLAG Alpha 1 AC58.1
Element: Bud Flag Budget edit flag for summary account
categories.
D = Detail
N = No Edit
S = Summary
CIF-MATRIX-CAT Alpha 12 Occurs 11 Times AC58.3
Element: Matrix Cat Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
CIF-MX-VALUE Alpha 32 Occurs 11 Times AC58.3
Element: Mx Value The attribute value.
ACIFCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIFSET1 STRUCTURE AC558 AC58.1
SUM-ACCT-CAT AC58.2 AC58.3
CIFSET2 STRUCTURE KeyChange AC558 AC58.1
CATEGORY-TYPE
SEQ-NUMBER
SUM-ACCT-CAT
ACIFCAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acifcatx ACIFCATX
CIF-STRUCTURE -> CIX-STRUCTURE
CIF-SUM-ACCT-CAT -> CIX-SUM-ACCT-CAT
CIX-ACCT-CATEGORY
Acifcatxall ACIFCATX
CIF-STRUCTURE -> CIX-STRUCTURE
CIX-ACCT-CATEGORY
|