COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

TRANSPERSONID

1

UPPER

30

UPLOADFILEID

1

INTEGER

12

 

 

 

 

PLUSRVHEADER Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

EMAIL

0

ALN

50

INDUSTRYFLAG

1

ALN

1

NAME

1

UPPER

30

ORGANIZATION

1

UPPER

20

PHONE

1

ALN

20

RECORDCOUNT

0

INTEGER

12

REPORTNUM

1

UPPER

12

REPORTNUMNP

0

UPPER

12

 

 

 

 

PLUSRVPROPERTY Table

 

 

 

 

 

 

 

COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

ASSETNUM

0

UPPER

12

CONTRACTNUM

0

UPPER

8

CONTRACTOR

0

UPPER

12

CUSTODIANPERSONID

0

UPPER

30

EXTERNALSYSTEM

0

UPPER

25

FILEFORMAT

0

UPPER

25

ITEMNUM

0

UPPER

30

ITEMSETID

0

UPPER

8

LOCATION

0

UPPER

12

ORGID

1

UPPER

8

PRICE

0

AMOUNT

10

PROPERTYCLASS

0

UPPER

25

QUANTITY

0

DECIMAL

15

SITEID

0

UPPER

8

SOURCE

0

UPPER

25

TOCONTRACT

0

UPPER

8

Government Database Tables and Columns

55

Page 65
Image 65
IBM SC23-8765-00 manual Plusrvheader Table, Plusrvproperty Table