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.
UPDATED BY

AC10.1	AC10.5	AC200	AC210	ACAC.1	AP125
AP126	AP131	AP170	AP193	AP20.1	AP20.2
AP20.3	AP20.4	AP20.5	AP20.7	AP21.1	AP211
AP23.1	AP25.1	AP25.2	AP26.1	AP27.1	AP30.2
AP30.4	AP520	API1.1	API2.1	CB10.1	CB15.1
CB15.2	CB150	CB191	CB20.1	CB30.1	CB45.1
CB46.1	CB500	CB543	CB544	CB55.1	CB554
EE11.1	EE135	EE20.3	EE35.1	EE35.2	EE520
GL146	GL165	GL170	GL197	GL299	GL40.1
GL40.2	GL40.3	GL40.7	GL40.8	GL44.1	GL45.1
GL70.1	GL70.2	GL70.3	GL70.5	GL70.6	GL75.1
EX545	IFEB.1	MA41.1	MA41.2	MA41.4	MA41.7
MA43.1	MA43.2	MA43.3	MA43.4	MA43.6	MA43.7
MAI1.1	PO136	PO190	PO300	PO520	POCP.1
POI3.1	POIG.1	POII.1	POIJ.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AIX-ACTIVITY Element: Activity	Alpha 15 Required key. This is the activity for the detailed billing information.
AIX-ACCT-CATEGORY Element: Account Category	Alpha 5 Required key. This is the account category for the detailed billing information.
AIX-BILLING-METHOD Element: Billing Method	Numeric 1 This 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 Element: Markup Percent	Signed 5.2 This is the markup percentage to use in billing for the activity.
AIX-PERC-BILLABLE Element: Percent Billable	Signed 7.4 Percent billable is the percentage of total costs that are billable.
AIX-TAX-CODE Element: Tax Code	Alpha 10 The code representing specific tax information. This must be a valid Tax Code.
AIX-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 Code indicating the taxing status. The values are: E = Exempt T = Taxable.
AIX-CEILING-AMT Element: Intl Amt	Signed 18.2 The total amount that can be billed for the activity and account category.
AIX-TOTAL-BILLED Element: Intl Amt	Signed 18.2 the total cumulative amount billed for the bill activity and account category. This amount is used to determine advance billing and unbilled accounts receivable entries for revenue recognition and billing.
AIX-TOT-UNT-BILLED Element: Intl Amt	Signed 18.2 The total cumulative billed for the activity and account category. This unit amount is used to determine advance billing and unbilled account receivable entries for revenue recognition and billing.
AIX-TOT-REV-AMT Element: Intl Amt	Signed 18.2 The cumulative revenue amount recognized for the activity and account category.
AIX-TOT-REV-UNIT Element: Tot Rev Unit	Signed 15.2 the cumulative revenue units recognized for the activity and account category.
AIX-TOLERANCE-AMT Element: Intl Amt	Signed 18.2 The billing activity and account category tolerance amount.
AIX-APPLY-TOL-AMT Element: Intl Amt	Signed 18.2 The amount of tolerance applied for revenue for the billing activity and account category.
AIX-APPLY-TOL-UNIT Element: Apply Tol Unit	Signed 15.2 Not used.
AIX-RATE-FLAG Element: Rate Flag	Alpha 1 the billing rate determines if the rates are from a resource or a table. R = Resource T = Table
AIX-SERVICE-LOC Element: Service Loc	Numeric 4 A user defined code identifying a customer's service location.
AIX-SUM-ACCT-CAT Element: Sum Acct Cat	Alpha 5 The name of the summary account category.
AIX-CTR-CAT-GRP Element: Ctr Cat Grp	Alpha 5

ACBILLX FILE INDEX

ACBILLX FILE RELATIONS

ONE TO ONE RELATIONS

ACBILLX FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.