COLINE FILE
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
BL125 BL80.1 POIJ.1 WH110 WH126 WH224
WH210
UPDATED BY
BLI2.1 WH120 WH130 WH21.1 WH21.2 WH21.3
WH21.4 WH22.1 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
COL-ORDER-NBR Numeric 8
Order Number Each order is assigned a unique number.
Order numbers are either manually
assigned or system assigned based on a
company-level option.
COL-LINE-NBR Numeric 6
Line Number This field displays the line number of
the transaction number.
COL-STATUS Numeric 1 WH22.1
Status 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
COL-FUTURE-FL Alpha 1
Future Order Flag This field indicates if this line has a
future status.
Y = Yes
N = No
COL-SALES-MAJCL Alpha 4
Sales Major Class This field contains the major sales
class code.
COL-SALES-MINCL Alpha 4
Sales Minor Class This field contains the minor sales
class code within the major class.
COL-ITEM Alpha 32
Item Number This field contains the item
identifier.
COL-ITEM-DESC Alpha 30
Item Description This field contains the description for
stock and nonstock items.
COL-LINE-TYPE Alpha 1
Line Type The line type can be entered. Valid
values are:
.
I = Inventoried. Default value.
N = Nonstock.
X = Special order.
COL-ORIG-LINE Numeric 4
Original Line Number This field contains the original line
number if it was overridden.
COL-ORIG-ITEM Alpha 32
Original Item Number This field contains the original item
number if it was overridden.
COL-ORIG-FL Alpha 1
Orig Fl This field indicates whether this line
was created as a result of item
replacement or substitution.
R = Replacement line
S = Substitute line
COL-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
COL-CUST-ITEM-FL Alpha 1
Customer Item This field indicates whether the number
Numbers Used Fl entered in the order line represents an
item set up in the Order Entry Customer
file.
C = Customer item was entered
COL-CUST-ITEM Alpha 32
Customer Item Number This field contains the customer's item
number.
COL-KIT-FL Alpha 1
Kit Flag 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
COL-KIT-ALLOC-FL Alpha 1
Kit Allocation Flag This field indicates whether the kit
has been allocated.
0 = Kit allocated
1 = Kit needs options chosen
COL-HOLD-CODE Alpha 4
Hold Code If the line is on hold, this field
contains the hold code. Hold codes are
set up in the Accounts Receivable
system.
COL-INV-LOC Alpha 5
Inventory Location This field contains the location from
which inventory is taken.
COL-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company. If you are using the General
Ledger Interface system, the process
level determines which general ledger
account the order's invoice debits when
its rate updates to the Accounts
Receivable system.
COL-SPR-UOM Alpha 4
Selling Price Unit This field contains the pricing unit of
of Measure measure. This must be a valid pricing
unit of measure for the item if the line
is not a special order line.
COL-SELL-UOM Alpha 4 WH126
Sell Unit of Measure 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.
COL-SEC-UOM Alpha 4
Secondary Unit of This field contains the secondary
Measure quantity unit of measure. This is used
only when the item is a catch weight
item.
COL-NO-CHARGE-FL Alpha 1
No Charge Flag 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 the Accounts
Receivable system for collection.
N = No
Y = Yes
COL-RATE-OVR-FL Alpha 1
Rate Ovr Fl This flag indicates whether the
currency conversion rate was overridden
for this line of the order.
Y = Yes
N = No
COL-PRICE-STATUS Alpha 1
Price Status This field indicates how the line was
priced.
A = Amalgamated (group) pricing
C = System calculated pricing
O = Price override
COL-PRICE-DATE Numeric 8 (yyyymmdd)
Price Date This field contains the date used to
price the line. The system date defaults
when the line is added.
COL-ENTERED-PRICE Signed 13.5
Entered Price This field contains the unit price in
the currency of the order.
COL-UNIT-PRICE Signed 13.5
Unit Price This field contains the unit price in
base currency. This is an amount per
stock unit of measure.
COL-SELL-UNIT-PRC Signed 15.7
Sell Unit Prc 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.
COL-SELL-PRC-CURR Signed 15.7
Sell Prc Curr 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.
COL-UNIT-COST Signed 13.5
Unit Cost This field contains the unit cost.
COL-DISC-AMT-CURR Signed 15.2
Disc Amt Curr This field contains the discount amount
in transaction currency.
COL-MULT-DISC-AMT Derived
Mult Disc Amt 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 Derived
Div Disc Amt 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 Derived
Disc Amt Base This field contains the discount amount
in base currency.
COL-DISC-CODE Alpha 10
Disc Code This field contains the discount code
used to calculate the discount amount
for this line.
COL-MULT-SPR-FL Alpha 1
Mult Spr Fl This field indicates whether the item
has multiple pricing.
Y = Yes
N = No
COL-SPR-TO-STOCK Signed 13.7
Spr To Stock This field contains the multiplier used
with special order items when converting
from pricing unit of measure to stock
unit of measure.
COL-SELL-TO-STOCK Signed 13.7
Sell To Stock This field contains the multiplier that
is used with special order items when
converting from selling unit of measure
to stock unit of measure.
COL-SEC-TO-STOCK Signed 13.7
Sec To Stock This field contains the multiplier that
is used with catch weight items when
converting secondary unit of measure to
stock unit of measure.
COL-ORD-DISC-FL Alpha 1
Order Discount Flag This field indicates whether this line
is eligible for an order discount.
Y = Yes
N = No
COL-CUST-SHIP-TO Numeric 4
Customer Ship to This field contains the ship-to
Number customer number. This defaults from the
order header.
COL-CREATE-PO Alpha 1
Create Purchase This field indicates the item is
Order Flag ordered by a purchase order rather than
using stock.
N = No
Y = Yes
COL-DROPSHIP-FL Alpha 1
Dropship Flag 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
COL-CARRIER Alpha 9 (Right Justified)
Carrier Vendor This field contains the carrier number.
Number This must be a valid vendor defined in
the Accounts Payable system.
COL-PO-NUMBER Alpha 14 (Right Justified)
PO Number This field contains the number
representing the purchase order. This is
used if the purchase order line is added
to an existing purchase order.
COL-PO-CODE Alpha 4
Po Code This is the purchase order code that
will be used as part of the purchase
order number for a create po order line.
COL-VENDOR Alpha 9 (Right Justified)
Vendor ID This field contains the vendor of the
purchase order. If left blank, the
Purchase Order system assigns a vendor
to the purchase order.
COL-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
COL-IF-REF-NBR Numeric 9
Reference Number This field contains an internally
generated reference number used by the
Requisition system.
COL-ROUTE Numeric 4 WH120 WH21.3
Route This field contains the route number. WH21.4
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.
COL-STOP Numeric 4 WH120 WH21.3
Stop This field contains the stop within the WH21.4
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.
COL-RTE-CREATE-FL Alpha 1 WH120 WH130
Rte Create Fl This field indicates whether a route WH21.1 WH21.2
record exists for this line. WH33.1 WH33.2
Y = Yes WH33.3 WH33.4
N = No WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
COL-EXP-DELIV-DT Numeric 8 (yyyymmdd) WH120 WH21.3
Exp Deliv Dt This field contains the expected WH21.4
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.
COL-TERRITORY Alpha 4
Sales Territory 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.
COL-SALESMAN Numeric 4
Salesman Number This field contains the code that
represents the primary sales
representative of this line. This
defaults from the order header.
COL-SALESMAN-2 Numeric 4
Salesman Number 2 This field contains the code
representing the second sales
representative. This defaults from the
order header.
COL-COMM-SPLIT Percent 5.3 (Percent)
Commission Split Commission split for the second sales
Percentage representative. This is the percentage
of this line's total value the secondary
sales representative's commission rate
is applied to.
COL-COMM-RATE-1 Percent 7.5 (Percent)
Commission Rate for Commission rate for sales
Slsmn 1 representative 1. Defaults from the
sales representative file.
COL-COMM-RATE-2 Percent 7.5 (Percent)
Commission Rate for This field contains the commission rate
Slsmn 2 for the second sales representative.
This defaults from the sales
representative file.
COL-ENTERED-DISC Signed 15.2
Entered Disc This field contains a per line discount
rather than a per unit discount as
entered in the order-line's billing
currency.
COL-MULT-ADD-DISC Derived
Mult Add Disc 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 Derived
Div Add Disc 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 Derived
Add Disc Base This field contains the additional
discount amount in base currency.
COL-DISC-TKN-CURR Signed 15.2
Disc Tkn Curr 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.
COL-MULT-DISC-TKN Derived
Mult Disc Tkn 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 Derived
Div Disc Tkn 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 Derived
Disc Tkn Base This field contains the amount of
additional discount in base currency
used by invoices for this order line.
COL-TAX-EXEMPT-CD Alpha 1
Tax Exempt Code 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
COL-TAX-CODE Alpha 10
Tax Code 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 the Tax system
and can be associated with the customer
or entered when adding the order.
COL-TAXABLE-CURR Signed 15.2
Taxable Curr This field contains the taxable amount
in billing currency.
COL-MULT-TAXABLE Derived
Mult Taxable This field contains the taxable amount
in base currency if a multiplier is used
to convert from original to base
currency.
COL-DIV-TAXABLE Derived
Div Taxable This field contains the taxable amount
in base currency if a divider is used to
convert from original to base currency.
COL-OVR-TAXABLE Signed 15.2
Ovr Taxable This field contains the override
taxable amount in base currency.
COL-MULT-OVR-TXBL Derived
Mult Ovr Txbl 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 Derived
Div Ovr Txbl 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 Derived
Taxable Base This field contains the override
taxable amount in base currency.
COL-EARLY-DL-DATE Numeric 8 (yyyymmdd)
Early Delivery Date This field contains the early delivery
(Rqst DT) date.
COL-LATE-DL-DATE Numeric 8 (yyyymmdd)
Late Delivery Date This field contains the late delivery
date.
COL-USER-DATE-3 Numeric 8 (yyyymmdd)
User Date 3 This field contains the third
user-definable date.
COL-USER-DATE-4 Numeric 8 (yyyymmdd)
User Date 4 This field contains the fourth
user-defined date. Informational
purposes only used on OE280 (Open Orders
by Customer).
COL-USER-FLD1 Alpha 2
User Defined Field 1 This field contains the first
user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system.
COL-USER-FLD2 Alpha 30 (Lower Case)
User Defined Field 2 This field contains the second
user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system. This field also updates to the
Sales Analysis system.
COL-USER-FLD3 Alpha 15 (Lower Case)
User Defined Field 3 This field contains the third
user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system. This field also updates to the
Sales Analysis system.
COL-EXP-SHIP-DT Numeric 8 (yyyymmdd)
Expected Ship Date 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.
COL-ALLOCATE-DT Numeric 8 (yyyymmdd)
Allocation Date 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.
COL-LIST-NAME Alpha 14
List Name This field contains the name of the
price list, if this line is priced using
a price list or a promotion.
COL-CONTRACT-NBR Alpha 14
Contract Number This field contains the contract
number, if this line is priced using a
contract.
COL-PROMOTION Alpha 10
Promotion 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.
COL-ACTIVITY Alpha 15
Activity 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 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.
COL-ACCT-CATEGORY Alpha 5
Account Category 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.
COL-ATN-OBJ-ID Numeric 12
Atn Object ID 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.
COL-ACTIVITY-C Alpha 15
Activity C 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 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.
COL-ACCT-CATEG-C Alpha 5
Acct Categ C 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.
COL-ATN-OBJ-ID-C Numeric 12
Atn Obj Id C The system defined object id
representing the Activity Management
commitment for Cost (COGS).
COL-BOOKED-FL Alpha 1
Booked Fl This field indicates if the order line
has been booked by the Sales Analysis
system.
COL-BOOKED-DATE Numeric 8 (yyyymmdd)
Booked Date This field indicates the date when the
order line was booked by the Sales
Analysis system.
COL-BOOKED-QTY Signed 13.4
Booked Quantity This field contains the quantity booked
to the customer and sales representative
totals. This is updated to the Sales
Analysis system for reporting and
inquiry analysis.
COL-ORDER-QTY Signed 13.4 BL125 WH130
Order Quantity The order quantity of the line item.
COL-SHIPPED-QTY Signed 13.4 WH126 WH130
Shipped Quantity This field contains the shipped WH33.1 WH33.2
quantity. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
COL-INVOICE-QTY Signed 13.4
Invoice Quantity This field contains the quantity that
has been invoiced for this order line.
COL-RETURNED-QTY Signed 13.4
Returned Qty Total quantity returned compared to
this quantity.
COL-FIRM-FL Alpha 1
Firm Fl 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
COL-SHIP-COMP-FL Alpha 1
Ship Comp Fl
COL-PK-PRIORITY Numeric 2
Picking Priority
COL-SLS-ACCT-UNIT Alpha 15
Sales Accounting This field contains the sales account
Unit unit, if the line is special order. If
left blank, this defaults from the
process level.
COL-SLS-ACCOUNT Numeric 6
Sales Account 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.
COL-SLS-SUB-ACCT Numeric 4
Sales Subaccount This field contains the sales
subaccount number, if the line is
special order. If left blank, this
defaults from the process level.
COL-EXP-ACCT-UNIT Alpha 15
Expense Accounting This field contains the general ledger
Unit account to credit for the cost amount of
nonstock and special orders. This
defaults from the process level for
special order lines and from the
major/minor sales class file for
nonstock lines.
COL-EXP-ACCOUNT Numeric 6
Expense Account This field contains the general ledger
distribution account that is credited
for nonstock and special orders. This
defaults from the process level for
special orders and from major/minor
sales class for nonstock orders.
COL-EXP-SUB-ACCT Numeric 4
Depr Expense This field contains the general ledger
Subaccount distribution subaccount that is credited
for nonstock and special orders. This
defaults from the process level for
special orders and from the major/minor
sales class for nonstock orders.
COL-CGS-ACCT-UNIT Alpha 15
Cost Of Goods Sold The cost of goods sold account unit is
Acct Unit debited and defaults from the process
level for special order items or from
the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-CGS-ACCOUNT Numeric 6
Cost Of Goods Sold The cost of goods sold account number
Account is debited and defaults from the process
level for special order items or from
the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-CGS-SUB-ACCT Numeric 4
Cost Of Goods Sold The cost of goods sold subaccount
Sub Account number is debited and defaults from the
process level for special order items or
from the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-PROD-TAX-CAT Alpha 15
Product Tax Category 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.
COL-CXL-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Cancel Date This field contains the date this line WH33.2 WH33.3
was canceled. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
COL-CXL-QTY Signed 13.4 WH130 WH33.1
Cancel Quantity This field contains the quantity WH33.2 WH33.3
canceled for this order line. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
COL-CXL-OPR Alpha 10 (Lower Case) WH130 WH33.1
Cancel Operator This field contains the user ID of the WH33.2 WH33.3
person who canceled this order line. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
COL-CXL-REASON Alpha 4 WH130 WH33.1
Cancel Reason This field contains the reason for WH33.2 WH33.3
canceling this order. Reason codes are WH33.4 WH33.5
set up in BL07.1 (Reason Codes). WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
COL-LAST-COMM-SEQ Numeric 3 BLI2.1
Last Comment This field contains the sequence number
Sequence Number of the last comment line entered on this
line.
COL-LAST-MISC-SEQ Numeric 3
Last Misc Code This field contains the last sequence
Sequence used for miscellaneous charges for this
line.
COL-MSDS-REQ-FL Alpha 1
MSDS Required Flag 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.
The Order Entry system does not create
MSDS forms, but it keeps track of when
the form was sent.
Y = Yes
N = No
COL-LAST-SHIP-NBR Numeric 10
Last Ship Nbr This field contains the last shipment
number created for this order line.
COL-WORK-ORDER Numeric 8
Work Order 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 Numeric 2
Work Order Suf This is the suffix of the work order
the line may be associated with. It
will normally be zero.
COL-PRICE-REC-TYPE Alpha 1
Price Rec Type C = Class
I = Item
COL-QTY-BREAK-FL Alpha 1
Qty Break Fl Y = Yes
N = No
COL-GROSS-AMOUNT Derived
Gross Amount This field contains the line extension
in base currency before discounts are
taken.
COL-NET-AMOUNT Derived
Net Amount This field contains the line amount in
base currency after discounts have been
removed.
COL-CURR-GROSS Derived
Curr Gross This field contains the gross amount in
transaction currency.
COL-CURR-NET Derived
Curr Net This field contains the line net amount
in transaction currency.
COL-OPEN-TO-ALLOC Derived
Open To Alloc This field contains quantity available
for allocation.
COL-ALLOC-NOT-PRT Derived
Alloc Not Prt This field contains the allocated
quantity that has not been printed on
the picking list.
COL-PROJ-STD-COST Derived
Proj Std Cost 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 Derived
Proj Avg Cost 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 Derived
Proj Spl Cost 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 Derived
Proj Cost 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 Derived
Proj Margin This field contains the projected
margin for this line.
COL-UNBILLED-QTY Derived
Unbilled Qty This field contains the unbilled
quantity on the line.
COL-UNBILLED-BASE Derived
Unbilled Base This field contains the unbilled
quantity on the order line in base
currency.
COL-UNBILLED-CURR Derived
Unbilled Curr This field contains the unbilled amount
in transaction currency.
COL-ORD-QTY-IN-STK Derived
Ord Qty In Stk This field contains the quantity of
item in stock unit of measure.
COL-BO-FL Derived
Backorder Flag This field indicates if the order line
was backordered.
COL-PRICE-LOC Derived
Price Loc This field indicates the pricing
location for the order line.
COL-ORDER-FILLER Derived
Order Filler Used to facilitate Drill Around to
shipments for this order.
COL-ORDER-NBR-A Derived
Order Nbr A Used to facilitate Drill Around to
shipments for this order.
COL-DISP-ALLOCATED Derived
Disp Allocated Used to facilitate Drill Around of
quantity allocated.
COL-DISP-PRINTED Derived
Disp Printed Used to facilitate Drill Around of pick
list quantity printed.
COL-DISP-IN-PROC Derived
Disp In Proc Used to facilitate Drill Around of
quantity in process.
COL-DISP-BACKORD Derived
Disp Backord Used to facilitate Drill Around of
quantity back ordered.
COL-COMM-LIT Derived
Comm Lit If comments are attached, this field
displays "comments exist."
COL-DER-ORIGIN-CD Derived
Der Origin Cd
COL-INTR-COMP Alpha 1
Intr Comp 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
COL-FOB-CODE Alpha 3
Shipping Term Code The user defined Free On Board Code.
COL-PORT-CD Alpha 5
Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
COL-NOTC Alpha 2
Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
COL-STAT-PROC Alpha 6
Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
COL-SUPLMNTARY-UOM Alpha 4
Suplmntary Uom
COL-SUPLMNTARY-QTY Signed 13.4
Suplmntary Qty
COLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 COMPANY BL125 BL80.1
ORDER-NBR BLI2.1 POIJ.1
LINE-NBR WH110 WH120
WH126 WH130
WH21.1 WH21.2
WH21.3 WH21.4
WH22.1 WH224
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
COLSET10 COMPANY KeyChange
ORDER-NBR
TAX-CODE
PROD-TAX-CAT
LINE-NBR
COLSET11 COMPANY Subset
CUSTOMER Where CREATE-PO = "Y"
ORDER-NBR And DROPSHIP-FL = "Y"
LINE-NBR And STATUS = 2
And ORDER-QTY > INVOICE-QTY
COLSET12 COMPANY Subset
CUSTOMER Where STATUS = 2
ORDER-NBR And CREATE-PO = "Y"
LINE-NBR And ORDER-QTY > SHIPPED-QTY
COLSET13 COMPANY This index was created as a solution to
LINE-NBR the Find Next/Prev Flag error. It is
ORDER-NBR only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
COLSET2 COMPANY KeyChange, Subset WH120
INV-LOC Where STATUS = 2
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
COLSET3 COMPANY KeyChange WH21.1
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
COLSET4 COMPANY Subset
ORDER-NBR Where PRICE-STATUS = "A"
SALES-MAJCL
SALES-MINCL
LINE-NBR
COLSET5 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
COLSET6 COMPANY KeyChange, Subset
CUSTOMER Where HOLD-CODE != Spaces
HOLD-CODE
ORDER-NBR
LINE-NBR
COLSET7 COMPANY Subset WH210
ORDER-NBR Where STATUS < 3
LINE-NBR
COLSET8 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
COLSET9 COMPANY Subset
ORDER-NBR Where STATUS = 2
VENDOR And CREATE-PO = "Y"
CUST-SHIP-TO And ORDER-QTY > SHIPPED-QTY
DROPSHIP-FL
LINE-NBR
COLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COL-CARRIER != Spaces
COL-COMPANY -> CPY-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 COL-CURRENCY-CODE != COL-CURRENCY-CODE
GLS-CURRENCY-TABLE -> x u u ( -CURRENCY-TABLE
COR-CURRENCY-CODE -> x u u ( -FR-CURR-CODE
OEC-CURRENCY-CODE -> x u u ( -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
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
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
COLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
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
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
|
