itemfulfillment
Stores records of item fulfillment transactions, detailing how and when items are shipped to customers.
Columns
| Name | Type | References | Description |
| accessibilitytypefedex | String | Specifies the accessibility type for FedEx shipments, determining the level of delivery access required. | |
| ancillaryendorsementfedex | String | Indicates the type of ancillary service endorsement for FedEx, used for special handling or return services. | |
| b13afilingoptionfedex | String | Defines the B13A filing option for FedEx, required for exporting goods from Canada and subject to customs regulations. | |
| b13astatementdatafedex | String | Contains additional details related to the B13A filing for FedEx, ensuring compliance with Canadian export documentation. | |
| backupemailaddressups | String | Stores an alternative email address for UPS notifications, used in case the primary email is unavailable. | |
| balance | Decimal | Represents the outstanding balance associated with the fulfillment, reflecting any unpaid amounts. | |
| bookingconfirmationnumfedex | String | A unique booking confirmation number for FedEx shipments, used for tracking and managing scheduled pickups. | |
| certifiedmailusps | Boolean | Indicates whether the shipment is sent via USPS Certified Mail, which provides proof of mailing and delivery tracking. | |
| consolidatebalance | Decimal | Reflects the combined outstanding balance across multiple transactions or fulfillments. | |
| createddate | Datetime | Records the date and time when the fulfillment record was created in the system. | |
| createdfrom | String | References the source record (such as a sales order) from which this fulfillment was generated. | |
| createdfromshipgroup | Integer | Identifies the specific shipment group associated with the source transaction for this fulfillment. | |
| customform | String | Specifies the custom form template used for this fulfillment, allowing for customized document layouts. | |
| entity | String | Represents the customer, vendor, or other entity associated with this fulfillment transaction. | |
| exchangerate | String | Indicates the exchange rate applied if the transaction involves currency conversion. | |
| externalid | String | Stores a unique identifier from an external system, allowing integration and tracking across different platforms. | |
| haladdressfedex | String | Provides the Hold at Location (HAL) address for FedEx shipments, specifying the pickup location for the recipient. | |
| halphonefedex | String | Lists the contact phone number for the FedEx HAL service, ensuring recipient verification. | |
| handlingcost | Decimal | Represents the total handling charges applied to the fulfillment, covering packing and processing expenses. | |
| hazmattypefedex | String | Specifies the hazardous material classification for FedEx shipments, ensuring compliance with safety regulations. | |
| holdatlocationfedex | Boolean | Indicates whether the FedEx shipment is being held at a designated FedEx location for pickup instead of home delivery. | |
| insidedeliveryfedex | Boolean | Specifies whether FedEx should provide inside delivery, meaning the package is delivered beyond the front door. | |
| insidepickupfedex | Boolean | Indicates whether FedEx is required to pick up the package from inside a facility rather than curbside. | |
| isbasecurrency | Boolean | Denotes whether the transaction is in the base currency of the subsidiary or company. | |
| iscargoaircraftonlyfedex | Boolean | Marks the package as restricted to cargo aircraft only for FedEx shipments due to hazardous material regulations. | |
| lastmodifieddate | Datetime | Records the most recent date and time when the fulfillment record was modified. | |
| memo | String | Stores any additional notes, comments, or references related to an individual item fulfillment record. | |
| packeddate | Date | Records the date when the items in this fulfillment were packed and prepared for shipment. | |
| pickeddate | Date | Records the date when the items in this fulfillment were picked from inventory for packing. | |
| postingperiod | String | Indicates the accounting period in which the fulfillment is posted, relevant for financial reporting. | |
| requestedby | String | Identifies the person or entity that requested the fulfillment, providing tracking for internal operations. | |
| shipaddress | String | Specifies the detailed shipping address where the fulfillment is being delivered. | |
| shipaddresslist | String | References a predefined list of shipping addresses associated with the customer or entity. | |
| shipcompany | String | Stores the name of the shipping company responsible for delivering the fulfillment. | |
| shipcountry | String | Indicates the destination country where the items in a particular fulfillment transaction are being shipped. | |
| shipisresidential | Boolean | Marks whether the shipping address is a residential location, which can affect delivery fees and restrictions. | |
| shipmentprocessed | Boolean | Indicates whether the shipment has been processed in the system, confirming that the order is ready for dispatch. | |
| shipmentweightfedex | String | Records the total weight of the shipment as measured for FedEx deliveries. | |
| shipmentweightups | String | Records the total weight of the shipment as measured for UPS deliveries. | |
| shipmentweightusps | String | Records the total weight of the shipment as measured for USPS deliveries. | |
| shipmethod | String | Specifies the shipping method or carrier service selected for this fulfillment. | |
| shipoverride | Boolean | Indicates whether the default shipping method was overridden manually for this fulfillment. | |
| shippeddate | Date | Records the date when the shipment was officially dispatched to the recipient. | |
| shipphone | String | Stores the contact phone number associated with the shipping address for delivery communication. | |
| shippingaddress | String | Contains the complete shipping address details, including street, city, state, and postal code. | |
| shippingcost | Decimal | Records the total cost of shipping applied to this fulfillment, including carrier charges and fees. | |
| shipstatus | String | Indicates the current status of the shipment, such as pending, shipped, or delivered. | |
| status | String | Represents the overall status of the fulfillment, tracking its progress from creation to completion. | |
| statusRef | String | References the internal system status for the fulfillment, used for backend processing. | |
| subsidiary | String | Identifies the subsidiary associated with this fulfillment, relevant for multi-entity businesses. | |
| termsofsalefedex | String | Specifies the terms of sale applicable to this FedEx shipment, outlining the responsibilities of the buyer and seller. | |
| trandate | Date | Records the transaction date of the fulfillment, used for financial and operational tracking. | |
| tranid | String | Stores the unique transaction ID assigned to this fulfillment, ensuring system-wide identification. |