Skip to main content

Window: Shipment (Customer)

[Created: 19/12/1999 - Updated: 02/01/2000 ]
Description: Customer Inventory Shipments Customer Returns
Help: The Shipment Window defines shipments made or to be made to a customer. They are generated from an Customer Order. The Shipment Document will generate the Customer Invoice.

Tab: Shipment

[Created: 19/12/1999 - Updated: 30/09/2009 ]
Description: Shipments and Customer Returns
Help: The Shipments Tab allows you to generate, maintain, enter and process Shipments to a Customer or Returns from a Customer.
Tab Level: 0

Table 10: Shipment - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_inout.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_inout.AD_Org_ID numeric(10)
Table Direct
OrderOrderThe Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you close an order, unshipped (backordered) quantities are cancelled.m_inout.C_Order_ID numeric(10)
Search
Date OrderedDate of OrderIndicates the Date an item was ordered.m_inout.DateOrdered timestamp without time zone
Date
RMAReturn Material AuthorizationA Return Material Authorization may be required to accept returns and to create Credit Memosm_inout.M_RMA_ID numeric(10)
Search
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).m_inout.DocumentNo character varying(30)
String
Order ReferenceTransaction Reference Number (Sales Order, Purchase Order) of your Business PartnerThe business partner order reference is the order reference for this specific transaction; Often Purchase Order numbers are given to print on Invoices for easier reference. A standard number can be defined in the Business Partner (Customer) window.m_inout.POReference character varying(20)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inout.Description character varying(255)
Text
Document TypeDocument type or rulesThe Document Type determines document sequence and processing rulesm_inout.C_DocType_ID numeric(10)
Table
Movement DateDate a product was moved in or out of inventoryThe Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.m_inout.MovementDate timestamp without time zone
Date
Account DateAccounting DateThe Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion.m_inout.DateAcct timestamp without time zone
Date
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonm_inout.C_BPartner_ID numeric(10)
Search
Partner LocationIdentifies the (ship to) address for this Business PartnerThe Partner address indicates the location of a Business Partnerm_inout.C_BPartner_Location_ID numeric(10)
Table Direct
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactm_inout.AD_User_ID numeric(10)
Table Direct
WarehouseStorage Warehouse and Service PointThe Warehouse identifies a unique Warehouse where products are stored or Services are provided.m_inout.M_Warehouse_ID numeric(10)
Table Direct
PriorityPriority of a documentThe Priority indicates the importance (high, medium, low) of this documentm_inout.PriorityRule character(1)
List
Delivery RuleDefines the timing of DeliveryThe Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available.m_inout.DeliveryRule character(1)
List
Pick DateDate/Time when picked for Shipmentm_inout.PickDate timestamp without time zone
Date+Time
Sales RepresentativeSales Representative or Company AgentThe Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user.m_inout.SalesRep_ID numeric(10)
Table
Delivery ViaHow the order will be deliveredThe Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.m_inout.DeliveryViaRule character(1)
List
ShipperMethod or manner of product deliveryThe Shipper indicates the method of delivering productm_inout.M_Shipper_ID numeric(10)
Table
Create PackageCreate Package for Shipmentm_inout.CreatePackage character(1)
Button
Ship DateShipment Date/TimeActual Date/Time of Shipment (pick up)m_inout.ShipDate timestamp without time zone
Date+Time
No PackagesNumber of packages shippedm_inout.NoPackages numeric(10)
Integer
Tracking NoNumber to track the shipmentm_inout.TrackingNo character varying(60)
String
Freight Cost RuleMethod for charging FreightThe Freight Cost Rule indicates the method used when charging for freight.m_inout.FreightCostRule character(1)
List
Freight AmountFreight AmountThe Freight Amount indicates the amount charged for Freight in the document currency.m_inout.FreightAmt numeric
Amount
Freight Chargesm_inout.FreightCharges character varying(10)
List
Freight Termsm_inout.FOB character varying(10)
List
Insurancem_inout.Insurance character(1)
List
Shipper Account Numberm_inout.ShipperAccount character varying(40)
String
Create lines fromProcess which will generate a new document lines based on an existing documentThe Create From process will create a new document based on information in an existing document selected by the user.m_inout.CreateLinesFrom character(1)
Button
Drop ShipmentDrop Shipments are sent directly to the Drop Shipment LocationDrop Shipments are sent directly to the Drop Shipment Location using the Drop Ship Business Partner name and contact.m_inout.IsDropShip character(1)
Yes-No
Drop Ship Business PartnerBusiness Partner to ship toIf empty the business partner will be shipped to.m_inout.DropShip_BPartner_ID numeric(10)
Search
Drop Shipment LocationBusiness Partner Location for shipping tom_inout.DropShip_Location_ID numeric(10)
Table
Drop Shipment ContactBusiness Partner Contact for drop shipmentm_inout.DropShip_User_ID numeric(10)
Table
Alternate Return Addressm_inout.IsAlternateReturnAddress character(1)
Yes-No
Return Partnerm_inout.ReturnBPartner_ID numeric(10)
Search
Return Locationm_inout.ReturnLocation_ID numeric(10)
Table
Return User/Contactm_inout.ReturnUser_ID numeric(10)
Table
Generate Invoice from ReceiptCreate and process Invoice from this receipt. The receipt should be correct and completed.Generate Invoice from Receipt will create an invoice based on the selected receipt and match the invoice to that receipt. You can set the document number only if the invoice document type allows to set the document number manually.m_inout.GenerateTo character(1)
Button
ChargeAdditional document chargesThe Charge indicates a type of Charge (Handling, Shipping, Restocking)m_inout.C_Charge_ID numeric(10)
Table
Charge amountCharge AmountThe Charge Amount indicates the amount for an additional charge.m_inout.ChargeAmt numeric
Amount
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.m_inout.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingm_inout.C_Activity_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.m_inout.C_Campaign_ID numeric(10)
Table Direct
Trx OrganizationPerforming or initiating organizationThe organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.m_inout.AD_OrgTrx_ID numeric(10)
Table
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.m_inout.User1_ID numeric(10)
Search
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.m_inout.User2_ID numeric(10)
Search
Movement TypeMethod of moving the inventoryThe Movement Type indicates the type of movement (in, out, to production, etc)m_inout.MovementType character(2)
List
Create ConfirmationCreate Confirmations for the DocumentThe confirmations generated need to be processed (confirmed) before you can process this documentm_inout.CreateConfirm character(1)
Button
In TransitMovement is in transitMaterial Movement is in transit - shipped, but not received.The transaction is completed, if confirmed.m_inout.IsInTransit character(1)
Yes-No
Date ReceivedDate a product was receivedThe Date Received indicates the date that product was received.m_inout.DateReceived timestamp without time zone
Date
Document StatusThe current status of the documentThe Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action fieldm_inout.DocStatus character(2)
List
Process ShipmentProcess Shipment/Receipt (Update Inventory)Process Shipment/Receipt will move products out of/into inventory and mark line items as shipped/received.m_inout.DocAction character(2)
Button
In DisputeDocument is in disputeThe document is in dispute. Use Requests to track details.m_inout.IsInDispute character(1)
Yes-No
PostedPosting statusThe Posted field indicates the status of the Generation of General Ledger Accounting Linesm_inout.Posted character(1)
Button

