|
ACHISTCNSL FILE
Billing Consolidation
UPDATED BY
BRIP.1 BR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IHC-OBJ-ID Numeric 12 BRIP.1
Element: Obj Id The object identifier is a number used
to relate the invoice consolidated
records to the invoice header/detail
records. The object Type is INVID in
the OBJID file.
IHC-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr The unique number of the invoice
consolidated record.
IHC-DESCRIPTION Alpha 60 (Lower Case) BRIP.1
Element: Long Desc The description that displays in the
print file for the invoice, based on
what the summarize options are set for
in the AC Customer(BR11).
IHC-BILL-RATE Signed 13.4 BRIP.1
Element: Bill Rate The billing rate set up for a resource
for a specific activity.
IHC-UNITS-AMOUNT Signed 15.2 BRIP.1
Element: Units Amount This is the units amount included in
the file.
IHC-INVC-AMT Signed 18.2 BRIP.1
Element: Intl Amt
IHC-CUM-AMT Signed 18.2 BRIP.1
Element: Intl Amt
IHC-CUM-UNIT Signed 15.2 BRIP.1
Element: Cum Unit This field stores the cumulative units
used to calculate fee. It is all costs
available for billing or revenue based
on the account categories set up as
drivers on fee code set up.
IHC-CONTRACT Alpha 15 BRIP.1
Element: Contract Activity Management contract.
IHC-LINE-TYPE Alpha 1 BRIP.1
Element: Line Type This field contains the type of
inventory on this line.
The values are:
A = Transaction
B = Milestone
C = Tax
F = Fee
G = Retention on Fee
H = Overage of Fee
I = Billed Retention on Fee
J = Billed Overage on Fee
K = Overage
L = Billed Overage
M = Retention
N = Billed Retention
O = Retainer
P = Billed Retainer
IHC-LINE-LVL Numeric 1 BRIP.1
Element: Line Lvl 1 = Detail
2 = Footer
3 = Total
4 = Gross Total
5 = Sub Total
6 = Final Total
7 = Invoice Tax Total
8 = Invoice Total
IHC-FEE-CD Alpha 5 BRIP.1
Element: Fee Cd The fee code name will be a user defined
identifier of the code that will be used
to calculate fee.
IHC-ACCT-CATEGORY Alpha 5 BRIP.1
Element: Acct Category The account category associated with the
invoice detail records.
IHC-SUM-ACCT-CAT Alpha 5 BRIP.1
Element: Sum Acct Cat The name of the summary account
category.
IHC-MATRIX-CAT Alpha 12 BRIP.1
Element: Matrix Cat Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
IHC-MX-VALUE Alpha 32 BRIP.1
Element: Mx Value The attribute value.
IHC-RESOURCE-TYPE Alpha 1 BRIP.1
Element: Resource Type The type of resource. Valid values
include:
P - AC Person
Q - Equipment
E - Employee
V - Vendor
IHC-RESOURCE-CODE Alpha 10 BRIP.1
Element: Resource Code The code identifying the resource
assigned to the activity or activity
group associated with the invoice
transactions.
IHC-RESOURCE-COMP Numeric 4 BRIP.1
Element: Resource Comp Resource Company. Identifies the AP
company if the resource type = V.
Identifies the HR company if the
resource type = E. It is the from
company blank with the from company for
type P or Q resources.
IHC-FIELD1-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
IHC-FIELD2-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
IHC-CTR-CAT-GRP Alpha 5 BRIP.1
Element: Ctr Cat Grp
IHC-FIELD3-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
IHC-FIELD4-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
IHC-FIELD5-DESC Alpha 30 (Lower Case) BRIP.1
Element: Description This field displays the description.
IHC-TAX-CODE Alpha 10 Occurs 8 Times BRIP.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
IHC-TAX-RATE Percent 7.5 (Percent) Occurs 8 Times BRIP.1
Element: Tax Rate The tax rate defined for the tax code.
IHC-TAX-AMT Signed 18.2 Occurs 8 Times BRIP.1
Element: Intl Amt
IHC-TAXABLE Signed 18.2 BRIP.1
Element: Intl Amt
ACHISTCNSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IHCSET1 OBJ-ID BR300 BRIP.1
LINE-NBR
IHCSET2 CONTRACT KeyChange
OBJ-ID
LINE-NBR
ACHISTCNSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
IHC-OBJ-ID -> HIH-OBJ-ID (HIHSET1)
ACHISTCNSL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
IHC-OBJ-ID -> HDT-OBJ-ID
IHC-LINE-NBR -> HDT-CNSL-LINE-NBR
HDT-LINE-NBR
Acinvaudit ACINVAUDIT
IHC-OBJ-ID -> IVA-OBJ-ID
IVA-LINE-NBR
IVA-TRANS-DATE
IVA-SEQUENCE-NBR
|