ACPRODDTL

Activity Product Detail

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
Element: Contract		Alpha 15
Activity Management contract.
BR51.1 BR570
AHD-OBJ-ID
Element: Obj Id		Numeric 12
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.
BR51.1 BR570
AHD-PRODUCT
Element: Product		Alpha 15
BR51.1 BR570
AHD-PROD-VERSION
Element: Prod Version		Alpha 10
BR51.1 BR570
AHD-EFFECTIVE-DT
Element: Effective Dt		Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
BR51.1 BR570
AHD-USERS
Element: Users		Numeric 12
BR51.1 BR570
AHD-LIST-PRICE
Element: Intl Amt		Signed 18.2
BR51.1 BR570
AHD-DISCOUNT-AMT
Element: Intl Amt		Signed 18.2
BR51.1
AHD-NET-PRICE
Element: Intl Amt		Signed 18.2
BR51.1
AHD-FREE-MAINT
Element: Intl Amt		Signed 18.2
BR51.1 BR570
AHD-SHIP-DATE
Element: Ship Date		Numeric 8 (yyyymmdd)
This field contains the ship date. If left blank, the system date defaults.
BR51.1 BR570
AHD-ANT-SHIP-DATE
Element: Ship Date		Numeric 8 (yyyymmdd)
This field contains the ship date. If left blank, the system date defaults.
BR51.1 BR570
AHD-DEFERRED-FL
Element: Deferred Fl		Alpha 1

Y = Yes
N = No
X = Not Shipped
BR153 BR51.1
BR570
AHD-DEFERRED-AMT
Element: Intl Amt		Signed 18.2
BR153 BR51.1
BR53.1 BR53.2
BR570
AHD-REASON-CODE
Element: Reason Code		Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BR51.1 BR570
AHD-TOT-REV-AMT
Element: Intl Amt		Signed 18.2
BR153 BR570
AHD-DISCOUNT-PCT
Element: Discount Pct		Signed 8.5
BR51.1 BR570
AHD-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
AHD-LIST-NET-FLAG
Element: List Net Flag		Alpha 1

1 = List
2 = Net
BR51.1 BR570
AHD-MAINT-PERIOD
Element: Period		Numeric 2
This is the current accounting period. This field is updated by Period Closing (GL199).
BR570
AHD-INCLUDE-BASE
Element: Include Base		Alpha 1

Y = Yes
N = No
BR51.1 BR570
AHD-REV-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
AHD-REV-GL-CD
Element: Ac Gl Code		Alpha 4
BR51.1 BR570
AHD-REV-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
AHD-REV-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
AHD-COST-BASIS-FL
Element: List Net Flag		Alpha 1
BR570
AHD-TOTAL-COST
Element: Intl Amt		Signed 18.2
BR51.1 BR51.2
BR570
AHD-PREV-EXP-AMT
Element: Intl Amt		Signed 18.2
BR153 BR570
AHD-CGSL-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 BR51.2
BR570
AHD-CGSL-GL-CD
Element: Ac Gl Code		Alpha 4
BR51.1 BR51.2
BR570
AHD-CGSL-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 BR51.2
BR570
AHD-CGSL-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 BR51.2
BR570
AHD-CGSX-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 BR51.2
BR570
AHD-CGSX-GL-CD
Element: Ac Gl Code		Alpha 4
BR51.1 BR51.2
BR570
AHD-CGSX-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 BR51.2
BR570
AHD-CGSX-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 BR51.2
BR570
AHD-LAST-SEQ-NBR
Element: Last Seq Nbr		Numeric 6
Identifies the last sequence number used. Ensures the record is unique.
AHD-TAX-EXEMPT-CD
Element: Tax Exempt Cd		Alpha 1
Code indicating the taxing status. E - Exempt, T - Taxable.
BR570
AHD-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
AHD-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
AHD-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
AHD-REVENUE-FLAG
Element: Revenue Flag		Alpha 1
This flag identifies whether an activity/account category is eligible for revenue recognition.
BR153 BR51.1
BR51.2 BR570
AHD-USER-FIELD1
Element: User Fld3		Alpha 15 (Lower Case)
BR51.1 BR51.2
BR570
AHD-USER-FIELD2
Element: User Fld3		Alpha 15 (Lower Case)
BR51.1 BR51.2
BR570
AHD-USER-FIELD3
Element: User Fld3		Alpha 15 (Lower Case)
BR51.1 BR51.2
BR570
AHD-SITE-LOCATION
Element: Site Location		Numeric 2
BR51.1 BR51.2
BR570
AHD-INV-NET-PRICE
Element: Intl Amt		Signed 18.2
BR51.1 BR570
AHD-SUITE
Element: Prod Suite		Alpha 6
BR51.1 BR570
AHD-ACTUAL-PRICE
Element: Intl Amt		Signed 18.2
BR51.1 BR570
AHD-NET-PROD-REV
Element: Net Prod Rev		Derived
AHD-END-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
BR51.1 BR570
AHD-TOT-DEF-AMT
Element: Intl Amt		Signed 18.2
BR51.1 BR53.1
BR53.2 BR570
AHD-DELIV-METHOD
Element: Deliv Method		Alpha 1

S = Shipped
H = Hosted at
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
BR51.1 BR570


ACPRODDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AHDSET1 CONTRACT
OBJ-ID
BR02.3 BR10.9
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
PRODUCT
PROD-VERSION
OBJ-ID
KeyChange
BR153 BR251
BR253 BR31.2
BR51.1 BR51.2
BR53.1 BR53.2
BR570


ACPRODDTL FILE RELATIONS


ONE TO ONE RELATIONS

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

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

Home
Contact Us



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