Tab: Shipment Line

[Created: 19/12/1999 - Updated: 02/09/2005 ]
Description: Shipment Line
Help: The Shipment Line Tab defines the individual items in a Shipment.
Tab Level: 1

Table 20: Shipment Line - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_inoutline.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_inoutline.AD_Org_ID numeric(10)
Table Direct
Shipment/ReceiptMaterial Shipment DocumentThe Material Shipment / Receiptm_inoutline.M_InOut_ID numeric(10)
Search
Sales Order LineSales Order LineThe Sales Order Line is a unique identifier for a line in an order.m_inoutline.C_OrderLine_ID numeric(10)
Table Direct
Line NoUnique line for this documentIndicates the unique line for a document. It will also control the display order of the lines within a document.m_inoutline.Line numeric(10)
Integer
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_inoutline.M_Product_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.m_inoutline.M_AttributeSetInstance_ID numeric(10)
Product Attribute
LocatorWarehouse LocatorThe Locator indicates where in a Warehouse a product is located.m_inoutline.M_Locator_ID numeric(10)
Locator (WH)
ChargeAdditional document chargesThe Charge indicates a type of Charge (Handling, Shipping, Restocking)m_inoutline.C_Charge_ID numeric(10)
Table Direct
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inoutline.Description character varying(255)
Text
QuantityThe Quantity Entered is based on the selected UoMThe Quantity Entered is converted to base product UoM quantitym_inoutline.QtyEntered numeric
Quantity
UOMUnit of MeasureThe UOM defines a unique non monetary Unit of Measurem_inoutline.C_UOM_ID numeric(10)
Table Direct
Movement QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_inoutline.MovementQty numeric
Quantity
Picked Quantitym_inoutline.PickedQty numeric
Quantity
Target QuantityTarget Movement QuantityThe Quantity which should have been receivedm_inoutline.TargetQty numeric
Quantity
Confirmed QuantityConfirmation of a received quantityConfirmation of a received quantitym_inoutline.ConfirmedQty numeric
Quantity
Scrapped QuantityThe Quantity scrapped due to QA issuesm_inoutline.ScrappedQty numeric
Quantity
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.m_inoutline.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingm_inoutline.C_Activity_ID numeric(10)
Table Direct
Project PhasePhase of a Projectm_inoutline.C_ProjectPhase_ID numeric(10)
Table Direct
Project TaskActual Project Task in a PhaseA Project Task in a Project Phase represents the actual work.m_inoutline.C_ProjectTask_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.m_inoutline.C_Campaign_ID numeric(10)
Table Direct
Trx OrganizationPerforming or initiating organizationThe organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.m_inoutline.AD_OrgTrx_ID numeric(10)
Table
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.m_inoutline.User1_ID numeric(10)
Search
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.m_inoutline.User2_ID numeric(10)
Search
Auto ProduceAuto create production to fulfill shipmentm_inoutline.IsAutoProduce character(1)
Yes-No

