 |
Lawson Insight Technical Documentation |
|
ACINVDTL FILE
REFERENCED BY
AC10.1 BR121 BR420
UPDATED BY
AC300 AC310 BR02.3 BR120 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVD-COMPANY Numeric 4 BR02.3 BR120
Company The company number represents an
established company and is entered on
all function codes.
IVD-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Customer Number This field contains the number that
represents a customer.
IVD-INVOICE-ID Numeric 6 BR02.3 BR120
Invoice Id
IVD-LINE-NBR Numeric 6 BR02.3 BR120
Line Number This field contains the line number. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-PT-ACTIVITY Alpha 15 BR120 BR20.1
To Activity BR20.2 BR20.3
BR20.4 BR20.5
IVD-ACTIVITY-GRP Alpha 15 BR120
Activity Group
IVD-ACCT-CATEGORY Alpha 5 BR02.3 BR120
Account Category Account categories are groupings of BR20.1 BR20.2
costs, revenues, or a combination of BR20.3 BR20.4
both used for reporting and inquiries BR20.5
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
IVD-BILLING-METHOD Numeric 1 BR120
Billing Method
IVD-TRAN-DATE Numeric 8 (yyyymmdd) BR120
Transaction Date
IVD-DESCRIPTION Alpha 30 (Lower Case) BR02.3 BR120
Description This field displays the description. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-RESOURCE-TYPE Alpha 1 BR120 BR20.5
Resource Type
IVD-RESOURCE-CODE Alpha 10 BR120 BR20.5
Resource Code
IVD-RESOURCE-DESC Alpha 30 (Lower Case) BR120 BR20.5
Resource Desc
IVD-BILL-RATE Signed 13.4 BR120 BR20.1
Bill Rate BR20.2 BR20.3
BR20.4 BR20.5
IVD-MARK-UP-PCT Signed 5.2 BR120 BR20.1
Markup percentage BR20.2 BR20.3
BR20.4 BR20.5
IVD-UNITS-AMOUNT Signed 15.2 BR120 BR20.1
Units Amount This is the units amount included in BR20.2 BR20.3
the file. BR20.4 BR20.5
IVD-UNIT-MEASURE Alpha 12 BR120 BR20.1
Unit Measure BR20.2 BR20.3
BR20.4 BR20.5
IVD-MILESTONE Alpha 3 BR120 BR20.1
Milestone BR20.2 BR20.3
BR20.4 BR20.5
IVD-PERC-COMPLETE Signed 7.3 BR20.1 BR20.2
Percent Complete BR20.3 BR20.4
BR20.5
IVD-TAX-EXEMPT-CD Alpha 1 BR120
Tax Exempt Code
IVD-TAX-CODE Alpha 10 BR120
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
IVD-INVC-AMT Signed 15.2 BR02.3 BR120
Invc Amt BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-POST-COMPANY Numeric 4 BR02.3 BR120
Post Company The company used for posting BR20.1 BR20.2
transactions to the general ledger. BR20.3 BR20.4
BR20.5
IVD-ACCT-UNIT Alpha 15 BR02.3 BR120
Accounting Unit The accounting unit is a shorthand BR20.1 BR20.2
notation representing the variable level BR20.3 BR20.4
number. When used in the General Ledger BR20.5
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
IVD-ACCOUNT Numeric 6 BR120
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
IVD-SUB-ACCT Numeric 4 BR120
Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
IVD-ATN-OBJ-ID Numeric 12 BR02.3 BR120
Atn Object ID The system-defined object id BR20.1 BR20.2
representing the Activity Management BR20.3 BR20.4
commitment. BR20.5
IVD-MATRIX-CAT-1 Alpha 12 BR120 BR20.1
Attribute 1 BR20.2 BR20.3
BR20.4 BR20.5
IVD-MX-VALUE-1 Alpha 32 BR120 BR20.1
Attribute Value BR20.2 BR20.3
BR20.4 BR20.5
IVD-MATRIX-CAT-2 Alpha 12
Attribute 2
IVD-MX-VALUE-2 Alpha 32
Attribute Value
IVD-MATRIX-CAT-3 Alpha 12
Attribute 3
IVD-MX-VALUE-3 Alpha 32
Attribute Value
IVD-CHANGE-STATUS Alpha 1 BR120
Change Status Y = Yes
N = No
9 = Delete
IVD-ACCT-CAT-CLASS Alpha 5 BR120 BR20.1
Acct Cat Class BR20.2 BR20.3
BR20.4 BR20.5
IVD-EXCEED-AMT Signed 15.2 BR120 BR20.1
Exceed Amt BR20.2 BR20.3
BR20.4 BR20.5
IVD-CONTRACT Alpha 10 BR02.3 BR120
Contract
IVD-BILL-ACTIVITY Alpha 15 BR02.3 BR120
Bill Activity
IVD-AC-CUSTOMER-ID Alpha 5 BR02.3 BR120
Ac Customer Id
IVD-EXCEED-UNIT Signed 15.2 BR120 BR20.1
Exceed Unit BR20.2 BR20.3
BR20.4 BR20.5
IVD-LEVEL Numeric 1 BR120 BR20.1
Level BR20.2 BR20.3
BR20.4 BR20.5
IVD-REASON-CODE Alpha 4 BR20.1 BR20.2
Reason Code This field contains the reason code, BR20.3 BR20.4
which indicates the cause for credit BR20.5
memos.
IVD-REVENUE-AMT Signed 15.2 BR120 BR20.1
Revenue Amt BR20.2 BR20.3
BR20.4 BR20.5
IVD-ADJ-LEVEL Alpha 1 BR20.1 BR20.2
Adj Level I = Invoice Level BR20.3 BR20.4
D = Invoice Detail Level BR20.5
P = Posting Activity Level
T = Transaction Detail Level
A = Posting Activity Acct Cat
H = Hold
IVD-HOLD-AMT Signed 15.2 BR20.1 BR20.2
Hold Amt BR20.3 BR20.4
BR20.5
IVD-LINE-NBR-MAP Numeric 6 BR20.1 BR20.2
Line Nbr Map BR20.3 BR20.4
BR20.5
IVD-SPLIT-OBJ-ID Numeric 12 BR20.1 BR20.2
Split Obj Id BR20.3 BR20.4
BR20.5
IVD-MX-CAT-DESC-1 Alpha 30 (Lower Case)
Mx Cat Desc 1
IVD-HOLD-REV-AMT Signed 15.2 BR20.1 BR20.2
Hold Rev Amt BR20.3 BR20.4
BR20.5
IVD-LINE-TYPE Alpha 1 BR02.3 BR120
Line Type This field contains the type of
inventory on this line.
ACINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVDSET1 CONTRACT AC10.1 AC300
COMPANY AC310 BR02.3
CUSTOMER BR121 BR20.1
AC-CUSTOMER-ID BR20.2 BR20.3
INVOICE-ID BR20.4 BR20.5
LINE-NBR BR420 BRIP.1
IVDSET2 CONTRACT BR20.1 BR20.2
COMPANY BR20.3 BR20.4
CUSTOMER
AC-CUSTOMER-ID
INVOICE-ID
LINE-NBR*
ACINVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acreasoncd ACREASONCD Required
IVD-REASON-CODE -> CDE-REASON-CODE
ACINVDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acinvhdr ACINVHDR
IVD-CONTRACT -> IVH-CONTRACT
IVD-COMPANY -> IVH-COMPANY
IVD-CUSTOMER -> IVH-CUSTOMER
IVD-AC-CUSTOMER-ID -> IVH-AC-CUSTOMER-ID
IVH-INVOICE-PREFIX
IVH-INVOICE-NBR
|