Lawson Insight Technical Documentation |
|
ACBILLX
ACBILLX FILE
Activity Billing Detail
This file contains billing detail from AC15.4 (Activity Billing Detail. It
includes activity, account category, billing method, rate schedule, markup
percentage, and billable percentage.
REFERENCED BY
AC10.1 AC10.5 AC110 AC113 AC120 AC121
AC135 AC165 AC190 AC191 AC192 AC196
AC198 AC210 AC213 AC218 AC220 AC240
AC258 AC261 AC265 AC290 AC295 AC297
AC298 AC40.1 AC40.4 AC400 AC401 AC41.1
AC41.4 AC410 AC42.1 AC420 AC440 AC45.1
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC50.1 AC500 AC530 AC54.1
AC540 AC541 AC551 AC90.1 AC90.2 AC90.4
AC90.6 AC90.8 AC92.1 AC92.2 AC92.4 AC92.6
AC93.1 AC93.4 AC93.5 AC94.1 AC94.2 AC94.4
AC94.6 AC95.1 AC95.2 AC95.4 AC95.6 AC97.1
ACBA.1 SE90.1 BR02.1 BR02.3 BR03.1 BR03.2
BR03.3 BR05.2 BR05.3 BR05.4 BR05.5 BR10.1
BR121 BR131 BR142 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR200
BR202 BR204 BR205 BR210 BR215 BR220
BR251 BR252 BR253 BR254 BR265 BR40.3
BR40.4 BR400 BR405 BR41.1 BR41.4 BR420
BR430 BR44.1 BR44.2 BR44.3 BR450 BR52.2
BR52.4 BR52.5 BR521 BR54.2 BR54.3 BR54.4
BR900 BRCC.1
UPDATED BY
AC300 AC310 BR00.2 BR120 BR122 BR130
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR530
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.
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
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. The value
for this field includes all customers
assigned to the activity or contract.
AIX-TAX-CODE Alpha 10 BR00.2
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
AIX-TAX-EXEMPT-CD Alpha 1 BR00.2
Element: Tax Exempt Code
AIX-TAX-PRINT Alpha 1
Element: Tax Print
AIX-ACCT-CAT-CLASS Alpha 5 BR00.2
Element: Acct Cat Class
AIX-CEILING-AMT Signed 15.2 BR00.2
Element: Ceiling Amt
AIX-TOTAL-BILLED Signed 15.2 AC300 BR122
Element: Total Billed BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
AIX-TOT-UNT-BILLED Signed 15.2 AC300 BR122
Element: Tot Unt Billed BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
AIX-TOT-REV-AMT Signed 15.2 AC300
Element: Tot Rev Amt
AIX-TOT-REV-UNIT Signed 15.2 AC300
Element: Tot Rev Unit
AIX-TOLERANCE-AMT Signed 15.2 BR00.2
Element: Tolerance Amt
AIX-APPLY-TOL-AMT Signed 15.2 AC300 BR130
Element: Apply Tol Amt BR530
AIX-APPLY-TOL-UNIT Signed 15.2 AC300
Element: Apply Tol Unit
AIX-RATE-FLAG Alpha 1 BR00.2
Element: Rate Flag
ACBILLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIXSET1 ACTIVITY AC10.1 AC10.5
ACCT-CATEGORY AC110 AC113
ACCT-CAT-CLASS AC120 AC121
AC135 AC165
AC190 AC191
AC192 AC196
AC198 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC300
AC310 AC40.1
AC40.4 AC400
...
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-ACCT-CAT-CLASS -> ALR-ACCT-CAT-CLASS
AIX-ACCT-CATEGORY -> ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acblratex ACBLRATE
AIX-ACTIVITY -> ALR-ACTIVITY
AIX-ACCT-CAT-CLASS -> ALR-ACCT-CAT-CLASS
AIX-ACCT-CATEGORY -> ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acceilingx ACCEILINGX
AIX-ACTIVITY -> CEX-ACTIVITY
AIX-ACCT-CATEGORY -> CEX-ACCT-CATEGORY
AIX-ACCT-CAT-CLASS -> CEX-ACCT-CAT-CLASS
CEX-MATRIX-CAT
CEX-MX-VALUE
Acmilestnx ACMILESTNX
AIX-ACTIVITY -> MLX-ACTIVITY
"B" -> MLX-MILESTONE-CAT
MLX-MILESTONE
|