ACIFCAT

UPDATED BY
AC58.1 AC58.3 AC58.2 AC558

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CIF-STRUCTURE
Element: Structure
Alpha 15
The name of the category structure.
AC58.1
CIF-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC58.1
CIF-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC58.1
CIF-DEPTH
Element: Depth
Numeric 2
The level depth of the summary account category.
AC58.1
CIF-SEQ-NUMBER
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
AC58.1
CIF-PARENT-SUM-CAT
Element: Parent Sum Cat
Alpha 5
Identifies 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.
AC58.1
CIF-CATEGORY-TYPE
Element: Category Type
Alpha 1
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
AC58.1
CIF-BUD-FLAG
Element: Bud Flag
Alpha 1
Budget edit flag for summary account categories.
D = Detail
N = No Edit
S = Summary
AC58.1
CIF-MATRIX-CAT
Element: Matrix Cat
Alpha 12 Occurs 11 Times
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.
AC58.3
CIF-MX-VALUE
Element: Mx Value
Alpha 32 Occurs 11 Times
The attribute value.
AC58.3


ACIFCAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CIFSET1 STRUCTURE
SUM-ACCT-CAT
AC558 AC58.1
AC58.2 AC58.3
CIFSET2 STRUCTURE
CATEGORY-TYPE
SEQ-NUMBER
SUM-ACCT-CAT
KeyChange
AC558 AC58.1


ACIFCAT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


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

Home
Contact Us



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