COLINE

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
CX05.1 CX05.2 CX805 RQIC.1 RQID.1 RQIG.1
WH126 WH210 WH224 WH226 WH25.1 WH25.2
WHD0.1


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 BLI2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1
WH110 WH120 WH130 WH132 WH190 WH20.2
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH22.1
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WHD2.1 IC11.1 IC216

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COL-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
WH20.7
COL-ORDER-NBR
Element: Order Nbr
Numeric 8
Each order is assigned a unique number. Order numbers are either manually assigned or system assigned based on a company-level option.
WH20.7
COL-LINE-NBR
Element: Line Nbr
Numeric 6
This field displays the line number of the transaction number.
WH20.7
COL-STATUS
Element: Status
Numeric 1
This field indicates the status of this line on the order.
0 = Needs clean-up
1 = Unreleased
2 = Released
8 = Canceled
9 = Ready for delete
WH20.7 WH22.1
WHD2.1
COL-FUTURE-FL
Element: Future Fl
Alpha 1
This field indicates if this line has a future status.
Y = Yes
N = No
WH20.7
COL-SALES-MAJCL
Element: Major Class
Alpha 4
This field contains the major sales class code.
WH20.7
COL-SALES-MINCL
Element: Minor Class
Alpha 4
This field contains the minor sales class code within the major class.
WH20.7
COL-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
WH20.7
COL-ITEM-DESC
Element: Item Desc
Alpha 30
This field contains the description for stock and non-stock items.
WH20.7 WH222
COL-LINE-TYPE
Element: Line Type
Alpha 1
The line type can be entered. Valid values are: . I = Inventoried. Default value. N = Non-stock. X = Special order.
WH20.7
COL-ORIG-LINE
Element: Orig Line
Numeric 4
This field contains the original line number if it was overridden.
WH20.7
COL-ORIG-ITEM
Element: Item
Alpha 32
This field contains the original item number if it was overridden.
WH20.7
COL-ORIG-FL
Element: Orig Fl
Alpha 1
This field indicates whether this line was created as a result of item replacement or substitution.
R = Replacement line
S = Substitute line
WH20.7
COL-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
WH20.7
COL-CUST-ITEM-FL
Element: Cust Item Fl
Alpha 1
This field indicates whether the number entered in the order line represents an item set up in the Order Entry Customer file.
C = Customer item was entered
WH20.7
COL-CUST-ITEM
Element: Item
Alpha 32
This field contains the customer's item number.
WH20.7
COL-KIT-FL
Element: Kit Fl
Alpha 1
This field indicates when the item ordered is a made-to-order kit.
N = Not a kit
O = Make to order kit
S = Make to stock kit
WH20.7
COL-KIT-ALLOC-FL
Element: Kit Alloc Fl
Alpha 1
This field indicates whether the kit has been allocated.
0 = Kit allocated
1 = Kit needs options chosen
WH20.7
COL-HOLD-CODE
Element: Hold Code
Alpha 4
If the line is on hold, this field contains the hold code. Hold codes are set up in Accounts Receivable.
WH20.7
COL-INV-LOC
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
WH20.7
COL-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company. The process level determines which general ledger account the order's invoice debits when its rate updates to Accounts Receivable.
WH20.7
COL-SPR-UOM
Element: Uom
Alpha 4
This field contains the pricing unit of measure. This must be a valid pricing unit of measure for the item if the line is not a special order line.
WH20.7
COL-SELL-UOM
Element: Uom
Alpha 4
This field contains the stock unit of measure for the item. If entered, it must be a valid stock unit of measure for this line's item. If not entered, the default stock unit of measure for this line's item is assigned.
WH126 WH20.7
COL-SEC-UOM
Element: Uom
Alpha 4
This field contains the secondary quantity unit of measure. This is used only when the item is a catch weight item.
WH20.7
COL-NO-CHARGE-FL
Element: No Charge Fl
Alpha 1
This field indicates the item's price is zero. This defaults to No. If set to Yes, this field prevents the system from pricing the item. No charge invoices are not to be passed to Accounts Receivable for collection.
N = No
Y = Yes
WH20.7
COL-RATE-OVR-FL
Element: Rate Ovr Fl
Alpha 1
This flag indicates whether the currency conversion rate was overridden for this line of the order.
Y = Yes
N = No
WH20.7
COL-PRICE-STATUS
Element: Price Status
Alpha 1
This field indicates how the line was priced.
A = Amalgamated (group) pricing
C = System calculated pricing
O = Price override
WH20.7
COL-PRICE-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date used to price the line. The system date defaults when the line is added.
WH20.7
COL-ENTERED-PRICE
Element: Intl Cost
Signed 18.5
This field contains the unit price in the currency of the order.
WH20.7
COL-UNIT-PRICE
Element: Intl Cost
Signed 18.5
This field contains the unit price in base currency. This is an amount per stock unit of measure.
WH20.7
COL-SELL-UNIT-PRC
Element: Sell Unit Prc
Signed 18.5
This field contains the price per sell unit of measure in base currency. If multiple unit of measure pricing is used, this is the weighted average price per sell unit of measure.
WH20.7
COL-SELL-PRC-CURR
Element: Sell Unit Prc
Signed 18.5
This field contains the price per sell unit of measure in transaction currency. If multiple unit of measure pricing is used, this is the weighted average price per sell unit of measure.
WH20.7
COL-UNIT-COST
Element: Intl Cost
Signed 18.5
WH20.7
COL-DISC-AMT-CURR
Element: Intl Amt
Signed 18.2
This field contains the discount amount in transaction currency.
WH20.7
COL-MULT-DISC-AMT
Element: Mult Disc Amt
Derived
This field contains the discount amount in base currency if a multiplier is used when converting from original to base currency.
COL-DIV-DISC-AMT
Element: Div Disc Amt
Derived
This field contains the discount amount in base currency if a divider is used when converting from original to base currency.
COL-DISC-AMT-BASE
Element: Disc Amt Base
Derived
This field contains the discount amount in base currency.
COL-DISC-CODE
Element: Discount Code
Alpha 10
This field contains the discount code used to calculate the discount amount for this line.
WH20.7
COL-MULT-SPR-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
WH20.7
COL-SPR-TO-STOCK
Element: Sell To Stock
Signed 13.7
This field contains the multiplier used with special order items when converting from pricing unit of measure to stock unit of measure.
WH20.7
COL-SELL-TO-STOCK
Element: Sell To Stock
Signed 13.7
This field contains the multiplier that is used with special order items when converting from selling unit of measure to stock unit of measure.
WH20.7
COL-SEC-TO-STOCK
Element: Sell To Stock
Signed 13.7
This field contains the multiplier that is used with catch weight items when converting secondary unit of measure to stock unit of measure.
WH20.7
COL-ORD-DISC-FL
Element: Ord Disc Fl
Alpha 1
This field indicates whether this line is eligible for an order discount.
Y = Yes
N = No
WH20.7
COL-CUST-SHIP-TO
Element: Ship To
Numeric 4
This field contains the ship-to customer number. This defaults from the order header.
WH20.7
COL-CREATE-PO
Element: All Flag
Alpha 1
This field indicates the item is ordered by a purchase order rather than using stock.
N = No
Y = Yes
WH20.7
COL-DROPSHIP-FL
Element: Dropship Fl
Alpha 1
This field indicates whether the items of the purchase order are sent directly from the vendor to the customer. If this field is set to No, items are shipped to the user who entered the order for shipment to the customer.
N = No
Y = Yes
WH20.7
COL-CARRIER
Element: Vendor
Alpha 9 (Right Justified)
This field contains the carrier number. This must be a valid vendor defined in Accounts Payable.
WH20.7
COL-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order. This is used if the purchase order line is added to an existing purchase order.
WH20.7
COL-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code that will be used as part of the purchase order number for a create po order line.
WH20.7
COL-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
This field contains the vendor of the purchase order. If left blank, Purchase Order assigns a vendor to the purchase order.
WH20.7
COL-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
WH20.7
COL-IF-REF-NBR
Element: If Ref Nbr
Numeric 9
This field contains an internally generated reference number used by the Requisition system.
WH20.7
COL-ROUTE
Element: Route
Numeric 4
This field contains the route number. If left blank, the route assigned to the ship-to customer defaults from the Order Entry Route file. If no route is assigned to the ship-to customer in the Order Entry Route file, the route defaults from the customer.
WH120 WH20.7
WH21.3 WH21.4
COL-STOP
Element: Stop
Numeric 4
This field contains the stop within the route. If left blank, this defaults from the ship-to customer from the Order Entry Route file. If no stop is associated with the ship-to customer, this defaults from the customer's file.
WH120 WH20.7
WH21.3 WH21.4
COL-RTE-CREATE-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
WH110 WH120
WH130 WH132
WH190 WH20.7
WH21.1 WH21.2
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
COL-EXP-DELIV-DT
Element: Date
Numeric 8 (yyyymmdd)
This field contains the expected delivery date. This field is valid only for a company that uses routes and stops. The expected delivery date is calculated by adding the ship days from the process level associated with the order to the system date when the order is added. This field determines when the order prints on the picking list for processing.
WH120 WH20.7
WH21.3 WH21.4
COL-TERRITORY
Element: Territory
Alpha 4
This field contains the sales territory. If left blank, this defaults from the ship-to customer. If no sales territory is assigned to the ship-to customer, this defaults from the customer's file.
WH20.7
COL-SALESMAN
Element: Salesman
Numeric 4
This field contains the code that represents the primary sales representative of this line. This defaults from the order header.
WH20.7
COL-SALESMAN-2
Element: Salesman
Numeric 4
This field contains the code representing the second sales representative. This defaults from the order header.
WH20.7
COL-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
Commission split for the second sales representative. This is the percentage of this line's total value the secondary sales representative's commission rate is applied to.
WH20.7
COL-COMM-RATE-1
Element: Chrg Rate
Percent 7.5 (Percent)
Commission rate for sales representative 1. Defaults from the sales representative file.
WH20.7
COL-COMM-RATE-2
Element: Chrg Rate
Percent 7.5 (Percent)
This field contains the commission rate for the second sales representative. This defaults from the sales representative file.
WH20.7
COL-ENTERED-DISC
Element: Intl Amt
Signed 18.2
This field contains a per line discount rather than a per unit discount as entered in the order-line's billing currency.
WH20.7
COL-MULT-ADD-DISC
Element: Mult Add Disc
Derived
This field contains the add-on discount amount in base currency if a multiplier is used to convert from original to base currency.
COL-DIV-ADD-DISC
Element: Div Add Disc
Derived
This field contains the additional discount amount in base currency if a divider is used to convert from original to base currency.
COL-ADD-DISC-BASE
Element: Add Disc Base
Derived
This field contains the additional discount amount in base currency.
COL-DISC-TKN-CURR
Element: Intl Amt
Signed 18.2
This field contains the amount of the additional discount that has been used by invoices for this order line in billing currency. If you need to lower an additional discount on the line, the amount cannot be lowered below amount found in this field for this line.
WH20.7
COL-MULT-DISC-TKN
Element: Mult Disc Tkn
Derived
This field contains the multiplier used to derive the base currency amount of the discount if the order or invoice is entered in foreign currency.
COL-DIV-DISC-TKN
Element: Div Disc Tkn
Derived
This field contains the multiplier used to derive the base currency amount of the discount if the order or invoice is entered in foreign currency.
COL-DISC-TKN-BASE
Element: Disc Tkn Base
Derived
This field contains the amount of additional discount in base currency used by invoices for this order line.
COL-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
This field contains the tax exempt code. This defaults from the order header. If the order header is tax exempt, the line is also tax exempt.
E = Exempt
T = Taxable
WH20.7
COL-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing the tax authorities this ship-to pays sales tax to. This must be valid in the Tax Code file. If the company is not using a third-party tax system, this code is the tax code for the order line. Tax codes are entered in Tax and can be associated with the customer or entered when adding the order.
WH20.7
COL-TAXABLE-CURR
Element: Intl Amt
Signed 18.2
This field contains the taxable amount in billing currency.
WH20.2 WH20.7
COL-MULT-TAXABLE
Element: Mult Taxable
Derived
This field contains the taxable amount in base currency if a multiplier is used to convert from original to base currency.
COL-DIV-TAXABLE
Element: Div Taxable
Derived
This field contains the taxable amount in base currency if a divider is used to convert from original to base currency.
COL-OVR-TAXABLE
Element: Intl Amt
Signed 18.2
This field contains the override taxable amount in base currency.
WH20.2 WH20.7
COL-MULT-OVR-TXBL
Element: Mult Ovr Txbl
Derived
This field contains the override taxable amount in base currency if a multiplier is used to convert from original to base currency.
COL-DIV-OVR-TXBL
Element: Div Ovr Txbl
Derived
This field contains the override taxable amount in base currency if a divider is used to convert from original to base currency.
COL-TAXABLE-BASE
Element: Taxable Base
Derived
This field contains the override taxable amount in base currency.
COL-EARLY-DL-DATE
Element: Early Dl Date
Numeric 8 (yyyymmdd)
This field contains the early delivery date.
WH20.7
COL-LATE-DL-DATE
Element: Late Dl Date
Numeric 8 (yyyymmdd)
This field contains the late delivery date.
WH20.7
COL-USER-DATE-3
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
WH20.7
COL-USER-DATE-4
Element: Date
Numeric 8 (yyyymmdd)
This field contains the fourth user-defined date. Informational purposes only used on Orders Not Shipped for Customer (OE280).
WH20.7
COL-USER-FLD1
Element: Po User Fld 2
Alpha 2
This field contains the first user-definable field. If a purchase order is created for this order, this field updates to Purchase Order.
WH20.7
COL-USER-FLD2
Element: User Fld2
Alpha 30 (Lower Case)
This field contains the second user-definable field. If a purchase order is created for this order, this field updates to Purchase Order. This field also updates to Sales Analysis.
WH20.7
COL-USER-FLD3
Element: User Fld3
Alpha 15 (Lower Case)
This field contains the third user-definable field. If a purchase order is created for this order, this field updates to Purchase Order. This field also updates to Sales Analysis.
WH20.7
COL-EXP-SHIP-DT
Element: Date
Numeric 8 (yyyymmdd)
Expected ship date. Defaulted by the system as the number of ship days (from process level record) beyond the system date when the line is added. May be overridden.
WH20.7
COL-ALLOCATE-DT
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date used for batch allocations. The type of date depends on a company option, and can be the order date, the customer requested delivery date or the expected ship date.
WH20.7
COL-LIST-NAME
Element: List Name
Alpha 14
This field contains the name of the price list, if this line is priced using a price list or a promotion.
WH20.7
COL-CONTRACT-NBR
Element: Contract Nbr
Alpha 14
This field contains the contract number, if this line is priced using a contract.
WH20.7
COL-PROMOTION
Element: Promotion
Alpha 10
This field contains the promotion name, if this line is priced via a promotion. When combined with the list name, it provides access to the promotion file.
WH20.7
COL-ACTIVITY
Element: Activity
Alpha 15
In this file the Activity field is used for the revenue (sales) side of the posting whereas the Activity-C field is used for the Cost (COGS) side of the posting. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.
WH20.7
COL-ACCT-CATEGORY
Element: Acct Category
Alpha 5
In this file the Acct-Category field is used for revenue (sales) postings whereas the Acct-Categ-C field is used for Cost (COGS) postings. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using Account Assignment (AC07.1). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.
WH20.7
COL-ATN-OBJ-ID
Element: Obj Id
Numeric 12
Represents Activity Management system ID for the revenue (sales) activity. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting inquiries.
WH20.7
COL-ACTIVITY-C
Element: Activity
Alpha 15
In this file the Activity-C field is used for the Cost (COGS) side of the posting whereas the Activity field is used for the revenue (sales) side of the posting. Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in Project Accounting. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries.
WH20.7
COL-ACCT-CATEG-C
Element: Acct Category
Alpha 5
In this file the Acct-Categ-C field is used for Cost (COGS) postings whereas the Acct-Category field is used for revenue (sales) postings. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in Project Accounting. All transactions are posted to an account category within an activity. You can assign a specific general ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using Account Assignment (AC07.1). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing.
WH20.7
COL-ATN-OBJ-ID-C
Element: Obj Id
Numeric 12
The system defined object id representing the Activity Management commitment for Cost (COGS).
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
COL-BOOKED-FL
Element: Account Flag
Alpha 1
This field indicates if the order line has been booked by the Sales Analysis system.
WH20.7
COL-BOOKED-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field indicates the date when the order line was booked by Sales Analysis.
WH20.7
COL-BOOKED-QTY
Element: Quantity
Signed 13.4
This field contains the quantity booked to the customer and sales representative totals. This is updated to Sales Analysis for reporting and inquiry analysis.
WH20.7
COL-ORDER-QTY
Element: Quantity
Signed 13.4
The order quantity of the line item.
WH130 WH132
WH190 WH20.7
WH520 WH830
COL-SHIPPED-QTY
Element: Quantity
Signed 13.4
This field contains the shipped quantity.
WH126 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHD2.1
COL-INVOICE-QTY
Element: Quantity
Signed 13.4
This field contains the quantity that has been invoiced for this order line.
WH20.7
COL-RETURNED-QTY
Element: Quantity
Signed 13.4
Total quantity returned compared to this quantity.
COL-FIRM-FL
Element: Firm Fl
Alpha 1
This field indicates if the allocation is firm. If the value is set to Yes, WH110 (Batch Allocation) skips the record in the de-allocation phase.
Y = Yes
N = No
WH20.7
COL-SHIP-COMP-FL
Element: Ship Comp Fl
Alpha 1
WH20.7
COL-PK-PRIORITY
Element: Pk Priority
Numeric 2
WH20.7
COL-SLS-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the sales account unit, if the line is special order. If left blank, this defaults from the process level.
WH20.7
COL-SLS-ACCOUNT
Element: Account
Numeric 6
This field contains the sales account number, if the line is for a special order item. If left blank, this defaults from the process level.
WH20.7
COL-SLS-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the sales subaccount number, if the line is special order. If left blank, this defaults from the process level.
WH20.7
COL-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
This field contains the general ledger account to credit for the cost amount of non-stock and special orders. This defaults from the process level for special order lines and from the major/minor sales class file for non-stock lines.
WH20.7
COL-EXP-ACCOUNT
Element: Account
Numeric 6
This field contains the general ledger distribution account that is credited for non-stock and special orders. This defaults from the process level for special orders and from major/minor sales class for non-stock orders.
WH20.7
COL-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the general ledger distribution subaccount that is credited for non-stock and special orders. This defaults from the process level for special orders and from the major/minor sales class for non-stock orders.
WH20.7
COL-CGS-ACCT-UNIT
Element: Acct Unit
Alpha 15
The cost of goods sold account unit is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.
WH20.7
COL-CGS-ACCOUNT
Element: Account
Numeric 6
The cost of goods sold account number is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.
WH20.7
COL-CGS-SUB-ACCT
Element: Sub Acct
Numeric 4
The cost of goods sold subaccount number is debited and defaults from the process level for special order items or from the sales class for inventoried or non-stock items. This account is credited for return to stock transactions.
WH20.7
COL-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
A classification of items for determining taxes using the VERTEX system in Lawson Order Entry system or the cash receipts programs in the Lawson Cash Ledger system.
WH20.7
COL-CXL-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the date this line was canceled.
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
COL-CXL-QTY
Element: Rec Qty
Signed 13.4
This field contains the quantity canceled for this order line.
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
COL-CXL-OPR
Element: Requester
Alpha 10 (Lower Case)
This field contains the user ID of the person who canceled this order line.
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
COL-CXL-REASON
Element: Cb Reason
Alpha 4
This field contains the reason for canceling this order. Reason codes are set up in Reason Codes (BL07.1).
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
COL-LAST-COMM-SEQ
Element: Seq
Numeric 3
This field contains the sequence number of the last comment line entered on this line.
BLI2.1 WH20.7
COL-LAST-MISC-SEQ
Element: Seq
Numeric 3
This field contains the last sequence used for miscellaneous charges for this line.
WH20.7
COL-MSDS-REQ-FL
Element: All Flag
Alpha 1
This field indicates that an MSDS (Material Safety Data Sheet) is required. If set to Yes, an MSDS acknowledgment is required for the first shipment containing the item even if an MSDS acknowledgment has been sent within a year for this item to the customer. Order Entry does not create MSDS forms, but it keeps track of when the form was sent.
Y = Yes
N = No
WH20.7
COL-LAST-SHIP-NBR
Element: Shipment Nbr
Numeric 10
This field contains the last shipment number created for this order line.
WH20.7
COL-WORK-ORDER
Element: Work Order
Numeric 8
This identifies the work order the line may be associated with. It is used if work order is active and the line is a finished good with a backorder quantity.
COL-WORK-ORDER-SUF
Element: Work Order Suf
Numeric 2
This is the suffix of the work order the line may be associated with. It will normally be zero.
COL-PRICE-REC-TYPE
Element: Price Rec Type
Alpha 1

