BLSHPUF – Ship To User Field

System
Billing (BL)
Prefix
BSU
Primary key
COMPANY, CUSTOMER, SHIP-TO
Fields
11
Updated by
0 programs
Referenced by
0 programs

BLSHPUF is the Ship To User Field table in Lawson Billing (prefix BSU). It is indexed by COMPANY, CUSTOMER, SHIP-TO (BSUSET1). The table has 11 fields, 1 index and 0 documented relations.

About BLSHPUF

The Ship-To User Fields file contains user fields that can be entered on Ship-To's.

Fields (11)

Column = COBOL field name without the BSU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BSU-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.—
#BSU-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.—
#BSU-SHIP-TO PK
SHIP_TO		Numeric 4This field contains the number representing the ship to customer.—
#BSU-SHP-USR-FLD-01
SHP_USR_FLD_01		Alpha 20Ship-To user field 1.—
#BSU-SHP-USR-FLD-02
SHP_USR_FLD_02		Alpha 20Ship-To user field 2.—
#BSU-SHP-USR-FLD-03
SHP_USR_FLD_03		Alpha 20Ship-To user field 3.—
#BSU-SHP-USR-FLD-04
SHP_USR_FLD_04		Alpha 20Ship-To user field 4.—
#BSU-SHP-USR-FLD-05
SHP_USR_FLD_05		Alpha 20Ship-To user field 5.—
#BSU-SHP-USR-FLD-06
SHP_USR_FLD_06		Alpha 20——
#BSU-SHP-USR-FLD-07
SHP_USR_FLD_07		Alpha 20——
#BSU-SHP-USR-FLD-08
SHP_USR_FLD_08		Alpha 20——

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BSUSET1
  1. COMPANY
  2. CUSTOMER
  3. SHIP-TO
PrimaryTX00.1

Programs

No Lawson programs are documented as updating or referencing this table.