COLUMN | REQUIRED | MAXTYPE | LENGTH |
|
|
|
|
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 |
Government Database Tables and Columns | 47 |
