 |
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 AC170 AC190 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC530 AC54.1 AC540 AC70.1
AC70.4 BR03.1 BR03.2 BR03.3 BR200 BR40.3
BR44.1 BR44.2 BR44.3
UPDATED BY
AC300 AC310 BR00.2 BR00.1 BR120 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 BR21.1
Total Billed
AIX-TOT-UNT-BILLED Signed 15.2 AC300 BR21.1
Tot Unt Billed
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
Apply Tol Amt
AIX-APPLY-TOL-UNIT Signed 15.2
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 AC170
ACCT-CATEGORY AC190 AC300
ACCT-CAT-CLASS AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC54.1
AC540 AC70.1
AC70.4 BR00.1
BR00.2 BR00.3
BR03.1 BR03.2
BR03.3 BR120
BR200 BR21.1
BR40.3 BR44.1
BR44.2 BR44.3
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
|