Lawson Insight Technical Documentation |
|
ACMNTSCH
ACMNTSCH FILE
REFERENCED BY
BR10.9 BR124 BR154 BR31.4 BR252
UPDATED BY
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 BR521 BRIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSC-CONTRACT Alpha 15 BR155 BR51.1
Element: Contract Activity Management contract. BR52.1 BR52.4
BR52.5
MSC-MAINT-SCHEDULE Alpha 15 BR155 BR51.1
Element: Maint Schedule BR52.1 BR52.4
BR52.5
MSC-OBJ-ID Numeric 12 BR155 BR51.1
Element: Obj Id This is the object identifier. It is BR52.1 BR52.4
used to relate commitments or posted BR52.5
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 Alpha 15 BR155 BR51.1
Element: Product BR52.1 BR52.4
BR52.5
MSC-PROD-VERSION Alpha 10 BR155 BR51.1
Element: Prod Version BR52.1 BR52.4
BR52.5
MSC-BEGIN-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Begin Date The begin date for this effort period. BR52.1 BR52.4
BR52.5
MSC-END-DATE Numeric 8 (yyyymmdd) BR155 BR51.1
Element: End Date The end date for this effort period. BR52.1 BR52.4
BR52.5
MSC-STATUS Numeric 1 BR02.3 BR120
Element: Status This field displays the status of the BR121 BR122
transaction. BR123 BR140
0 = Unreleased BR151 BR152
1 = Pro Forma BR156 BR157
2 = Accepted BR20.1 BR20.2
3 = Invoiced BR20.3 BR20.4
4 = Free Maintenance BR20.5 BR420
5 = Invoice Cancelled BR51.1 BR52.1
6 = Maint Cancelled BR52.4 BR52.5
BR521 BRIP.1
MSC-EFFECTIVE-DT Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Effective Dt The effective date is the date the BR52.1 BR52.4
record is first valid. BR52.5
MSC-USERS Numeric 12 BR155 BR51.1
Element: Users BR52.1 BR52.4
BR52.5
MSC-MAINT-PERCENT Signed 7.3 BR155 BR51.1
Element: Percent The percentage determines how much BR52.1 BR52.4
retention is held. It can either be a BR52.5
percentage of each invoice, or it can be
a percentage of a total.
MSC-LIST-NET-FLAG Alpha 1 BR155 BR51.1
Element: List Net Flag 1 = List BR52.1 BR52.4
2 = Net BR52.5
MSC-PROD-LIST-AMT Signed 18.2 BR155 BR51.1
Element: Intl Amt BR52.1 BR52.4
BR52.5
MSC-PROD-NET-AMT Signed 18.2 BR155 BR51.1
Element: Intl Amt BR52.1 BR52.4
BR52.5
MSC-PROD-MAINT-AMT Signed 18.2 BR155 BR51.1
Element: Intl Amt BR52.1 BR52.4
BR52.5
MSC-INVOICE Alpha 22 BR52.1 BR52.4
Element: Invoice Used to identify the invoice. BR52.5
MSC-PMH-OBJ-ID Numeric 12
Element: Obj Id 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 Alpha 5 BR155 BR51.1
Element: Acct Category Account categories are groupings of BR52.1 BR52.4
costs, revenues, or a combination of BR52.5
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 Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-BILL-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account This field along with the accounting BR52.1 BR52.4
unit and subaccount make up the location BR52.5
(account) where amounts and other
account information is stored.
MSC-BILL-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Sub Acct This field contains the subaccount from BR52.1 BR52.4
your general ledger chart of accounts BR52.5
that was charged with the amount carried
on this record.
MSC-UNBL-ACCT-CAT Alpha 5 BR155 BR51.1
Element: Acct Category Account categories are groupings of BR52.1 BR52.4
costs, revenues, or a combination of BR52.5
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 Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-UNBL-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account This field along with the accounting BR52.1 BR52.4
unit and subaccount make up the location BR52.5
(account) where amounts and other
account information is stored.
MSC-UNBL-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Sub Acct This field contains the subaccount from BR52.1 BR52.4
your general ledger chart of accounts BR52.5
that was charged with the amount carried
on this record.
MSC-REV-ACCT-CAT Alpha 5 BR155 BR51.1
Element: Acct Category Account categories are groupings of BR52.1 BR52.4
costs, revenues, or a combination of BR52.5
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 Alpha 4 BR155 BR51.1
Element: Ac Gl Code BR52.1 BR52.4
BR52.5
MSC-REV-ACCOUNT Numeric 6 BR155 BR51.1
Element: Account This field along with the accounting BR52.1 BR52.4
unit and subaccount make up the location BR52.5
(account) where amounts and other
account information is stored.
MSC-REV-SUB-ACCT Numeric 4 BR155 BR51.1
Element: Sub Acct This field contains the subaccount from BR52.1 BR52.4
your general ledger chart of accounts BR52.5
that was charged with the amount carried
on this record.
MSC-OPERATOR Alpha 10 BR155 BR51.1
Element: Operator This field is used to store the login BR52.1 BR52.4
id of the person who entered the record. BR52.5
MSC-DATE-STAMP Numeric 8 (yyyymmdd) BR155 BR51.1
Element: Date Stamp This field contains the server date BR52.1 BR52.4
(month, date, and year) of the last BR52.5
change to this record.
MSC-TIME-STAMP Numeric 6 (hhmmss) BR155 BR51.1
Element: Time Stamp Contains the server time (hour, minute, BR52.1 BR52.4
and second) when the record was last BR52.5
changed.
MSC-PROD-USER-AMT Signed 18.2 BR155 BR52.1
Element: Intl Amt BR52.4 BR52.5
MSC-PROD-BASE-AMT Signed 18.2 BR155 BR52.1
Element: Intl Amt BR52.4 BR52.5
MSC-USER-FIELD1 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Fld3 BR52.1 BR52.4
BR52.5
MSC-USER-FIELD2 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Fld3 BR52.1 BR52.4
BR52.5
MSC-USER-FIELD3 Alpha 15 (Lower Case) BR155 BR51.1
Element: User Fld3 BR52.1 BR52.4
BR52.5
MSC-PROFORMA-FL Alpha 1 BR02.3 BR120
Element: Flag1 Y = Yes BR121 BR122
N = No 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 Numeric 2 BR155 BR51.1
Element: Site Location BR52.1 BR52.4
BR52.5
MSC-REASON-CODE Alpha 4 BR155 BR157
Element: Reason Code This field contains the reason code, BR52.1 BR52.4
which indicates the cause for credit BR52.5
memos.
MSC-SUITE Alpha 6 BR155 BR51.1
Element: Prod Suite BR52.1 BR52.4
BR52.5
MSC-ORIG-CONTRACT Alpha 15 BR155 BR51.1
Element: Contract Activity Management contract. BR52.1 BR52.4
BR52.5
MSC-DELIV-METHOD Alpha 1 BR155 BR51.1
Element: Deliv Method S = Shipped BR52.1 BR52.4
H = Hosted at BR52.5
E = Electronic
L = Loaded
1 = Method 1
2 = Method 2
3 = Method 3
ACMNTSCH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSCSET1 CONTRACT BR02.3 BR10.9
MAINT-SCHEDULE BR120 BR121
OBJ-ID 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 KeyChange BR02.3 BR120
MAINT-SCHEDULE BR121 BR122
PRODUCT BR123 BR124
PROD-VERSION BR140 BR151
OBJ-ID 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 KeyChange
CONTRACT
MAINT-SCHEDULE
PRODUCT
PROD-VERSION
OBJ-ID
ACMNTSCH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|