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
BR145 BR16.1 BR245 BR45.1 BRBD.2 TX101
AC10.1 AC300 BR400


UPDATED BY
BR140 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR300 BR46.1 BR46.2 BR46.4 BR49.1 BRIP.1
BR02.3 BR120 BR121 BR122 BR123 BR151
BR152 BR156 BR21.1 BR420 BR521 BR131
BR580

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
BRBD.2 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
BR121 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
Achstdtbod ACHSTDTBOD Not Required, Delete Cascades
HDT-OBJ-ID->YAL-OBJ-ID
HDT-LINE-NBR->YAL-LINE-NBR
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 02:11:04 2016

Home
Contact Us



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