Table: Worksheet Detail Optional Fields

Table: ICWKUHO
View: IC0795
Record Length: 198

Flags: A R 

Keys: 2

Title Flags Fields

Worksheet Detail Optional Field LOCATIONSORTCODEITEMNOOPTFIELD
Optional Field/Worksheet Detail OPTFIELDLOCATIONSORTCODEITEMNO

Fields: 15

Field Type Title Presentation

LOCATION String*6 Location Mask: %-6N
SORTCODE String*60 Sort Code
ITEMNO String*24 Unformatted Item Number Mask: %-24C
OPTFIELD String*12 Optional Field Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
VALUE String*60 Value
TYPE Integer Type List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH Integer Length
DECIMALS Integer Decimals
ALLOWNULL Boolean Allow Blank List:2 entries
0 = No
1 = Yes
VALIDATE Boolean Validate List:2 entries
0 = No
1 = Yes
SWSET Integer Value Set List:3 entries
0 = No
1 = Yes
99 = Not Applicable