SSIconnect Custom Report Fields
Name ...... Type Len JustDescription ......
Recipient Information
RECIP_NAMEA/N30L Attention Line
RECIP_COMPANYA/N30LConsignee Company
RECIP_STREETA/N30LConsignee Street Address
RECIP_CITYA/N18LConsignee City
RECIP_STATEA/N 2LConsignee State
RECIP_ZIPA/N10LConsignee Zip Code
RECIP_COUNTRYA/N 2LConsignee Country
RECIP_INFOA/N30LPrints combined recipient fields of company, name, street, city, state, zip, country
Shipper Information
SHIPPER_NAMEA/N30LPerson Sending Package
SHIPPER_COMPANYA/N30LName of Company Sending the Freight
SHIPPER_STREETA/N30LShipper Street Address
SHIPPER_CITYA/N18LShipper City
SHIPPER_STATEA/N 2LShipper State
SHIPPER_ZIPA/N10LShipper Zip Code
SHIPPER_COUNTRYA/N2LShipper Country
SHIPPER_INFOA/N30LPrints combined shipper fields of company, name, street, city, state, zip, country
Dates And Times
DELIVERY_DATEA/N11RDate Freight Was Delivered
DELIVERY_TIMEA/N10RTime Freight Was Delivered
INVOICE_DATEA/N11RDate of Invoice (01 JAN 99 format)
INVOICE_DTA/N 8LInvoice Date (01JAN99 format)
PAID_DATEA/N10RDate Check Went Out
PROC_DATEA/N11RDate Processed by SSUI
PROC_MONTHA/N10LMonth Bill was Processed by SSUI
SHIPMENT_DATEA/N11RDate Freight was Shipped
SHIP_MTHYRA/N 6LMonth and Year Shipped in MMMYY format
REMIT_DATEA/N 8RDate Funding is Received (Date Check Mailed)
Charges, Weights, And Pieces
FREIGHT_CHARGESD14RGross Freight Charges (does not deduct any discounts indicated in Misc Codes)
TOT_FREIGHTD14RTotal Billed Charges for Freight Only
NET_FREIGHT_CHARGESD14RNet Freight Charges (discounts in Misc Codes field are deducted from gross freight charges)
BROKER_CHGSD14RCharges for Misc Codes ABAP and APRO
DUTY_CHARGESD10RAdds Custom & Duty Fees
*Includes charges for codes 24, 25, 26, 27, A315, A750, ACUS, 81, 122, ATAX, ATAY
MISC_CHARGESD14RPrints all Miscellaneous Charges
MISC_CODESA/N10LPrints all Miscellaneous Codes
TOT_MISC_CHARGESD14RTotal Dollar Amount of all Miscellaneous Charges
OTHER_CHARGESD10RMiscellaneous Charges Not Including Discounts
NET_CHARGESD14RTotal Net Charges (Freight plus Misc Charges)
AMOUNT_PAIDD14RActual Amount Paid
AMOUNT_SAVEDD14RDifference Between Net Charges and Amount Paid
AMOUNT_REPAIDD14RAdditional Amounts Paid if Transaction is a
Re-Bill from Carrier
CPPD 8RCost per Pound
CWTD10RCost per Hundred Weight
DIM_WEIGHTSN10RDimension Weights
KG_WEIGHTN 7RWeight in Kilograms
TOT_PIECESN10RCount of Pieces in Shipment
TOT_WEIGHTN 8RTotal Weight
Carrier Information
CARRIERA/N10LSSUI’s Carrier Code
CARRIER_NAMEA/N20LComplete Name of Carrier
CARRIER_ACCTA/N31LCarrier Name and Bill to Number
BILL_TO_NOA/N10LCarrier Bill to Number
REMIT_STREETA/N30LCarrier Remittance Address
REMIT_CITYA/N18LCarrier Remittance City
REMIT_STATEA/N 8LCarrier Remittance State
REMIT_ZIPA/N 9LCarrier Remittance Zip Code
REMIT_COUNTRYA/N 8LCarrier Remittance Country
CHECK_NON10LCheck Number
Tracking Numbers
AIRBILL_NUMBERA/N10LAirbill Number
BATCH_NBRA/N10RSSUI Number for Weekly Batch Payment
INVOICE_NOA/N10LInvoice Number
STACK_NBRA/N10LStack Number
BOLA/N15LBill of Lading Number
Type Of Service And Analysis Information
FEDX_SERVICEA/N23LFEDX Type of Service Description
SHIP_CLASSA/N 2LClass Code
RATE_CODEA/N 3LRate Code
TRANS_MODEA/N5LShipment Transportation Mode (S, A, O)
TRANS_MODE_DESCA/N 7LSURFACE, AIR, or OCEAN
TRANS_TYPEA/N 5LTransaction Type
TYPE_SERVICEA/N 3LType of Service Code
TYPE_SERVICE_DESCA/N30LType of Service Description
BY_01N 8RPercent Delivered in 1 day
BY_02N 8RPercent Delivered in 2 days
BY_03N 8RPercent Delivered in 3 days
BY_04N 8RPercent Delivered in 4 days
BY_05N 8RPercent Delivered in 5 days
BY_0900N 8RPercent Delivered by 9 am
BY_1030N 8RPercent Delivered by 10:30 am
BY_1200N 8RPercent Delivered by 12:00 pm
BY_1530N 8RPercent Delivered by 3:30 pm
BY_1630N 8RPercent Delivered by 4:30 pm
Miscellaneous Fields
ASSIGN_CODEA/N 6RSection Number in Auto Coding Rules where GL Code was Assigned
CITY_LANEA/N40LOrigin City, Consignee city
CITY_STATEA/N50LOrigin City, State – Consignee City, state
CNTN 4RCount of Number of Bills (used for summary information or subtotaling)b
DOMESTICA10LFlag indicating Domestic or International
1 = Domestic, 0 (zero) = International
EXCEPT_REASONA/N30LCompliance Reason for Placing On-Hold
FREIGHT_DESCA/N30LDescription of Freight
GL_CODE1A/N19LGeneral Ledger Code with No Formating
LADING_DESCA/N20LBill of Lading Description
MILESN10LMiles Shipped
NBR_BILLSN 10RCount of Number of Bills (used for summary information or subtotaling)
NBR_SSICONN_POSTEDN10RCount of changes made to the Transaction that were made through SSIconnect
PAYMENT_TYPEA/N 1L1 = prepaid, 2 = collect, 3 = third party
POD_RECIPIENTA/N22LPerson who signed for package
REFERENCE_NOTESA/N24LShipper Reference Notes
REMARKSA/N10LShipper Remarks Field
SHORT_PAY_COMMENTA/N20LReason for Short Pay
NON_PAY_CODEA/N 2LSSI Code for Non-Payment Reason
00 = Normal Payment
01 = Service Failure
02 = Incorrect Rate
03 = Duplicate Bill
04 = Bill is Not Ours
06 = Missing POD
07 = Bill Under Review
08 = Possible Other SSUI Client
Type Codes: A/N = Alpha Numeric, N=Numeric, A = Alpha, D= Dollars
Software Solutions Unlimited, Inc. - Proprietary Trade SecretsApril 27, 1999
Page 1 of 4