|
|
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 BR145 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
Object The object identifier is a number used BR46.4 BRIP.1
Identification 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 Number 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 Number 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: Account CategoThe 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: Transaction DaThe 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 with BR46.4 BRIP.1
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: Markup percentThe 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: Percent CompleThe 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 CodThe 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: Accounting UniThe 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: Subaccount 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
Object The system-defined object id BR20.3 BR20.4
Identification 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: Attribute 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: Attribute ValuThe 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: Attribute The Billing Category name associated
with the original activity transaction
for this invoice.
HDT-MX-VALUE-2 Alpha 32
Element: Attribute ValuThe Billing Category value associated
with the original activity transaction
for this invoice.
HDT-MATRIX-CAT-3 Alpha 12
Element: Attribute The Billing Category name associated
with the original activity transaction
for this invoice.
HDT-MX-VALUE-3 Alpha 32
Element: Attribute ValuThe 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 10 BR46.1 BR46.2
Element: Contract The contract associated with the posting BR46.4 BRIP.1
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
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 BR46.2 BR46.4
Element: Intl Amt 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 Signed 18.2 BR46.2 BR46.4
Element: Adj Amt 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 Alpha 5 BRIP.1
Element: Ctr Cat Grp
HDT-XREF-HIH-OBJID Numeric 12 BRIP.1
Object
Identification
HDT-XREF-LINE-NBR Numeric 6 BRIP.1
Element: Line Number
HDT-GLT-OBJ-ID Numeric 12 BRIP.1
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
ACHISTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HDTSET1 OBJ-ID BR02.3 BR120
LINE-NBR BR121 BR122
BR131 BR140
BR145 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 BR122 BR131
CONTRACT BR20.1 BR20.2
LINE-NBR BR20.3 BR20.4
BR20.5 BR300
BR400
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
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
|
