|
|
ACHISTDTL FILE
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
BR02.3 BR120 BR121 BR122 BR123 BR145
BR151 BR152 BR156 BR16.1 BR21.1 BR245
BR420 BR45.1 BR521 TX101 AC10.1 AC300
AC310 BR580 BR400
UPDATED BY
BR131 BR140 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR300 BR46.1 BR46.2 BR46.4 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HDT-OBJ-ID Numeric 12 BR46.1 BR46.2
Element: Obj Id The object identifier is a number used BR46.4 BRIP.1
to relate the invoice detail records to
the invoice header. The object type is
INVID in the OBJID file.
HDT-LINE-NBR Numeric 6 BR20.1 BR20.2
Element: Line Nbr The line number associated with the BR20.3 BR20.4
invoice detail record. It, in BR20.5 BR46.1
combination with the OBJ-ID field, keeps BR46.2 BR46.4
the ACHISTDTL record unique. BRIP.1
HDT-CNSL-LINE-NBR Numeric 6 BRIP.1
Element: Line Nbr The number that maps the ACHISTCNSL
file line number to this record.
HDT-PT-ACTIVITY Alpha 15 BR20.1 BR20.2
Element: Activity The posting activity associated with BR20.3 BR20.4
the original activity transaction being BR20.5 BR46.1
billed on this invoice. BR46.2 BR46.4
BRIP.1
HDT-ACCT-CATEGORY Alpha 5 BR20.1 BR20.2
Element: Acct Category The account category associated with BR20.3 BR20.4
the original activity transaction being BR20.5 BR46.1
billed on this invoice. BR46.2 BR46.4
BRIP.1
HDT-BILLING-METHOD Numeric 1 BR20.1 BR20.2
Element: Billing MethodThe billing method maintained for the BR20.3 BR20.4
activity associated with the invoice BR20.5 BR46.1
transaction in the Activity Billing BR46.2 BR46.4
(BR00) or Billing Detail (BR00.2) BRIP.1
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 Numeric 8 (yyyymmdd) BR20.1 BR20.2
Element: Tran Date The transaction date associated with BR20.3 BR20.4
the original activity transaction being BR20.5 BR46.1
billed on this invoice. BR46.2 BR46.4
BRIP.1
HDT-DESCRIPTION Alpha 30 (Lower Case) BR20.1 BR20.2
Element: Description The description associated with the BR20.3 BR20.4
original activity transaction being BR20.5 BR46.1
billed on this invoice. BR46.2 BR46.4
BRIP.1
HDT-RESOURCE-TYPE Alpha 1 BR20.1 BR20.2
Element: Resource Type The type of resource associated with BR20.3 BR20.4
the original activity transaction. The BR20.5 BR46.1
valid values are: BR46.2 BR46.4
P=AC Person BRIP.1
Q=Equipment
E=Employee
V=Vendor
Q = Equipment
P = Person
HDT-RESOURCE-COMP Numeric 4 BR46.1 BR46.2
Element: Company The resource company or from company on BR46.4 BRIP.1
the original activity transaction.
HDT-RESOURCE-CODE Alpha 10 BR20.1 BR20.2
Element: Resource Code The resource code associated with the BR20.3 BR20.4
original activity transacton being BR20.5 BR46.1
billed on this invoice. BR46.2 BR46.4
BRIP.1
HDT-RESOURCE-DESC Alpha 30 (Lower Case) BR20.1 BR20.2
Element: Description The description of the resource code BR20.3 BR20.4
maintained in Resource (AC03). BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-BILL-RATE Signed 13.4 BR46.1 BR46.2
Element: Bill Rate The billing rate that is associated BR46.4 BRIP.1
with the original activity transaction
being billed on this invoice. Only
populated when the billing method is
Time and Materials.
HDT-MARK-UP-PCT Signed 5.2 BR46.2 BR46.4
Element: Mark Up Pct The percentage of markup for billing BRIP.1
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 Signed 15.2 BR20.1 BR20.2
Element: Units Amount The billable units amount associated BR20.3 BR20.4
with the original activity transaction. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-UNIT-MEASURE Alpha 12 BR46.1 BR46.2
Element: Unit Measure The unit of measure associated with the BR46.4 BRIP.1
original activity transaction.
HDT-MILESTONE Alpha 3 BR20.1 BR20.2
Element: Milestone The milestone code maintained in BR20.3 BR20.4
Milestone (BR05). Only populated when BR20.5 BR46.1
the billing method is Milestone. BR46.2 BR46.4
BRIP.1
HDT-PERC-COMPLETE Signed 7.3
Element: Perc Complete The percentage of completion associated
with the percent complete milestone
maintained in Percent Complete
Milestones (BR05).
HDT-TAX-EXEMPT-CD Alpha 1 BR20.1 BR20.2
Element: Tax Exempt Cd The code indicating the taxing status. BR20.3 BR20.4
The valid values are: BR20.5 BR46.1
E=Exempt BR46.2 BR46.4
T=Taxable BRIP.1
E = Exempt
T = Taxable
HDT-TAX-CODE Alpha 10 BR20.1 BR20.2
Element: Tax Code The code representing specific tax BR20.3 BR20.4
information. Must be a valid Tax Code. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-INVC-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The invoice amount. Any billing BR20.3 BR20.4
adjustments made to the invoice line BR20.5 BR46.1
will be included in this line. BR46.2 BR46.4
BRIP.1
HDT-TAX-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The tax amount calculated for the BR20.3 BR20.4
invoice line. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-POST-COMPANY Numeric 4 BR20.1 BR20.2
Element: Company The company used for posting BR20.3 BR20.4
transactions to the General Ledger. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-ACCT-UNIT Alpha 15 BR20.1 BR20.2
Element: Acct Unit The accounting unit used in the BR20.3 BR20.4
transaction that is posted to General BR20.5 BR46.1
Ledger. This field along with the BR46.2 BR46.4
account and subaccount make up the BRIP.1
location (account) where the amount and
other account information is stored.
HDT-ACCOUNT Numeric 6 BR46.1 BR46.2
Element: Account The Account used in the transaction BR46.4 BRIP.1
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 Numeric 4 BR46.1 BR46.2
Element: Sub Acct The subaccount used in the transaction BR46.4 BRIP.1
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 Numeric 12 BR20.1 BR20.2
Element: Obj Id The system-defined object id BR20.3 BR20.4
representing the original activity BR20.5 BR46.1
transaction. BR46.2 BR46.4
BRIP.1
HDT-MATRIX-CAT-1 Alpha 12 BR20.1 BR20.2
Element: Matrix Cat The Billing Category name associated BR20.3 BR20.4
with the original activity transaction BR20.5 BR46.1
for this invoice. BR46.2 BR46.4
BRIP.1
HDT-MX-VALUE-1 Alpha 32 BR20.1 BR20.2
Element: Mx Value 1 The Billing Category value associated BR20.3 BR20.4
with the original activity transaction. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-MATRIX-CAT-2 Alpha 12
Element: Matrix Cat The Billing Category name associated
with the original activity transaction
for this invoice.
HDT-MX-VALUE-2 Alpha 32
Element: Mx Value 2 The Billing Category value associated
with the original activity transaction
for this invoice.
HDT-MATRIX-CAT-3 Alpha 12
Element: Matrix Cat The Billing Category name associated
with the original activity transaction
for this invoice.
HDT-MX-VALUE-3 Alpha 32
Element: Mx Value The Billing Category value associated
with the original activity transaction
for this invoice.
HDT-EXCEED-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The amount of the detail invoice amoun BR20.3 BR20.4
that exceeds a ceiling. The ceilings are BR20.5 BR46.1
maintained in Contract Detail (BR102) BR46.2 BR46.4
Activity Billing (BR00.1) or Billing BRIP.1
Detail (BR00.2) or Ceiling Levels
(BR00.3).
HDT-EXCEED-UNIT Signed 15.2 BR20.1 BR20.2
Element: Exceed Unit The unit amount related to the exceed BR20.3 BR20.4
amount that is over the ceiling. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-BILL-ACTIVITY Alpha 15 BR20.1 BR20.2
Element: Bill Activity The billing activity assoicated with BR20.3 BR20.4
the posting activity on the original BR20.5 BR46.1
activity transaction. BR46.2 BR46.4
BRIP.1
HDT-CONTRACT Alpha 15 BR46.1 BR46.2
Element: Contract The contract associated with the BR46.4 BRIP.1
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 Signed 18.2 BR46.2 BR46.4
Element: Intl Amt The retention amount based on the BRIP.1
Retention Percent maintained in Bill
Retention (BR01.2)
HDT-LEVEL Numeric 1 BR20.1 BR20.2
Element: Level Stores the level at which the exceeded BR20.3 BR20.4
amount or unit is recaptured. BR20.5 BR46.1
The billing level maintained on the Bill BR46.2 BR46.4
Parameter (BR00). BRIP.1
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 Alpha 4 BR20.1 BR20.2
Element: Reason Code The reason code indicating the cause of BR20.3 BR20.4
an invoice adjustment. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-REVENUE-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The revenue amount assoicated with the BR20.3 BR20.4
original activity transaction. Field BR20.5 BR46.1
will only be populated when using BR46.2 BR46.4
transaction based revenue methods (i.e. BRIP.1
Full Accrual or Cost Plus Full Accrual).
HDT-ADJ-LEVEL Alpha 1 BR20.1 BR20.2
Element: Adj Level Indicates the invoice edit(BR20) level BR20.3 BR20.4
of the adjustment. BR20.5 BR46.1
The valid values are: BR46.2 BR46.4
I=Invoice BRIP.1
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 Numeric 6 BR20.1 BR20.2
Element: Line Nbr Map Indicates the detail line number that is BR20.3 BR20.4
associated with the adjustment line. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-ADJUST-AMT Signed 18.2 BR131 BR20.1
Element: Intl Amt The Adjustment amount is the prorated BR20.2 BR20.3
revenue amount BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 BRIP.1
HDT-LINE-TYPE Alpha 1 BR46.1 BR46.2
Element: Line Type This field contains the line type. BR46.4 BRIP.1
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 Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The taxable amount. BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-SERVICE-LOC Numeric 4 BR20.1 BR20.2
Element: Service Loc The service location used for the tax BR20.3 BR20.4
calculation. BR20.5 BR46.1
BR46.2 BR46.4
BRIP.1
HDT-BACKED-OUT-FL Alpha 1 BR140 BR46.1
Element: Backed Out Fl Y = Yes BR46.2 BR46.4
N = No BRIP.1
HDT-FEE-CD Alpha 5 BR20.1 BR20.2
Element: Fee Cd The Fee Code maintained in Assignment BR20.3 BR20.4
for Billing (BR15.2) associated with the BR20.5 BR46.1
contract. BR46.2 BR46.4
BRIP.1
HDT-RETAIN-CODE Alpha 3 BR46.2 BR46.4
Element: Retain Code The Retainer Code maintained in Retainer BRIP.1
Detail (BR02.2). Only populated when
applying specific type retainers.
HDT-RETAIN-ID Numeric 6 BRIP.1
Element: Retain Id The retainer sequence maintained in the
Retainer Parameters (BR02).
HDT-RETAINER-AMT Signed 18.2 BR46.2 BR46.4
Element: Intl Amt The invoice amount associated with a BRIP.1
retainer invoice type.
HDT-SUM-ACCT-CAT Alpha 5 BR20.1 BR20.2
Element: Sum Acct Cat The name of the summary account BR20.3 BR20.4
category that is assoicated with the BR20.5 BR46.1
detail account category. BR46.2 BR46.4
BRIP.1
HDT-ADJUST-TYPE Alpha 1 BR20.1 BR20.2
Element: Adjust Type The category of adjustment related to BR20.3 BR20.4
this invoice detail line. BR20.5 BR46.1
The values are: BR46.2 BR46.4
A=Write up or Down BRIP.1
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 Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The original invoice amount from the BR20.3 BR20.4
original activity transactions billable BR20.5 BR46.1
amount. Will not be populated on the BR46.2 BR46.4
write up or write down adjustment lines. BRIP.1
Used to display the original billable
amount on the detail lines in the
Invoice Edit (BR20).
HDT-TRANSFER-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt The transfer amount or billable amount BR20.3 BR20.4
being transferred in Transfer Invoice BR20.5 BR46.1
Transaction (BR40.6). Stored in BR46.2 BR46.4
Contract Currency. Only populated when
Adjust-Type equals D.
HDT-TRANSFER-UNITS Signed 18.2 BR20.1 BR20.2
Element: Adj Amt The transfer units or billable units BR20.3 BR20.4
being transferred in Transfer Invoice BR20.5 BR46.1
Transaction (BR40.6). Only populated BR46.2 BR46.4
when Adjust-Type equals D.
HDT-CTR-CAT-GRP Alpha 5 BR46.1 BR46.2
Element: Ctr Cat Grp BR46.4 BRIP.1
HDT-XREF-HIH-OBJID Numeric 12 BRIP.1
Element: Obj Id 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 Numeric 6 BRIP.1
Element: Line Nbr This field contains the line number.
HDT-GLT-OBJ-ID Numeric 12 BRIP.1
Element: Obj Id 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 Signed 18.2
Element: Intl Amt
ACHISTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDTSET1 OBJ-ID BR02.3 BR120
LINE-NBR BR121 BR122
BR123 BR131
BR140 BR145
BR151 BR152
BR156 BR16.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR21.1
BR245 BR420
BR45.1 BR46.1
BR46.2 BR46.4
BR521 BRIP.1
TX101
HDTSET2 CONTRACT KeyChange AC10.1 AC300
OBJ-ID AC310 BR122
LINE-NBR BR131 BR140
BR580
HDTSET3 ATN-OBJ-ID KeyChange
CONTRACT
OBJ-ID
LINE-NBR
HDTSET4 OBJ-ID KeyChange BR20.1 BR20.2
TRAN-DATE* BR20.3 BR20.4
LINE-NBR BR20.5 BR46.1
BR46.2 BR46.4
HDTSET5 OBJ-ID KeyChange BRIP.1
CNSL-LINE-NBR
LINE-NBR
HDTSET6 OBJ-ID KeyChange BR120 BR121
CONTRACT BR122 BR123
LINE-NBR BR131 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR21.1 BR300
BR400 BR420
BR521
HDTSET7 OBJ-ID KeyChange BR20.1 BR20.2
PT-ACTIVITY BR20.3 BR20.4
ACCT-CATEGORY BR20.5 BR46.1
LINE-NBR BR46.2 BR46.4
HDTSET8 GLT-OBJ-ID KeyChange
OBJ-ID
LINE-NBR
HDTSET9 OBJ-ID KeyChange BR20.1 BR20.2
LINE-NBR* BR20.3 BR20.4
LINE-TYPE BR20.5 BR46.1
BR46.2 BR46.4
ACHISTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
