|
|
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
WH126 WH222 WH224 WHD0.1 WH210
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 BLI2.1 IC28.1
MA180 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.1 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.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 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
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1
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 WO20.1
WO30.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY Numeric 4 WH20.7
Element: Company The company number represents an
established company and is entered on
all function codes.
COL-ORDER-NBR Numeric 8 WH20.7
Element: Order Number Each order is assigned a unique number.
Order numbers are either manually
assigned or system assigned based on a
company-level option.
COL-LINE-NBR Numeric 6 WH20.7
Element: Line Number This field displays the line number of
the transaction number.
COL-STATUS Numeric 1 WH20.7 WH22.1
Element: Status This field indicates the status of this WHD2.1
line on the order.
0 = Needs clean-up
1 = Unreleased
2 = Released
8 = Canceled
9 = Ready for delete
COL-FUTURE-FL Alpha 1 WH20.7
Element: Future Order FThis field indicates if this line has a
future status.
Y = Yes
N = No
COL-SALES-MAJCL Alpha 4 WH20.7
Element: Major Class This field contains the major sales
class code.
COL-SALES-MINCL Alpha 4 WH20.7
Element: Minor Class This field contains the minor sales
class code within the major class.
COL-ITEM Alpha 32 WH20.7
Element: Item Number This field contains the item
identifier.
COL-ITEM-DESC Alpha 30 WH20.7 WH222
Element: Item DescriptiThis field contains the description for
stock and nonstock items.
COL-LINE-TYPE Alpha 1 WH20.7
Element: Line Type The line type can be entered. Valid
values are:
.
I = Inventoried. Default value.
N = Nonstock.
X = Special order.
COL-ORIG-LINE Numeric 4 WH20.7
Element: Original Line This field contains the original line
number if it was overridden.
COL-ORIG-ITEM Alpha 32 WH20.7
Element: Item Number This field contains the original item
number if it was overridden.
COL-ORIG-FL Alpha 1 WH20.7
Element: Orig Fl This field indicates whether this line
was created as a result of item
replacement or substitution.
R = Replacement line
S = Substitute line
COL-CUSTOMER Alpha 9 (Right Justified) WH20.7
Element: Customer NumbeThis field contains the number that
represents a customer.
COL-CUST-ITEM-FL Alpha 1 WH20.7
Customer Item This field indicates whether the number
Numbers Used Fl entered in the order line represents an
item set up in the Order Entry Customer
file.
C = Customer item was entered
COL-CUST-ITEM Alpha 32 WH20.7
Element: Item Number This field contains the customer's item
number.
COL-KIT-FL Alpha 1 WH20.7
Element: Kit Flag This field indicates when the item
ordered is a made-to-order kit.
N = Not a kit
O = Make to order kit
S = Make to stock kit
COL-KIT-ALLOC-FL Alpha 1 WH20.7
Element: Kit AllocationThis field indicates whether the kit
has been allocated.
0 = Kit allocated
1 = Kit needs options chosen
COL-HOLD-CODE Alpha 4 WH20.7
Element: Hold Code If the line is on hold, this field
contains the hold code. Hold codes are
set up in the Accounts Receivable
system.
COL-INV-LOC Alpha 5 WH20.7
Element: Location Code
COL-PROCESS-LEVEL Alpha 5 WH20.7
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company. If you are using the General
Ledger Interface system, the process
level determines which general ledger
account the order's invoice debits when
its rate updates to the Accounts
Receivable system.
COL-SPR-UOM Alpha 4 WH20.7
Element: Unit of MeasurThis field contains the pricing unit of
measure. This must be a valid pricing
unit of measure for the item if the line
is not a special order line.
COL-SELL-UOM Alpha 4 WH126 WH20.7
Element: Unit of MeasurThis field contains the stock unit of
measure for the item. If entered, it
must be a valid stock unit of measure
for this line's item. If not entered,
the default stock unit of measure for
this line's item is assigned.
COL-SEC-UOM Alpha 4 WH20.7
Element: Unit of MeasurThis field contains the secondary
quantity unit of measure. This is used
only when the item is a catch weight
item.
COL-NO-CHARGE-FL Alpha 1 WH20.7
Element: No Charge FlagThis field indicates the item's price
is zero. This defaults to No. If set to
Yes, this field prevents the system from
pricing the item. No charge invoices are
not to be passed to the Accounts
Receivable system for collection.
N = No
Y = Yes
COL-RATE-OVR-FL Alpha 1 WH20.7
Element: All Flag This flag indicates whether the
currency conversion rate was overridden
for this line of the order.
Y = Yes
N = No
COL-PRICE-STATUS Alpha 1 WH20.7
Element: Price Status This field indicates how the line was
priced.
A = Amalgamated (group) pricing
C = System calculated pricing
O = Price override
COL-PRICE-DATE Numeric 8 (yyyymmdd) WH20.7
Element: Date This field contains the date used to
price the line. The system date defaults
when the line is added.
COL-ENTERED-PRICE Signed 13.5 WH20.7
Element: Base Price This field contains the unit price in
the currency of the order.
COL-UNIT-PRICE Signed 13.5 WH20.7
Element: Base Price This field contains the unit price in
base currency. This is an amount per
stock unit of measure.
COL-SELL-UNIT-PRC Signed 15.7 WH20.7
Element: Sell Unit Prc This field contains the price per sell
unit of measure in base currency. If
multiple unit of measure pricing is
used, this is the weighted average price
per sell unit of measure.
COL-SELL-PRC-CURR Signed 15.7 WH20.7
Element: Sell Unit Prc This field contains the price per sell
unit of measure in transaction currency.
If multiple unit of measure pricing is
used, this is the weighted average price
per sell unit of measure.
COL-UNIT-COST Signed 13.5 WH20.7
Element: Base Cost
COL-DISC-AMT-CURR Signed 15.2 WH20.7
Element: Actual Disc This field contains the discount amount
in transaction currency.
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 WH20.7
Element: Discount Code This field contains the discount code
used to calculate the discount amount
for this line.
COL-MULT-SPR-FL Alpha 1 WH20.7
Element: All Flag Y = Yes
N = No
COL-SPR-TO-STOCK Signed 13.7 WH20.7
Element: Sell To Stock This field contains the multiplier used
with special order items when converting
from pricing unit of measure to stock
unit of measure.
COL-SELL-TO-STOCK Signed 13.7 WH20.7
Element: Sell To Stock This field contains the multiplier that
is used with special order items when
converting from selling unit of measure
to stock unit of measure.
COL-SEC-TO-STOCK Signed 13.7 WH20.7
Element: Sell To Stock This field contains the multiplier that
is used with catch weight items when
converting secondary unit of measure to
stock unit of measure.
COL-ORD-DISC-FL Alpha 1 WH20.7
Element: Order DiscountThis field indicates whether this line
is eligible for an order discount.
Y = Yes
N = No
COL-CUST-SHIP-TO Numeric 4 WH20.7
Element: Ship-to Code This field contains the ship-to
customer number. This defaults from the
order header.
COL-CREATE-PO Alpha 1 WH20.7
Element: All Flag This field indicates the item is
ordered by a purchase order rather than
using stock.
N = No
Y = Yes
COL-DROPSHIP-FL Alpha 1 WH20.7
Element: Dropship Flag This field indicates whether the items
of the purchase order are sent directly
from the vendor to the customer. If this
field is set to No, items are shipped to
the user who entered the order for
shipment to the customer.
N = No
Y = Yes
COL-CARRIER Alpha 9 (Right Justified) WH20.7
Element: Vendor ID This field contains the carrier number.
This must be a valid vendor defined in
the Accounts Payable system.
COL-PO-NUMBER Alpha 14 (Right Justified) WH20.7
Element: PO Number This field contains the number
representing the purchase order. This is
used if the purchase order line is added
to an existing purchase order.
COL-PO-CODE Alpha 4 WH20.7
Element: Po Code This is the purchase order code that
will be used as part of the purchase
order number for a create po order line.
COL-VENDOR Alpha 9 (Right Justified) WH20.7
Element: Vendor ID This field contains the vendor of the
purchase order. If left blank, the
Purchase Order system assigns a vendor
to the purchase order.
COL-PURCH-FR-LOC Alpha 4 WH20.7
Purchase From The vendor's purchase from location.
Location Code
COL-IF-REF-NBR Numeric 9 WH20.7
Element: Reference NumbThis field contains an internally
generated reference number used by the
Requisition system.
COL-ROUTE Numeric 4 WH120 WH20.7
Element: Route This field contains the route number. WH21.3 WH21.4
If left blank, the route assigned to the
ship-to customer defaults from the Order
Entry Route file. If no route is
assigned to the ship-to customer in the
Order Entry Route file, the route
defaults from the customer.
COL-STOP Numeric 4 WH120 WH20.7
Element: Stop This field contains the stop within the WH21.3 WH21.4
route. If left blank, this defaults from
the ship-to customer from the Order
Entry Route file. If no stop is
associated with the ship-to customer,
this defaults from the customer's file.
COL-RTE-CREATE-FL Alpha 1 WH110 WH120
Element: All Flag Y = Yes WH130 WH132
N = No 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) WH120 WH20.7
Element: Date This field contains the expected WH21.3 WH21.4
delivery date. This field is valid only
for a company that uses routes and
stops. The expected delivery date is
calculated by adding the ship days from
the process level associated with the
order to the system date when the order
is added. This field determines when the
order prints on the picking list for
processing.
COL-TERRITORY Alpha 4 WH20.7
Element: Sales TerritorThis field contains the sales
territory. If left blank, this defaults
from the ship-to customer. If no sales
territory is assigned to the ship-to
customer, this defaults from the
customer's file.
COL-SALESMAN Numeric 4 WH20.7
Element: Salesman NumbeThis field contains the code that
represents the primary sales
representative of this line. This
defaults from the order header.
COL-SALESMAN-2 Numeric 4 WH20.7
Element: Salesman NumbeThis field contains the code
representing the second sales
representative. This defaults from the
order header.
COL-COMM-SPLIT Percent 5.3 (Percent) WH20.7
Commission Split Commission split for the second sales
Percentage representative. This is the percentage
of this line's total value the secondary
sales representative's commission rate
is applied to.
COL-COMM-RATE-1 Percent 7.5 (Percent) WH20.7
Element: Chrg Rate Commission rate for sales
representative 1. Defaults from the
sales representative file.
COL-COMM-RATE-2 Percent 7.5 (Percent) WH20.7
Element: Chrg Rate This field contains the commission rate
for the second sales representative.
This defaults from the sales
representative file.
COL-ENTERED-DISC Signed 15.2 WH20.7
Element: Actual Disc This field contains a per line discount
rather than a per unit discount as
entered in the order-line's billing
currency.
COL-MULT-ADD-DISC Derived
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 15.2 WH20.7
Element: Actual Disc This field contains the amount of the
additional discount that has been used
by invoices for this order line in
billing currency. If you need to lower
an additional discount on the line, the
amount cannot be lowered below amount
found in this field for this line.
COL-MULT-DISC-TKN Derived
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 WH20.7
Element: Tax Exempt CodThis field contains the tax exempt
code. This defaults from the order
header. If the order header is tax
exempt, the line is also tax exempt.
E = Exempt
T = Taxable
COL-TAX-CODE Alpha 10 WH20.7
Element: Tax Code This field contains a code representing
the tax authorities this ship-to pays
sales tax to. This must be valid in the
Tax Code file. If the company is not
using a third-party tax system, this
code is the tax code for the order line.
Tax codes are entered in the Tax system
and can be associated with the customer
or entered when adding the order.
COL-TAXABLE-CURR Signed 15.2 WH20.2 WH20.7
Element: Item Tax This field contains the taxable amount
in billing currency.
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 15.2 WH20.2 WH20.7
Element: Item Tax This field contains the override
taxable amount in base currency.
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) WH20.7
Element: Date
COL-LATE-DL-DATE Numeric 8 (yyyymmdd) WH20.7
Element: Date
COL-USER-DATE-3 Numeric 8 (yyyymmdd) WH20.7
Element: Date
COL-USER-DATE-4 Numeric 8 (yyyymmdd) WH20.7
Element: Date This field contains the fourth
user-defined date. Informational
purposes only used on OE280 (Open Orders
by Customer).
COL-USER-FLD1 Alpha 2 WH20.7
Purchase Order User This field contains the first
Field 2 user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system.
COL-USER-FLD2 Alpha 30 (Lower Case) WH20.7
Element: User Defined FThis field contains the second
user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system. This field also updates to the
Sales Analysis system.
COL-USER-FLD3 Alpha 15 (Lower Case) WH20.7
Element: User Defined FThis field contains the third
user-definable field. If a purchase
order is created for this order, this
field updates to the Purchase Order
system. This field also updates to the
Sales Analysis system.
COL-EXP-SHIP-DT Numeric 8 (yyyymmdd) WH20.7
Element: Date Expected ship date. Defaulted by the
system as the number of ship days (from
process level record) beyond the system
date when the line is added. May be
overridden.
COL-ALLOCATE-DT Numeric 8 (yyyymmdd) WH20.7
Element: Date This field contains the date used for
batch allocations. The type of date
depends on a company option, and can be
the order date, the customer requested
delivery date or the expected ship date.
COL-LIST-NAME Alpha 14 WH20.7
Element: List Name This field contains the name of the
price list, if this line is priced using
a price list or a promotion.
COL-CONTRACT-NBR Alpha 14 WH20.7
Element: Contract NumbeThis field contains the contract
number, if this line is priced using a
contract.
COL-PROMOTION Alpha 10 WH20.7
Element: Promotion This field contains the promotion name,
if this line is priced via a promotion.
When combined with the list name, it
provides access to the promotion file.
COL-ACTIVITY Alpha 15 WH20.7
Element: Activity In this file the Activity field is used
for the revenue (sales) side of the
posting whereas the Activity-C field is
used for the Cost (COGS) side of the
posting.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEGORY Alpha 5 WH20.7
Element: Account CategoIn this file the Acct-Category field is
used for revenue (sales) postings
whereas the Acct-Categ-C field is used
for Cost (COGS) postings.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID Numeric 12 WH20.7
Object Represents Activity Management system
Identification ID for the revenue (sales) activity.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting inquiries.
COL-ACTIVITY-C Alpha 15 WH20.7
Element: Activity In this file the Activity-C field is
used for the Cost (COGS) side of the
posting whereas the Activity field is
used for the revenue (sales) side of the
posting.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
COL-ACCT-CATEG-C Alpha 5 WH20.7
Element: Account CategoIn this file the Acct-Categ-C field is
used for Cost (COGS) postings whereas
the Acct-Category field is used for
revenue (sales) postings.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
general ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
COL-ATN-OBJ-ID-C Numeric 12 AP125 AP126
Object The system defined object id AP131 AP20.1
Identification representing the Activity Management AP20.2 AP20.3
commitment for Cost (COGS). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
COL-BOOKED-FL Alpha 1 WH20.7
Element: Account Flag This field indicates if the order line
has been booked by the Sales Analysis
system.
COL-BOOKED-DATE Numeric 8 (yyyymmdd) WH20.7
Element: Date This field indicates the date when the
order line was booked by the Sales
Analysis system.
COL-BOOKED-QTY Signed 13.4 WH20.7
Element: Quantity This field contains the quantity booked
to the customer and sales representative
totals. This is updated to the Sales
Analysis system for reporting and
inquiry analysis.
COL-ORDER-QTY Signed 13.4 WH130 WH132
Element: Quantity The order quantity of the line item. WH190 WH20.7
WH520 WH830
COL-SHIPPED-QTY Signed 13.4 WH126 WH130
Element: Quantity This field contains the shipped WH132 WH190
quantity. 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 WH20.7
Element: Quantity This field contains the quantity that
has been invoiced for this order line.
COL-RETURNED-QTY Signed 13.4
Element: Quantity Total quantity returned compared to
this quantity.
COL-FIRM-FL Alpha 1 WH20.7
Element: Firm Fl This field indicates if the allocation
is firm. If the value is set to Yes,
WH110 (Batch Allocation) skips the
record in the de-allocation phase.
Y = Yes
N = No
COL-SHIP-COMP-FL Alpha 1 WH20.7
Element: Ship Comp Fl
COL-PK-PRIORITY Numeric 2 WH20.7
Element: Picking Priority
COL-SLS-ACCT-UNIT Alpha 15 WH20.7
Element: Accounting UniThis field contains the sales account
unit, if the line is special order. If
left blank, this defaults from the
process level.
COL-SLS-ACCOUNT Numeric 6 WH20.7
Element: Account This field contains the sales account
number, if the line is for a special
order item. If left blank, this defaults
from the process level.
COL-SLS-SUB-ACCT Numeric 4 WH20.7
Element: Subaccount This field contains the sales
subaccount number, if the line is
special order. If left blank, this
defaults from the process level.
COL-EXP-ACCT-UNIT Alpha 15 WH20.7
Element: Accounting UniThis field contains the general ledger
account to credit for the cost amount of
nonstock and special orders. This
defaults from the process level for
special order lines and from the
major/minor sales class file for
nonstock lines.
COL-EXP-ACCOUNT Numeric 6 WH20.7
Element: Account This field contains the general ledger
distribution account that is credited
for nonstock and special orders. This
defaults from the process level for
special orders and from major/minor
sales class for nonstock orders.
COL-EXP-SUB-ACCT Numeric 4 WH20.7
Element: Subaccount This field contains the general ledger
distribution subaccount that is credited
for nonstock and special orders. This
defaults from the process level for
special orders and from the major/minor
sales class for nonstock orders.
COL-CGS-ACCT-UNIT Alpha 15 WH20.7
Element: Accounting UniThe cost of goods sold account unit is
debited and defaults from the process
level for special order items or from
the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-CGS-ACCOUNT Numeric 6 WH20.7
Element: Account The cost of goods sold account number
is debited and defaults from the process
level for special order items or from
the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-CGS-SUB-ACCT Numeric 4 WH20.7
Element: Subaccount The cost of goods sold subaccount
number is debited and defaults from the
process level for special order items or
from the sales class for inventoried or
nonstock items. This account is credited
for return to stock transactions.
COL-PROD-TAX-CAT Alpha 15 WH20.7
Element: Product Tax CaA classification of items for
determining taxes using the VERTEX
system in Lawson Order Entry system or
the cash receipts programs in the Lawson
Cash Ledger system.
COL-CXL-DATE Numeric 8 (yyyymmdd) WH130 WH132
Element: Date This field contains the date this line WH190 WH20.7
was canceled. 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 WH130 WH132
Element: Quantity This field contains the quantity WH190 WH20.7
canceled for this order line. 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) WH130 WH132
Element: Requester This field contains the user ID of the WH190 WH20.7
person who canceled this order line. 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 WH130 WH132
Element: Cb Reason This field contains the reason for WH190 WH20.7
canceling this order. Reason codes are WH30.1 WH30.2
set up in BL07.1 (Reason Codes). 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 BLI2.1 WH20.7
Element: Sequence NumbeThis field contains the sequence number
of the last comment line entered on this
line.
COL-LAST-MISC-SEQ Numeric 3 WH20.7
Element: Sequence NumbeThis field contains the last sequence
used for miscellaneous charges for this
line.
COL-MSDS-REQ-FL Alpha 1 WH20.7
Element: All Flag This field indicates that an MSDS
(Material Safety Data Sheet) is
required. If set to Yes, an MSDS
acknowledgment is required for the first
shipment containing the item even if an
MSDS acknowledgment has been sent within
a year for this item to the customer.
The Order Entry system does not create
MSDS forms, but it keeps track of when
the form was sent.
Y = Yes
N = No
COL-LAST-SHIP-NBR Numeric 10 WH20.7
Element: Shipment NumbeThis field contains the last shipment
number created for this order line.
COL-WORK-ORDER Numeric 8 WO20.1 WO30.1
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 WO20.1 WO30.1
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 WH20.7
Element: Price Rec TypeC = Class
I = Item
COL-QTY-BREAK-FL Alpha 1 WH20.7
Element: Qty Break Fl Y = Yes
N = No
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: Backorder FlagThis 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 WH20.7
Element: Intr Comp Identifies Inter-Company order lines as
"O" for the customer order line, "S" for
the shipping company, or N" not an
Inter-company order line.
O = Inter-Co Customer order
S = Inter-Co Shipping order
N = Not an Inter-Co Order
COL-FOB-CODE Alpha 3 WH20.7
Element: Shipping Term The user defined Free On Board Code.
COL-PORT-CD Alpha 5 WH20.7
Element: Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
COL-NOTC Alpha 2 WH20.7
Element: Notc The Nature of Transaction code. Must
be a valid code defined in IN07.1 (NOTC
Maintenance).
COL-STAT-PROC Alpha 6 WH20.7
Element: Stat Proc The statistical procedure code applied
to the data. The code must be defined
in IN06.1. (Statistical Procedure
Maintenance).
COL-SUPLMNTARY-UOM Alpha 4 WH20.7
Element: Unit of Measure
COL-SUPLMNTARY-QTY Signed 13.4 WH20.7
Element: Quantity
COL-ICN-CODE Alpha 8 WH20.7
Element: Icn Code
COL-SIEB-LOCKED Alpha 1 WH20.7
Element: Sieb Locked Y = Siebel Line Lock
N
COL-ROW-ID Alpha 15 (Lower Case) WH20.7
Element: Row Id
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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
BLI2.1 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
COLSET10 COMPANY KeyChange WH20.2 WH20.7
ORDER-NBR
TAX-CODE
PROD-TAX-CAT
LINE-NBR
COLSET11 COMPANY Subset
CUSTOMER Where CREATE-PO = "Y"
ORDER-NBR And DROPSHIP-FL = "Y"
LINE-NBR And STATUS = 2
And ORDER-QTY > INVOICE-QTY
COLSET12 COMPANY Subset
CUSTOMER Where STATUS = 2
ORDER-NBR And CREATE-PO = "Y"
LINE-NBR And ORDER-QTY > SHIPPED-QTY
COLSET13 COMPANY This index was created as a solution to WH20.7
LINE-NBR the Find Next/Prev Flag error. It is
ORDER-NBR only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
COLSET2 COMPANY KeyChange, Subset WH120
INV-LOC Where STATUS = 2
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
COLSET3 COMPANY KeyChange WH21.1
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
COLSET4 COMPANY Subset WH20.2 WH20.7
ORDER-NBR Where PRICE-STATUS = "A"
SALES-MAJCL
SALES-MINCL
LINE-NBR
COLSET5 ATN-OBJ-ID KeyChange, Subset
Where ATN-OBJ-ID != Zeroes
COLSET6 COMPANY KeyChange, Subset
CUSTOMER Where HOLD-CODE != Spaces
HOLD-CODE
ORDER-NBR
LINE-NBR
COLSET7 COMPANY Subset WH20.2 WH20.7
ORDER-NBR Where STATUS < 3 WH210
LINE-NBR
COLSET8 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
COLSET9 COMPANY Subset WH20.7
ORDER-NBR Where STATUS = 2
VENDOR And CREATE-PO = "Y"
CUST-SHIP-TO And ORDER-QTY > SHIPPED-QTY
DROPSHIP-FL
LINE-NBR
COLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When COL-CARRIER != Spaces
COL-COMPANY -> -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
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
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
|
