CUSTORDER FILE Customer Order File This file contains a record for every order entered in the Lawson Order Entry system. This is the order header record for which any lines on the order are kept in the Customer Order Line file. REFERENCED BY BL00.1 BL120 BL122 BL123 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL291 BL520 BL720 BL80.1 BL820 BL91.1 BL940 OE12.1 OE210 OE270 OE280 OE281 OE282 OE283 OE284 OE286 OE287 OE288 OE289 OE290 OE293 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE80.1 OE80.3 OE80.2 OE80.6 OE80.4 OE80.5 OE81.1 OE81.2 OE830 OE950 WH120 WH126 WH140 WH21.2 WH21.4 WH222 WH224 WH962 WH963 AR08.1 AR10.1 AR501 AR550 OE291 OE292 OE53.1 AR115 AR124 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR30.1 AR30.2 AR30.4 AR570 AR575 AR580 CB191 UPDATED BY BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.2 OE11.3 OE11.4 OE11.8 OE11.9 OE110 OE112 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE310 OE510 OE810 OE90.1 OE920 OE966 OE999 SA100 SA101 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 WH966 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY COR-COMPANY Numeric 4 BL92.1 OE10.1 Company The company number represents an OE10.2 OE10.3 established company and is entered on OE10.4 OE10.5 all function codes. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ORDER-NBR Numeric 8 BL92.1 OE10.1 Order Number Each order is assigned a unique number. OE10.2 OE10.3 Order numbers are either manually OE10.4 OE10.5 assigned or system assigned based on a OE10.6 OE10.7 company-level option. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-STATUS Numeric 1 BL92.1 OE10.1 Status This field contains the status of the OE10.2 OE10.3 order. OE10.4 OE10.5 1 = Unreleased OE10.6 OE10.7 2 = Released OE10.8 OE11.1 8 = Cancelled OE11.4 OE11.8 9 = Ready for purge OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PROCESS-LEVEL Alpha 5 BL92.1 OE10.1 Process Level This field contains the process level, OE10.2 OE10.3 which is the reporting hierarchy below OE10.4 OE10.5 company. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ORDER-TYPE Alpha 2 BL92.1 OE10.1 Order Type Code This field contains the order type. OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ORDER-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1 Order Date This field contains the date of the OE10.2 OE10.3 order. The system date defaults. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PRICE-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1 Price Date This field contains the pricing basis OE10.2 OE10.3 date. If left blank, each line when OE10.4 OE10.5 added defaults to the system date. The OE10.6 OE10.7 price date is tied to the price list. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-OPR-CODE Alpha 10 (Lower Case) BL92.1 OE10.1 Operator Code This field contains the user ID, which OE10.2 OE10.3 is required for each order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CHG-OPR Alpha 10 (Lower Case) BL92.1 OE10.1 Chg Opr This field contains the user ID of the OE10.2 OE10.3 last operator to maintain this order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CRED-OPR Alpha 10 (Lower Case) BL92.1 OE10.1 Cred Opr This field contains the user ID of the OE10.2 OE10.3 person who released the order from OE10.4 OE10.5 credit hold. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE90.1 OE920 OE966 OE999 WH20.7 COR-CUST-PO-NBR Alpha 20 BL92.1 OE10.1 Customer P.O. Number This field contains the customer's OE10.2 OE10.3 purchase order number. If a purchase OE10.4 OE10.5 order number is entered, it updates to OE10.6 OE10.7 the order and any invoices created from OE10.8 OE11.1 this order. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LETTER-OF-CR Alpha 20 BL92.1 OE10.1 Letter of Credit This field contains the letter of OE10.2 OE10.3 credit. This value prints on the invoice OE10.4 OE10.5 and, if the order is dropshipped, this OE10.6 OE10.7 field prints on the purchase order. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-TO Numeric 4 BL92.1 OE10.1 Bill-To Customer This field contains the bill-to OE10.2 OE10.3 Number customer number. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 WH20.7 COR-CUSTOMER Alpha 9 (Right Justified) BL122 BL92.1 Customer Number This field contains the number that OE10.1 OE10.2 represents a customer. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-NAME Alpha 30 (Lower Case) BL122 BL92.1 Billing Name This field contains the bill-to OE10.1 OE10.2 customer's name. This defaults from the OE10.3 OE10.4 customer file, but can be overridden. OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE282 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-ADDR1 Alpha 30 (Lower Case) BL122 BL92.1 Billing Address One This field contains the first line of OE10.1 OE10.2 the bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-ADDR2 Alpha 30 (Lower Case) BL122 BL92.1 Billing Address Two This field contains the second line of OE10.1 OE10.2 the bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-ADDR3 Alpha 30 (Lower Case) BL122 BL92.1 Bill Addr3 This field contains the third line of OE10.1 OE10.2 the bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-ADDR4 Alpha 30 (Lower Case) BL122 BL92.1 Bill Addr4 This field contains the fourth line of OE10.1 OE10.2 the bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-CITY Alpha 18 BL122 BL92.1 Billing City This field contains the city of the OE10.1 OE10.2 bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-STATE Alpha 2 BL122 BL92.1 Billing State This field contains the state or OE10.1 OE10.2 province of the bill-to customer's OE10.3 OE10.4 address. OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-ZIP Alpha 10 BL122 BL92.1 Billing Zip Code This field contains the postal code of OE10.1 OE10.2 the bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BILL-CNTRY Alpha 30 (Lower Case) BL122 BL92.1 Billing County This field contains the country of the OE10.1 OE10.2 bill-to customer's address. OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-EXP-SHIP-DT Numeric 8 (yyyymmdd) BL92.1 OE10.1 Expected Ship Date This field contains the expected ship OE10.2 OE10.3 date of this order. If left blank and no OE10.4 OE10.5 ship days are defined on this order's OE10.6 OE10.7 process level, the order date defaults. OE10.8 OE11.1 If ship days exist with the process OE11.4 OE11.8 level, the ship days are added to the OE11.9 OE110 order date to calculate the expected OE113 OE114 ship date. OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH132 WH20.7 WH222 COR-RQST-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1 Request Date This field contains the customer's OE10.2 OE10.3 requested delivery date. If left blank, OE10.4 OE10.5 the system date defaults. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-USER-ID-RLS Alpha 3 BL92.1 OE10.1 User Id Rls This field contains the user ID of the OE10.2 OE10.3 person who released this order. This OE10.4 OE10.5 field is only used if the order is OE10.6 OE10.7 entered using the Customer Entry of OE10.8 OE11.1 OE15. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-USER-ID-ENTRY Alpha 3 BL92.1 OE10.1 User Id Entry This field contains the user ID of the OE10.2 OE10.3 person who entered this order at the OE10.4 OE10.5 customer's site. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TAX-EXEMPT-CD Alpha 1 BL92.1 OE10.1 Tax Exempt Code This field contains the tax exempt OE10.2 OE10.3 code. If the order header is tax exempt, OE10.4 OE10.5 all order lines are tax exempt. If the OE10.6 OE10.7 order is taxable, you can override the OE10.8 OE11.1 taxable status of individual lines. If OE11.4 OE11.8 lines on the order are taxable, then the OE11.9 OE110 order header must be taxable. If either OE113 OE114 the customer or the item(s) involved OE129 OE14.4 with the order are exempt then the OE15.1 OE15.2 entire order is exempt. OE15.3 OE15.4 E = Exempt OE15.5 OE15.7 T = Taxable OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO Numeric 4 BL92.1 OE10.1 Ship-to Code This field contains the ship-to OE10.2 OE10.3 customer's number. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-NAME Alpha 30 (Lower Case) BL92.1 OE10.1 Ship-to Name This field contains the name of OE10.2 OE10.3 the-ship-to customer. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-ADDR1 Alpha 30 (Lower Case) BL92.1 OE10.1 Ship-to Address This field contains the first line of OE10.2 OE10.3 Line 1 the ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-ADDR2 Alpha 30 (Lower Case) BL92.1 OE10.1 Ship-to Address This field contains the second line of OE10.2 OE10.3 Line 2 the ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-ADDR3 Alpha 30 (Lower Case) BL92.1 OE10.1 Ship To Addr3 This field contains the third line of OE10.2 OE10.3 the ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-ADDR4 Alpha 30 (Lower Case) BL92.1 OE10.1 Ship To Addr4 This field contains the fourth line of OE10.2 OE10.3 the ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-CITY Alpha 18 BL92.1 OE10.1 Ship-to City This field contains the city of the OE10.2 OE10.3 ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-STATE Alpha 2 BL92.1 OE10.1 Ship-to State or This field contains the state or OE10.2 OE10.3 Province province of the ship-to customer's OE10.4 OE10.5 address. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-ZIP Alpha 10 BL92.1 OE10.1 Ship-to Postal Code This field contains the postal code of OE10.2 OE10.3 the ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-TO-CNTRY Alpha 30 (Lower Case) BL92.1 OE10.1 Ship-to Country This field contains the country of the OE10.2 OE10.3 ship-to customer's address. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-HOLD-CODE Alpha 4 BL92.1 OE10.1 Hold Code This field contains the hold code. If OE10.2 OE10.3 this field is not blank, processing for OE10.4 OE10.5 the order is suspended. You can take an OE10.6 OE10.7 order off hold by clearing its hold code OE10.8 OE11.1 field. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE90.1 OE920 OE966 OE999 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 COR-HOLD-APR-FL Alpha 1 BL92.1 OE10.1 Hold Apr Fl This field indicates if the hold code OE10.2 OE10.3 is approved. When a one time credit hold OE10.4 OE10.5 code is removed, this field defaults to OE10.6 OE10.7 Yes, which ensures the order is not OE10.8 OE11.1 placed on hold. OE11.4 OE11.8 Y = Yes OE11.9 OE110 N = No OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE90.1 OE920 OE966 OE999 WH20.7 COR-INV-LOCATION Alpha 5 BL92.1 OE10.1 Inventory Location This field contains the location from OE10.2 OE10.3 which inventory is taken. If the item OE10.4 OE10.5 ordered is nonstock, the inventory OE10.6 OE10.7 location is used for reporting purposes. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TERRITORY Alpha 4 BL92.1 OE10.1 Sales Territory This field contains the sales territory OE10.2 OE10.3 for this order. This defaults from the OE10.4 OE10.5 order's ship-to customer. If no ship-to OE10.6 OE10.7 customer is associated with the order, OE10.8 OE11.1 this defaults from the customer's file. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SALESMAN Numeric 4 BL92.1 OE10.1 Salesman Number This field contains the primary sales OE10.2 OE10.3 representative for this order. This OE10.4 OE10.5 defaults from the order's ship-to OE10.6 OE10.7 customer. If no ship-to customer is OE10.8 OE11.1 associated with the order, this defaults OE11.4 OE11.8 from the customer's file. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SALESMAN-2 Numeric 4 BL92.1 OE10.1 Salesman Number 2 This field contains the code OE10.2 OE10.3 representing the second sales OE10.4 OE10.5 representative. This defaults from the OE10.6 OE10.7 ship-to customer. If no ship-to customer OE10.8 OE11.1 is associated with the order, this OE11.4 OE11.8 defaults from the customer's file. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-COMM-SPLIT Percent 5.3 (Percent) BL92.1 OE10.1 Commission Split This field contains the commission OE10.2 OE10.3 Percentage split. This defaults from the customer OE10.4 OE10.5 file. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-COMM-RATE-1 Percent 7.5 (Percent) BL92.1 OE10.1 Commission Rate for This field contains the commission rate OE10.2 OE10.3 Slsmn 1 of the primary sales representative. OE10.4 OE10.5 This defaults from the sales OE10.6 OE10.7 representative's file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-COMM-RATE-2 Percent 7.5 (Percent) BL92.1 OE10.1 Commission Rate for This field contains the commission rate OE10.2 OE10.3 Slsmn 2 for the second sales representative. OE10.4 OE10.5 This defaults from the sales OE10.6 OE10.7 representative's file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CC-TYPE Alpha 2 BL92.1 OE10.1 Credit Card Type This field contains the credit card OE10.2 OE10.3 type. If a credit card type and number OE10.4 OE10.5 are added to the customer file, they OE10.6 OE10.7 default to the order. If an order is OE10.8 OE11.1 fully paid with a credit card the OE11.4 OE11.8 invoice is passed to the Accounts OE11.9 OE110 Receivable system as fully paid and no OE113 OE114 invoice document is printed. OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CC-NUMBER Alpha 17 BL92.1 OE10.1 Credit Card Number This field contains the credit card OE10.2 OE10.3 number. This defaults from the customer OE10.4 OE10.5 file. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CC-EXP-DATE Numeric 6 BL92.1 OE10.1 Credit Card This field contains the credit card OE10.2 OE10.3 Expiration Date expiration date. This defaults from the OE10.4 OE10.5 customer's file. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CHECK-NBR Numeric 8 BL92.1 OE10.1 Payment Number This field contains the payment number. OE10.2 OE10.3 This is only valid with a down payment. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TERMS-CD Alpha 5 BL92.1 OE10.1 Terms Code This field contains the payment terms OE10.2 OE10.3 code. This defaults from the customer's OE10.4 OE10.5 file. Terms codes are set up in the OE10.6 OE10.7 Terms system. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BANK-INST-CODE Alpha 3 BL92.1 OE10.1 Transaction Code A transaction code represents a type of OE10.2 OE10.3 cash payment, bill of exchange payment, OE10.4 OE10.5 or bank service transaction. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-COD-FL Alpha 1 BL122 BL91.1 Cod Fl This field indicates if COD (Cash On BL92.1 OE10.1 Delivery) orders are accepted. This OE10.2 OE10.3 defaults to Yes if the terms code OE10.4 OE10.5 specifies COD orders. OE10.6 OE10.7 Y = Yes OE10.8 OE11.1 N = No OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CIA-FL Alpha 1 BL92.1 OE10.1 Cash In Advance Flag This field indicates that a down OE10.2 OE10.3 payment is needed for the order to be OE10.4 OE10.5 released. The required down payment OE10.6 OE10.7 amount is a percentage of the total OE10.8 OE11.1 order amount. OE11.4 OE11.8 Y = Yes OE11.9 OE110 N = No OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CIA-PCT Percent 8.5 (Percent) BL92.1 OE10.1 Cash In Advance This field contains the cash in advance OE10.2 OE10.3 Percent percentage, which is used to determine OE10.4 OE10.5 the down payment amount of the total OE10.6 OE10.7 order value. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ORD-DISC-CODE Alpha 4 BL92.1 OE10.1 Order Discount Code This field contains the order discount OE10.2 OE10.3 code. If left blank, this defaults from OE10.4 OE10.5 the customer's file. Discounts based on OE10.6 OE10.7 the total value of the order. OE10.8 OE11.1 Order Discount Codes are set up on OE11.4 OE11.8 OE59.1 (Order Discount Code). The order OE11.9 OE110 discount and any add-on discounts are OE113 OE114 printed on the invoices following the OE129 OE14.4 line items. OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PCT Percent 5.2 (Percent) BL92.1 OE10.1 Percent This field contains the order discount OE10.2 OE10.3 percent for which this order qualifies OE10.4 OE10.5 based on the total value of the order. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ENTERED-PMNT Signed 15.2 BL92.1 OE10.1 Entered Pmnt This field contains the down payment OE10.2 OE10.3 amount entered in the order's currency. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-PMNT Derived Mult Pmnt This field indicates what the base payment amount is if a multiplier is used when converting the payment from foreign to base currency. COR-DIV-PMNT Derived Div Pmnt This field indicates what the base payment amount is if a divider is used when converting the payment from foreign to company base currency. COR-PMNT-BASE Derived Pmnt Base This field contains the amount of the payment in the company base currency. COR-NET-DUE-CURR Derived Net Due Curr This field contains the total amount of the order minus the down payment valued in the order's original currency. COR-NET-DUE-BASE Derived Net Due Base This field contains the total amount in company base currency of the order minus the down payment. COR-PMNT-INVCED Signed 15.2 BL92.1 OE10.1 Pmnt Invced This field contains the amount of OE10.2 OE10.3 payment that has been printed on OE10.4 OE10.5 invoices for this order. Once the OE10.6 OE10.7 invoice has been printed, the payment OE10.8 OE11.1 amount cannot be changed below the OE11.4 OE11.8 original value. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ENTERED-DISC Signed 15.2 BL92.1 OE10.1 Entered Disc This field contains the additional OE10.2 OE10.3 discount amount entered on the order in OE10.4 OE10.5 the original currency in which the order OE10.6 OE10.7 was placed. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-DISC Derived Mult Disc This field contains the base discount amount if a multiplier is used in its conversion. COR-DIV-DISC Derived Div Disc This field contains the base discount amount if a divider is used in its conversion. COR-DISC-BASE Derived Disc Base This field contains the amount of the discount in the company's base currency. COR-DISC-TKN-CURR Signed 15.2 BL92.1 OE10.1 Disc Tkn Curr This field contains the amount of OE10.2 OE10.3 additional discount that has been taken OE10.4 OE10.5 on invoices for this order. This can be OE10.6 OE10.7 different from the total order discount OE10.8 OE11.1 if partial shipments are invoiced for OE11.4 OE11.8 the order. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-DISC-TKN Derived Mult Disc Tkn This field contains the amount of additional discounts for this order in base currency if a multiplier is used when converting the discount amount. COR-DIV-DISC-TKN Derived Div Disc Tkn This field contains the amount of the additional discount taken from the order in the base currency if a divider is used when converting the discount. COR-DISC-TKN-BASE Derived Disc Tkn Base This field contains the amount of the additional discount taken on invoices of the order in the company base currency. COR-TAX-CODE Alpha 10 BL92.1 OE10.1 Tax Code This field contains a code representing OE10.2 OE10.3 the tax authorities this ship-to pays OE10.4 OE10.5 sales tax to. This must be valid in the OE10.6 OE10.7 Tax Code file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TAX-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1 Tax Date This field contains the tax point date. OE10.2 OE10.3 This is only used if you are overriding OE10.4 OE10.5 the normal tax point date. This is the OE10.6 OE10.7 source of the invoice's tax point date OE10.8 OE11.1 only if this field is not equal to zero. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ORDER-SOURCE Alpha 2 BL92.1 OE10.1 Order Source This field contains the order source OE10.2 OE10.3 code that indicates the reason the OE10.4 OE10.5 customer gave for placing the order. OE10.6 OE10.7 Order source codes are set up in OE52.1 OE10.8 OE11.1 (Order Source). OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-FREIGHT-CODE Alpha 2 BL80.1 BL92.1 Freight Code This field contains the freight code, OE10.1 OE10.2 which determines if carrier and freight OE10.3 OE10.4 charges are assessed on the shipment. OE10.5 OE10.6 Freight codes are defined in BL12.1 OE10.7 OE10.8 (Freight Codes). A freight code can be OE11.1 OE11.4 added to the customer's file as a OE11.8 OE11.9 default, or it can be added at order OE110 OE113 entry time. OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 COR-FRT-CHG-CURR Signed 15.2 BL92.1 OE10.1 Frt Chg Curr This field contains the freight charge OE10.2 OE10.3 amount in billing currency. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.1 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5 OE810 OE920 OE966 OE999 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 COR-FRT-TAXABLE-FL Alpha 1 BL92.1 OE10.1 Frt Taxable Fl Select Yes if freight is taxable. OE10.2 OE10.3 Y = Yes OE10.4 OE10.5 N = No OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 WH20.7 COR-MULT-FRT-CHG Derived Mult Frt Chg This field contains the freight charge amount in the base currency if a multiplier is in the conversion from original to base currency. COR-DIV-FRT-CHG Derived Div Frt Chg This field contains the base amount of the freight charge if a divider is used in the conversion from original to base currency. COR-FRT-CHG-BASE Derived Frt Chg Base This field contains the freight charge amount in base currency. COR-CARRIER Alpha 9 BL92.1 OE10.1 Carrier Vendor This field contains the carrier vendor OE10.2 OE10.3 Number number. Vendors are set up in the OE10.4 OE10.5 Accounts Payable system. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-METHOD Alpha 10 BL92.1 OE10.1 Method Code User-defined shipping method. Shipping OE10.2 OE10.3 methods are set up in the Order Entry OE10.4 OE10.5 system. The shipping method will print OE10.6 OE10.7 on order acknowledgments, packing lists, OE10.8 OE11.1 and invoices. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-ID Alpha 10 BL92.1 OE10.1 Trans Id This field contains the transportation OE10.2 OE10.3 ID, which is a user-definable field form OE10.4 OE10.5 that prints on invoices and bills of OE10.6 OE10.7 lading. This field is not validated. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LIST-NAME Alpha 14 BL92.1 OE10.1 List Name This field contains the customer's OE10.2 OE10.3 price list. This defaults from the OE10.4 OE10.5 customer's price list when the order is OE10.6 OE10.7 entered. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PK-PRIORITY Numeric 2 BL92.1 OE10.1 Picking Priority This field contains the picking OE10.2 OE10.3 priority, which defaults from the OE10.4 OE10.5 customer's file. WH110 (Batch OE10.6 OE10.7 Allocation) uses this as a priority when OE10.8 OE11.1 assigning inventory to orders. OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-IMMEDIATE-FL Alpha 1 BL92.1 OE10.1 Immediate Order Flag This field indicates that this order OE10.2 OE10.3 should be delivered on the next run of OE10.4 OE10.5 route construction regardless of the OE10.6 OE10.7 routes being delivered today. OE10.8 OE11.1 Y = Yes OE11.4 OE11.8 N = No OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-EDI-OE-FLAG Alpha 1 BL92.1 OE10.1 Edi OE Flag This field contains the EDI flag, which OE10.2 OE10.3 is set on if this order was created by OE10.4 OE10.5 the EDI interface. OE10.6 OE10.7 N = No OE10.8 OE11.1 Y = Yes OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ACKNWLDG-FL Alpha 1 BL92.1 OE10.1 Acknowledgment This field indicates whether a printed OE10.2 OE10.3 Required Flag acknowledgment is required for this OE10.4 OE10.5 order. This defaults from the customer's OE10.6 OE10.7 file. OE10.8 OE11.1 N = No OE11.4 OE11.8 Y = Yes OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-ACK-PRT-FL Alpha 1 BL92.1 OE10.1 Acknowledgment This field indicates if an OE10.2 OE10.3 Printed Flag acknowledgment was printed to avoid OE10.4 OE10.5 duplicate printing of the document. OE10.6 OE10.7 N = No OE10.8 OE11.1 Y = Yes OE11.4 OE11.8 OE11.9 OE110 OE112 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-BACK-ORD-FL Alpha 1 BL92.1 OE10.1 Backorders Allowed This field indicates if backorders are OE10.2 OE10.3 Flag allowed. If No, an order cannot be OE10.4 OE10.5 placed for items that do not have OE10.6 OE10.7 sufficient stock to be allocated to OE10.8 OE11.1 them. This is only valid for companies OE11.4 OE11.8 that use online allocation. This OE11.9 OE110 defaults from the customer's file. OE113 OE114 N = No OE129 OE14.4 Y = Yes OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIP-COMP-FL Alpha 1 BL92.1 OE10.1 Ship Comp Fl This field indicates whether partial OE10.2 OE10.3 shipments are allowed. This defaults OE10.4 OE10.5 from the customer's file. OE10.6 OE10.7 N = No OE10.8 OE11.1 Y = Yes OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CREDIT-WF-FL Alpha 1 BL92.1 OE10.1 Credit WF Fl This field indicates that this order on OE10.2 OE10.3 hold has passed to the Workflow OE10.4 OE10.5 Management system. OE10.6 OE10.7 Y = Yes OE10.8 OE11.1 N = No OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 COR-ACTIVITY Alpha 15 BL92.1 OE10.1 Activity In this file the Activity field is used OE10.2 OE10.3 for revenue (sales) postings whereas the OE10.4 OE10.5 Activity-C field is used for Cost (COGS) OE10.6 OE10.7 postings. OE10.8 OE11.1 OE11.4 OE11.8 Activities are the processes or OE11.9 OE110 procedures that produce work. Cost OE113 OE114 objects (products, services, customers, OE129 OE14.4 and so on) are the reasons for OE15.1 OE15.2 performing the activity. Activities and OE15.3 OE15.4 cost object activities are used OE15.5 OE15.7 synonymously in the Activity Management OE510 OE810 system. Direct costs are posted to OE920 OE966 activities, and indirect costs are WH20.7 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. COR-ACCT-CATEGORY Alpha 5 BL92.1 OE10.1 Account Category In this file the Acct-Category field is OE10.2 OE10.3 used for revenue (sales) postings OE10.4 OE10.5 whereas the Acct-Categ-C field is used OE10.6 OE10.7 for Cost (COGS) postings. OE10.8 OE11.1 OE11.4 OE11.8 Account categories are groupings of OE11.9 OE110 costs, revenues, or a combination of OE113 OE114 both used for reporting and inquiries OE129 OE14.4 for activities in the Activity OE15.1 OE15.2 Management system. All transactions are OE15.3 OE15.4 posted to an account category within an OE15.5 OE15.7 activity. You can assign a specific OE510 OE810 general ledger account or range of OE920 OE966 accounts (company, accounting unit, WH20.7 account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. COR-USER-DATE-1 Numeric 8 (yyyymmdd) BL92.1 OE10.1 User Date 1 This field contains the first OE10.2 OE10.3 user-definable date. This is used by OE10.4 OE10.5 OE280 (Open Orders By Customer). OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-USER-DATE-2 Numeric 8 (yyyymmdd) BL92.1 OE10.1 User Date 2 This field contains the second OE10.2 OE10.3 user-definable date. This is used by OE10.4 OE10.5 OE280 (Open Orders By Customer). OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-USER1 Alpha 10 BL92.1 OE10.1 Trans User 1 This field contains the first OE10.2 OE10.3 user-definable transaction field. This OE10.4 OE10.5 field can be used in the Accounts OE10.6 OE10.7 Receivable system as a sort option OE10.8 OE11.1 during cash application and select OE11.4 OE11.8 criteria for the aged trial balance. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-USER2 Alpha 15 BL92.1 OE10.1 Trans User 2 This field contains the second OE10.2 OE10.3 user-definable transaction field. This OE10.4 OE10.5 updates on the invoice in the Accounts OE10.6 OE10.7 Receivable system file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-USER3 Numeric 8 (yyyymmdd) BL92.1 OE10.1 Trans User 3 This field contains the third OE10.2 OE10.3 user-definable transaction field. This OE10.4 OE10.5 updates on the invoice in the Accounts OE10.6 OE10.7 Receivable system file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-USER4 Numeric 9 BL92.1 OE10.1 Trans User 4 This field contains the fourth OE10.2 OE10.3 user-definable transaction field. This OE10.4 OE10.5 updates on the invoice in the Accounts OE10.6 OE10.7 Receivable system file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-TRANS-USER5 Signed 13.2 BL92.1 OE10.1 Trans User 5 This field contains the fifth OE10.2 OE10.3 user-definable transaction field. This OE10.4 OE10.5 updates on the invoice in the Accounts OE10.6 OE10.7 Receivable system file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CUBIC-FEET Signed 9.3 BL92.1 OE10.1 Cubic Feet This field contains the total cubic OE10.2 OE10.3 feet of the items comprising this order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-WEIGHT Signed 9.3 BL92.1 OE10.1 Unit Weight This field contains the total weight of OE10.2 OE10.3 this order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LAST-LINE-NBR Numeric 6 BL92.1 OE10.1 Last Line Number This field contains the number of the OE10.2 OE10.3 last line item added to the order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LAST-TP-SEQ Numeric 3 BL92.1 OE10.1 Last Top Comment This field contains the last sequence OE10.2 OE10.3 Sequence number used for top comments. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.2 OE11.3 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LAST-BM-SEQ Numeric 3 BL92.1 OE10.1 Last Bottom Comment This field contains the last sequence OE10.2 OE10.3 Sequence number used for bottom comments. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.2 OE11.3 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-LAST-MISC-SEQ Numeric 3 BL92.1 OE10.1 Last Misc Code This field contains the last sequence OE10.2 OE10.3 Sequence number used for add-on charges. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SHIPMENT-NBR Numeric 10 BL92.1 OE10.1 Shipment Number This field contains the last shipment OE10.2 OE10.3 number used for this order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH130 WH132 WH190 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 WH966 COR-LST-IF-REF-NBR Numeric 6 BL92.1 OE10.1 Lst If Ref Nbr This field contains an internally OE10.2 OE10.3 generated reference number used by the OE10.4 OE10.5 Requisitions system. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 WH20.7 COR-SLS-QUOTE-FL Alpha 1 BL92.1 OE10.1 Sales Quote Flag This field indicates if the order is a OE10.2 OE10.3 quote. Quotes cannot be released and OE10.4 OE10.5 have no effect on inventory. They can be OE10.6 OE10.7 changed to regular orders and OE10.8 OE11.1 subsequently processed. OE11.4 OE11.8 Y = Yes OE11.9 OE110 N = No OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-FUTURE-FL Alpha 1 BL92.1 OE10.1 Future Order Flag This field contains the future flag, OE10.2 OE10.3 which defaults to No. If set to Yes, OE10.4 OE10.5 future lines do not have inventory OE10.6 OE10.7 allocated to them until it is necessary OE10.8 OE11.1 to meet the customer's requested OE11.4 OE11.8 delivery date. OE11.9 OE110 N = No OE113 OE114 Y = Yes OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PK-PRT-FL Alpha 1 BL92.1 OE10.1 Picking List This field indicates whether a picking OE10.2 OE10.3 Printed Flag list has been printed for this order. OE10.4 OE10.5 N = No OE10.6 OE10.7 Y = Yes OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-POD-REQ-FL Alpha 1 BL92.1 OE10.1 Pod Req Fl This field indicates that a POD (Proof OE10.2 OE10.3 of Delivery) is required. Indicates OE10.4 OE10.5 whether this customer's ship-to requires OE10.6 OE10.7 a POD form to accompany the shipment. OE10.8 OE11.1 The shipment is not billed until the POD OE11.4 OE11.8 is returned or the POD grace period OE11.9 OE110 expires. OE113 OE114 N = No OE129 OE14.4 Y = Yes OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-POD-GRACE-PER Numeric 3 BL92.1 OE10.1 Pod Grace Per This field contains the number of days OE10.2 OE10.3 from the shipment date after which POD OE10.4 OE10.5 shipments are automatically billed even OE10.6 OE10.7 if the POD is not returned. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CXL-DATE Numeric 8 (yyyymmdd) BL92.1 OE10.1 Cancel Date This field contains the date the order OE10.2 OE10.3 was canceled. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CXL-OPR Alpha 10 (Lower Case) BL92.1 OE10.1 Cancel Operator This field contains the user ID of the OE10.2 OE10.3 person who canceled the order. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CXL-REASON Alpha 4 BL92.1 OE10.1 Cancel Reason This field contains the cancellation OE10.2 OE10.3 reason code. This is passed to the Sales OE10.4 OE10.5 Analysis system for reporting. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-SA-UPDATED-FL Alpha 1 BL92.1 OE10.1 Sa-Updated Fl This field indicates if this order has OE10.2 OE10.3 been booked in the Sales Analysis OE10.4 OE10.5 system. OE10.6 OE10.7 Y = Yes OE10.8 OE11.1 N = No OE11.4 OE11.8 C = Change OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 SA100 SA101 WH20.7 COR-CURRENCY-CODE Alpha 5 BL92.1 OE10.1 Currency Code This field contains the currency the OE10.2 OE10.3 customer is to be billed in for this OE10.4 OE10.5 order. This defaults from the customer's OE10.6 OE10.7 file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CURR-MUDV Alpha 1 BL92.1 OE10.1 Currency This field indicates whether the OE10.2 OE10.3 Multiply/Divide conversion from base to the billing OE10.4 OE10.5 currency is accomplished using a OE10.6 OE10.7 multiplier or divider. OE10.8 OE11.1 M = Multiply OE11.4 OE11.8 D = Divide OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CURR-RATE Signed 13.6 BL92.1 OE10.1 Currency Rate This field contains the currency OE10.2 OE10.3 conversion rate to base currency. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CURR-ND Numeric 1 BL92.1 OE10.1 Currency Number of This field contains the number of OE10.2 OE10.3 Decimals decimals for the billing currency. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-CURR-OVR-FL Alpha 1 OE966 OE999 Curr Ovr Fl This field indicates whether you can override the currency for transactions on the customer's account. Y = Yes N = No COR-RATE-FRZ-CD Alpha 1 BL92.1 OE10.1 Rate Frz-Cd This field contains the code indicating OE10.2 OE10.3 when the currency conversion rate is OE10.4 OE10.5 frozen for this order. OE10.6 OE10.7 O = Order OE10.8 OE11.1 I = Invoice OE11.4 OE11.8 P = Payment OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-OPEN-ORD-AMT Signed 15.2 BL92.1 OE10.1 Open Ord Amt This field contains the total amount of OE10.2 OE10.3 the open order added to the customer's OE10.4 OE10.5 open order total from the customer's OE10.6 OE10.7 file. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-PASS-ORD-AMT Signed 15.2 BL92.1 OE10.1 Pass Ord Amt This field contains the amount of the OE10.2 OE10.3 open order that was subtracted from the OE10.4 OE10.5 customer's open order total by invoices OE10.6 OE10.7 that have been created for this order. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-INV-GDS-CURR Signed 15.2 BL92.1 OE10.1 Inv Gds Curr This field contains the amount of OE10.2 OE10.3 inventoried goods for this order in OE10.4 OE10.5 billing currency. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-INV-GDS-BASE Signed 15.2 BL92.1 OE10.1 Inv Gds Base This field contains the amount of OE10.2 OE10.3 inventoried goods for this order in base OE10.4 OE10.5 currency. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-NI-GDS-CURR Signed 15.2 BL92.1 OE10.1 Ni Gds Curr This field contains the amount of OE10.2 OE10.3 non-inventoried goods for this order in OE10.4 OE10.5 billing currency. These could be either OE10.6 OE10.7 nonstock or special items. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-NI-GDS-BASE Signed 15.2 BL92.1 OE10.1 Ni Gds Base This field contains the amount of OE10.2 OE10.3 non-inventoried goods for this order in OE10.4 OE10.5 base currency. These can be either OE10.6 OE10.7 nonstock or special items. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-GDS-TTL-CURR Derived Gds Ttl Curr This field contains the total goods amount for this order in billing currency. COR-GDS-TTL-BASE Derived Gds Ttl Base This field contains the total goods amount for this order in base currency. COR-MISC-TTL-CURR Signed 15.2 BL92.1 OE10.1 Misc Ttl Curr This field contains the total of add-on OE10.2 OE10.3 charges for this order in billing OE10.4 OE10.5 currency. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-MISC-TTL Derived Mult Misc Ttl This field contains the total of add-on charges in base currency if a multiplier is used in the conversion from original to base amount. COR-DIV-MISC-TTL Derived Div Misc Ttl This field contains the total amount of add-on charges in base currency if a divider is used in the conversion from original to base currency. COR-MISC-TTL-BASE Derived Misc Ttl Base This field contains the total amount of add-on charges in base currency. COR-DISCNTBL-CURR Signed 15.2 BL92.1 OE10.1 Discntbl Curr This field contains the total OE10.2 OE10.3 discountable amount for this order in OE10.4 OE10.5 billing currency. This amount is used to OE10.6 OE10.7 compute the order discount amount. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-DISCNTBL Derived Mult Discntbl This field contains the total discountable amount for this order in base currency if the conversion from original to base currency is accomplished using a multiplier. COR-DIV-DISCNTBL Derived Div Discntbl This field contains the total discountable amount of the order in base currency if a divider is used in the conversion from original to base currency. COR-DISCNTBL-BASE Derived Discntbl Base This field contains the total discountable amount of the order in base currency. COR-ORD-DISC-CURR Signed 15.2 BL92.1 OE10.1 Ord Disc Curr This field contains the discount for OE10.2 OE10.3 this order in billing currency. Order OE10.4 OE10.5 discounts are calculated using the OE10.6 OE10.7 discount codes set up on OE59.1 (Order OE10.8 OE11.1 Discount Code) that are assigned to the OE11.4 OE11.8 customer's record. OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-ORD-DISC Derived Mult Ord Disc This field contains the order discount for this order in base currency if a multiplier is used in the conversion from original to base currency. COR-DIV-ORD-DISC Derived Div Ord Disc This field contains the total order discount amount for this order if a divider is used in the conversion from original to base currency. COR-ORD-DISC-BASE Derived Ord Disc Base This field contains the total amount of the order discount in the company base currency. COR-TXBL-TTL-CURR Signed 15.2 BL92.1 OE10.1 Txbl Ttl Curr This field contains the taxable amount OE10.2 OE10.3 for this order in billing currency. OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-TXBL-TTL Derived Mult Txbl Ttl This field contains the taxable amount for this order in base currency if a multiplier is used in the conversion from original to base currency. COR-DIV-TXBL-TTL Derived Div Txbl Ttl This field contains the taxable amount for this order in base currency if a divider is used in the conversion from original to base currency. COR-TXBL-TTL-BASE Derived Txbl Ttl Base This field contains the taxable amount for this order in the company base currency. COR-TAX-TTL-CURR Signed 15.2 BL92.1 OE10.1 Tax Ttl Curr This field contains the total amount of OE10.2 OE10.3 tax on the order in original billing OE10.4 OE10.5 currency. OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 OE966 OE999 WH20.7 COR-MULT-TAX-TTL Derived Mult Tax Ttl This field contains the total amount of tax on the order in base currency if a multiplier is used in the conversion from original to base currency. COR-DIV-TAX-TTL Derived Div Tax Ttl This field contains the total amount of tax on the order in base currency if a divider is used in the conversion from original to base currency. COR-TAX-TTL-BASE Derived Tax Ttl Base This field contains the total amount of tax on the order in base currency. COR-ORD-GRS-BASE Derived Ord Grs Base This field contains the total gross amount of the order in base currency. COR-ORD-GRS-CURR Derived Ord Grs Curr This field contains the total gross amount of the order in original billing currency. COR-ORDER-NET Derived Order Net This field contains the total of line net amounts plus add-on charges minus order discounts. COR-ORD-NET-BASE Derived Ord Net Base This field contains the total of line net amounts and add-on charges minus order discounts in base currency. COR-ORD-NET-CURR Derived Ord Net Curr This field contains the net order, which is the total of line net amounts and add-on charges minus the order discount in the order's original currency. COR-HOLD-LIT Derived Hold Lit This field contains the hold code. COR-CCTERMS-2 Derived Ccterms 2 This field indicates whether credit card terms apply or not. COR-TERMS-1 Derived Terms 1 This field contains the description of the first credit card terms table. COR-TERM-2 Derived Term 2 This field contains the description of the second credit card terms table. COR-ORDER-NBR-A Derived Order Nbr A This field is used internally to create relationships. COR-ORDER-ZERO Derived Order Zero This field is used internally to create relationships COR-COMM-LIT Derived Comm Lit If comments are attached, this field displays "comments exist." COR-ACTIVITY-C Alpha 15 BL92.1 OE10.1 Activity for Cst of In this file the Activity-C field is OE10.2 OE10.3 Goods Sold used for Cost (COGS) postings whereas OE10.4 OE10.5 the Activity field is used for revenue OE10.6 OE10.7 (sales) postings. OE10.8 OE11.1 OE11.4 OE11.8 Activities are the processes or OE11.9 OE110 procedures that produce work. Cost OE113 OE114 objects (products, services, customers, OE129 OE14.4 and so on) are the reasons for OE15.1 OE15.2 performing the activity. Activities and OE15.3 OE15.4 cost object activities are used OE15.5 OE15.7 synonymously in the Activity Management OE510 OE810 system. Direct costs are posted to OE920 WH20.7 activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries. COR-ACCT-CATEG-C Alpha 5 BL92.1 OE10.1 Acct Categ (Cst of In this file the Acct-Categ-C field is OE10.2 OE10.3 Goods Sold) used for Cost (COGS) postings whereas OE10.4 OE10.5 the Acct-Category field is used for OE10.6 OE10.7 revenue (sales) postings. OE10.8 OE11.1 OE11.4 OE11.8 Account categories are groupings of OE11.9 OE110 costs, revenues, or a combination of OE113 OE114 both used for reporting and inquiries OE129 OE14.4 for activities in the Activity OE15.1 OE15.2 Management system. All transactions are OE15.3 OE15.4 posted to an account category within an OE15.5 OE15.7 activity. You can assign a specific OE510 OE810 general ledger account or range of OE920 WH20.7 accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. COR-INTRASTAT-NBR Numeric 10 BL92.1 OE10.1 Intrastat Number The number assigned by the Intrastat OE10.2 OE10.3 system to a transaction that involves OE10.4 OE10.5 Intrastat reporting after it has been OE10.6 OE10.7 added. OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COR-BILL-CNTRY-CD Alpha 2 BL92.1 OE10.1 Bill To Country Code The Bill-To country code. Must be OE10.2 OE10.3 defined in IN01.1 (Country Maintenance). OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COR-BILL-REGION Alpha 2 BL92.1 OE10.1 Bill To Region The Bill-To Region Code. Must be defined OE10.2 OE10.3 in IN02.1 (Region Maintenance). OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COR-TO-CNTRY-CD Alpha 2 BL92.1 OE10.1 Ship To Country Code The Ship-To country Code. Must be OE10.2 OE10.3 defined in IN01.1 (Country Maintenance). OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COR-SHIP-TO-REGION Alpha 2 BL92.1 OE10.1 Ship To Region The ship-to region code. OE10.2 OE10.3 Must be defined in IN02.1 (Region OE10.4 OE10.5 Maintenance). OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510 OE810 OE920 WH20.7 COR-WF-CO-ORDR-NBR Derived Wf Co Ordr Nbr The Workflow order number. CUSTORDER FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN CORSET1 COMPANY BL00.1 BL120 ORDER-NBR BL122 BL123 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL291 BL520 BL720 BL80.1 BL820 BL91.1 BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.2 OE11.3 ... CORSET10 COMPANY Subset SA100 ORDER-NBR Where SA-UPDATED-FL != "Y" And STATUS > 1 CORSET2 COMPANY AR08.1 AR10.1 CUSTOMER AR501 AR550 ORDER-NBR OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112 OE113 OE114 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE291 OE292 OE510 ... CORSET3 COMPANY KeyChange OE80.6 CUST-PO-NBR ORDER-NBR CORSET5 COMPANY OE110 OE53.1 OPR-CODE OE80.4 ORDER-NBR CORSET6 COMPANY KeyChange, Subset AR115 AR124 CUSTOMER Where HOLD-CODE != Spaces AR20.1 AR21.1 HOLD-CODE AR21.2 AR21.3 ORDER-NBR AR24.1 AR30.1 AR30.2 AR30.4 AR570 AR575 AR580 CB191 OE90.1 CORSET7 COMPANY KeyChange OE286 HOLD-CODE ORDER-NBR CORSET8 COMPANY KeyChange OE110 OE283 ORDER-DATE OE310 OE80.5 ORDER-NBR CORSET9 COMPANY KeyChange TRANS-USER1 ORDER-NBR CUSTORDER FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Apcompany APCOMPANY Required When COR-CARRIER != Spaces COR-COMPANY -> CPY-COMPANY Apvenmast APVENMAST Required When COR-CARRIER != Spaces CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP COR-CARRIER -> VEN-VENDOR Arcomp ARCOMP Required COR-COMPANY -> ACO-COMPANY Arcustomer ARCUSTOMER Required COR-COMPANY -> ACM-COMPANY COR-CUSTOMER -> ACM-CUSTOMER Billto BILLTO Not Required Valid When COR-BILL-TO != Zeroes ACO-CUST-GROUP -> ABS-CUST-GROUP COR-CUSTOMER -> ABS-CUSTOMER COR-BILL-TO -> ABS-BILL-TO Cosgblk COSGBLK Not Required COR-COMPANY -> OSG-COMPANY COR-ORDER-NBR -> OSG-ORDER-NBR Zeroes -> OSG-LINE-NBR Zeroes -> OSG-SEQ Cucodes CUCODES Required When COR-CURRENCY-CODE != COR-CURRENCY-CODE COR-CURRENCY-CODE -> CUC-CURRENCY-CODE Curelat CURELAT Not Required 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 COR-CUSTOMER -> CUD-CUSTOMER Cxl Operator OPERATOR Not Required Valid When COR-CXL-REASON != Spaces COR-CXL-OPR -> OPE-OPR-CODE Glsystem GLSYSTEM Required COR-COMPANY -> GLS-COMPANY Holdcodes HOLDCODES Required When COR-HOLD-CODE != Spaces ACO-CUST-GROUP -> HDD-CUST-GROUP COR-HOLD-CODE -> HDD-HOLD-CODE Iccompany ICCOMPANY Required COR-COMPANY -> ICC-COMPANY Iclocation ICLOCATION Required When COR-INV-LOCATION != Spaces COR-COMPANY -> ICL-COMPANY COR-INV-LOCATION -> ICL-LOCATION Oecompany OECOMPANY Required COR-COMPANY -> OEC-COMPANY Oecredcard OECREDCARD Required When COR-CC-TYPE != Spaces COR-COMPANY -> OCR-COMPANY COR-CC-TYPE -> OCR-CC-TYPE Oecust OECUST Required COR-COMPANY -> OET-COMPANY COR-CUSTOMER -> OET-CUSTOMER Oefrtcode OEFRTCODE Required When COR-FREIGHT-CODE != Spaces COR-COMPANY -> OFR-COMPANY COR-FREIGHT-CODE -> OFR-FRT-CODE Oemethod OEMETHOD Required When COR-METHOD != Spaces COR-COMPANY -> OMT-COMPANY COR-METHOD -> OMT-METHOD Oeorddisc OEORDDISC Required When COR-ORD-DISC-CODE > Spaces COR-COMPANY -> OOD-COMPANY COR-ORD-DISC-CODE -> OOD-ORD-DISC-CODE COR-CURRENCY-CODE -> OOD-CURRENCY-CODE Oeprclist OEPRCLIST Required COR-COMPANY -> OPL-COMPANY Spaces -> OPL-CUSTOMER COR-LIST-NAME -> OPL-LIST-NAME Spaces -> OPL-PROMOTION Oeproclev OEPROCLEV Required COR-COMPANY -> OEP-COMPANY COR-PROCESS-LEVEL -> OEP-PROCESS-LEVEL Oereason OEREASON Required When COR-CXL-REASON != Spaces COR-COMPANY -> OER-COMPANY COR-CXL-REASON -> OER-REASON-CODE Oesource OESOURCE Required When COR-ORDER-SOURCE != Spaces COR-COMPANY -> OSR-COMPANY COR-ORDER-SOURCE -> OSR-ORDER-SOURCE Operator OPERATOR Required COR-COMPANY -> OPE-DEF-COMPANY COR-OPR-CODE -> OPE-OPR-CODE Ordertype ORDERTYPE Required COR-COMPANY -> OTP-COMPANY COR-ORDER-TYPE -> OTP-ORDER-TYPE Salesman SALESREP Required COR-COMPANY -> SAW-COMPANY COR-SALESMAN -> SAW-SALESMAN Salesman2 SALESREP Required When COR-SALESMAN-2 != Zeroes COR-COMPANY -> SAW-COMPANY COR-SALESMAN-2 -> SAW-SALESMAN Shipto SHIPTO Required When COR-SHIP-TO != Zeroes COR-COMPANY -> SHP-COMPANY COR-CUSTOMER -> SHP-CUSTOMER COR-SHIP-TO -> SHP-SHIP-TO Teritory TERITORY Required When COR-TERRITORY != Spaces COR-COMPANY -> TRY-COMPANY COR-TERRITORY -> TRY-TERRITORY Terms TERMS Not Required COR-TERMS-CD -> TMS-TERMS-CD Txtaxcode TXTAXCODE Required When COR-TAX-CODE != Spaces COR-COMPANY -> TAC-COMPANY COR-TAX-CODE -> TAC-TAX-CODE Whdemndhdr WHDEMNDHDR Not Required COR-COMPANY -> WDH-COMPANY "OE" -> WDH-SYSTEM-CD COR-ORDER-NBR -> WDH-DOC-NBR-NUM CUSTORDER FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH All Comisc COMISC COR-COMPANY -> CMC-COMPANY COR-ORDER-NBR -> CMC-ORDER-NBR CMC-LINE-NBR CMC-SEQ Coline COLINE Delete Restricted COR-COMPANY -> COL-COMPANY COR-ORDER-NBR -> COL-ORDER-NBR COL-LINE-NBR Comisc COMISC COR-COMPANY -> CMC-COMPANY COR-ORDER-NBR -> CMC-ORDER-NBR Zeroes -> CMC-LINE-NBR CMC-SEQ Custorder CUSTORDER COR-COMPANY -> COR-COMPANY COR-CUSTOMER -> COR-CUSTOMER COR-ORDER-NBR Hdr Comments OEORDCMNT COR-COMPANY -> OOC-COMPANY Spaces -> OOC-CUSTOMER Spaces -> OOC-STD-ORDER-NBR COR-ORDER-NBR -> OOC-ORDER-NBR Zeroes -> OOC-LINE-NBR OOC-SEQ Icgeneric ICGENERIC ICC-ITEM-GROUP -> ICG-ITEM-GROUP ICG-GENERIC Majorcl MAJORCL ICC-ITEM-GROUP -> MAJ-ITEM-GROUP "S" -> MAJ-CLASS-TYPE MAJ-MAJOR-CLASS Minorcl MINORCL ICC-ITEM-GROUP -> MIN-ITEM-GROUP "S" -> MIN-CLASS-TYPE MIN-MAJOR-CLASS MIN-MINOR-CLASS Oeaudit OEAUDIT Delete Cascades COR-COMPANY -> OEA-COMPANY COR-ORDER-NBR -> OEA-ORDER-NBR Zeroes -> OEA-LINE-NBR OEA-FLD-NBR OEA-UPDATE-DATE OEA-UPDATE-TIME Oediscount OEDISCOUNT COR-COMPANY -> OED-COMPANY OED-DISC-CODE Oeinvoice OEINVOICE Delete Restricted COR-COMPANY -> OEI-COMPANY COR-ORDER-NBR -> OEI-ORDER-NBR OEI-SHIPMENT-NBR OEI-INVC-PREFIX OEI-INVC-NUMBER Oeorddisc2 OEORDDISC COR-COMPANY -> OOD-COMPANY OOD-ORD-DISC-CODE OOD-CURRENCY-CODE Oestdline OESTDLINE COR-COMPANY -> OSL-COMPANY OSL-CUSTOMER OSL-STD-ORDER-NBR OSL-LINE-NBR Oestdorder OESTDORDER COR-COMPANY -> OSO-COMPANY COR-CUSTOMER -> OSO-CUSTOMER OSO-STD-ORDER-NBR Trl Comments OEORDCMNT COR-COMPANY -> OOC-COMPANY Spaces -> OOC-CUSTOMER Spaces -> OOC-STD-ORDER-NBR COR-ORDER-NBR -> OOC-ORDER-NBR 999999 -> OOC-LINE-NBR OOC-SEQ Wfhiswkuni WFHISWKUNI "CORSET1 " -> WFI-OBJECT-NAME COR-WF-CO-ORDR-NBR -> WFI-KEY-STRING WFI-WORKUNIT Wfworkunit WFWORKUNIT "CORSET1 " -> WFW-OBJECT-NAME COR-WF-CO-ORDR-NBR -> WFW-KEY-STRING WFW-WORKUNIT Whshipment WHSHIPMENT COR-COMPANY -> WHS-COMPANY "O" -> WHS-SYSTEM-CD WDH-DOC-NBR -> WHS-DOC-NBR WHS-SHIPMENT-NBR WHS-LOCATION |