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 |
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. |
|
||||||
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. |
|
||||||
COL-LINE-NBR Element: Line Nbr | Numeric 6 This field displays the line number of the transaction number. |
|
||||||
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 |
|
||||||
COL-FUTURE-FL Element: Future Fl | Alpha 1 This field indicates if this line has a future status. Y = Yes N = No |
|
||||||
COL-SALES-MAJCL Element: Major Class | Alpha 4 This field contains the major sales class code. |
|
||||||
COL-SALES-MINCL Element: Minor Class | Alpha 4 This field contains the minor sales class code within the major class. |
|
||||||
COL-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||||||
COL-ITEM-DESC Element: Item Desc | Alpha 30 This field contains the description for stock and non-stock items. |
|
||||||
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. |
|
||||||
COL-ORIG-LINE Element: Orig Line | Numeric 4 This field contains the original line number if it was overridden. |
|
||||||
COL-ORIG-ITEM Element: Item | Alpha 32 This field contains the original item number if it was overridden. |
|
||||||
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 |
|
||||||
COL-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
||||||
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 |
|
||||||
COL-CUST-ITEM Element: Item | Alpha 32 This field contains the customer's item number. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
COL-INV-LOC Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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 |
|
||||||
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. |
|
||||||
COL-ENTERED-PRICE Element: Intl Cost | Signed 18.5 This field contains the unit price in the currency of the order. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-UNIT-COST Element: Intl Cost | Signed 18.5 |
|
||||||
COL-DISC-AMT-CURR Element: Intl Amt | Signed 18.2 This field contains the discount amount in transaction currency. |
|
||||||
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. |
|
||||||
COL-MULT-SPR-FL Element: All Flag | Alpha 1 Y = Yes N = No |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
COL-CUST-SHIP-TO Element: Ship To | Numeric 4 This field contains the ship-to customer number. This defaults from the order header. |
|
||||||
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 |
|
||||||
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 |
|
||||||
COL-CARRIER Element: Vendor | Alpha 9 (Right Justified) This field contains the carrier number. This must be a valid vendor defined in Accounts Payable. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||||||
COL-IF-REF-NBR Element: If Ref Nbr | Numeric 9 This field contains an internally generated reference number used by the Requisition system. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-RTE-CREATE-FL Element: All Flag | Alpha 1 Y = Yes N = No |
|||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-SALESMAN-2 Element: Salesman | Numeric 4 This field contains the code representing the second sales representative. This defaults from the order header. |
|
||||||
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. |
|
||||||
COL-COMM-RATE-1 Element: Chrg Rate | Percent 7.5 (Percent) Commission rate for sales representative 1. Defaults from the sales representative file. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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. |
|
||||||
COL-TAXABLE-CURR Element: Intl Amt | Signed 18.2 This field contains the taxable amount in billing currency. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-LATE-DL-DATE Element: Late Dl Date | Numeric 8 (yyyymmdd) This field contains the late delivery date. |
|
||||||
COL-USER-DATE-3 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||
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). |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-CONTRACT-NBR Element: Contract Nbr | Alpha 14 This field contains the contract number, if this line is priced using a contract. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-ATN-OBJ-ID-C Element: Obj Id | Numeric 12 The system defined object id representing the Activity Management commitment for Cost (COGS). |
|||||||
COL-BOOKED-FL Element: Account Flag | Alpha 1 This field indicates if the order line has been booked by the Sales Analysis system. |
|
||||||
COL-BOOKED-DATE Element: Date | Numeric 8 (yyyymmdd) This field indicates the date when the order line was booked by Sales Analysis. |
|
||||||
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. |
|
||||||
COL-ORDER-QTY Element: Quantity | Signed 13.4 The order quantity of the line item. |
|
||||||
COL-SHIPPED-QTY Element: Quantity | Signed 13.4 This field contains the shipped quantity. |
|||||||
COL-INVOICE-QTY Element: Quantity | Signed 13.4 This field contains the quantity that has been invoiced for this order line. |
|
||||||
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 |
|
||||||
COL-SHIP-COMP-FL Element: Ship Comp Fl | Alpha 1 |
|
||||||
COL-PK-PRIORITY Element: Pk Priority | Numeric 2 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
COL-CXL-DATE Element: Date | Numeric 8 (yyyymmdd) This field contains the date this line was canceled. |
|||||||
COL-CXL-QTY Element: Rec Qty | Signed 13.4 This field contains the quantity canceled for this order line. |
|||||||
COL-CXL-OPR Element: Requester | Alpha 10 (Lower Case) This field contains the user ID of the person who canceled this order line. |
|||||||
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). |
|||||||
COL-LAST-COMM-SEQ Element: Seq | Numeric 3 This field contains the sequence number of the last comment line entered on this line. |
|
||||||
COL-LAST-MISC-SEQ Element: Seq | Numeric 3 This field contains the last sequence used for miscellaneous charges for this line. |
|
||||||
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 |
|
||||||
COL-LAST-SHIP-NBR Element: Shipment Nbr | Numeric 10 This field contains the last shipment number created for this order line. |
|
||||||
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 |
|
||||||
COL-QTY-BREAK-FL Element: Qty Break Fl | Alpha 1 Y = Yes N = No |
|
||||||
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 |
|
||||||
COL-FOB-CODE Element: Fob Code | Alpha 3 The user defined Free On Board Code. |
|
||||||
COL-PORT-CD Element: Port Cd | Alpha 5 The Intrastat port code. Must be define in IN04.1 (Port Maintenance) |
|
||||||
COL-NOTC Element: Notc | Alpha 2 The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance). |
|
||||||
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). |
|
||||||
COL-SUPLMNTARY-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||||||
COL-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||||||
COL-ICN-CODE Element: Icn Code | Alpha 8 |
|
||||||
COL-BACK-ORD-FL Element: Back Ord Fl | Alpha 1 Y = Backorder Allowed N = Backorder Not Allowed |
|
||||||
COL-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15 |
|
||||||
COL-FREIGHT-TOT Element: Freight Total | Signed 18.2 |
|
||||||
COL-INSURANCE-TOT Element: Insurance Tot | Signed 18.2 |
|
||||||
COL-CSTMS-TOT Element: Cstms Total | Signed 18.2 |
|
||||||
COL-OTHER-AOC-TOT Element: Other Aoc Tot | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
COLSET1 |
COMPANY ORDER-NBR LINE-NBR |
|
||||||||||||||||||||||||||||||||
COLSET10 |
COMPANY ORDER-NBR TAX-CODE PROD-TAX-CAT LINE-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET11 |
COMPANY CUSTOMER ORDER-NBR LINE-NBR |
|
||||||||||||||||||||||||||||||||
COLSET12 |
COMPANY CUSTOMER ORDER-NBR LINE-NBR |
|
||||||||||||||||||||||||||||||||
COLSET13 |
COMPANY LINE-NBR ORDER-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET2 |
COMPANY INV-LOC ITEM PROCESS-LEVEL ORDER-NBR LINE-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET3 |
COMPANY CUSTOMER ITEM ORDER-NBR LINE-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET4 |
COMPANY ORDER-NBR SALES-MAJCL SALES-MINCL LINE-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET5 |
ATN-OBJ-ID |
|
||||||||||||||||||||||||||||||||
COLSET6 |
COMPANY CUSTOMER HOLD-CODE ORDER-NBR LINE-NBR |
|
||||||||||||||||||||||||||||||||
COLSET7 |
COMPANY ORDER-NBR LINE-NBR |
|
| |||||||||||||||||||||||||||||||
COLSET8 |
ATN-OBJ-ID-C |
|
||||||||||||||||||||||||||||||||
COLSET9 |
COMPANY ORDER-NBR VENDOR CUST-SHIP-TO DROPSHIP-FL LINE-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| ||||||||||||||||||||||||
Apvenmast | APVENMAST |
Required
| ||||||||||||||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||||||||||||||
Cogs Offset | GLMASTER |
Required
| ||||||||||||||||||||||||
Colineuom | COLINEUOM |
Not Required, Delete Cascades
| ||||||||||||||||||||||||
Contract | OEPRCLIST |
Required
| ||||||||||||||||||||||||
Cosgblk | COSGBLK |
Not Required
| ||||||||||||||||||||||||
Cucodes | CUCODES |
Required
| ||||||||||||||||||||||||
Curelat | CURELAT |
Required
| ||||||||||||||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||||||||||||||
Custorder | CUSTORDER |
Required
| ||||||||||||||||||||||||
Cxl Operator | OPERATOR |
Required
| ||||||||||||||||||||||||
Glsystem | GLSYSTEM |
Required
| ||||||||||||||||||||||||
Hdrloc | ITEMLOC |
Not Required
| ||||||||||||||||||||||||
Holdcodes | HOLDCODES |
Required
| ||||||||||||||||||||||||
Iccategory | ICCATEGORY |
Not Required
| ||||||||||||||||||||||||
Iccompany | ICCOMPANY |
Required
| ||||||||||||||||||||||||
Iclocation | ICLOCATION |
Required
| ||||||||||||||||||||||||
Itemlocation | ITEMLOC |
Required
| ||||||||||||||||||||||||
Itemmast | ITEMMAST |
Required
| ||||||||||||||||||||||||
Kititem | KITITEM |
Not Required
| ||||||||||||||||||||||||
Kititem 2 | KITITEM |
Not Required
| ||||||||||||||||||||||||
Majorcl | MAJORCL |
Required
| ||||||||||||||||||||||||
Minorcl | MINORCL |
Not Required
| ||||||||||||||||||||||||
Oecoluf | OECOLUF |
Required
| ||||||||||||||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||||||||||||||
Oecust | OECUST |
Required
| ||||||||||||||||||||||||
Oeproclev | OEPROCLEV |
Required
| ||||||||||||||||||||||||
Oereason | OEREASON |
Not Required
| ||||||||||||||||||||||||
Oeslsacct | OESLSACCT |
Required
| ||||||||||||||||||||||||
Operator | OPERATOR |
Required
| ||||||||||||||||||||||||
Ordertype | ORDERTYPE |
Required
| ||||||||||||||||||||||||
Po Vendor | APVENMAST |
Required
| ||||||||||||||||||||||||
Promotion | OEPRCLIST |
Required
| ||||||||||||||||||||||||
Sales Acct | GLMASTER |
Required
| ||||||||||||||||||||||||
Salesrep1 | SALESREP |
Required
| ||||||||||||||||||||||||
Salesrep2 | SALESREP |
Required
| ||||||||||||||||||||||||
Shipto | SHIPTO |
Required
| ||||||||||||||||||||||||
Teritory | TERITORY |
Required
| ||||||||||||||||||||||||
Txtaxcode | TXTAXCODE |
Required
| ||||||||||||||||||||||||
Whdemndhdr | WHDEMNDHDR |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Comisc | COMISC |
| ||||||||||||||||||||||||||||||
Companions | ITEMSUB |
| ||||||||||||||||||||||||||||||
Component | COMPONENT |
| ||||||||||||||||||||||||||||||
Components | COMPONENT |
| ||||||||||||||||||||||||||||||
Itemcompanion | ITEMSUB |
| ||||||||||||||||||||||||||||||
Itemloc | ITEMLOC |
Required
| ||||||||||||||||||||||||||||||
Itemsub | ITEMSUB |
| ||||||||||||||||||||||||||||||
Itserial | ITSERIAL |
| ||||||||||||||||||||||||||||||
Oeaudit | OEAUDIT |
Delete Cascades
| ||||||||||||||||||||||||||||||
Oeordcmnt | OEORDCMNT |
| ||||||||||||||||||||||||||||||
Polinesrc | POLINESRC |
| ||||||||||||||||||||||||||||||
Returnline | RETURNLINE |
| ||||||||||||||||||||||||||||||
Sohbins | SOHDETAIL |
| ||||||||||||||||||||||||||||||
Sohdetail | SOHDETAIL |
| ||||||||||||||||||||||||||||||
Substitutions | ITEMSUB |
| ||||||||||||||||||||||||||||||
Vendor Company | ICLOCATION |
| ||||||||||||||||||||||||||||||
Whdemand | WHDEMAND |
| ||||||||||||||||||||||||||||||
Whshipline | WHSHIPLINE |
| ||||||||||||||||||||||||||||||
Whshipment | WHSHIPMENT |
|
All trademarks and registered trademarks are the property of their
respective owners.