 |
Lawson Insight Technical Documentation |
|
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 AC120 AC170 AC190
AC191 AC192 AC198 AC290 AC40.1 AC40.4
AC41.1 AC41.4 AC42.1 AC45.1 AC471 AC490
AC50.1 AC500 AC530 AC54.1 AC540 AC541
AC551 AC70.1 AC70.4 ACBA.1 DA233 DA240
GR240 DA90.1 BR02.1 BR02.3 BR03.1 BR03.2
BR03.3 BR04.1 BR05.2 BR05.3 BR05.4 BR05.5
BR121 BR131 BR165 BR200 BR202 BR220
BR40.3 BR40.4 BR41.1 BR420 BR44.1 BR44.2
BR44.3 BR450
UPDATED BY
AC300 AC310 BR00.2 BR00.1 BR120 BR130
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIX-ACTIVITY Alpha 15 BR00.2
Activity Required key. This is the activity for
the detailed billing information.
AIX-ACCT-CATEGORY Alpha 5 BR00.2
Account Category Required key. This is the account
category for the detailed billing
information.
AIX-BILLING-METHOD Numeric 1 BR00.2
Billing Method This 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
Markup Percent This is the markup percentage to use in
billing for the activity.
AIX-PERC-BILLABLE Signed 7.4 BR00.2
Percent Billable Percent 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
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
Tax Exempt Code
AIX-TAX-PRINT Alpha 1
Tax Print
AIX-ACCT-CAT-CLASS Alpha 5 BR00.2
Acct Cat Class
AIX-CEILING-AMT Signed 15.2 BR00.2
Ceiling Amt
AIX-TOTAL-BILLED Signed 15.2 AC300 BR20.1
Total Billed BR20.2 BR20.3
BR20.4 BR20.5
BR21.1
AIX-TOT-UNT-BILLED Signed 15.2 AC300 BR20.1
Tot Unt Billed BR20.2 BR20.3
BR20.4 BR20.5
BR21.1
AIX-TOT-REV-AMT Signed 15.2 AC300
Tot Rev Amt
AIX-TOT-REV-UNIT Signed 15.2 AC300
Tot Rev Unit
AIX-TOLERANCE-AMT Signed 15.2 BR00.2
Tolerance Amt
AIX-APPLY-TOL-AMT Signed 15.2 AC300 BR130
Apply Tol Amt
AIX-APPLY-TOL-UNIT Signed 15.2 AC300
Apply Tol Unit
AIX-RATE-FLAG Alpha 1 BR00.2
Rate Flag
ACBILLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIXSET1 ACTIVITY AC10.1 AC10.5
ACCT-CATEGORY AC110 AC120
ACCT-CAT-CLASS AC170 AC190
AC191 AC192
AC198 AC290
AC300 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC471 AC490
AC50.1 AC500
AC530 AC54.1
AC540 AC541
AC551 AC70.1
AC70.4 ACBA.1
...
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
|