Lawson Insight Technical Documentation |
|
OEFRTCODE
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR08.1 AR10.1 AR501 AR550
BL123 BL202 BL212 BL290 BL80.1 BL802
CXCP.1 IC28.1 IC83.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE112 OE116 OE286 OE81.1 OE90.1 OE90.2
PO100 PO101 PO122 PO131 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 POI3.1
POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH222 WH224 WH25.1 WH25.2
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 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 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 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 OE111 OE113 OE114
OE129 OE13.2 OE13.3 OE13.5 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE810 OE830 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OFR-COMPANY Numeric 4 BL12.1
Element: Company 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.
OFR-FRT-CODE Alpha 2 BL12.1
Element: Add On Cost CoThe 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
Element: 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 AP125 AP126
Element: Frt Chrg Cd This field indicates if freight charges AP131 AP25.1
are optional, required, or not allowed AP25.2 AP26.1
when this freight code has been entered AP27.1 AP30.4
on an order. BL12.1 BL120
N = Not Allowed BL122 BL130
O = Optional BL20.1 BL20.3
R = Required BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
IC28.1 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 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
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
...
OFR-AOC-CODE Alpha 2 BL12.1
Element: Add On Cost CoThis 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
Element: Accounting UniThe account unit used for posting the
credit side of the freight transaction.
OFR-FRT-ACCOUNT Numeric 6 BL12.1
Element: Account The account number used for posting the
credit side of the freight transaction.
OFR-FRT-SUB-ACCT Numeric 4 BL12.1
Element: Subaccount The subaccount number used for posting
the credit side of the freight
transaction.
OFR-FRT-USED-FL Alpha 1 BL02.1 BL120
Element: All Flag Freight code used flag. If the freight BL122 BL130
code has ever been used, this flag will BL20.1 BL20.3
be set to Yes. BL21.2 BL21.5
Y = Yes BL212 BL29.1
N = No BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE129 OE13.2
OE13.3 OE13.5
OE14.4 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE510
OE530 OE810
OE830 WH20.7
OFR-FRT-ACT-FL Alpha 1 BL12.1
Element: Status Only freight codes that have not been
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 AP125 AP126
FRT-CODE AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR08.1 AR10.1
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
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|