COMISC FILE
Customer Order Miscellaneous
The Customer Order Miscellaneous file stores add-on charges attached to
orders or order lines.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMC-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
CMC-ORDER-NBR Numeric 8
Order Number Each order is assigned a unique number.
Order numbers are either manually
assigned or system assigned based on a
company-level option.
CMC-LINE-NBR Numeric 6
Line Number This field contains the line number.
Add-on charges that are associated with
the order header and not the line number
on which they appear have a line number
of zero.
CMC-SEQ Numeric 3
Sequence Number This field contains the number of the
add-on charge tied to the line on an
order.
CMC-MISC Alpha 16
Misc This field contains the add-on charge
code set up on BL09.1 (Add-on Charges).
Add-on charges can be tied to the order
or line of an order.
CMC-AOC-CODE Alpha 2
Add On Cost Code This field contains the purchase order
add-on cost code to be used if an order
line is causing a purchase order to be
created. Purchase order add-on cost
codes are added and updated in the
Invoice Matching system.
CMC-CURRENCY-CODE Alpha 5
Currency Code This field contains the currency code
defined to the add-on charge in BL09.1
(Add-on Charges).
CMC-STATUS Numeric 1
Status This field contains the status of the
add-on charge.
0 = Unreleased
1 = Released
2 = Shipped
8 = Cancelled
9 = Ready For Purge
CMC-DESCRIPTION Alpha 30 (Lower Case)
Description This field contains the description of
the add-on charge as defined in BL09.1
(Add-on Charges).
CMC-ORD-DISC-FL Alpha 1
Order Discount Flag This field indicates whether this
add-on charge is included when
calculating the discount amount of the
order.
Y = Yes
N = No
CMC-UPD-SA-FL Alpha 1
Upd Sa Fl This field indicates whether this
add-on charge is updated into the Sales
Analysis system for reporting purposes.
Y = Yes
N = No
CMC-BOOKED-DATE Numeric 8 (yyyymmdd)
Booked Date This field contains the date this
add-on charge was booked in the Sales
Analysis system.
CMC-TAX-EXEMPT-CD Alpha 1
Tax Exempt Code This field indicates if this add-on
charge is taxed.
T = Taxable
E = Exempt
CMC-TAX-CODE Alpha 10
Tax Code This field contains a code representing
the tax authorities this ship-to pays
sales tax to. This must be valid in the
Tax Code file.
CMC-TAX-AMT-CURR Signed 15.2
Tax Amt Curr This field contains the tax amount of
the add-on charge in billing currency.
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 Amt Base This field contains the tax amount of
add-on charge in company base currency.
CMC-ENT-TAXABLE Signed 15.2
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
Charge Type This field indicates whether the charge
is lump sum, unit price (per stock unit
of measure) or percent.
1 = Lump Sum
2 = Unit Price
3 = Percentage
CMC-ENT-UNIT-PRC Signed 13.5
Ent Unit Prc This field contains the unit price in
the order's currency.
CMC-UNIT-PRICE Signed 13.5
Unit Price This field contains the unit price of
the add-on charge in company base
currency. This is a flat monetary amount
or a per unit amount, depending on the
charge type.
CMC-PRICE-PCT Percent 5.3 (Percent)
Price Pct Price percent. This is the percent
applied to either the line net or order
net amount to calculate the amount to
charge for this add-on charge.
CMC-ENT-PRICE Signed 15.2
Ent Price This field contains the flat amount at
which the add-on charge is priced in
original billing currency.
CMC-PRICE Signed 15.2
Price This field contains the flat price
amount of the add-on charge in company
base currency.
CMC-UNIT-COST Signed 13.5
Unit Cost This field contains the cost amount of
the add-on charge as established in
BL09.1 (Add-on Charges). This can be
overridden, and is always in company
base currency. Enter a flat monetary
cost amount or a per unit cost,
depending on the charge type.
CMC-COST-PCT Percent 5.3 (Percent)
Cost Pct This field contains the cost percent,
which is applied to the add-on charge
resulting in the cost for the line. If
the add-on charge is added to the
header, this is the percent applied to
the order amount to arrive at the cost
of this charge.
CMC-COST Signed 11.2
Cost This field contains the cost tied to
the add-on charge in BL09.1 (Add-on
Charges), if the charge is the flat
type.
CMC-BILLED-CURR Signed 15.2
Billed Curr This field contains the amount billed
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 Base This field contains the amount billed
to the customer for this add-on charge
in company base currency.
CMC-ACTIVITY Alpha 15
Activity In this file the Activity field is used
for revenue (sales) postings whereas the
Activity-C field is used for Cost (COGS)
postings.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
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-CATEGORY Alpha 5
Account Category In this file the Acct-Category field is
used for revenue (sales) postings
whereas the Acct-Categ-C field is used
for Cost (COGS) postings.
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.
CMC-ATN-OBJ-ID Numeric 12
Atn Object ID Represents Activity Management object
ID for the revenue (sales) Activity.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
CMC-ACTIVITY-C Alpha 15
Activity C In this file the Activity-C field is
used for Cost (COGS) postings whereas
the Activity field is used for revenue
(sales) postings.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
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
Acct Categ C In this file the Acct-Categ-C field is
used for Cost (COGS) postings whereas
the Acct-Category field is used for
revenue (sales) postings.
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.
CMC-ATN-OBJ-ID-C Numeric 12
Atn Obj Id C The system defined object id
representing the Activity Management
commitment for Cost (COGS).
CMC-SLS-ACCT-UNIT Alpha 15
Sales Accounting This field contains the sales account
Unit unit that is credited when the add-on
charge is assessed. This defaults from
BL09.1 (Add-on Charges).
CMC-SLS-ACCOUNT Numeric 6
Sales Account This field contains the general ledger
account number that is credited when the
add-on charge is assessed. This defaults
from BL09.1 (Add-on Charges).
CMC-SLS-SUB-ACCT Numeric 4
Sales Subaccount This field contains the general ledger
subaccount that is credited when the
add-on charge is assessed. This defaults
from the add-on charge set up in the
Billing system.
CMC-OFF-ACCT-UNIT Alpha 15
Offset Account Unit This field contains the general ledger
account unit that is credited as an
offset to the cost of goods sold when
assessing a charge.
CMC-OFF-ACCOUNT Numeric 6
Offset Account This field contains the general ledger
account number that is credited as an
offset to the cost of goods sold when
the add-on charge is assessed. This
defaults from the add-on charge set up
in the Billing system.
CMC-OFF-SUB-ACCT Numeric 4
Offset Subaccount This field contains the general ledger
subaccount that is credited as an offset
to the cost of goods sold. This defaults
from the add-on charge set up in the
Billing system.
CMC-CGS-ACCT-UNIT Alpha 15
Cost Of Goods Sold This field contains the general ledger
Acct Unit account unit of the cost of goods that
is debited when the add-on charge is
assessed. This defaults from the add-on
charge set up in the Billing system.
CMC-CGS-ACCOUNT Numeric 6
Cost Of Goods Sold Cost of goods sold general ledger
Account account number to be debited when the
add-on charge is assessed. Defaults from
the add-on charge set up in the Billing
system.
CMC-CGS-SUB-ACCT Numeric 4
Cost Of Goods Sold This field contains the general ledger
Sub Account subaccount number of the cost of goods
sold that is debited when the add-on
charge is assessed. This defaults from
the add-on charge set up in the Billing
system.
CMC-SHIPMENT-NBR Numeric 10
Shipment Number This field contains the shipment
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
Book To Sa Fl This field indicates if this charge
line is updated to the Sales Analysis
system.
Y = Yes
N = No
CMC-PROD-TAX-CAT Alpha 15
Product Tax Category A classification of items for
determining taxes using the VERTEX
system in Lawson Order Entry system or
the cash receipts programs in the Lawson
Cash Ledger system.
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 Amt 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.
COMISC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMCSET1 COMPANY
ORDER-NBR
LINE-NBR
SEQ
CMCSET3 COMPANY Subset
ORDER-NBR Where AOC-CODE != Spaces
LINE-NBR And STATUS != 8
AOC-CODE
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
ORDER-NBR
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
CMCSET7 COMPANY This index was created as a solution to
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
|
