COLINE – Customer Order Line

System: OE (OE)
Prefix: COL
Primary key: COMPANY, ORDER-NBR, LINE-NBR
Fields: 168
Updated by: 231 programs
Referenced by: 13 programs

COLINE is the Customer Order Line table in Lawson OE (prefix COL). It is indexed by COMPANY, ORDER-NBR, LINE-NBR (COLSET1); alternate indexes: COLSET10, COLSET11, COLSET12, COLSET13, COLSET2, COLSET3, COLSET4, COLSET5 and 4 more. It is related 1:1 to APCOMPANY, APVENMAST, ARCOMP, ARCUSTOMER, GLMASTER, COLINEUOM, OEPRCLIST, COSGBLK and 27 more and 1:M to COMISC, ITEMSUB, COMPONENT, ITEMLOC, ITSERIAL, OEAUDIT, OEORDCMNT, POLINESRC and 6 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 223 more and referenced by CX05.1, CX05.2, CX805, RQIC.1, RQID.1, RQIG.1, WH126, WH210 and 5 more. The table has 168 fields, 13 indexes and 61 documented relations.

About COLINE

Customer order line information is stored in this file. There are three possible types of lines that can be stored here: inventory, nonstock, and special items. During processing, totals are kept here, for example, the total quantity ordered, allocated, printed, picked, packed and shipped. The quantity shipped on a specific shipment is kept in the Order Entry Shipment Line file.

Fields (168)

