The following table lists the fields in the argo_chargeable_unit_events table that are available through the billing extract:
|
Field Label |
Data Type |
Field Size |
Description/Applicable Reportable Entity Tag |
|---|---|---|---|
|
gkey |
bigint(auto_increment) |
20 |
|
|
batch_id |
bigint |
20 |
Batch number is assigned by auto increment for every extract. |
|
event_type |
varchar |
30 |
Id field from the event type screen |
|
source_event_gkey |
bigint |
20 |
Gkey of srv_event table is extracted for internal reference. |
|
is_locked |
tinyint |
1 |
Boolean value of 0 or 1 is stored. If it is TRUE then N4 will not update the row. |
|
status |
varchar |
30 |
"QUEUED" indicates that the record is extracted. |
|
unit_gkey |
bigint |
20 |
Gkey of inv_unit_fcy_visit is extracted for internal reference. |
|
facility_id |
varchar |
20 |
Facility Id |
|
complex_id |
varchar |
20 |
Complex Id |
|
terminal_operator_gkey |
bigint |
20 |
Gkey of Terminal operator for internal reference. |
|
line_operator_id |
varchar |
20 |
Line Operator of the equipment |
|
equipment_id |
varchar |
30 |
Container number |
|
eq_subclass |
varchar |
30 |
Equipment sub class CTR, CHS etc. |
|
line_operator_id |
varchar |
20 |
Event operator Id |
|
freight_kind |
varchar |
30 |
Freight Kind of Unit: MTY,FCL,LCL,BBK |
|
iso_code |
varchar |
30 |
ISO code |
|
iso_group |
varchar |
30 |
ISO group code |
|
eq_length |
varchar |
30 |
ISO length |
|
eq_height |
varchar |
30 |
ISO height |
|
category |
varchar |
10 |
The Category of the Unit (Import, Export, ...) |
|
paid_thru_day |
datetime |
19 |
Applicable only for STORAGE and REEFER event. |
|
dray_status |
varchar |
30 |
Dray Status of Unit: FORWARD,RETURN,DRAYIN |
|
is_oog |
tinyint |
1 |
True if equipment is OOG |
|
is_refrigerated |
tinyint |
1 |
True if equipment is Refrigerated |
|
is_hazardous |
tinyint |
1 |
True if Hazardous |
|
imdg_class |
varchar |
30 |
IMDG Class. If multiple hazardous, then max value is extracted. |
|
fire_code |
varchar |
4 |
Worst fire code for hazardous cargo |
|
fire_code_class |
varchar |
4 |
Worst fire code class for hazardous cargo |
|
commodity_id |
varchar |
30 |
Commodity Id |
|
special_stow_id |
varchar |
30 |
Special Stow Id |
|
pod1 |
varchar |
30 |
Port of discharge COUNTRY + ID |
|
pol1 |
varchar |
30 |
Port of Loading COUNTRY + ID |
|
bundle_unitid |
varchar |
30 |
Equipment is bundled to (master) number |
|
bundle_ufv_gkey |
bigint |
20 |
For internal reference |
|
ib_loctype |
varchar |
30 |
The actual arrival location type. VESSEL, TRUCK, TRAIN |
|
ib_id |
varchar |
30 |
The actual inbound carrier id |
|
ib_visit_id |
varchar |
30 |
The actual inbound carrier visit id |
|
ib_carrier_name |
varchar |
35 |
The actual inbound carrier name |
|
ib_call_nbr |
varchar |
30 |
The actual inbound carrier call nbr |
|
ib_eta |
datetime |
19 |
The actual inbound carrier ETA |
|
ib_ata |
datetime |
19 |
The actual inbound carrier ATA |
|
ib_vessel_type |
varchar |
30 |
The actual inbound vessel type RORO, PSNGR etc., |
|
ib_line_id |
varchar |
30 |
The actual inbound carrier line id |
|
ob_loctype |
varchar |
30 |
The actual departure location type. VESSEL, TRUCK, TRAIN |
|
ob_id |
varchar |
30 |
The actual outbound carrier id |
|
ob_visit_id |
varchar |
30 |
The actual outbound carrier visit id |
|
ob_carrier_name |
varchar |
35 |
The actual outbound carrier name |
|
ob_call_nbr |
varchar |
30 |
The actual outbound carrier call nbr |
|
ob_eta |
datetime |
19 |
The actual outbound carrier ETA |
|
ob_ata |
datetime |
19 |
The actual outbound carrier ATA |
|
ob_vessel_type |
varchar |
30 |
The actual outbound vessel type RORO, PSNGR etc., |
|
ob_line_id |
varchar |
30 |
The actual outbound carrier line id |
|
event_start_time |
datetime |
19 |
Start time of the event. It is applicale like STORAGE,REEFER kind |
|
event_end_time |
datetime |
19 |
End time of the event. It is applicale like STORAGE,REEFER kind |
|
first_availability_date |
datetime |
19 |
First availability date. It is applicable for STORAGE |
|
qc_che_id |
varchar |
30 |
Quay crane Id |
|
fm_pos_loctype |
varchar |
16 |
From position loc type of this event |
|
fm_pos_locid |
varchar |
16 |
From position loc Id of this event |
|
to_pos_loctype |
varchar |
16 |
To position loc type of this event |
|
to_pos_locid |
varchar |
16 |
To position loc Id of this event |
|
service_order |
varchar |
20 |
Service order number of this event |
|
restow_reason |
varchar |
20 |
Restow Reason |
|
restow_account |
varchar |
20 |
|
|
rehandle_count |
bigint |
20 |
|
|
opl |
varchar |
30 |
Original Port of Loading |
|
final_destination |
varchar |
30 |
Final_destination |
|
ufv_time_in |
datetime |
19 |
Unit facility visit Time In |
|
ufv_time_out |
datetime |
19 |
Unit facility visit Time Out |
|
temp_reqd_C |
double |
22 |
Temperature required, degrees Centigrade |
|
time_load |
datetime |
19 |
The time at which the ufv was loaded to the outbound carrier |
|
consignee_id |
varchar |
30 |
Consignee Id |
|
shipper_id |
varchar |
30 |
Shipper Id |
|
flex_string01 |
varchar |
255 |
Refer to Flex field mapping. |
|
flex_string02 |
varchar |
255 |
" |
|
flex_string03 |
varchar |
255 |
" |
|
flex_string04 |
varchar |
255 |
" |
|
flex_string05 |
varchar |
255 |
" |
|
flex_date01 |
datetime |
19 |
" |
|
flex_date02 |
datetime |
19 |
" |
|
flex_date03 |
datetime |
19 |
" |
|
flex_date04 |
datetime |
19 |
" |
|
flex_date05 |
datetime |
19 |
" |
|
flex_long01 |
bigint |
20 |
" |
|
flex_long02 |
bigint |
20 |
" |
|
flex_long03 |
bigint |
20 |
" |
|
flex_long04 |
bigint |
20 |
" |
|
flex_long05 |
bigint |
20 |
" |
|
quantity |
double |
22 |
Quantity. Usually null for Discharge, Load type event |
|
quantity_unit |
varchar |
|
Quantity Unit of measure |
|
created |
datetime |
19 |
Extract record created date and time |
|
creator |
varchar |
30 |
Extract record creator |
|
changed |
datetime |
19 |
Extract record last modified date and time |
|
changer |
varchar |
30 |
Extract record last modified user |