ACHISTCNSL

Billing Consolidation
UPDATED BY
BR300 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IHC-OBJ-ID
Element: Obj Id
Numeric 12
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.
BRIP.1
IHC-LINE-NBR
Element: Line Nbr
Numeric 6
The unique number of the invoice consolidated record.
BRIP.1
IHC-DESCRIPTION
Element: Long Desc
Alpha 60 (Lower Case)
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).
BRIP.1
IHC-BILL-RATE
Element: Bill Rate
Signed 13.4
The billing rate set up for a resource for a specific activity.
BRIP.1
IHC-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
This is the units amount included in the file.
BRIP.1
IHC-INVC-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
IHC-CUM-AMT
Element: Intl Amt
Signed 18.2
BRIP.1
IHC-CUM-UNIT
Element: Cum Unit
Signed 15.2
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.
BRIP.1
IHC-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BRIP.1
IHC-LINE-TYPE
Element: Line Type
Alpha 1
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
BRIP.1
IHC-LINE-LVL
Element: Line Lvl
Numeric 1

1 = Detail
2 = Footer
3 = Total
4 = Gross Total
5 = Sub Total
6 = Final Total
7 = Invoice Tax Total
8 = Invoice Total
BRIP.1
IHC-FEE-CD
Element: Fee Cd
Alpha 5
The fee code name will be a user defined identifier of the code that will be used to calculate fee.
BRIP.1
IHC-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category associated with the invoice detail records.
BRIP.1
IHC-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
BRIP.1
IHC-MATRIX-CAT
Element: Matrix Cat
Alpha 12
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.
BRIP.1
IHC-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
BRIP.1
IHC-RESOURCE-TYPE
Element: Resource Type
Alpha 1
The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor
BRIP.1
IHC-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group associated with the invoice transactions.
BRIP.1
IHC-RESOURCE-COMP
Element: Resource Comp
Numeric 4
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.
BRIP.1
IHC-FIELD1-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
IHC-FIELD2-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
IHC-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5
BRIP.1
IHC-FIELD3-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
IHC-FIELD4-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
IHC-FIELD5-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BRIP.1
IHC-TAX-CODE
Element: Tax Code
Alpha 10 Occurs 8 Times
This field contains a code representing specific tax information. This must be valid Tax Code.
BRIP.1
IHC-TAX-RATE
Element: Tax Rate
Percent 7.5 (Percent) Occurs 8 Times
The tax rate defined for the tax code.
BRIP.1
IHC-TAX-AMT
Element: Intl Amt
Signed 18.2 Occurs 8 Times
BRIP.1
IHC-TAXABLE
Element: Intl Amt
Signed 18.2
BRIP.1
IHC-GRANT
Element: Grant
Alpha 30


ACHISTCNSL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IHCSET1 OBJ-ID
LINE-NBR
BR300 BRIP.1
IHCSET2 CONTRACT
OBJ-ID
LINE-NBR
KeyChange


ACHISTCNSL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
IHC-OBJ-ID->HIH-OBJ-ID (HIHSET1)


ACHISTCNSL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:10:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.