Column = COBOL field name without the COL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`COL-COMPANY` PK 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
`COL-ORDER-NBR` PK 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
`COL-LINE-NBR` PK LINE_NBR	Numeric 6	This field displays the line number of the transaction number.	WH20.7
`COL-STATUS` STATUS	Numeric 1	This field indicates the status of this line on the order. `0` Needs clean-up `1` Unreleased `2` Released `8` Canceled `9` Ready for delete	WH20.7, WH22.1, WHD2.1
`COL-FUTURE-FL` FUTURE_FL	Alpha 1	This field indicates if this line has a future status. `Y` Yes `N` No	WH20.7
`COL-SALES-MAJCL` SALES_MAJCL	Alpha 4	This field contains the major sales class code.	WH20.7
`COL-SALES-MINCL` SALES_MINCL	Alpha 4	This field contains the minor sales class code within the major class.	WH20.7
`COL-ITEM` ITEM	Alpha 32	This field contains the item identifier.	WH20.7
`COL-ITEM-DESC` ITEM_DESC	Alpha 30	This field contains the description for stock and non-stock items.	WH20.7, WH222
`COL-LINE-TYPE` LINE_TYPE	Alpha 1	The line type can be entered. Valid values are: . `I` Inventoried. Default value. `N` Non-stock. `X` Special order.	WH20.7
`COL-ORIG-LINE` ORIG_LINE	Numeric 4	This field contains the original line number if it was overridden.	WH20.7
`COL-ORIG-ITEM` ORIG_ITEM	Alpha 32	This field contains the original item number if it was overridden.	WH20.7
`COL-ORIG-FL` ORIG_FL	Alpha 1	This field indicates whether this line was created as a result of item replacement or substitution. `R` Replacement line `S` Substitute line	WH20.7
`COL-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	WH20.7
`COL-CUST-ITEM-FL` CUST_ITEM_FL	Alpha 1	This field indicates whether the number entered in the order line represents an item set up in the Order Entry Customer file. `C` Customer item was entered	WH20.7
`COL-CUST-ITEM` CUST_ITEM	Alpha 32	This field contains the customer's item number.	WH20.7
`COL-KIT-FL` KIT_FL	Alpha 1	This field indicates when the item ordered is a made-to-order kit. `N` Not a kit `O` Make to order kit `S` Make to stock kit	WH20.7
`COL-KIT-ALLOC-FL` KIT_ALLOC_FL	Alpha 1	This field indicates whether the kit has been allocated. `0` Kit allocated `1` Kit needs options chosen	WH20.7
`COL-HOLD-CODE` HOLD_CODE	Alpha 4	If the line is on hold, this field contains the hold code. Hold codes are set up in Accounts Receivable.	WH20.7
`COL-INV-LOC` INV_LOC	Alpha 5	This field contains a valid stocking location within the company inventory.	WH20.7
`COL-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	This field contains the process level, which is the reporting hierarchy below company. The process level determines which general ledger account the order's invoice debits when its rate updates to Accounts Receivable.	WH20.7
`COL-SPR-UOM` SPR_UOM	Alpha 4	This field contains the pricing unit of measure. This must be a valid pricing unit of measure for the item if the line is not a special order line.	WH20.7
`COL-SELL-UOM` SELL_UOM	Alpha 4	This field contains the stock unit of measure for the item. If entered, it must be a valid stock unit of measure for this line's item. If not entered, the default stock unit of measure for this line's item is assigned.	WH126, WH20.7
`COL-SEC-UOM` SEC_UOM	Alpha 4	This field contains the secondary quantity unit of measure. This is used only when the item is a catch weight item.	WH20.7
`COL-NO-CHARGE-FL` NO_CHARGE_FL	Alpha 1	This field indicates the item's price is zero. This defaults to No. If set to Yes, this field prevents the system from pricing the item. No charge invoices are not to be passed to Accounts Receivable for collection. `N` No `Y` Yes	WH20.7
`COL-RATE-OVR-FL` RATE_OVR_FL	Alpha 1	This flag indicates whether the currency conversion rate was overridden for this line of the order. `Y` Yes `N` No	WH20.7
`COL-PRICE-STATUS` PRICE_STATUS	Alpha 1	This field indicates how the line was priced. `A` Amalgamated (group) pricing `C` System calculated pricing `O` Price override	WH20.7
`COL-PRICE-DATE` PRICE_DATE	Numeric 8 (yyyymmdd)	This field contains the date used to price the line. The system date defaults when the line is added.	WH20.7
`COL-ENTERED-PRICE` ENTERED_PRICE	Signed 18.5	This field contains the unit price in the currency of the order.	WH20.7
`COL-UNIT-PRICE` UNIT_PRICE	Signed 18.5	This field contains the unit price in base currency. This is an amount per stock unit of measure.	WH20.7
`COL-SELL-UNIT-PRC` SELL_UNIT_PRC	Signed 18.5	This field contains the price per sell unit of measure in base currency. If multiple unit of measure pricing is used, this is the weighted average price per sell unit of measure.	WH20.7
`COL-SELL-PRC-CURR` SELL_PRC_CURR	Signed 18.5	This field contains the price per sell unit of measure in transaction currency. If multiple unit of measure pricing is used, this is the weighted average price per sell unit of measure.	WH20.7
`COL-UNIT-COST` UNIT_COST	Signed 18.5	—	WH20.7
`COL-DISC-AMT-CURR` DISC_AMT_CURR	Signed 18.2	This field contains the discount amount in transaction currency.	WH20.7
`COL-MULT-DISC-AMT` MULT_DISC_AMT	Derived	This field contains the discount amount in base currency if a multiplier is used when converting from original to base currency.	—
`COL-DIV-DISC-AMT` DIV_DISC_AMT	Derived	This field contains the discount amount in base currency if a divider is used when converting from original to base currency.	—
`COL-DISC-AMT-BASE` DISC_AMT_BASE	Derived	This field contains the discount amount in base currency.	—
`COL-DISC-CODE` DISC_CODE	Alpha 10	This field contains the discount code used to calculate the discount amount for this line.	WH20.7
`COL-MULT-SPR-FL` MULT_SPR_FL	Alpha 1	— `Y` Yes `N` No	WH20.7
`COL-SPR-TO-STOCK` SPR_TO_STOCK	Signed 13.7	This field contains the multiplier used with special order items when converting from pricing unit of measure to stock unit of measure.	WH20.7
`COL-SELL-TO-STOCK` SELL_TO_STOCK	Signed 13.7	This field contains the multiplier that is used with special order items when converting from selling unit of measure to stock unit of measure.	WH20.7
`COL-SEC-TO-STOCK` SEC_TO_STOCK	Signed 13.7	This field contains the multiplier that is used with catch weight items when converting secondary unit of measure to stock unit of measure.	WH20.7
`COL-ORD-DISC-FL` ORD_DISC_FL	Alpha 1	This field indicates whether this line is eligible for an order discount. `Y` Yes `N` No	WH20.7
`COL-CUST-SHIP-TO` CUST_SHIP_TO	Numeric 4	This field contains the ship-to customer number. This defaults from the order header.	WH20.7
`COL-CREATE-PO` CREATE_PO	Alpha 1	This field indicates the item is ordered by a purchase order rather than using stock. `N` No `Y` Yes	WH20.7
`COL-DROPSHIP-FL` DROPSHIP_FL	Alpha 1	This field indicates whether the items of the purchase order are sent directly from the vendor to the customer. If this field is set to No, items are shipped to the user who entered the order for shipment to the customer. `N` No `Y` Yes	WH20.7
`COL-CARRIER` CARRIER	Alpha 9 (Right Justified)	This field contains the carrier number. This must be a valid vendor defined in Accounts Payable.	WH20.7
`COL-PO-NUMBER` PO_NUMBER	Alpha 14 (Right Justified)	This field contains the number representing the purchase order. This is used if the purchase order line is added to an existing purchase order.	WH20.7
`COL-PO-CODE` PO_CODE	Alpha 4	This is the purchase order code that will be used as part of the purchase order number for a create po order line.	WH20.7
`COL-VENDOR` VENDOR	Alpha 9 (Right Justified)	This field contains the vendor of the purchase order. If left blank, Purchase Order assigns a vendor to the purchase order.	WH20.7
`COL-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	The vendor's purchase from location.	WH20.7
`COL-IF-REF-NBR` IF_REF_NBR	Numeric 9	This field contains an internally generated reference number used by the Requisition system.	WH20.7
`COL-ROUTE` ROUTE	Numeric 4	This field contains the route number. If left blank, the route assigned to the ship-to customer defaults from the Order Entry Route file. If no route is assigned to the ship-to customer in the Order Entry Route file, the route defaults from the customer.	WH120, WH20.7, WH21.3, WH21.4
`COL-STOP` STOP	Numeric 4	This field contains the stop within the route. If left blank, this defaults from the ship-to customer from the Order Entry Route file. If no stop is associated with the ship-to customer, this defaults from the customer's file.	WH120, WH20.7, WH21.3, WH21.4
`COL-RTE-CREATE-FL` RTE_CREATE_FL	Alpha 1	— `Y` Yes `N` No	WH110, WH120, WH130, WH132, WH190, WH20.7, WH21.1, WH21.2 +29 more
`COL-EXP-DELIV-DT` EXP_DELIV_DT	Numeric 8 (yyyymmdd)	This field contains the expected delivery date. This field is valid only for a company that uses routes and stops. The expected delivery date is calculated by adding the ship days from the process level associated with the order to the system date when the order is added. This field determines when the order prints on the picking list for processing.	WH120, WH20.7, WH21.3, WH21.4
`COL-TERRITORY` TERRITORY	Alpha 4	This field contains the sales territory. If left blank, this defaults from the ship-to customer. If no sales territory is assigned to the ship-to customer, this defaults from the customer's file.	WH20.7
`COL-SALESMAN` SALESMAN	Numeric 4	This field contains the code that represents the primary sales representative of this line. This defaults from the order header.	WH20.7
`COL-SALESMAN-2` SALESMAN_2	Numeric 4	This field contains the code representing the second sales representative. This defaults from the order header.	WH20.7
`COL-COMM-SPLIT` COMM_SPLIT	Percent 5.3 (Percent)	Commission split for the second sales representative. This is the percentage of this line's total value the secondary sales representative's commission rate is applied to.	WH20.7
`COL-COMM-RATE-1` COMM_RATE_1	Percent 7.5 (Percent)	Commission rate for sales representative 1. Defaults from the sales representative file.	WH20.7
`COL-COMM-RATE-2` COMM_RATE_2	Percent 7.5 (Percent)	This field contains the commission rate for the second sales representative. This defaults from the sales representative file.	WH20.7
`COL-ENTERED-DISC` ENTERED_DISC	Signed 18.2	This field contains a per line discount rather than a per unit discount as entered in the order-line's billing currency.	WH20.7
`COL-MULT-ADD-DISC` MULT_ADD_DISC	Derived	This field contains the add-on discount amount in base currency if a multiplier is used to convert from original to base currency.	—
`COL-DIV-ADD-DISC` DIV_ADD_DISC	Derived	This field contains the additional discount amount in base currency if a divider is used to convert from original to base currency.	—
`COL-ADD-DISC-BASE` ADD_DISC_BASE	Derived	This field contains the additional discount amount in base currency.	—
`COL-DISC-TKN-CURR` DISC_TKN_CURR	Signed 18.2	This field contains the amount of the additional discount that has been used by invoices for this order line in billing currency. If you need to lower an additional discount on the line, the amount cannot be lowered below amount found in this field for this line.	WH20.7
`COL-MULT-DISC-TKN` MULT_DISC_TKN	Derived	This field contains the multiplier used to derive the base currency amount of the discount if the order or invoice is entered in foreign currency.	—
`COL-DIV-DISC-TKN` DIV_DISC_TKN	Derived	This field contains the multiplier used to derive the base currency amount of the discount if the order or invoice is entered in foreign currency.	—
`COL-DISC-TKN-BASE` DISC_TKN_BASE	Derived	This field contains the amount of additional discount in base currency used by invoices for this order line.	—
`COL-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	This field contains the tax exempt code. This defaults from the order header. If the order header is tax exempt, the line is also tax exempt. `E` Exempt `T` Taxable	WH20.7
`COL-TAX-CODE` 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. If the company is not using a third-party tax system, this code is the tax code for the order line. Tax codes are entered in Tax and can be associated with the customer or entered when adding the order.	WH20.7
`COL-TAXABLE-CURR` TAXABLE_CURR	Signed 18.2	This field contains the taxable amount in billing currency.	WH20.2, WH20.7
`COL-MULT-TAXABLE` MULT_TAXABLE	Derived	This field contains the taxable amount in base currency if a multiplier is used to convert from original to base currency.	—
`COL-DIV-TAXABLE` DIV_TAXABLE	Derived	This field contains the taxable amount in base currency if a divider is used to convert from original to base currency.	—
`COL-OVR-TAXABLE` OVR_TAXABLE	Signed 18.2	This field contains the override taxable amount in base currency.	WH20.2, WH20.7
`COL-MULT-OVR-TXBL` MULT_OVR_TXBL	Derived	This field contains the override taxable amount in base currency if a multiplier is used to convert from original to base currency.	—
`COL-DIV-OVR-TXBL` DIV_OVR_TXBL	Derived	This field contains the override taxable amount in base currency if a divider is used to convert from original to base currency.	—
`COL-TAXABLE-BASE` TAXABLE_BASE	Derived	This field contains the override taxable amount in base currency.	—
`COL-EARLY-DL-DATE` EARLY_DL_DATE	Numeric 8 (yyyymmdd)	This field contains the early delivery date.	WH20.7
`COL-LATE-DL-DATE` LATE_DL_DATE	Numeric 8 (yyyymmdd)	This field contains the late delivery date.	WH20.7
`COL-USER-DATE-3` USER_DATE_3	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	WH20.7
`COL-USER-DATE-4` USER_DATE_4	Numeric 8 (yyyymmdd)	This field contains the fourth user-defined date. Informational purposes only used on Orders Not Shipped for Customer (OE280).	WH20.7
`COL-USER-FLD1` USER_FLD1	Alpha 2	This field contains the first user-definable field. If a purchase order is created for this order, this field updates to Purchase Order.	WH20.7
`COL-USER-FLD2` USER_FLD2	Alpha 30 (Lower Case)	This field contains the second user-definable field. If a purchase order is created for this order, this field updates to Purchase Order. This field also updates to Sales Analysis.	WH20.7
`COL-USER-FLD3` USER_FLD3	Alpha 15 (Lower Case)	This field contains the third user-definable field. If a purchase order is created for this order, this field updates to Purchase Order. This field also updates to Sales Analysis.	WH20.7
`COL-EXP-SHIP-DT` EXP_SHIP_DT	Numeric 8 (yyyymmdd)	Expected ship date. Defaulted by the system as the number of ship days (from process level record) beyond the system date when the line is added. May be overridden.	WH20.7
`COL-ALLOCATE-DT` ALLOCATE_DT	Numeric 8 (yyyymmdd)	This field contains the date used for batch allocations. The type of date depends on a company option, and can be the order date, the customer requested delivery date or the expected ship date.	WH20.7
`COL-LIST-NAME` LIST_NAME	Alpha 14	This field contains the name of the price list, if this line is priced using a price list or a promotion.	WH20.7
`COL-CONTRACT-NBR` CONTRACT_NBR	Alpha 14	This field contains the contract number, if this line is priced using a contract.	WH20.7
`COL-PROMOTION` PROMOTION	Alpha 10	This field contains the promotion name, if this line is priced via a promotion. When combined with the list name, it provides access to the promotion file.	WH20.7
`COL-ACTIVITY` ACTIVITY	Alpha 15	In this file the Activity field is used for the revenue (sales) side of the posting whereas the Activity-C field is used for the Cost (COGS) side of the posting. 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 Project Accounting. 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
`COL-ACCT-CATEGORY` 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 Project Accounting. 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 Account Assignment (AC07.1). 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
`COL-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	Represents Activity Management system 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. 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 inquiries.	WH20.7
`COL-ACTIVITY-C` ACTIVITY_C	Alpha 15	In this file the Activity-C field is used for the Cost (COGS) side of the posting whereas the Activity field is used for the revenue (sales) side of the posting. 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 Project Accounting. 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
`COL-ACCT-CATEG-C` ACCT_CATEG_C	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 Project Accounting. 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 Account Assignment (AC07.1). 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
`COL-ATN-OBJ-ID-C` ATN_OBJ_ID_C	Numeric 12	The system defined object id representing the Activity Management commitment for Cost (COGS).	AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`COL-BOOKED-FL` BOOKED_FL	Alpha 1	This field indicates if the order line has been booked by the Sales Analysis system.	WH20.7
`COL-BOOKED-DATE` BOOKED_DATE	Numeric 8 (yyyymmdd)	This field indicates the date when the order line was booked by Sales Analysis.	WH20.7
`COL-BOOKED-QTY` BOOKED_QTY	Signed 13.4	This field contains the quantity booked to the customer and sales representative totals. This is updated to Sales Analysis for reporting and inquiry analysis.	WH20.7
`COL-ORDER-QTY` ORDER_QTY	Signed 13.4	The order quantity of the line item.	WH130, WH132, WH190, WH20.7, WH520, WH830
`COL-SHIPPED-QTY` SHIPPED_QTY	Signed 13.4	This field contains the shipped quantity.	WH126, WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3 +27 more
`COL-INVOICE-QTY` INVOICE_QTY	Signed 13.4	This field contains the quantity that has been invoiced for this order line.	WH20.7
`COL-RETURNED-QTY` RETURNED_QTY	Signed 13.4	Total quantity returned compared to this quantity.	—
`COL-FIRM-FL` FIRM_FL	Alpha 1	This field indicates if the allocation is firm. If the value is set to Yes, WH110 (Batch Allocation) skips the record in the de-allocation phase. `Y` Yes `N` No	WH20.7
`COL-SHIP-COMP-FL` SHIP_COMP_FL	Alpha 1	—	WH20.7
`COL-PK-PRIORITY` PK_PRIORITY	Numeric 2	—	WH20.7
`COL-SLS-ACCT-UNIT` SLS_ACCT_UNIT	Alpha 15	This field contains the sales account unit, if the line is special order. If left blank, this defaults from the process level.	WH20.7
`COL-SLS-ACCOUNT` SLS_ACCOUNT	Numeric 6	This field contains the sales account number, if the line is for a special order item. If left blank, this defaults from the process level.	WH20.7
`COL-SLS-SUB-ACCT` SLS_SUB_ACCT	Numeric 4	This field contains the sales subaccount number, if the line is special order. If left blank, this defaults from the process level.	WH20.7
`COL-EXP-ACCT-UNIT` EXP_ACCT_UNIT	Alpha 15	This field contains the general ledger account to credit for the cost amount of non-stock and special orders. This defaults from the process level for special order lines and from the major/minor sales class file for non-stock lines.	WH20.7
`COL-EXP-ACCOUNT` EXP_ACCOUNT	Numeric 6	This field contains the general ledger distribution account that is credited for non-stock and special orders. This defaults from the process level for special orders and from major/minor sales class for non-stock orders.	WH20.7
`COL-EXP-SUB-ACCT` EXP_SUB_ACCT	Numeric 4	This field contains the general ledger distribution subaccount that is credited for non-stock and special orders. This defaults from the process level for special orders and from the major/minor sales class for non-stock orders.	WH20.7
`COL-CGS-ACCT-UNIT` CGS_ACCT_UNIT	Alpha 15	The cost of goods sold account unit is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.	WH20.7
`COL-CGS-ACCOUNT` CGS_ACCOUNT	Numeric 6	The cost of goods sold account number is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.	WH20.7
`COL-CGS-SUB-ACCT` CGS_SUB_ACCT	Numeric 4	The cost of goods sold subaccount number is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.	WH20.7
`COL-PROD-TAX-CAT` 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
`COL-CXL-DATE` CXL_DATE	Numeric 8 (yyyymmdd)	This field contains the date this line was canceled.	WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +25 more
`COL-CXL-QTY` CXL_QTY	Signed 13.4	This field contains the quantity canceled for this order line.	WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +25 more
`COL-CXL-OPR` CXL_OPR	Alpha 10 (Lower Case)	This field contains the user ID of the person who canceled this order line.	WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +25 more
`COL-CXL-REASON` CXL_REASON	Alpha 4	This field contains the reason for canceling this order. Reason codes are set up in Reason Codes (BL07.1).	WH130, WH132, WH190, WH20.7, WH30.1, WH30.2, WH30.3, WH30.4 +25 more
`COL-LAST-COMM-SEQ` LAST_COMM_SEQ	Numeric 3	This field contains the sequence number of the last comment line entered on this line.	BLI2.1, WH20.7
`COL-LAST-MISC-SEQ` LAST_MISC_SEQ	Numeric 3	This field contains the last sequence used for miscellaneous charges for this line.	WH20.7
`COL-MSDS-REQ-FL` MSDS_REQ_FL	Alpha 1	This field indicates that an MSDS (Material Safety Data Sheet) is required. If set to Yes, an MSDS acknowledgment is required for the first shipment containing the item even if an MSDS acknowledgment has been sent within a year for this item to the customer. Order Entry does not create MSDS forms, but it keeps track of when the form was sent. `Y` Yes `N` No	WH20.7
`COL-LAST-SHIP-NBR` LAST_SHIP_NBR	Numeric 10	This field contains the last shipment number created for this order line.	WH20.7
`COL-WORK-ORDER` WORK_ORDER	Numeric 8	This identifies the work order the line may be associated with. It is used if work order is active and the line is a finished good with a backorder quantity.	—
`COL-WORK-ORDER-SUF` WORK_ORDER_SUF	Numeric 2	This is the suffix of the work order the line may be associated with. It will normally be zero.	—
`COL-PRICE-REC-TYPE` PRICE_REC_TYPE	Alpha 1	— `C` Class `I` Item	WH20.7
`COL-QTY-BREAK-FL` QTY_BREAK_FL	Alpha 1	— `Y` Yes `N` No	WH20.7
`COL-GROSS-AMOUNT` GROSS_AMOUNT	Derived	This field contains the line extension in base currency before discounts are taken.	—
`COL-NET-AMOUNT` NET_AMOUNT	Derived	This field contains the line amount in base currency after discounts have been removed.	—
`COL-CURR-GROSS` CURR_GROSS	Derived	This field contains the gross amount in transaction currency.	—
`COL-CURR-NET` CURR_NET	Derived	This field contains the line net amount in transaction currency.	—
`COL-OPEN-TO-ALLOC` OPEN_TO_ALLOC	Derived	This field contains quantity available for allocation.	—
`COL-ALLOC-NOT-PRT` ALLOC_NOT_PRT	Derived	This field contains the allocated quantity that has not been printed on the picking list.	—
`COL-PROJ-STD-COST` PROJ_STD_COST	Derived	This field contains the projected cost for a standard cost company. This is used when editing the profit margin for a particular order.	—
`COL-PROJ-AVG-COST` PROJ_AVG_COST	Derived	This field contains the projected cost for any company not using standard cost. This is used when editing the profit margin for a particular order.	—
`COL-PROJ-SPL-COST` PROJ_SPL_COST	Derived	This field contains the projected extended cost for special and nonstock items. This is based on the cost entered when adding the order. This is used when calculating the profit margin of the order.	—
`COL-PROJ-COST` PROJ_COST	Derived	This field contains the projected cost for this line. This can either be the projected standard cost or the projected average cost.	—
`COL-PROJ-MARGIN` PROJ_MARGIN	Derived	This field contains the projected margin for this line.	—
`COL-UNBILLED-QTY` UNBILLED_QTY	Derived	This field contains the unbilled quantity on the line.	—
`COL-UNBILLED-BASE` UNBILLED_BASE	Derived	This field contains the unbilled quantity on the order line in base currency.	—
`COL-UNBILLED-CURR` UNBILLED_CURR	Derived	This field contains the unbilled amount in transaction currency.	—
`COL-ORD-QTY-IN-STK` ORD_QTY_IN_STK	Derived	This field contains the quantity of item in stock unit of measure.	—
`COL-BO-FL` BO_FL	Derived	This field indicates if the order line was backordered.	—
`COL-PRICE-LOC` PRICE_LOC	Derived	This field indicates the pricing location for the order line.	—
`COL-ORDER-FILLER` ORDER_FILLER	Derived	Used to facilitate Drill Around to shipments for this order.	—
`COL-ORDER-NBR-A` ORDER_NBR_A	Derived	Used to facilitate Drill Around to shipments for this order.	—
`COL-DISP-ALLOCATED` DISP_ALLOCATED	Derived	Used to facilitate Drill Around of quantity allocated.	—
`COL-DISP-PRINTED` DISP_PRINTED	Derived	Used to facilitate Drill Around of pick list quantity printed.	—
`COL-DISP-IN-PROC` DISP_IN_PROC	Derived	Used to facilitate Drill Around of quantity in process.	—
`COL-DISP-BACKORD` DISP_BACKORD	Derived	Used to facilitate Drill Around of quantity back ordered.	—
`COL-COMM-LIT` COMM_LIT	Derived	If comments are attached, this field displays "comments exist."	—
`COL-DER-ORIGIN-CD` DER_ORIGIN_CD	Derived	—	—
`COL-INTR-COMP` INTR_COMP	Alpha 1	Identifies Inter-Company order lines as "O" for the customer order line, "S" for the shipping company, or N" not an Inter-company order line. `O` Inter-Co Customer order `S` Inter-Co Shipping order `N` Not an Inter-Co Order	WH20.7
`COL-FOB-CODE` FOB_CODE	Alpha 3	The user defined Free On Board Code.	WH20.7
`COL-PORT-CD` PORT_CD	Alpha 5	The Intrastat port code. Must be define in IN04.1 (Port Maintenance)	WH20.7
`COL-NOTC` NOTC	Alpha 2	The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	WH20.7
`COL-STAT-PROC` STAT_PROC	Alpha 6	The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).	WH20.7
`COL-SUPLMNTARY-UOM` SUPLMNTARY_UOM	Alpha 4	This field contains the valid stock unit of measure for this item.	WH20.7
`COL-SUPLMNTARY-QTY` SUPLMNTARY_QTY	Signed 13.4	This field contains the desired quantity.	WH20.7
`COL-ICN-CODE` ICN_CODE	Alpha 8	—	WH20.7
`COL-BACK-ORD-FL` BACK_ORD_FL	Alpha 1	— `Y` Backorder Allowed `N` Backorder Not Allowed	WH20.7
`COL-GLBL-LINE-TYPE` GLBL_LINE_TYPE	Alpha 15	—	WH20.7
`COL-FREIGHT-TOT` FREIGHT_TOT	Signed 18.2	—	WH20.7
`COL-INSURANCE-TOT` INSURANCE_TOT	Signed 18.2	—	WH20.7
`COL-CSTMS-TOT` CSTMS_TOT	Signed 18.2	—	WH20.7
`COL-OTHER-AOC-TOT` OTHER_AOC_TOT	Signed 18.2	—	WH20.7

Indexes (13)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`COLSET1`	`COMPANY`, `ORDER-NBR`, `LINE-NBR`	Primary		AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`COLSET10`	`COMPANY`, `ORDER-NBR`, `TAX-CODE`, `PROD-TAX-CAT`, `LINE-NBR`	KeyChange		WH20.2, WH20.7
`COLSET11`	`COMPANY`, `CUSTOMER`, `ORDER-NBR`, `LINE-NBR`	Subset	Where CREATE-PO = "Y" And DROPSHIP-FL = "Y" And STATUS = 2 And ORDER-QTY > INVOICE-QTY	—
`COLSET12`	`COMPANY`, `CUSTOMER`, `ORDER-NBR`, `LINE-NBR`	Subset	Where STATUS = 2 And CREATE-PO = "Y" And ORDER-QTY > SHIPPED-QTY	—
`COLSET13`	`COMPANY`, `LINE-NBR`, `ORDER-NBR`			WH20.7
`COLSET2`	`COMPANY`, `INV-LOC`, `ITEM`, `PROCESS-LEVEL`, `ORDER-NBR`, `LINE-NBR`	KeyChange, Subset	Where STATUS = 2	WH120
`COLSET3`	`COMPANY`, `CUSTOMER`, `ITEM`, `ORDER-NBR`, `LINE-NBR`	KeyChange		IC11.1, IC216
`COLSET4`	`COMPANY`, `ORDER-NBR`, `SALES-MAJCL`, `SALES-MINCL`, `LINE-NBR`	Subset	Where PRICE-STATUS = "A"	WH20.2, WH20.7
`COLSET5`	`ATN-OBJ-ID`	KeyChange, Subset	Where ATN-OBJ-ID != Zeroes	—
`COLSET6`	`COMPANY`, `CUSTOMER`, `HOLD-CODE`, `ORDER-NBR`, `LINE-NBR`	KeyChange, Subset	Where HOLD-CODE != Spaces	—
`COLSET7`	`COMPANY`, `ORDER-NBR`, `LINE-NBR`	Subset	Where STATUS < 3	WH20.2, WH20.7, WH210
`COLSET8`	`ATN-OBJ-ID-C`	KeyChange, Subset	Where ATN-OBJ-ID-C != Zeroes	—
`COLSET9`	`COMPANY`, `ORDER-NBR`, `VENDOR`, `CUST-SHIP-TO`, `DROPSHIP-FL`, `LINE-NBR`	Subset	Where STATUS = 2 And CREATE-PO = "Y" And ORDER-QTY > SHIPPED-QTY	WH20.7

Relations

One to one (42) — lookups and parents

Relation	Table	Rules	Condition	Field map
Apcompany	APCOMPANY	Required	When COL-CARRIER != Spaces	`COL-COMPANY` → `-COMPANY`
Apvenmast	APVENMAST	Required	When COL-CARRIER != Spaces	`CPY-VENDOR-GROUP` → `VEN-VENDOR-GROUP`, `COL-CARRIER` → `VEN-VENDOR`
Arcomp	ARCOMP	Required		`COL-COMPANY` → `ACO-COMPANY`
Arcustomer	ARCUSTOMER	Required		`COL-COMPANY` → `ACM-COMPANY`, `COL-CUSTOMER` → `ACM-CUSTOMER`
Cogs Offset	GLMASTER	Required	When COL-LINE-TYPE = "N" Or COL-LINE-TYPE = "X"	`COL-COMPANY` → `GLM-COMPANY`, `COL-EXP-ACCT-UNIT` → `GLM-ACCT-UNIT`, `COL-EXP-ACCOUNT` → `GLM-ACCOUNT`, `COL-EXP-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Colineuom	COLINEUOM	Not Required, Delete Cascades	Valid When COL-MULT-SPR-FL = "Y"	`COL-COMPANY` → `COU-COMPANY`, `COL-ORDER-NBR` → `COU-ORDER-NBR`, `COL-LINE-NBR` → `COU-LINE-NBR`
Contract	OEPRCLIST	Required	When COL-CONTRACT-NBR != Spaces	`COL-COMPANY` → `OPL-COMPANY`, `COL-CUSTOMER` → `OPL-CUSTOMER`, `COL-CONTRACT-NBR` → `OPL-LIST-NAME`, `Spaces` → `OPL-PROMOTION`
Cosgblk	COSGBLK	Not Required		`COL-COMPANY` → `OSG-COMPANY`, `COL-ORDER-NBR` → `OSG-ORDER-NBR`, `COL-LINE-NBR` → `OSG-LINE-NBR`, `Zeroes` → `OSG-SEQ`
Cucodes	CUCODES	Required		`COR-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Curelat	CURELAT	Required	When COR-CURRENCY-CODE != COL-CURRENCY-CODE	`GLS-CURRENCY-TABLE` → `CRL-CURRENCY-TABLE`, `COR-CURRENCY-CODE` → `CRL-FR-CURR-CODE`, `OEC-CURRENCY-CODE` → `CRL-TO-CURR-CODE`
Custdesc	CUSTDESC	Required		`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `COL-CUSTOMER` → `CUD-CUSTOMER`
Custorder	CUSTORDER	Required		`COL-COMPANY` → `COR-COMPANY`, `COL-ORDER-NBR` → `COR-ORDER-NBR`
Cxl Operator	OPERATOR	Required	When COL-CXL-OPR != Spaces	`COL-COMPANY` → `OPE-DEF-COMPANY`, `COL-CXL-OPR` → `OPE-OPR-CODE`
Glsystem	GLSYSTEM	Required		`COL-COMPANY` → `GLS-COMPANY`
Hdrloc	ITEMLOC	Not Required		`COL-COMPANY` → `ITL-COMPANY`, `COR-INV-LOCATION` → `ITL-LOCATION`, `COL-ITEM` → `ITL-ITEM`
Holdcodes	HOLDCODES	Required	When COL-HOLD-CODE != Spaces	`ACO-CUST-GROUP` → `HDD-CUST-GROUP`, `COL-HOLD-CODE` → `HDD-HOLD-CODE`
Iccategory	ICCATEGORY	Not Required	Valid When COL-LINE-TYPE = "I"	`COL-COMPANY` → `ICA-COMPANY`, `COL-INV-LOC` → `ICA-LOCATION`, `ITL-GL-CATEGORY` → `ICA-GL-CATEGORY`
Iccompany	ICCOMPANY	Required	When COL-LINE-TYPE != "X"	`COL-COMPANY` → `ICC-COMPANY`
Iclocation	ICLOCATION	Required		`COL-COMPANY` → `ICL-COMPANY`, `COL-INV-LOC` → `ICL-LOCATION`
Itemlocation	ITEMLOC	Required	When COL-INV-LOC != Spaces And COL-LINE-TYPE = "I"	`COL-COMPANY` → `ITL-COMPANY`, `COL-INV-LOC` → `ITL-LOCATION`, `COL-ITEM` → `ITL-ITEM`
Itemmast	ITEMMAST	Required	When COL-LINE-TYPE != "X"	`ICC-ITEM-GROUP` → `ITE-ITEM-GROUP`, `COL-ITEM` → `ITE-ITEM`
Kititem	KITITEM	Not Required	Valid When COL-KIT-FL = "O"	`ICC-ITEM-GROUP` → `KIT-ITEM-GROUP`, `COL-COMPANY` → `KIT-COMPANY`, `COL-INV-LOC` → `KIT-LOCATION`, `COL-ITEM` → `KIT-ITEM`
Kititem 2	KITITEM	Not Required	Valid When COL-KIT-FL != "O"	`ICC-ITEM-GROUP` → `KIT-ITEM-GROUP`, `COL-COMPANY` → `KIT-COMPANY`, `COL-INV-LOC` → `KIT-LOCATION`, `COL-ITEM` → `KIT-ITEM`
Majorcl	MAJORCL	Required	When COL-LINE-TYPE != "X"	`ICC-ITEM-GROUP` → `MAJ-ITEM-GROUP`, `"S"` → `MAJ-CLASS-TYPE`, `ITE-SALES-MAJCL` → `MAJ-MAJOR-CLASS`
Minorcl	MINORCL	Not Required	Valid When COL-LINE-TYPE != "X"	`ICC-ITEM-GROUP` → `MIN-ITEM-GROUP`, `"S"` → `MIN-CLASS-TYPE`, `ITE-SALES-MAJCL` → `MIN-MAJOR-CLASS`, `ITE-SALES-MINCL` → `MIN-MINOR-CLASS`
Oecoluf	OECOLUF	Required		`COL-COMPANY` → `OLU-COMPANY`, `COL-ORDER-NBR` → `OLU-ORDER-NBR`, `COL-LINE-NBR` → `OLU-LINE-NBR`
Oecompany	OECOMPANY	Required		`COL-COMPANY` → `OEC-COMPANY`
Oecust	OECUST	Required		`COL-COMPANY` → `OET-COMPANY`, `COL-CUSTOMER` → `OET-CUSTOMER`
Oeproclev	OEPROCLEV	Required		`COL-COMPANY` → `OEP-COMPANY`, `COL-PROCESS-LEVEL` → `OEP-PROCESS-LEVEL`
Oereason	OEREASON	Not Required	Valid When COL-CXL-OPR != Spaces	`COL-COMPANY` → `OER-COMPANY`, `COL-CXL-REASON` → `OER-REASON-CODE`
Oeslsacct	OESLSACCT	Required	When COL-LINE-TYPE != "X"	`COL-COMPANY` → `OSA-COMPANY`, `COL-PROCESS-LEVEL` → `OSA-PROCESS-LEVEL`, `ITE-SALES-MAJCL` → `OSA-SALES-MAJCL`, `ITE-SALES-MINCL` → `OSA-SALES-MINCL`
Operator	OPERATOR	Required		`COL-COMPANY` → `OPE-DEF-COMPANY`, `COR-OPR-CODE` → `OPE-OPR-CODE`
Ordertype	ORDERTYPE	Required		`COL-COMPANY` → `OTP-COMPANY`, `COR-ORDER-TYPE` → `OTP-ORDER-TYPE`
Po Vendor	APVENMAST	Required	When COL-VENDOR != Spaces	`CPY-VENDOR-GROUP` → `VEN-VENDOR-GROUP`, `COL-VENDOR` → `VEN-VENDOR`
Promotion	OEPRCLIST	Required	When COL-PROMOTION > Spaces	`COL-COMPANY` → `OPL-COMPANY`, `Spaces` → `OPL-CUSTOMER`, `COR-LIST-NAME` → `OPL-LIST-NAME`, `COL-PROMOTION` → `OPL-PROMOTION`
Sales Acct	GLMASTER	Required	When COL-LINE-TYPE = "N" Or COL-LINE-TYPE = "X"	`COL-COMPANY` → `GLM-COMPANY`, `COL-SLS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `COL-SLS-ACCOUNT` → `GLM-ACCOUNT`, `COL-SLS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Salesrep1	SALESREP	Required		`COL-COMPANY` → `SAW-COMPANY`, `COL-SALESMAN` → `SAW-SALESMAN`
Salesrep2	SALESREP	Required	When COL-SALESMAN-2 != Zeroes	`COL-COMPANY` → `SAW-COMPANY`, `COL-SALESMAN-2` → `SAW-SALESMAN`
Shipto	SHIPTO	Required	When COL-CUST-SHIP-TO != Zeroes	`COL-COMPANY` → `SHP-COMPANY`, `COL-CUSTOMER` → `SHP-CUSTOMER`, `COL-CUST-SHIP-TO` → `SHP-SHIP-TO`
Teritory	TERITORY	Required		`COL-COMPANY` → `TRY-COMPANY`, `COL-TERRITORY` → `TRY-TERRITORY`
Txtaxcode	TXTAXCODE	Required	When COL-TAX-CODE > Spaces	`COL-COMPANY` → `TAC-COMPANY`, `COL-TAX-CODE` → `TAC-TAX-CODE`
Whdemndhdr	WHDEMNDHDR	Not Required		`COL-COMPANY` → `WDH-COMPANY`, `"OE"` → `WDH-SYSTEM-CD`, `COL-ORDER-NBR` → `WDH-DOC-NBR-NUM`

