Activity Maintenance Schedule
REFERENCED BY
BR10.9 | BR31.4 | BR252 |
BR02.3 | BR120 | BR121 | BR122 | BR123 | BR140 |
BR151 | BR152 | BR155 | BR156 | BR157 | BR20.1 |
BR20.2 | BR20.3 | BR20.4 | BR20.5 | BR420 | BR51.1 |
BR52.1 | BR52.4 | BR52.5 | BR52.2 | BR521 | BRIP.1 |
BR124 | BR154 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSC-CONTRACT Element: Contract | Alpha 15 Activity Management contract. |
|
||||||||||||||||||||||
MSC-MAINT-SCHEDULE Element: Maint Schedule | Alpha 15 |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
MSC-PRODUCT Element: Product | Alpha 15 |
|
||||||||||||||||||||||
MSC-PROD-VERSION Element: Prod Version | Alpha 10 |
|
||||||||||||||||||||||
MSC-BEGIN-DATE Element: Begin Date | Numeric 8 (yyyymmdd) The begin date for this effort period. |
|
||||||||||||||||||||||
MSC-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The end date for this effort period. |
|
||||||||||||||||||||||
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 |
|
||||||||||||||||||||||
MSC-EFFECTIVE-DT Element: Effective Dt | Numeric 8 (yyyymmdd) The effective date is the date the record is first valid. |
|
||||||||||||||||||||||
MSC-USERS Element: Users | Numeric 12 |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
MSC-LIST-NET-FLAG Element: List Net Flag | Alpha 1 1 = List 2 = Net |
|
||||||||||||||||||||||
MSC-PROD-LIST-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
MSC-PROD-NET-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
MSC-PROD-MAINT-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
MSC-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||||||||||||||||||||||
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 |
|
||||||||||||||||||||||
MSC-BILL-GL-CD Element: Ac Gl Code | Alpha 4 |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
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 |
|
||||||||||||||||||||||
MSC-UNBL-GL-CD Element: Ac Gl Code | Alpha 4 |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
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 |
|
||||||||||||||||||||||
MSC-REV-GL-CD Element: Ac Gl Code | Alpha 4 |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
MSC-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||||||||||||||||||||
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. |
|
||||||||||||||||||||||
MSC-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||
MSC-PROD-USER-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
MSC-PROD-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||
MSC-USER-FIELD1 Element: User Fld3 | Alpha 15 (Lower Case) |
|
||||||||||||||||||||||
MSC-USER-FIELD2 Element: User Fld3 | Alpha 15 (Lower Case) |
|
||||||||||||||||||||||
MSC-USER-FIELD3 Element: User Fld3 | Alpha 15 (Lower Case) |
|
||||||||||||||||||||||
MSC-PROFORMA-FL Element: Flag1 | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||
MSC-SITE-LOCATION Element: Site Location | Numeric 2 |
|
||||||||||||||||||||||
MSC-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||||||||||||||||||||||
MSC-SUITE Element: Prod Suite | Alpha 6 |
|
||||||||||||||||||||||
MSC-ORIG-CONTRACT Element: Contract | Alpha 15 Activity Management contract. |
|
||||||||||||||||||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSCSET1 |
CONTRACT MAINT-SCHEDULE OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
MSCSET2 |
CONTRACT MAINT-SCHEDULE PRODUCT PROD-VERSION OBJ-ID |
|
| ||||||||||||||||||||||||||||||||||||
MSCSET3 |
PMH-OBJ-ID CONTRACT MAINT-SCHEDULE PRODUCT PROD-VERSION OBJ-ID |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accntract | ACCNTRACT |
Required
| ||||||||||||
Accntract Orig | ACCNTRACT |
Not Required
| ||||||||||||
Accntrpcd | ACCNTRPCD |
Not Required
| ||||||||||||
Acglcode Bill | ACGLCODE |
Not Required
| ||||||||||||
Acglcode Rev | ACGLCODE |
Not Required
| ||||||||||||
Acglcode Unbl | ACGLCODE |
Not Required
| ||||||||||||
Acmnthdr | ACMNTHDR |
Required
| ||||||||||||
Acpmhsthdr | ACPMHSTHDR |
Not Required
| ||||||||||||
Acproddtl | ACPRODDTL |
Required
| ||||||||||||
Acprodhdr | ACPRODHDR |
Not Required
| ||||||||||||
Acprodhdr Orig | ACPRODHDR |
Not Required
| ||||||||||||
Acprodlstx | ACPRODLSTX |
Required
| ||||||||||||
Acreasoncd | ACREASONCD |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accntrcmtx | ACCNTRCMTX |
| ||||||||||||||||||||||||
Acmntschx | ACMNTSCHX |
| ||||||||||||||||||||||||
Acprodtax | ACPRODTAX |
| ||||||||||||||||||||||||
Acproduser | ACPRODUSER |
|
All trademarks and registered trademarks are the property of their
respective owners.