Billing Consolidation
UPDATED BY
BRIP.1 | BR300 |
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. |
|
||
IHC-LINE-NBR Element: Line Nbr | Numeric 6 The unique number of the invoice consolidated record. |
|
||
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). |
|
||
IHC-BILL-RATE Element: Bill Rate | Signed 13.4 The billing rate set up for a resource for a specific activity. |
|
||
IHC-UNITS-AMOUNT Element: Units Amount | Signed 15.2 This is the units amount included in the file. |
|
||
IHC-INVC-AMT Element: Intl Amt | Signed 18.2 |
|
||
IHC-CUM-AMT Element: Intl Amt | Signed 18.2 |
|
||
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. |
|
||
IHC-CONTRACT Element: Contract | Alpha 15 Activity Management contract. |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
IHC-ACCT-CATEGORY Element: Acct Category | Alpha 5 The account category associated with the invoice detail records. |
|
||
IHC-SUM-ACCT-CAT Element: Sum Acct Cat | Alpha 5 The name of the summary account category. |
|
||
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. |
|
||
IHC-MX-VALUE Element: Mx Value | Alpha 32 The attribute value. |
|
||
IHC-RESOURCE-TYPE Element: Resource Type | Alpha 1 The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor |
|
||
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. |
|
||
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. |
|
||
IHC-FIELD1-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
IHC-FIELD2-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
IHC-CTR-CAT-GRP Element: Ctr Cat Grp | Alpha 5 |
|
||
IHC-FIELD3-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
IHC-FIELD4-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
IHC-FIELD5-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
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. |
|
||
IHC-TAX-RATE Element: Tax Rate | Percent 7.5 (Percent) Occurs 8 Times The tax rate defined for the tax code. |
|
||
IHC-TAX-AMT Element: Intl Amt | Signed 18.2 Occurs 8 Times |
|
||
IHC-TAXABLE Element: Intl Amt | Signed 18.2 |
|
||
IHC-GRANT Element: Grant | Alpha 30 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
IHCSET1 |
OBJ-ID LINE-NBR |
|
| ||||||||
IHCSET2 |
CONTRACT OBJ-ID LINE-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Achisthdr | ACHISTHDR |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Achistdtl | ACHISTDTL |
| ||||||||||||
Acinvaudit | ACINVAUDIT |
|
All trademarks and registered trademarks are the property of their
respective owners.