|
|
COMISC FILE
Customer Order Miscellaneous
The Customer Order Miscellaneous file stores add-on charges attached to
orders or order lines.
UPDATED BY
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMC-COMPANY Numeric 4 WH20.7
Element: Company The company number represents an
established company and is entered on
all function codes.
CMC-ORDER-NBR Numeric 8 WH20.7
Element: 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 WH20.7
Element: 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 WH20.7
Element: Sequence NumbeThis field contains the number of the
add-on charge tied to the line on an
order.
CMC-MISC Alpha 16 WH20.7
Element: 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 WH20.7
Element: Add On Cost CoThis 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 WH20.7
Element: Currency Code This field contains the currency code
defined to the add-on charge in BL09.1
(Add-on Charges).
CMC-STATUS Numeric 1 WH20.7
Element: 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) WH20.7
Element: 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 WH20.7
Element: Order DiscountThis 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 WH20.7
Element: All Flag 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)
Element: Date This field contains the date this
add-on charge was booked in the Sales
Analysis system.
CMC-TAX-EXEMPT-CD Alpha 1 WH20.7
Element: Tax Exempt CodThis field indicates if this add-on
charge is taxed.
T = Taxable
E = Exempt
CMC-TAX-CODE Alpha 10 WH20.7
Element: 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 WH20.7
Element: Adj Amt This field contains the tax amount of
the add-on charge in billing currency.
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 15.2
Element: Item Tax 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 WH20.7
Element: 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 WH20.7
Element: Base Price This field contains the unit price in
the order's currency.
CMC-UNIT-PRICE Signed 13.5 WH20.7
Element: Base 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) WH20.7
Element: Cost 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 WH20.7
Element: Price This field contains the flat amount at
which the add-on charge is priced in
original billing currency.
CMC-PRICE Signed 15.2 WH20.7
Element: Price This field contains the flat price
amount of the add-on charge in company
base currency.
CMC-UNIT-COST Signed 13.5 WH20.7
Element: Base 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) WH20.7
Element: 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 WH20.7
Element: 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
Element: Current Cash 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 WH20.7
Element: 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 WH20.7
Element: Account CategoIn 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 WH20.7
Object Represents Activity Management object
Identification 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 WH20.7
Element: Activity 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 WH20.7
Element: Account CategoIn 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 WH20.7
Object The system defined object id
Identification representing the Activity Management
commitment for Cost (COGS).
CMC-SLS-ACCT-UNIT Alpha 15 WH20.7
Element: Accounting UniThis field contains the sales account
unit that is credited when the add-on
charge is assessed. This defaults from
BL09.1 (Add-on Charges).
CMC-SLS-ACCOUNT Numeric 6 WH20.7
Element: 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 WH20.7
Element: 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 WH20.7
Element: Accounting UniThis 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 WH20.7
Element: 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 WH20.7
Element: 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 WH20.7
Element: Accounting UniThis field contains the general ledger
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 WH20.7
Element: Account Cost of goods sold general ledger
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 WH20.7
Element: Subaccount This field contains the general ledger
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
Element: Shipment NumbeThis 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
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 WH20.7
Element: Product Tax CaA 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
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 WH20.2 WH20.7
ORDER-NBR
LINE-NBR
SEQ
CMCSET3 COMPANY Subset WH20.2 WH20.7
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 WH20.2 WH20.7
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
|
