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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL80.1 BL820
BL940 OE112 OE210 OE270 OE271 OE280
OE281 OE282 OE283 OE286 OE288 OE289
OE290 OE293 OE80.1 OE80.2 OE80.3 OE80.4
OE80.5 OE81.1 OE81.3 OE81.2 WH126 WH222
WH224 WH962 WH963 OE287 WH210
UPDATED BY
BL720 BL92.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.5 OE11.6 OE11.8 OE11.9 OE110 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE510 OE810 OE830 OE90.1 OE90.2 OE920
OE950 OE964 PO100 SA100 SA101 WH120
WH130 WH132 WH190 WH20.7 WH21.1 WH21.2
WH21.3 WH21.4 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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 WH966
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY Numeric 4 BL92.1 OE10.1
Company The company number represents an OE10.2 OE10.3
established company and is entered on OE10.4 OE10.5
all function codes. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
COL-ORDER-NBR Numeric 8 BL92.1 OE10.1
Order Number Each order is assigned a unique number. OE10.2 OE10.3
Order numbers are either manually OE10.4 OE10.5
assigned or system assigned based on a OE10.6 OE10.7
company-level option. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
COL-LINE-NBR Numeric 6 BL92.1 OE10.1
Line Number This field displays the line number of OE10.2 OE10.3
the transaction number. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-STATUS Numeric 1 BL92.1 OE10.1
Status This field indicates the status of this OE10.2 OE10.3
line on the order. OE10.4 OE10.5
0 = Needs clean-up OE10.6 OE10.7
1 = Unreleased OE10.8 OE11.1
2 = Released OE11.4 OE11.8
8 = Cancelled OE11.9 OE110
9 = Ready for delete OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-FUTURE-FL Alpha 1 BL92.1 OE10.1
Future Order Flag This field indicates if this line has a OE10.2 OE10.3
future status. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE920
OE964 WH20.7
COL-SALES-MAJCL Alpha 4 BL92.1 OE10.1
Sales Major Class This field contains the major sales OE10.2 OE10.3
class code. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SALES-MINCL Alpha 4 BL92.1 OE10.1
Sales Minor Class This field contains the minor sales OE10.2 OE10.3
class code within the major class. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ITEM Alpha 32 BL92.1 OE10.1
Item Number This field contains the item OE10.2 OE10.3
identifier. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ITEM-DESC Alpha 30 BL92.1 OE10.1
Item Description This field contains the description for OE10.2 OE10.3
stock and nonstock items. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7 WH222
COL-LINE-TYPE Alpha 1 BL92.1 OE10.1
Line Type The line type can be entered. Valid OE10.2 OE10.3
values are: OE10.4 OE10.5
. OE10.6 OE10.7
I = Inventoried. Default value. OE10.8 OE11.1
N = Nonstock. OE11.4 OE11.8
X = Special order. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ORIG-LINE Numeric 4 BL92.1 OE10.1
Original Line Number This field contains the original line OE10.2 OE10.3
number if it was overridden. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ORIG-ITEM Alpha 32 BL92.1 OE10.1
Original Item Number This field contains the original item OE10.2 OE10.3
number if it was overridden. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ORIG-FL Alpha 1 BL92.1 OE10.1
Orig Fl This field indicates whether this line OE10.2 OE10.3
was created as a result of item OE10.4 OE10.5
replacement or substitution. OE10.6 OE10.7
R = Replacement line OE10.8 OE11.1
S = Substitute line OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CUSTOMER Alpha 9 (Right Justified) BL92.1 OE10.1
Customer Number This field contains the number that OE10.2 OE10.3
represents a customer. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CUST-ITEM-FL Alpha 1 BL92.1 OE10.1
Customer Item This field indicates whether the number OE10.2 OE10.3
Numbers Used Fl entered in the order line represents an OE10.4 OE10.5
item set up in the Order Entry Customer OE10.6 OE10.7
file. OE10.8 OE11.1
C = Customer item was entered OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CUST-ITEM Alpha 32 BL92.1 OE10.1
Customer Item Number This field contains the customer's item OE10.2 OE10.3
number. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-KIT-FL Alpha 1 BL92.1 OE10.1
Kit Flag This field indicates when the item OE10.2 OE10.3
ordered is a made-to-order kit. OE10.4 OE10.5
N = Not a kit OE10.6 OE10.7
O = Make to order kit OE10.8 OE11.1
S = Make to stock kit OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-KIT-ALLOC-FL Alpha 1 BL92.1 OE10.1
Kit Allocation Flag This field indicates whether the kit OE10.2 OE10.3
has been allocated. OE10.4 OE10.5
0 = Kit allocated OE10.6 OE10.7
1 = Kit needs options chosen OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-HOLD-CODE Alpha 4 BL92.1 OE10.1
Hold Code If the line is on hold, this field OE10.2 OE10.3
contains the hold code. Hold codes are OE10.4 OE10.5
set up in the Accounts Receivable OE10.6 OE10.7
system. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.2 OE920
OE964 WH20.7
COL-INV-LOC Alpha 5 BL92.1 OE10.1
Inventory Location This field contains the location from OE10.2 OE10.3
which inventory is taken. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-PROCESS-LEVEL Alpha 5 BL92.1 OE10.1
Process Level This field contains the process level, OE10.2 OE10.3
which is the reporting hierarchy below OE10.4 OE10.5
company. If you are using the General OE10.6 OE10.7
Ledger Interface system, the process OE10.8 OE11.1
level determines which general ledger OE11.4 OE11.8
account the order's invoice debits when OE11.9 OE110
its rate updates to the Accounts OE113 OE114
Receivable system. OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SPR-UOM Alpha 4 BL92.1 OE10.1
Selling Price Unit This field contains the pricing unit of OE10.2 OE10.3
of Measure measure. This must be a valid pricing OE10.4 OE10.5
unit of measure for the item if the line OE10.6 OE10.7
is not a special order line. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SELL-UOM Alpha 4 BL92.1 OE10.1
Sell Unit of Measure This field contains the stock unit of OE10.2 OE10.3
measure for the item. If entered, it OE10.4 OE10.5
must be a valid stock unit of measure OE10.6 OE10.7
for this line's item. If not entered, OE10.8 OE11.1
the default stock unit of measure for OE11.4 OE11.8
this line's item is assigned. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH126 WH20.7
COL-SEC-UOM Alpha 4 BL92.1 OE10.1
Secondary Unit of This field contains the secondary OE10.2 OE10.3
Measure quantity unit of measure. This is used OE10.4 OE10.5
only when the item is a catch weight OE10.6 OE10.7
item. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-NO-CHARGE-FL Alpha 1 BL92.1 OE10.1
No Charge Flag This field indicates the item's price OE10.2 OE10.3
is zero. This defaults to No. If set to OE10.4 OE10.5
Yes, this field prevents the system from OE10.6 OE10.7
pricing the item. No charge invoices are OE10.8 OE11.1
not to be passed to the Accounts OE11.4 OE11.8
Receivable system for collection. OE11.9 OE110
N = No OE113 OE114
Y = Yes OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-RATE-OVR-FL Alpha 1 BL92.1 OE10.1
Rate Override Flag This flag indicates whether the OE10.2 OE10.3
currency conversion rate was overridden OE10.4 OE10.5
for this line of the order. OE10.6 OE10.7
Y = Yes OE10.8 OE11.1
N = No OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-PRICE-STATUS Alpha 1 BL92.1 OE10.1
Price Status This field indicates how the line was OE10.2 OE10.3
priced. OE10.4 OE10.5
A = Amalgamated (group) pricing OE10.6 OE10.7
C = System calculated pricing OE10.8 OE11.1
O = Price override OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-PRICE-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1
Price Date This field contains the date used to OE10.2 OE10.3
price the line. The system date defaults OE10.4 OE10.5
when the line is added. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ENTERED-PRICE Signed 13.5 BL92.1 OE10.1
Entered Price This field contains the unit price in OE10.2 OE10.3
the currency of the order. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-UNIT-PRICE Signed 13.5 BL92.1 OE10.1
Unit Price This field contains the unit price in OE10.2 OE10.3
base currency. This is an amount per OE10.4 OE10.5
stock unit of measure. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SELL-UNIT-PRC Signed 15.7 BL92.1 OE10.1
Sell Unit Price This field contains the price per sell OE10.2 OE10.3
unit of measure in base currency. If OE10.4 OE10.5
multiple unit of measure pricing is OE10.6 OE10.7
used, this is the weighted average price OE10.8 OE11.1
per sell unit of measure. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
COL-SELL-PRC-CURR Signed 15.7 BL92.1 OE10.1
Sell Prc Currency This field contains the price per sell OE10.2 OE10.3
unit of measure in transaction currency. OE10.4 OE10.5
If multiple unit of measure pricing is OE10.6 OE10.7
used, this is the weighted average price OE10.8 OE11.1
per sell unit of measure. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
COL-UNIT-COST Signed 13.5 BL92.1 OE10.1
Unit Cost This field contains the unit cost. OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-DISC-AMT-CURR Signed 15.2 BL92.1 OE10.1
Discount Amount This field contains the discount amount OE10.2 OE10.3
Currency in transaction currency. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
COL-MULT-DISC-AMT Derived
Mult Disc Amount 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
Discount Amount Base This field contains the discount amount
in base currency.
COL-DISC-CODE Alpha 10 BL92.1 OE10.1
Disc Code This field contains the discount code OE10.2 OE10.3
used to calculate the discount amount OE10.4 OE10.5
for this line. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-MULT-SPR-FL Alpha 1 BL92.1 OE10.1
Mult Spr Fl This field indicates whether the item OE10.2 OE10.3
has multiple pricing. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SPR-TO-STOCK Signed 13.7 BL92.1 OE10.1
Spr to Stock This field contains the multiplier used OE10.2 OE10.3
with special order items when converting OE10.4 OE10.5
from pricing unit of measure to stock OE10.6 OE10.7
unit of measure. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SELL-TO-STOCK Signed 13.7 BL92.1 OE10.1
Sell to Stock This field contains the multiplier that OE10.2 OE10.3
is used with special order items when OE10.4 OE10.5
converting from selling unit of measure OE10.6 OE10.7
to stock unit of measure. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE920 OE950
OE964 WH20.7
COL-SEC-TO-STOCK Signed 13.7 BL92.1 OE10.1
Sec to Stock This field contains the multiplier that OE10.2 OE10.3
is used with catch weight items when OE10.4 OE10.5
converting secondary unit of measure to OE10.6 OE10.7
stock unit of measure. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ORD-DISC-FL Alpha 1 BL92.1 OE10.1
Order Discount Flag This field indicates whether this line OE10.2 OE10.3
is eligible for an order discount. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CUST-SHIP-TO Numeric 4 BL92.1 OE10.1
Customer Ship to This field contains the ship-to OE10.2 OE10.3
Number customer number. This defaults from the OE10.4 OE10.5
order header. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CREATE-PO Alpha 1 BL92.1 OE10.1
Create Purchase This field indicates the item is OE10.2 OE10.3
Order Flag ordered by a purchase order rather than OE10.4 OE10.5
using stock. OE10.6 OE10.7
N = No OE10.8 OE11.1
Y = Yes OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-DROPSHIP-FL Alpha 1 BL92.1 OE10.1
Dropship Flag This field indicates whether the items OE10.2 OE10.3
of the purchase order are sent directly OE10.4 OE10.5
from the vendor to the customer. If this OE10.6 OE10.7
field is set to No, items are shipped to OE10.8 OE11.1
the user who entered the order for OE11.4 OE11.8
shipment to the customer. OE11.9 OE110
N = No OE113 OE114
Y = Yes OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CARRIER Alpha 9 BL92.1 OE10.1
Carrier Vendor This field contains the carrier number. OE10.2 OE10.3
Number This must be a valid vendor defined in OE10.4 OE10.5
the Accounts Payable system. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-PO-NUMBER Alpha 7 (Right Justified) BL92.1 OE10.1
PO Number This field contains the number OE10.2 OE10.3
representing the purchase order. This is OE10.4 OE10.5
used if the purchase order line is added OE10.6 OE10.7
to an existing purchase order. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
PO100 WH20.7
COL-VENDOR Alpha 9 BL92.1 OE10.1
Vendor ID This field contains the vendor of the OE10.2 OE10.3
purchase order. If left blank, the OE10.4 OE10.5
Purchase Order system assigns a vendor OE10.6 OE10.7
to the purchase order. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-IF-REF-NBR Numeric 9 BL92.1 OE10.1
Reference Number This field contains an internally OE10.2 OE10.3
generated reference number used by the OE10.4 OE10.5
Requisition system. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ROUTE Numeric 4 BL92.1 OE10.1
Route This field contains the route number. OE10.2 OE10.3
If left blank, the route assigned to the OE10.4 OE10.5
ship-to customer defaults from the Order OE10.6 OE10.7
Entry Route file. If no route is OE10.8 OE11.1
assigned to the ship-to customer in the OE11.4 OE11.8
Order Entry Route file, the route OE11.9 OE110
defaults from the customer. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE90.2
OE920 OE964
WH120 WH20.7
WH21.3 WH21.4
COL-STOP Numeric 4 BL92.1 OE10.1
Stop This field contains the stop within the OE10.2 OE10.3
route. If left blank, this defaults from OE10.4 OE10.5
the ship-to customer from the Order OE10.6 OE10.7
Entry Route file. If no stop is OE10.8 OE11.1
associated with the ship-to customer, OE11.4 OE11.8
this defaults from the customer's file. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE90.2
OE920 OE964
WH120 WH20.7
WH21.3 WH21.4
COL-RTE-CREATE-FL Alpha 1 BL92.1 OE10.1
RTE Create Flag This field indicates whether a route OE10.2 OE10.3
record exists for this line. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE90.2
OE920 OE964
WH120 WH130
WH132 WH190
WH20.7 WH21.1
WH21.2 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
...
COL-EXP-DELIV-DT Numeric 8 (yyyymmdd) BL92.1 OE10.1
Exp Deliv Dt This field contains the expected OE10.2 OE10.3
delivery date. This field is valid only OE10.4 OE10.5
for a company that uses routes and OE10.6 OE10.7
stops. The expected delivery date is OE10.8 OE11.1
calculated by adding the ship days from OE11.4 OE11.8
the process level associated with the OE11.9 OE110
order to the system date when the order OE113 OE114
is added. This field determines when the OE129 OE14.4
order prints on the picking list for OE15.1 OE15.2
processing. OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.1 OE90.2
OE920 OE964
WH120 WH20.7
WH21.3 WH21.4
COL-TERRITORY Alpha 4 BL92.1 OE10.1
Sales Territory This field contains the sales OE10.2 OE10.3
territory. If left blank, this defaults OE10.4 OE10.5
from the ship-to customer. If no sales OE10.6 OE10.7
territory is assigned to the ship-to OE10.8 OE11.1
customer, this defaults from the OE11.4 OE11.8
customer's file. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SALESMAN Numeric 4 BL92.1 OE10.1
Salesman Number This field contains the code that OE10.2 OE10.3
represents the primary sales OE10.4 OE10.5
representative of this line. This OE10.6 OE10.7
defaults from the order header. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SALESMAN-2 Numeric 4 BL92.1 OE10.1
Salesman Number 2 This field contains the code OE10.2 OE10.3
representing the second sales OE10.4 OE10.5
representative. This defaults from the OE10.6 OE10.7
order header. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-COMM-SPLIT Percent 5.3 (Percent) BL92.1 OE10.1
Commission Split Commission split for the second sales OE10.2 OE10.3
Percentage representative. This is the percentage OE10.4 OE10.5
of this line's total value the secondary OE10.6 OE10.7
sales representative's commission rate OE10.8 OE11.1
is applied to. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-COMM-RATE-1 Percent 7.5 (Percent) BL92.1 OE10.1
Commission Rate for Commission rate for sales OE10.2 OE10.3
Slsmn 1 representative 1. Defaults from the OE10.4 OE10.5
sales representative file. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-COMM-RATE-2 Percent 7.5 (Percent) BL92.1 OE10.1
Commission Rate for This field contains the commission rate OE10.2 OE10.3
Slsmn 2 for the second sales representative. OE10.4 OE10.5
This defaults from the sales OE10.6 OE10.7
representative file. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ENTERED-DISC Signed 15.2 BL92.1 OE10.1
Entered Disc This field contains a per line discount OE10.2 OE10.3
rather than a per unit discount as OE10.4 OE10.5
entered in the order-line's billing OE10.6 OE10.7
currency. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE286 OE510
OE810 OE920
OE964 WH20.7
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 BL92.1 OE10.1
Disc Tkn Curr This field contains the amount of the OE10.2 OE10.3
additional discount that has been used OE10.4 OE10.5
by invoices for this order line in OE10.6 OE10.7
billing currency. If you need to lower OE10.8 OE11.1
an additional discount on the line, the OE11.4 OE11.8
amount cannot be lowered below amount OE11.9 OE110
found in this field for this line. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
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 BL92.1 OE10.1
Tax Exempt Code This field contains the tax exempt OE10.2 OE10.3
code. This defaults from the order OE10.4 OE10.5
header. If the order header is tax OE10.6 OE10.7
exempt, the line is also tax exempt. OE10.8 OE11.1
E = Exempt OE11.4 OE11.8
T = Taxable OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-TAX-CODE Alpha 10 BL92.1 OE10.1
Tax Code This field contains a code representing OE10.2 OE10.3
the tax authorities this ship-to pays OE10.4 OE10.5
sales tax to. This must be valid in the OE10.6 OE10.7
Tax Code file. If the company is not OE10.8 OE11.1
using a third-party tax system, this OE11.4 OE11.8
code is the tax code for the order line. OE11.9 OE110
Tax codes are entered in the Tax system OE113 OE114
and can be associated with the customer OE129 OE14.4
or entered when adding the order. OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-TAXABLE-CURR Signed 15.2 BL92.1 OE10.1
Taxable Curr This field contains the taxable amount OE10.2 OE10.3
in billing currency. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.2 OE920
OE964 WH20.2
WH20.7
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 BL92.1 OE10.1
Ovr Taxable This field contains the override OE10.2 OE10.3
taxable amount in base currency. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE90.2 OE920
OE964 WH20.2
WH20.7
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) BL92.1 OE10.1
Early Delivery Date This field contains the early delivery OE10.2 OE10.3
(Rqst DT) date. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-LATE-DL-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1
Late Delivery Date This field contains the late delivery OE10.2 OE10.3
date. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-USER-DATE-3 Numeric 8 (yyyymmdd) BL92.1 OE10.1
User Date 3 This field contains the third OE10.2 OE10.3
user-definable date. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-USER-DATE-4 Numeric 8 (yyyymmdd) BL92.1 OE10.1
User Date 4 This field contains the fourth OE10.2 OE10.3
user-defined date. Informational OE10.4 OE10.5
purposes only used on OE280 (Open Orders OE10.6 OE10.7
by Customer). OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-USER-FLD1 Alpha 2 BL92.1 OE10.1
User Defined Field 1 This field contains the first OE10.2 OE10.3
user-definable field. If a purchase OE10.4 OE10.5
order is created for this order, this OE10.6 OE10.7
field updates to the Purchase Order OE10.8 OE11.1
system. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-USER-FLD2 Alpha 30 (Lower Case) BL92.1 OE10.1
User Defined Field 2 This field contains the second OE10.2 OE10.3
user-definable field. If a purchase OE10.4 OE10.5
order is created for this order, this OE10.6 OE10.7
field updates to the Purchase Order OE10.8 OE11.1
system. This field also updates to the OE11.4 OE11.8
Sales Analysis system. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-USER-FLD3 Alpha 15 (Lower Case) BL92.1 OE10.1
User Defined Field 3 This field contains the third OE10.2 OE10.3
user-definable field. If a purchase OE10.4 OE10.5
order is created for this order, this OE10.6 OE10.7
field updates to the Purchase Order OE10.8 OE11.1
system. This field also updates to the OE11.4 OE11.8
Sales Analysis system. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-EXP-SHIP-DT Numeric 8 (yyyymmdd) BL92.1 OE10.1
Expected Ship Date Expected ship date. Defaulted by the OE10.2 OE10.3
system as the number of ship days (from OE10.4 OE10.5
process level record) beyond the system OE10.6 OE10.7
date when the line is added. May be OE10.8 OE11.1
overridden. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ALLOCATE-DT Numeric 8 (yyyymmdd) BL92.1 OE10.1
Allocation Date This field contains the date used for OE10.2 OE10.3
batch allocations. The type of date OE10.4 OE10.5
depends on a company option, and can be OE10.6 OE10.7
the order date, the customer requested OE10.8 OE11.1
delivery date or the expected ship date. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-LIST-NAME Alpha 14 BL92.1 OE10.1
List Name This field contains the name of the OE10.2 OE10.3
price list, if this line is priced using OE10.4 OE10.5
a price list or a promotion. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CONTRACT-NBR Alpha 14 BL92.1 OE10.1
Contract Number This field contains the contract OE10.2 OE10.3
number, if this line is priced using a OE10.4 OE10.5
contract. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-PROMOTION Alpha 10 BL92.1 OE10.1
Promotion This field contains the promotion name, OE10.2 OE10.3
if this line is priced via a promotion. OE10.4 OE10.5
When combined with the list name, it OE10.6 OE10.7
provides access to the promotion file. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-ACTIVITY Alpha 15 BL92.1 OE10.1
Activity In this file the Activity field is used OE10.2 OE10.3
for the revenue (sales) side of the OE10.4 OE10.5
posting whereas the Activity-C field is OE10.6 OE10.7
used for the Cost (COGS) side of the OE10.8 OE11.1
posting. OE11.4 OE11.8
OE11.9 OE110
Activities are the processes or OE113 OE114
procedures that produce work. Cost OE129 OE14.4
objects (products, services, customers, OE15.1 OE15.2
and so on) are the reasons for OE15.3 OE15.4
performing the activity. Activities and OE15.5 OE15.7
cost object activities are used OE510 OE810
synonymously in the Activity Management OE920 OE964
system. Direct costs are posted to WH20.7
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 BL92.1 OE10.1
Account Category In this file the Acct-Category field is OE10.2 OE10.3
used for revenue (sales) postings OE10.4 OE10.5
whereas the Acct-Categ-C field is used OE10.6 OE10.7
for Cost (COGS) postings. OE10.8 OE11.1
OE11.4 OE11.8
Account categories are groupings of OE11.9 OE110
costs, revenues, or a combination of OE113 OE114
both used for reporting and inquiries OE129 OE14.4
for activities in the Activity OE15.1 OE15.2
Management system. All transactions are OE15.3 OE15.4
posted to an account category within an OE15.5 OE15.7
activity. You can assign a specific OE510 OE810
General Ledger account or range of OE920 OE964
accounts (company, accounting unit, WH20.7
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 BL92.1 OE10.1
AC System Object ID Represents Activity Management system OE10.2 OE10.3
(Sales) ID for the revenue (sales) activity. OE10.4 OE10.5
OE10.6 OE10.7
Activities are the processes or OE10.8 OE11.1
procedures that produce work. Cost OE11.4 OE11.8
objects (products, services, customers, OE11.9 OE110
and so on) are the reasons for OE113 OE114
performing the activity. Activities and OE129 OE14.4
cost object activities are used OE15.1 OE15.2
synonymously in the Activity Management OE15.3 OE15.4
system. Direct costs are posted to OE15.5 OE15.7
activities, and indirect costs are OE510 OE810
allocated to activities based on OE920 OE964
activity drivers. WH20.7
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-BOOKED-FL Alpha 1 BL92.1 OE10.1
Booked Fl This field indicates if the order line OE10.2 OE10.3
has been booked by the Sales Analysis OE10.4 OE10.5
system. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-BOOKED-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1
Booked Date This field indicates the date when the OE10.2 OE10.3
order line was booked by the Sales OE10.4 OE10.5
Analysis system. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-BOOKED-QTY Signed 13.4 BL92.1 OE10.1
Booked Quantity This field contains the quantity booked OE10.2 OE10.3
to the customer and sales representative OE10.4 OE10.5
totals. This is updated to the Sales OE10.6 OE10.7
Analysis system for reporting and OE10.8 OE11.1
inquiry analysis. OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
SA100 SA101
WH20.7
COL-ORDER-QTY Signed 13.4 BL120 BL92.1
Order Quantity The order quantity of the line item. OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE286
OE510 OE810
OE920 OE964
WH130 WH132
WH190 WH20.7
WH520 WH830
COL-SHIPPED-QTY Signed 13.4 BL92.1 OE10.1
Shipped Quantity This field contains the shipped OE10.2 OE10.3
quantity. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH126 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
COL-INVOICE-QTY Signed 13.4 BL92.1 OE10.1
Invoice Quantity This field contains the quantity that OE10.2 OE10.3
has been invoiced for this order line. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-DETAIL-QTY Signed 13.4 BL92.1 OE10.1
Detail Qty This field contains the total of all OE10.2 OE10.3
details (bin, lot, and so on) in stock OE10.4 OE10.5
unit of measure. This is only used for OE10.6 OE10.7
items that are bin, lot, or serial OE10.8 OE11.1
tracked and for which you have chosen OE11.4 OE11.8
these details prior to printing picking OE11.9 OE110
lists. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-RETURNED-QTY Signed 13.4 OE30.1 OE30.2
Rmt Addr1 Total quantity returned compared to OE30.3 OE30.4
this quantity. OE30.5 OE30.6
OE30.7 OE30.9
OE964
COL-FIRM-FL Alpha 1 BL92.1 OE10.1
Firm Fl This field indicates if the allocation OE10.2 OE10.3
is firm. If the value is set to Yes, OE10.4 OE10.5
WH110 (Batch Allocation) skips the OE10.6 OE10.7
record in the de-allocation phase. OE10.8 OE11.1
Y = Yes OE11.4 OE11.8
N = No OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SLS-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Sales Accounting This field contains the sales account OE10.2 OE10.3
Unit unit, if the line is special order. If OE10.4 OE10.5
left blank, this defaults from the OE10.6 OE10.7
process level. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SLS-ACCOUNT Numeric 6 BL92.1 OE10.1
Sales Account This field contains the sales account OE10.2 OE10.3
number, if the line is for a special OE10.4 OE10.5
order item. If left blank, this defaults OE10.6 OE10.7
from the process level. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-SLS-SUB-ACCT Numeric 4 BL92.1 OE10.1
Sales Subaccount This field contains the sales OE10.2 OE10.3
subaccount number, if the line is OE10.4 OE10.5
special order. If left blank, this OE10.6 OE10.7
defaults from the process level. OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-EXP-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Expense Accounting This field contains the general ledger OE10.2 OE10.3
Unit account to credit for the cost amount of OE10.4 OE10.5
nonstock and special orders. This OE10.6 OE10.7
defaults from the process level for OE10.8 OE11.1
special order lines and from the OE11.4 OE11.8
major/minor sales class file for OE11.9 OE110
nonstock lines. OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-EXP-ACCOUNT Numeric 6 BL92.1 OE10.1
Expense Account This field contains the general ledger OE10.2 OE10.3
distribution account that is credited OE10.4 OE10.5
for nonstock and special orders. This OE10.6 OE10.7
defaults from the process level for OE10.8 OE11.1
special orders and from major/minor OE11.4 OE11.8
sales class for nonstock orders. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-EXP-SUB-ACCT Numeric 4 BL92.1 OE10.1
Depr Expense This field contains the general ledger OE10.2 OE10.3
Subaccount distribution subaccount that is credited OE10.4 OE10.5
for nonstock and special orders. This OE10.6 OE10.7
defaults from the process level for OE10.8 OE11.1
special orders and from the major/minor OE11.4 OE11.8
sales class for nonstock orders. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-CXL-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1
Cancel Date This field contains the date this line OE10.2 OE10.3
was canceled. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
COL-CXL-QTY Signed 13.4 BL92.1 OE10.1
Cancel Quantity This field contains the quantity OE10.2 OE10.3
canceled for this order line. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
COL-CXL-OPR Alpha 10 (Lower Case) BL92.1 OE10.1
Cancel Operator This field contains the user ID of the OE10.2 OE10.3
person who canceled this order line. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
COL-CXL-REASON Alpha 4 BL92.1 OE10.1
Cancel Reason This field contains the reason for OE10.2 OE10.3
canceling this order. Reason codes are OE10.4 OE10.5
set up in BL07.1 (Reason Codes). OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
COL-LAST-COMM-SEQ Numeric 3 BL92.1 OE10.1
Last Comment This field contains the sequence number OE10.2 OE10.3
Sequence Number of the last comment line entered on this OE10.4 OE10.5
line. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-LAST-MISC-SEQ Numeric 3 BL92.1 OE10.1
Last Misc Code This field contains the last sequence OE10.2 OE10.3
Sequence used for miscellaneous charges for this OE10.4 OE10.5
line. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7
COL-MSDS-REQ-FL Alpha 1 BL92.1 OE10.1
MSDS Required Flag This field indicates that an MSDS OE10.2 OE10.3
(Material Safety Data Sheet) is OE10.4 OE10.5
required. If set to Yes, an MSDS OE10.6 OE10.7
acknowledgment is required for the first OE10.8 OE11.1
shipment containing the item even if an OE11.4 OE11.8
MSDS acknowledgment has been sent within OE11.9 OE110
a year for this item to the customer. OE113 OE114
The Order Entry system does not create OE129 OE14.4
MSDS forms, but it keeps track of when OE15.1 OE15.2
the form was sent. OE15.3 OE15.4
Y = Yes OE15.5 OE15.7
N = No OE510 OE810
OE920 OE964
WH20.7
COL-LAST-SHIP-NBR Numeric 10 BL92.1 OE10.1
Last Ship Nbr This field contains the last shipment OE10.2 OE10.3
number created for this order line. OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 OE964
WH20.7 WH966
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
Allocated Qty Not This field contains the allocated
Printed 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-S-ACCT-UNIT Derived
S Acct Unit This field represents the sales
accounting unit for the order line.
COL-S-ACCOUNT Derived
S Account This field represents the sales account
for the order line.
COL-S-SUB-ACCT Derived
S Sub Acct This field represents the sales
subaccount for the order line.
COL-I-ACCT-UNIT Derived
I Acct Unit This field represents the inventory
accounting unit for the order line.
COL-I-ACCOUNT Derived
I Account This field represents the inventory
account for the order line.
COL-I-SUB-ACCT Derived
I Sub Acct This field represents the inventory
subaccount for the order line.
COL-C-ACCT-UNIT Derived
C Acct Unit This field represents the COGS
accounting unit for the order line.
COL-C-ACCOUNT Derived
C Account This field represents the COGS account
for the order line.
COL-C-SUB-ACCT Derived
C Sub Acct This field represents the COGS
subaccount 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-ACTIVITY-C Alpha 15 BL92.1 OE10.1
Activity for Cst of In this file the Activity-C field is OE10.2 OE10.3
Goods Sold used for the Cost (COGS) side of the OE10.4 OE10.5
posting whereas the Activity field is OE10.6 OE10.7
used for the revenue (sales) side of the OE10.8 OE11.1
posting. OE11.4 OE11.8
OE11.9 OE110
Activities are the processes or OE113 OE114
procedures that produce work. Cost OE129 OE14.4
objects (products, services, customers, OE15.1 OE15.2
and so on) are the reasons for OE15.3 OE15.4
performing the activity. Activities and OE15.5 OE15.7
cost object activities are used OE510 OE810
synonymously in the Activity Management OE920 WH20.7
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 BL92.1 OE10.1
Acct Categ (Cst of In this file the Acct-Categ-C field is OE10.2 OE10.3
Goods Sold) used for Cost (COGS) postings whereas OE10.4 OE10.5
the Acct-Category field is used for OE10.6 OE10.7
revenue (sales) postings. OE10.8 OE11.1
OE11.4 OE11.8
Account categories are groupings of OE11.9 OE110
costs, revenues, or a combination of OE113 OE114
both used for reporting and inquiries OE129 OE14.4
for activities in the Activity OE15.1 OE15.2
Management system. All transactions are OE15.3 OE15.4
posted to an account category within an OE15.5 OE15.7
activity. You can assign a specific OE510 OE810
general ledger account or range of OE920 WH20.7
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 BL92.1 OE10.1
AC System Object ID The system defined object id OE10.2 OE10.3
(Cost) representing the Activity Management OE10.4 OE10.5
commitment for Cost (COGS). OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
COL-CGS-ACCT-UNIT Alpha 15 BL92.1 OE10.1
Cost Of Goods Sold The cost of goods sold account unit is OE10.2 OE10.3
Acct Unit debited and defaults from the process OE10.4 OE10.5
level for special order items or from OE10.6 OE10.7
the sales class for inventoried or OE10.8 OE11.1
nonstock items. This account is credited OE11.4 OE11.8
for return to stock transactions. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
COL-CGS-ACCOUNT Numeric 6 BL92.1 OE10.1
Cost Of Goods Sold The cost of goods sold account number OE10.2 OE10.3
Account is debited and defaults from the process OE10.4 OE10.5
level for special order items or from OE10.6 OE10.7
the sales class for inventoried or OE10.8 OE11.1
nonstock items. This account is credited OE11.4 OE11.8
for return to stock transactions. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
COL-CGS-SUB-ACCT Numeric 4 BL92.1 OE10.1
Cost Of Goods Sold The cost of goods sold subaccount OE10.2 OE10.3
Subaccount number is debited and defaults from the OE10.4 OE10.5
process level for special order items or OE10.6 OE10.7
from the sales class for inventoried or OE10.8 OE11.1
nonstock items. This account is credited OE11.4 OE11.8
for return to stock transactions. OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
COL-PROD-TAX-CAT Alpha 15 BL720 BL92.1
Product Tax Category A classification of items for OE10.1 OE10.2
determining taxes using the VERTEX OE10.3 OE10.4
system in Lawson Order Entry system or OE10.5 OE10.6
the cash receipts programs in the Lawson OE10.7 OE10.8
Cash Ledger system. OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH20.7
COLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 COMPANY BL120 BL122
ORDER-NBR BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL720 BL80.1
BL820 BL92.1
BL940 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.5
OE11.6 OE11.8
OE11.9 OE110
...
COLSET10 COMPANY KeyChange BL92.1 OE10.1
ORDER-NBR OE10.2 OE10.3
TAX-CODE OE10.4 OE10.5
PROD-TAX-CAT OE10.6 OE10.7
LINE-NBR OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE112 OE113
OE114 OE129
OE14.1 OE14.2
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE80.1 OE80.2
...
COLSET2 COMPANY KeyChange, Subset OE287 WH120
INV-LOC Where STATUS = 2
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
COLSET3 COMPANY OE81.2
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
COLSET4 COMPANY Subset BL92.1 OE10.1
ORDER-NBR Where PRICE-STATUS = "A" OE10.2 OE10.3
SALES-MAJCL OE10.4 OE10.5
SALES-MINCL OE10.6 OE10.7
LINE-NBR OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.2
WH20.7
COLSET5 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
COLSET6 COMPANY KeyChange, Subset OE90.2
CUSTOMER Where HOLD-CODE != Spaces
HOLD-CODE
ORDER-NBR
LINE-NBR
COLSET7 COMPANY Subset BL720 OE10.1
ORDER-NBR Where STATUS < 3 OE10.2 OE10.3
LINE-NBR OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.2
WH20.7 WH210
COLSET8 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
COLSET9 COMPANY Subset BL92.1 OE10.1
ORDER-NBR Where STATUS = 2 OE10.2 OE10.3
VENDOR And CREATE-PO = "Y" OE10.4 OE10.5
CUST-SHIP-TO And ORDER-QTY > SHIPPED-QTY OE10.6 OE10.7
DROPSHIP-FL OE10.8 OE11.1
LINE-NBR OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
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 -> 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
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
Pointerfac POINTERFAC Not Required
Valid When COL-STATUS = 2
And COL-CREATE-PO = "Y"
And COL-ORDER-QTY > COL-SHIPPED-QTY
COL-COMPANY -> PIF-COMPANY
"OE" -> PIF-ORIGIN-CD
COL-IF-REF-NBR -> PIF-IF-REF-NBR
COL-ORDER-NBR -> PIF-ORDER-NBR
COL-LINE-NBR -> PIF-LINE-NBR
Zeroes -> PIF-SEQ
Poline POLINE Not Required
Valid When COL-STATUS = 2
And COL-CREATE-PO = "Y"
And COL-ORDER-QTY > COL-SHIPPED-QTY
COL-COMPANY -> PLI-COMPANY
PIF-PO-NUMBER -> PLI-PO-NUMBER
PIF-PO-RELEASE -> PLI-PO-RELEASE
PIF-PO-LINE-NBR -> PLI-LINE-NBR
Promotion OEPRCLIST Required
When COL-PROMOTION > Spaces
COL-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
COR-LIST-NAME -> OPL-LIST-NAME
COL-PROMOTION -> OPL-PROMOTION
Purchorder PURCHORDER Not Required
Valid When COL-STATUS = 2
And COL-CREATE-PO = "Y"
And COL-ORDER-QTY > COL-SHIPPED-QTY
COL-COMPANY -> PCR-COMPANY
PIF-PO-NUMBER -> PCR-PO-NUMBER
PIF-PO-RELEASE -> PCR-PO-RELEASE
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
Whdemand WHDEMAND Required
COL-COMPANY -> WDM-COMPANY
"OE" -> WDM-SYSTEM-CD
WDH-DOC-NBR -> WDM-DOC-NBR
COL-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
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
Cocomp COCOMP
Valid When COL-KIT-FL = "O"
COL-COMPANY -> CKT-COMPANY
"OE" -> CKT-SYSTEM-CD
WDH-DOC-NBR -> CKT-DOC-NBR
COL-LINE-NBR -> CKT-LINE-NBR
CKT-COMPONENT-SEQ
Comisc COMISC
COL-COMPANY -> CMC-COMPANY
COL-ORDER-NBR -> CMC-ORDER-NBR
COL-LINE-NBR -> CMC-LINE-NBR
CMC-SEQ
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
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
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
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
ITS-SUB-ITEM
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
|