CAALLOCGRP

Allocation Group

This file contains the Allocation Group information.

REFERENCED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 CA05.1 CA05.2
CA10.1 CA10.2 CA10.4 CA10.6 CA10.7 CA110
CA15.1 CA15.2 CA160 CA200 GL110 GL145
GL146 GL148 GL167 GL170 GL190 GL191
GL196 GL197 GL199 GL300 GL40.1 GL40.2
GL40.3 GL40.6 GL40.7 GL40.8 GL41.4 GL44.1
GL45.1 GL500 GL70.1 GL70.2 GL70.3 GL70.6
GL75.1 IFGT.1 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MA70.1
MA75.1 MAI1.1


UPDATED BY
CA00.1 CA00.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAG-ALLOCATION-GRP
Element: Allocation Group		Alpha 12
The allocation group name. An allocation group is used to store allocations for a specific company or company group. The group is used in allocation calculation and allocation interface.
CA00.1 CA00.2
CAG-DESCRIPTION
Allocation Group
Description		Alpha 30 (Lower Case)
The allocation group description.
CA00.1 CA00.2
CAG-COMPANY-GROUP
Element: Company Group		Alpha 12
The company group where allocations are stored.
CA00.1 CA00.2
CAG-COMPANY
Element: Company		Numeric 4
The company number where allocations are stored.
CA00.1 CA00.2
CAG-ALLOC-TYPE
Element: Allocation Type		Alpha 1
This field determines which allocations are members of the group by allocation type. The default is 'All'. The values are: All A = Actual C = Current Year Budget N = Next Year Budget
CA00.1 CA00.2


CAALLOCGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAGSET1 ALLOCATION-GRP
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA110
CA15.1 CA15.2
CA160 CA200


CAALLOCGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
CAG-COMPANY->GLS-COMPANY
Glcpygrp GLCPYGRP Required
CAG-COMPANY-GROUP->GCG-COMPANY-GROUP


CAALLOCGRP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Caalocgpau CAALOCGPAU
CAG-ALLOCATION-GRP->CGA-ALLOCATION-GRP
  CGA-ACTION
  CGA-DATE
  CGA-TIME
  CGA-UNIQUE-I-D
Caheader CAHEADER
CAG-ALLOCATION-GRP->CAH-ALLOCATION-GRP
  CAH-ALLOC-TYPE
  CAH-COMPANY
  CAH-ALLOC-NAME

File created: Thu Jun 09 02:13:35 2016

Home
Contact Us



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