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.

REFERENCED BY

AC110	AC12.1	ACBA.1	BR01.1	BR01.2	BR03.1
BR03.2	BR03.3	BR05.2	BR05.3	BR05.4	BR05.5
BR18.1	BR206	BR54.2	BR54.3	BR54.4	BR96.1

UPDATED BY

AC10.1	AC10.5	AC112	AC113	AC120	AC121
AC123	AC128	AC135	AC145	AC147	AC160
AC165	AC169	AC190	AC191	AC197	AC198
AC200	AC203	AC206	AC207	AC210	AC213
AC218	AC220	AC225	AC240	AC246	AC247
AC261	AC265	AC290	AC295	AC297	AC298
AC300	AC310	AC311	AC346	AC40.1	AC40.4
AC400	AC401	AC41.1	AC41.4	AC410	AC412
AC42.1	AC420	AC421	AC440	AC45.1	AC45.4
AC46.1	AC460	AC471	AC472	AC473	AC480
AC490	AC493	AC494	AC50.1	AC500	AC527
AC54.1	AC540	AC56.1	AC560	AC90.1	AC90.2
AC90.4	AC90.6	AC90.8	AC92.1	AC92.2	AC92.4
AC92.6	AC93.4	AC93.5	AC94.1	AC94.2	AC94.4
AC94.6	AC95.1	AC95.2	AC95.4	AC95.6	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	BR00.1
BR00.2	BR00.3	BR02.1	BR02.3	BR10.1	BR120
BR121	BR122	BR123	BR130	BR131	BR140
BR142	BR145	BR151	BR152	BR153	BR154
BR155	BR156	BR157	BR165	BR19.1	BR190
BR20.1	BR20.2	BR20.3	BR20.4	BR20.5	BR20.6
BR200	BR202	BR204	BR205	BR210	BR212
BR215	BR220	BR245	BR251	BR252	BR253
BR265	BR300	BR40.3	BR40.4	BR400	BR405
BR41.1	BR41.4	BR42.1	BR420	BR422	BR43.1
BR430	BR44.1	BR450	BR46.1	BR46.2	BR46.4
BR52.2	BR52.4	BR52.5	BR521	BR530	BR580
BRIP.1	CB10.1	CB15.1	CB15.2	CB150	CB191
CB20.1	CB30.1	CB45.1	CB46.1	CB500	CB543
CB544	CB55.1	CB554	CX100	CX20.1	CX20.2
CX20.4	CX20.5	CX220	CX30.1	CX300	CX506
CXCP.1	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	GL76.1	DR100	IC140	IC66.1	IC83.1
EX545	IFEB.1	MA180	MA41.1	MA41.2	MA41.4
MA41.7	MA42.2	MA43.2	MA43.7	MA44.1	MA44.2
MA530	MA531	MA60.2	MA60.3	MA60.5	MA61.1
MA65.1	MA66.2	MA67.2	MA67.3	MA68.2	MA68.3
MA68.5	MA70.1	MA75.1	MA80.1	MAI1.1	PD10.1
PD10.2	PD130	PD20.1	PD20.2	PD20.3	PO100
PO101	PO122	PO131	PO136	PO150	PO190
PO20.1	PO20.6	PO20.9	PO21.1	PO21.2	PO21.3
PO21.4	PO21.5	PO22.1	PO22.3	PO22.4	PO23.1
PO24.1	PO25.1	PO25.5	PO25.6	PO25.7	PO26.2
PO26.3	PO26.4	PO26.5	PO26.6	PO26.7	PO26.9
PO27.2	PO28.2	PO29.1	PO30.1	PO30.2	PO30.3
PO30.4	PO300	PO31.1	PO31.2	PO32.2	PO32.4
PO33.1	PO34.1	PO35.1	PO36.1	PO36.2	PO38.1
PO39.1	PO39.2	PO44.1	PO50.1	PO52.1	PO520
PO536	PO54.5	POCP.1	POI3.1	POID.1	POIG.1
POII.1	POIJ.1	POIK.1	RQ10.1	RQ10.2	RQ10.4
RQ12.1	RQ13.1	RQ13.2	RQ35.1	RQ500	RQIF.1
WH130	WH132	WH190	WH20.2	WH20.7	WH222
WH30.1	WH30.2	WH30.3	WH30.4	WH31.1	WH31.2
WH31.3	WH31.4	WH32.1	WH32.2	WH32.3	WH32.4
WH32.5	WH33.1	WH33.2	WH33.3	WH33.4	WH33.5
WH33.6	WH33.8	WH33.9	WH34.1	WH34.2	WH34.3
WH34.4	WH40.1	WH40.2	WH520	WH830	ZW130

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AIX-ACTIVITY Element: Activity	Alpha 15 Required key. This is the activity for the detailed billing information.	BR00.2
AIX-ACCT-CATEGORY Element: Account Category	Alpha 5 Required key. This is the account category for the detailed billing information.	BR00.2
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	BR00.2
AIX-MARK-UP-PCT Element: Markup Percent	Signed 5.2 This is the markup percentage to use in billing for the activity.	BR00.2
AIX-PERC-BILLABLE Element: Percent Billable	Signed 7.4 Percent billable is the percentage of total costs that are billable.	BR00.2
AIX-TAX-CODE Element: Tax Code	Alpha 10 The code representing specific tax information. This must be a valid Tax Code.	BR00.2
AIX-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 Code indicating the taxing status. The values are: E = Exempt T = Taxable.	BR00.2
AIX-CEILING-AMT Element: Intl Amt	Signed 18.2 The total amount that can be billed for the activity and account category.	BR00.2
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.	AC300 BR122 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR46.1 BR46.2 BR46.4 BR580 BRIP.1
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.	AC300 BR122 BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR46.1 BR46.2 BR46.4 BR580 BRIP.1
AIX-TOT-REV-AMT Element: Intl Amt	Signed 18.2 The cumulative revenue amount recognized for the activity and account category.	AC300 BR580
AIX-TOT-REV-UNIT Element: Tot Rev Unit	Signed 15.2 the cumulative revenue units recognized for the activity and account category.	AC300 BR580
AIX-TOLERANCE-AMT Element: Intl Amt	Signed 18.2 The billing activity and account category tolerance amount.	BR00.2
AIX-APPLY-TOL-AMT Element: Intl Amt	Signed 18.2 The amount of tolerance applied for revenue for the billing activity and account category.	AC300 BR130 BR131 BR530 BR580
AIX-APPLY-TOL-UNIT Element: Apply Tol Unit	Signed 15.2 Not used.	AC300 BR580
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	BR00.2
AIX-SERVICE-LOC Element: Service Loc	Numeric 4 A user defined code identifying a customer's service location.	BR00.2
AIX-SUM-ACCT-CAT Element: Sum Acct Cat	Alpha 5 The name of the summary account category.	BR00.2
AIX-CTR-CAT-GRP Element: Ctr Cat Grp	Alpha 5	BR00.2

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.