 |
Lawson Insight Technical Documentation |
|
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 AR08.1 AR10.1 AR501 AR550 CXCP.1
DR100 IC141 IC142 IC28.1 IC83.1 MA180
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1
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 RQ10.3
RQ11.1 RQ12.1 RQ13.1 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
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OFR-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OFR-FRT-CODE Alpha 2
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)
Freight Code This field contains the description of
Description the freight code that prints on invoices
where freight is assessed.
OFR-FRT-CARR-CD Alpha 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 AP125 AP126
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 CXCP.1
on an order. DR100 IC141
N = Not Allowed IC142 IC28.1
O = Optional IC83.1 MA180
R = Required MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
OFR-AOC-CODE Alpha 2
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
Default Freight The account unit used for posting the
Acct. Unit credit side of the freight transaction.
OFR-FRT-ACCOUNT Numeric 6
Default Freight The account number used for posting the
Account credit side of the freight transaction.
OFR-FRT-SUB-ACCT Numeric 4
Default Freight Sub The subaccount number used for posting
Account the credit side of the freight
transaction.
OFR-FRT-USED-FL Alpha 1 WH20.7
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
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 AP125 AP126
FRT-CODE AP131 AP25.1
AP25.2 AP26.1
AP27.1 AR08.1
AR10.1 AR501
AR550 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
...
OEFRTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY -> OEC-COMPANY
|