Item_fulfillments

Columns

Name Type Length Precision Scale References In Description
accounting_period_id NUMBER 39 0 Accounting period ID
ancillary_endorsement VARCHAR2 32 Ancillary endorsement
b13a_filling_option VARCHAR2 24 B13a filling option
b13a_statement_data VARCHAR2 50 B13a statement data
backup_ship_notification_email VARCHAR2 100 Backup ship notification email
billaddress VARCHAR2 999 Bill address
booking_confirmation_number VARCHAR2 64 Booking confirmation number
carrier_identification_code VARCHAR2 32 Carrier identification code
created_by_id NUMBER 39 0 Created by ID
currency_id NUMBER 39 0 Currency ID
date_blanket_period_end TIMESTAMP Date blanket period end
date_blanket_period_start TIMESTAMP Date blanket period start
date_closed TIMESTAMP Date closed
date_created TIMESTAMP Date created
date_future_shipping TIMESTAMP Date future shipping
date_home_delivery TIMESTAMP Date home delivery
date_last_modified TIMESTAMP Date last modified
date_license TIMESTAMP Date license
date_sales_effective TIMESTAMP Date the sales is effective
date_transaction TIMESTAMP Transaction date
delivery_instructions VARCHAR2 64 Delivery instrcutions
eccn VARCHAR2 8 ECCN
email VARCHAR2 256 Email
entity_id NUMBER 39 0 Entity ID. The customer or job associated with this transaction appears here. For details on existing customers and projects, go to Customers.
entry_number VARCHAR2 32 Entry number
exchange_rate NUMBER 30 15 Exchange rate
export_type VARCHAR2 22 Export type
fax VARCHAR2 100 Fax
fedex_ship_alert VARCHAR2 100 Fedex ship alert
fob VARCHAR2 13 Free on Board
handling_cost NUMBER 39 0 Handling cost
has_cert_of_origin VARCHAR2 3 Has Certification of origin
has_commercial_invoice VARCHAR2 3 Has commercial invoice
has_nafta_cert_of_origin VARCHAR2 3 Has NAFTA certification or origin
has_pro_forma_invoice VARCHAR2 3 Has promo forma invoice
hold_at_location_address_one VARCHAR2 150 Hold at location address one
hold_at_location_address_three VARCHAR2 150 Hold at location address three
hold_at_location_address_two VARCHAR2 150 Hold at location address two
hold_at_location_city VARCHAR2 50 Hold at location city
hold_at_location_country VARCHAR2 50 Hold at location country
hold_at_location_loc_phone VARCHAR2 100
hold_at_location_phone VARCHAR2 100 Hold at location phone
hold_at_location_state VARCHAR2 50 Hold at location state
hold_at_location_zip VARCHAR2 36 Hold at location zip code
home_delivery_type VARCHAR2 16 Home delivery type
in_bond_code VARCHAR2 2 In bond code
international_exemption_number VARCHAR2 32 International exemption number
is_certified_mail VARCHAR2 3 Is certified mail
is_fdx_signature_home_delivery VARCHAR2 3 Is fedex signature home delivery
is_held_at_location VARCHAR2 3 Is held at location
is_holiday_delivery VARCHAR2 3 Is holiday delivery
is_inside_delivery VARCHAR2 3 is inside delivery
is_inside_pickup VARCHAR2 3 Is inside pickup
is_intercompany VARCHAR2 3 Is intercompany
is_memorized VARCHAR2 3 Is memorized
is_online_bill_pay VARCHAR2 3 Is online bill pay
is_routed_export_transaction VARCHAR2 3 Is routed export transaction
is_saturday_delivery VARCHAR2 3 Is Saturday delivery
is_saturday_pickup VARCHAR2 3 Is Saturday pickup
is_saturday_service VARCHAR2 3 Is Saturday service
is_tax_reg_override VARCHAR2 3 Is tax region override
is_visible_in_customer_center VARCHAR2 3 Is visible in customer center
is_weekend_delivery VARCHAR2 3 Is weekend delivery
license_exception VARCHAR2 4 License exception
license_number VARCHAR2 35 License number
memo VARCHAR2 4000 Memo. Enter an optional memo with additional information about this fulfillment. What you enter here can be used in searches and shows on reports.
message VARCHAR2 999 Message
method_of_transport VARCHAR2 64 Method of transport
needs_bill VARCHAR2 3 Needs bill
notification_email_message VARCHAR2 500 Notification email message
promotion_code_id NUMBER 39 0 Promotion code ID
reason_for_export VARCHAR2 20 Reason for export
recipient_customs_id VARCHAR2 64 Recipient customs ID
recipient_customs_id_type VARCHAR2 32 Recipient customs ID type
recipient_tax_id VARCHAR2 15 Recipient tax ID
return_type VARCHAR2 32 Return type
return_type_description VARCHAR2 30 Return type description
ship_notification_email VARCHAR2 100 Ship notification email
ship_notification_email_two VARCHAR2 100 Ship notification email 2
shipaddress VARCHAR2 999 Ship address
shipping_cost NUMBER 39 0 Shipping cost
shipping_item_id NUMBER 39 0 Shipping item ID
status VARCHAR2 4000 Status
tax_reg_id NUMBER 39 0 This field is no longer supported.
terms_freight_charge NUMBER 39 0 Terms freight charge
terms_insurance_charge NUMBER 39 0 Terms of insurance charge
terms_of_sale VARCHAR2 32 Terms of sale
title VARCHAR2 200 Title
total_package_weight_in_lbs NUMBER 39 0 Total package weight in pounds
tranid VARCHAR2 138 Tran ID
transaction_extid VARCHAR2 255 Transaction Extension ID
transaction_id NUMBER 39 0 Transaction ID
transfer_location_id NUMBER 39 0 Transfer location ID
use_backup_email VARCHAR2 3 Use backup email
use_fedex_ship_alert VARCHAR2 3 Use fedex ship alert
use_ship_notification_email VARCHAR2 3 Use ship notification email

 

Generated on 09-26-2022 for version 2022.2