COMISC

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
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.
CMC-TRACK-TYPE
Element: Aoc Type
Alpha 1

" " = Other AOC
I = Insurance
F = Freight
C = Customs Charges
WH20.7


COMISC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMCSET1 COMPANY
ORDER-NBR
LINE-NBR
SEQ
WH20.2 WH20.7
CMCSET3 COMPANY
ORDER-NBR
LINE-NBR
AOC-CODE
Subset
WhereAOC-CODE !=Spaces
AndSTATUS !=8
WH20.2 WH20.7
CMCSET4 ATN-OBJ-ID
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes
CMCSET5 ATN-OBJ-ID-C
KeyChange, Subset
WhereATN-OBJ-ID-C !=Zeroes
CMCSET6 COMPANY
ORDER-NBR
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
KeyChange
WH20.2 WH20.7
CMCSET7 COMPANY
ORDER-NBR
SEQ
LINE-NBR


COMISC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cgs Account GLMASTER Required
When CMC-CGS-ACCT-UNIT !=Spaces
OrCMC-CGS-ACCOUNT !=Zeroes
OrCMC-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
OrCMC-OFF-ACCOUNT !=Zeroes
OrCMC-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
OrCMC-SLS-ACCOUNT !=Zeroes
OrCMC-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


File created: Thu Jun 09 02:24:26 2016

Home
Contact Us



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