ACCLGTRANS

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.
UPDATED BY
AC300 AC310 AC311 BR02.3 BR10.1 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR420 BR450 BR46.1 BR46.2 BR46.4 BR521
BR580 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGT-ATN-OBJ-ID
Element: Obj Id
Numeric 12
The system-defined object id associated with the Activity Management transaction (ACTRANS).
BR02.3 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 BRIP.1
CGT-LEVEL
Element: Level
Numeric 1
The level at which the ceiling is maintained. Posting or Summary Ceiling Levels 1 = ACBILLX (BR00.2) 2 = ACCEILING (BR00.3) 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)_
BR02.3 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 BRIP.1
CGT-ACTIVITY
Element: Activity
Alpha 15
The activity associated with the activity transaction.
BR02.3 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 BRIP.1
CGT-CONTRACT
Element: Contract
Alpha 15
The contract associated with the activity.
BR02.3 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 BRIP.1
CGT-EXCEED-AMT
Element: Intl Amt
Signed 18.2
The amount That is over the billing activity ceiling maintained in Billing (BR00.1) or Billing Detail (BR00.2) or Ceiling Levels (BR00.3).
BR02.3 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 BRIP.1
CGT-EXCEED-UNIT
Element: Exceed Unit
Signed 15.2
The unit amount that is related to the exceed amount that is over the ceiling.
BR02.3 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 BRIP.1


ACCLGTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGTSET1 ATN-OBJ-ID
LEVEL
AC300 AC310
AC311 BR02.3
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
BR580 BRIP.1
CGTSET2 CONTRACT
ATN-OBJ-ID
LEVEL
KeyChange
BR10.1 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
CGTSET3 ACTIVITY
ATN-OBJ-ID
LEVEL
KeyChange
BR450


File created: Thu Jun 09 11:10:48 2016

Home
Contact Us



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