ACHISTDTL

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.

REFERENCED BY
BR131 BR400 BR580 AC300


UPDATED BY
AC10.1 BR02.3 BR120 BR121 BR122 BR123
BR140 BR145 BR151 BR152 BR156 BR16.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR21.1
BR245 BR300 BR420 BR45.1 BR46.1 BR46.2
BR46.4 BR49.1 BR521 BRIP.1 TX101

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.
BR46.1 BR46.2
BR46.4 BRIP.1
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-CNSL-LINE-NBR
Element: Line Nbr
Numeric 6
The number that maps the ACHISTCNSL file line number to this record.
BRIP.1
HDT-PT-ACTIVITY
Element: Activity
Alpha 15
The posting activity associated with the original activity transaction being billed on this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category associated with the original activity transaction being billed on this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-TRAN-DATE
Element: Tran Date
Numeric 8 (yyyymmdd)
The transaction date associated with the original activity transaction being billed on this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description associated with the original activity transaction being billed on this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-RESOURCE-COMP
Element: Company
Numeric 4
The resource company or from company on the original activity transaction.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-RESOURCE-CODE
Element: Resource Code
Alpha 10
The resource code associated with the original activity transacton being billed on this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
The description of the resource code maintained in Resource (AC03).
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR46.1 BR46.2
BR46.4 BRIP.1
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.
BR46.2 BR46.4
BRIP.1
HDT-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
The billable units amount associated with the original activity transaction.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-UNIT-MEASURE
Element: Unit Measure
Alpha 12
The unit of measure associated with the original activity transaction.
BR46.1 BR46.2
BR46.4 BRIP.1
HDT-MILESTONE
Element: Milestone
Alpha 3
The milestone code maintained in Milestone (BR05). Only populated when the billing method is Milestone.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-TAX-CODE
Element: Tax Code
Alpha 10
The code representing specific tax information. Must be a valid Tax Code.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR46.1 BR46.2
BR46.4 BR521
BRIP.1
HDT-TAX-AMT
Element: Intl Amt
Signed 18.2
The tax amount calculated for the invoice line.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-POST-COMPANY
Element: Company
Numeric 4
The company used for posting transactions to the General Ledger.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-ATN-OBJ-ID
Element: Obj Id
Numeric 12
The system-defined object id representing the original activity transaction.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-MATRIX-CAT-1
Element: Matrix Cat
Alpha 12
The Billing Category name associated with the original activity transaction for this invoice.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-MX-VALUE-1
Element: Mx Value 1
Alpha 32
The Billing Category value associated with the original activity transaction.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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).
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-EXCEED-UNIT
Element: Exceed Unit
Signed 15.2
The unit amount related to the exceed amount that is over the ceiling.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-BILL-ACTIVITY
Element: Bill Activity
Alpha 15
The billing activity assoicated with the posting activity on the original activity transaction.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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.
BR46.1 BR46.2
BR46.4 BRIP.1
HDT-RETENTION-AMT
Element: Intl Amt
Signed 18.2
The retention amount based on the Retention Percent maintained in Bill Retention (BR01.2)
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-REASON-CODE
Element: Reason Code
Alpha 4
The reason code indicating the cause of an invoice adjustment.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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).
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-LINE-NBR-MAP
Element: Line Nbr Map
Numeric 6
Indicates the detail line number that is associated with the adjustment line.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-ADJUST-AMT
Element: Intl Amt
Signed 18.2
The Adjustment amount is the prorated revenue amount
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR46.1 BR46.2
BR46.4 BRIP.1
HDT-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
The taxable amount.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-SERVICE-LOC
Element: Service Loc
Numeric 4
The service location used for the tax calculation.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-BACKED-OUT-FL
Element: Backed Out Fl
Alpha 1

Y = Yes
N = No
BR140 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-FEE-CD
Element: Fee Cd
Alpha 5
The Fee Code maintained in Assignment for Billing (BR15.2) associated with the contract.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-RETAIN-CODE
Element: Retain Code
Alpha 3
The Retainer Code maintained in Retainer Detail (BR02.2). Only populated when applying specific type retainers.
BR46.2 BR46.4
BRIP.1
HDT-RETAIN-ID
Element: Retain Id
Numeric 6
The retainer sequence maintained in the Retainer Parameters (BR02).
BRIP.1
HDT-RETAINER-AMT
Element: Intl Amt
Signed 18.2
The invoice amount associated with a retainer invoice type.
BR46.2 BR46.4
BRIP.1
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
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).
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
HDT-CTR-CAT-GRP
Element: Ctr Cat Grp
Alpha 5
BR46.1 BR46.2
BR46.4 BRIP.1
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.
BRIP.1
HDT-XREF-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
BRIP.1
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.
BRIP.1
HDT-BILL-ADJ-AMT
Element: Intl Amt
Signed 18.2
BR02.3 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BRIP.1
HDT-UNIT-ADJ-AMT
Element: Units Amount
Signed 15.2
BR02.3 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BRIP.1
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDTSET1 OBJ-ID
LINE-NBR
BR02.3 BR120
BR121 BR122
BR123 BR140
BR145 BR151
BR152 BR156
BR16.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR20.6 BR21.1
BR245 BR420
BR45.1 BR46.1
BR46.2 BR46.4
BR49.1 BR521
BRIP.1 TX101
HDTSET2 CONTRACT
OBJ-ID
LINE-NBR
KeyChange
AC10.1 AC300
BR02.3 BR120
BR121 BR122
BR123 BR131
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521 BR580
HDTSET3 ATN-OBJ-ID
CONTRACT
OBJ-ID
LINE-NBR
KeyChange
HDTSET4 OBJ-ID
TRAN-DATE*
LINE-NBR
KeyChange
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
HDTSET5 OBJ-ID
CNSL-LINE-NBR
LINE-NBR
KeyChange
BRIP.1
HDTSET6 OBJ-ID
CONTRACT
LINE-NBR
KeyChange
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR21.1
BR300 BR400
BR420 BR49.1
BR521
HDTSET7 OBJ-ID
PT-ACTIVITY
ACCT-CATEGORY
LINE-NBR
KeyChange
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
HDTSET8 GLT-OBJ-ID
OBJ-ID
LINE-NBR
KeyChange
HDTSET9 OBJ-ID
LINE-NBR*
LINE-TYPE
KeyChange
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4


ACHISTDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
HDT-CONTRACT->CNT-CONTRACT
Achistcnsl ACHISTCNSL Required
HDT-OBJ-ID->IHC-OBJ-ID
HDT-CNSL-LINE-NBR->IHC-LINE-NBR
Achisthdr ACHISTHDR Required
HDT-OBJ-ID->HIH-OBJ-ID
Acreasoncd ACREASONCD Required
HDT-REASON-CODE->CDE-REASON-CODE
Actrans ACTRANS Required
HDT-ATN-OBJ-ID->ATN-OBJ-ID
Gltrans GLTRANS Not Required
HDT-GLT-OBJ-ID->GLT-OBJ-ID


ACHISTDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisttax ACHISTTAX
HDT-OBJ-ID->HIT-OBJ-ID
HDT-LINE-NBR->HIT-HDT-LINE-NBR
  HIT-SEQ-NBR
Acinvaudit ACINVAUDIT
HDT-OBJ-ID->IVA-OBJ-ID
HDT-LINE-NBR->IVA-LINE-NBR
  IVA-TRANS-DATE
  IVA-SEQUENCE-NBR


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

Home
Contact Us



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