ACINVDTL FILE
REFERENCED BY
BR121 BR420
UPDATED BY
AC300 AC310 BR02.3 BR120 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.
IVD-PT-ACTIVITY Alpha 15 BR120
To Activity
IVD-ACTIVITY-GRP Alpha 15 BR120
Activity Group
IVD-ACCT-CATEGORY Alpha 5 BR120
Account Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
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.
IVD-RESOURCE-TYPE Alpha 1 BR120
Resource Type
IVD-RESOURCE-CODE Alpha 10 BR120
Resource Code
IVD-RESOURCE-DESC Alpha 30 (Lower Case) BR120
Resource Desc
IVD-BILL-RATE Signed 13.4 BR120
Bill Rate
IVD-MARK-UP-PCT Signed 5.2 BR120
Markup percentage
IVD-UNITS-AMOUNT Signed 15.2 BR120
Units Amount This is the units amount included in
the file.
IVD-UNIT-MEASURE Alpha 12 BR120
Unit Measure
IVD-MILESTONE Alpha 3 BR120
Milestone
IVD-PERC-COMPLETE Signed 7.3
Percent Complete
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-TAX-AMT Signed 15.2
Tax Amt
IVD-INVC-AMT Signed 15.2 BR02.3 BR120
Invc Amt
IVD-ADJ-AMT Signed 15.2
Adj Amt
IVD-POST-COMPANY Numeric 4 BR120
Post Company The company used for posting
transactions to the general ledger.
IVD-ACCT-UNIT Alpha 15 BR120
Accounting Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
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 BR120
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
IVD-MATRIX-CAT-1 Alpha 12 BR120
Attribute 1
IVD-MX-VALUE-1 Alpha 32 BR120
Attribute Value
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
Acct Cat Class
IVD-EXCEED-AMT Signed 15.2 BR120
Exceed Amt
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
Exceed Unit
IVD-LEVEL Numeric 1 BR120
Level
IVD-REASON-CODE Alpha 4
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
ACINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IVDSET1 CONTRACT AC300 AC310
COMPANY BR02.3 BR121
CUSTOMER BR420 BRIP.1
AC-CUSTOMER-ID
INVOICE-ID
LINE-NBR
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
|