One to many (19) — child tables

Relation	Table	Rules	Condition	Field map
Comisc	COMISC			`COL-COMPANY` → `CMC-COMPANY`, `COL-ORDER-NBR` → `CMC-ORDER-NBR`, `COL-LINE-NBR` → `CMC-LINE-NBR`, → `CMC-SEQ`
Companions	ITEMSUB			`ICC-ITEM-GROUP` → `ITS-ITEM-GROUP`, `COL-ITEM` → `ITS-ITEM`, `"C"` → `ITS-SUBTYPE`, → `ITS-SUB-ITEM`
Component	COMPONENT		Valid When COL-KIT-FL = "O"	`ICC-ITEM-GROUP` → `COM-ITEM-GROUP`, `COL-COMPANY` → `COM-COMPANY`, `COL-INV-LOC` → `COM-LOCATION`, `COL-ITEM` → `COM-KIT-ITEM`, → `COM-SEQ`, → `COM-OPT-SEQ`
Components	COMPONENT			`ICC-ITEM-GROUP` → `COM-ITEM-GROUP`, `COL-COMPANY` → `COM-COMPANY`, `COL-INV-LOC` → `COM-LOCATION`, `COL-ITEM` → `COM-KIT-ITEM`, → `COM-SEQ`, → `COM-OPT-SEQ`
Itemcompanion	ITEMSUB			`ICC-ITEM-GROUP` → `ITS-ITEM-GROUP`, `COL-ITEM` → `ITS-ITEM`, `"C"` → `ITS-SUBTYPE`, → `ITS-SUB-ITEM`
Itemloc	ITEMLOC	Required	When COL-LINE-TYPE = "I"	`COL-COMPANY` → `ITL-COMPANY`, `COL-ITEM` → `ITL-ITEM`, → `ITL-LOCATION`
Itemsub	ITEMSUB			`ICC-ITEM-GROUP` → `ITS-ITEM-GROUP`, `COL-ITEM` → `ITS-ITEM`, `"S"` → `ITS-SUBTYPE`, → `ITS-SUB-ITEM`
Itserial	ITSERIAL			`COL-COMPANY` → `SER-COMPANY`, `COL-ITEM` → `SER-ITEM`, → `SER-SERIAL`
Oeaudit	OEAUDIT	Delete Cascades		`COL-COMPANY` → `OEA-COMPANY`, `COL-ORDER-NBR` → `OEA-ORDER-NBR`, `COL-LINE-NBR` → `OEA-LINE-NBR`, → `OEA-FLD-NBR`, → `OEA-UPDATE-DATE`, → `OEA-UPDATE-TIME`
Oeordcmnt	OEORDCMNT			`COL-COMPANY` → `OOC-COMPANY`, `Spaces` → `OOC-CUSTOMER`, `Spaces` → `OOC-STD-ORDER-NBR`, `COL-ORDER-NBR` → `OOC-ORDER-NBR`, `COL-LINE-NBR` → `OOC-LINE-NBR`, → `OOC-SEQ`
Polinesrc	POLINESRC		Valid When COL-CREATE-PO = "Y"	`COL-COMPANY` → `PLS-OPER-COMPANY`, `"OE"` → `PLS-ORIGIN-CD`, `COL-ORDER-NBR` → `PLS-SOURCE-DOC-N`, `COL-LINE-NBR` → `PLS-SRC-LINE-NBR`, → `PLS-PO-CODE`, → `PLS-PO-NUMBER`, → `PLS-PO-RELEASE`, → `PLS-LINE-NBR`
Returnline	RETURNLINE			`COL-COMPANY` → `RTL-COMPANY`, `COL-CUSTOMER` → `RTL-CUSTOMER`, `COL-ITEM` → `RTL-ITEM`, `COL-CUST-SHIP-TO` → `RTL-SHIP-TO`, → `RTL-DATE`, → `RTL-AUTH-NO`, → `RTL-LINE-NBR`
Sohbins	SOHDETAIL			`COL-COMPANY` → `SDT-COMPANY`, `COL-INV-LOC` → `SDT-LOCATION`, `COL-ITEM` → `SDT-ITEM`, → `SDT-BIN`, → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`
Sohdetail	SOHDETAIL			`COL-COMPANY` → `SDT-COMPANY`, `COL-INV-LOC` → `SDT-LOCATION`, `COL-ITEM` → `SDT-ITEM`, → `SDT-UOM`, → `SDT-LOT`, → `SDT-SUBLOT`, → `SDT-BIN`
Substitutions	ITEMSUB			`ICC-ITEM-GROUP` → `ITS-ITEM-GROUP`, `COL-ITEM` → `ITS-ITEM`, `"S"` → `ITS-SUBTYPE`, → `ITS-SUB-ITEM`
Vendor Company	ICLOCATION			`COL-VENDOR` → `ICL-VENDOR`, `COL-PURCH-FR-LOC` → `ICL-PURCH-FR-LOC`, `Zeroes` → `ICL-COMPANY`, → `ICL-LOCATION`
Whdemand	WHDEMAND			`COL-COMPANY` → `WDM-COMPANY`, `"OE"` → `WDM-SYSTEM-CD`, `WDH-DOC-NBR` → `WDM-DOC-NBR`, `COL-LINE-NBR` → `WDM-LINE-NBR`, `Zeroes` → `WDM-COMPONENT-SEQ`, → `WDM-LOCATION`
Whshipline	WHSHIPLINE			`COL-COMPANY` → `WHL-COMPANY`, `"OE"` → `WHL-SYSTEM-CD`, `WDH-DOC-NBR` → `WHL-DOC-NBR`, `COL-LINE-NBR` → `WHL-LINE-NBR`, → `WHL-SHIPMENT-NBR`
Whshipment	WHSHIPMENT			`COL-COMPANY` → `WHS-COMPANY`, `COL-INV-LOC` → `WHS-LOCATION`, `COL-ORDER-NBR-A` → `WHS-DOC-NBR`, → `WHS-SHIPMENT-NBR`

Programs

Updated by (231)

AP125 Batch Release
AP126 Mass Invoice Release
AP131 Chargeback
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.4 Invoice Cancel
AP510 Vendor Conversion
API1.1 Add Invoice
API2.1 Add Invoice
BLI2.1 BL and OE Attachment Copy
CX100 Pick List Print
CX20.1 Case Build
CX20.2 Case Detail
CX20.4 Substitute Items
CX20.5 Insert line
CX220 Case, Preference Listing
CX30.1 Case Completion Feedback
CX300 Preference List Purge
CX506 HL7 Schedules Import Interface
CXCP.1 Copy preference to case
DR100 Distribution Requirements Report
IC11.1 Item Master
IC12.1 Item Location
IC140 Vendor Reorder Advice
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC145 Stock Status Report
IC216 Open Transaction Report
IC243 Killed Item Report
IC330 Item Mass Change
IC64.1 Global Location Nbr Assignment GL/IC Company
IC64.2 Global Location Nbr Assignment IC Location
IC64.3 Global Location Number Assignment RQ Location
IC64.4 Global Location Number Assignment Manuf Code
IC64.5 Global Location Number Assignment Manuf Div
IC64.6 Global Location Number Assignment Vendor
IC64.7 Global Location Number Assignment Vendor Location
IC64.8 Global Location Number Assignment IC Bin
IC64.9 Global Location Number Assignment Buyer
IC66.1 Replenishment PO Worksheet
IC83.1 Par Location Counts
MA180 Open Receipt Archive
MA278 Cost Variance Analysis
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA43.7 GL Distribution
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA53.1 Receipt Interface
MA530 ERS Invoice Creation
MA531 Receipt Interface
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.5 Receipt Match Reference Adjustment
MA61.1 Match Invoice Approval
MA66.2 Invoice Message - Details
MA67.2 Invoice Match from frontend
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.3 Detail Level Match - Prepaid
MA68.5 Receipt Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MA80.1 Receipt Archive
MAI1.1 Invoke for MAMATCH Object
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD570 P-Card Charge Import
PO04.1 Buyer
PO04.2 Buyer Purchasing Class
PO10.1 PO Vendor
PO10.2 Vendor Purchase From Location
PO100 Purchase Order Interface from Lawson Applications
PO101 Create Standing PO Release
PO115 Procurement Template Mass Changes
PO120 Mass PO Issue
PO122 Transmitted PO Acknowledgement
PO131 Receiving Log
PO132 Print Vendor Return Material Authorization
PO136 Matched, Not Received Report
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.4 Procurement Template Line Detail
PO150 Bid Load to Contract or Catalog
PO17.1 Purchase Order Approval Review
PO190 Close Purchase Order Header
PO20.1 Purchase Order Entry
PO20.6 Substitute Vendor Items
PO20.9 Multiple Lines
PO204 Buyer Master Listing
PO21.1 Select and Copy
PO21.2 Add-On Cost Spread
PO21.3 Account Distribution
PO21.4 Miscellaneous Add-On Cost
PO21.5 Item Add-On Cost
PO22.1 Authorization, Release
PO22.3 Mass Cancel or Delete Purchase Orders
PO22.4 Mass Cancel or Delete Purchase Order Lines
PO220 PO Status Report
PO222 Remaining PO Balance Report
PO224 PO Revision Report
PO225 Vendor Agreement Listing
PO229 Vendor Agreement Format Print
PO23.1 Purchase Order Worksheet
PO230 Unreleased Receivings Listing
PO234 PO Interface Listing Report
PO24.1 Purchase Order Direct Approval
PO25.1 Vendor Agreements
PO25.5 Vendor Agreement Item Add-On Cost
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO251 PO Buyer Message Listing
PO26.3 Vendor Agreement Commitments Spread
PO26.7 Mass Release of Vendor Agreements
PO26.9 Vendor Agreement Release
PO27.2 Select Blanket Lines
PO27.3 Create PO From Procurement Template
PO27.4 Select and Copy Template
PO275 Delivery Date Analysis
PO276 Deliver Quantity Analysis
PO277 Deliver Quality Analysis
PO28.2 Vendor Agreement Line Detail List
PO280 Purchases By Class
PO29.1 Copy Purchase Order
PO30.1 PO Receiving
PO30.2 Substitute Item
PO30.3 Additional Tracking Numbers
PO30.4 PO Receiving Line Detail List
PO300 PO and Receipt Purge
PO31.1 Vendor Return
PO31.2 Vendor Return Item Selection
PO32.2 Item Detail
PO32.4 Cancel Detail
PO33.1 Receiving Adjustment
PO34.1 Inspection Accept or Reject
PO35.1 Receiving Approval and Release
PO36.1 Identify Lawson Items by Vendor Agreement Line
PO36.2 Vendor Agreement Import Manual Input
PO38.1 Invoice AOC
PO39.1 Additional Receiving Entry
PO39.2 Additional Adjustment/Rejection Entry
PO44.1 PO Line Source
PO50.1 Buyer Message Entry
PO52.1 Buyer Message - Receiving
PO520 Purchase Order Interface from Non Lawson
PO536 Vendor Price Agreement Load
PO54.5 PO Line Detail List
POCP.1 POC Comments Copy
POI3.1 Invoke for POPI70PD
POID.1 PO Delivery Ticket Select
POII.1 Invoke for POPCRUPD
POIJ.1 Invoke for POPLIUPD
RQ01.1 Requesting Locations
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ12.1 Approval Review
RQ13.1 Direct Approval
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ44.1 Requisition Inquiry
RQ500 Requisition Interface
RQ810 Request Location Load
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy
WH110 Batch Allocation
WH120 Route Creation
WH130 Pick List Print
WH132 Batch Feedback
WH190 Shipment Release
WH20.2 Nonstock and Special Allocation
WH20.7 Substitute Location
WH21.1 Routes
WH21.2 Stops
WH21.3 Stop Transfer
WH21.4 Document Transfer
WH22.1 Kit Options
WH222 Shipments In Process
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.1 Bins
WH33.2 Lots
WH33.3 Serials
WH33.4 UOMs
WH33.5 Additional Shipment Information
WH33.6 Catch Weight
WH33.8 Preassembled Kits
WH33.9 Line Options
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program
WHD2.1 WH-IC Integrity Check

Referenced by (13)

CX05.1 Preference Template
CX05.2 Preference Template Diagnostics
CX805 Template Card Conversion
RQIC.1 Get Item List Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIG.1 Get Shopping List Invoke Object
WH126 POD Print
WH210 Route File Listing
WH224 Packing List Print
WH226 Items on Backorder Report
WH25.1 Cancellation By Item
WH25.2 Cancellation By Document
WHD0.1 WH Orphan Record Check