|
|
ACBILL FILE
Activity Billing
This file contains billing information from AC15.1 (Billing). It includes tax
information, invoice type, process level, additional billing information, such
as maximum billing, billable percentage, billing method, and billing discount
percent; as well as total billed amounts. In addition, the file contains an
aging code and GL codes and account categories for retainer, advance billing,
and unbilled accounts receivable.
REFERENCED BY
AC110 AC113 AC120 AC121 AC123 AC130
AC131 AC135 AC165 AC190 AC191 AC192
AC196 AC198 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC210 AC213 AC218 AC220 AC240
AC258 AC261 AC265 AC290 AC295 AC297
AC298 AC32.1 AC37.1 AC40.1 AC40.4 AC400
AC401 AC41.1 AC41.4 AC410 AC42.1 AC420
AC440 AC45.1 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC50.1 AC500
AC530 AC54.1 AC540 AC541 AC550 AC551
AC90.1 AC90.2 AC90.4 AC90.6 AC90.8 AC92.1
AC92.2 AC92.4 AC92.6 AC93.1 AC93.4 AC93.5
AC94.1 AC94.2 AC94.4 AC94.6 AC95.1 AC95.2
AC95.4 AC95.6 AC97.1 ACAC.1 ACBA.1 SE90.1
BR02.1 BR02.3 BR03.1 BR03.2 BR03.3 BR04.1
BR05.1 BR05.2 BR05.3 BR05.4 BR05.5 BR10.1
BR121 BR131 BR142 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR200
BR202 BR204 BR205 BR210 BR215 BR220
BR251 BR252 BR253 BR254 BR265 BR40.3
BR40.4 BR400 BR405 BR41.1 BR41.4 BR420
BR430 BR44.1 BR44.2 BR44.3 BR450 BR52.2
BR52.4 BR52.5 BR521 BR54.2 BR54.3 BR54.4
BR900 BRCC.1 BRIP.1
UPDATED BY
AC300 AC310 BR00.1 BR120 BR122 BR130
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR530
AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY Alpha 15 BR00.1
Element: Activity Required key. This is the activity for
the billing information.
ACI-MAX-BILLING Signed 15.2 BR00.1
Element: Maximum BillinThis is the maximum billing for the
contract. Total billings should not
exceed the maximum billing entered.
ACI-PERC-BILLABLE Signed 7.4 BR00.1
Element: Billable PercePercent billable is the percentage of
total costs that are billable. The value
for this field includes all customers
assigned to the activity or contract.
ACI-BILLING-METHOD Numeric 1 AC198 BR00.1
Element: Billing MethodThis field defines the method used to
calculate billings.
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
9 = User Defined
ACI-INVC-TYPE Alpha 4
Element: Invoice Type This field is required for the
interface to the Billing system. It
defines whether an invoice is a debit or
credit invoice. The invoice type must
have been defined already in BL06.1
(Invoice Type). For use in this form,
invoice type must be Debit. Activity
invoice types should be flagged as
Service on BL06.1.
ACI-CM-INVC-TYPE Alpha 4
Element: Invoice Type This field is required for the
interface to the Billing system. It
defines
whether an invoice is a debit or credit
invoice type. The invoice type must
have
been defined already in BL06.1 (Invoice
Type). Activity invoice types should be
flagged as Service on BL06.1.
ACI-PROCESS-LEVEL Alpha 5
Element: Process Level Required. This field is required for
billing. The field must exist in the
Accounts Receivable and Billing Process
Level files. It can be overridden using
the AC115 (Billing Calculation) batch
parameter form.
ACI-TOTAL-BILLED Signed 15.2 AC300 BR122
Element: Total Billed This field accumulates the total amount BR20.1 BR20.2
billed for the activity. This amount is BR20.3 BR20.4
used to determine advance billing and BR20.5
unbilled accounts receivable entries for
revenue recognition and billing. It is
updated by AC115 (Billing Calculation)
and any Billing programs that create
billing invoices with an activity
assigned. The total in this field
includes transactions billed through
BL20.1 (Invoice Entry).
ACI-TOT-UNT-BILLED Signed 15.2 AC300 BR122
Element: Tot Unt Billed BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
ACI-DISC-GL-CODE Alpha 4
Element: Disc Gl Code
ACI-DISC-ACCT-CAT Alpha 5
Element: Disc Acct Cat
ACI-TOT-REV-AMT Signed 15.2 AC300
Element: Tot Rev Amt
ACI-TOT-REV-UNIT Signed 15.2 AC300
Element: Tot Rev Unit
ACI-TOLERANCE-AMT Signed 15.2 BR00.1
Element: Tolerance Amt
ACI-APPLY-TOL-AMT Signed 15.2 AC300 BR130
Element: Apply Tol Amt BR530
ACI-APPLY-TOL-UNIT Signed 15.2 AC300
Element: Apply Tol Unit
ACI-RATE-FLAG Alpha 1 BR00.1
Element: Rate Flag R = Rate
T = Table
ACI-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information for the
activity. This must be a valid tax code
in the LAWSON INSIGHT Tax system.
ACI-TAX-EXEMPT-CD Alpha 1
Element: Tax Exempt CodThis is the tax exempt code, indicating
whether the activity is taxable or tax
exempt.
ACBILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACISET1 ACTIVITY AC10.1 AC10.5
AC110 AC113
AC120 AC121
AC123 AC130
AC131 AC135
AC165 AC190
AC191 AC192
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
...
ACBILL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
ACI-ACTIVITY -> ACV-ACTIVITY
Oeinvctype OEINVCTYPE Required
ACV-COMPANY -> OIN-COMPANY
ACI-INVC-TYPE -> OIN-INVC-TYPE
Oeproclev OEPROCLEV Required
ACV-COMPANY -> OEP-COMPANY
ACI-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
ACBILL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbillx ACBILLX
ACI-ACTIVITY -> AIX-ACTIVITY
AIX-ACCT-CATEGORY
AIX-ACCT-CAT-CLASS
Acblactv ACBLACTV
ACI-ACTIVITY -> BLA-BILL-ACTIVITY
BLA-ACTIVITY
BLA-ACCT-CATEGORY
BLA-ACCT-CAT-CLASS
Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-ACCT-CAT-CLASS
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acblratex ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-ACCT-CAT-CLASS
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
Acceiling ACCEILING
ACI-ACTIVITY -> CEH-ACTIVITY
Spaces -> CEH-ACCT-CATEGORY
Spaces -> CEH-ACCT-CAT-CLASS
CEH-MATRIX-CAT
Acceilingx ACCEILINGX
ACI-ACTIVITY -> CEX-ACTIVITY
CEX-ACCT-CATEGORY
CEX-ACCT-CAT-CLASS
CEX-MATRIX-CAT
CEX-MX-VALUE
Acmilestn ACMILESTN
ACI-ACTIVITY -> MLS-ACTIVITY
MLS-MILESTONE-CAT
Acmilestnx ACMILESTNX
ACI-ACTIVITY -> MLX-ACTIVITY
"B" -> MLX-MILESTONE-CAT
MLX-MILESTONE
H Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-ACCT-CAT-CLASS
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
U Acblrate ACBLRATE
ACI-ACTIVITY -> ALR-ACTIVITY
ALR-ACCT-CAT-CLASS
ALR-ACCT-CATEGORY
ALR-SOURCE-CODE
ALR-MATRIX-CAT
ALR-EFFECTIVE-DT
|
