Lawson Insight Technical Documentation |
|
COMISC
COMISC FILE
Customer Order Miscellaneous
The Customer Order Miscellaneous file stores add-on charges attached to
orders or order lines.
REFERENCED BY
OE112 OE229 OE280 OE281 OE286 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 SA100 OE90.1
OE90.2
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE510 OE530 OE810 OE830
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMC-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Number Each order is assigned a unique number. BL130 BL20.1
Order numbers are either manually BL20.3 BL21.2
assigned or system assigned based on a BL21.5 BL29.1
company-level option. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number This field contains the line number. BL130 BL20.1
Add-on charges that are associated with BL20.3 BL21.2
the order header and not the line number BL21.5 BL29.1
on which they appear have a line number BL29.2 BL520
of zero. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThis field contains the number of the BL130 BL20.1
add-on charge tied to the line on an BL20.3 BL21.2
order. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-MISC Alpha 16 BL120 BL122
Element: Misc This field contains the add-on charge BL130 BL20.1
code set up on BL09.1 (Add-on Charges). BL20.3 BL21.2
Add-on charges can be tied to the order BL21.5 BL29.1
or line of an order. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-AOC-CODE Alpha 2 BL120 BL122
Element: Add On Cost CoThis field contains the purchase order BL130 BL20.1
add-on cost code to be used if an order BL20.3 BL21.2
line is causing a purchase order to be BL21.5 BL29.1
created. Purchase order add-on cost BL29.2 BL520
codes are added and updated in the BL820 BL92.1
Invoice Matching system. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-CURRENCY-CODE Alpha 5 BL120 BL122
Element: Currency Code This field contains the currency code BL130 BL20.1
defined to the add-on charge in BL09.1 BL20.3 BL21.2
(Add-on Charges). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-STATUS Numeric 1 BL120 BL122
Element: Status This field contains the status of the BL130 BL20.1
add-on charge. BL20.3 BL21.2
0 = Unreleased BL21.5 BL29.1
1 = Released BL29.2 BL520
2 = Shipped BL820 BL92.1
8 = Cancelled OE10.1 OE10.2
9 = Ready For Purge OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-DESCRIPTION Alpha 30 (Lower Case) BL120 BL122
Element: Description This field contains the description of BL130 BL20.1
the add-on charge as defined in BL09.1 BL20.3 BL21.2
(Add-on Charges). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Order DiscountThis field indicates whether this BL130 BL20.1
add-on charge is included when BL20.3 BL21.2
calculating the discount amount of the BL21.5 BL29.1
order. BL29.2 BL520
Y = Yes BL820 BL92.1
N = No OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-UPD-SA-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates whether this BL130 BL20.1
add-on charge is updated into the Sales BL20.3 BL21.2
Analysis system for reporting purposes. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-BOOKED-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the date this
add-on charge was booked in the Sales
Analysis system.
CMC-TAX-EXEMPT-CD Alpha 1 BL120 BL122
Element: Tax Exempt CodThis field indicates if this add-on BL130 BL20.1
charge is taxed. BL20.3 BL21.2
T = Taxable BL21.5 BL29.1
E = Exempt BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code This field contains a code representing BL130 BL20.1
the tax authorities this ship-to pays BL20.3 BL21.2
sales tax to. This must be valid in the BL21.5 BL29.1
Tax Code file. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-TAX-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the tax amount of BL130 BL20.1
the add-on charge in billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-MULT-TAX-AMT Derived
Element: Mult Tax Amt This field contains the multiplier used
to convert foreign currency to the base
amount of tax.
CMC-DIV-TAX-AMT Derived
Element: Div Tax Amt This field contains the divider used to
convert foreign currency to the base
amount of tax.
CMC-TAX-AMT-BASE Derived
Element: Tax Amt Base This field contains the tax amount of
add-on charge in company base currency.
CMC-ENT-TAXABLE Signed 18.2
Element: Intl Amt This field contains the taxable amount
of the add-on charge. This defaults to
the charge amount but can be overridden
at entry time.
CMC-MULT-TAXABLE Derived
Element: Mult Taxable This field contains the taxable amount
of the add-on charge in base currency,
if a multiplier is used when converting
from original to base currency.
CMC-DIV-TAXABLE Derived
Element: Div Taxable This field contains the taxable amount
of the add-on charge in base currency,
if a multiplier is used in the
conversion from original to base
currency.
CMC-TAXABLE-BASE Derived
Element: Taxable Base This field contains the taxable amount
of the add-on charge in company base
currency.
CMC-CHARGE-TYPE Numeric 1 BL120 BL122
Element: Charge Type This field indicates whether the charge BL130 BL20.1
is lump sum, unit price (per stock unit BL20.3 BL21.2
of measure) or percent. BL21.5 BL29.1
1 = Lump Sum BL29.2 BL520
2 = Unit Price BL820 BL92.1
3 = Percentage OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ENT-UNIT-PRC Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price in BL130 BL20.1
the order's currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-UNIT-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price of BL130 BL20.1
the add-on charge in company base BL20.3 BL21.2
currency. This is a flat monetary amount BL21.5 BL29.1
or a per unit amount, depending on the BL29.2 BL520
charge type. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-PRICE-PCT Percent 5.3 (Percent) BL120 BL122
Element: Cost Pct Price percent. This is the percent BL130 BL20.1
applied to either the line net or order BL20.3 BL21.2
net amount to calculate the amount to BL21.5 BL29.1
charge for this add-on charge. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ENT-PRICE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the flat amount at BL130 BL20.1
which the add-on charge is priced in BL20.3 BL21.2
original billing currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-PRICE Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the flat price BL130 BL20.1
amount of the add-on charge in company BL20.3 BL21.2
base currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-UNIT-COST Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the cost amount of BL130 BL20.1
the add-on charge as established in BL20.3 BL21.2
BL09.1 (Add-on Charges). This can be BL21.5 BL29.1
overridden, and is always in company BL29.2 BL520
base currency. Enter a flat monetary BL820 BL92.1
cost amount or a per unit cost, OE10.1 OE10.2
depending on the charge type. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-COST-PCT Percent 5.3 (Percent) BL120 BL122
Element: Cost Pct This field contains the cost percent, BL130 BL20.1
which is applied to the add-on charge BL20.3 BL21.2
resulting in the cost for the line. If BL21.5 BL29.1
the add-on charge is added to the BL29.2 BL520
header, this is the percent applied to BL820 BL92.1
the order amount to arrive at the cost OE10.1 OE10.2
of this charge. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-COST Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the cost tied to BL130 BL20.1
the add-on charge in BL09.1 (Add-on BL20.3 BL21.2
Charges), if the charge is the flat BL21.5 BL29.1
type. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-BILLED-CURR Signed 18.2 OE114 OE129
Element: Intl Amt This field contains the amount billed
to the customer for this add-on charge
in original currency.
CMC-MULT-BILLED Derived
Element: Mult Billed This field contains the amount billed
to the customer for this add-on charge
in base currency, if a multiplier is
used when converting from original to
base currency.
CMC-DIV-BILLED Derived
Element: Div Billed This field contains the amount billed
to the customer for this add-on charge
in company base currency, if a divider
is used when converting from original to
base currency.
CMC-BILLED-BASE Derived
Element: Billed Base This field contains the amount billed
to the customer for this add-on charge
in company base currency.
CMC-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for revenue (sales) postings whereas the BL20.3 BL21.2
Activity-C field is used for Cost (COGS) BL21.5 BL29.1
postings. BL29.2 BL520
BL820 BL92.1
Activities are the processes or OE10.1 OE10.2
procedures that produce work. Cost OE10.3 OE10.4
objects (products, services, customers, OE10.5 OE10.6
and so on) are the reasons for OE10.7 OE10.8
performing the activity. Activities and OE11.1 OE11.4
cost object activities are used OE11.8 OE11.9
synonymously in the Activity Management OE110 OE111
system. Direct costs are posted to OE113 OE114
activities, and indirect costs are OE116 OE129
allocated to activities based on OE13.2 OE13.3
activity drivers. OE13.5 OE13.6
OE14.4 OE30.1
Activities are grouped or organized by OE30.2 OE30.3
activity levels. There are two types of OE30.4 OE30.5
activities: "posting allowed" and OE30.6 OE30.7
"summary only." Use posting level OE30.9 OE510
activities to budget and maintain all OE530 OE810
posted transactions. Summary activities OE830 WH20.7
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
CMC-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Account CategoIn this file the Acct-Category field is BL130 BL20.1
used for revenue (sales) postings BL20.3 BL21.2
whereas the Acct-Categ-C field is used BL21.5 BL29.1
for Cost (COGS) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of OE10.1 OE10.2
costs, revenues, or a combination of OE10.3 OE10.4
both used for reporting and inquiries OE10.5 OE10.6
for activities in the Activity OE10.7 OE10.8
Management system. All transactions are OE11.1 OE11.4
posted to an account category within an OE11.8 OE11.9
activity. You can assign a specific OE110 OE111
general ledger account or range of OE113 OE114
accounts (company, accounting unit, OE116 OE129
account, and subaccount) that make up OE13.2 OE13.3
the transactions posted to an account OE13.5 OE13.6
category using AC07.1 (Account OE14.4 OE30.1
Assignment). OE30.2 OE30.3
OE30.4 OE30.5
Period-to-date, year-to-date, and OE30.6 OE30.7
life-to-date balances are maintained by OE30.9 OE510
account category for activities. Account OE530 OE810
categories must be assigned to OE830 WH20.7
activities before you do any budgeting
or transaction processing.
CMC-ATN-OBJ-ID Numeric 12 BL120 BL122
Object Represents Activity Management object BL130 BL20.1
Identification ID for the revenue (sales) Activity. BL20.3 BL21.2
BL21.5 BL29.1
Activities are the processes or BL29.2 BL520
procedures that produce work. Cost BL820 BL92.1
objects (products, services, customers, OE10.1 OE10.2
and so on) are the reasons for OE10.3 OE10.4
performing the activity. Activities and OE10.5 OE10.6
cost object activities are used OE10.7 OE10.8
synonymously in the Activity Management OE11.1 OE11.4
system. Direct costs are posted to OE11.8 OE11.9
activities, and indirect costs are OE110 OE111
allocated to activities based on OE113 OE114
activity drivers. OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ACTIVITY-C Alpha 15 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Activity field is used for revenue BL21.5 BL29.1
(sales) postings. BL29.2 BL520
BL820 BL92.1
Activities are the processes or OE10.1 OE10.2
procedures that produce work. Cost OE10.3 OE10.4
objects (products, services, customers, OE10.5 OE10.6
and so on) are the reasons for OE10.7 OE10.8
performing the activity. Activities and OE11.1 OE11.4
cost object activities are used OE11.8 OE11.9
synonymously in the Activity Management OE110 OE111
system. Direct costs are posted to OE113 OE114
activities, and indirect costs are OE116 OE129
allocated to activities based on OE13.2 OE13.3
activity drivers. OE13.5 OE13.6
OE14.4 OE30.1
Activities are grouped or organized by OE30.2 OE30.3
activity levels. There are two types of OE30.4 OE30.5
activities: "posting allowed" and OE30.6 OE30.7
"summary only." Use posting level OE30.9 OE510
activities to budget and maintain all OE530 OE810
posted transactions. Summary activities OE830 WH20.7
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
CMC-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Account CategoIn this file the Acct-Categ-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Acct-Category field is used for BL21.5 BL29.1
revenue (sales) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of OE10.1 OE10.2
costs, revenues, or a combination of OE10.3 OE10.4
both used for reporting and inquiries OE10.5 OE10.6
for activities in the Activity OE10.7 OE10.8
Management system. All transactions are OE11.1 OE11.4
posted to an account category within an OE11.8 OE11.9
activity. You can assign a specific OE110 OE111
general ledger account or range of OE113 OE114
accounts (company, accounting unit, OE116 OE129
account, and subaccount) that make up OE13.2 OE13.3
the transactions posted to an account OE13.5 OE13.6
category using AC07.1 (Account OE14.4 OE30.1
Assignment). OE30.2 OE30.3
OE30.4 OE30.5
Period-to-date, year-to-date, and OE30.6 OE30.7
life-to-date balances are maintained by OE30.9 OE510
account category for activities. Account OE530 OE810
categories must be assigned to OE830 WH20.7
activities before you do any budgeting
or transaction processing.
CMC-ATN-OBJ-ID-C Numeric 12 BL120 BL122
Object The system defined object id BL130 BL20.1
Identification representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis field contains the sales account BL130 BL20.1
unit that is credited when the add-on BL20.3 BL21.2
charge is assessed. This defaults from BL21.5 BL29.1
BL09.1 (Add-on Charges). BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-SLS-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the general ledger BL130 BL20.1
account number that is credited when the BL20.3 BL21.2
add-on charge is assessed. This defaults BL21.5 BL29.1
from BL09.1 (Add-on Charges). BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This field contains the general ledger BL130 BL20.1
subaccount that is credited when the BL20.3 BL21.2
add-on charge is assessed. This defaults BL21.5 BL29.1
from the add-on charge set up in the BL29.2 BL520
Billing system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis field contains the general ledger BL130 BL20.1
account unit that is credited as an BL20.3 BL21.2
offset to the cost of goods sold when BL21.5 BL29.1
assessing a charge. BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-OFF-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the general ledger BL130 BL20.1
account number that is credited as an BL20.3 BL21.2
offset to the cost of goods sold when BL21.5 BL29.1
the add-on charge is assessed. This BL29.2 BL520
defaults from the add-on charge set up BL820 BL92.1
in the Billing system. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This field contains the general ledger BL130 BL20.1
subaccount that is credited as an offset BL20.3 BL21.2
to the cost of goods sold. This defaults BL21.5 BL29.1
from the add-on charge set up in the BL29.2 BL520
Billing system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis field contains the general ledger BL130 BL20.1
account unit of the cost of goods that BL20.3 BL21.2
is debited when the add-on charge is BL21.5 BL29.1
assessed. This defaults from the add-on BL29.2 BL520
charge set up in the Billing system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account Cost of goods sold general ledger BL130 BL20.1
account number to be debited when the BL20.3 BL21.2
add-on charge is assessed. Defaults from BL21.5 BL29.1
the add-on charge set up in the Billing BL29.2 BL520
system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This field contains the general ledger BL130 BL20.1
subaccount number of the cost of goods BL20.3 BL21.2
sold that is debited when the add-on BL21.5 BL29.1
charge is assessed. This defaults from BL29.2 BL520
the add-on charge set up in the Billing BL820 BL92.1
system. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-SHIPMENT-NBR Numeric 10 OE114 OE129
Element: Shipment NumbeThis field contains the shipment OE14.4 OE810
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
CMC-BOOK-TO-SA-FL Alpha 1
Element: All Flag This field indicates if this charge
line is updated to the Sales Analysis
system.
Y = Yes
N = No
CMC-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Product Tax CaA classification of items for BL130 BL20.1
determining taxes using the VERTEX BL20.3 BL21.2
system in Lawson Order Entry system or BL21.5 BL29.1
the cash receipts programs in the Lawson BL29.2 BL520
Cash Ledger system. BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
CMC-ORD-PCT-AMT Derived
Element: Ord Pct Amt This field contains the amount billed
to the customer if the add-on charge is
tied to the order header and is a
percentage type. This amount is in
company base currency.
CMC-ORD-PCT-CURR Derived
Element: Ord Pct Curr This field contains the amount billed
to the customer if the add-on charge is
tied to the order header and is a
percentage type. This amount is in
original billing currency.
CMC-LINE-PCT-AMT Derived
Element: Line Pct Amt This field contains the amount to bill
if attached to an order line.
CMC-LINE-PCT-CURR Derived
Element: Line Pct Curr This field contains the amount billed
to the customer if the add-on charge is
tied to the line and is a percentage
type charge. This amount is in original
billing currency.
CMC-UNIT-AMOUNT Derived
Element: Unit Amount This field contains the amount that is
charged per unit of the item ordered at
the line level. The add-on charge amount
is the sum total of the charges per
unit.
CMC-UNIT-AMT-CURR Derived
Element: Unit Amt Curr This field contains the amount that is
charged per unit of the item ordered at
the line level. The add-on charge amount
is the sum total of the charges per
unit. This amount is in billing
currency.
CMC-PRT-PRICE Derived
Element: Prt Price This field contains the unit amount
that is billed for the add-on charge
line.
CMC-PRT-PRC-CURR Derived
Element: Prt Prc Curr This field contains the unit amount
that is billed for the add-on charge
line in billing currency.
CMC-UNBILLED-AMT Derived
Element: Unbilled Amt This field contains the amount
remaining to be billed.
CMC-UNBILLED-CURR Derived
Element: Unbilled Curr This field contains the amount
remaining to be billed in billing
currency.
CMC-PER-UNIT-FL Derived
Element: Per Unit Fl This field indicates if the add-on
charge is a per unit type.
COMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMCSET1 COMPANY BL120 BL122
ORDER-NBR BL130 BL20.1
LINE-NBR BL20.3 BL21.2
SEQ BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE112 OE113
OE114 OE116
...
CMCSET3 COMPANY Subset BL120 BL122
ORDER-NBR Where AOC-CODE != Spaces BL130 BL20.1
LINE-NBR And STATUS != 8 BL20.3 BL21.2
AOC-CODE BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
...
CMCSET4 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
CMCSET5 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
CMCSET6 COMPANY KeyChange BL120 BL122
ORDER-NBR BL130 BL20.1
TAX-CODE BL20.3 BL21.2
PROD-TAX-CAT BL21.5 BL29.1
LINE-NBR BL29.2 BL520
SEQ BL820 BL92.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE112 OE113
OE114 OE129
...
CMCSET7 COMPANY This index was created as a solution to OE114 OE129
ORDER-NBR the Find Next/Prev Flag error. It is
SEQ only used where a modify must be done
LINE-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
COMISC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cgs Account GLMASTER Required
When CMC-CGS-ACCT-UNIT != Spaces
Or CMC-CGS-ACCOUNT != Zeroes
Or CMC-CGS-SUB-ACCT != Zeroes
CMC-COMPANY -> GLM-COMPANY
CMC-CGS-ACCT-UNIT -> GLM-ACCT-UNIT
CMC-CGS-ACCOUNT -> GLM-ACCOUNT
CMC-CGS-SUB-ACCT -> GLM-SUB-ACCOUNT
Coline COLINE Required
When CMC-LINE-NBR != Zeroes
CMC-COMPANY -> COL-COMPANY
CMC-ORDER-NBR -> COL-ORDER-NBR
CMC-LINE-NBR -> COL-LINE-NBR
Cosgblk COSGBLK Not Required
CMC-COMPANY -> OSG-COMPANY
CMC-ORDER-NBR -> OSG-ORDER-NBR
CMC-LINE-NBR -> OSG-LINE-NBR
CMC-SEQ -> OSG-SEQ
Cucodes CUCODES Required
CMC-CURRENCY-CODE -> CUC-CURRENCY-CODE
Custorder CUSTORDER Required
CMC-COMPANY -> COR-COMPANY
CMC-ORDER-NBR -> COR-ORDER-NBR
Oemisc OEMISC Required
CMC-COMPANY -> OEM-COMPANY
CMC-MISC -> OEM-MISC
CMC-CURRENCY-CODE -> OEM-CURRENCY-CODE
Off Account GLMASTER Required
When CMC-OFF-ACCT-UNIT != Spaces
Or CMC-OFF-ACCOUNT != Zeroes
Or CMC-OFF-SUB-ACCT != Zeroes
CMC-COMPANY -> GLM-COMPANY
CMC-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
CMC-OFF-ACCOUNT -> GLM-ACCOUNT
CMC-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Sales Account GLMASTER Required
When CMC-SLS-ACCT-UNIT != Spaces
Or CMC-SLS-ACCOUNT != Zeroes
Or CMC-SLS-SUB-ACCT != Zeroes
CMC-COMPANY -> GLM-COMPANY
CMC-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
CMC-SLS-ACCOUNT -> GLM-ACCOUNT
CMC-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
Txtaxcode TXTAXCODE Not Required
CMC-COMPANY -> TAC-COMPANY
CMC-TAX-CODE -> TAC-TAX-CODE
|