OEFRTCODE

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 API2.1
AR08.1 AR10.1 AR501 AR550 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC140 IC66.1 IC83.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 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
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.4
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 WH32.5 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
ZW130


UPDATED BY
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OFR-COMPANY
Element: Company
Numeric 4
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
Element: Aoc Code
Alpha 2
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
Element: Frt Desc
Alpha 20 (Lower Case)
This field contains the description of the freight code that prints on invoices where freight is assessed.
OFR-FRT-CARR-CD
Element: Frt Carr Cd
Alpha 1
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
Element: Frt Chrg Cd
Alpha 1
This field indicates if freight charges are optional, required, or not allowed when this freight code has been entered on an order.
N = Not Allowed
O = Optional
R = Required
...
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 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
OFR-AOC-CODE
Element: Aoc Code
Alpha 2
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
Element: Acct Unit
Alpha 15
The account unit used for posting the credit side of the freight transaction.
OFR-FRT-ACCOUNT
Element: Account
Numeric 6
The account number used for posting the credit side of the freight transaction.
OFR-FRT-SUB-ACCT
Element: Sub Acct
Numeric 4
The subaccount number used for posting the credit side of the freight transaction.
OFR-FRT-USED-FL
Element: All Flag
Alpha 1
Freight code used flag. If the freight code has ever been used, this flag will be set to Yes.
Y = Yes
N = No
WH20.7
OFR-FRT-ACT-FL
Element: Active Flag
Alpha 1
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
FRT-CODE
...
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 API2.1
AR08.1 AR10.1
AR501 AR550
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300


OEFRTCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OFR-COMPANY->OEC-COMPANY


File created: Thu Jun 09 11:09:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.