|
|
ACCLGTRANS FILE
REFERENCED BY
BR00.3 BR10.1 BR450
UPDATED BY
AC300 AC310 BR120 BR122 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CGT-OBJ-ID Numeric 12 BR120 BR122
Object This is the object identifier. It is BR20.1 BR20.2
Identification used to relate commitments or posted BR20.3 BR20.4
transactions back to the originating BR20.5
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 BR122
Element: Cont Activity BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-BILL-ACTIVITY Alpha 15 BR120 BR122
Element: Bill Activity BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-ACCT-CATEGORY Alpha 5 BR120 BR122
Element: Account CategoAccount categories are groupings of BR20.1 BR20.2
costs, revenues, or a combination of BR20.3 BR20.4
both used for reporting and inquiries BR20.5
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 BR122
Element: Acct Cat Class BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-INVOICE-PREFIX Alpha 2
Element: Invoice Prefix
CGT-INVOICE-NBR Numeric 8
Element: Invoice Nbr
CGT-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
CGT-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the number that
represents a customer.
CGT-EXCEED-AMT Signed 15.2 BR120 BR122
Element: Exceed Amt BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-EXCEED-UNIT Signed 15.2 BR120 BR122
Element: Exceed Unit BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-MATRIX-CAT Alpha 12 BR120 BR122
Element: Attribute Attribute name assigned to an object BR20.1 BR20.2
(like accounting unit) to track BR20.3 BR20.4
additional information. Attribute BR20.5
values may then be used in selection and
sorting for report and analysis.
CGT-MX-VALUE Alpha 32 BR120 BR122
Element: Attribute Value BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CGT-LEVEL Numeric 1 BR120 BR122
Element: Level 1 = bill lvl billx ceiling BR20.1 BR20.2
2 = bill lvl billx matrix ceiling BR20.3 BR20.4
3 = bill lvl ceiling BR20.5
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
Element: Bid Name
CGT-AC-CUSTOMER-ID Alpha 5
Element: Ac Customer Id
ACCLGTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CGTSET1 OBJ-ID AC300 AC310
CONT-ACTIVITY BR120 BR122
BILL-ACTIVITY BR20.1 BR20.2
ACCT-CATEGORY BR20.3 BR20.4
ACCT-CAT-CLASS BR20.5
MATRIX-CAT
MX-VALUE
CGTSET2 CONT-ACTIVITY BR00.3 BR10.1
BILL-ACTIVITY BR120
ACCT-CATEGORY
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
HDT-SEQ-NBR-2
|
