ACHISTDTL FILE
REFERENCED BY
BR21.1 BR400
UPDATED BY
AC300 AC310 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDT-COMPANY Numeric 4 BRIP.1
Company The company number represents an
established company and is entered on
all function codes.
HDT-CUSTOMER Alpha 9 (Right Justified) BRIP.1
Customer Number This field contains the number that
represents a customer.
HDT-INVOICE Alpha 22 BRIP.1
Invoice Number Used to identify the invoice.
HDT-INVOICE-PREFIX Alpha 2 BRIP.1
Invoice Prefix
HDT-INVOICE-NBR Numeric 8 BRIP.1
Invoice Nbr
HDT-LINE-NBR Numeric 6 BRIP.1
Line Number This field contains the line number.
HDT-SEQ-NBR Numeric 4 BRIP.1
Sequence Number An automatically assigned sequence
number.
HDT-PT-ACTIVITY Alpha 15 BRIP.1
To Activity
HDT-ACCT-CATEGORY Alpha 5 BRIP.1
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.
HDT-BILLING-METHOD Numeric 1 BRIP.1
Billing Method
HDT-TRAN-DATE Numeric 8 (yyyymmdd) BRIP.1
Transaction Date
HDT-DESCRIPTION Alpha 30 (Lower Case) BRIP.1
Description This field displays the description.
HDT-RESOURCE-TYPE Alpha 1 BRIP.1
Resource Type
HDT-RESOURCE-CODE Alpha 10 BRIP.1
Resource Code
HDT-RESOURCE-DESC Alpha 30 (Lower Case) BRIP.1
Resource Desc
HDT-BILL-RATE Signed 13.4 BRIP.1
Bill Rate
HDT-MARK-UP-PCT Signed 5.2 BRIP.1
Markup percentage
HDT-UNITS-AMOUNT Signed 15.2 BRIP.1
Units Amount This is the units amount included in
the file.
HDT-UNIT-MEASURE Alpha 12 BRIP.1
Unit Measure
HDT-MILESTONE Alpha 3 BRIP.1
Milestone
HDT-PERC-COMPLETE Signed 7.3
Percent Complete
HDT-TAX-EXEMPT-CD Alpha 1 BRIP.1
Tax Exempt Code
HDT-TAX-CODE Alpha 10 BRIP.1
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
HDT-INVC-AMT Signed 15.2 BRIP.1
Invc Amt The amount written to this record is the
invoice amount. Any billing adjustments
made to the invoice line will be
included in this line.
HDT-TAX-AMT Signed 15.2
Tax Amt
HDT-POST-COMPANY Numeric 4 BRIP.1
Post Company The company used for posting
transactions to the general ledger.
HDT-ACCT-UNIT Alpha 15 BRIP.1
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.
HDT-ACCOUNT Numeric 6 BRIP.1
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
HDT-SUB-ACCT Numeric 4 BRIP.1
Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
HDT-ATN-OBJ-ID Numeric 12 BRIP.1
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
HDT-MATRIX-CAT-1 Alpha 12 BRIP.1
Attribute 1
HDT-MX-VALUE-1 Alpha 32 BRIP.1
Attribute Value
HDT-MATRIX-CAT-2 Alpha 12
Attribute 2
HDT-MX-VALUE-2 Alpha 32
Attribute Value
HDT-MATRIX-CAT-3 Alpha 12
Attribute 3
HDT-MX-VALUE-3 Alpha 32
Attribute Value
HDT-ACCT-CAT-CLASS Alpha 5 BRIP.1
Acct Cat Class
HDT-CUM-AMT Signed 15.2 BRIP.1
Cum Amt
HDT-CUM-UNIT Signed 15.2 BRIP.1
Cum Unit
HDT-CUM-TAX-AMT Signed 15.2
Cum Tax Amt
HDT-EXCEED-AMT Signed 15.2 BRIP.1
Exceed Amt
HDT-EXCEED-UNIT Signed 15.2 BRIP.1
Exceed Unit
HDT-BILL-ACTIVITY Alpha 15 BRIP.1
Bill Activity
HDT-CONTRACT Alpha 10 BRIP.1
Contract
HDT-AC-CUSTOMER-ID Alpha 5 BRIP.1
Ac Customer Id
HDT-RETAINAGE-AMT Signed 15.2 BRIP.1
Retainage Amt
HDT-LEVEL Numeric 1 BRIP.1
Level
HDT-REASON-CODE Alpha 4
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
ACHISTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDTSET1 CONTRACT AC300 AC310
COMPANY BR21.1 BR400
CUSTOMER BRIP.1
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
LINE-NBR
SEQ-NBR
HDTSET2 CONTRACT Duplicates
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
LINE-NBR
SEQ-NBR
HDTSET3 ATN-OBJ-ID Duplicates
CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
LINE-NBR
SEQ-NBR
ACHISTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achistcnsl ACHISTCNSL Required
HDT-CONTRACT -> IHC-CONTRACT (IHCSET1)
HDT-COMPANY -> IHC-COMPANY
HDT-CUSTOMER -> IHC-CUSTOMER
HDT-AC-CUSTOMER-ID -> IHC-AC-CUSTOMER-ID
HDT-INVOICE-PREFIX -> IHC-INVOICE-PREFIX
HDT-INVOICE-NBR -> IHC-INVOICE-NBR
HDT-LINE-NBR -> IHC-LINE-NBR
Achisthdr ACHISTHDR Required
HDT-CONTRACT -> HIH-CONTRACT
HDT-COMPANY -> HIH-COMPANY
HDT-CUSTOMER -> HIH-CUSTOMER
HDT-AC-CUSTOMER-ID -> HIH-AC-CUSTOMER-ID
HDT-INVOICE-PREFIX -> HIH-INVOICE-PREFIX
HDT-INVOICE-NBR -> HIH-INVOICE-NBR
Actrans ACTRANS Required
HDT-ACCT-CATEGORY -> ATN-ACCT-CATEGORY
HDT-ATN-OBJ-ID -> ATN-OBJ-ID
ACHISTDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acclgtrans ACCLGTRANS
HDT-ATN-OBJ-ID -> CGT-OBJ-ID
CGT-CONT-ACTIVITY
CGT-BILL-ACTIVITY
CGT-ACCT-CATEGORY
CGT-ACCT-CAT-CLASS
CGT-MATRIX-CAT
CGT-MX-VALUE
Acinvaudit ACINVAUDIT
HDT-CONTRACT -> IVA-CONTRACT
HDT-COMPANY -> IVA-COMPANY
HDT-CUSTOMER -> IVA-CUSTOMER
HDT-AC-CUSTOMER-ID -> IVA-AC-CUSTOMER-ID
HDT-INVOICE-PREFIX -> IVA-INVOICE-PREFIX
HDT-INVOICE-NBR -> IVA-INVOICE-NBR
HDT-LINE-NBR -> IVA-LINE-NBR
IVA-TRANS-DATE
IVA-SEQUENCE-NBR
|