C = Class
I = Item
WH20.7
COL-QTY-BREAK-FL
Element: Qty Break Fl
Alpha 1

Y = Yes
N = No
WH20.7
COL-GROSS-AMOUNT
Element: Gross Amount
Derived
This field contains the line extension in base currency before discounts are taken.
COL-NET-AMOUNT
Element: Net Amount
Derived
This field contains the line amount in base currency after discounts have been removed.
COL-CURR-GROSS
Element: Curr Gross
Derived
This field contains the gross amount in transaction currency.
COL-CURR-NET
Element: Curr Net
Derived
This field contains the line net amount in transaction currency.
COL-OPEN-TO-ALLOC
Element: Open To Alloc
Derived
This field contains quantity available for allocation.
COL-ALLOC-NOT-PRT
Element: Alloc Not Prt
Derived
This field contains the allocated quantity that has not been printed on the picking list.
COL-PROJ-STD-COST
Element: Proj Std Cost
Derived
This field contains the projected cost for a standard cost company. This is used when editing the profit margin for a particular order.
COL-PROJ-AVG-COST
Element: Proj Avg Cost
Derived
This field contains the projected cost for any company not using standard cost. This is used when editing the profit margin for a particular order.
COL-PROJ-SPL-COST
Element: Proj Spl Cost
Derived
This field contains the projected extended cost for special and nonstock items. This is based on the cost entered when adding the order. This is used when calculating the profit margin of the order.
COL-PROJ-COST
Element: Proj Cost
Derived
This field contains the projected cost for this line. This can either be the projected standard cost or the projected average cost.
COL-PROJ-MARGIN
Element: Proj Margin
Derived
This field contains the projected margin for this line.
COL-UNBILLED-QTY
Element: Unbilled Qty
Derived
This field contains the unbilled quantity on the line.
COL-UNBILLED-BASE
Element: Unbilled Base
Derived
This field contains the unbilled quantity on the order line in base currency.
COL-UNBILLED-CURR
Element: Unbilled Curr
Derived
This field contains the unbilled amount in transaction currency.
COL-ORD-QTY-IN-STK
Element: Ord Qty In Stk
Derived
This field contains the quantity of item in stock unit of measure.
COL-BO-FL
Element: Bo Fl
Derived
This field indicates if the order line was backordered.
COL-PRICE-LOC
Element: Price Loc
Derived
This field indicates the pricing location for the order line.
COL-ORDER-FILLER
Element: Order Filler
Derived
Used to facilitate Drill Around to shipments for this order.
COL-ORDER-NBR-A
Element: Order Nbr A
Derived
Used to facilitate Drill Around to shipments for this order.
COL-DISP-ALLOCATED
Element: Disp Allocated
Derived
Used to facilitate Drill Around of quantity allocated.
COL-DISP-PRINTED
Element: Disp Printed
Derived
Used to facilitate Drill Around of pick list quantity printed.
COL-DISP-IN-PROC
Element: Disp In Proc
Derived
Used to facilitate Drill Around of quantity in process.
COL-DISP-BACKORD
Element: Disp Backord
Derived
Used to facilitate Drill Around of quantity back ordered.
COL-COMM-LIT
Element: Comm Lit
Derived
If comments are attached, this field displays "comments exist."
COL-DER-ORIGIN-CD
Element: Der Origin Cd
Derived
COL-INTR-COMP
Element: Intr Comp
Alpha 1
Identifies Inter-Company order lines as "O" for the customer order line, "S" for the shipping company, or N" not an Inter-company order line.
O = Inter-Co Customer order
S = Inter-Co Shipping order
N = Not an Inter-Co Order
WH20.7
COL-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
WH20.7
COL-PORT-CD
Element: Port Cd
Alpha 5
The Intrastat port code. Must be define in IN04.1 (Port Maintenance)
WH20.7
COL-NOTC
Element: Notc
Alpha 2
The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).
WH20.7
COL-STAT-PROC
Element: Stat Proc
Alpha 6
The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).
WH20.7
COL-SUPLMNTARY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
WH20.7
COL-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
WH20.7
COL-ICN-CODE
Element: Icn Code
Alpha 8
WH20.7
COL-BACK-ORD-FL
Element: Back Ord Fl
Alpha 1

