 |
Lawson Insight Technical Documentation |
|
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 AC121 AC123 AC130 AC170 AC190
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC30.2 AC30.3 AC32.1 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC490 AC50.1 AC500 AC530
AC54.1 AC540 AC541 AC550 AC551 AC70.1
AC70.4 AC741 AC750 ACAC.1 ACBA.1 GR741
BR02.1 BR02.2 BR02.3 BR03.1 BR03.2 BR03.3
BR04.1 BR05.1 BR05.2 BR05.3 BR05.4 BR05.5
BR10.1 BR121 BR200 BR202 BR205 BR220
BR40.3 BR405 BR41.1 BR420 BR44.1 BR44.2
BR44.3 BR450 BRIP.1
UPDATED BY
AC300 AC310 BR00.1 BR120 BR21.1 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY Alpha 15 BR00.1
Activity Required key. This is the activity for
the billing information.
ACI-MAX-BILLING Signed 15.2 BR00.1
Maximum Billing This is the maximum billing for the
contract. Total billings should not
exceed the maximum billing entered.
ACI-PERC-BILLABLE Signed 7.4 BR00.1
Billable Percentage 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.
ACI-BILLING-METHOD Numeric 1 BR00.1
Billing Method This 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
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
Cm Invc 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
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 BR21.1
Total Billed This field accumulates the total amount
billed for the activity. This amount is
used to determine advance billing and
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 BR21.1
Tot Unt Billed
ACI-DISC-GL-CODE Alpha 4
Disc Gl Code
ACI-DISC-ACCT-CAT Alpha 5
Disc Acct Cat
ACI-TOT-REV-AMT Signed 15.2 AC300
Tot Rev Amt
ACI-TOT-REV-UNIT Signed 15.2 AC300
Tot Rev Unit
ACI-TOLERANCE-AMT Signed 15.2 BR00.1
Tolerance Amt
ACI-APPLY-TOL-AMT Signed 15.2
Apply Tol Amt
ACI-APPLY-TOL-UNIT Signed 15.2
Apply Tol Unit
ACI-RATE-FLAG Alpha 1 BR00.1
Rate Flag R = Rate
T = Table
ACBILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACISET1 ACTIVITY AC10.1 AC110
AC121 AC123
AC130 AC170
AC190 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC30.2
AC30.3 AC300
AC310 AC32.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC490
AC50.1 AC500
AC530 AC54.1
AC540 AC541
...
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
|