|
|
ACHISTDTL FILE
REFERENCED BY
AC10.1 BR02.1 BR122 BR21.1 BR400 BR901
UPDATED BY
AC300 AC310 BR131 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDT-COMPANY Numeric 4 BR521 BRIP.1
Element: Company The company number represents an
established company and is entered on
all function codes.
HDT-CUSTOMER Alpha 9 (Right Justified) BR521 BRIP.1
Element: Customer NumbeThis field contains the number that
represents a customer.
HDT-INVOICE Alpha 22 BR521 BRIP.1
Element: Invoice NumberUsed to identify the invoice.
HDT-INVOICE-PREFIX Alpha 2 BR521 BRIP.1
Element: Invoice Prefix
HDT-INVOICE-NBR Numeric 8 BR521 BRIP.1
Element: Invoice Nbr
HDT-LINE-NBR Numeric 6 BR521 BRIP.1
Element: Line Number This field contains the line number.
HDT-SEQ-NBR Numeric 4 BR521 BRIP.1
Element: Sequence NumbeAn automatically assigned sequence
number.
HDT-PT-ACTIVITY Alpha 15 BR521 BRIP.1
Element: Activity
HDT-ACCT-CATEGORY Alpha 5 BR521 BRIP.1
Element: Account CategoAccount 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 BR521 BRIP.1
Element: Billing Method
HDT-TRAN-DATE Numeric 8 (yyyymmdd) BR521 BRIP.1
Element: Date
HDT-DESCRIPTION Alpha 30 (Lower Case) BR521 BRIP.1
Element: Description This field displays the description.
HDT-RESOURCE-TYPE Alpha 1 BR521 BRIP.1
Element: Resource Type
HDT-RESOURCE-CODE Alpha 10 BR521 BRIP.1
Element: Resource Code
HDT-RESOURCE-DESC Alpha 30 (Lower Case) BR521 BRIP.1
Element: Description
HDT-BILL-RATE Signed 13.4 BR521 BRIP.1
Element: Document Total
HDT-MARK-UP-PCT Signed 5.2 BR521 BRIP.1
Element: Bus Percent
HDT-UNITS-AMOUNT Signed 15.2 BR521 BRIP.1
Element: Adj Amt This is the units amount included in
the file.
HDT-UNIT-MEASURE Alpha 12 BR521 BRIP.1
Element: Unit Measure
HDT-MILESTONE Alpha 3 BR521 BRIP.1
Element: Milestone
HDT-PERC-COMPLETE Signed 7.3
Element: Percent Complete
HDT-TAX-EXEMPT-CD Alpha 1 BR521 BRIP.1
Element: Tax Exempt Code
HDT-TAX-CODE Alpha 10 BR521 BRIP.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
HDT-INVC-AMT Signed 15.2 BR521 BRIP.1
Element: 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 BR521 BRIP.1
Element: Tax Amt
HDT-POST-COMPANY Numeric 4 BR521 BRIP.1
Element: Company
HDT-ACCT-UNIT Alpha 15 BR521 BRIP.1
Element: Accounting UniThe 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 BR521 BRIP.1
Element: 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 BR521 BRIP.1
Element: 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 BR521 BRIP.1
Object
Identification
HDT-MATRIX-CAT-1 Alpha 12 BR521 BRIP.1
Element: Attribute
HDT-MX-VALUE-1 Alpha 32 BR521 BRIP.1
Element: Attribute Value
HDT-MATRIX-CAT-2 Alpha 12 BR521 BRIP.1
Element: Attribute
HDT-MX-VALUE-2 Alpha 32
Element: Attribute Value
HDT-MATRIX-CAT-3 Alpha 12
Element: Attribute
HDT-MX-VALUE-3 Alpha 32
Element: Attribute Value
HDT-ACCT-CAT-CLASS Alpha 5 BR521 BRIP.1
Element: Acct Cat Class
HDT-CUM-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Amt
HDT-CUM-UNIT Signed 15.2 BR521 BRIP.1
Element: Cum Unit
HDT-CUM-TAX-AMT Signed 15.2
Element: Cum Tax Amt
HDT-EXCEED-AMT Signed 15.2 BR521 BRIP.1
Element: Exceed Amt
HDT-EXCEED-UNIT Signed 15.2 BR521 BRIP.1
Element: Exceed Unit
HDT-BILL-ACTIVITY Alpha 15 BR521 BRIP.1
Element: Bill Activity
HDT-CONTRACT Alpha 10 BR521 BRIP.1
Element: Bid Name
HDT-AC-CUSTOMER-ID Alpha 5 BR521 BRIP.1
Element: Ac Customer Id
HDT-RETAINAGE-AMT Signed 15.2 BR521 BRIP.1
Element: Retainage Amt
HDT-LEVEL Numeric 1 BR521 BRIP.1
Element: Level
HDT-REASON-CODE Alpha 4 BR521 BRIP.1
Accounts Receivable This field contains the reason code,
Code which indicates the cause for credit
memos.
HDT-REVENUE-AMT Signed 15.2 BR521 BRIP.1
Element: Adj Amt
HDT-ADJ-LEVEL Alpha 1 BR521 BRIP.1
Element: Adj Level I = Invoice Level
D = Invoice Detail Level
T = Transaction Detail Level
P = Posting Activity Level
A = Posting Activity Acct Cat
H = Hold
HDT-SPLIT-OBJ-ID Numeric 12 BR521 BRIP.1
Element: Split Obj Id
HDT-ORIG-LINE-NBR Numeric 6 BR521 BRIP.1
Element: Original Line Number
HDT-LINE-NBR-MAP Numeric 6 BR521 BRIP.1
Element: Line Nbr Map
HDT-MX-CAT-DESC-1 Alpha 30 (Lower Case)
Element: Mx Cat Desc 1
HDT-ADJUST-AMT Signed 15.2 BR131
Element: Adjust Amt
HDT-LINE-TYPE Alpha 1 BR521 BRIP.1
Element: Line Type This field contains the type of
inventory on this line.
HDT-SEQ-NBR-2 Numeric 4 BR521 BRIP.1
Element: Seq Nbr 2
ACHISTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDTSET1 CONTRACT AC10.1 AC300
COMPANY AC310 BR02.1
CUSTOMER BR122 BR131
AC-CUSTOMER-ID BR21.1 BR400
INVOICE-PREFIX BR521 BR901
INVOICE-NBR BRIP.1
LINE-NBR
SEQ-NBR
SEQ-NBR-2
HDTSET2 CONTRACT BR131
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
LINE-NBR
SEQ-NBR
SEQ-NBR-2
HDTSET3 ATN-OBJ-ID
CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
LINE-NBR
SEQ-NBR
SEQ-NBR-2
HDTSET4 CONTRACT BR131
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
ORIG-LINE-NBR
LINE-NBR
SEQ-NBR
SEQ-NBR-2
ACHISTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achistcnsl ACHISTCNSL Required
HDT-CONTRACT -> IHC-CONTRACT
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
Acreasoncd ACREASONCD Required
HDT-REASON-CODE -> CDE-REASON-CODE
Actrans ACTRANS Required
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
Achisttax ACHISTTAX
HDT-CONTRACT -> HIT-CONTRACT
HDT-COMPANY -> HIT-COMPANY
HDT-CUSTOMER -> HIT-CUSTOMER
HDT-AC-CUSTOMER-ID -> HIT-AC-CUSTOMER-ID
HDT-INVOICE-PREFIX -> HIT-INVOICE-PREFIX
HDT-INVOICE-NBR -> HIT-INVOICE-NBR
HDT-LINE-NBR -> HIT-LINE-NBR
HDT-SEQ-NBR -> HIT-SEQ-NBR
HIT-TAX-CODE
HIT-TAX-LEVEL
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
|
