|
|
ACBLRATEX FILE
Activity Billing Rates Detail
This file contains detailed billing rate information from the BR03 forms. It
includes rate schedule, attribute and attribute value, effective date, and
billing rate. You can run a listing of billing rates by runnning BR203
(Billing Rate Listing).
REFERENCED BY
AC190 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC54.1 AC540 ACAC.1 BR190 BR20.6 BR203
BR40.3 BR46.1 BR46.2 BR46.4 ET540
UPDATED BY
AC300 AC310 BR03.1 BR03.2 BR03.3 BR00.1
BR00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALX-ACTIVITY Alpha 15 BR03.1 BR03.2
Element: Activity The activity established in the Billing BR03.3
Category Rates (BR03.1) or Units of
Production Rates (BR03.2).
ALX-ACCT-CATEGORY Alpha 5 BR03.1 BR03.2
Element: Acct Category The account category associated with the BR03.3
activity maintained in Billing Category
Rates (BR03.1) or the Units of
Production Rates (BR03.2). A blank value
in the account category or summary
account category indicates that the
rates are valid for all account
categories associated with the activity.
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.
ALX-SOURCE-CODE Alpha 2 BR03.1 BR03.2
Element: Source Code The Source Code is established in Source BR03.3
Code (GL05) and maintained in Billing
Category Rates (BR03.1) or Units of
Production Rates (BR03.2). A blank
value in this field indicates that the
rates are valid for all source codes
related to Activity Management.
ALX-MATRIX-CAT Alpha 12 BR03.1 BR03.2
Element: Attribute A billing rate attribute can be defined BR03.3
as part of the key for Activity
Management billing transactions.
The attribute is established in MX00.1.
The attribute must have an object type
of ACTRN established.
ALX-DESCRIPTION Alpha 30 (Lower Case) BR03.1 BR03.3
Element: Description The billing category description which
is associated with the category
selected.
ALX-MX-VALUE Alpha 32 BR03.1 BR03.2
Element: Attribute ValuKey field. This field is required if an BR03.3
attribute is defined.
The value for this field is UOM if the
Unit Type field in the Activity Billing
Rate Header file is Units of Production.
ALX-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR03.1 BR03.2
Element: Effective DateThe effective date is the date the BR03.3
record is first valid . The date is
maintained on the Billing Category Rates
(BR03.1) or Units of Production (B03.2).
ALX-BILL-RATE Signed 13.4 BR03.1 BR03.2
Element: Billing Rate The hourly rate at which to bill this BR03.3
value for the attribute.
ALX-SUM-ACCT-CAT Alpha 5 BR03.1 BR03.2
Element: Sum Acct Cat The summary account category associated BR03.3
with the activity and maintained in
Billing Category Rates (BR03.1) or Units
of Production (BR03.2). A blank value
in the summary account category or the
account category indicates that the
rates are valid for all account
categories associated with the activity.
ALX-CTR-CAT-GRP Alpha 5 BR03.1 BR03.2
Element: Ctr Cat Grp BR03.3
ACBLRATEX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALXSET1 ACTIVITY AC190 AC300
SUM-ACCT-CAT AC310 AC40.1
CTR-CAT-GRP AC40.4 AC41.1
ACCT-CATEGORY AC41.4 AC42.1
SOURCE-CODE AC54.1 AC540
MATRIX-CAT ACAC.1 BR00.1
EFFECTIVE-DT* BR00.2 BR00.3
MX-VALUE BR03.1 BR03.2
BR03.3 BR190
BR20.6 BR203
BR40.3 BR46.1
BR46.2 BR46.4
ET540
ALXSET2 ACTIVITY AC190 AC40.1
SUM-ACCT-CAT AC40.4 AC41.1
CTR-CAT-GRP AC41.4 AC42.1
ACCT-CATEGORY AC54.1 AC540
SOURCE-CODE ACAC.1 BR190
MATRIX-CAT BR20.6 BR40.3
MX-VALUE BR46.1 BR46.2
EFFECTIVE-DT* BR46.4 ET540
ALXSET3 MATRIX-CAT
ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
SOURCE-CODE
EFFECTIVE-DT*
MX-VALUE
ACBLRATEX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
ACV-ACTIVITY-GRP -> AGP-ACTIVITY-GRP (AGPSET1)
Acactivity ACACTIVITY Required
ALX-ACTIVITY -> ACV-ACTIVITY
Acbill ACBILL Required
ALX-ACTIVITY -> ACI-ACTIVITY
Acblrate ACBLRATE Required
ALX-ACTIVITY -> ALR-ACTIVITY
ALX-SUM-ACCT-CAT -> ALR-SUM-ACCT-CAT
ALX-CTR-CAT-GRP -> ALR-CTR-CAT-GRP
ALX-ACCT-CATEGORY -> ALR-ACCT-CATEGORY
ALX-SOURCE-CODE -> ALR-SOURCE-CODE
ALX-MATRIX-CAT -> ALR-MATRIX-CAT
ALX-EFFECTIVE-DT -> ALR-EFFECTIVE-DT
Mxcatdef MXCATDEF Required
ALX-MATRIX-CAT -> MXC-MATRIX-CAT
ACBLRATEX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsccat Ad GLSCCAT
ALX-MATRIX-CAT -> GSC-MATRIX-CAT
"AD" -> GSC-SOURCE-CODE
GSC-SEQ-NBR
|
