Field Listing for Table PURCHASESHIPMENTS

Field:SHIPMENTNUMBER Type: INTEGER
Field:SHIPMENTREFERENCE Type: VARCHAR Length: 50
Field:SHIPMENTSTATUS Type: VARCHAR Length: 20
Field:SHIPMENTDATE Type: DATE
Field:PRINTSTATUS Type: VARCHAR Length: 20
Field:WORKFLOWSTATUS Type: VARCHAR Length: 20
Field:TRACKINGCOLOUR Type: INTEGER
Field:SHIPMENTTYPE Type: VARCHAR Length: 20
Field:SHIPMENTMETHOD Type: VARCHAR Length: 20
Field:SHIPMENTETADATE Type: DATE
Field:SHIPMENTARRIVALDATE Type: DATE
Field:DOCUMENTREFERENCE Type: VARCHAR Length: 50
Field:DEPARTUREPORT Type: VARCHAR Length: 30
Field:ARRIVALPORT Type: VARCHAR Length: 30
Field:SINGLESUPPLIERSHIPMENT Type: BOOLEAN
Field:SUPPLIER Type: VARCHAR Length: 50
Field:SHIPMENTNOTES Type: BLOB
Field:ORDERNETTVALUE Type: DOUBLE
Field:LOCALORDERNETTVALUE Type: DOUBLE
Field:LOCALCHARGESNETTVALUE Type: DOUBLE
Field:LOCALSHIPMENTNETTVALUE Type: DOUBLE
Field:CHARGEVALUE1 Type: DOUBLE
Field:CHARGEVALUE2 Type: DOUBLE
Field:CHARGEVALUE3 Type: DOUBLE
Field:CHARGEVALUE4 Type: DOUBLE
Field:CHARGEVALUE5 Type: DOUBLE
Field:CHARGEVALUE6 Type: DOUBLE
Field:CHARGEVALUE7 Type: DOUBLE
Field:CHARGEVALUE8 Type: DOUBLE
Field:CHARGEVALUE9 Type: DOUBLE
Field:CHARGEVALUE10 Type: DOUBLE
Field:CHARGELINEVALUE1 Type: DOUBLE
Field:CHARGELINEVALUE2 Type: DOUBLE
Field:CHARGELINEVALUE3 Type: DOUBLE
Field:CHARGELINEVALUE4 Type: DOUBLE
Field:CHARGELINEVALUE5 Type: DOUBLE
Field:CHARGELINEVALUE6 Type: DOUBLE
Field:CHARGELINEVALUE7 Type: DOUBLE
Field:CHARGELINEVALUE8 Type: DOUBLE
Field:CHARGELINEVALUE9 Type: DOUBLE
Field:CHARGELINEVALUE10 Type: DOUBLE
Field:CHARGEDIFFVALUE1 Type: DOUBLE
Field:CHARGEDIFFVALUE2 Type: DOUBLE
Field:CHARGEDIFFVALUE3 Type: DOUBLE
Field:CHARGEDIFFVALUE4 Type: DOUBLE
Field:CHARGEDIFFVALUE5 Type: DOUBLE
Field:CHARGEDIFFVALUE6 Type: DOUBLE
Field:CHARGEDIFFVALUE7 Type: DOUBLE
Field:CHARGEDIFFVALUE8 Type: DOUBLE
Field:CHARGEDIFFVALUE9 Type: DOUBLE
Field:CHARGEDIFFVALUE10 Type: DOUBLE
Field:CHARGESOUTOFBALANCE Type: INTEGER
Field:SHIPMENTDEPARTUREDATE Type: DATE
Field:ADDITIONALFIELD_1 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_2 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_3 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_4 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_5 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_6 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_7 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_8 Type: VARCHAR Length: 100
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:ADDITIONALDATEFIELD_3 Type: DATE
Field:ADDITIONALDATEFIELD_4 Type: DATE
Field:ADDITIONALDATEFIELD_5 Type: DATE
Field:ADDITIONALDATEFIELD_6 Type: DATE
Field:ADDITIONALDATEFIELD_7 Type: DATE
Field:ADDITIONALDATEFIELD_8 Type: DATE
Field:CREATEPURCHASEINVOICE Type: BOOLEAN
Field:INSERTSHIPMENTCHARGELINES Type: BOOLEAN
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30