OEFRTCODE FILE
Order Entry Freight Code
This file contains freight codes that can be used in the Lawson Order Entry
system. Freight codes are set up in BL12.1 (Freight Codes).
REFERENCED BY
AR08.1 AR10.1 AR501 AR550 BL120 BL122
BL123 BL130 BL20.1 BL20.3 BL202 BL21.2
BL21.5 BL212 BL29.1 BL29.2 BL290 BL520
BL80.1 BL802 BL820 BL902 BL940 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC141 IC142
IC83.1 OE112 OE286 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE830
OE90.1 OE950 PO31.1 RQ10.1 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ35.1 RQ500 RQ961
WH130 WH132 WH190 WH222 WH224 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO120 WO132 WO140 WO20.1 WO30.1 WO32.1
WO40.1 WO40.2 WO40.3 WO40.4 WO40.5 WO41.1
WO41.2 WO41.3 WO41.4 WO42.1 WO42.2 WO42.3
WO42.4 WO42.5 WO45.1 WOEX.1 WOSP.1
UPDATED BY
BL02.1 BL12.1 BL92.1 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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE510 OE810 OE920 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OFR-COMPANY Numeric 4 BL12.1
Company The company number represents an
established company and is entered on
all function codes.
OFR-FRT-CODE Alpha 2 BL12.1
Freight Code The freight code, which is a
user-defined, two-character value that
identifies the general ledger freight
account that is credited. You can use
AR10.1 (Customer) to default the freight
code to the customer's file.
OFR-FRT-DESC Alpha 20 (Lower Case) BL02.1 BL12.1
Freight Code This field contains the description of BL122 BL80.1
Description the freight code that prints on invoices OE112 OE114
where freight is assessed. OE286
OFR-FRT-CARR-CD Alpha 1 BL12.1
Frt Carr Cd This field indicates if the entry of
freight codes on an order also requires
the entry of a carrier. Valid carriers
must be set up as vendors in the
Accounts Payable system.
N = Not Allowed
O = Optional
R = Required
OFR-FRT-CHRG-CD Alpha 1 BL12.1 BL92.1
Frt Chrg Cd This field indicates if freight charges CX100 CX20.1
are optional, required, or not allowed CX20.2 CX20.4
when this freight code has been entered CX20.5 CX220
on an order. CX30.1 CX300
N = Not Allowed CX506 CXCP.1
O = Optional DR100 IC141
R = Required IC142 IC83.1
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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE810 OE830
OE90.1 OE920
OE950 PO31.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ20.1
...
OFR-AOC-CODE Alpha 2 BL12.1
Add On Cost Code This field contains the purchase order
add-on cost code to be used if an order
line is causing a purchase order to be
created. Purchase order add-on cost
codes are added and updated in the
Invoice Matching system.
OFR-FRT-ACCT-UNIT Alpha 15 BL12.1 BL92.1
Default Freight The account unit used for posting the OE10.1 OE10.2
Acct. Unit credit side of the freight transaction. 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
WH20.2 WH20.7
OFR-FRT-ACCOUNT Numeric 6 BL12.1 BL92.1
Default Freight The account number used for posting the OE10.1 OE10.2
Account credit side of the freight transaction. 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
WH20.2 WH20.7
OFR-FRT-SUB-ACCT Numeric 4 BL12.1 BL92.1
Default Freight Sub The subaccount number used for posting OE10.1 OE10.2
Account the credit side of the freight OE10.3 OE10.4
transaction. 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.2 WH20.7
OFR-FRT-USED-FL Alpha 1 BL02.1 BL212
Freight Code Used Freight code used flag. If the freight BL92.1 OE10.1
Flag code has ever been used, this flag will OE10.2 OE10.3
be set to Yes. OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
N = No 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
OFR-FRT-ACT-FL Alpha 1 BL12.1
Freight Code Active Only freight codes that have not been
Flag previously assigned to orders (In use =
No) can be deleted. To prevent future
use of a used freight code, make it
inactive by selecting Inactive in this
field.
A = Active
I = Inactive
OEFRTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OFRSET1 COMPANY AR08.1 AR10.1
FRT-CODE AR501 AR550
BL02.1 BL12.1
BL120 BL122
BL123 BL130
BL20.1 BL20.3
BL202 BL21.2
BL21.5 BL212
BL29.1 BL29.2
BL290 BL520
BL80.1 BL802
BL820 BL902
BL92.1 BL940
CX100 CX20.1
CX20.2 CX20.4
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|