Lawson Insight Technical Documentation |
|
ACINVDTL
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 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IVD-COMPANY Numeric 4 BR02.3 BR120
Element: Company The company number represents an
established company and is entered on
all function codes.
IVD-CUSTOMER Alpha 9 (Right Justified) BR02.3 BR120
Element: Customer NumbeThis field contains the number that
represents a customer.
IVD-INVOICE-ID Numeric 6 BR02.3 BR120
Element: Invoice Id
IVD-LINE-NBR Numeric 6 BR02.3 BR120
Element: 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
Element: Activity BR20.2 BR20.3
BR20.4 BR20.5
IVD-ACTIVITY-GRP Alpha 15 BR120
Element: Group
IVD-ACCT-CATEGORY Alpha 5 BR02.3 BR120
Element: Account CategoAccount 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
Element: Billing Method
IVD-TRAN-DATE Numeric 8 (yyyymmdd) BR120
Element: Date
IVD-DESCRIPTION Alpha 30 (Lower Case) BR02.3 BR120
Element: Description This field displays the description. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-RESOURCE-TYPE Alpha 1 BR120 BR20.5
Element: Resource Type
IVD-RESOURCE-CODE Alpha 10 BR120 BR20.5
Element: Resource Code
IVD-RESOURCE-DESC Alpha 30 (Lower Case) BR120 BR20.5
Element: Description
IVD-BILL-RATE Signed 13.4 BR120 BR20.1
Element: Document Total BR20.2 BR20.3
BR20.4 BR20.5
IVD-MARK-UP-PCT Signed 5.2 BR120 BR20.1
Element: Bus Percent BR20.2 BR20.3
BR20.4 BR20.5
IVD-UNITS-AMOUNT Signed 15.2 BR120 BR20.1
Element: Adj Amt 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
Element: Unit Measure BR20.2 BR20.3
BR20.4 BR20.5
IVD-MILESTONE Alpha 3 BR120 BR20.1
Element: Milestone BR20.2 BR20.3
BR20.4 BR20.5
IVD-PERC-COMPLETE Signed 7.3 BR20.1 BR20.2
Element: Percent Complete BR20.3 BR20.4
BR20.5
IVD-TAX-EXEMPT-CD Alpha 1 BR120
Element: Tax Exempt Code
IVD-TAX-CODE Alpha 10 BR120
Element: 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
Element: Invc Amt BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-POST-COMPANY Numeric 4 BR02.3 BR120
Element: Company BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
IVD-ACCT-UNIT Alpha 15 BR02.3 BR120
Element: Accounting UniThe 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
Element: 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
Element: 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
Object BR20.1 BR20.2
Identification BR20.3 BR20.4
BR20.5
IVD-MATRIX-CAT-1 Alpha 12 BR120 BR20.1
Element: Attribute BR20.2 BR20.3
BR20.4 BR20.5
IVD-MX-VALUE-1 Alpha 32 BR120 BR20.1
Element: Attribute Value BR20.2 BR20.3
BR20.4 BR20.5
IVD-MATRIX-CAT-2 Alpha 12
Element: Attribute
IVD-MX-VALUE-2 Alpha 32
Element: Attribute Value
IVD-MATRIX-CAT-3 Alpha 12
Element: Attribute
IVD-MX-VALUE-3 Alpha 32
Element: Attribute Value
IVD-CHANGE-STATUS Alpha 1 BR120
Element: Change Status Y = Yes
N = No
9 = Delete
IVD-ACCT-CAT-CLASS Alpha 5 BR120 BR20.1
Element: Acct Cat Class BR20.2 BR20.3
BR20.4 BR20.5
IVD-EXCEED-AMT Signed 15.2 BR120 BR20.1
Element: Exceed Amt BR20.2 BR20.3
BR20.4 BR20.5
IVD-CONTRACT Alpha 10 BR02.3 BR120
Element: Bid Name
IVD-BILL-ACTIVITY Alpha 15 BR02.3 BR120
Element: Bill Activity
IVD-AC-CUSTOMER-ID Alpha 5 BR02.3 BR120
Element: Ac Customer Id
IVD-EXCEED-UNIT Signed 15.2 BR120 BR20.1
Element: Exceed Unit BR20.2 BR20.3
BR20.4 BR20.5
IVD-LEVEL Numeric 1 BR120 BR20.1
Element: Level BR20.2 BR20.3
BR20.4 BR20.5
IVD-REASON-CODE Alpha 4 BR20.1 BR20.2
Accounts Receivable This field contains the reason code, BR20.3 BR20.4
Code which indicates the cause for credit BR20.5
memos.
IVD-REVENUE-AMT Signed 15.2 BR120 BR20.1
Element: Adj Amt BR20.2 BR20.3
BR20.4 BR20.5
IVD-ADJ-LEVEL Alpha 1 BR20.1 BR20.2
Element: 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
Element: Hold Amt BR20.3 BR20.4
BR20.5
IVD-LINE-NBR-MAP Numeric 6 BR20.1 BR20.2
Element: Line Nbr Map BR20.3 BR20.4
BR20.5
IVD-SPLIT-OBJ-ID Numeric 12 BR20.1 BR20.2
Element: Split Obj Id BR20.3 BR20.4
BR20.5
IVD-MX-CAT-DESC-1 Alpha 30 (Lower Case)
Element: Mx Cat Desc 1
IVD-HOLD-REV-AMT Signed 15.2 BR20.1 BR20.2
Element: Hold Rev Amt BR20.3 BR20.4
BR20.5
IVD-LINE-TYPE Alpha 1 BR02.3 BR120
Element: 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 BR521
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
|