COMISC FILE
Customer Order Miscellaneous
The Customer Order Miscellaneous file stores add-on charges attached to
orders or order lines.
REFERENCED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL940 OE112
OE280 OE281 OE286 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE830 OE950
SA100
UPDATED BY
BL720 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 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE310 OE510 OE810 OE920 OE965
WH20.7 WH966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMC-COMPANY Numeric 4 BL92.1 OE10.1
Company The company number represents an OE10.2 OE10.3
established company and is entered on OE10.4 OE10.5
all function codes. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number Each order is assigned a unique number. OE10.2 OE10.3
Order numbers are either manually OE10.4 OE10.5
assigned or system assigned based on a OE10.6 OE10.7
company-level option. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field contains the line number. OE10.2 OE10.3
Add-on charges that are associated with OE10.4 OE10.5
the order header and not the line number OE10.6 OE10.7
on which they appear have a line number OE10.8 OE11.1
of zero. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-SEQ Numeric 3 BL92.1 OE10.1
Sequence Number This field contains the number of the OE10.2 OE10.3
add-on charge tied to the line on an OE10.4 OE10.5
order. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-MISC Alpha 16 BL92.1 OE10.1
Miscellaneous This field contains the add-on charge OE10.2 OE10.3
code set up on BL09.1 (Add-on Charges). OE10.4 OE10.5
Add-on charges can be tied to the order OE10.6 OE10.7
or line of an order. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-AOC-CODE Alpha 2 BL92.1 OE10.1
Add On Cost Code This field contains the purchase order OE10.2 OE10.3
add-on cost code to be used if an order OE10.4 OE10.5
line is causing a purchase order to be OE10.6 OE10.7
created. Purchase order add-on cost OE10.8 OE11.1
codes are added and updated in the OE11.4 OE11.8
Invoice Matching system. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-CURRENCY-CODE Alpha 5 BL92.1 OE10.1
Currency Code This field contains the currency code OE10.2 OE10.3
defined to the add-on charge in BL09.1 OE10.4 OE10.5
(Add-on Charges). OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-STATUS Numeric 1 BL92.1 OE10.1
Status This field contains the status of the OE10.2 OE10.3
add-on charge. OE10.4 OE10.5
0 = Unreleased OE10.6 OE10.7
1 = Released OE10.8 OE11.1
2 = Shipped OE11.4 OE11.8
8 = Cancelled OE11.9 OE110
9 = Ready For Purge OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-DESCRIPTION Alpha 30 (Lower Case) BL92.1 OE10.1
Description This field contains the description of OE10.2 OE10.3
the add-on charge as defined in BL09.1 OE10.4 OE10.5
(Add-on Charges). OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-ORD-DISC-FL Alpha 1 BL92.1 OE10.1
Order Discount Flag This field indicates whether this OE10.2 OE10.3
add-on charge is included when OE10.4 OE10.5
calculating the discount amount of the OE10.6 OE10.7
order. OE10.8 OE11.1
Y = Yes OE11.4 OE11.8
N = No OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-UPD-SA-FL Alpha 1 BL92.1 OE10.1
Upd Sa-Fl This field indicates whether this OE10.2 OE10.3
add-on charge is updated into the Sales OE10.4 OE10.5
Analysis system for reporting purposes. OE10.6 OE10.7
Y = Yes OE10.8 OE11.1
N = No OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-BOOKED-DATE Numeric 8 (yyyymmdd) OE965
Booked Date This field contains the date this
add-on charge was booked in the Sales
Analysis system.
CMC-TAX-EXEMPT-CD Alpha 1 BL92.1 OE10.1
Tax Exempt Code This field indicates if this add-on OE10.2 OE10.3
charge is taxed. OE10.4 OE10.5
T = Taxable OE10.6 OE10.7
E = Exempt OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-TAX-CODE Alpha 10 BL92.1 OE10.1
Tax Code This field contains a code representing OE10.2 OE10.3
the tax authorities this ship-to pays OE10.4 OE10.5
sales tax to. This must be valid in the OE10.6 OE10.7
Tax Code file. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-TAX-AMT-CURR Signed 15.2 BL92.1 OE10.1
Tax Amount Currency This field contains the tax amount of OE10.2 OE10.3
the add-on charge in billing currency. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-MULT-TAX-AMT Derived
Mult Tax Amt This field contains the multiplier used
to convert foreign currency to the base
amount of tax.
CMC-DIV-TAX-AMT Derived
Div Tax Amt This field contains the divider used to
convert foreign currency to the base
amount of tax.
CMC-TAX-AMT-BASE Derived
Tax Amount Base This field contains the tax amount of
add-on charge in company base currency.
CMC-ENT-TAXABLE Signed 15.2 OE965
Entered Taxable 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
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
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
Taxable Base This field contains the taxable amount
of the add-on charge in company base
currency.
CMC-CHARGE-TYPE Numeric 1 BL92.1 OE10.1
Charge Type This field indicates whether the charge OE10.2 OE10.3
is lump sum, unit price (per stock unit OE10.4 OE10.5
of measure) or percent. OE10.6 OE10.7
1 = Lump Sum OE10.8 OE11.1
2 = Unit Price OE11.4 OE11.8
3 = Percentage OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-ENT-UNIT-PRC Signed 13.5 BL92.1 OE10.1
Ent Unit Prc This field contains the unit price in OE10.2 OE10.3
the order's currency. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-UNIT-PRICE Signed 13.5 BL92.1 OE10.1
Unit Price This field contains the unit price of OE10.2 OE10.3
the add-on charge in company base OE10.4 OE10.5
currency. This is a flat monetary amount OE10.6 OE10.7
or a per unit amount, depending on the OE10.8 OE11.1
charge type. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-PRICE-PCT Percent 5.3 (Percent) BL92.1 OE10.1
Price Pct Price percent. This is the percent OE10.2 OE10.3
applied to either the line net or order OE10.4 OE10.5
net amount to calculate the amount to OE10.6 OE10.7
charge for this add-on charge. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-ENT-PRICE Signed 15.2 BL92.1 OE10.1
Ent Price This field contains the flat amount at OE10.2 OE10.3
which the add-on charge is priced in OE10.4 OE10.5
original billing currency. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-PRICE Signed 15.2 BL92.1 OE10.1
Price This field contains the flat price OE10.2 OE10.3
amount of the add-on charge in company OE10.4 OE10.5
base currency. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-UNIT-COST Signed 13.5 BL92.1 OE10.1
Unit Cost This field contains the cost amount of OE10.2 OE10.3
the add-on charge as established in OE10.4 OE10.5
BL09.1 (Add-on Charges). This can be OE10.6 OE10.7
overridden, and is always in company OE10.8 OE11.1
base currency. Enter a flat monetary OE11.4 OE11.8
cost amount or a per unit cost, OE11.9 OE110
depending on the charge type. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-COST-PCT Percent 5.3 (Percent) BL92.1 OE10.1
Cost Pct This field contains the cost percent, OE10.2 OE10.3
which is applied to the add-on charge OE10.4 OE10.5
resulting in the cost for the line. If OE10.6 OE10.7
the add-on charge is added to the OE10.8 OE11.1
header, this is the percent applied to OE11.4 OE11.8
the order amount to arrive at the cost OE11.9 OE110
of this charge. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-COST Signed 11.2 BL92.1 OE10.1
Cost This field contains the cost tied to OE10.2 OE10.3
the add-on charge in BL09.1 (Add-on OE10.4 OE10.5
Charges), if the charge is the flat OE10.6 OE10.7
type. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-BILLED-CURR Signed 15.2 OE114 OE129
Billed Amount in This field contains the amount billed OE965
Orig Currency to the customer for this add-on charge
in original currency.
CMC-MULT-BILLED Derived
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
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
Billed Amount in This field contains the amount billed
Base Currency to the customer for this add-on charge
in company base currency.
CMC-ACTIVITY Alpha 15 BL92.1 OE10.1
Activity In this file the Activity field is used OE10.2 OE10.3
for revenue (sales) postings whereas the OE10.4 OE10.5
Activity-C field is used for Cost (COGS) OE10.6 OE10.7
postings. OE10.8 OE11.1
OE11.4 OE11.8
Activities are the processes or OE11.9 OE110
procedures that produce work. Cost OE113 OE114
objects (products, services, customers, OE129 OE14.4
and so on) are the reasons for OE15.1 OE15.2
performing the activity. Activities and OE15.3 OE15.4
cost object activities are used OE15.5 OE15.7
synonymously in the Activity Management OE510 OE810
system. Direct costs are posted to OE920 OE965
activities, and indirect costs are WH20.7
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
CMC-ACCT-CATEGORY Alpha 5 BL92.1 OE10.1
Account Category In this file the Acct-Category field is OE10.2 OE10.3
used for revenue (sales) postings OE10.4 OE10.5
whereas the Acct-Categ-C field is used OE10.6 OE10.7
for Cost (COGS) postings. OE10.8 OE11.1
OE11.4 OE11.8
Account categories are groupings of OE11.9 OE110
costs, revenues, or a combination of OE113 OE114
both used for reporting and inquiries OE129 OE14.4
for activities in the Activity OE15.1 OE15.2
Management system. All transactions are OE15.3 OE15.4
posted to an account category within an OE15.5 OE15.7
activity. You can assign a specific OE510 OE810
general ledger account or range of OE920 OE965
accounts (company, accounting unit, WH20.7
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.
CMC-ATN-OBJ-ID Numeric 12 BL92.1 OE10.1
AC System Object ID Represents Activity Management object OE10.2 OE10.3
(Sales) ID for the revenue (sales) Activity. OE10.4 OE10.5
OE10.6 OE10.7
Activities are the processes or OE10.8 OE11.1
procedures that produce work. Cost OE11.4 OE11.8
objects (products, services, customers, OE11.9 OE110
and so on) are the reasons for OE113 OE114
performing the activity. Activities and OE129 OE14.4
cost object activities are used OE15.1 OE15.2
synonymously in the Activity Management OE15.3 OE15.4
system. Direct costs are posted to OE15.5 OE15.7
activities, and indirect costs are OE510 OE810
allocated to activities based on OE920 OE965
activity drivers. WH20.7
CMC-SLS-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Sales Accounting This field contains the sales account OE10.2 OE10.3
Unit unit that is credited when the add-on OE10.4 OE10.5
charge is assessed. This defaults from OE10.6 OE10.7
BL09.1 (Add-on Charges). OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-SLS-ACCOUNT Numeric 6 BL92.1 OE10.1
Sales Account This field contains the general ledger OE10.2 OE10.3
account number that is credited when the OE10.4 OE10.5
add-on charge is assessed. This defaults OE10.6 OE10.7
from BL09.1 (Add-on Charges). OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-SLS-SUB-ACCT Numeric 4 BL92.1 OE10.1
Sales Subaccount This field contains the general ledger OE10.2 OE10.3
subaccount that is credited when the OE10.4 OE10.5
add-on charge is assessed. This defaults OE10.6 OE10.7
from the add-on charge set up in the OE10.8 OE11.1
Billing system. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-OFF-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Offset Accounting This field contains the general ledger OE10.2 OE10.3
Unit account unit that is credited as an OE10.4 OE10.5
offset to the cost of goods sold when OE10.6 OE10.7
assessing a charge. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-OFF-ACCOUNT Numeric 6 BL92.1 OE10.1
Offset Account This field contains the general ledger OE10.2 OE10.3
account number that is credited as an OE10.4 OE10.5
offset to the cost of goods sold when OE10.6 OE10.7
the add-on charge is assessed. This OE10.8 OE11.1
defaults from the add-on charge set up OE11.4 OE11.8
in the Billing system. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-OFF-SUB-ACCT Numeric 4 BL92.1 OE10.1
Offset Subaccount This field contains the general ledger OE10.2 OE10.3
subaccount that is credited as an offset OE10.4 OE10.5
to the cost of goods sold. This defaults OE10.6 OE10.7
from the add-on charge set up in the OE10.8 OE11.1
Billing system. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-CGS-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Cost Of Goods Sold This field contains the general ledger OE10.2 OE10.3
Acct Unit account unit of the cost of goods that OE10.4 OE10.5
is debited when the add-on charge is OE10.6 OE10.7
assessed. This defaults from the add-on OE10.8 OE11.1
charge set up in the Billing system. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-CGS-ACCOUNT Numeric 6 BL92.1 OE10.1
Cost Of Goods Sold Cost of goods sold general ledger OE10.2 OE10.3
Account account number to be debited when the OE10.4 OE10.5
add-on charge is assessed. Defaults from OE10.6 OE10.7
the add-on charge set up in the Billing OE10.8 OE11.1
system. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-CGS-SUB-ACCT Numeric 4 BL92.1 OE10.1
Cost Of Goods Sold This field contains the general ledger OE10.2 OE10.3
Subaccount subaccount number of the cost of goods OE10.4 OE10.5
sold that is debited when the add-on OE10.6 OE10.7
charge is assessed. This defaults from OE10.8 OE11.1
the add-on charge set up in the Billing OE11.4 OE11.8
system. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE965
WH20.7
CMC-SHIPMENT-NBR Numeric 10 OE114 OE129
Shipment Number This field contains the shipment OE14.4 OE15.7
number. One order can have several OE810 OE920
shipment numbers if the items of the OE965 WH966
order were not shipped at the same time.
CMC-BOOK-TO-SA-FL Alpha 1 OE965
Booked to Sales This field indicates if this charge
Analysis Flag line is updated to the Sales Analysis
system.
Y = Yes
N = No
CMC-ACTIVITY-C Alpha 15 BL92.1 OE10.1
Activity for Cst of In this file the Activity-C field is OE10.2 OE10.3
Goods Sold used for Cost (COGS) postings whereas OE10.4 OE10.5
the Activity field is used for revenue OE10.6 OE10.7
(sales) postings. OE10.8 OE11.1
OE11.4 OE11.8
Activities are the processes or OE11.9 OE110
procedures that produce work. Cost OE113 OE114
objects (products, services, customers, OE129 OE14.4
and so on) are the reasons for OE15.1 OE15.2
performing the activity. Activities and OE15.3 OE15.4
cost object activities are used OE15.5 OE15.7
synonymously in the Activity Management OE510 OE810
system. Direct costs are posted to OE920 WH20.7
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
CMC-ACCT-CATEG-C Alpha 5 BL92.1 OE10.1
Acct Categ (Cst of In this file the Acct-Categ-C field is OE10.2 OE10.3
Goods Sold) used for Cost (COGS) postings whereas OE10.4 OE10.5
the Acct-Category field is used for OE10.6 OE10.7
revenue (sales) postings. OE10.8 OE11.1
OE11.4 OE11.8
Account categories are groupings of OE11.9 OE110
costs, revenues, or a combination of OE113 OE114
both used for reporting and inquiries OE129 OE14.4
for activities in the Activity OE15.1 OE15.2
Management system. All transactions are OE15.3 OE15.4
posted to an account category within an OE15.5 OE15.7
activity. You can assign a specific OE510 OE810
general ledger account or range of OE920 WH20.7
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.
CMC-ATN-OBJ-ID-C Numeric 12 BL92.1 OE10.1
AC System Object ID The system defined object id OE10.2 OE10.3
(Cost) representing the Activity Management OE10.4 OE10.5
commitment for Cost (COGS). OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
CMC-ORD-PCT-AMT Derived
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
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
Line Pct Amt This field contains the amount to bill
if attached to an order line.
CMC-LINE-PCT-CURR Derived
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
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
~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
Prt Price This field contains the unit amount
that is billed for the add-on charge
line.
CMC-PRT-PRC-CURR Derived
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
Unbilled Amount This field contains the amount
remaining to be billed.
CMC-UNBILLED-CURR Derived
Unbilled Curr This field contains the amount
remaining to be billed in billing
currency.
CMC-PER-UNIT-FL Derived
Per Unit Fl This field indicates if the add-on
charge is a per unit type.
CMC-PROD-TAX-CAT Alpha 15 BL720 BL92.1
Product Tax Category A classification of items for OE10.1 OE10.2
determining taxes using the VERTEX OE10.3 OE10.4
system in Lawson Order Entry system or OE10.5 OE10.6
the cash receipts programs in the Lawson OE10.7 OE10.8
Cash Ledger system. OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH20.7
COMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMCSET1 COMPANY BL120 BL130
ORDER-NBR BL20.1 BL20.3
LINE-NBR BL21.2 BL21.5
SEQ BL29.1 BL29.2
BL520 BL720
BL820 BL92.1
BL940 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
OE112 OE113
OE114 OE129
...
CMCSET3 COMPANY Subset BL92.1 OE10.1
ORDER-NBR Where AOC-CODE != Spaces OE10.2 OE10.3
LINE-NBR And STATUS != 8 OE10.4 OE10.5
AOC-CODE OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.2
WH20.7
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 BL92.1 OE10.1
ORDER-NBR OE10.2 OE10.3
TAX-CODE OE10.4 OE10.5
PROD-TAX-CAT OE10.6 OE10.7
LINE-NBR OE10.8 OE11.1
SEQ OE11.4 OE11.8
OE11.9 OE110
OE112 OE113
OE114 OE129
OE14.1 OE14.2
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE80.1 OE80.2
...
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
|