Invoice Detail

The Billing and Revenue Invoice detail file contains the records associated with an invoice header. The file is keyed by the OBJ-ID associated with the invoice header.
UPDATED BY

TX101

AC10.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
HDT-OBJ-ID Element: Obj Id	Numeric 12 The object identifier is a number used to relate the invoice detail records to the invoice header. The object type is INVID in the OBJID file.
HDT-LINE-NBR Element: Line Nbr	Numeric 6 The line number associated with the invoice detail record. It, in combination with the OBJ-ID field, keeps the ACHISTDTL record unique.
HDT-CNSL-LINE-NBR Element: Line Nbr	Numeric 6 The number that maps the ACHISTCNSL file line number to this record.
HDT-PT-ACTIVITY Element: Activity	Alpha 15 The posting activity associated with the original activity transaction being billed on this invoice.
HDT-ACCT-CATEGORY Element: Acct Category	Alpha 5 The account category associated with the original activity transaction being billed on this invoice.
HDT-BILLING-METHOD Element: Billing Method	Numeric 1 The billing method maintained for the activity associated with the invoice transaction in the Activity Billing (BR00) or Billing Detail (BR00.2) 1=Time and Materials 2=Cost Plus 3=Units of Production 4=Milestone 5=Pass Thru 9=User defined 1 = Time and Materials 2 = Cost Plus 3 = Units of Production 4 = Milestone 5 = Pass Thru 9 = User defined
HDT-TRAN-DATE Element: Tran Date	Numeric 8 (yyyymmdd) The transaction date associated with the original activity transaction being billed on this invoice.
HDT-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description associated with the original activity transaction being billed on this invoice.
HDT-RESOURCE-TYPE Element: Resource Type	Alpha 1 The type of resource associated with the original activity transaction. The valid values are: P=AC Person Q=Equipment E=Employee V=Vendor Q = Equipment P = Person
HDT-RESOURCE-COMP Element: Company	Numeric 4 The resource company or from company on the original activity transaction.
HDT-RESOURCE-CODE Element: Resource Code	Alpha 10 The resource code associated with the original activity transacton being billed on this invoice.
HDT-RESOURCE-DESC Element: Description	Alpha 30 (Lower Case) The description of the resource code maintained in Resource (AC03).
HDT-BILL-RATE Element: Bill Rate	Signed 13.4 The billing rate that is associated with the original activity transaction being billed on this invoice. Only populated when the billing method is Time and Materials.
HDT-MARK-UP-PCT Element: Mark Up Pct	Signed 5.2 The percentage of markup for billing associated with the account category on the original activity transaction. The markup percent is maintained in Account Category Detail (AC08.3) and/or Billing Detail (BR00.2). Markup percentages will increase the cost amount by the percentage entered.
HDT-UNITS-AMOUNT Element: Units Amount	Signed 15.2 The billable units amount associated with the original activity transaction.
HDT-UNIT-MEASURE Element: Unit Measure	Alpha 12 The unit of measure associated with the original activity transaction.
HDT-MILESTONE Element: Milestone	Alpha 3 The milestone code maintained in Milestone (BR05). Only populated when the billing method is Milestone.
HDT-PERC-COMPLETE Element: Perc Complete	Signed 7.3 The percentage of completion associated with the percent complete milestone maintained in Percent Complete Milestones (BR05).
HDT-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 The code indicating the taxing status. The valid values are: E=Exempt T=Taxable E = Exempt T = Taxable
HDT-TAX-CODE Element: Tax Code	Alpha 10 The code representing specific tax information. Must be a valid Tax Code.
HDT-INVC-AMT Element: Intl Amt	Signed 18.2 The invoice amount. Any billing adjustments made to the invoice line will be included in this line.
HDT-TAX-AMT Element: Intl Amt	Signed 18.2 The tax amount calculated for the invoice line.
HDT-POST-COMPANY Element: Company	Numeric 4 The company used for posting transactions to the General Ledger.
HDT-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit used in the transaction that is posted to General Ledger. This field along with the account and subaccount make up the location (account) where the amount and other account information is stored.
HDT-ACCOUNT Element: Account	Numeric 6 The Account used in the transaction that is posted to General Ledger. This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
HDT-SUB-ACCT Element: Sub Acct	Numeric 4 The subaccount used in the transaction that is posted ot General Ledger. This field along with the accounting unit and account make up the location (account) where ammounts and other account information is stored. subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
HDT-ATN-OBJ-ID Element: Obj Id	Numeric 12 The system-defined object id representing the original activity transaction.
HDT-MATRIX-CAT-1 Element: Matrix Cat	Alpha 12 The Billing Category name associated with the original activity transaction for this invoice.
HDT-MX-VALUE-1 Element: Mx Value 1	Alpha 32 The Billing Category value associated with the original activity transaction.
HDT-MATRIX-CAT-2 Element: Matrix Cat	Alpha 12 The Billing Category name associated with the original activity transaction for this invoice.
HDT-MX-VALUE-2 Element: Mx Value 2	Alpha 32 The Billing Category value associated with the original activity transaction for this invoice.
HDT-MATRIX-CAT-3 Element: Matrix Cat	Alpha 12 The Billing Category name associated with the original activity transaction for this invoice.
HDT-MX-VALUE-3 Element: Mx Value	Alpha 32 The Billing Category value associated with the original activity transaction for this invoice.
HDT-EXCEED-AMT Element: Intl Amt	Signed 18.2 The amount of the detail invoice amoun that exceeds a ceiling. The ceilings are maintained in Contract Detail (BR102) Activity Billing (BR00.1) or Billing Detail (BR00.2) or Ceiling Levels (BR00.3).
HDT-EXCEED-UNIT Element: Exceed Unit	Signed 15.2 The unit amount related to the exceed amount that is over the ceiling.
HDT-BILL-ACTIVITY Element: Bill Activity	Alpha 15 The billing activity assoicated with the posting activity on the original activity transaction.
HDT-CONTRACT Element: Contract	Alpha 15 The contract associated with the posting activity on the original activity transaction. The contract activity associated with the posting activity on the original transaction has a one to one relationship with the contract.
HDT-RETENTION-AMT Element: Intl Amt	Signed 18.2 The retention amount based on the Retention Percent maintained in Bill Retention (BR01.2)
HDT-LEVEL Element: Level	Numeric 1 Stores the level at which the exceeded amount or unit is recaptured. The billing level maintained on the Bill Parameter (BR00). The valid values are: 1=Billx 2=Resource Billx 3=Bill 4=Resource Bill 5=Contract Billx 6=Resource Contract Billx 7=Contract Bill 8=Resource Contract Bill 9=Contract 1 = Billx 2 = Resource Billx 3 = Bill 4 = Resource Bill 5 = Contract Billx 6 = Resource Contract Billx 7 = Contract Bill 8 = Resource Contract Bill 9 = Contract
HDT-REASON-CODE Element: Reason Code	Alpha 4 The reason code indicating the cause of an invoice adjustment.
HDT-REVENUE-AMT Element: Intl Amt	Signed 18.2 The revenue amount assoicated with the original activity transaction. Field will only be populated when using transaction based revenue methods (i.e. Full Accrual or Cost Plus Full Accrual).
HDT-ADJ-LEVEL Element: Adj Level	Alpha 1 Indicates the invoice edit(BR20) level of the adjustment. The valid values are: I=Invoice D=Invoice Detail T=Transaction Detail P=Posting Activity A=Posting Activity Acct Cat I = Invoice Level D = Invoice Detail Level T = Transaction Detail Level P = Posting Activity Level A = Posting Activity Acct Cat
HDT-LINE-NBR-MAP Element: Line Nbr Map	Numeric 6 Indicates the detail line number that is associated with the adjustment line.
HDT-ADJUST-AMT Element: Intl Amt	Signed 18.2 The Adjustment amount is the prorated revenue amount
HDT-LINE-TYPE Element: Line Type	Alpha 1 This field contains the line type. The valid 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 A = Transaction B = Milestone C = Tax F = Fee G = Retention on Fee H = Overage on 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
HDT-TAXABLE-AMT Element: Intl Amt	Signed 18.2 The taxable amount.
HDT-SERVICE-LOC Element: Service Loc	Numeric 4 The service location used for the tax calculation.
HDT-BACKED-OUT-FL Element: Backed Out Fl	Alpha 1 Y = Yes N = No
HDT-FEE-CD Element: Fee Cd	Alpha 5 The Fee Code maintained in Assignment for Billing (BR15.2) associated with the contract.
HDT-RETAIN-CODE Element: Retain Code	Alpha 3 The Retainer Code maintained in Retainer Detail (BR02.2). Only populated when applying specific type retainers.
HDT-RETAIN-ID Element: Retain Id	Numeric 6 The retainer sequence maintained in the Retainer Parameters (BR02).
HDT-RETAINER-AMT Element: Intl Amt	Signed 18.2 The invoice amount associated with a retainer invoice type.
HDT-SUM-ACCT-CAT Element: Sum Acct Cat	Alpha 5 The name of the summary account category that is assoicated with the detail account category.
HDT-ADJUST-TYPE Element: Adjust Type	Alpha 1 The category of adjustment related to this invoice detail line. The values are: A=Write up or Down B=Hold C=Bill in Advance D=Transfer A = Write Up or Down B = Hold C = Bill in Advance D = Transfer
HDT-ORIG-INVC-AMT Element: Intl Amt	Signed 18.2 The original invoice amount from the original activity transactions billable amount. Will not be populated on the write up or write down adjustment lines. Used to display the original billable amount on the detail lines in the Invoice Edit (BR20).
HDT-TRANSFER-AMT Element: Intl Amt	Signed 18.2 The transfer amount or billable amount being transferred in Transfer Invoice Transaction (BR40.6). Stored in Contract Currency. Only populated when Adjust-Type equals D.
HDT-TRANSFER-UNITS Element: Adj Amt	Signed 18.2 The transfer units or billable units being transferred in Transfer Invoice Transaction (BR40.6). Only populated when Adjust-Type equals D.
HDT-CTR-CAT-GRP Element: Ctr Cat Grp	Alpha 5
HDT-XREF-HIH-OBJID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
HDT-XREF-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the line number.
HDT-GLT-OBJ-ID Element: Obj Id	Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
HDT-BILL-ADJ-AMT Element: Intl Amt	Signed 18.2
HDT-UNIT-ADJ-AMT Element: Units Amount	Signed 15.2
HDT-GRANT Element: Grant	Alpha 30
HDT-COST-CLASS Element: Alpha 15	Alpha 15
HDT-ELIGIBLE Element: Elig Flag	Alpha 1 Y = Yes N = No
HDT-MATCH-FUND Element: Grant	Alpha 30
HDT-ATN-BILL-AMT Element: Intl Amt	Signed 18.2

ACHISTDTL FILE INDEX

ACHISTDTL FILE RELATIONS

ONE TO ONE RELATIONS

ACHISTDTL FILE RELATIONS

ONE TO MANY RELATIONS

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