Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:58:42 AM Thursday, March 21, 2019 |
Last Modified | 12:58:42 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls |
---|---|---|---|
ItemID | int | 4 | True |
StandardQty | decimal(18,0) | 9 | True |
OnHandQty | decimal(18,0) | 9 | True |
AvailableQty | decimal(18,0) | 9 | True |
Allocated | decimal(18,0) | 9 | True |
Rcv30 | decimal(18,0) | 9 | True |
Rcv60 | decimal(18,0) | 9 | True |
Rcv90 | decimal(18,0) | 9 | True |
Rcv120 | decimal(18,0) | 9 | True |
Rcv150 | decimal(18,0) | 9 | True |
RcvOver | decimal(18,0) | 9 | True |
Sales30 | decimal(18,0) | 9 | True |
Sales60 | decimal(18,0) | 9 | True |
Sales90 | decimal(18,0) | 9 | True |
Sales120 | decimal(18,0) | 9 | True |
Sales150 | decimal(18,0) | 9 | True |
SalesOver | decimal(18,0) | 9 | True |
AvgCost | money | 8 | True |
ItemDesc | varchar(256) | 256 | True |
Category | varchar(60) | 60 | True |
InvCode | varchar(50) | 50 | True |
SalesCode | varchar(50) | 50 | True |
ServiceCode | varchar(50) | 50 | True |
Model | varchar(128) | 128 | True |
Serialized | bit | 1 | True |
Item | varchar(64) | 64 | True |
Updated | datetime | 8 | True |