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]