ACBLRATE

Activity Billing Rates Header

This file contains billing rate information from the Billing Category Rates (BR03.1) or the Units of Production Rates (BR03.2). Rates are stored by attributes or units of prodction. The file maintains the rate schedule name and description, the billing rate attribute, unit type, and currency code for an activity. You can print a billing rate listing by running BR203 (Billing Rate Listing).

REFERENCED BY
BR203


UPDATED BY
AC190 AC300 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC54.1 AC540 ACAC.1 BR00.1 BR00.2
BR03.1 BR03.2 BR03.3 BR190 BR20.6 BR40.3
BR44.1 BR46.1 BR46.2 BR46.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALR-ACTIVITY
Element: Activity
Alpha 15
The activity established in Billing Category Rates (BR03.1) or Units of Production Rates (BR03.2).
BR03.1 BR03.2
BR03.3
ALR-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category associated with the activity and 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.
BR03.1 BR03.2
BR03.3
ALR-SOURCE-CODE
Element: Source Code
Alpha 2
The Source Code is established in the Source 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.
BR03.1 BR03.2
BR03.3
ALR-MATRIX-CAT
Element: Attribute
Alpha 12
A billing rate attribute must be defined 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. The attribute must be assigned to the object type ACTRANS in GL05.1 (Source Code).
BR03.1 BR03.2
BR03.3
ALR-EFFECTIVE-DT
Element: Effective Dt
Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid. The date is maintained on the Billing Category Rates (BR03.1) or Units of Production (BR03.2).
BR03.1 BR03.2
BR03.3
ALR-UNIT-TYPE
Element: Unit Type
Alpha 1
This field indicates whether the rate schedule is for hours (time and materials) or units (units of production). If the rates are set up in Billing Category Rates (BR00.1), the value = H(ours). If the rates are set up in Units of Production Rates (BR03.2) the value = U(nits).
U = Units
H = Hours
BR03.1 BR03.2
BR03.3
ALR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This code represents the currency defined for the activity which is established in Activity (AC10.1).
BR03.1 BR03.2
BR03.3
ALR-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The summary account category associated 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.
BR03.1 BR03.2
BR03.3
ALR-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5
BR03.1 BR03.2
BR03.3


ACBLRATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALRSET1 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
SOURCE-CODE
MATRIX-CAT
EFFECTIVE-DT*
AC190 AC300
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC54.1
AC540 ACAC.1
BR00.1 BR00.2
BR03.1 BR03.2
BR03.3 BR190
BR20.6 BR203
BR40.3 BR44.1
BR46.1 BR46.2
BR46.4


ACBLRATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acbill ACBILL Required
ALR-ACTIVITY->ACI-ACTIVITY
Mxcatdef MXCATDEF Required
ALR-MATRIX-CAT->MXC-MATRIX-CAT


ACBLRATE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acblratex ACBLRATEX
ALR-ACTIVITY->ALX-ACTIVITY
ALR-SUM-ACCT-CAT->ALX-SUM-ACCT-CAT
ALR-CTR-CAT-GRP->ALX-CTR-CAT-GRP
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


File created: Thu Jun 09 11:10:47 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.