COMISC – Customer Order Miscellaneous

System
OE (OE)
Prefix
CMC
Primary key
COMPANY, ORDER-NBR, LINE-NBR, SEQ
Fields
65
Updated by
1 program
Referenced by
0 programs

COMISC is the Customer Order Miscellaneous table in Lawson OE (prefix CMC). It is indexed by COMPANY, ORDER-NBR, LINE-NBR, SEQ (CMCSET1); alternate indexes: CMCSET3, CMCSET4, CMCSET5, CMCSET6 and CMCSET7. It is related 1:1 to GLMASTER, COLINE, COSGBLK, CUCODES, CUSTORDER, OEMISC and TXTAXCODE. It is updated by WH20.7. The table has 65 fields, 6 indexes and 9 documented relations.

About COMISC

No description in the Lawson data dictionary.

Fields (65)

Column = COBOL field name without the CMC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CMC-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
ORDER_NBR		Numeric 8Each 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 PK
LINE_NBR		Numeric 6This 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 PK
SEQ		Numeric 3This field contains the number of the add-on charge tied to the line on an order.WH20.7
#CMC-MISC
MISC		Alpha 16This 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 SET3
AOC_CODE		Alpha 2This 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
CURRENCY_CODE		Alpha 5This field contains the currency code defined to the add-on charge in BL09.1 (Add-on Charges).WH20.7
#CMC-STATUS
STATUS		Numeric 1This 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
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
ORD_DISC_FL		Alpha 1This 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
UPD_SA_FL		Alpha 1This 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
BOOKED_DATE		Numeric 8 (yyyymmdd)This field contains the date this add-on charge was booked in the Sales Analysis system.—
#CMC-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1This field indicates if this add-on charge is taxed.
  • T Taxable
  • E Exempt
WH20.7
#CMC-TAX-CODE SET6
TAX_CODE		Alpha 10This 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
TAX_AMT_CURR		Signed 18.2This field contains the tax amount of the add-on charge in billing currency.WH20.7
#CMC-MULT-TAX-AMT
MULT_TAX_AMT		DerivedThis field contains the multiplier used to convert foreign currency to the base amount of tax.—
#CMC-DIV-TAX-AMT
DIV_TAX_AMT		DerivedThis field contains the divider used to convert foreign currency to the base amount of tax.—
#CMC-TAX-AMT-BASE
TAX_AMT_BASE		DerivedThis field contains the tax amount of add-on charge in company base currency.—
#CMC-ENT-TAXABLE
ENT_TAXABLE		Signed 18.2This 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
MULT_TAXABLE		DerivedThis 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
DIV_TAXABLE		DerivedThis 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
TAXABLE_BASE		DerivedThis field contains the taxable amount of the add-on charge in company base currency.—
#CMC-CHARGE-TYPE
CHARGE_TYPE		Numeric 1This 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
ENT_UNIT_PRC		Signed 18.5This field contains the unit price in the order's currency.WH20.7
#CMC-UNIT-PRICE
UNIT_PRICE		Signed 18.5This 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
PRICE_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
ENT_PRICE		Signed 18.2This field contains the flat amount at which the add-on charge is priced in original billing currency.WH20.7
#CMC-PRICE
PRICE		Signed 18.2This field contains the flat price amount of the add-on charge in company base currency.WH20.7
#CMC-UNIT-COST
UNIT_COST		Signed 18.5This 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
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
COST		Signed 18.5This 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
BILLED_CURR		Signed 18.2This field contains the amount billed to the customer for this add-on charge in original currency.—
#CMC-MULT-BILLED
MULT_BILLED		DerivedThis 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
DIV_BILLED		DerivedThis 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
BILLED_BASE		DerivedThis field contains the amount billed to the customer for this add-on charge in company base currency.—
#CMC-ACTIVITY
ACTIVITY		Alpha 15In 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
ACCT_CATEGORY		Alpha 5In 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 SET4
ATN_OBJ_ID		Numeric 12Represents 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
ACTIVITY_C		Alpha 15In 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
ACCT_CATEG_C		Alpha 5In 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 SET5
ATN_OBJ_ID_C		Numeric 12The system defined object id representing the Activity Management commitment for Cost (COGS).WH20.7
#CMC-SLS-ACCT-UNIT
SLS_ACCT_UNIT		Alpha 15This 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
SLS_ACCOUNT		Numeric 6This 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
SLS_SUB_ACCT		Numeric 4This 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
OFF_ACCT_UNIT		Alpha 15This 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
OFF_ACCOUNT		Numeric 6This 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
OFF_SUB_ACCT		Numeric 4This 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
CGS_ACCT_UNIT		Alpha 15This 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
CGS_ACCOUNT		Numeric 6Cost 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
CGS_SUB_ACCT		Numeric 4This 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
SHIPMENT_NBR		Numeric 10This 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
BOOK_TO_SA_FL		Alpha 1This field indicates if this charge line is updated to the Sales Analysis system.
  • Y Yes
  • N No
