COLUMN

REQUIRED

MAXTYPE

LENGTH

 

 

 

 

ENTERPRISEID

0

UPPER

25

FROMPARENT

0

UPPER

12

FROMPRICE

0

AMOUNT

10

FROMPROPERTYID

0

INTEGER

12

FROMSITE

0

UPPER

8

FROMSTATUS

0

ALN

20

FROMUII

0

ALN

100

FROMUIIMARK

0

ALN

256

GFPCONTRACTNUMBER

0

UPPER

8

GFPPRICONTRACTCAGE

0

ALN

9

GFPPRICONTRACTDUNS

0

ALN

9

GFPPRICONTRDODAAC

0

ALN

6

HASLD

1

YORN

1

ISSUEAGENCYCODE

0

UPPER

25

ITEMNUM

0

UPPER

30

ITEMTYPE

0

UPPER

3

LANGCODE

1

UPPER

4

MARKCONTENTS

0

ALN

25

MARKERCODE

0

UPPER

25

MARKGRADE

0

UPPER

1

MARKIDENTIFIER

0

UPPER

30

MARKMETHOD

0

UPPER

3

MATRECTRANSID

0

INTEGER

12

MATUSETRANSID

0

INTEGER

12

MEDIUMCODE

0

UPPER

25

MFGCODE

0

UPPER

25

MFGID

0

ALN

13

MINUSDATE

0

DATETIME

10

MINUSMEMO

0

ALN

254

MINUSMEMO_LONGDESCRIPTION

0

LONGALN

32000

MINUSPERSONID

0

UPPER

30

ORGID

1

UPPER

8

ORIGINALPARTNUM

0

UPPER

30

Government Database Tables and Columns

51

Page 61
Image 61
IBM SC23-8765-00 manual Fromuiimark ALN