Table: MC Details Opt Field Values

Table: UPMCDO
View: UP0130
Record Length: 145

Flags: A R 

Keys: 2

Title Flags Fields

MC Details Optional Field EMPLOYEEBANKCHECKNUMPERENDCHECKDATELINENUMOPTFIELD
Optional Field/MC Details OPTFIELDEMPLOYEEBANKCHECKNUMPERENDCHECKDATELINENUM

Fields: 18

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
BANK String*8 Bank Code Mask: %-8N
CHECKNUM BCD*5.0 Check Number
PEREND Date Period End Date
CHECKDATE Date Check Date
LINENUM Integer Line Number
OPTFIELD String*12 Optional Field Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
VALUE String*60 Value Mask: %-60c
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