Tab: Confirmations

[Created: 03/02/2005 - Updated: 22/05/2005 ]
Description: Optional Confirmations of Shipment Lines
Help: The quantities are in the storage Unit of Measure!
Tab Level: 2

Table 30: Confirmations - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_inoutlineconfirm.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_inoutlineconfirm.AD_Org_ID numeric(10)
Table Direct
Shipment/Receipt LineLine on Shipment or Receipt documentThe Shipment/Receipt Line indicates a unique line in a Shipment/Receipt documentm_inoutlineconfirm.M_InOutLine_ID numeric(10)
Search
Ship/Receipt ConfirmationMaterial Shipment or Receipt ConfirmationConfirmation of Shipment or Receipt - Created from the Shipment/Receiptm_inoutlineconfirm.M_InOutConfirm_ID numeric(10)
Search
Ship/Receipt Confirmation LineMaterial Shipment or Receipt Confirmation LineConfirmation detailsm_inoutlineconfirm.M_InOutLineConfirm_ID numeric(10)
ID
Confirmation NoConfirmation Numberm_inoutlineconfirm.ConfirmationNo character varying(20)
String
Target QuantityTarget Movement QuantityThe Quantity which should have been receivedm_inoutlineconfirm.TargetQty numeric
Quantity
Confirmed QuantityConfirmation of a received quantityConfirmation of a received quantitym_inoutlineconfirm.ConfirmedQty numeric
Quantity
DifferenceDifference Quantitym_inoutlineconfirm.DifferenceQty numeric
Quantity
Scrapped QuantityThe Quantity scrapped due to QA issuesm_inoutlineconfirm.ScrappedQty numeric
Quantity
DescriptionOptional short description of the recordA description is limited to 255 characters.m_inoutlineconfirm.Description character varying(255)
String

Tab: Attributes

[Created: 27/08/2005 - Updated: 16/03/2021 ]
Description: Product Instance Attribute Material Allocation
Help:
Tab Level: 2

Table 40: Attributes - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_inoutlinema.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_inoutlinema.AD_Org_ID numeric(10)
Table Direct
Shipment/Receipt LineLine on Shipment or Receipt documentThe Shipment/Receipt Line indicates a unique line in a Shipment/Receipt documentm_inoutlinema.M_InOutLine_ID numeric(10)
Search
Attribute Set InstanceProduct Attribute Set InstanceThe values of the actual Product Attribute Instances. The product level attributes are defined on Product level.m_inoutlinema.M_AttributeSetInstance_ID numeric(10)
Product Attribute
Movement QuantityQuantity of a product moved.The Movement Quantity indicates the quantity of a product that has been moved.m_inoutlinema.MovementQty numeric
Quantity
Date Material PolicyTime used for LIFO and FIFO Material PolicyThis field is used to record time used for LIFO and FIFO material policym_inoutlinema.DateMaterialPolicy timestamp without time zone
Date
Auto GeneratedRecord is Auto Generated by System.m_inoutlinema.IsAutoGenerated character(1)
Yes-No

Tab: Packages

[Created: 06/12/2012 - Updated: 06/12/2012 ]
Description:
Help:
Tab Level: 1