—
#CMC-PROD-TAX-CAT SET6
PROD_TAX_CAT		Alpha 15A 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
ORD_PCT_AMT		DerivedThis 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
ORD_PCT_CURR		DerivedThis 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
LINE_PCT_AMT		DerivedThis field contains the amount to bill if attached to an order line.—
#CMC-LINE-PCT-CURR
LINE_PCT_CURR		DerivedThis 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
UNIT_AMOUNT		DerivedThis 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
UNIT_AMT_CURR		DerivedThis 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
PRT_PRICE		DerivedThis field contains the unit amount that is billed for the add-on charge line.—
#CMC-PRT-PRC-CURR
PRT_PRC_CURR		DerivedThis field contains the unit amount that is billed for the add-on charge line in billing currency.—
#CMC-UNBILLED-AMT
UNBILLED_AMT		DerivedThis field contains the amount remaining to be billed.—
#CMC-UNBILLED-CURR
UNBILLED_CURR		DerivedThis field contains the amount remaining to be billed in billing currency.—
#CMC-PER-UNIT-FL
PER_UNIT_FL		DerivedThis field indicates if the add-on charge is a per unit type.—
#CMC-TRACK-TYPE
TRACK_TYPE		Alpha 1" " = Other AOC
  • I Insurance
  • F Freight
  • C Customs Charges
WH20.7

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CMCSET1
  1. COMPANY
  2. ORDER-NBR
  3. LINE-NBR
  4. SEQ
PrimaryWH20.2, WH20.7
CMCSET3
  1. COMPANY
  2. ORDER-NBR
  3. LINE-NBR
  4. AOC-CODE
SubsetWhere AOC-CODE != Spaces And STATUS != 8WH20.2, WH20.7
CMCSET4
  1. ATN-OBJ-ID
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—
CMCSET5
  1. ATN-OBJ-ID-C
KeyChange, SubsetWhere ATN-OBJ-ID-C != Zeroes—
CMCSET6
  1. COMPANY
  2. ORDER-NBR
  3. TAX-CODE
  4. PROD-TAX-CAT
  5. LINE-NBR
  6. SEQ
KeyChangeWH20.2, WH20.7
CMCSET7
  1. COMPANY
  2. ORDER-NBR
  3. SEQ
  4. LINE-NBR
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERCOLINECOSGBLKCUCODESCUSTORDEROEMISCTXTAXCODECOMISC

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Cgs AccountGLMASTERRequiredWhen 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
ColineCOLINERequiredWhen CMC-LINE-NBR != Zeroes
CMC-COMPANY→COL-COMPANY
CMC-ORDER-NBR→COL-ORDER-NBR
CMC-LINE-NBR→COL-LINE-NBR
CosgblkCOSGBLKNot Required
CMC-COMPANY→OSG-COMPANY
CMC-ORDER-NBR→OSG-ORDER-NBR
CMC-LINE-NBR→OSG-LINE-NBR
CMC-SEQ→OSG-SEQ
CucodesCUCODESRequired
CMC-CURRENCY-CODE→CUC-CURRENCY-CODE
CustorderCUSTORDERRequired
CMC-COMPANY→COR-COMPANY
CMC-ORDER-NBR→COR-ORDER-NBR
OemiscOEMISCRequired
CMC-COMPANY→OEM-COMPANY
CMC-MISC→OEM-MISC
CMC-CURRENCY-CODE→OEM-CURRENCY-CODE
Off AccountGLMASTERRequiredWhen 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 AccountGLMASTERRequiredWhen 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
TxtaxcodeTXTAXCODENot Required
CMC-COMPANY→TAC-COMPANY
CMC-TAX-CODE→TAC-TAX-CODE

Programs

Updated by (1)