ACPRODHDR

Activity Product Header

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
Element: Contract
Alpha 15
Activity Management contract.
BR51.1 BR570
AHR-CONT-STATUS
Element: Cont Status
Alpha 2
BR51.1 BR570
AHR-PRODUCT-LIST
Element: Product List
Alpha 10
BR51.1 BR570
AHR-DISCOUNT-PCT
Element: Discount Pct
Signed 8.5
BR51.1 BR570
AHR-MAINT-PERCENT
Element: Percent
Signed 7.3
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.
BR51.1 BR570
AHR-LIST-NET-FLAG
Element: List Net Flag
Alpha 1

1 = List
2 = Net
BR51.1 BR570
AHR-MAINT-PERIOD
Element: Period
Numeric 2
This is the current accounting period. This field is updated by Period Closing (GL199).
AHR-DEFERRED-FL
Element: Deferred Fl
Alpha 1

Y = Yes
N = No
BR153 BR51.1
BR570
AHR-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BR51.1 BR570
AHR-MAINT-SCHEDULE
Element: Maint Schedule
Alpha 15
BR51.1 BR570
AHR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BR51.1 BR570
AHR-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
BR51.1 BR51.2
BR570
AHR-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BR51.1 BR570
AHR-CONT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR51.1 BR570
AHR-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The begin date for this effort period.
BR51.1 BR570
AHR-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
BR51.1 BR570
AHR-LIST-PRICE
Element: Intl Amt
Signed 18.2
BR51.1 BR570
AHR-NET-PRICE
Element: Intl Amt
Signed 18.2
BR51.1 BR570
AHR-FREE-MAINT
Element: Intl Amt
Signed 18.2
BR51.1 BR570
AHR-DEFERRED-AMT
Element: Intl Amt
Signed 18.2
BR53.1 BR53.2
BR570
AHR-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
BR51.1 BR51.2
BR570
AHR-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BR51.1 BR51.2
BR570
AHR-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BR51.1 BR51.2
BR570
AHR-DFLT-COMPANY
Element: Company
Numeric 4
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.
BR51.1 BR570
AHR-DFLT-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
BR51.1 BR570
AHR-BILL-ACCT-CAT
Element: Acct Category
Alpha 5
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
BR51.1 BR570
AHR-BILL-GL-CD
Element: Ac Gl Code
Alpha 4
BR51.1 BR570
AHR-BILL-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
BR51.1 BR570
AHR-BILL-SUB-ACCT
Element: Sub Account
Numeric 4
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
BR51.1 BR570
AHR-UNBL-ACCT-CAT
Element: Acct Category
Alpha 5
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
BR51.1 BR570
AHR-UNBL-GL-CD
Element: Ac Gl Code
Alpha 4
BR51.1 BR570
AHR-UNBL-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
BR51.1 BR570
AHR-UNBL-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
BR51.1 BR570
AHR-SERVICE-LOC
Element: Service Loc
Numeric 4
A user defined code identifying a customer's service location.
BR51.1 BR570
AHR-CUST-NAME
Element: Cust Name
Derived
AHR-NET-PROD-REV
Element: Net Prod Rev
Derived
AHR-ACTUAL-PRICE
Element: Intl Amt
Signed 18.2
BR51.1 BR570
AHR-INV-NET-PRICE
Element: Intl Amt
Signed 18.2
BR51.1 BR570


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
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:11:11 2016

Home
Contact Us



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