BLUSRFLDEF – The User Field Definition file defines user field types and user field data types.

System
Billing (BL)
Prefix
BUD
Primary key
USER-FLD-TYPE, COMPANY
Fields
10
Updated by
0 programs
Referenced by
0 programs

BLUSRFLDEF is the The User Field Definition file defines user field types and user field data types. table in Lawson Billing (prefix BUD). It is indexed by USER-FLD-TYPE, COMPANY (BUDSET1). The table has 10 fields, 1 index and 0 documented relations.

About BLUSRFLDEF

The User Field Definition file defines user field types and user field data types.

Fields (10)

Column = COBOL field name without the BUD- 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
#BUD-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.—
#BUD-USER-FLD-TYPE PK
USER_FLD_TYPE		Alpha 1Indicates the user field type. User flds can be added to invoices, invoice lines and ship-to's. Valid values are:
  • I Invoice
  • L Invoice Line
  • S Ship-To
—
#BUD-DATA-TYPE-01
DATA_TYPE_01		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-02
DATA_TYPE_02		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-03
DATA_TYPE_03		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-04
DATA_TYPE_04		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-05
DATA_TYPE_05		Alpha 1Indicates the data type of the user field.
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-06
DATA_TYPE_06		Alpha 1—
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-07
DATA_TYPE_07		Alpha 1—
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—
#BUD-DATA-TYPE-08
DATA_TYPE_08		Alpha 1—
  • A Alpha
  • N Numeric
  • D Date Format (1st 6 positions)
  • M Amount
—

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
BUDSET1
  1. USER-FLD-TYPE
  2. COMPANY
PrimaryTX00.1

Programs

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