<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > TrxTransactionDeliveryInformation Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
TrxTransactionDeliveryInformation Table
Collapse All Expand All
iVend Database Database : TrxTransactionDeliveryInformation Table |
Description
Stores the values for the delivery information for a transaction
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
0 |
Data Space Used |
0.00 KB |
Index Space Used |
0.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
DeliveryInformationKey |
Primary key |
VarWChar |
50 |
|
|
|
|
|
OrderDetailKey |
Reference for Transaction order key. See also Transaction order |
VarWChar |
50 |
|
|
|
|
TrackingNumber |
Stores the Tracking number of the Delivery |
VarWChar |
255 |
|
|
|
|
StampNumber |
Stores the Stamp number |
VarWChar |
255 |
|
|
|
|
Quantity |
Value is the quantity of the order item |
Numeric |
9 (20,5) |
|
|
|
|
PostingDate |
Refers to the Date on which shipment has been made |
DBTimeStamp |
4 |
|
|
|
|
DeliveryDate |
Refers the Delivery date of the order |
DBTimeStamp |
4 |
|
|
|
|
ShippingTypeKey |
Refers to the shipping type. |
VarWChar |
50 |
|
|
|
|
Comment |
The comment given with the delivery |
VarWChar |
255 |
|
|
|
|
Length |
Length of the Delivery packet |
Numeric |
9 (20,5) |
|
|
|
|
Width |
Width of the Delivery packet |
Numeric |
9 (20,5) |
|
|
|
|
Height |
Height of the Delivery packet |
Numeric |
9 (20,5) |
|
|
|
|
Volume |
Voulme of the Delivery packet |
Numeric |
9 (20,5) |
|
|
|
|
Weight |
Weight of the Delivery packet |
Numeric |
9 (20,5) |
|
|
|
|
DocumentNumber |
Stores the number of the series for the Document Type |
VarWChar |
50 |
|
|
|
|
DocumentType |
Stores the document type value for which the user wants to generate a number series. Valid values are PurchaseOrder = 0 StockTransfer = 1 GoodsReceipt = 2 GoodsIssue = 3 StockRequisition = 4 Sale = 5 Refund = 6 Exchange = 7 SpecialOrder = 8 Quotation = 9 ARPayment = 10 Layaway = 11 Delivery = 12 GoodsReceiptPO = 13 GoodsReceiptST = 14 DefaultSeries = 15 |
Integer |
4 |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[TrxTransactionDeliveryInformation]( [DeliveryInformationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OrderDetailKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TrackingNumber] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [StampNumber] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Quantity] [decimal](20, 5) NOT NULL, [PostingDate] [datetime] NULL, [DeliveryDate] [datetime] NULL, [ShippingTypeKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Comment] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Length] [decimal](20, 5) NULL, [Width] [decimal](20, 5) NULL, [Height] [decimal](20, 5) NULL, [Volume] [decimal](20, 5) NULL, [Weight] [decimal](20, 5) NULL, [DocumentNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DocumentType] [int] NOT NULL, CONSTRAINT [PK_TrxTransactionDeliveryInformation] PRIMARY KEY CLUSTERED ( [DeliveryInformationKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.