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. |
|
||
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. |
|
||
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. |
|
||
CMC-SEQ Element: Seq | Numeric 3 This field contains the number of the add-on charge tied to the line on an order. |
|
||
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. |
|
||
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. |
|
||
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). |
|
||
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 |
|
||
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). |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
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. |
|
||
CMC-TAX-AMT-CURR Element: Intl Amt | Signed 18.2 This field contains the tax amount of the add-on charge in billing currency. |
|
||
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 |
|
||
CMC-ENT-UNIT-PRC Element: Intl Cost | Signed 18.5 This field contains the unit price in the order's currency. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
CMC-PRICE Element: Intl Amt | Signed 18.2 This field contains the flat price amount of the add-on charge in company base currency. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
CMC-ATN-OBJ-ID-C Element: Obj Id | Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS). |
|
||
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). |
|
||
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). |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CMCSET1 |
COMPANY ORDER-NBR LINE-NBR SEQ |
|
| ||||||||||||||||||||
CMCSET3 |
COMPANY ORDER-NBR LINE-NBR AOC-CODE |
|
| ||||||||||||||||||||
CMCSET4 |
ATN-OBJ-ID |
|
|||||||||||||||||||||
CMCSET5 |
ATN-OBJ-ID-C |
|
|||||||||||||||||||||
CMCSET6 |
COMPANY ORDER-NBR TAX-CODE PROD-TAX-CAT LINE-NBR SEQ |
|
| ||||||||||||||||||||
CMCSET7 |
COMPANY ORDER-NBR SEQ LINE-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cgs Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Coline | COLINE |
Required
| ||||||||||||||||||||||||||||||
Cosgblk | COSGBLK |
Not Required
| ||||||||||||||||||||||||||||||
Cucodes | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Custorder | CUSTORDER |
Required
| ||||||||||||||||||||||||||||||
Oemisc | OEMISC |
Required
| ||||||||||||||||||||||||||||||
Off Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Sales Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Txtaxcode | TXTAXCODE |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.