Lawson Insight Technical Documentation |
|
ACCLGTRANS
ACCLGTRANS FILE
This file contains the exceeded amounts for billed transactions that are
applied to the ceilings in Activity Billing (BR00.1), Billing Detail
(BR00.2), Ceiling Levels (BR00.3) and Contract Detail (BR10.2).
The file includes the transaction obj id, activity, contract, ceiling level,
and the exceed amount and units.
REFERENCED BY
BR580 BR10.1 BR10.2 BR450
UPDATED BY
AC300 AC310 BR02.3 BR120 BR121 BR122
BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR420 BR46.1 BR46.2 BR46.4 BR521
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGT-ATN-OBJ-ID Numeric 12 BR02.3 BR120
Object The system-defined object id associated BR121 BR122
Identification with the Activity Management BR140 BR20.1
transaction (ACTRANS). BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521
CGT-LEVEL Numeric 1 BR02.3 BR120
Element: Level The level at which the ceiling is BR121 BR122
maintained. BR140 BR20.1
Posting or Summary Ceiling Levels BR20.2 BR20.3
1 = ACBILLX (BR00.2) BR20.4 BR20.5
2 = ACCEILING (BR00.3) BR420 BR46.1
3 = ACBILL (BR00.1) BR46.2 BR46.4
4 = Not used BR521
Contract Ceiling Levels
5 = ACBILLX (BR00.2)
6 = ACCEILING (BR00.3)
7 = ACBILL (BR00.1)
8 = Not used
9 - Contract (BR10.2)_
CGT-ACTIVITY Alpha 15 BR02.3 BR120
Element: Activity The activity associated with the BR121 BR122
activity transaction. BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521
CGT-CONTRACT Alpha 10 BR02.3 BR120
Element: Contract The contract associated with the BR121 BR122
activity. BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521
CGT-EXCEED-AMT Signed 18.2 BR02.3 BR120
Element: Intl Amt The amount That is over the billing BR121 BR122
activity ceiling maintained in Billing BR140 BR20.1
(BR00.1) or Billing Detail (BR00.2) or BR20.2 BR20.3
Ceiling Levels (BR00.3). BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521
CGT-EXCEED-UNIT Signed 15.2 BR02.3 BR120
Element: Exceed Unit The unit amount that is related to the BR121 BR122
exceed amount that is over the ceiling. BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521
ACCLGTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGTSET1 ATN-OBJ-ID AC300 AC310
LEVEL BR02.3 BR120
BR121 BR122
BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR46.1
BR46.2 BR46.4
BR521 BR580
CGTSET2 CONTRACT KeyChange BR10.1 BR10.2
ATN-OBJ-ID BR120 BR121
LEVEL BR122 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
CGTSET3 ACTIVITY KeyChange AC310 BR450
ATN-OBJ-ID
LEVEL
|