|
|
COMISC FILE
Customer Order Miscellaneous
The Customer Order Miscellaneous file stores add-on charges attached to
orders or order lines.
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
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
WH20.7
CMC-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr 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
WH20.7
CMC-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr 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
WH20.7
CMC-SEQ Numeric 3 BL120 BL122
Element: Seq This 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
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
WH20.7
CMC-AOC-CODE Alpha 2 BL120 BL122
Element: Aoc Code This 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. 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
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 WH20.7
9 = Ready For Purge
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
WH20.7
CMC-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Ord Disc Fl This 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 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
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 Cd This 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
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
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
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 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
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
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
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
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
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, WH20.7
depending on the charge type.
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 WH20.7
of this charge.
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
WH20.7
CMC-BILLED-CURR Signed 18.2
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 WH20.7
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 BL120 BL122
Element: Acct Category In 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 WH20.7
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 BL120 BL122
Element: Obj Id Represents Activity Management object BL130 BL20.1
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, WH20.7
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 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 WH20.7
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 BL120 BL122
Element: Acct Category In 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 WH20.7
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 BL120 BL122
Element: Obj Id The system defined object id BL130 BL20.1
representing the Activity Management BL20.3 BL21.2
commitment for Cost (COGS). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
CMC-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This 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
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
WH20.7
CMC-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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
WH20.7
CMC-OFF-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This 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
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. WH20.7
CMC-OFF-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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
WH20.7
CMC-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This 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
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
WH20.7
CMC-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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. WH20.7
CMC-SHIPMENT-NBR Numeric 10
Element: Shipment Nbr 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
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: Prod Tax Cat A 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
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
WH20.2 WH20.7
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
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 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
WH20.2 WH20.7
CMCSET7 COMPANY
ORDER-NBR
SEQ
LINE-NBR
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
|
