ACPRODDTL

REFERENCED BY
BR253 BR31.2 BR54.2 BR54.3 BR54.4


UPDATED BY
BR02.3 BR10.9 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR153 BR156 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR251 BR420
BR51.1 BR51.2 BR52.4 BR521 BR53.1 BR53.2
BR570 BRIP.1

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 11:11:01 2016

Home
Contact Us



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