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

ACPRODDTL FILE RELATIONS

ONE TO ONE RELATIONS

ACPRODDTL FILE RELATIONS

ONE TO MANY RELATIONS

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