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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 AR08.1
AR10.1 AR120 AR501 AR550 BL123 BL202
BL212 BL290 BL80.1 BL802 CXCP.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO190
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.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
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 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: Aoc 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
Customer (AR10.1) to default the freight
code to the customer's file.
OFR-FRT-DESC Alpha 20 (Lower Case) BL02.1 BL12.1
Element: Frt Desc This field contains the description of BL122 BL80.1
the freight code that prints on invoices
where freight is assessed.
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 AP20.1
are optional, required, or not allowed AP20.2 AP20.3
when this freight code has been entered AP20.4 AP20.5
on an order. AP20.7 AP21.1
N = Not Allowed AP23.1 AP25.1
O = Optional AP25.2 AP26.1
R = Required AP27.1 AP30.4
API1.1 BL12.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
...
OFR-AOC-CODE Alpha 2 BL12.1
Element: Aoc 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
Element: Acct Unit The 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: Sub Acct 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
WH20.7
OFR-FRT-ACT-FL Alpha 1 BL12.1
Element: Active Flag 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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR08.1
AR10.1 AR120
AR501 AR550
BL02.1 BL12.1
BL120 BL122
BL123 BL130
BL20.1 BL20.3
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|