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 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1

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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.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
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4


OEFRTCODE FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Wed Jun 08 20:48:00 2016

Home
Contact Us



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