Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    Supplier Bill Detail

    Uploaded by

    gauravchau

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Supplier Bill Detail

    Uploaded by

    gauravchau
    18 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    18 views1 page

    Supplier Bill Detail

    Uploaded by

    gauravchau

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 1

    if exists (select * from dbo.sysobjects where id = object_id(N'[DivUsr].

    [Supplier_Bill_Detail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)


    drop table [DivUsr].[Supplier_Bill_Detail]
    GO

    CREATE TABLE [DivUsr].[Supplier_Bill_Detail] (


    [Bill_RecNo] [int] NULL ,
    [RecNo] [int] IDENTITY (1, 1) NOT NULL ,
    [Item_Sub_Code] [int] NULL ,
    [Item_Qty] [decimal](18, 2) NULL ,
    [Item_Rate] [decimal](18, 2) NULL ,
    [Item_Amount] [decimal](18, 2) NULL ,
    [AddBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [AddDt] [datetime] NULL ,
    [ModifyBy] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [ModifyDt] [datetime] NULL
    ) ON [PRIMARY]
    GO

    You might also like