ACHISTCNSL FILE
REFERENCED BY
BR21.1
UPDATED BY
AC300 AC310 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IHC-COMPANY Numeric 4 BRIP.1
Company The company number represents an
established company and is entered on
all function codes.
IHC-CUSTOMER Alpha 9 (Right Justified) BRIP.1
Customer Number This field contains the number that
represents a customer.
IHC-INVOICE Alpha 22 BRIP.1
Invoice Number Used to identify the invoice.
IHC-INVOICE-PREFIX Alpha 2 BRIP.1
Invoice Prefix
IHC-INVOICE-NBR Numeric 8 BRIP.1
Invoice Nbr
IHC-LINE-NBR Numeric 6 BRIP.1
Line Number This field contains the line number.
IHC-FIELD-1 Alpha 30 BRIP.1
Field 1
IHC-FIELD-2 Alpha 30
Field 2
IHC-PT-ACTIVITY Alpha 15 BRIP.1
To Activity
IHC-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.
IHC-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
IHC-RESOURCE-TYPE Alpha 1 BRIP.1
Resource Type
IHC-RESOURCE-CODE Alpha 10 BRIP.1
Resource Code
IHC-RESOURCE-DESC Alpha 30 (Lower Case) BRIP.1
Resource Desc
IHC-BILL-RATE Signed 13.4 BRIP.1
Bill Rate
IHC-UNITS-AMOUNT Signed 15.2 BRIP.1
Units Amount This is the units amount included in
the file.
IHC-INVC-AMT Signed 15.2 BRIP.1
Invc Amt
IHC-TAX-AMT Signed 15.2
Tax Amt
IHC-MATRIX-CAT-1 Alpha 12
Attribute 1
IHC-MX-VALUE-1 Alpha 32
Attribute Value
IHC-MATRIX-CAT-2 Alpha 12
Attribute 2
IHC-MX-VALUE-2 Alpha 32
Attribute Value
IHC-MATRIX-CAT-3 Alpha 12
Attribute 3
IHC-MX-VALUE-3 Alpha 32
Attribute Value
IHC-ACCT-CAT-CLASS Alpha 5
Acct Cat Class
IHC-CUM-AMT Signed 15.2 BRIP.1
Cum Amt
IHC-CUM-UNIT Signed 15.2 BRIP.1
Cum Unit
IHC-CUM-TAX-AMT Signed 15.2
Cum Tax Amt
IHC-BILL-ACTIVITY Alpha 15
Bill Activity
IHC-CONTRACT Alpha 10 BRIP.1
Contract
IHC-AC-CUSTOMER-ID Alpha 5 BRIP.1
Ac Customer Id
ACHISTCNSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IHCSET1 CONTRACT AC300 AC310
COMPANY BR21.1 BRIP.1
CUSTOMER
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
Achisthdtl 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
IHC-LINE-NBR -> HDT-LINE-NBR
HDT-SEQ-NBR
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
|
