|
|
ACHISTCNSL FILE
REFERENCED BY
BR21.1
UPDATED BY
AC300 AC310 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IHC-COMPANY Numeric 4 BR521 BRIP.1
Element: Company The company number represents an
established company and is entered on
all function codes.
IHC-CUSTOMER Alpha 9 (Right Justified) BR521 BRIP.1
Element: Customer NumbeThis field contains the number that
represents a customer.
IHC-INVOICE Alpha 22 BR521 BRIP.1
Element: Invoice NumberUsed to identify the invoice.
IHC-INVOICE-PREFIX Alpha 2 BR521 BRIP.1
Element: Invoice Prefix
IHC-INVOICE-NBR Numeric 8 BR521 BRIP.1
Element: Invoice Nbr
IHC-LINE-NBR Numeric 6 BR521 BRIP.1
Element: Line Number This field contains the line number.
IHC-FIELD-1 Alpha 32 BR521 BRIP.1
Element: Field 1
IHC-FIELD-2 Alpha 32
Element: Field 2
IHC-PT-ACTIVITY Alpha 15 BR521 BRIP.1
Element: Activity
IHC-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.
IHC-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
IHC-RESOURCE-TYPE Alpha 1 BR521 BRIP.1
Element: Resource Type
IHC-RESOURCE-CODE Alpha 10 BR521 BRIP.1
Element: Resource Code
IHC-RESOURCE-DESC Alpha 30 (Lower Case) BR521 BRIP.1
Element: Description
IHC-BILL-RATE Signed 13.4 BR521 BRIP.1
Element: Document Total
IHC-UNITS-AMOUNT Signed 15.2 BR521 BRIP.1
Element: Adj Amt This is the units amount included in
the file.
IHC-INVC-AMT Signed 15.2 BR521 BRIP.1
Element: Invc Amt
IHC-TAX-AMT Signed 15.2
Element: Tax Amt
IHC-MATRIX-CAT-1 Alpha 12
Element: Attribute
IHC-MX-VALUE-1 Alpha 32
Element: Attribute Value
IHC-MATRIX-CAT-2 Alpha 12
Element: Attribute
IHC-MX-VALUE-2 Alpha 32
Element: Attribute Value
IHC-MATRIX-CAT-3 Alpha 12
Element: Attribute
IHC-MX-VALUE-3 Alpha 32
Element: Attribute Value
IHC-ACCT-CAT-CLASS Alpha 5 BR521 BRIP.1
Element: Acct Cat Class
IHC-CUM-AMT Signed 15.2 BR521 BRIP.1
Element: Cum Amt
IHC-CUM-UNIT Signed 15.2 BR521 BRIP.1
Element: Cum Unit
IHC-CUM-TAX-AMT Signed 15.2
Element: Cum Tax Amt
IHC-BILL-ACTIVITY Alpha 15
Element: Bill Activity
IHC-CONTRACT Alpha 10 BR521 BRIP.1
Element: Bid Name
IHC-AC-CUSTOMER-ID Alpha 5 BR521 BRIP.1
Element: Ac Customer Id
ACHISTCNSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IHCSET1 CONTRACT AC300 AC310
COMPANY BR21.1 BR521
CUSTOMER BRIP.1
AC-CUSTOMER-ID
INVOICE-PREFIX
INVOICE-NBR
LINE-NBR
IHCSET2 CONTRACT
COMPANY
CUSTOMER
AC-CUSTOMER-ID
INVOICE
LINE-NBR
ACHISTCNSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
IHC-CONTRACT -> HIH-CONTRACT (HIHSET1)
IHC-COMPANY -> HIH-COMPANY
IHC-CUSTOMER -> HIH-CUSTOMER
IHC-AC-CUSTOMER-ID -> HIH-AC-CUSTOMER-ID
IHC-INVOICE-PREFIX -> HIH-INVOICE-PREFIX
IHC-INVOICE-NBR -> HIH-INVOICE-NBR
Arcomp ARCOMP Required
IHC-COMPANY -> ACO-COMPANY
ACHISTCNSL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
IHC-CONTRACT -> HDT-CONTRACT
IHC-COMPANY -> HDT-COMPANY
IHC-CUSTOMER -> HDT-CUSTOMER
IHC-AC-CUSTOMER-ID -> HDT-AC-CUSTOMER-ID
IHC-INVOICE-PREFIX -> HDT-INVOICE-PREFIX
IHC-INVOICE-NBR -> HDT-INVOICE-NBR
HDT-LINE-NBR
HDT-SEQ-NBR
HDT-SEQ-NBR-2
Acinvaudit ACINVAUDIT
IHC-CONTRACT -> IVA-CONTRACT
IHC-COMPANY -> IVA-COMPANY
IHC-CUSTOMER -> IVA-CUSTOMER
IHC-AC-CUSTOMER-ID -> IVA-AC-CUSTOMER-ID
IHC-INVOICE-PREFIX -> IVA-INVOICE-PREFIX
IHC-INVOICE-NBR -> IVA-INVOICE-NBR
IHC-LINE-NBR -> IVA-LINE-NBR
IVA-TRANS-DATE
IVA-SEQUENCE-NBR
|
