OEFRTCODE – Order Entry Freight Code

System
Billing (BL)
Prefix
OFR
Primary key
COMPANY, FRT-CODE
Fields
11
Updated by
1 program
Referenced by
225 programs

OEFRTCODE is the Order Entry Freight Code table in Lawson Billing (prefix OFR). It is indexed by COMPANY, FRT-CODE (OFRSET1). It is related 1:1 to OECOMPANY. It is updated by WH20.7 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more. The table has 11 fields, 1 index and 1 documented relation.

About OEFRTCODE

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).

Fields (11)

Column = COBOL field name without the OFR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OFR-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
FRT_CODE		Alpha 2The 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
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
FRT_CARR_CD		Alpha 1This 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
FRT_CHRG_CD		Alpha 1This 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 +52 more (list truncated in source)
OFR-AOC-CODE
AOC_CODE		Alpha 2This 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
FRT_ACCT_UNIT		Alpha 15The account unit used for posting the credit side of the freight transaction.—
OFR-FRT-ACCOUNT
FRT_ACCOUNT		Numeric 6The account number used for posting the credit side of the freight transaction.—
OFR-FRT-SUB-ACCT
FRT_SUB_ACCT		Numeric 4The subaccount number used for posting the credit side of the freight transaction.—
OFR-FRT-USED-FL
FRT_USED_FL		Alpha 1Freight 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
FRT_ACT_FL		Alpha 1Only 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
—

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OFRSET1COMPANY, FRT-CODEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OecompanyOECOMPANYRequiredOFR-COMPANY → OEC-COMPANY

Programs

Updated by (1)

Referenced by (225)