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 PW110 BR450
UPDATED BY
AC300 AC310 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR156 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 BR120 BR122
Element: Obj Id The system-defined object id associated BR140 BR20.1
with the Activity Management BR20.2 BR20.3
transaction (ACTRANS). BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR521
CGT-LEVEL Numeric 1 BR120 BR122
Element: Level The level at which the ceiling is BR140 BR20.1
maintained. BR20.2 BR20.3
Posting or Summary Ceiling Levels BR20.4 BR20.5
1 = ACBILLX (BR00.2) BR46.1 BR46.2
2 = ACCEILING (BR00.3) BR46.4 BR521
3 = ACBILL (BR00.1)
4 = Not used
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 BR120 BR122
Element: Activity The activity associated with the BR140 BR20.1
activity transaction. BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR521
CGT-CONTRACT Alpha 15 BR120 BR122
Element: Contract The contract associated with the BR140 BR20.1
activity. BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR521
CGT-EXCEED-AMT Signed 18.2 BR120 BR122
Element: Intl Amt The amount That is over the billing BR140 BR20.1
activity ceiling maintained in Billing BR20.2 BR20.3
(BR00.1) or Billing Detail (BR00.2) or BR20.4 BR20.5
Ceiling Levels (BR00.3). BR46.1 BR46.2
BR46.4 BR521
CGT-EXCEED-UNIT Signed 15.2 BR120 BR122
Element: Exceed Unit The unit amount that is related to the BR140 BR20.1
exceed amount that is over the ceiling. BR20.2 BR20.3
BR20.4 BR20.5
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 BR120 BR122
BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BR521
BR580
CGTSET2 CONTRACT KeyChange BR10.1 BR120
ATN-OBJ-ID BR121 BR122
LEVEL BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
PW110
CGTSET3 ACTIVITY KeyChange AC310 BR450
ATN-OBJ-ID
LEVEL
|