|
|
ACPRODDTL FILE
REFERENCED BY
BR02.3 BR10.9 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR156 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR31.2 BR420 BR52.4
BR521 BR54.2 BR54.3 BR54.4 BRIP.1 BR251
BR253
UPDATED BY
BR153 BR51.1 BR51.2 BR53.1 BR53.2 BR570
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AHD-CONTRACT Alpha 15 BR51.1 BR570
Element: Contract Activity Management contract.
AHD-OBJ-ID Numeric 12 BR51.1 BR570
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.
AHD-PRODUCT Alpha 15 BR51.1 BR570
Element: Product
AHD-PROD-VERSION Alpha 10 BR51.1 BR570
Element: Prod Version
AHD-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Effective Dt The effective date is the date the
record is first valid.
AHD-USERS Numeric 12 BR51.1 BR570
Element: Users
AHD-LIST-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHD-DISCOUNT-AMT Signed 18.2 BR51.1
Element: Intl Amt
AHD-NET-PRICE Signed 18.2 BR51.1
Element: Intl Amt
AHD-FREE-MAINT Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHD-SHIP-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Ship Date This field contains the ship date. If
left blank, the system date defaults.
AHD-ANT-SHIP-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Ship Date This field contains the ship date. If
left blank, the system date defaults.
AHD-DEFERRED-FL Alpha 1 BR153 BR51.1
Element: Deferred Fl Y = Yes BR570
N = No
X = Not Shipped
AHD-DEFERRED-AMT Signed 18.2 BR153 BR51.1
Element: Intl Amt BR53.1 BR53.2
BR570
AHD-REASON-CODE Alpha 4 BR51.1 BR570
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
AHD-TOT-REV-AMT Signed 18.2 BR153 BR570
Element: Intl Amt
AHD-DISCOUNT-PCT Signed 8.5 BR51.1 BR570
Element: Discount Pct
AHD-MAINT-PERCENT Signed 7.3 BR51.1 BR570
Element: Percent The percentage determines how much
retention is held. It can either be a
percentage of each invoice, or it can be
a percentage of a total.
AHD-LIST-NET-FLAG Alpha 1 BR51.1 BR570
Element: List Net Flag 1 = List
2 = Net
AHD-MAINT-PERIOD Numeric 2 BR570
Element: Period This is the current accounting period.
This field is updated by Period Closing
(GL199).
AHD-INCLUDE-BASE Alpha 1 BR51.1 BR570
Element: Include Base Y = Yes
N = No
AHD-REV-ACCT-CAT Alpha 5 BR51.1 BR570
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
AHD-REV-GL-CD Alpha 4 BR51.1 BR570
Element: Ac Gl Code
AHD-REV-ACCOUNT Numeric 6 BR51.1 BR570
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AHD-REV-SUB-ACCT Numeric 4 BR51.1 BR570
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AHD-COST-BASIS-FL Alpha 1 BR570
Element: List Net Flag
AHD-TOTAL-COST Signed 18.2 BR51.1 BR51.2
Element: Intl Amt BR570
AHD-PREV-EXP-AMT Signed 18.2 BR153 BR570
Element: Intl Amt
AHD-CGSL-ACCT-CAT Alpha 5 BR51.1 BR51.2
Element: Acct Category Account categories are groupings of BR570
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
AHD-CGSL-GL-CD Alpha 4 BR51.1 BR51.2
Element: Ac Gl Code BR570
AHD-CGSL-ACCOUNT Numeric 6 BR51.1 BR51.2
Element: Account This field along with the accounting BR570
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AHD-CGSL-SUB-ACCT Numeric 4 BR51.1 BR51.2
Element: Sub Acct This field contains the subaccount from BR570
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AHD-CGSX-ACCT-CAT Alpha 5 BR51.1 BR51.2
Element: Acct Category Account categories are groupings of BR570
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
AHD-CGSX-GL-CD Alpha 4 BR51.1 BR51.2
Element: Ac Gl Code BR570
AHD-CGSX-ACCOUNT Numeric 6 BR51.1 BR51.2
Element: Account This field along with the accounting BR570
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AHD-CGSX-SUB-ACCT Numeric 4 BR51.1 BR51.2
Element: Sub Acct This field contains the subaccount from BR570
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AHD-LAST-SEQ-NBR Numeric 6
Element: Last Seq Nbr Identifies the last sequence number
used. Ensures the record is unique.
AHD-TAX-EXEMPT-CD Alpha 1 BR570
Element: Tax Exempt Cd Code indicating the taxing status. E -
Exempt, T - Taxable.
AHD-OPERATOR Alpha 10 BR51.1 BR51.2
Element: Operator This field is used to store the login BR570
id of the person who entered the record.
AHD-DATE-STAMP Numeric 8 (yyyymmdd) BR51.1 BR51.2
Element: Date Stamp This field contains the server date BR570
(month, date, and year) of the last
change to this record.
AHD-TIME-STAMP Numeric 6 (hhmmss) BR51.1 BR51.2
Element: Time Stamp Contains the server time (hour, minute, BR570
and second) when the record was last
changed.
AHD-REVENUE-FLAG Alpha 1 BR153 BR51.1
Element: Revenue Flag This flag identifies whether an BR51.2 BR570
activity/account category is eligible
for revenue recognition.
AHD-USER-FIELD1 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Fld3 BR570
AHD-USER-FIELD2 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Fld3 BR570
AHD-USER-FIELD3 Alpha 15 (Lower Case) BR51.1 BR51.2
Element: User Fld3 BR570
AHD-SITE-LOCATION Numeric 2 BR51.1 BR51.2
Element: Site Location BR570
AHD-INV-NET-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHD-SUITE Alpha 6 BR51.1 BR570
Element: Prod Suite
AHD-ACTUAL-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHD-NET-PROD-REV Derived
Element: Net Prod Rev
AHD-END-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Date This field displays the system date
when this was created.
AHD-TOT-DEF-AMT Signed 18.2 BR51.1 BR53.1
Element: Intl Amt BR53.2 BR570
AHD-DELIV-METHOD Alpha 1 BR51.1 BR570
Element: Deliv Method S = Shipped
H = Hosted at
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
ACPRODDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AHDSET1 CONTRACT BR02.3 BR10.9
OBJ-ID BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR153
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR31.2 BR420
BR51.1 BR51.2
BR52.4 BR521
BR53.1 BR53.2
BR54.2 BR54.3
BR54.4 BR570
BRIP.1
AHDSET2 CONTRACT KeyChange BR153 BR251
PRODUCT BR253 BR31.2
PROD-VERSION BR51.1 BR51.2
OBJ-ID BR53.1 BR53.2
BR570
ACPRODDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
AHD-CONTRACT -> CNT-CONTRACT
Acglcode Cgsl ACGLCODE Not Required
AHD-CGSL-GL-CD -> AGC-AC-GL-CODE
Acglcode Cgsx ACGLCODE Not Required
AHD-CGSX-GL-CD -> AGC-AC-GL-CODE
Acglcode Rev ACGLCODE Not Required
AHD-REV-GL-CD -> AGC-AC-GL-CODE
Acprodhdr ACPRODHDR Required
AHD-CONTRACT -> AHR-CONTRACT
Acprodlstx ACPRODLSTX Required
AHR-PRODUCT-LIST -> BRQ-PRODUCT-LIST
AHD-PRODUCT -> BRQ-PRODUCT
AHD-PROD-VERSION -> BRQ-PROD-VERSION
Acreasoncd ACREASONCD Not Required
AHD-REASON-CODE -> CDE-REASON-CODE
ACPRODDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
AHD-CONTRACT -> CXM-CONTRACT
Spaces -> CXM-MAINT-SCHEDULE
AHD-PRODUCT -> CXM-PRODUCT
AHD-PROD-VERSION -> CXM-PROD-VERSION
AHD-OBJ-ID -> CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
Acdefrev ACDEFREV
AHD-CONTRACT -> DRD-CONTRACT
AHD-PRODUCT -> DRD-PRODUCT
AHD-PROD-VERSION -> DRD-PROD-VERSION
AHD-OBJ-ID -> DRD-OBJ-ID
DRD-SEQ-NBR
Acprodtax ACPRODTAX
AHD-REV-ACCT-CAT -> BTX-TAX-ACCT-CAT
AHD-DELIV-METHOD -> BTX-DELIV-METHOD
BTX-EFFECTIVE-DATE
Acproduser ACPRODUSER
AHR-PRODUCT-LIST -> BRU-PRODUCT-LIST
AHD-PRODUCT -> BRU-PRODUCT
AHD-PROD-VERSION -> BRU-PROD-VERSION
AHD-EFFECTIVE-DT -> BRU-EFFECTIVE-DT
BRU-RECORD-TYPE
BRU-MAX-USERS
|
