ACBLRATE FILE
Activity Billing Rates Header
This file contains billing rate information from the AC17 forms. It includes
the rate schedule and description, the billing rate attribute, unit type, and
currency code.
REFERENCED BY
AC170 AC190 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC530 AC54.1 AC540 AC70.1 AC70.4
BR203 BR40.3
UPDATED BY
AC300 AC310 BR03.1 BR03.2 BR03.3 BR00.1
BR00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALR-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.
ALR-ACCT-CAT-CLASS Alpha 5 BR03.1 BR03.2
Acct Cat Class BR03.3
ALR-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.
ALR-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.
ALR-MATRIX-CAT Alpha 12 BR03.1 BR03.2
Attribute Required. A billing rate attribute can BR03.3
be defined as part of the key for
Activity Management billing
transactions.
The attribute must be assigned to the
object type ACTRANS in GL05.1 (Source
Code).
ALR-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR03.1 BR03.2
Effective Date BR03.3
ALR-UNIT-TYPE Alpha 1 BR03.1 BR03.2
Unit Type This field indicates whether the rate BR03.3
schedule is for hours (time and
materials) or units (units of
production).
U = Units
H = Hours
ALR-CURRENCY-CODE Alpha 5 BR03.1 BR03.2
Currency Code This code represents the base currency BR03.3
defined for the company in the General
Ledger system.
ACBLRATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALRSET1 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
AC70.1 AC70.4
BR00.1 BR00.2
BR03.1 BR03.2
BR03.3 BR203
BR40.3
ACBLRATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbill ACBILL Required
ALR-ACTIVITY -> ACI-ACTIVITY
Acbillx ACBILLX Required
ALR-ACTIVITY -> AIX-ACTIVITY
ALR-ACCT-CATEGORY -> AIX-ACCT-CATEGORY
ALR-ACCT-CAT-CLASS -> AIX-ACCT-CAT-CLASS
Acceiling ACCEILING Required
ALR-ACTIVITY -> CEH-ACTIVITY
ALR-ACCT-CATEGORY -> CEH-ACCT-CATEGORY
ALR-ACCT-CAT-CLASS -> CEH-ACCT-CAT-CLASS
ALR-MATRIX-CAT -> CEH-MATRIX-CAT
Mxcatdef MXCATDEF Required
ALR-MATRIX-CAT -> MXC-MATRIX-CAT
ACBLRATE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acblratex ACBLRATEX
ALR-ACTIVITY -> ALX-ACTIVITY
ALR-ACCT-CAT-CLASS -> ALX-ACCT-CAT-CLASS
ALR-ACCT-CATEGORY -> ALX-ACCT-CATEGORY
ALR-SOURCE-CODE -> ALX-SOURCE-CODE
ALR-MATRIX-CAT -> ALX-MATRIX-CAT
ALR-EFFECTIVE-DT -> ALX-EFFECTIVE-DT
ALX-MX-VALUE
Acceilingx ACCEILINGX
ALR-ACTIVITY -> CEX-ACTIVITY
ALR-ACCT-CATEGORY -> CEX-ACCT-CATEGORY
ALR-ACCT-CAT-CLASS -> CEX-ACCT-CAT-CLASS
ALR-MATRIX-CAT -> CEX-MATRIX-CAT
CEX-MX-VALUE
|
