|
|
ACPRODHDR FILE
REFERENCED BY
BR02.3 BR10.9 BR120 BR121 BR122 BR123
BR124 BR140 BR151 BR152 BR156 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR251 BR253
BR30.1 BR31.1 BR31.2 BR31.4 BR420 BR50.3
BR52.4 BR521 BR54.1 BR54.2 BR54.3 BR54.4
BR70.1 BRIP.1
UPDATED BY
BR153 BR51.1 BR51.2 BR53.1 BR53.2 BR570
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AHR-CONTRACT Alpha 15 BR51.1 BR570
Element: Contract Activity Management contract.
AHR-CONT-STATUS Alpha 2 BR51.1 BR570
Element: Cont Status
AHR-PRODUCT-LIST Alpha 10 BR51.1 BR570
Element: Product List
AHR-DISCOUNT-PCT Signed 8.5 BR51.1 BR570
Element: Discount Pct
AHR-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.
AHR-LIST-NET-FLAG Alpha 1 BR51.1 BR570
Element: List Net Flag 1 = List
2 = Net
AHR-MAINT-PERIOD Numeric 2
Element: Period This is the current accounting period.
This field is updated by Period Closing
(GL199).
AHR-DEFERRED-FL Alpha 1 BR153 BR51.1
Element: Deferred Fl Y = Yes BR570
N = No
AHR-REASON-CODE Alpha 4 BR51.1 BR570
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
AHR-MAINT-SCHEDULE Alpha 15 BR51.1 BR570
Element: Maint Schedule
AHR-DESCRIPTION Alpha 30 (Lower Case) BR51.1 BR570
Element: Description This field displays the description.
AHR-STATUS Numeric 1 BR51.1 BR51.2
Element: Status This field displays the status of the BR570
transaction.
0 = Unreleased
1 = Released
AHR-ACTIVITY Alpha 15 BR51.1 BR570
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AHR-CONT-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Date This field displays the system date
when this was created.
AHR-BEGIN-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: Begin Date The begin date for this effort period.
AHR-END-DATE Numeric 8 (yyyymmdd) BR51.1 BR570
Element: End Date The end date for this effort period.
AHR-LIST-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHR-NET-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHR-FREE-MAINT Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHR-DEFERRED-AMT Signed 18.2 BR53.1 BR53.2
Element: Intl Amt BR570
AHR-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.
AHR-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.
AHR-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.
AHR-DFLT-COMPANY Numeric 4 BR51.1 BR570
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
AHR-DFLT-ACCT-UNIT Alpha 15 BR51.1 BR570
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
AHR-BILL-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
AHR-BILL-GL-CD Alpha 4 BR51.1 BR570
Element: Ac Gl Code
AHR-BILL-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.
AHR-BILL-SUB-ACCT Numeric 4 BR51.1 BR570
Element: Sub Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AHR-UNBL-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
AHR-UNBL-GL-CD Alpha 4 BR51.1 BR570
Element: Ac Gl Code
AHR-UNBL-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.
AHR-UNBL-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.
AHR-SERVICE-LOC Numeric 4 BR51.1 BR570
Element: Service Loc A user defined code identifying a
customer's service location.
AHR-CUST-NAME Derived
Element: Cust Name
AHR-NET-PROD-REV Derived
Element: Net Prod Rev
AHR-ACTUAL-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
AHR-INV-NET-PRICE Signed 18.2 BR51.1 BR570
Element: Intl Amt
ACPRODHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AHRSET1 CONTRACT BR02.3 BR10.9
BR120 BR121
BR122 BR123
BR124 BR140
BR151 BR152
BR153 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR251
BR253 BR30.1
BR31.1 BR31.2
BR31.4 BR420
BR50.3 BR51.1
BR51.2 BR52.4
BR521 BR53.1
...
ACPRODHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
AHR-ACTIVITY -> ACV-ACTIVITY
Accntract ACCNTRACT Required
AHR-CONTRACT -> CNT-CONTRACT
Accntrstat ACCNTRSTAT Not Required
AHR-CONT-STATUS -> CSB-CONT-STATUS
Acglcode Bill ACGLCODE Not Required
AHR-BILL-GL-CD -> AGC-AC-GL-CODE
Acglcode Unbl ACGLCODE Not Required
AHR-UNBL-GL-CD -> AGC-AC-GL-CODE
Acprodlst ACPRODLST Required
AHR-PRODUCT-LIST -> BRP-PRODUCT-LIST
Acreasoncd ACREASONCD Not Required
AHR-REASON-CODE -> CDE-REASON-CODE
Acsrvcloc ACSRVCLOC Not Required
CNT-COMPANY -> ASV-COMPANY
CNT-CUSTOMER -> ASV-CUSTOMER
AHR-SERVICE-LOC -> ASV-SERVICE-LOC
Arcomp ARCOMP Required
CNT-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
CNT-CUSTOMER -> CUD-CUSTOMER
ACPRODHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
AHR-CONTRACT -> CXM-CONTRACT
Spaces -> CXM-MAINT-SCHEDULE
Spaces -> CXM-PRODUCT
Spaces -> CXM-PROD-VERSION
CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
Acprmstn ACPRMSTN
CNT-ACTIVITY -> PMS-ACTIVITY
PMS-MILESTONE-CAT
Acprmstnx ACPRMSTNX
CNT-ACTIVITY -> PMX-ACTIVITY
PMX-MILESTONE-CAT
PMX-MILESTONE
Acproddtl ACPRODDTL
AHR-CONTRACT -> AHD-CONTRACT
AHD-PRODUCT
AHD-PROD-VERSION
AHD-OBJ-ID
|
