Project
>
DEVSQL2016EA172
>
User databases
>
CoSample_17_2
>
Tables
> dbo.GLAccounts1
[dbo].[GLAccounts1]
Properties
Property
Value
Row Count (~)
0
Created
12:57:21 AM Thursday, March 21, 2019
Last Modified
1:15:19 AM Thursday, March 21, 2019
Columns
Key
Name
Data Type
Max Length (Bytes)
Allow Nulls
AccountID
int
4
False
timestamp
timestamp
8
True
Indexes
Key
Name
Key Columns
Unique
Fill Factor
PK_GLAccounts1
AccountID
True
80
SQL Script
CREATE
TABLE
[dbo]
.
[GLAccounts1]
(
[AccountID]
[int]
NOT
NULL
,
[timestamp]
[timestamp]
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[GLAccounts1]
ADD
CONSTRAINT
[PK_GLAccounts1]
PRIMARY
KEY
CLUSTERED
(
[AccountID]
)
ON
[PRIMARY]
GO
Used By
[dbo].[APChecks]
[dbo].[APPaymentDetails]
[dbo].[APPayments]
[dbo].[APVoucherDetails]
[dbo].[APVouchers]
[dbo].[ARFinCharges]
[dbo].[ARInvoiceDetails]
[dbo].[ARInvoices]
[dbo].[ARInvoiceTaxDetails]
[dbo].[ARReceiptDetails]
[dbo].[ARReceipts]
[dbo].[SCProposals]
[dbo].[SCProposalTaxDetails]
[dbo].[SCQBillings]
[dbo].[SCQBillingTaxDetails]