Customer Order Miscellaneous

The Customer Order Miscellaneous file stores add-on charges attached to orders or order lines.
UPDATED BY

WH20.2

WH20.7

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CMC-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	WH20.7
CMC-ORDER-NBR Element: Order Nbr	Numeric 8 Each order is assigned a unique number. Order numbers are either manually assigned or system assigned based on a company-level option.	WH20.7
CMC-LINE-NBR Element: Line Nbr	Numeric 6 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.	WH20.7
CMC-SEQ Element: Seq	Numeric 3 This field contains the number of the add-on charge tied to the line on an order.	WH20.7
CMC-MISC Element: Misc	Alpha 16 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.	WH20.7
CMC-AOC-CODE Element: Aoc Code	Alpha 2 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.	WH20.7
CMC-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the currency code defined to the add-on charge in BL09.1 (Add-on Charges).	WH20.7
CMC-STATUS Element: Status	Numeric 1 This field contains the status of the add-on charge. 0 = Unreleased 1 = Released 2 = Shipped 8 = Cancelled 9 = Ready For Purge	WH20.7
CMC-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field contains the description of the add-on charge as defined in BL09.1 (Add-on Charges).	WH20.7
CMC-ORD-DISC-FL Element: Ord Disc Fl	Alpha 1 This field indicates whether this add-on charge is included when calculating the discount amount of the order. Y = Yes N = No	WH20.7
CMC-UPD-SA-FL Element: All Flag	Alpha 1 This field indicates whether this add-on charge is updated into the Sales Analysis system for reporting purposes. Y = Yes N = No	WH20.7
CMC-BOOKED-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the date this add-on charge was booked in the Sales Analysis system.
CMC-TAX-EXEMPT-CD Element: Tax Exempt Cd	Alpha 1 This field indicates if this add-on charge is taxed. T = Taxable E = Exempt	WH20.7
CMC-TAX-CODE Element: Tax Code	Alpha 10 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.	WH20.7
CMC-TAX-AMT-CURR Element: Intl Amt	Signed 18.2 This field contains the tax amount of the add-on charge in billing currency.	WH20.7
CMC-MULT-TAX-AMT Element: Mult Tax Amt	Derived This field contains the multiplier used to convert foreign currency to the base amount of tax.
CMC-DIV-TAX-AMT Element: Div Tax Amt	Derived This field contains the divider used to convert foreign currency to the base amount of tax.
CMC-TAX-AMT-BASE Element: Tax Amt Base	Derived This field contains the tax amount of add-on charge in company base currency.
CMC-ENT-TAXABLE Element: Intl Amt	Signed 18.2 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 Element: Mult Taxable	Derived 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 Element: Div Taxable	Derived 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 Element: Taxable Base	Derived This field contains the taxable amount of the add-on charge in company base currency.
CMC-CHARGE-TYPE Element: Charge Type	Numeric 1 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	WH20.7
CMC-ENT-UNIT-PRC Element: Intl Cost	Signed 18.5 This field contains the unit price in the order's currency.	WH20.7
CMC-UNIT-PRICE Element: Intl Cost	Signed 18.5 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.	WH20.7
CMC-PRICE-PCT Element: Cost Pct	Percent 5.3 (Percent) 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.	WH20.7
CMC-ENT-PRICE Element: Intl Amt	Signed 18.2 This field contains the flat amount at which the add-on charge is priced in original billing currency.	WH20.7
CMC-PRICE Element: Intl Amt	Signed 18.2 This field contains the flat price amount of the add-on charge in company base currency.	WH20.7
CMC-UNIT-COST Element: Intl Cost	Signed 18.5 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.	WH20.7
CMC-COST-PCT Element: Cost Pct	Percent 5.3 (Percent) 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.	WH20.7
CMC-COST Element: Intl Cost	Signed 18.5 This field contains the cost tied to the add-on charge in BL09.1 (Add-on Charges), if the charge is the flat type.	WH20.7
CMC-BILLED-CURR Element: Intl Amt	Signed 18.2 This field contains the amount billed to the customer for this add-on charge in original currency.
CMC-MULT-BILLED Element: Mult Billed	Derived 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 Element: Div Billed	Derived 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 Element: Billed Base	Derived This field contains the amount billed to the customer for this add-on charge in company base currency.
CMC-ACTIVITY Element: Activity	Alpha 15 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.	WH20.7
CMC-ACCT-CATEGORY Element: Acct Category	Alpha 5 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.	WH20.7
CMC-ATN-OBJ-ID Element: Obj Id	Numeric 12 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.	WH20.7
CMC-ACTIVITY-C Element: Activity	Alpha 15 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.	WH20.7
CMC-ACCT-CATEG-C Element: Acct Category	Alpha 5 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.	WH20.7
CMC-ATN-OBJ-ID-C Element: Obj Id	Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS).	WH20.7
CMC-SLS-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the sales account unit that is credited when the add-on charge is assessed. This defaults from BL09.1 (Add-on Charges).	WH20.7
CMC-SLS-ACCOUNT Element: Account	Numeric 6 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).	WH20.7
CMC-SLS-SUB-ACCT Element: Sub Acct	Numeric 4 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.	WH20.7
CMC-OFF-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the general ledger account unit that is credited as an offset to the cost of goods sold when assessing a charge.	WH20.7
CMC-OFF-ACCOUNT Element: Account	Numeric 6 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.	WH20.7
CMC-OFF-SUB-ACCT Element: Sub Acct	Numeric 4 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.	WH20.7
CMC-CGS-ACCT-UNIT Element: Acct Unit	Alpha 15 This 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.	WH20.7
CMC-CGS-ACCOUNT Element: Account	Numeric 6 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.	WH20.7
CMC-CGS-SUB-ACCT Element: Sub Acct	Numeric 4 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.	WH20.7
CMC-SHIPMENT-NBR Element: Shipment Nbr	Numeric 10 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 Element: All Flag	Alpha 1 This field indicates if this charge line is updated to the Sales Analysis system. Y = Yes N = No
CMC-PROD-TAX-CAT Element: Prod Tax Cat	Alpha 15 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.	WH20.7
CMC-ORD-PCT-AMT Element: Ord Pct Amt	Derived 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 Element: Ord Pct Curr	Derived 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 Element: Line Pct Amt	Derived This field contains the amount to bill if attached to an order line.
CMC-LINE-PCT-CURR Element: Line Pct Curr	Derived 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 Element: Unit Amount	Derived 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 Element: Unit Amt Curr	Derived 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 Element: Prt Price	Derived This field contains the unit amount that is billed for the add-on charge line.
CMC-PRT-PRC-CURR Element: Prt Prc Curr	Derived This field contains the unit amount that is billed for the add-on charge line in billing currency.
CMC-UNBILLED-AMT Element: Unbilled Amt	Derived This field contains the amount remaining to be billed.
CMC-UNBILLED-CURR Element: Unbilled Curr	Derived This field contains the amount remaining to be billed in billing currency.
CMC-PER-UNIT-FL Element: Per Unit Fl	Derived This field indicates if the add-on charge is a per unit type.

COMISC FILE INDEX

COMISC FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.