Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBILLX


                              ACBILLX FILE

                        Activity Billing Detail

This file contains billing detail from BR00.2 (Activity Billing Detail). It
includes activity, account category, billing method, rate schedule, markup
percentage, ceiling amount, tolerance amount, billable percentage and tax
information. BILLX parameters are stored at any activity/account category or
activity/summary account category level.

REFERENCED BY

AC110     AC112     AC113     AC12.1    AC121     AC123
AC128     AC135     AC145     AC160     AC165     AC169
AC190     AC191     AC197     AC198     AC200     AC203
AC206     AC207     AC210     AC213     AC218     AC220
AC225     AC240     AC246     AC261     AC265     AC290
AC295     AC298     AC346     AC40.1    AC40.4    AC400
AC401     AC41.1    AC41.4    AC410     AC412     AC42.1
AC420     AC421     AC440     AC45.1    AC460     AC471
AC472     AC473     AC480     AC490     AC493     AC494
AC50.1    AC500     AC527     AC54.1    AC540     AC56.1
AC560     AC90.1    AC90.2    AC90.4    AC90.6    AC90.8
AC92.1    AC92.2    AC92.4    AC92.6    AC93.4    AC93.5
AC94.1    AC94.2    AC94.4    AC94.6    AC95.1    AC95.2
AC95.4    AC95.6    ACAC.1    ACBA.1    AP211     AR237
AR239     AR257     AR296     AR32.1    BR01.1    BR01.2
BR02.1    BR02.3    BR03.1    BR03.2    BR03.3    BR05.2
BR05.3    BR05.4    BR05.5    BR10.1    BR121     BR123
BR142     BR145     BR151     BR152     BR153     BR154
BR155     BR156     BR157     BR165     BR18.1    BR19.1
BR190     BR200     BR202     BR204     BR205     BR206
BR210     BR212     BR215     BR220     BR245     BR251
BR252     BR253     BR265     BR300     BR40.3    BR40.4
BR400     BR405     BR41.1    BR41.4    BR42.1    BR420
BR422     BR430     BR450     BR52.2    BR52.4    BR52.5
BR54.2    BR54.3    BR54.4    BR96.1    ET175     ET540
ET542     PW110     PW510

UPDATED BY

AC10.1    AC120     AC300     AC310     BR00.2    BR00.1
BR120     BR122     BR130     BR131     BR140     BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR46.1    BR46.2
BR46.4    BR521     BR530     BR580

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AIX-ACTIVITY           Alpha 15                                  BR00.2
Element: Activity      Required key. This is the activity for
                       the detailed billing information.

AIX-ACCT-CATEGORY      Alpha 5                                   BR00.2
Element: Account CategoRequired key. This is the account
                       category for the detailed billing
                       information.

AIX-BILLING-METHOD     Numeric 1                                 BR00.2
Element: Billing MethodThis is the billing method for the
                       activity.
                       The values are:
                       1 = Time and Materials
                       2 = Cost Plus
                       3 = Units of Produciton
                       4 = Milestone
                       5 = Pass Thru

AIX-MARK-UP-PCT        Signed 5.2                                BR00.2
Element: Markup PercentThis is the markup percentage to use in
                       billing for the activity.

AIX-PERC-BILLABLE      Signed 7.4                                BR00.2
Element: Percent BillabPercent billable is the percentage of
                       total costs that are billable.

AIX-TAX-CODE           Alpha 10                                  BR00.2
Element: Tax Code      The code representing specific tax
                       information. This must be a valid Tax
                       Code.

AIX-TAX-EXEMPT-CD      Alpha 1                                   BR00.2
Element: Tax Exempt Cd Code indicating the taxing status.  The
                       values are:
                       E = Exempt
                       T = Taxable.

AIX-CEILING-AMT        Signed 18.2                               BR00.2
Element: Intl Amt      The total amount that can be billed for
                       the activity and account category.

AIX-TOTAL-BILLED       Signed 18.2                               AC300   BR122
Element: Intl Amt      the total cumulative amount billed for    BR140   BR20.1
                       the bill activity and account category.   BR20.2  BR20.3
                       This amount is used to determine advance  BR20.4  BR20.5
                       billing and unbilled accounts receivable  BR46.1  BR46.2
                       entries for revenue recognition and       BR46.4  BR580
                       billing.

AIX-TOT-UNT-BILLED     Signed 18.2                               AC300   BR122
Element: Intl Amt      The total cumulative billed for the       BR140   BR20.1
                       activity and account category.  This      BR20.2  BR20.3
                       unit amount is used to  determine         BR20.4  BR20.5
                       advance billing and unbilled  account     BR46.1  BR46.2
                       receivable entries for revenue            BR46.4  BR580
                       recognition and billing.

AIX-TOT-REV-AMT        Signed 18.2                               AC300   BR580
Element: Intl Amt      The cumulative revenue amount recognized
                       for the activity and account category.

AIX-TOT-REV-UNIT       Signed 15.2                               AC300   BR580
Element: Tot Rev Unit  the cumulative revenue units recognized
                       for the activity and account category.

AIX-TOLERANCE-AMT      Signed 18.2                               BR00.2
Element: Intl Amt      The billing activity and account
                       category tolerance amount.

AIX-APPLY-TOL-AMT      Signed 18.2                               AC300   BR130
Element: Intl Amt      The amount of tolerance applied for       BR131   BR530
                       revenue for the billing activity and      BR580
                       account category.

AIX-APPLY-TOL-UNIT     Signed 15.2                               AC300   BR580
Element: Apply Tol UnitNot used.

AIX-RATE-FLAG          Alpha 1                                   BR00.2
Element: Rate Flag     the billing rate determines if the rates
                       are from a resource or a table.
                       R = Resource
                       T = Table

AIX-SERVICE-LOC        Numeric 4                                 BR00.2
Element: Service Loc   A user defined code identifying a
                       customer's service location.

AIX-SUM-ACCT-CAT       Alpha 5                                   BR00.2
Element: Sum Acct Cat  The name of the summary account
                       category.

AIX-CTR-CAT-GRP        Alpha 5                                   BR00.2
Element: Ctr Cat Grp

                         ACBILLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIXSET1   ACTIVITY                                               AC10.1  AC10.5
          SUM-ACCT-CAT                                           AC110   AC112
          CTR-CAT-GRP                                            AC113   AC12.1
          ACCT-CATEGORY                                          AC120   AC121
                                                                 AC123   AC128
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC225
                                                                 AC240   AC246
                                                                 ...

                         ACBILLX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            AIX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

                         ACBILLX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblrate       ACBLRATE

                            AIX-ACTIVITY         -> ALR-ACTIVITY
                            AIX-SUM-ACCT-CAT     -> ALR-SUM-ACCT-CAT
                            AIX-CTR-CAT-GRP      -> ALR-CTR-CAT-GRP
                            AIX-ACCT-CATEGORY    -> ALR-ACCT-CATEGORY
                                                    ALR-SOURCE-CODE
                                                    ALR-MATRIX-CAT
                                                    ALR-EFFECTIVE-DT

Acmilestnx     ACMILESTNX

                            AIX-ACTIVITY         -> MLX-ACTIVITY
                            "B"                  -> MLX-MILESTONE-CAT
                                                    MLX-MILESTONE