Table: Manual Check Optional Field Values

Table: UPMCHO
View: UP0129
Record Length: 143

Flags: A R 

Keys: 2

Title Flags Fields

Manual Check Optional Field Valu EMPLOYEEBANKCHECKNUMPERENDCHECKDATEOPTFIELD
Optional Field/Manual Check OPTFIELDEMPLOYEEBANKCHECKNUMPERENDCHECKDATE

Fields: 17

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