Table 50: Packages - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_package.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_package.AD_Org_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).m_package.DocumentNo character varying(30)
String
Shipment/ReceiptMaterial Shipment DocumentThe Material Shipment / Receiptm_package.M_InOut_ID numeric(10)
Search
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.m_package.IsActive character(1)
Yes-No
Latest Pickup Timem_package.LatestPickupTime timestamp without time zone
Time
Date ReceivedDate a product was receivedThe Date Received indicates the date that product was received.m_package.DateReceived timestamp without time zone
Date
Info ReceivedInformation of the receipt of the package (acknowledgement)m_package.ReceivedInfo character varying(255)
String
WeightWeight of a productThe Weight indicates the weight of the product in the Weight UOM of the Tenantm_package.Weight numeric
Quantity
UOM for WeightStandard Unit of Measure for WeightThe Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.m_package.C_UOM_Weight_ID numeric(10)
Table
Lengthm_package.Length numeric
Quantity
UOM for LengthStandard Unit of Measure for LengthThe Standard UOM for Length indicates the UOM to use for products referenced by length in a document.m_package.C_UOM_Length_ID numeric(10)
Table
Widthm_package.Width numeric
Quantity
Heightm_package.Height numeric
Quantity
ShipperMethod or manner of product deliveryThe Shipper indicates the method of delivering productm_package.M_Shipper_ID numeric(10)
Table
Ship Date (For FedEx only)Shipment Date/TimeActual Date/Time of Shipment (pick up)m_package.ShipDate timestamp without time zone
Date
Box Countm_package.BoxCount numeric(10)
Integer
Shipper Packagingm_package.M_ShipperPackaging_ID numeric(10)
Table
Shipper Labelsm_package.M_ShipperLabels_ID numeric(10)
Table
Shipper Pickup Typesm_package.M_ShipperPickupTypes_ID numeric(10)
Table
Insured Amountm_package.InsuredAmount numeric
Amount
Shipper Account Numberm_package.ShipperAccount character varying(40)
String
Duties Shipper Account (For FedEx only)m_package.DutiesShipperAccount character varying(40)
String
Partner Location (For UPS only)Identifies the (ship to) address for this Business PartnerThe Partner address indicates the location of a Business Partnerm_package.C_BPartner_Location_ID numeric(10)
Table Direct
Handling Chargem_package.HandlingCharge numeric
Amount
Added Handling (For UPS only)m_package.IsAddedHandling character(1)
Yes-No
CODm_package.CashOnDelivery character(1)
Yes-No
Payment RuleHow you pay the invoiceThe Payment Rule indicates the method of invoice payment.m_package.PaymentRule character(1)
List
Delivery ConfirmationEMail Delivery confirmationm_package.DeliveryConfirmation character(1)
Yes-No
Delivery Confirmation Type (For FedEx only)m_package.DeliveryConfirmationType character varying(30)
List
Verbal Confirmation (For UPS only)m_package.IsVerbalConfirmation character(1)
Yes-No
Saturday Deliverym_package.IsSaturdayDelivery character(1)
Yes-No
Saturday Pickupm_package.IsSaturdayPickup character(1)
Yes-No
Future Day Shipment (For FedEx only)m_package.IsFutureDayShipment character(1)
Yes-No
Residentialm_package.IsResidential character(1)
Yes-No
Home Delivery Premium Type (For FedEx only)m_package.HomeDeliveryPremiumType character varying(30)
List
Phone Number (For FedEx only)m_package.HomeDeliveryPremiumPhone character varying(30)
String
Date (For FedEx only)m_package.HomeDeliveryPremiumDate timestamp without time zone
Date
Hazardous Materials (For FedEx only)m_package.IsHazMat character(1)
Yes-No
Dot Hazard Class or Division (For FedEx only)m_package.DotHazardClassOrDivision character varying(30)
List
Cargo Aircraft Only (For FedEx only)m_package.IsCargoAircraftOnly character(1)
Yes-No
Accessible (For FedEx only)m_package.IsAccessible character(1)
Yes-No
Dry Ice (For FedEx only)m_package.IsDryIce character(1)
Yes-No
Dry Ice Weight (For FedEx only)m_package.DryIceWeight numeric
Amount
Hold At Location (For FedEx only)m_package.IsHoldAtLocation character(1)
Yes-No
Hold Address (For FedEx only)m_package.HoldAddress_ID numeric(10)
Table
Ignore Zip State Not Matchm_package.IsIgnoreZipStateNotMatch character(1)
Yes-No
Ignore Zip Not Foundm_package.IsIgnoreZipNotFound character(1)
Yes-No
Dutiablem_package.IsDutiable character(1)
Yes-No
Notification TypeType of NotificationsEmails or Notification sent out for Request Updates, etc.m_package.NotificationType character varying(2)
List
Notification Messagem_package.NotificationMessage character varying(255)
String
Online Shipping Rate Inquirym_package.ShippingRateInquiry character(1)
Button
Void Shipment OnlineVoid shipment using web services provided by shipperm_package.VoidIt character(1)
Button
Process Shipment OnlineCreate shipment using web services provided by shipperm_package.OProcessing character(1)
Button
Print Shipping LabelPrint shipping labelPrint shipping label return from online shipping services.m_package.LabelPrint character(1)
Button
PricePriceThe Price indicates the Price for a product or service.m_package.Price numeric
Costs+Prices
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordm_package.C_Currency_ID numeric(10)
Table Direct
Surchargesm_package.Surcharges numeric
Costs+Prices
Tracking NoNumber to track the shipmentm_package.TrackingNo character varying(255)
String
Tracking Infom_package.TrackingInfo character varying(255)
String
Rate Inquiry Messagem_package.RateInquiryMessage character varying(2000)
Text
Response Messagem_package.ShippingRespMessage character varying(2000)
Text
DescriptionOptional short description of the recordA description is limited to 255 characters.m_package.Description character varying(255)
String
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.m_package.Processed character(1)
Yes-No