Y = Backorder Allowed
N = Backorder Not Allowed
WH20.7
COL-GLBL-LINE-TYPE
Element: Glbl Line Type
Alpha 15
WH20.7
COL-FREIGHT-TOT
Element: Freight Total
Signed 18.2
WH20.7
COL-INSURANCE-TOT
Element: Insurance Tot
Signed 18.2
WH20.7
COL-CSTMS-TOT
Element: Cstms Total
Signed 18.2
WH20.7
COL-OTHER-AOC-TOT
Element: Other Aoc Tot
Signed 18.2
WH20.7


COLINE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COLSET1 COMPANY
ORDER-NBR
LINE-NBR
...
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
AP510 API1.1
API2.1 BLI2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
COLSET10 COMPANY
ORDER-NBR
TAX-CODE
PROD-TAX-CAT
LINE-NBR
KeyChange
WH20.2 WH20.7
COLSET11 COMPANY
CUSTOMER
ORDER-NBR
LINE-NBR
Subset
WhereCREATE-PO ="Y"
AndDROPSHIP-FL ="Y"
AndSTATUS =2
AndORDER-QTY >INVOICE-QTY
COLSET12 COMPANY
CUSTOMER
ORDER-NBR
LINE-NBR
Subset
WhereSTATUS =2
AndCREATE-PO ="Y"
AndORDER-QTY >SHIPPED-QTY
COLSET13 COMPANY
LINE-NBR
ORDER-NBR
WH20.7
COLSET2 COMPANY
INV-LOC
ITEM
PROCESS-LEVEL
ORDER-NBR
LINE-NBR
KeyChange, Subset
WhereSTATUS =2
WH120
COLSET3 COMPANY
CUSTOMER
ITEM
ORDER-NBR
LINE-NBR
KeyChange
IC11.1 IC216
COLSET4 COMPANY
ORDER-NBR
SALES-MAJCL
SALES-MINCL
LINE-NBR
Subset
WherePRICE-STATUS ="A"
WH20.2 WH20.7
COLSET5 ATN-OBJ-ID
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes
COLSET6 COMPANY
CUSTOMER
HOLD-CODE
ORDER-NBR
LINE-NBR
KeyChange, Subset
WhereHOLD-CODE !=Spaces
COLSET7 COMPANY
ORDER-NBR
LINE-NBR
Subset
WhereSTATUS <3
WH20.2 WH20.7
WH210
COLSET8 ATN-OBJ-ID-C
KeyChange, Subset
WhereATN-OBJ-ID-C !=Zeroes
COLSET9 COMPANY
ORDER-NBR
VENDOR
CUST-SHIP-TO
DROPSHIP-FL
LINE-NBR
Subset
WhereSTATUS =2
AndCREATE-PO ="Y"
AndORDER-QTY >SHIPPED-QTY
WH20.7


COLINE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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"
OrCOL-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
AndCOL-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"
OrCOL-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
NAME
RELATED 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


File created: Thu Jun 09 02:24:25 2016

Home
Contact Us



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