ACBLRATEX

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).
UPDATED BY
ACAC.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALX-ACTIVITY
Element: Activity
Alpha 15
The activity established in the Billing Category Rates (BR03.1) or Units of Production Rates (BR03.2).
ALX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category associated with the 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
Element: Source Code
Alpha 2
The Source Code is established in 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.
ALX-MATRIX-CAT
Element: Attribute
Alpha 12
A billing rate attribute can 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.
ALX-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The billing category description which is associated with the category selected.
ALX-MX-VALUE
Element: Attribute Value
Alpha 32
Key field. This field is required if an 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
Element: Effective Date
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 (B03.2).
ALX-BILL-RATE
Element: Billing Rate
Signed 13.4
The hourly rate at which to bill this value for the attribute.
ALX-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.
ALX-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5


ACBLRATEX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALXSET1 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
SOURCE-CODE
MATRIX-CAT
EFFECTIVE-DT*
MX-VALUE
ACAC.1
ALXSET2 ACTIVITY
SUM-ACCT-CAT
CTR-CAT-GRP
ACCT-CATEGORY
SOURCE-CODE
MATRIX-CAT
MX-VALUE
EFFECTIVE-DT*
ACAC.1
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
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsccat Ad GLSCCAT
ALX-MATRIX-CAT->GSC-MATRIX-CAT
"AD"->GSC-SOURCE-CODE
  GSC-SEQ-NBR


File created: Wed Jun 08 20:48:19 2016

Home
Contact Us



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