Tab: MPS Lines

[Created: 06/12/2012 - Updated: 06/12/2012 ]
Description:
Help:
Tab Level: 2

Table 60: MPS Lines - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_packagemps.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_packagemps.AD_Org_ID numeric(10)
Table Direct
PackageShipment PackageA Shipment can have one or more Packages. A Package may be individually tracked.m_packagemps.M_Package_ID numeric(10)
Search
SequenceMethod of ordering records; lowest number comes firstThe Sequence indicates the order of recordsm_packagemps.SeqNo numeric(10)
Integer
DescriptionOptional short description of the recordA description is limited to 255 characters.m_packagemps.Description character varying(255)
String
Master Tracking Nom_packagemps.MasterTrackingNo character varying(255)
String
Tracking NoNumber to track the shipmentm_packagemps.TrackingNo character varying(255)
String
PricePriceThe Price indicates the Price for a product or service.m_packagemps.Price numeric
Costs+Prices
WeightWeight of a productThe Weight indicates the weight of the product in the Weight UOM of the Tenantm_packagemps.Weight numeric
Quantity
UOM for WeightStandard Unit of Measure for WeightThe Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.m_packagemps.C_UOM_Weight_ID numeric(10)
Table
Lengthm_packagemps.Length numeric
Quantity
UOM for LengthStandard Unit of Measure for LengthThe Standard UOM for Length indicates the UOM to use for products referenced by length in a document.m_packagemps.C_UOM_Length_ID numeric(10)
Table
Widthm_packagemps.Width numeric
Quantity
Heightm_packagemps.Height numeric
Quantity
Create lines fromProcess which will generate a new document lines based on an existing documentThe Create From process will create a new document based on information in an existing document selected by the user.m_packagemps.CreateFrom character(1)
Button
ProcessedThe document has been processedThe Processed checkbox indicates that a document has been processed.m_packagemps.Processed character(1)
Yes-No

Tab: Package Lines

[Created: 06/12/2012 - Updated: 06/12/2012 ]
Description:
Help:
Tab Level: 3

Table 70: Package Lines - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.m_packageline.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.m_packageline.AD_Org_ID numeric(10)
Table Direct
Package MPSm_packageline.M_PackageMPS_ID numeric(10)
Search
PackageShipment PackageA Shipment can have one or more Packages. A Package may be individually tracked.m_packageline.M_Package_ID numeric(10)
Search
Shipment/Receipt LineLine on Shipment or Receipt documentThe Shipment/Receipt Line indicates a unique line in a Shipment/Receipt documentm_packageline.M_InOutLine_ID numeric(10)
Table Direct
QuantityQuantityThe Quantity indicates the number of a specific product or item for this document.m_packageline.Qty numeric
Quantity
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.m_packageline.M_Product_ID numeric(10)
Search
DescriptionOptional short description of the recordA description is limited to 255 characters.m_packageline.Description character varying(255)
String