Venture ERP Documentation : TableDefinitionHistoryBackOrderFill

Venture :: Categories :: PageIndex :: RecentChanges :: RecentlyCommented :: Login/Register
Return to: Database Reference Home Page
Return to: Table Definitions Master List

*Table Name*

history_back_order_fill

*Description*



*Schema*

CREATE TABLE history_back_order_fill (
    "company_id" integer
        NOT NULL,              -- Company ID
    "sales_order_header_id" integer
        NOT NULL,    -- SOH ID   
    "po_header_id" integer,                      -- PO ID for received line (optional)
    "source_code" varchar(8),                    -- Origin for this line ('PO'|'TRNS'|'ADJ'|'...')
    "warehouse_code" varchar(8)
        NOT NULL,       -- Sourcing warehouse code
    "line_number" numeric(5)
        NOT NULL,          -- Order Line number
    "quantity_received" numeric(15,2)            -- Quantity Received
        DEFAULT 0,
    "report_date" timestamp without time zone,  -- Date that this line was reported
    "report_series" integer                     -- Printing Group: Uses fill_report_seq
);

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by Wikka Wakka Wiki 1.1.6.3
Page was generated in 0.0422 seconds