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 AP510 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 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 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 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.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


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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA180 MA278
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA53.1
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
AP510 API1.1
API2.1 AR08.1
AR10.1 AR501
AR550 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1


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 02:09:33 2016

Home
Contact Us



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