Lawson Insight Technical Documentation |
|
COLINE
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 IC11.1 WH126 WH222 WH224
WH226 WHD0.1 WH210
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BLI2.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH110 WH120 WH130 WH132 WH190 WH20.2
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH22.1
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 WHD2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ORDER-NBR Numeric 8 BL120 BL122
Element: Order Nbr Each order is assigned a unique number. BL130 BL20.1
Order numbers are either manually BL20.3 BL21.2
assigned or system assigned based on a BL21.5 BL29.1
company-level option. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr This field displays the line number of BL130 BL20.1
the transaction number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-STATUS Numeric 1 BL120 BL122
Element: Status This field indicates the status of this BL130 BL20.1
line on the order. BL20.3 BL21.2
0 = Needs clean-up BL21.5 BL29.1
1 = Unreleased BL29.2 BL520
2 = Released BL820 BL92.1
8 = Canceled WH20.7 WH22.1
9 = Ready for delete WHD2.1
COL-FUTURE-FL Alpha 1 BL120 BL122
Element: Future Fl This field indicates if this line has a BL130 BL20.1
future status. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SALES-MAJCL Alpha 4 BL120 BL122
Element: Major Class This field contains the major sales BL130 BL20.1
class code. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SALES-MINCL Alpha 4 BL120 BL122
Element: Minor Class This field contains the minor sales BL130 BL20.1
class code within the major class. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ITEM Alpha 32 BL120 BL122
Element: Item This field contains the item BL130 BL20.1
identifier. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ITEM-DESC Alpha 30 BL120 BL122
Element: Item Desc This field contains the description for BL130 BL20.1
stock and non-stock items. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7 WH222
COL-LINE-TYPE Alpha 1 BL120 BL122
Element: Line Type The line type can be entered. Valid BL130 BL20.1
values are: BL20.3 BL21.2
. BL21.5 BL29.1
I = Inventoried. Default value. BL29.2 BL520
N = Non-stock. BL820 BL92.1
X = Special order. WH20.7
COL-ORIG-LINE Numeric 4 BL120 BL122
Element: Orig Line This field contains the original line BL130 BL20.1
number if it was overridden. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ORIG-ITEM Alpha 32 BL120 BL122
Element: Item This field contains the original item BL130 BL20.1
number if it was overridden. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ORIG-FL Alpha 1 BL120 BL122
Element: Orig Fl This field indicates whether this line BL130 BL20.1
was created as a result of item BL20.3 BL21.2
replacement or substitution. BL21.5 BL29.1
R = Replacement line BL29.2 BL520
S = Substitute line BL820 BL92.1
WH20.7
COL-CUSTOMER Alpha 9 (Right Justified) BL120 BL122
Element: Customer This field contains the number that BL130 BL20.1
represents a customer. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-CUST-ITEM-FL Alpha 1 BL120 BL122
Element: Cust Item Fl This field indicates whether the number BL130 BL20.1
entered in the order line represents an BL20.3 BL21.2
item set up in the Order Entry Customer BL21.5 BL29.1
file. BL29.2 BL520
C = Customer item was entered BL820 BL92.1
WH20.7
COL-CUST-ITEM Alpha 32 BL120 BL122
Element: Item This field contains the customer's item BL130 BL20.1
number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-KIT-FL Alpha 1 BL120 BL122
Element: Kit Fl This field indicates when the item BL130 BL20.1
ordered is a made-to-order kit. BL20.3 BL21.2
N = Not a kit BL21.5 BL29.1
O = Make to order kit BL29.2 BL520
S = Make to stock kit BL820 BL92.1
WH20.7
COL-KIT-ALLOC-FL Alpha 1 BL120 BL122
Element: Kit Alloc Fl This field indicates whether the kit BL130 BL20.1
has been allocated. BL20.3 BL21.2
0 = Kit allocated BL21.5 BL29.1
1 = Kit needs options chosen BL29.2 BL520
BL820 BL92.1
WH20.7
COL-HOLD-CODE Alpha 4 BL120 BL122
Element: Hold Code If the line is on hold, this field BL130 BL20.1
contains the hold code. Hold codes are BL20.3 BL21.2
set up in Accounts Receivable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-INV-LOC Alpha 5 BL120 BL122
Element: Location This field contains a valid stocking BL130 BL20.1
location within the company inventory. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PROCESS-LEVEL Alpha 5 BL120 BL122
Element: Process Level This field contains the process level, BL130 BL20.1
which is the reporting hierarchy below BL20.3 BL21.2
company. The process level determines BL21.5 BL29.1
which general ledger account the order's BL29.2 BL520
invoice debits when its rate updates to BL820 BL92.1
Accounts Receivable. WH20.7
COL-SPR-UOM Alpha 4 BL120 BL122
Element: Uom This field contains the pricing unit of BL130 BL20.1
measure. This must be a valid pricing BL20.3 BL21.2
unit of measure for the item if the line BL21.5 BL29.1
is not a special order line. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SELL-UOM Alpha 4 BL120 BL122
Element: Uom This field contains the stock unit of BL130 BL20.1
measure for the item. If entered, it BL20.3 BL21.2
must be a valid stock unit of measure BL21.5 BL29.1
for this line's item. If not entered, BL29.2 BL520
the default stock unit of measure for BL820 BL92.1
this line's item is assigned. WH126 WH20.7
COL-SEC-UOM Alpha 4 BL120 BL122
Element: Uom This field contains the secondary BL130 BL20.1
quantity unit of measure. This is used BL20.3 BL21.2
only when the item is a catch weight BL21.5 BL29.1
item. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-NO-CHARGE-FL Alpha 1 BL120 BL122
Element: No Charge Fl This field indicates the item's price BL130 BL20.1
is zero. This defaults to No. If set to BL20.3 BL21.2
Yes, this field prevents the system from BL21.5 BL29.1
pricing the item. No charge invoices are BL29.2 BL520
not to be passed to Accounts Receivable BL820 BL92.1
for collection. WH20.7
N = No
Y = Yes
COL-RATE-OVR-FL Alpha 1 BL120 BL122
Element: Rate Ovr Fl This flag indicates whether the BL130 BL20.1
currency conversion rate was overridden BL20.3 BL21.2
for this line of the order. BL21.5 BL29.1
Y = Yes BL29.2 BL520
N = No BL820 BL92.1
WH20.7
COL-PRICE-STATUS Alpha 1 BL120 BL122
Element: Price Status This field indicates how the line was BL130 BL20.1
priced. BL20.3 BL21.2
A = Amalgamated (group) pricing BL21.5 BL29.1
C = System calculated pricing BL29.2 BL520
O = Price override BL820 BL92.1
WH20.7
COL-PRICE-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date used to BL130 BL20.1
price the line. The system date defaults BL20.3 BL21.2
when the line is added. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ENTERED-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price in BL130 BL20.1
the currency of the order. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-UNIT-PRICE Signed 18.5 BL120 BL122
Element: Intl Cost This field contains the unit price in BL130 BL20.1
base currency. This is an amount per BL20.3 BL21.2
stock unit of measure. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SELL-UNIT-PRC Signed 18.5 BL120 BL122
Element: Sell Unit Prc This field contains the price per sell BL130 BL20.1
unit of measure in base currency. If BL20.3 BL21.2
multiple unit of measure pricing is BL21.5 BL29.1
used, this is the weighted average price BL29.2 BL520
per sell unit of measure. BL820 BL92.1
WH20.7
COL-SELL-PRC-CURR Signed 18.5 BL120 BL122
Element: Sell Unit Prc This field contains the price per sell BL130 BL20.1
unit of measure in transaction currency. BL20.3 BL21.2
If multiple unit of measure pricing is BL21.5 BL29.1
used, this is the weighted average price BL29.2 BL520
per sell unit of measure. BL820 BL92.1
WH20.7
COL-UNIT-COST Signed 18.5 BL120 BL122
Element: Intl Cost BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-DISC-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the discount amount BL130 BL20.1
in transaction currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-MULT-DISC-AMT Derived
Element: 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
Element: 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
Element: Disc Amt Base This field contains the discount amount
in base currency.
COL-DISC-CODE Alpha 10 BL120 BL122
Element: Discount Code This field contains the discount code BL130 BL20.1
used to calculate the discount amount BL20.3 BL21.2
for this line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-MULT-SPR-FL Alpha 1 BL120 BL122
Element: All Flag Y = Yes BL130 BL20.1
N = No BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SPR-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier used BL130 BL20.1
with special order items when converting BL20.3 BL21.2
from pricing unit of measure to stock BL21.5 BL29.1
unit of measure. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SELL-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier that BL130 BL20.1
is used with special order items when BL20.3 BL21.2
converting from selling unit of measure BL21.5 BL29.1
to stock unit of measure. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SEC-TO-STOCK Signed 13.7 BL120 BL122
Element: Sell To Stock This field contains the multiplier that BL130 BL20.1
is used with catch weight items when BL20.3 BL21.2
converting secondary unit of measure to BL21.5 BL29.1
stock unit of measure. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ORD-DISC-FL Alpha 1 BL120 BL122
Element: Ord Disc Fl This field indicates whether this line BL130 BL20.1
is eligible for an order discount. BL20.3 BL21.2
Y = Yes BL21.5 BL29.1
N = No BL29.2 BL520
BL820 BL92.1
WH20.7
COL-CUST-SHIP-TO Numeric 4 BL120 BL122
Element: Ship To This field contains the ship-to BL130 BL20.1
customer number. This defaults from the BL20.3 BL21.2
order header. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-CREATE-PO Alpha 1 BL120 BL122
Element: All Flag This field indicates the item is BL130 BL20.1
ordered by a purchase order rather than BL20.3 BL21.2
using stock. BL21.5 BL29.1
N = No BL29.2 BL520
Y = Yes BL820 BL92.1
WH20.7
COL-DROPSHIP-FL Alpha 1 BL120 BL122
Element: Dropship Fl This field indicates whether the items BL130 BL20.1
of the purchase order are sent directly BL20.3 BL21.2
from the vendor to the customer. If this BL21.5 BL29.1
field is set to No, items are shipped to BL29.2 BL520
the user who entered the order for BL820 BL92.1
shipment to the customer. WH20.7
N = No
Y = Yes
COL-CARRIER Alpha 9 (Right Justified) BL120 BL122
Element: Vendor This field contains the carrier number. BL130 BL20.1
This must be a valid vendor defined in BL20.3 BL21.2
Accounts Payable. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PO-NUMBER Alpha 14 (Right Justified) BL120 BL122
Element: Po Number This field contains the number BL130 BL20.1
representing the purchase order. This is BL20.3 BL21.2
used if the purchase order line is added BL21.5 BL29.1
to an existing purchase order. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PO-CODE Alpha 4 BL120 BL122
Element: Po Code This is the purchase order code that BL130 BL20.1
will be used as part of the purchase BL20.3 BL21.2
order number for a create po order line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-VENDOR Alpha 9 (Right Justified) BL120 BL122
Element: Vendor This field contains the vendor of the BL130 BL20.1
purchase order. If left blank, Purchase BL20.3 BL21.2
Order assigns a vendor to the purchase BL21.5 BL29.1
order. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PURCH-FR-LOC Alpha 4 BL120 BL122
Element: Purch Fr Loc The vendor's purchase from location. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-IF-REF-NBR Numeric 9 BL120 BL122
Element: If Ref Nbr This field contains an internally BL130 BL20.1
generated reference number used by the BL20.3 BL21.2
Requisition system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ROUTE Numeric 4 BL120 BL122
Element: Route This field contains the route number. BL130 BL20.1
If left blank, the route assigned to the BL20.3 BL21.2
ship-to customer defaults from the Order BL21.5 BL29.1
Entry Route file. If no route is BL29.2 BL520
assigned to the ship-to customer in the BL820 BL92.1
Order Entry Route file, the route WH120 WH20.7
defaults from the customer. WH21.3 WH21.4
COL-STOP Numeric 4 BL120 BL122
Element: Stop This field contains the stop within the BL130 BL20.1
route. If left blank, this defaults from BL20.3 BL21.2
the ship-to customer from the Order BL21.5 BL29.1
Entry Route file. If no stop is BL29.2 BL520
associated with the ship-to customer, BL820 BL92.1
this defaults from the customer's file. WH120 WH20.7
WH21.3 WH21.4
COL-RTE-CREATE-FL Alpha 1 BL120 BL122
Element: All Flag Y = Yes BL130 BL20.1
N = No BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH110 WH120
WH130 WH132
WH190 WH20.7
WH21.1 WH21.2
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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-EXP-DELIV-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the expected BL130 BL20.1
delivery date. This field is valid only BL20.3 BL21.2
for a company that uses routes and BL21.5 BL29.1
stops. The expected delivery date is BL29.2 BL520
calculated by adding the ship days from BL820 BL92.1
the process level associated with the WH120 WH20.7
order to the system date when the order WH21.3 WH21.4
is added. This field determines when the
order prints on the picking list for
processing.
COL-TERRITORY Alpha 4 BL120 BL122
Element: Territory This field contains the sales BL130 BL20.1
territory. If left blank, this defaults BL20.3 BL21.2
from the ship-to customer. If no sales BL21.5 BL29.1
territory is assigned to the ship-to BL29.2 BL520
customer, this defaults from the BL820 BL92.1
customer's file. WH20.7
COL-SALESMAN Numeric 4 BL120 BL122
Element: Salesman This field contains the code that BL130 BL20.1
represents the primary sales BL20.3 BL21.2
representative of this line. This BL21.5 BL29.1
defaults from the order header. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SALESMAN-2 Numeric 4 BL120 BL122
Element: Salesman This field contains the code BL130 BL20.1
representing the second sales BL20.3 BL21.2
representative. This defaults from the BL21.5 BL29.1
order header. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-COMM-SPLIT Percent 5.3 (Percent) BL120 BL122
Element: Comm Split Commission split for the second sales BL130 BL20.1
representative. This is the percentage BL20.3 BL21.2
of this line's total value the secondary BL21.5 BL29.1
sales representative's commission rate BL29.2 BL520
is applied to. BL820 BL92.1
WH20.7
COL-COMM-RATE-1 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate Commission rate for sales BL130 BL20.1
representative 1. Defaults from the BL20.3 BL21.2
sales representative file. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-COMM-RATE-2 Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate This field contains the commission rate BL130 BL20.1
for the second sales representative. BL20.3 BL21.2
This defaults from the sales BL21.5 BL29.1
representative file. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ENTERED-DISC Signed 18.2 BL120 BL122
Element: Intl Amt This field contains a per line discount BL130 BL20.1
rather than a per unit discount as BL20.3 BL21.2
entered in the order-line's billing BL21.5 BL29.1
currency. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-MULT-ADD-DISC Derived
Element: 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
Element: 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
Element: Add Disc Base This field contains the additional
discount amount in base currency.
COL-DISC-TKN-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the amount of the BL130 BL20.1
additional discount that has been used BL20.3 BL21.2
by invoices for this order line in BL21.5 BL29.1
billing currency. If you need to lower BL29.2 BL520
an additional discount on the line, the BL820 BL92.1
amount cannot be lowered below amount WH20.7
found in this field for this line.
COL-MULT-DISC-TKN Derived
Element: 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
Element: 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
Element: 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 BL120 BL122
Element: Tax Exempt Cd This field contains the tax exempt BL130 BL20.1
code. This defaults from the order BL20.3 BL21.2
header. If the order header is tax BL21.5 BL29.1
exempt, the line is also tax exempt. BL29.2 BL520
E = Exempt BL820 BL92.1
T = Taxable WH20.7
COL-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code This field contains a code representing BL130 BL20.1
the tax authorities this ship-to pays BL20.3 BL21.2
sales tax to. This must be valid in the BL21.5 BL29.1
Tax Code file. If the company is not BL29.2 BL520
using a third-party tax system, this BL820 BL92.1
code is the tax code for the order line. WH20.7
Tax codes are entered in Tax and can be
associated with the customer or entered
when adding the order.
COL-TAXABLE-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This field contains the taxable amount BL130 BL20.1
in billing currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
COL-MULT-TAXABLE Derived
Element: 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
Element: 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 18.2 BL120 BL122
Element: Intl Amt This field contains the override BL130 BL20.1
taxable amount in base currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
COL-MULT-OVR-TXBL Derived
Element: 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
Element: 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
Element: Taxable Base This field contains the override
taxable amount in base currency.
COL-EARLY-DL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Early Dl Date This field contains the early delivery BL130 BL20.1
date. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-LATE-DL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Late Dl Date This field contains the late delivery BL130 BL20.1
date. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-USER-DATE-3 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field displays the system date BL130 BL20.1
when this was created. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-USER-DATE-4 Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the fourth BL130 BL20.1
user-defined date. Informational BL20.3 BL21.2
purposes only used on Orders Not Shipped BL21.5 BL29.1
for Customer (OE280). BL29.2 BL520
BL820 BL92.1
WH20.7
COL-USER-FLD1 Alpha 2 BL120 BL122
Element: Po User Fld 2 This field contains the first BL130 BL20.1
user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to Purchase Order. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-USER-FLD2 Alpha 30 (Lower Case) BL120 BL122
Element: User Fld2 This field contains the second BL130 BL20.1
user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to Purchase Order. This BL29.2 BL520
field also updates to Sales Analysis. BL820 BL92.1
WH20.7
COL-USER-FLD3 Alpha 15 (Lower Case) BL120 BL122
Element: User Fld3 This field contains the third BL130 BL20.1
user-definable field. If a purchase BL20.3 BL21.2
order is created for this order, this BL21.5 BL29.1
field updates to Purchase Order. This BL29.2 BL520
field also updates to Sales Analysis. BL820 BL92.1
WH20.7
COL-EXP-SHIP-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date Expected ship date. Defaulted by the BL130 BL20.1
system as the number of ship days (from BL20.3 BL21.2
process level record) beyond the system BL21.5 BL29.1
date when the line is added. May be BL29.2 BL520
overridden. BL820 BL92.1
WH20.7
COL-ALLOCATE-DT Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date used for BL130 BL20.1
batch allocations. The type of date BL20.3 BL21.2
depends on a company option, and can be BL21.5 BL29.1
the order date, the customer requested BL29.2 BL520
delivery date or the expected ship date. BL820 BL92.1
WH20.7
COL-LIST-NAME Alpha 14 BL120 BL122
Element: List Name This field contains the name of the BL130 BL20.1
price list, if this line is priced using BL20.3 BL21.2
a price list or a promotion. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-CONTRACT-NBR Alpha 14 BL120 BL122
Element: Contract Nbr This field contains the contract BL130 BL20.1
number, if this line is priced using a BL20.3 BL21.2
contract. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PROMOTION Alpha 10 BL120 BL122
Element: Promotion This field contains the promotion name, BL130 BL20.1
if this line is priced via a promotion. BL20.3 BL21.2
When combined with the list name, it BL21.5 BL29.1
provides access to the promotion file. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ACTIVITY Alpha 15 BL120 BL122
Element: Activity In this file the Activity field is used BL130 BL20.1
for the revenue (sales) side of the BL20.3 BL21.2
posting whereas the Activity-C field is BL21.5 BL29.1
used for the Cost (COGS) side of the BL29.2 BL520
posting. BL820 BL92.1
WH20.7
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEGORY Alpha 5 BL120 BL122
Element: Acct Category In this file the Acct-Category field is BL130 BL20.1
used for revenue (sales) postings BL20.3 BL21.2
whereas the Acct-Categ-C field is used BL21.5 BL29.1
for Cost (COGS) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of WH20.7
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
All transactions are posted to an
account category within an activity. You
can assign a specific General Ledger
account or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category using Account Assignment
(AC07.1).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID Numeric 12 BL120 BL122
Element: Obj Id Represents Activity Management system BL130 BL20.1
ID for the revenue (sales) activity. BL20.3 BL21.2
BL21.5 BL29.1
Activities are the processes or BL29.2 BL520
procedures that produce work. Cost BL820 BL92.1
objects (products, services, customers, WH20.7
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 BL120 BL122
Element: Activity In this file the Activity-C field is BL130 BL20.1
used for the Cost (COGS) side of the BL20.3 BL21.2
posting whereas the Activity field is BL21.5 BL29.1
used for the revenue (sales) side of the BL29.2 BL520
posting. BL820 BL92.1
WH20.7
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEG-C Alpha 5 BL120 BL122
Element: Acct Category In this file the Acct-Categ-C field is BL130 BL20.1
used for Cost (COGS) postings whereas BL20.3 BL21.2
the Acct-Category field is used for BL21.5 BL29.1
revenue (sales) postings. BL29.2 BL520
BL820 BL92.1
Account categories are groupings of WH20.7
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
All transactions are posted to an
account category within an activity. You
can assign a specific general ledger
account or range of accounts (company,
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category using Account Assignment
(AC07.1).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID-C Numeric 12 AP125 AP126
Element: Obj Id The system defined object id AP131 AP20.1
representing the Activity Management AP20.2 AP20.3
commitment for Cost (COGS). AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
PD20.1 PD20.2
...
COL-BOOKED-FL Alpha 1 BL120 BL122
Element: Account Flag This field indicates if the order line BL130 BL20.1
has been booked by the Sales Analysis BL20.3 BL21.2
system. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-BOOKED-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field indicates the date when the BL130 BL20.1
order line was booked by Sales Analysis. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-BOOKED-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the quantity booked BL130 BL20.1
to the customer and sales representative BL20.3 BL21.2
totals. This is updated to Sales BL21.5 BL29.1
Analysis for reporting and inquiry BL29.2 BL520
analysis. BL820 BL92.1
WH20.7
COL-ORDER-QTY Signed 13.4 BL120 BL122
Element: Quantity The order quantity of the line item. BL125 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 WH130
WH132 WH190
WH20.7 WH520
WH830
COL-SHIPPED-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the shipped BL130 BL20.1
quantity. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH126 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WHD2.1
COL-INVOICE-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the quantity that BL130 BL20.1
has been invoiced for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-RETURNED-QTY Signed 13.4
Element: Quantity Total quantity returned compared to
this quantity.
COL-FIRM-FL Alpha 1 BL120 BL122
Element: Firm Fl This field indicates if the allocation BL130 BL20.1
is firm. If the value is set to Yes, BL20.3 BL21.2
WH110 (Batch Allocation) skips the BL21.5 BL29.1
record in the de-allocation phase. BL29.2 BL520
Y = Yes BL820 BL92.1
N = No WH20.7
COL-SHIP-COMP-FL Alpha 1 BL120 BL122
Element: Ship Comp Fl BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PK-PRIORITY Numeric 2 BL120 BL122
Element: Pk Priority BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SLS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This field contains the sales account BL130 BL20.1
unit, if the line is special order. If BL20.3 BL21.2
left blank, this defaults from the BL21.5 BL29.1
process level. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SLS-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the sales account BL130 BL20.1
number, if the line is for a special BL20.3 BL21.2
order item. If left blank, this defaults BL21.5 BL29.1
from the process level. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SLS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct This field contains the sales BL130 BL20.1
subaccount number, if the line is BL20.3 BL21.2
special order. If left blank, this BL21.5 BL29.1
defaults from the process level. BL29.2 BL520
BL820 BL92.1
WH20.7
COL-EXP-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This field contains the general ledger BL130 BL20.1
account to credit for the cost amount of BL20.3 BL21.2
non-stock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special order lines and from the BL820 BL92.1
major/minor sales class file for WH20.7
non-stock lines.
COL-EXP-ACCOUNT Numeric 6 BL120 BL122
Element: Account This field contains the general ledger BL130 BL20.1
distribution account that is credited BL20.3 BL21.2
for non-stock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special orders and from major/minor BL820 BL92.1
sales class for non-stock orders. WH20.7
COL-EXP-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct This field contains the general ledger BL130 BL20.1
distribution subaccount that is credited BL20.3 BL21.2
for non-stock and special orders. This BL21.5 BL29.1
defaults from the process level for BL29.2 BL520
special orders and from the major/minor BL820 BL92.1
sales class for non-stock orders. WH20.7
COL-CGS-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit The cost of goods sold account unit is BL130 BL20.1
debited and defaults from the process BL20.3 BL21.2
level for special order items or from BL21.5 BL29.1
the sales class for inventoried or BL29.2 BL520
non-stock items. This account is BL820 BL92.1
credited for return to stock WH20.7
transactions.
COL-CGS-ACCOUNT Numeric 6 BL120 BL122
Element: Account The cost of goods sold account number BL130 BL20.1
is debited and defaults from the process BL20.3 BL21.2
level for special order items or from BL21.5 BL29.1
the sales class for inventoried or BL29.2 BL520
non-stock items. This account is BL820 BL92.1
credited for return to stock WH20.7
transactions.
COL-CGS-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct The cost of goods sold subaccount BL130 BL20.1
number is debited and defaults from the BL20.3 BL21.2
process level for special order items or BL21.5 BL29.1
from the sales class for inventoried or BL29.2 BL520
non-stock items. This account is BL820 BL92.1
credited for return to stock WH20.7
transactions.
COL-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Prod Tax Cat A classification of items for BL130 BL20.1
determining taxes using the VERTEX BL20.3 BL21.2
system in Lawson Order Entry system or BL21.5 BL29.1
the cash receipts programs in the Lawson BL29.2 BL520
Cash Ledger system. BL820 BL92.1
WH20.7
COL-CXL-DATE Numeric 8 (yyyymmdd) BL120 BL122
Element: Date This field contains the date this line BL130 BL20.1
was canceled. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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 BL120 BL122
Element: Rec Qty This field contains the quantity BL130 BL20.1
canceled for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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) BL120 BL122
Element: Requester This field contains the user ID of the BL130 BL20.1
person who canceled this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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 BL120 BL122
Element: Cb Reason This field contains the reason for BL130 BL20.1
canceling this order. Reason codes are BL20.3 BL21.2
set up in Reason Codes (BL07.1). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
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 BL120 BL122
Element: Seq This field contains the sequence number BL130 BL20.1
of the last comment line entered on this BL20.3 BL21.2
line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BLI2.1 WH20.7
COL-LAST-MISC-SEQ Numeric 3 BL120 BL122
Element: Seq This field contains the last sequence BL130 BL20.1
used for miscellaneous charges for this BL20.3 BL21.2
line. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-MSDS-REQ-FL Alpha 1 BL120 BL122
Element: All Flag This field indicates that an MSDS BL130 BL20.1
(Material Safety Data Sheet) is BL20.3 BL21.2
required. If set to Yes, an MSDS BL21.5 BL29.1
acknowledgment is required for the first BL29.2 BL520
shipment containing the item even if an BL820 BL92.1
MSDS acknowledgment has been sent within WH20.7
a year for this item to the customer.
Order Entry does not create MSDS forms,
but it keeps track of when the form was
sent.
Y = Yes
N = No
COL-LAST-SHIP-NBR Numeric 10 BL120 BL122
Element: Shipment Nbr This field contains the last shipment BL130 BL20.1
number created for this order line. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-WORK-ORDER Numeric 8
Element: 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
Element: Work Order SufThis is the suffix of the work order
the line may be associated with. It
will normally be zero.
COL-PRICE-REC-TYPE Alpha 1 BL120 BL122
Element: Price Rec TypeC = Class BL130 BL20.1
I = Item BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-QTY-BREAK-FL Alpha 1 BL120 BL122
Element: Qty Break Fl Y = Yes BL130 BL20.1
N = No BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-GROSS-AMOUNT Derived
Element: Gross Amount This field contains the line extension
in base currency before discounts are
taken.
COL-NET-AMOUNT Derived
Element: Net Amount This field contains the line amount in
base currency after discounts have been
removed.
COL-CURR-GROSS Derived
Element: Curr Gross This field contains the gross amount in
transaction currency.
COL-CURR-NET Derived
Element: Curr Net This field contains the line net amount
in transaction currency.
COL-OPEN-TO-ALLOC Derived
Element: Open To Alloc This field contains quantity available
for allocation.
COL-ALLOC-NOT-PRT Derived
Element: Alloc Not Prt This field contains the allocated
quantity that has not been printed on
the picking list.
COL-PROJ-STD-COST Derived
Element: 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
Element: 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
Element: 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
Element: 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
Element: Proj Margin This field contains the projected
margin for this line.
COL-UNBILLED-QTY Derived
Element: Unbilled Qty This field contains the unbilled
quantity on the line.
COL-UNBILLED-BASE Derived
Element: Unbilled Base This field contains the unbilled
quantity on the order line in base
currency.
COL-UNBILLED-CURR Derived
Element: Unbilled Curr This field contains the unbilled amount
in transaction currency.
COL-ORD-QTY-IN-STK Derived
Element: Ord Qty In StkThis field contains the quantity of
item in stock unit of measure.
COL-BO-FL Derived
Element: Bo Fl This field indicates if the order line
was backordered.
COL-PRICE-LOC Derived
Element: Price Loc This field indicates the pricing
location for the order line.
COL-ORDER-FILLER Derived
Element: Order Filler Used to facilitate Drill Around to
shipments for this order.
COL-ORDER-NBR-A Derived
Element: Order Nbr A Used to facilitate Drill Around to
shipments for this order.
COL-DISP-ALLOCATED Derived
Element: Disp AllocatedUsed to facilitate Drill Around of
quantity allocated.
COL-DISP-PRINTED Derived
Element: Disp Printed Used to facilitate Drill Around of pick
list quantity printed.
COL-DISP-IN-PROC Derived
Element: Disp In Proc Used to facilitate Drill Around of
quantity in process.
COL-DISP-BACKORD Derived
Element: Disp Backord Used to facilitate Drill Around of
quantity back ordered.
COL-COMM-LIT Derived
Element: Comm Lit If comments are attached, this field
displays "comments exist."
COL-DER-ORIGIN-CD Derived
Element: Der Origin Cd
COL-INTR-COMP Alpha 1 BL120 BL122
Element: Intr Comp Identifies Inter-Company order lines as BL130 BL20.1
"O" for the customer order line, "S" for BL20.3 BL21.2
the shipping company, or N" not an BL21.5 BL29.1
Inter-company order line. BL29.2 BL520
O = Inter-Co Customer order BL820 BL92.1
S = Inter-Co Shipping order WH20.7
N = Not an Inter-Co Order
COL-FOB-CODE Alpha 3 BL120 BL122
Element: Fob Code The user defined Free On Board Code. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-PORT-CD Alpha 5 BL120 BL122
Element: Port Cd The Intrastat port code. Must be BL130 BL20.1
define BL20.3 BL21.2
in IN04.1 (Port Maintenance) BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-NOTC Alpha 2 BL120 BL122
Element: Notc The Nature of Transaction code. Must BL130 BL20.1
be a valid code defined in IN07.1 (NOTC BL20.3 BL21.2
Maintenance). BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-STAT-PROC Alpha 6 BL120 BL122
Element: Stat Proc The statistical procedure code applied BL130 BL20.1
to the data. The code must be defined BL20.3 BL21.2
in IN06.1. (Statistical Procedure BL21.5 BL29.1
Maintenance). BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SUPLMNTARY-UOM Alpha 4 BL120 BL122
Element: Uom This field contains the valid stock BL130 BL20.1
unit of measure for this item. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-SUPLMNTARY-QTY Signed 13.4 BL120 BL122
Element: Quantity This field contains the desired BL130 BL20.1
quantity. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-ICN-CODE Alpha 8 BL120 BL122
Element: Icn Code BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COL-BACK-ORD-FL Alpha 1 BL120 BL122
Element: Back Ord Fl Y = Backorder Allowed BL130 BL20.1
N = Backorder Not Allowed BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 COMPANY AP125 AP126
ORDER-NBR AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL125
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL80.1 BL820
...
COLSET10 COMPANY KeyChange BL120 BL122
ORDER-NBR BL130 BL20.1
TAX-CODE BL20.3 BL21.2
PROD-TAX-CAT BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
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 BL120 BL122
LINE-NBR BL130 BL20.1
ORDER-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
COLSET2 COMPANY KeyChange, Subset WH120
INV-LOC Where STATUS = 2
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
COLSET3 COMPANY KeyChange
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
COLSET4 COMPANY Subset BL120 BL122
ORDER-NBR Where PRICE-STATUS = "A" BL130 BL20.1
SALES-MAJCL BL20.3 BL21.2
SALES-MINCL BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
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 BL120 BL122
ORDER-NBR Where STATUS < 3 BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
WH210
COLSET8 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
COLSET9 COMPANY Subset BL120 BL122
ORDER-NBR Where STATUS = 2 BL130 BL20.1
VENDOR And CREATE-PO = "Y" BL20.3 BL21.2
CUST-SHIP-TO And ORDER-QTY > SHIPPED-QTY BL21.5 BL29.1
DROPSHIP-FL BL29.2 BL520
LINE-NBR BL820 BL92.1
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 -> -COMPANY
Apvenmast APVENMAST Required
When COL-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COL-CARRIER -> VEN-VENDOR
Arcomp ARCOMP Required
COL-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
COL-COMPANY -> ACM-COMPANY
COL-CUSTOMER -> ACM-CUSTOMER
Cogs Offset GLMASTER Required
When COL-LINE-TYPE = "N"
Or COL-LINE-TYPE = "X"
COL-COMPANY -> GLM-COMPANY
COL-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
COL-EXP-ACCOUNT -> GLM-ACCOUNT
COL-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Colineuom COLINEUOM Not Required, Delete Cascades
Valid When COL-MULT-SPR-FL = "Y"
COL-COMPANY -> COU-COMPANY
COL-ORDER-NBR -> COU-ORDER-NBR
COL-LINE-NBR -> COU-LINE-NBR
Contract OEPRCLIST Required
When COL-CONTRACT-NBR != Spaces
COL-COMPANY -> OPL-COMPANY
COL-CUSTOMER -> OPL-CUSTOMER
COL-CONTRACT-NBR -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Cosgblk COSGBLK Not Required
COL-COMPANY -> OSG-COMPANY
COL-ORDER-NBR -> OSG-ORDER-NBR
COL-LINE-NBR -> OSG-LINE-NBR
Zeroes -> OSG-SEQ
Cucodes CUCODES Required
COR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Curelat CURELAT Required
When COR-CURRENCY-CODE != COL-CURRENCY-CODE
GLS-CURRENCY-TABLE -> CRL-CURRENCY-TABLE
COR-CURRENCY-CODE -> CRL-FR-CURR-CODE
OEC-CURRENCY-CODE -> CRL-TO-CURR-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
COL-CUSTOMER -> CUD-CUSTOMER
Custorder CUSTORDER Required
COL-COMPANY -> COR-COMPANY
COL-ORDER-NBR -> COR-ORDER-NBR
Cxl Operator OPERATOR Required
When COL-CXL-OPR != Spaces
COL-COMPANY -> OPE-DEF-COMPANY
COL-CXL-OPR -> OPE-OPR-CODE
Glsystem GLSYSTEM Required
COL-COMPANY -> GLS-COMPANY
Hdrloc ITEMLOC Not Required
COL-COMPANY -> ITL-COMPANY
COR-INV-LOCATION -> ITL-LOCATION
COL-ITEM -> ITL-ITEM
Holdcodes HOLDCODES Required
When COL-HOLD-CODE != Spaces
ACO-CUST-GROUP -> HDD-CUST-GROUP
COL-HOLD-CODE -> HDD-HOLD-CODE
Iccategory ICCATEGORY Not Required
Valid When COL-LINE-TYPE = "I"
COL-COMPANY -> ICA-COMPANY
COL-INV-LOC -> ICA-LOCATION
ITL-GL-CATEGORY -> ICA-GL-CATEGORY
Iccompany ICCOMPANY Required
When COL-LINE-TYPE != "X"
COL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
COL-COMPANY -> ICL-COMPANY
COL-INV-LOC -> ICL-LOCATION
Itemlocation ITEMLOC Required
When COL-INV-LOC != Spaces
And COL-LINE-TYPE = "I"
COL-COMPANY -> ITL-COMPANY
COL-INV-LOC -> ITL-LOCATION
COL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
COL-ITEM -> ITE-ITEM
Kititem KITITEM Not Required
Valid When COL-KIT-FL = "O"
ICC-ITEM-GROUP -> KIT-ITEM-GROUP
COL-COMPANY -> KIT-COMPANY
COL-INV-LOC -> KIT-LOCATION
COL-ITEM -> KIT-ITEM
Kititem 2 KITITEM Not Required
Valid When COL-KIT-FL != "O"
ICC-ITEM-GROUP -> KIT-ITEM-GROUP
COL-COMPANY -> KIT-COMPANY
COL-INV-LOC -> KIT-LOCATION
COL-ITEM -> KIT-ITEM
Majorcl MAJORCL Required
When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
ITE-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Not Required
Valid When COL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
ITE-SALES-MAJCL -> MIN-MAJOR-CLASS
ITE-SALES-MINCL -> MIN-MINOR-CLASS
Oecoluf OECOLUF Required
COL-COMPANY -> OLU-COMPANY
COL-ORDER-NBR -> OLU-ORDER-NBR
COL-LINE-NBR -> OLU-LINE-NBR
Oecompany OECOMPANY Required
COL-COMPANY -> OEC-COMPANY
Oecust OECUST Required
COL-COMPANY -> OET-COMPANY
COL-CUSTOMER -> OET-CUSTOMER
Oeproclev OEPROCLEV Required
COL-COMPANY -> OEP-COMPANY
COL-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oereason OEREASON Not Required
Valid When COL-CXL-OPR != Spaces
COL-COMPANY -> OER-COMPANY
COL-CXL-REASON -> OER-REASON-CODE
Oeslsacct OESLSACCT Required
When COL-LINE-TYPE != "X"
COL-COMPANY -> OSA-COMPANY
COL-PROCESS-LEVEL -> OSA-PROCESS-LEVEL
ITE-SALES-MAJCL -> OSA-SALES-MAJCL
ITE-SALES-MINCL -> OSA-SALES-MINCL
Operator OPERATOR Required
COL-COMPANY -> OPE-DEF-COMPANY
COR-OPR-CODE -> OPE-OPR-CODE
Ordertype ORDERTYPE Required
COL-COMPANY -> OTP-COMPANY
COR-ORDER-TYPE -> OTP-ORDER-TYPE
Po Vendor APVENMAST Required
When COL-VENDOR != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
COL-VENDOR -> VEN-VENDOR
Promotion OEPRCLIST Required
When COL-PROMOTION > Spaces
COL-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
COR-LIST-NAME -> OPL-LIST-NAME
COL-PROMOTION -> OPL-PROMOTION
Sales Acct GLMASTER Required
When COL-LINE-TYPE = "N"
Or COL-LINE-TYPE = "X"
COL-COMPANY -> GLM-COMPANY
COL-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
COL-SLS-ACCOUNT -> GLM-ACCOUNT
COL-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
Salesrep1 SALESREP Required
COL-COMPANY -> SAW-COMPANY
COL-SALESMAN -> SAW-SALESMAN
Salesrep2 SALESREP Required
When COL-SALESMAN-2 != Zeroes
COL-COMPANY -> SAW-COMPANY
COL-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When COL-CUST-SHIP-TO != Zeroes
COL-COMPANY -> SHP-COMPANY
COL-CUSTOMER -> SHP-CUSTOMER
COL-CUST-SHIP-TO -> SHP-SHIP-TO
Teritory TERITORY Required
COL-COMPANY -> TRY-COMPANY
COL-TERRITORY -> TRY-TERRITORY
Txtaxcode TXTAXCODE Required
When COL-TAX-CODE > Spaces
COL-COMPANY -> TAC-COMPANY
COL-TAX-CODE -> TAC-TAX-CODE
Whdemndhdr WHDEMNDHDR Not Required
COL-COMPANY -> WDH-COMPANY
"OE" -> WDH-SYSTEM-CD
COL-ORDER-NBR -> WDH-DOC-NBR-NUM
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
Components COMPONENT
ICC-ITEM-GROUP -> COM-ITEM-GROUP
COL-COMPANY -> COM-COMPANY
COL-INV-LOC -> COM-LOCATION
COL-ITEM -> COM-KIT-ITEM
COM-SEQ
COM-OPT-SEQ
Itemcompanion ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"C" -> ITS-SUBTYPE
ITS-SUB-ITEM
Itemloc ITEMLOC Required
When COL-LINE-TYPE = "I"
COL-COMPANY -> ITL-COMPANY
COL-ITEM -> ITL-ITEM
ITL-LOCATION
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Itserial ITSERIAL
COL-COMPANY -> SER-COMPANY
COL-ITEM -> SER-ITEM
SER-SERIAL
Oeaudit OEAUDIT Delete Cascades
COL-COMPANY -> OEA-COMPANY
COL-ORDER-NBR -> OEA-ORDER-NBR
COL-LINE-NBR -> OEA-LINE-NBR
OEA-FLD-NBR
OEA-UPDATE-DATE
OEA-UPDATE-TIME
Oeordcmnt OEORDCMNT
COL-COMPANY -> OOC-COMPANY
Spaces -> OOC-CUSTOMER
Spaces -> OOC-STD-ORDER-NBR
COL-ORDER-NBR -> OOC-ORDER-NBR
COL-LINE-NBR -> OOC-LINE-NBR
OOC-SEQ
Polinesrc POLINESRC
Valid When COL-CREATE-PO = "Y"
COL-COMPANY -> PLS-OPER-COMPANY
"OE" -> PLS-ORIGIN-CD
COL-ORDER-NBR -> PLS-SOURCE-DOC-N
COL-LINE-NBR -> PLS-SRC-LINE-NBR
PLS-PO-CODE
PLS-PO-NUMBER
PLS-PO-RELEASE
PLS-LINE-NBR
Returnline RETURNLINE
COL-COMPANY -> RTL-COMPANY
COL-CUSTOMER -> RTL-CUSTOMER
COL-ITEM -> RTL-ITEM
COL-CUST-SHIP-TO -> RTL-SHIP-TO
RTL-DATE
RTL-AUTH-NO
RTL-LINE-NBR
Sohbins SOHDETAIL
COL-COMPANY -> SDT-COMPANY
COL-INV-LOC -> SDT-LOCATION
COL-ITEM -> SDT-ITEM
SDT-BIN
SDT-UOM
SDT-LOT
SDT-SUBLOT
Sohdetail SOHDETAIL
COL-COMPANY -> SDT-COMPANY
COL-INV-LOC -> SDT-LOCATION
COL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Substitutions ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
COL-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Vendor Company ICLOCATION
COL-VENDOR -> ICL-VENDOR
COL-PURCH-FR-LOC -> ICL-PURCH-FR-LOC
Zeroes -> ICL-COMPANY
ICL-LOCATION
Whdemand WHDEMAND
COL-COMPANY -> WDM-COMPANY
"OE" -> WDM-SYSTEM-CD
WDH-DOC-NBR -> WDM-DOC-NBR
COL-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
WDM-LOCATION
Whshipline WHSHIPLINE
COL-COMPANY -> WHL-COMPANY
"OE" -> WHL-SYSTEM-CD
WDH-DOC-NBR -> WHL-DOC-NBR
COL-LINE-NBR -> WHL-LINE-NBR
WHL-SHIPMENT-NBR
Whshipment WHSHIPMENT
COL-COMPANY -> WHS-COMPANY
COL-INV-LOC -> WHS-LOCATION
COL-ORDER-NBR-A -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
|