|
|
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
AC115 AC16.1 AC16.2 AC16.3 AC16.4 AC16.5
AC170 AC190 AC215 AC40.1 AC41.1 AC415
AC42.1 AC530 AC54.1 AC540 AC70.3 AC800
UPDATED BY
AC10.1 AC110 AC15.1 AC15.4 AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIX-ACTIVITY Alpha 15 AC110 AC15.4
Activity Required key. This is the activity for
the detailed billing information.
AIX-ACCT-CATEGORY Alpha 5 AC110 AC15.4
Account Category Required key. This is the account AC170
category for the detailed billing
information.
AIX-BILLING-METHOD Numeric 1 AC110 AC15.4
Billing Method This is the billing method for the AC170
activity.
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
AIX-RATE-SCHEDULE Alpha 12 AC110 AC15.4
Rate Schedule This is the rate schedule to use in
billing for the activity.
AIX-MARK-UP-PCT Signed 5.2 AC110 AC15.4
Markup Percent This is the markup percentage to use in
billing for the activity.
AIX-PERC-BILLABLE Signed 7.4 AC110 AC15.4
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.
ACBILLX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIXSET1 ACTIVITY AC10.1 AC110
ACCT-CATEGORY AC115 AC15.1
AC15.4 AC16.1
AC16.2 AC16.3
AC16.4 AC16.5
AC170 AC190
AC215 AC300
AC310 AC40.1
AC41.1 AC415
AC42.1 AC530
AC54.1 AC540
AC70.3 AC800
AIXSET2 RATE-SCHEDULE
ACTIVITY
ACCT-CATEGORY
ACBILLX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AIX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acblrate ACBLRATE Not Required
Valid When AIX-BILLING-METHOD = 1
Or AIX-BILLING-METHOD = 3
AIX-RATE-SCHEDULE -> ALR-RATE-SCHEDULE
Acmilestn ACMILESTN Not Required
AIX-ACTIVITY -> MLS-ACTIVITY
AIX-ACCT-CATEGORY -> MLS-ACCT-CATEGORY
ACBILLX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acmilestnx ACMILESTNX
AIX-ACTIVITY -> MLX-ACTIVITY
AIX-ACCT-CATEGORY -> MLX-ACCT-CATEGORY
MLX-MILESTONE
|