ACCTLGRPHD

Activity Control Group Header

This file contains header information about activity control groups from AC40.1 (Journal Entry) and AC41.1 (Resource Journal Entry).

REFERENCED BY
AC240 AC256 AC290


UPDATED BY
AC40.1 AC40.3 AC40.4 AC40.6 AC41.1 AC41.3
AC41.4 AC41.6 AC45.4 BR41.1 BR41.4 BR43.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGH-TRANS-TYPE
Element: Transaction Type		Alpha 1
Required key. This field determines if the transaction processes amounts or units.
A = AC Only
B = Both AC & GL
T = Time Entry
R = Resource AC Only
G = Resource AC & GL
C = Contract Only
D = Contract & GL
E = Revenue Only
F = Revenue & GL
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-CONTROL-GROUP
Element: Control Group		Numeric 8
Required key. This field contains the control group number used for process control of the journal entry detail.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-DESCRIPTION
Control Group
Description		Alpha 30 (Lower Case)
This is the control group description.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-BATCH-DATE
Element: Batch Date		Numeric 8 (yyyymmdd)
This is the date the batch of transactions for the control group was processed.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-COMPANY
Element: Company		Numeric 4
This is the responsible company.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-BASE-ND
Base Number of
Decimals		Numeric 1
This is the number of decimal positions defined for the activity group currency.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-DEBIT-TOTAL
Element: Debit Total		Signed 18.2
This is the total debit amount for this batch of transactions. The debit amount must equal the credit amount.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-CREDIT-TOTAL
Element: Credit Total		Signed 18.2
This is the total credit amount for this batch of transactions. The credit amount must equal the debit amount.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-UNIT-DEBITS
Element: Unit Debits		Signed 15.2
This is the total of unit debits.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-UNIT-CREDITS
Element: Unit Credits		Signed 15.2
This is the total of unit credits.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-LAST-REC-SEQ
Last Record
Sequence Number		Numeric 6
This is the sequence number of the last record processed.
AC40.1 AC40.4
AC41.1 AC41.4
BR41.1 BR41.4
BR43.1


ACCTLGRPHD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGHSET1 CONTROL-GROUP
AC240 AC256
AC290 AC40.1
AC40.3 AC40.4
AC40.6 AC41.1
AC41.3 AC41.4
AC41.6 AC45.4
BR41.1 BR41.4
CGHSET2 TRANS-TYPE
CONTROL-GROUP
KeyChange
AC40.1 AC40.3
AC40.4 AC40.6
AC41.1 AC41.3
AC41.4 AC41.6
AC45.4 BR41.1
BR41.4


ACCTLGRPHD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
CGH-COMPANY->GLS-COMPANY


ACCTLGRPHD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
CGH-CONTROL-GROUP->ATN-CONTROL-GROUP
  ATN-SEQUENCE-NBR
  ATN-TRAN-CURRENCY
  ATN-OBJ-ID
  ATN-ACTIVITY-GRP

File created: Thu Jun 09 11:04:05 2016

Home
Contact Us



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