IBM TIVOLI SC23-8765-00 User Manual

Page 57

background image

Government Database Tables and Columns

47

FOB

0

ALN

20

FREIGHTTERMS

0

ALN

50

FREIGHTTERMS_LONGDESCRIPTION

0

LONGALN

32000

HASINSURANCE

1

YORN

1

HASLD

1

YORN

1

HISTORYFLAG

1

YORN

1

INCLUDESMAINT

1

YORN

1

INCLUSIVE1

1

YORN

1

INCLUSIVE2

1

YORN

1

INCLUSIVE3

1

YORN

1

INCLUSIVE4

1

YORN

1

INCLUSIVE5

1

YORN

1

INSPECTIONREQUIRED

1

YORN

1

INSURANCEEXPDATE

0

DATE

4

INSURANCEREQ

1

YORN

1

INTERIMCHG

0

AMOUNT

10

LANGCODE

1

UPPER

4

LASTSCHEDULEDATE

0

DATE

4

LEASERATEFACTOR

0

DECIMAL

10

LEASESUSPACCT

0

GL

23

LINESTATUS

0

UPPER

12

MAINTHIERCHY

1

YORN

1

MASTERNUM

0

UPPER

8

MASTERREVNUM

0

INTEGER

12

NOTIFYCONTACT

0

ALN

50

NOTIFYONMOVE

1

YORN

1

NP_STATUSMEMO

0

ALN

50

NUMOFPAYMENTS

0

INTEGER

12

ORGID

0

UPPER

8

OUTSIDEMAINT

1

YORN

1

OWNERSYSID

0

ALN

10

PAYMENTSCHED

1

YORN

1

PAYMENTTERMS

0

ALN

20

COLUMN

REQUIRED

MAXTYPE

LENGTH