Transportation

Contains the unique key, system generated by sequence number that will uniquely identify a single transportation transaction record.

Contains vessel or other vehicle identification

Contains voyage or flight number.

Estimated date of departure for the goods leaving the port of lading.

contains the actual depart date of the transportation

Contains the purchase order number from which the item was originated.

Contains the item number. Oracle Retail target column ITEM on TRANSPORTATION.

Contains the Bill of Lading or Airway Bill number. This id will be generated by the agent that is shipping the goods.

Contains the id number of the container in which the item was shipped.

Contains the invoice id associated with the purchase order or item.

Contains the date that the invoice was issued.

Contains the ASN# or shipment tracking number.

Actual arrival date of the goods to the discharge port.

Actual delivery date of the goods of the goods from the port.

Contains the status of the detail record. Valid values are Booked, Delivered, Loaded and Sailed.

Contains a customs defined Transportation mode. Valid values are: 10 - Vessel, Non-container 11 - Vessel, Container 12 - Border Water-borne (Only - Mexico and Canada) 20 - Rail, Non-container 21 - Rail, Container 30 - Truck, Non-container 31 - Truck, Container 32 - Auto 33 - Pedestrian 34 - Road, other, Includes foot and animal borne 40 - Air, Non-container 41 - Air, Container 50 - Mail 60 - Passenger, hand-carried 70 - Fixed Tran Installation 80 - Not used at this time.

Contains the Vessels Standard Carrier Alpha Code as established by Customs. Each vessel will have a unique scac code.

Contains the Containers Standard Carrier Alpha Code as established by Customs. Each container will have a unique SCAC code.

Contains the id number of the tag used to physically seal a container before placement on a vessel.

Contains the method in which the goods are shipped.

Contains the size of the freight type used.

Contains the id of the country where the goods originated.

Contains the id of the country where the goods were consolidated

Contains the id of the country where the goods were exported.

Contains the estimated arrival date of the Tran detail record.

Contains the lading port id, which is the Customs port code identifying where the goods were loaded on a vessel.

Contains the discharge port id, which is the Customs port code identifying where the goods were unloaded from a vessel.

Contains the receipt identification that was assigned to these goods.

Contains the Forwarders Cargo Receipt id.

Contains the date the Forwarders Cargo Receipt was issued.

Contains the Service Contract number for the negotiated freight rates.

Contains the In Transit number for shipments cleared at inland locations, or other than Discharge Port.

Contains the date the In Transit number was issued.

Contains the Lot number of the fabric or material which is used to maintain item consistency for deliveries.

Contains the value of the invoice. The currency code for this value is stored in this record in the Currency Code column.

The currency that values are stored in the Tran module for this header record.

The rate of exchange for the given currency code against the primary currency

Contains the number of cartons for this order/item combination.

Contains the unit of measure that carton_qty is stored in.

Contains the number of items for this order/item combination.

Contains the unit of measure that item_qty is stored in.

Contains the gross weight for this order/item combination.

Contains the unit of measure that the gross weight is stored in.

Contains the net weight for this order/item combination.

Contains the unit of measure that the net weight is stored in.

Contains the cubic for this order/item combination.

Contains the unit of measure that the cubic is stored in.

Contains the shipment type of the record. Valid values are DESH Deconsolidated Shipment and DISH Direct Shipment.

Contains a Rush value. This will identify goods for promotional or other purposes that need to be received as quickly as possible. Valid values are Yes and No.

This indicator will determine whether or not a Transporation record is to be considered for Customs Entry finalization.

Contains user comments. Oracle Retail target column COMMENTS on TRANSPORTATION.

identifies row selected for update

Contains the partner type of the transportation partner id.

Contains the partner associated with the transportation.

This field Indicates the currency against which the exchange rate has been captured on the entity. Valid values are: P (Primary) or L (Local) currency.