1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
/****** Object: Table [dbo].[Payment_Diary] Script Date: 02/03/2012 10:41:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Payment_Diary](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Amount] [money] NULL,
[Document_ID] [int] NULL,
[Document_Reference] [varchar](50) NULL,
[Interchange_ID] [varchar](50) NULL,
[Payee_Account_Location] [varchar](50) NULL,
[Payee_Account_Name] [varchar](50) NULL,
[Payee_Account_Number] [varchar](50) NULL,
[Payer_Account_Location] [varchar](50) NULL,
[Payer_Account_Name] [varchar](50) NULL,
[Payer_Account_Number] [varchar](50) NULL,
[Payer_UserId] [varchar](14) NULL,
[Payment_Date] [datetime] NULL,
[Status_Date] [datetime] NULL,
[Status_Flag] [int] NULL,
[Stamp] [datetime] NULL,
[User_ID] [int] NULL,
[EmployerID] [int] NULL,
[SS_User_Document_ID] [int] NULL,
[Channel_Code] [varchar](50) NULL,
[Payer_Method_Flag] [char](10) NULL,
[Credit_Interval] [int] NULL,
[Payee_ABN] [varchar](14) NULL,
[Payee_Name] [varchar](50) NULL,
[Payee_Bank_Account_Flag] [char](1) NULL,
[Product_ID] [int] NULL,
[Product_Code] [varchar](50) NULL,
[Debit_Interval] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO |
Partager