|
|
ACCTLGRPHD FILE
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
UPDATED BY
AC300 AC40.1 AC41.1 AC42.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGH-ACTIVITY Alpha 15 AC40.1 AC41.1
Activity Required key. This is the activity for AC42.1
the control group.
CGH-TRANS-TYPE Alpha 1 AC40.1 AC41.1
Transaction Type Required key. This field determines if AC42.1
the transaction processes amounts or
units.
A = AC Only
B = AC & GL
T = Time
R = Resource
CGH-CONTROL-GROUP Numeric 8 AC40.1 AC41.1
Control Group Required key. This field contains the AC42.1
control group number used for process
control of the journal entry detail.
CGH-CURRENCY-CODE Alpha 5 AC40.1 AC41.1
Currency Code This field indicates the base currency AC42.1
code for the activity group. It is
defined in AC00.1 (Activity Group).
CGH-CURRENCY-TABLE Alpha 12
Currency Table This is the currency table, a table of
currency relationships, currency
exchange rates, and translation rates
for one or more companies.
CGH-COMPANY Numeric 4 AC40.1 AC41.1
Company This is the responsible company.
CGH-DESCRIPTION Alpha 30 (Lower Case) AC40.1 AC41.1
Control Group This is the control group description. AC42.1
Description
CGH-BATCH-DATE Numeric 8 (yyyymmdd) AC40.1 AC41.1
Batch Date This is the date the batch of AC42.1
transactions for the control group was
processed.
CGH-BASE-ND Numeric 1 AC40.1 AC41.1
Base Number of This is the number of decimal positions AC42.1
Decimals defined for the activity group currency.
CGH-DEBIT-TOTAL Signed 15.2 AC40.1 AC41.1
Debit Total This is the total debit amount for this AC42.1
batch of transactions. The debit amount
must equal the credit amount.
CGH-CREDIT-TOTAL Signed 15.2 AC40.1 AC41.1
Credit Total This is the total credit amount for AC42.1
this batch of transactions. The credit
amount must equal the debit amount.
CGH-UNIT-DEBITS Signed 15.2 AC40.1 AC41.1
Unit Debits This is the total of unit debits. AC42.1
CGH-UNIT-CREDITS Signed 15.2 AC40.1 AC41.1
Unit Credits This is the total of unit credits. AC42.1
CGH-LAST-REC-SEQ Numeric 6 AC40.1 AC41.1
Last Record This is the sequence number of the last AC42.1
Sequence Number record processed.
ACCTLGRPHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGHSET1 ACTIVITY AC240 AC256
TRANS-TYPE AC300 AC40.1
CONTROL-GROUP AC41.1 AC42.1
CGHSET2 ACTIVITY Duplicates AC40.1 AC41.1
BATCH-DATE AC42.1
TRANS-TYPE
CONTROL-GROUP
CGHSET3 ACTIVITY
CONTROL-GROUP
BATCH-DATE
TRANS-TYPE
ACCTLGRPHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
CGH-ACTIVITY -> ATN-ACTIVITY (ATNSET7)
CGH-CONTROL-GROUP -> ATN-CONTROL-GROUP
ATN-SEQUENCE-NBR
ATN-OBJ-ID
ATN-ACTIVITY-GRP
|