|
|
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
AC16.1 AC16.2 AC16.3 AC16.4 AC16.5 AC170
AC190 AC215 AC40.1 AC41.1 AC415 AC416
AC42.1 AC450 AC470 AC530 AC54.1 AC540
AC70.3 AC800 ACAC.1 AC04.1 AC17.1 AC17.2
UPDATED BY
AC10.1 AC110 AC115 AC15.1 AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACI-ACTIVITY Alpha 15 AC110 AC15.1
Activity Required key. This is the activity for
the billing information.
ACI-MAX-BILLING Signed 15.2 AC110 AC15.1
Maximum Billing This is the maximum billing for the
contract. Total billings should not
exceed the maximum billing entered.
ACI-RETAIN-GL-CD Alpha 4 AC110 AC15.1
Retainer GL Code This is the GL code for the retainer
amount.
ACI-RETAIN-ACT-CAT Alpha 5 AC110 AC15.1
Retainer Account This is the account category for the
Category retainer.
ACI-PERC-BILLABLE Signed 7.4 AC110 AC15.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-UNBL-AR-GL-CD Alpha 4 AC110 AC15.1
Unbilled AR GL Code This is the Unbilled Accounts
Receivable GL Code field. When you are
making revenue entries and revenues
exceed billings, use this code to make a
debit entry to the unbilled accounts
receivable account. (The Billing system
uses the same code to reverse out the
unbilled portion when it becomes
billed.) The GL code must have been
defined already in AC04.1 (GL Code).
ACI-UNBL-ACCT-CAT Alpha 5 AC110 AC15.1
Unbilled AR Account This is the Unbilled Accounts
Category Receivable Account Category field. This
field determines the Activity Management
account category to post unbilled
accounts receivable entries to. The
account category must have been defined
already in AC06.1 (Account Category
Assignment). The account category type
for the account category must be
Revenue.
ACI-ADV-BILL-GL-CD Alpha 4 AC110 AC15.1
Advance Billing GL This is the Advance Billing GL Code
Code field. When you are making billing
entries and billings exceed revenue, use
this code to make a credit entry to the
advance billing account. The GL code
must have been defined already in AC04.1
(GL Code).
ACI-ADV-BL-ACT-CAT Alpha 5 AC110 AC15.1
Advance Billing This is the Advance Billing Account
Acct Category Category field. This field determines
the Activity Management account category
to post advance billing entries to. The
account category must have been defined
already in AC06.1 (Account Category
Assignment). The category type for the
account category must be Revenue.
ACI-AGING-CODE Numeric 2 AC110 AC15.1
Unbilled AR Aging This is the unbilled accounts
Code receivable aging code. This code and
other aging codes are defined in AR15.8
(Aging Code). The Activity Management
system uses this code to age unbilled
accounts receivable.
ACI-BILLING-METHOD Numeric 1 AC110 AC15.1
Billing Method This field defines the method used to AC170
calculate billings.
1 = Time and Materials
2 = Cost Plus
3 = Units of Production
4 = Milestone
5 = Pass Thru
9 = User Defined
ACI-TAX-CODE Alpha 10 AC110 AC15.1
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 AC110 AC15.1
Tax Exempt Code This is the tax exempt code, indicating
whether the activity is taxable or tax
exempt.
Y = Exempt
N = Non-exempt
ACI-INVC-TYPE Alpha 4 AC110 AC15.1
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 AC110 AC15.1
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 AC110 AC15.1
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-RATE-SCHEDULE Alpha 12 AC110 AC15.1
Rate Schedule This is the rate schedule to use in
billing for the activity.
ACI-RETAINER-CODE Alpha 16 AC110 AC15.1
Retainer Code This is the code for the retainer
account. It must be defined in the
Billing system.
ACI-TOTAL-BILLED Signed 15.2 AC115 AC300
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).
ACBILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACISET1 ACTIVITY AC10.1 AC110
AC115 AC15.1
AC15.2 AC15.4
AC16.1 AC16.2
AC16.3 AC16.4
AC16.5 AC170
AC190 AC215
AC300 AC310
AC40.1 AC41.1
AC415 AC416
AC42.1 AC450
AC470 AC530
AC54.1 AC540
AC70.3 AC800
ACAC.1
ACISET2 UNBL-AR-GL-CD KeyChange AC04.1
ACTIVITY
ACISET4 ADV-BILL-GL-CDKeyChange AC04.1
ACTIVITY
ACISET6 RATE-SCHEDULE KeyChange AC17.1 AC17.2
ACTIVITY
ACISET8 RETAIN-GL-CD KeyChange AC04.1
ACTIVITY
ACBILL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
ACI-ACTIVITY -> ACV-ACTIVITY
Acblrate ACBLRATE Not Required
ACI-RATE-SCHEDULE -> ALR-RATE-SCHEDULE
Acmilestn ACMILESTN Not Required
ACI-ACTIVITY -> MLS-ACTIVITY
Spaces -> MLS-ACCT-CATEGORY
Agingcode AGINGCODE Not Required
ACV-COMPANY -> AGE-COMPANY
ACI-AGING-CODE -> AGE-AGING-CODE
H Acblrate ACBLRATE Required
When ACI-BILLING-METHOD = 1
ACI-RATE-SCHEDULE -> ALR-RATE-SCHEDULE
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
U Acblrate ACBLRATE Required
When ACI-BILLING-METHOD = 3
ACI-RATE-SCHEDULE -> ALR-RATE-SCHEDULE
ACBILL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbillx ACBILLX
ACI-ACTIVITY -> AIX-ACTIVITY
AIX-ACCT-CATEGORY
Accustomer ACCUSTOMER
ACI-ACTIVITY -> CMR-ACTIVITY
CMR-CUSTOMER
Acmilestnx ACMILESTNX
ACI-ACTIVITY -> MLX-ACTIVITY
MLX-ACCT-CATEGORY
MLX-MILESTONE
|