COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

UIITYPE

0

UPPER

25

UNITOFMEASURE

0

UPPER

8

 

 

 

 

PLUSRTRANSACTION Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

NEWASSETSTATUS

0

ALN

20

ORGID

1

UPPER

8

PLUSRTRANSACTIONID

1

INTEGER

12

TRANSACTIONNAME

1

UPPER

25

 

 

 

 

PLUSRTRANSEXTSYS Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

EXTERNALSYSTEM

1

UPPER

25

FILEFORMAT

1

UPPER

25

ORGID

1

UPPER

8

PLUSRTRANSEXTSYSID

1

INTEGER

12

TRANSACTIONID

1

INTEGER

12

 

 

 

 

PLUSRTRANSFORM Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

FORMNAME

1

UPPER

25

ORGID

1

UPPER

8

PLUSRTRANSFORMID

1

INTEGER

12

TRANSACTIONID

1

INTEGER

12

 

 

 

 

PLUSRUIITEMPLATE Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

EID

1

UPPER

25

IAC

1

UPPER

25

ORGID

1

UPPER

8

PLUSRUIITEMPLATEID

1

INTEGER

12

Government Database Tables and Columns

53

Page 63
Image 63
IBM SC23-8765-00 manual Plusrtransaction Table, Plusrtransextsys Table, Plusrtransform Table, Plusruiitemplate Table