ACBLRATEX FILE
Activity Billing Rates Detail
This file contains detailed billing rate information from the AC17 forms. It
includes rate schedule, attribute and attribute value, effective date, and
billing rate.
REFERENCED BY
AC170 AC190 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC530 AC54.1 AC540 AC550 AC551
AC70.1 AC70.4 AC750 BR203 BR40.3 BR44.1
BR44.2 BR44.3
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
Activity Activities are the processes or BR03.3
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
ALX-ACCT-CAT-CLASS Alpha 5 BR03.1 BR03.2
Acct Cat Class BR03.3
ALX-ACCT-CATEGORY Alpha 5 BR03.1 BR03.2
Account Category Account categories are groupings of BR03.3
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.
ALX-SOURCE-CODE Alpha 2 BR03.1 BR03.2
Source Code A two character code assigned to a BR03.3
transaction to identify where the
transaction was created.
ALX-MATRIX-CAT Alpha 12 BR03.1 BR03.2
Attribute Required key. A billing rate attribute BR03.3
can be defined as part of the key for
Activity Management billing
transactions.
ALX-DESCRIPTION Alpha 30 (Lower Case) BR03.1 BR03.3
Description This field displays the description.
ALX-MX-VALUE Alpha 32 BR03.1 BR03.2
Attribute Value Key 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
Effective Date Required key. This is the effective BR03.3
date of the rates defined in this rate
table.
ALX-BILL-RATE Signed 13.4 BR03.1 BR03.2
Billing Rate Optional. This is the hourly rate at BR03.3
which to bill this value for the
attribute.
ACBLRATEX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALXSET1 ACTIVITY AC170 AC190
ACCT-CAT-CLASS AC300 AC310
ACCT-CATEGORY AC40.1 AC40.4
SOURCE-CODE AC41.1 AC41.4
MATRIX-CAT AC42.1 AC530
EFFECTIVE-DT* AC54.1 AC540
MX-VALUE AC550 AC551
AC70.1 AC70.4
AC750 BR00.1
BR00.2 BR00.3
BR03.1 BR03.2
BR03.3 BR203
BR40.3 BR44.1
BR44.2 BR44.3
ALXSET2 ACTIVITY AC170 AC190
ACCT-CAT-CLASS AC40.1 AC40.4
ACCT-CATEGORY AC41.1 AC41.4
SOURCE-CODE AC42.1 AC530
MATRIX-CAT AC54.1 AC540
MX-VALUE AC70.1 AC70.4
EFFECTIVE-DT* BR40.3
ACBLRATEX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbill ACBILL Required
ALX-ACTIVITY -> ACI-ACTIVITY
Acbillx ACBILLX Required
ALX-ACTIVITY -> AIX-ACTIVITY
ALX-ACCT-CATEGORY -> AIX-ACCT-CATEGORY
ALX-ACCT-CAT-CLASS -> AIX-ACCT-CAT-CLASS
Acblrate ACBLRATE Required
ALX-ACTIVITY -> ALR-ACTIVITY
ALX-ACCT-CAT-CLASS -> ALR-ACCT-CAT-CLASS
ALX-ACCT-CATEGORY -> ALR-ACCT-CATEGORY
ALX-SOURCE-CODE -> ALR-SOURCE-CODE
ALX-MATRIX-CAT -> ALR-MATRIX-CAT
ALX-EFFECTIVE-DT -> ALR-EFFECTIVE-DT
Acceilingx ACCEILINGX Not Required
ALX-ACTIVITY -> CEX-ACTIVITY
ALX-ACCT-CATEGORY -> CEX-ACCT-CATEGORY
ALX-ACCT-CAT-CLASS -> CEX-ACCT-CAT-CLASS
ALX-MATRIX-CAT -> CEX-MATRIX-CAT
ALX-MX-VALUE -> CEX-MX-VALUE
Mxcatdef MXCATDEF Required
ALX-MATRIX-CAT -> MXC-MATRIX-CAT
ACBLRATEX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acblactv ACBLACTV
ALX-ACTIVITY -> BLA-BILL-ACTIVITY
ALX-ACCT-CATEGORY -> BLA-ACCT-CAT-CLASS
ALX-ACCT-CAT-CLASS -> BLA-ACCT-CATEGORY
BLA-ACTIVITY
|
