Tables [dbo].[SOSARInvoicesEX]
PropertyValue
HeapTrue
Row Count (~)0
Created1:00:52 AM Thursday, March 21, 2019
Last Modified1:00:52 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
InvoiceIDint4
False
FirstPayDatedatetime8
True
FPReceiptIDint4
True
FPDetailIDint4
True
PayFullDatedatetime8
True
PFReceiptIDint4
True
PFDetailIDint4
True
LastUpdatedatetime8
True
BillToIDint4
False
DueDaysToPayint4
True
BilledDaysToPayint4
True
PaidLateint4
True
TermsDaysint4
True
DaysLateint4
True
CREATE TABLE [dbo].[SOSARInvoicesEX]
(
[InvoiceID] [int] NOT NULL,
[FirstPayDate] [datetime] NULL,
[FPReceiptID] [int] NULL,
[FPDetailID] [int] NULL,
[PayFullDate] [datetime] NULL,
[PFReceiptID] [int] NULL,
[PFDetailID] [int] NULL,
[LastUpdate] [datetime] NULL,
[BillToID] [int] NOT NULL,
[DueDaysToPay] [int] NULL,
[BilledDaysToPay] [int] NULL,
[PaidLate] [int] NULL,
[TermsDays] [int] NULL,
[DaysLate] [int] NULL
) ON [PRIMARY]
GO