Return to:
Database Reference Home Page
Return to:
Table Definitions Master List
*Table Name*
vendor_purchasing_master
*Description*
System purchasing methods; defines the style of automatic purchasing used for a specific vendor. Each vendor may have one default purchasing method defined in the vendor_master table. These methods define the purchasing method label only; they do not define the actual formula or calculation.
*Schema*
CREATE TABLE vendor_purchasing_master (
"purchase_method_code" varchar(16) -- Purchase method code, used to reference purchasing method
NOT NULL,
"description" varchar(32), -- Description
"sort_order" int, -- Sort order
"default_flag" BOOLEAN DEFAULT false, -- Default purchasing method
UNIQUE (purchase_method_code)
);
There are no comments on this page. [Add comment]