Lawson Insight Technical Documentation |
|
ACCTLGRPHD
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 AC290
UPDATED BY
AC40.1 AC40.4 AC41.1 AC41.4 AC45.4 BR41.1
BR41.4 BR43.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGH-TRANS-TYPE Alpha 1 AC40.1 AC40.4
Element: Transaction TyRequired key. This field determines if AC41.1 AC41.4
the transaction processes amounts or BR41.1 BR41.4
units. BR43.1
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
CGH-CONTROL-GROUP Numeric 8 AC40.1 AC40.4
Element: Control Group Required key. This field contains the AC41.1 AC41.4
control group number used for process BR41.1 BR41.4
control of the journal entry detail. BR43.1
CGH-DESCRIPTION Alpha 30 (Lower Case) AC40.1 AC40.4
Control Group This is the control group description. AC41.1 AC41.4
Description BR41.1 BR41.4
BR43.1
CGH-BATCH-DATE Numeric 8 (yyyymmdd) AC40.1 AC40.4
Element: Batch Date This is the date the batch of AC41.1 AC41.4
transactions for the control group was BR41.1 BR41.4
processed. BR43.1
CGH-COMPANY Numeric 4 AC40.1 AC40.4
Element: Company This is the responsible company. AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-BASE-ND Numeric 1 AC40.1 AC40.4
Base Number of This is the number of decimal positions AC41.1 AC41.4
Decimals defined for the activity group currency. BR41.1 BR41.4
BR43.1
CGH-DEBIT-TOTAL Signed 18.2 AC40.1 AC40.4
Element: Debit Total This is the total debit amount for this AC41.1 AC41.4
batch of transactions. The debit amount BR41.1 BR41.4
must equal the credit amount. BR43.1
CGH-CREDIT-TOTAL Signed 18.2 AC40.1 AC40.4
Element: Credit Total This is the total credit amount for AC41.1 AC41.4
this batch of transactions. The credit BR41.1 BR41.4
amount must equal the debit amount. BR43.1
CGH-UNIT-DEBITS Signed 15.2 AC40.1 AC40.4
Element: Unit Debits This is the total of unit debits. AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-UNIT-CREDITS Signed 15.2 AC40.1 AC40.4
Element: Unit Credits This is the total of unit credits. AC41.1 AC41.4
BR41.1 BR41.4
BR43.1
CGH-LAST-REC-SEQ Numeric 6 AC40.1 AC40.4
Last Record This is the sequence number of the last AC41.1 AC41.4
Sequence Number record processed. 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 KeyChange AC40.1 AC40.3
CONTROL-GROUP 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
CGH-COMPANY -> GLS-COMPANY
ACCTLGRPHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|