ACCLGTRANS FILE
REFERENCED BY
BR00.1 BR00.2 BR00.3 BR10.1 BR10.2 BR450
UPDATED BY
AC300 AC310 BR120 BR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGT-OBJ-ID Numeric 12 BR120 BR21.1
Object This is the object identifier. It is
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
CGT-CONT-ACTIVITY Alpha 15 BR120 BR21.1
Cont Activity
CGT-BILL-ACTIVITY Alpha 15 BR120 BR21.1
Bill Activity
CGT-ACCT-CATEGORY Alpha 5 BR120 BR21.1
Account Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
CGT-ACCT-CAT-CLASS Alpha 5 BR120 BR21.1
Acct Cat Class
CGT-INVOICE-PREFIX Alpha 2
Invoice Prefix
CGT-INVOICE-NBR Numeric 8
Invoice Nbr
CGT-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
CGT-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
CGT-EXCEED-AMT Signed 15.2 BR120 BR21.1
Exceed Amt
CGT-EXCEED-UNIT Signed 15.2 BR120 BR21.1
Exceed Unit
CGT-MATRIX-CAT Alpha 12 BR120 BR21.1
Attribute Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
CGT-MX-VALUE Alpha 32 BR120 BR21.1
Attribute Value
CGT-LEVEL Numeric 1 BR120 BR21.1
Level 1 = bill lvl billx ceiling
2 = bill lvl billx matrix ceiling
3 = bill lvl ceiling
4 = bill lvl matrix ceiling
5 = cont lvl billx ceiling
6 = cont lvl billx matrix ceiling
7 = cont lvl bill ceiling
8 = cont lvl bill matrix ceiling
9 = contract ceiling
CGT-CONTRACT Alpha 10
Contract
CGT-AC-CUSTOMER-ID Alpha 5
Ac Customer Id
ACCLGTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGTSET1 OBJ-ID AC300 AC310
CONT-ACTIVITY BR120 BR21.1
BILL-ACTIVITY
ACCT-CATEGORY
ACCT-CAT-CLASS
MATRIX-CAT
MX-VALUE
CGTSET2 CONT-ACTIVITY BR00.1 BR00.2
BILL-ACTIVITY BR00.3 BR10.1
ACCT-CATEGORY BR10.2 BR120
ACCT-CAT-CLASS
MATRIX-CAT
MX-VALUE
OBJ-ID
CGTSET3 BILL-ACTIVITY BR450
COMPANY
CUSTOMER
INVOICE-PREFIX
INVOICE-NBR
OBJ-ID
CONT-ACTIVITY
ACCT-CATEGORY
ACCT-CAT-CLASS
MATRIX-CAT
MX-VALUE
ACCLGTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
CGT-CONTRACT -> HIH-CONTRACT
CGT-COMPANY -> HIH-COMPANY
CGT-CUSTOMER -> HIH-CUSTOMER
CGT-AC-CUSTOMER-ID -> HIH-AC-CUSTOMER-ID
CGT-INVOICE-PREFIX -> HIH-INVOICE-PREFIX
CGT-INVOICE-NBR -> HIH-INVOICE-NBR
Actrans ACTRANS Required
CGT-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
CGT-OBJ-ID -> ATN-OBJ-ID
Actranserr ACTRANSERR Required
CGT-OBJ-ID -> TER-OBJ-ID
ACCLGTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
CGT-OBJ-ID -> HDT-ATN-OBJ-ID
CGT-CONTRACT -> HDT-CONTRACT
CGT-COMPANY -> HDT-COMPANY
CGT-CUSTOMER -> HDT-CUSTOMER
CGT-AC-CUSTOMER-ID -> HDT-AC-CUSTOMER-ID
CGT-INVOICE-PREFIX -> HDT-INVOICE-PREFIX
CGT-INVOICE-NBR -> HDT-INVOICE-NBR
HDT-LINE-NBR
HDT-SEQ-NBR
|
