STPLAN

Planning Table

Field Name

Caption

Mask

Description

Field Type

PT_AUTO

Plan Rec #

nnnnnnnn

 

Long Integer

PT_CRT_BY

Created By

25x

Created By

Text

PT_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PT_DESC

Planning Description

30x

Planning Description

Text

PT_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

PT_MOD_BY

Last Modified By

25x

Last Modified By

Text

PT_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

PT_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PT_NUMBER

Planning Table

nnn

Planning Table

Integer

PT_ROWVER

 

 

Rowversion for optimistic locking

Date/Time