Customer Order Line

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.

REFERENCED BY

IC11.1

IC216

WH126

WH224

WH226

WHD0.1

UPDATED BY

AP125	AP126	AP131	AP20.1	AP20.2	AP20.3
AP20.4	AP20.5	AP20.7	AP21.1	AP23.1	AP25.1
AP25.2	AP26.1	AP27.1	AP30.4	API1.1	API2.1
BLI2.1	CX100	CX20.1	CX20.2	CX20.4	CX20.5
CX220	CX30.1	CX300	CX506	CXCP.1	DR100
IC140	IC66.1	IC83.1	MA180	MA41.1	MA41.2
MA41.4	MA41.7	MA42.2	MA43.2	MA43.7	MA44.1
MA44.2	MA530	MA531	MA60.2	MA60.3	MA60.5
MA61.1	MA66.2	MA67.2	MA67.3	MA68.2	MA68.3
MA68.5	MA70.1	MA75.1	MA80.1	MAI1.1	PD10.1
PD10.2	PD130	PD20.1	PD20.2	PD20.3	PO100
PO101	PO122	PO131	PO136	PO150	PO190
PO20.1	PO20.6	PO20.9	PO21.1	PO21.2	PO21.3
PO21.4	PO21.5	PO22.1	PO22.3	PO22.4	PO23.1
PO24.1	PO25.1	PO25.5	PO25.6	PO25.7	PO27.2
PO28.2	PO29.1	PO30.1	PO30.2	PO30.3	PO30.4
PO300	PO31.1	PO31.2	PO32.2	PO32.4	PO33.1
PO34.1	PO35.1	PO36.1	PO36.2	PO38.1	PO39.1
PO39.2	PO44.1	PO50.1	PO52.1	PO520	PO536
PO54.5	POCP.1	POI3.1	POID.1	POII.1	POIJ.1
RQ10.1	RQ10.2	RQ10.4	RQ12.1	RQ13.1	RQ13.2
RQ35.1	RQ500	RQIF.1	WH110	WH120	WH130
WH132	WH190	WH20.2	WH20.7	WH21.1	WH21.2
WH21.3	WH21.4	WH210	WH22.1	WH222	WH30.1
WH30.2	WH30.3	WH30.4	WH31.1	WH31.2	WH31.3
WH31.4	WH32.1	WH32.2	WH32.3	WH32.4	WH32.5
WH33.1	WH33.2	WH33.3	WH33.4	WH33.5	WH33.6
WH33.8	WH33.9	WH34.1	WH34.2	WH34.3	WH34.4
WH40.1	WH40.2	WH520	WH830	WHD2.1	ZW130

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
COL-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
COL-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
COL-LINE-NBR Element: Line Nbr	Numeric 6 This field displays the line number of the transaction number.	WH20.7
COL-STATUS Element: 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 Element: Future Fl	Alpha 1 This field indicates if this line has a future status. Y = Yes N = No	WH20.7
COL-SALES-MAJCL Element: Major Class	Alpha 4 This field contains the major sales class code.	WH20.7
COL-SALES-MINCL Element: Minor Class	Alpha 4 This field contains the minor sales class code within the major class.	WH20.7
COL-ITEM Element: Item	Alpha 32 This field contains the item identifier.	WH20.7
COL-ITEM-DESC Element: Item Desc	Alpha 30 This field contains the description for stock and non-stock items.	WH20.7 WH222
COL-LINE-TYPE Element: 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 Element: Orig Line	Numeric 4 This field contains the original line number if it was overridden.	WH20.7
COL-ORIG-ITEM Element: Item	Alpha 32 This field contains the original item number if it was overridden.	WH20.7
COL-ORIG-FL Element: 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 Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.	WH20.7
COL-CUST-ITEM-FL Element: 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 Element: Item	Alpha 32 This field contains the customer's item number.	WH20.7
COL-KIT-FL Element: 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 Element: 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 Element: 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 Element: Location	Alpha 5 This field contains a valid stocking location within the company inventory.	WH20.7
COL-PROCESS-LEVEL Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: Intl Cost	Signed 18.5 This field contains the unit price in the currency of the order.	WH20.7
COL-UNIT-PRICE Element: Intl Cost	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 Element: 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 Element: Sell Unit Prc	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 Element: Intl Cost	Signed 18.5	WH20.7
COL-DISC-AMT-CURR Element: Intl Amt	Signed 18.2 This field contains the discount amount in transaction currency.	WH20.7
COL-MULT-DISC-AMT Element: 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 Element: 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 Element: Disc Amt Base	Derived This field contains the discount amount in base currency.
COL-DISC-CODE Element: Discount Code	Alpha 10 This field contains the discount code used to calculate the discount amount for this line.	WH20.7
COL-MULT-SPR-FL Element: All Flag	Alpha 1 Y = Yes N = No	WH20.7
COL-SPR-TO-STOCK Element: Sell 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 Element: 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 Element: Sell 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 Element: 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 Element: Ship To	Numeric 4 This field contains the ship-to customer number. This defaults from the order header.	WH20.7
COL-CREATE-PO Element: All Flag	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 Element: 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 Element: Vendor	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 Element: 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 Element: 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 Element: 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 Element: Purch Fr Loc	Alpha 4 The vendor's purchase from location.	WH20.7
COL-IF-REF-NBR Element: If Ref Nbr	Numeric 9 This field contains an internally generated reference number used by the Requisition system.	WH20.7
COL-ROUTE Element: 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 Element: 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 Element: All Flag	Alpha 1 Y = Yes N = No	WH110 WH120 WH130 WH132 WH190 WH20.7 WH21.1 WH21.2 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
COL-EXP-DELIV-DT Element: Date	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 Element: 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 Element: 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 Element: Salesman	Numeric 4 This field contains the code representing the second sales representative. This defaults from the order header.	WH20.7
COL-COMM-SPLIT Element: 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 Element: Chrg Rate	Percent 7.5 (Percent) Commission rate for sales representative 1. Defaults from the sales representative file.	WH20.7
COL-COMM-RATE-2 Element: Chrg Rate	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 Element: Intl Amt	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 Element: 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 Element: 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 Element: Add Disc Base	Derived This field contains the additional discount amount in base currency.
COL-DISC-TKN-CURR Element: Intl Amt	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 Element: 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 Element: 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 Element: 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 Element: 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 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. 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 Element: Intl Amt	Signed 18.2 This field contains the taxable amount in billing currency.	WH20.2 WH20.7
COL-MULT-TAXABLE Element: 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 Element: 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 Element: Intl Amt	Signed 18.2 This field contains the override taxable amount in base currency.	WH20.2 WH20.7
COL-MULT-OVR-TXBL Element: 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 Element: 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 Element: Taxable Base	Derived This field contains the override taxable amount in base currency.
COL-EARLY-DL-DATE Element: Early Dl Date	Numeric 8 (yyyymmdd) This field contains the early delivery date.	WH20.7
COL-LATE-DL-DATE Element: Late Dl Date	Numeric 8 (yyyymmdd) This field contains the late delivery date.	WH20.7
COL-USER-DATE-3 Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	WH20.7
COL-USER-DATE-4 Element: Date	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 Element: Po User Fld 2	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 Element: 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 Element: 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 Element: Date	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 Element: Date	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 Element: 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 Element: Contract Nbr	Alpha 14 This field contains the contract number, if this line is priced using a contract.	WH20.7
COL-PROMOTION Element: 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 Element: 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 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 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 Element: 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 Element: Activity	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 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 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 Element: Obj Id	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 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1 DR100 IC140 IC66.1 IC83.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
COL-BOOKED-FL Element: Account Flag	Alpha 1 This field indicates if the order line has been booked by the Sales Analysis system.	WH20.7
COL-BOOKED-DATE Element: Date	Numeric 8 (yyyymmdd) This field indicates the date when the order line was booked by Sales Analysis.	WH20.7
COL-BOOKED-QTY Element: Quantity	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 Element: Quantity	Signed 13.4 The order quantity of the line item.	WH130 WH132 WH190 WH20.7 WH520 WH830 ZW130
COL-SHIPPED-QTY Element: Quantity	Signed 13.4 This field contains the shipped quantity.	WH126 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 WHD2.1 ZW130
COL-INVOICE-QTY Element: Quantity	Signed 13.4 This field contains the quantity that has been invoiced for this order line.	WH20.7
COL-RETURNED-QTY Element: Quantity	Signed 13.4 Total quantity returned compared to this quantity.
COL-FIRM-FL Element: 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 Element: Ship Comp Fl	Alpha 1	WH20.7
COL-PK-PRIORITY Element: Pk Priority	Numeric 2	WH20.7
COL-SLS-ACCT-UNIT Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 Element: 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 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
COL-CXL-DATE Element: 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 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
COL-CXL-QTY Element: Rec 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 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
COL-CXL-OPR Element: Requester	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 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
COL-CXL-REASON Element: Cb 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 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130
COL-LAST-COMM-SEQ Element: 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 Element: Seq	Numeric 3 This field contains the last sequence used for miscellaneous charges for this line.	WH20.7
COL-MSDS-REQ-FL Element: All Flag	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 Element: Shipment Nbr	Numeric 10 This field contains the last shipment number created for this order line.	WH20.7
COL-WORK-ORDER Element: 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 Element: 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 Element: Price Rec Type	Alpha 1 C = Class I = Item	WH20.7
COL-QTY-BREAK-FL Element: Qty Break Fl	Alpha 1 Y = Yes N = No	WH20.7
COL-GROSS-AMOUNT Element: Gross Amount	Derived This field contains the line extension in base currency before discounts are taken.
COL-NET-AMOUNT Element: Net Amount	Derived This field contains the line amount in base currency after discounts have been removed.
COL-CURR-GROSS Element: Curr Gross	Derived This field contains the gross amount in transaction currency.
COL-CURR-NET Element: Curr Net	Derived This field contains the line net amount in transaction currency.
COL-OPEN-TO-ALLOC Element: Open To Alloc	Derived This field contains quantity available for allocation.
COL-ALLOC-NOT-PRT Element: Alloc Not Prt	Derived This field contains the allocated quantity that has not been printed on the picking list.
COL-PROJ-STD-COST Element: 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 Element: 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 Element: 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 Element: 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 Element: Proj Margin	Derived This field contains the projected margin for this line.
COL-UNBILLED-QTY Element: Unbilled Qty	Derived This field contains the unbilled quantity on the line.
COL-UNBILLED-BASE Element: Unbilled Base	Derived This field contains the unbilled quantity on the order line in base currency.
COL-UNBILLED-CURR Element: Unbilled Curr	Derived This field contains the unbilled amount in transaction currency.
COL-ORD-QTY-IN-STK Element: Ord Qty In Stk	Derived This field contains the quantity of item in stock unit of measure.
COL-BO-FL Element: Bo Fl	Derived This field indicates if the order line was backordered.
COL-PRICE-LOC Element: Price Loc	Derived This field indicates the pricing location for the order line.
COL-ORDER-FILLER Element: Order Filler	Derived Used to facilitate Drill Around to shipments for this order.
COL-ORDER-NBR-A Element: Order Nbr A	Derived Used to facilitate Drill Around to shipments for this order.
COL-DISP-ALLOCATED Element: Disp Allocated	Derived Used to facilitate Drill Around of quantity allocated.
COL-DISP-PRINTED Element: Disp Printed	Derived Used to facilitate Drill Around of pick list quantity printed.
COL-DISP-IN-PROC Element: Disp In Proc	Derived Used to facilitate Drill Around of quantity in process.
COL-DISP-BACKORD Element: Disp Backord	Derived Used to facilitate Drill Around of quantity back ordered.
COL-COMM-LIT Element: Comm Lit	Derived If comments are attached, this field displays "comments exist."
COL-DER-ORIGIN-CD Element: Der Origin Cd	Derived
COL-INTR-COMP Element: 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 Element: Fob Code	Alpha 3 The user defined Free On Board Code.	WH20.7
COL-PORT-CD Element: Port Cd	Alpha 5 The Intrastat port code. Must be define in IN04.1 (Port Maintenance)	WH20.7
COL-NOTC Element: Notc	Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).	WH20.7
COL-STAT-PROC Element: 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 Element: Uom	Alpha 4 This field contains the valid stock unit of measure for this item.	WH20.7
COL-SUPLMNTARY-QTY Element: Quantity	Signed 13.4 This field contains the desired quantity.	WH20.7
COL-ICN-CODE Element: Icn Code	Alpha 8	WH20.7
COL-BACK-ORD-FL Element: Back Ord Fl	Alpha 1 Y = Backorder Allowed N = Backorder Not Allowed	WH20.7

COLINE FILE INDEX

COLINE FILE RELATIONS

ONE TO ONE RELATIONS

COLINE FILE RELATIONS

ONE TO MANY RELATIONS

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