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 AR501 AR550 BL123 BL202 BL212
BL290 BL80.1 BL802 CXCP.1 DR100 IC141
IC142 IC83.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1
WH130 WH224 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
BL02.1 BL12.1
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 BL80.1
Description the freight code that prints on invoices
where freight is assessed.
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 CXCP.1
Frt Chrg Cd This field indicates if freight charges DR100 IC141
are optional, required, or not allowed IC142 IC83.1
when this freight code has been entered POIJ.1 RQ11.1
on an order. RQ12.1 RQ13.1
N = Not Allowed WH130 WH33.1
O = Optional WH33.2 WH33.3
R = Required WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
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
Default Freight The account unit used for posting the
Acct. Unit credit side of the freight transaction.
OFR-FRT-ACCOUNT Numeric 6 BL12.1
Default Freight The account number used for posting the
Account credit side of the freight transaction.
OFR-FRT-SUB-ACCT Numeric 4 BL12.1
Default Freight Sub The subaccount number used for posting
Account the credit side of the freight
transaction.
OFR-FRT-USED-FL Alpha 1 BL02.1 BL212
Freight Code Used Freight code used flag. If the freight
Flag code has ever been used, this flag will
be set to Yes.
Y = Yes
N = No
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 AR501
FRT-CODE AR550 BL02.1
BL12.1 BL123
BL202 BL212
BL290 BL80.1
BL802 CXCP.1
DR100 IC141
IC142 IC83.1
POIJ.1 RQ11.1
RQ12.1 RQ13.1
WH130 WH224
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|
