ACMNTSCH

REFERENCED BY
BR124 BR154 BR31.4


UPDATED BY
BR02.3 BR10.9 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR155 BR156 BR157
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR252
BR420 BR51.1 BR52.1 BR52.2 BR52.4 BR52.5
BR52.7 BR521 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSC-CONTRACT
Element: Contract		Alpha 15
Activity Management contract.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-MAINT-SCHEDULE
Element: Maint Schedule		Alpha 15
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PRODUCT
Element: Product		Alpha 15
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROD-VERSION
Element: Prod Version		Alpha 10
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-BEGIN-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
The begin date for this effort period.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
The end date for this effort period.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Pro Forma
2 = Accepted
3 = Invoiced
4 = Free Maintenance
5 = Invoice Cancelled
6 = Maint Cancelled
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR157
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR51.1 BR52.1
BR52.4 BR52.5
BR521 BRIP.1
MSC-EFFECTIVE-DT
Element: Effective Dt		Numeric 8 (yyyymmdd)
The effective date is the date the record is first valid.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-USERS
Element: Users		Numeric 12
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-LIST-NET-FLAG
Element: List Net Flag		Alpha 1

1 = List
2 = Net
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROD-LIST-AMT
Element: Intl Amt		Signed 18.2
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROD-NET-AMT
Element: Intl Amt		Signed 18.2
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROD-MAINT-AMT
Element: Intl Amt		Signed 18.2
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
BR52.1 BR52.4
BR52.5
MSC-PMH-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.
MSC-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
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-BILL-GL-CD
Element: Ac Gl Code		Alpha 4
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-BILL-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-UNBL-GL-CD
Element: Ac Gl Code		Alpha 4
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-REV-GL-CD
Element: Ac Gl Code		Alpha 4
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROD-USER-AMT
Element: Intl Amt		Signed 18.2
BR155 BR52.1
BR52.4 BR52.5
MSC-PROD-BASE-AMT
Element: Intl Amt		Signed 18.2
BR155 BR52.1
BR52.4 BR52.5
MSC-USER-FIELD1
Element: User Fld3		Alpha 15 (Lower Case)
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-USER-FIELD2
Element: User Fld3		Alpha 15 (Lower Case)
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-USER-FIELD3
Element: User Fld3		Alpha 15 (Lower Case)
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-PROFORMA-FL
Element: Flag1		Alpha 1

Y = Yes
N = No
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR52.1
BR52.4 BR52.5
BR521 BRIP.1
MSC-SITE-LOCATION
Element: Site Location		Numeric 2
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-REASON-CODE
Element: Reason Code		Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BR155 BR157
BR52.1 BR52.4
BR52.5
MSC-SUITE
Element: Prod Suite		Alpha 6
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-ORIG-CONTRACT
Element: Contract		Alpha 15
Activity Management contract.
BR155 BR51.1
BR52.1 BR52.4
BR52.5
MSC-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
BR155 BR51.1
BR52.1 BR52.4
BR52.5


ACMNTSCH FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSCSET1 CONTRACT
MAINT-SCHEDULE
OBJ-ID
BR02.3 BR10.9
BR120 BR121
BR122 BR123
BR124 BR140
BR151 BR152
BR154 BR155
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR31.4 BR420
BR51.1 BR52.1
BR52.2 BR52.3
BR52.4 BR52.5
BR52.7 BR521
BRIP.1
MSCSET2 CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
KeyChange
BR02.3 BR120
BR121 BR122
BR123 BR124
BR140 BR151
BR152 BR154
BR156 BR157
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR252
BR31.4 BR420
BR51.1 BR52.1
BR521
MSCSET3 PMH-OBJ-ID
CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
KeyChange


ACMNTSCH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
MSC-CONTRACT->CNT-CONTRACT (CNTSET1)
Accntract Orig ACCNTRACT Not Required
MSC-ORIG-CONTRACT->CNT-CONTRACT
Accntrpcd ACCNTRPCD Not Required
MSC-CONTRACT->CNP-CONTRACT
Acglcode Bill ACGLCODE Not Required
MSC-BILL-GL-CD->AGC-AC-GL-CODE
Acglcode Rev ACGLCODE Not Required
MSC-REV-GL-CD->AGC-AC-GL-CODE
Acglcode Unbl ACGLCODE Not Required
MSC-UNBL-GL-CD->AGC-AC-GL-CODE
Acmnthdr ACMNTHDR Required
MSC-CONTRACT->MSE-CONTRACT
MSC-MAINT-SCHEDULE->MSE-MAINT-SCHEDULE
Acpmhsthdr ACPMHSTHDR Not Required
MSC-PMH-OBJ-ID->PMH-OBJ-ID
Acproddtl ACPRODDTL Required
MSC-CONTRACT->AHD-CONTRACT
MSC-PRODUCT->AHD-PRODUCT
MSC-PROD-VERSION->AHD-PROD-VERSION
MSC-OBJ-ID->AHD-OBJ-ID
Acprodhdr ACPRODHDR Not Required
MSC-CONTRACT->AHR-CONTRACT
Acprodhdr Orig ACPRODHDR Not Required
MSC-ORIG-CONTRACT->AHR-CONTRACT
Acprodlstx ACPRODLSTX Required
MSE-PRODUCT-LIST->BRQ-PRODUCT-LIST
MSC-PRODUCT->BRQ-PRODUCT
MSC-PROD-VERSION->BRQ-PROD-VERSION
Acreasoncd ACREASONCD Not Required
MSC-REASON-CODE->CDE-REASON-CODE


ACMNTSCH FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntrcmtx ACCNTRCMTX
MSC-CONTRACT->CXM-CONTRACT
MSC-MAINT-SCHEDULE->CXM-MAINT-SCHEDULE
MSC-PRODUCT->CXM-PRODUCT
MSC-PROD-VERSION->CXM-PROD-VERSION
MSC-OBJ-ID->CXM-OBJ-ID
  CXM-COMMENT-TYPE
  CXM-DATE
  CXM-SEQ-NBR
Acmntschx ACMNTSCHX
MSC-CONTRACT->MSD-CONTRACT
MSC-MAINT-SCHEDULE->MSD-MAINT-SCHEDULE
MSC-PRODUCT->MSD-PRODUCT
MSC-PROD-VERSION->MSD-PROD-VERSION
MSC-OBJ-ID->MSD-OBJ-ID
  MSD-TRAN-DATE
Acprodtax ACPRODTAX
MSC-REV-ACCT-CAT->BTX-TAX-ACCT-CAT
MSC-DELIV-METHOD->BTX-DELIV-METHOD
  BTX-EFFECTIVE-DATE
Acproduser ACPRODUSER
MSE-PRODUCT-LIST->BRU-PRODUCT-LIST
MSC-PRODUCT->BRU-PRODUCT
MSC-PROD-VERSION->BRU-PROD-VERSION
MSC-EFFECTIVE-DT->BRU-EFFECTIVE-DT
  BRU-RECORD-TYPE
  BRU-MAX-USERS

File created: Thu Jun 09 11:10:57 2016

Home
Contact Us



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