Lawson Insight Technical Documentation |
|
ACRETNGX
ACRETNGX FILE
REFERENCED BY
BR450
UPDATED BY
AC300 AC310 BR01.1 BR01.2 BR02.3 BR120
BR121 BR122 BR123 BR140 BR151 BR152
BR156 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR420 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGX-ACTIVITY Alpha 15 BR01.1 BR122
Element: Activity Activities are the processes or BRIP.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RGX-SUM-ACCT-CAT Alpha 5 BR01.1 BR122
Element: Sum Acct Cat The name of the summary account BRIP.1
category.
RGX-ACCT-CATEGORY Alpha 5 BR01.1 BR122
Element: Acct Category Account categories are groupings of BRIP.1
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.
Valid account category types are:
cost
revenue
accrual
pass thru
RGX-SEQ-NBR Numeric 4 BR01.1 BR122
Element: Seq Nbr An automatically assigned sequence BRIP.1
number.
RGX-STATUS Numeric 1 BR01.1 BR02.3
Element: Status This field displays the status of the BR120 BR121
transaction. BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521 BRIP.1
RGX-DESCRIPTION Alpha 30 (Lower Case) BR01.1 BR122
Element: Description This field displays the description. BRIP.1
RGX-DATE Numeric 8 (yyyymmdd) BR122 BRIP.1
Element: Date This field displays the system date
when this was created.
RGX-PST-ACTIVITY Alpha 15 BR01.1 BR122
Element: Pst Activity BRIP.1
RGX-PST-ACCT-CAT Alpha 5 BR01.1 BR122
Element: Pst Acct Cat BRIP.1
RGX-PST-GL-CODE Alpha 4 BR122 BRIP.1
Element: Pst Gl Code
RGX-RETAINAGE-AMT Signed 18.2 BR01.1 BR122
Element: Intl Amt BRIP.1
RGX-RELEASED-AMT Signed 18.2 BR01.1 BR02.3
Element: Intl Amt BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RGX-BILL-AMT Signed 18.2 BR01.1 BR02.3
Element: Intl Amt BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
RGX-INVOICE-PREFIX Alpha 2 BR01.1 BR122
Element: Invoice Prefix BRIP.1
RGX-INVOICE-NBR Numeric 8 BR01.1 BR122
Element: Invoice Nbr BRIP.1
RGX-OBJ-ID Numeric 12 BR122 BRIP.1
Element: Obj Id This is the object identifier. It is
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.
RGX-CTR-CAT-GRP Alpha 5 BR01.1 BR122
Element: Ctr Cat Grp BRIP.1
ACRETNGX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGXSET1 ACTIVITY AC300 AC310
SUM-ACCT-CAT BR01.1 BR01.2
CTR-CAT-GRP BR02.3 BR120
ACCT-CATEGORY BR121 BR122
SEQ-NBR BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR450
BR521 BRIP.1
ACRETNGX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
RGX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Required
RGX-ACTIVITY -> ACV-ACTIVITY
Pst Acct Cat ACACCTCAT Required
RGX-PST-ACCT-CAT -> AAX-ACCT-CATEGORY
Pst Activity ACACTIVITY Required
RGX-PST-ACTIVITY -> ACV-ACTIVITY
Pst Gl Code ACGLCODE Required
RGX-PST-GL-CODE -> AGC-AC-GL-CODE
|