Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
[...] order is due to the customer. ShipDate datetime null Date the order was shipped to the customer. Status tinyint not null ((1)) Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled OnlineOrderFlag dbo.Flag not null ((1)) 0 = Order placed by sales person. 1 = Order placed online by customer. SalesOrderNumber Unique sales order identification number. PurchaseOrderNumber dbo.OrderNumber null Customer purchase order number reference. AccountNumber dbo.AccountNumber null [...]
wikibot
Table public.location_specific_status_changes Columns Column Data Type Nullable Default Description id integer not null locationmonitorid integer not null ifserviceid integer not null statuscode integer not null statustime timestamp with time zone not null statusreason varchar(255) null responsetime double precision null Primary Key Primary Key Columns location_specific_status_changes_pkey id Indexes Index Type Columns location_specific_status_changes_ifserviceid [...]
[...] RevisionNumber tinyint not null ((0)) Incremental number to track changes to the purchase order over time. Status tinyint not null ((1)) Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete EmployeeID int not null Employee who created the purchase order. Foreign key to Employee.EmployeeID. VendorID int not null Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID. ShipMethodID int not null Shipping method. Foreign key to ShipMethod.ShipMethodID. OrderDate datetime not null (getdate()) Purchase [...]
[...] timestamp with time zone null lastfail timestamp with time zone null qualifier char(16) null status char(1) null source char(1) null notify char(1) null ipinterfaceid integer not null Primary Key Primary Key Columns ifservices_pkey id Indexes Index Type Columns ifservices_nodeid_idx nodeid ifservices_nodeid_ipaddr_status nodeid, ipaddr, status ifservices_nodeid_ipaddr_svc_unique nodeid, ipaddr, serviceid ifservices_nodeid_serviceid_idx nodeid, serviceid ifservices_nodeid_
[...] dbo.ufnGetDocumentStatusText Description Scalar function returning the text representation of the Status column in the Document table. Source
CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [tinyint])
RETURNS [nvarchar](16)
AS
-- Returns the sales order status [...]
[...] VARCHAR2(30) not null product package size SUPPLIER_ID NUMBER(6, 0) not null this column PROD_STATUS VARCHAR2(20) not null product status PROD_LIST_PRICE NUMBER(8, 2) not null product list price PROD_MIN_PRICE NUMBER(8, 2) not null product minimum price PROD_TOTAL VARCHAR2(13) not null PROD_TOTAL_ID NUMBER not null PROD_SRC_ID NUMBER null PROD_EFF_FROM DATE(7) null PROD_EFF_TO DATE(7) null PROD_VALID VARCHAR2(1) null Primary Key Primary Key Columns PRODUCTS_PK PROD_ID Indexes Index Type [...]
[...] Revision number of the document. ChangeNumber int not null ((0)) Engineering change approval number. Status tinyint not null 1 = Pending approval, 2 = Approved, 3 = Obsolete DocumentSummary nvarchar(max) null Document abstract. Document varbinary(max) null Complete document. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Document_DocumentID DocumentID Indexes Index Type Columns AK_Document_FileName_Revision Unique FileName, Revision Check Constraints Check Constraint [...]
[...] dbo.ufnGetPurchaseOrderStatusText Description Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. Source
CREATE FUNCTION [dbo].[ufnGetPurchaseOrderStatusText](@Status [tinyint])
RETURNS [nvarchar](15)
AS
-- Returns the sales order status [...]
[...] dbo.ufnGetSalesOrderStatusText Description Scalar function returning the text representation of the Status column in the SalesOrderHeader table. Source
CREATE FUNCTION [dbo].[ufnGetSalesOrderStatusText](@Status [tinyint])
RETURNS [nvarchar](15)
AS
-- Returns the sales order status [...]
[...] bitmap SUPPLIER_ID NUMBER(6, 0) null Offers possibility of extensions outside Common Schema. PRODUCT_STATUS VARCHAR2(20) null Check constraint. Appropriate for complex rules, such as "All products in LIST_PRICE NUMBER(8, 2) null MIN_PRICE NUMBER(8, 2) null CATALOG_URL VARCHAR2(50) null Primary Key Primary Key Columns PRODUCT_INFORMATION_PK PRODUCT_ID Indexes Index Type Columns PROD_SUPPLIER_IX SUPPLIER_ID Check Constraints Check Constraint Expression Description PRODUCT_STATUS_LOV [...]
[...] null lastpolltime timestamp without time zone not null pathtofile varchar(256) not null status char(1) not null Indexes Index Type Columns inventory_lastpolltime_idx lastpolltime inventory_nodeid_idx nodeid inventory_nodeid_name_idx nodeid, name inventory_status_idx [...]
[...] cardinality attribute CUST_YEAR_OF_BIRTH NUMBER(4, 0) not null customer year of birth CUST_MARITAL_STATUS VARCHAR2(20) null customer marital status; low cardinality attribute CUST_STREET_ADDRESS VARCHAR2(40) not null customer street address CUST_POSTAL_CODE VARCHAR2(10) not null postal code of the customer CUST_CITY VARCHAR2(30) not null city where the customer lives CUST_CITY_ID NUMBER not null CUST_STATE_PROVINCE VARCHAR2(40) not null customer geography: state or province CUST_STATE_PROVINCE_ID NUMBER not null COUNTRY_ID [...]
[...] public.location_monitors Columns Column Data Type Nullable Default Description id integer not null status varchar(31) not null lastcheckintime timestamp with time zone null definitionname varchar(31) not null Primary Key Primary Key Columns location_monitors_pkey id Detail Tables Detail Table Column Referencing Column public.location_monitor_details id locationmonitorid public.location_specific_status_changes [...]
[...] order_id NUMBER(12)
, order_mode VARCHAR2(8)
, customer_ref REF customer_typ
, order_status NUMBER(2)
, order_total NUMBER(8,2)
[...]
[...] o.order_id, o.order_mode,
MAKE_REF(oc_customers,o.customer_id),
o.order_status,
o.order_total,o.sales_rep_id,
[...]
[...] OE.OC_ORDERS AS
SELECT o.order_id, o.order_mode,MAKE_REF(oc_customers,o.customer_id),
o.order_status,o.order_total,o.sales_rep_id,
CAST(MULTISET(SELECT [...]
[...] o.order_id, o.order_mode,
MAKE_REF(oc_customers,o.customer_id),
o.order_status,
o.order_total,o.sales_rep_id,
[...]
[...] p.product_description, p.category_id,
p.weight_class, p.warranty_period, p.supplier_id, p.product_status,
p.list_price, p.min_price, p.catalog_url,
[...]
[...] NUMBER(1)
, warranty_period INTERVAL YEAR(2) TO MONTH
, supplier_id NUMBER(6)
, product_status VARCHAR2(20)
, list_price NUMBER(8,2)
[...]
[...] AS product_description
, i.weight_class
, i.warranty_period
, i.supplier_id
, i.product_status
, i.list_price
, i.min_price
, i.catalog_url
FROM [...]
[...] TO_DATE(TO_CHAR(order_date,'DD-MON-YY HH:MI:SS'),'DD-MON-YY HH:MI:SS') ORDER_DATE,
order_mode,
customer_id,
order_status,
order_total,
sales_rep_id,
promotion_id
FROM [...]
[...] constraint. ORDER_MODE VARCHAR2(8) null CHECK constraint. CUSTOMER_ID NUMBER(6, 0) not null ORDER_STATUS NUMBER(2, 0) null 0: Not fully entered, [...]
[...] PayFrequency Rate (table) EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status Availability CostRate Class DaysToManufacture [...]
[...] ipinterface.nodeid = nid AND ipinterface.ipaddr = ipid AND ipinterface.ismanaged = 'M' AND ifservices.status = 'A'
LOOP
BEGIN
downtime := downtime [...]
[...] ipinterface.nodeid = nid AND ipinterface.ismanaged = 'M' AND ifservices.ipaddr = ipinterface.ipaddr AND ifservices.status = 'A' AND node.nodeid = nid and node.nodetype [...]
[...] ipinterface.nodeid = nid
AND ipinterface.ipaddr = ipid
AND ipinterface.ismanaged = 'M'
AND ifservices.status = 'A'
LOOP
BEGIN
counter := counter [...]
[...] (public)
location_monitor_details (public)
location_monitors (public)
location_specific_status_changes (public)
map (public)
node [...]
[...] nodeid integer not null ipaddr varchar(16) not null atphysaddr varchar(12) not null status char(1) not null sourcenodeid integer [...]
[...] ifindex integer not null nodeparentid integer not null parentifindex integer not null status char(1) not null lastpolltime timestamp [...]
[...] ipinterface.ismanaged = 'M'
AND ifservices.ipaddr = ipinterface.ipaddr
AND ifservices.status = 'A'
LOOP
BEGIN
[...]