Property | Value |
---|---|
Collation | SQL_Latin1_General_CP1_CI_AS |
Heap | True |
Row Count (~) | 0 |
Created | 12:56:48 AM Thursday, March 21, 2019 |
Last Modified | 12:56:48 AM Thursday, March 21, 2019 |
Name | Data Type | Max Length (Bytes) | Allow Nulls | Identity |
---|---|---|---|---|
ID | int | 4 | False | 1 - 1 |
InvoiceID | int | 4 | False | |
InvoiceNumber | varchar(15) | 15 | False | |
Date | datetime | 8 | False | |
Period | int | 4 | False | |
Item | varchar(255) | 255 | True | |
Description | varchar(1068) | 1068 | True | |
Quantity | decimal(29,6) | 17 | True | |
Price | decimal(21,6) | 13 | True | |
Cost | money | 8 | True | |
Amount | money | 8 | True | |
ItemID | int | 4 | True | |
WarehouseID | int | 4 | True | |
BinID | int | 4 | True | |
Outcost | money | 8 | True | |
OutcostExtended | money | 8 | True | |
Tax | numeric(10,2) | 9 | True | |
ItemType | varchar(37) | 37 | False | |
InvoiceType | varchar(16) | 16 | False | |
TransactionType | varchar(64) | 64 | False | |
SalesRepID | int | 4 | True | |
CustomerID | int | 4 | False | |
BillToID | int | 4 | False | |
BillCodeID | int | 4 | True | |
CallID | int | 4 | True | |
ContractID | int | 4 | True | |
EquipmentID | int | 4 | True | |
TransactionDetailBinID | int | 4 | True | |
SOID | int | 4 | True | |
SODetailID | int | 4 | True | |
DeptID | int | 4 | True | |
OriginalInvoiceNumber | varchar(15) | 15 | False | |
ARInvoiceLastUpdate | datetime | 8 | False | |
qryType | varchar(10) | 10 | False |