Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help with Trigger

Author  Topic 

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-02 : 10:21:51
I'm attempting to create the following trigger. I'm obviously doing something wrong because I'm getting the following error:

Incorrect syntax near the keyword 'FROM'.

CREATE TRIGGER USR_TR_Adjust_Loyalty_Points ON dbo.PS_DOC_HDR
AFTER INSERT
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

BEGIN
UPDATE AR
       SET AR.LOY_PTS_BAL =
                 CASE
                   WHEN (AR.LOY_PTS_BAL >= 750)
                                   THEN (AR.LOY_PTS_BAL - 750)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 500 AND 749)
                                   THEN (AR.LOY_PTS_BAL - 500)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 250 AND 499)
                                   THEN (AR.LOY_PTS_BAL - 250)
                   ELSE AR.LOY_PTS_BAL
	   FROM inserted AS I
			JOIN dbo.PS_DOC_HDR as PS
				ON PS.CUST_NO = I.CUST_NO
			JOIN AR_CUST AS AR
				ON AR.CUST_NO = PS.CUST_NO 
					AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T'
END
go

To clarify, I have two tables: PS_DOC_HDR and AR_CUST. I am joining the tables using non-primary key columns. What I am trying to do is subtract 750, 500, or 250 from the AR_CUST.LOY_PTS_BAL column after a new column is inserted into the PS_DOC_HDR table.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2011-08-02 : 10:26:42
The syntax error is due to a a missing "END".
CREATE TRIGGER USR_TR_Adjust_Loyalty_Points ON dbo.PS_DOC_HDR
AFTER INSERT
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

BEGIN
UPDATE AR
       SET AR.LOY_PTS_BAL =
                 CASE
                   WHEN (AR.LOY_PTS_BAL >= 750)
                                   THEN (AR.LOY_PTS_BAL - 750)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 500 AND 749)
                                   THEN (AR.LOY_PTS_BAL - 500)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 250 AND 499)
                                   THEN (AR.LOY_PTS_BAL - 250)
                   ELSE AR.LOY_PTS_BAL
                 END
	   FROM inserted AS I
			JOIN dbo.PS_DOC_HDR as PS
				ON PS.CUST_NO = I.CUST_NO
			JOIN AR_CUST AS AR
				ON AR.CUST_NO = PS.CUST_NO 
					AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T'
END
go
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-02 : 11:03:02
Thank you! That's what I missed. Also is there a way to make this trigger ONLY run against the last column that is inserted in the PS_DOC_HDR table? Since there is a column (PS_DOC_HDR.TKT_DT) that is assigned the current date stamp, I was going to use "where PS.TKT_DT = within the last 5 seconds." But maybe there is a better way?

CREATE TRIGGER USR_TR_Adjust_Loyalty_Points ON dbo.PS_DOC_HDR
AFTER INSERT
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

BEGIN
UPDATE AR
       SET AR.LOY_PTS_BAL =
                 CASE
                   WHEN (AR.LOY_PTS_BAL >= 750)
                                   THEN (AR.LOY_PTS_BAL - 750)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 500 AND 749)
                                   THEN (AR.LOY_PTS_BAL - 500)
                   WHEN (AR.LOY_PTS_BAL BETWEEN 250 AND 499)
                                   THEN (AR.LOY_PTS_BAL - 250)
                   ELSE AR.LOY_PTS_BAL
                 END
	   FROM inserted AS I
			JOIN dbo.PS_DOC_HDR as PS
				ON PS.CUST_NO = I.CUST_NO
			JOIN AR_CUST AS AR
				ON AR.CUST_NO = PS.CUST_NO 
					AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T' AND PS.TKT_DT = date within the last 5 seconds
END
go
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2011-08-02 : 13:11:16
You can order the results by TKT_DT desc and then update only the top 1 column - see if this would work for you. First uncomment the SELECT * FROM CTE; and run only upto that. That will show you the values before the update and what they will be updated to. If you are satisfied with that, comment the select and run the query.
;WITH cte AS
(
   SELECT
      AR.LOY_PTS_BAL,
      AR.LOY_PTS_BAL,
      ROW_NUMBER() OVER (/*Partition by somecolumn if required*/ ORDER BY PS.TKT_DT DESC) AS RN
   FROM
      inserted AS I
      JOIN dbo.PS_DOC_HDR as PS
         ON PS.CUST_NO = I.CUST_NO
      JOIN AR_CUST AS AR
         ON AR.CUST_NO = PS.CUST_NO 
            AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T' 
)
--SELECT * FROM cte;
UPDATE cte SET
 AR.LOY_PTS_BAL =
	 CASE
	   WHEN (AR.LOY_PTS_BAL >= 750)
					   THEN (AR.LOY_PTS_BAL - 750)
	   WHEN (AR.LOY_PTS_BAL BETWEEN 500 AND 749)
					   THEN (AR.LOY_PTS_BAL - 500)
	   WHEN (AR.LOY_PTS_BAL BETWEEN 250 AND 499)
					   THEN (AR.LOY_PTS_BAL - 250)
	   ELSE AR.LOY_PTS_BAL
	 END
WHERE RN = 1;
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-02 : 14:06:45
Thanks sunitabeck. When trying to run the following, I get the error "Invalid object name 'inserted'."

;WITH cte AS
(
   SELECT
      AR.LOY_PTS_BAL,
      AR.LOY_PTS_BAL,
      ROW_NUMBER() OVER (/*Partition by somecolumn if required*/ ORDER BY PS.TKT_DT DESC) AS RN
   FROM
      inserted AS I
      JOIN dbo.PS_DOC_HDR as PS
         ON PS.CUST_NO = I.CUST_NO
      JOIN AR_CUST AS AR
         ON AR.CUST_NO = PS.CUST_NO 
            AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T' 
)
SELECT * FROM cte;
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2011-08-02 : 14:20:06
The INSERTED virtual table is something that is available only inside the trigger code. So you cannot run it from outside. You would need to insert the code in the trigger and do the insert/update action that would cause the trigger to be invoked in order to test it. Alternatively, you can insert the row that is inserted/updated into a temp table and then join with that temp table instead of the INSERTED table.
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-02 : 14:26:50
Ok, I got it now. Sorry for being so new at this. So I ran this:

CREATE TRIGGER USR_TR_Adjust_Loyalty_Points ON dbo.PS_DOC_HDR
AFTER INSERT
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

BEGIN
;WITH cte AS
(
   SELECT
      AR.LOY_PTS_BAL,
      AR.LOY_PTS_BAL,
      ROW_NUMBER() OVER (/*Partition by somecolumn if required*/ ORDER BY PS.TKT_DT DESC) AS RN
   FROM
      inserted AS I
      JOIN dbo.PS_DOC_HDR as PS
         ON PS.CUST_NO = I.CUST_NO
      JOIN AR_CUST AS AR
         ON AR.CUST_NO = PS.CUST_NO 
            AND PS_DOC_HDR.LOY_PGM_COD IS NOT NULL AND PS_DOC_HDR.DOC_TYP = 'T' 
)
--SELECT * FROM cte;
UPDATE cte SET
 AR.LOY_PTS_BAL =
	 CASE
	   WHEN (AR.LOY_PTS_BAL >= 750)
					   THEN (AR.LOY_PTS_BAL - 750)
	   WHEN (AR.LOY_PTS_BAL BETWEEN 500 AND 749)
					   THEN (AR.LOY_PTS_BAL - 500)
	   WHEN (AR.LOY_PTS_BAL BETWEEN 250 AND 499)
					   THEN (AR.LOY_PTS_BAL - 250)
	   ELSE AR.LOY_PTS_BAL
	 END
WHERE RN = 1;
END
go


And I got the following errors:
Msg 4104, Level 16, State 1, Procedure USR_TR_Adjust_Loyalty_Points, Line 20
The multi-part identifier "PS_DOC_HDR.LOY_PGM_COD" could not be bound.
Msg 4104, Level 16, State 1, Procedure USR_TR_Adjust_Loyalty_Points, Line 20
The multi-part identifier "PS_DOC_HDR.DOC_TYP" could not be bound.
Msg 8156, Level 16, State 1, Procedure USR_TR_Adjust_Loyalty_Points, Line 8
The column 'LOY_PTS_BAL' was specified multiple times for 'cte'.
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2011-08-02 : 15:17:16
The following should at the very least parse and run, but please check if it is doing the right things logically:
CREATE TRIGGER USR_TR_Adjust_Loyalty_Points ON dbo.PS_DOC_HDR
AFTER INSERT
AS
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

BEGIN
;WITH cte AS
(
   SELECT
      AR.LOY_PTS_BAL,
      ROW_NUMBER() OVER (/*Partition by somecolumn if required*/ ORDER BY PS.TKT_DT DESC) AS RN
   FROM
      inserted AS I
      JOIN dbo.PS_DOC_HDR as PS
         ON PS.CUST_NO = I.CUST_NO
      JOIN AR_CUST AS AR
         ON AR.CUST_NO = PS.CUST_NO 
            AND PS.LOY_PGM_COD IS NOT NULL AND PS.DOC_TYP = 'T' 
)
--SELECT * FROM cte;
UPDATE cte SET
 LOY_PTS_BAL =
	 CASE
	   WHEN (LOY_PTS_BAL >= 750)
					   THEN (LOY_PTS_BAL - 750)
	   WHEN (LOY_PTS_BAL BETWEEN 500 AND 749)
					   THEN (LOY_PTS_BAL - 500)
	   WHEN (LOY_PTS_BAL BETWEEN 250 AND 499)
					   THEN (LOY_PTS_BAL - 250)
	   ELSE LOY_PTS_BAL
	 END
WHERE RN = 1;
END
go
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-02 : 17:39:53
Ok, it ran this time - I think maybe there was one too many of the AR.LOY_PTS_BAL. Nothing happens though when a row is inserted into the PS_DOC_HDR table. Maybe you can explain what this part does:

 ROW_NUMBER() OVER (/*Partition by somecolumn if required*/ ORDER BY PS.TKT_DT DESC) AS RN
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2011-08-02 : 17:49:34
If the update in the trigger, more likely than not, that is because the query within the CTE block does not return any rows at all (perhaps because of the join conditions).

The partition would result in multiple rows being updated if the logic required it, but even without that at least one row should get updated in the trigger.

Can you post the table DDLs and some sample data? Brett's blog might help in retrieving the DDLs.
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-03 : 16:10:34
Here are the DDL's. Sorry it's so long.

USE [harvest]
GO
/****** Object:  Table [dbo].[AR_CUST]    Script Date: 08/03/2011 16:04:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AR_CUST](
	[CUST_NO] [dbo].[T_CUST_NO] NOT NULL,
	[NAM] [dbo].[T_NAM] NOT NULL,
	[NAM_UPR] [dbo].[T_NAM] NULL,
	[FST_NAM] [dbo].[T_FST_NAM] NULL,
	[FST_NAM_UPR] [dbo].[T_FST_NAM] NULL,
	[LST_NAM] [dbo].[T_LST_NAM] NULL,
	[LST_NAM_UPR] [dbo].[T_LST_NAM] NULL,
	[SALUTATION] [dbo].[T_SALUTATION] NULL,
	[CUST_TYP] [dbo].[T_FLG] NOT NULL,
	[ADRS_1] [dbo].[T_ADRS] NULL,
	[ADRS_2] [dbo].[T_ADRS] NULL,
	[ADRS_3] [dbo].[T_ADRS] NULL,
	[CITY] [dbo].[T_CITY] NULL,
	[STATE] [dbo].[T_STATE] NULL,
	[ZIP_COD] [dbo].[T_ZIP_COD] NULL,
	[CNTRY] [dbo].[T_CNTRY] NULL,
	[PHONE_1] [dbo].[T_PHONE] NULL,
	[PHONE_2] [dbo].[T_PHONE] NULL,
	[FAX_1] [dbo].[T_PHONE] NULL,
	[FAX_2] [dbo].[T_PHONE] NULL,
	[CONTCT_1] [dbo].[T_NAM] NULL,
	[CONTCT_2] [dbo].[T_NAM] NULL,
	[EMAIL_ADRS_1] [dbo].[T_EMAIL_ADRS] NULL,
	[EMAIL_ADRS_2] [dbo].[T_EMAIL_ADRS] NULL,
	[URL_1] [dbo].[T_URL] NULL,
	[URL_2] [dbo].[T_URL] NULL,
	[PROMPT_NAM_ADRS] [dbo].[T_FLG] NOT NULL,
	[SLS_REP] [dbo].[T_USR_ID] NOT NULL,
	[CATEG_COD] [dbo].[T_COD] NULL,
	[SHIP_VIA_COD] [dbo].[T_COD] NULL,
	[SHIP_ZONE_COD] [dbo].[T_COD] NULL,
	[STR_ID] [dbo].[T_COD] NOT NULL,
	[STMNT_COD] [dbo].[T_COD] NULL,
	[TAX_COD] [dbo].[T_COD] NULL,
	[TERMS_COD] [dbo].[T_COD] NULL,
	[COMMNT] [dbo].[T_COMMNT] NULL,
	[TAX_EXEMPT_NO] [dbo].[T_DESCR] NULL,
	[TAX_EXEMPT_DAT] [dbo].[T_DAT] NULL,
	[ALLOW_AR_CHRG] [dbo].[T_BOOL] NOT NULL,
	[ALLOW_TKTS] [dbo].[T_BOOL] NOT NULL,
	[NO_CR_LIM] [dbo].[T_BOOL] NOT NULL,
	[CR_LIM] [dbo].[T_MONEY] NULL,
	[CR_RATE] [dbo].[T_COD] NULL,
	[NO_MAX_CHK_AMT] [dbo].[T_BOOL] NOT NULL,
	[MAX_CHK_AMT] [dbo].[T_MONEY] NULL,
	[CR_CARD_PAY_COD_1] [dbo].[T_COD] NULL,
	[CR_CARD_NO_1] [dbo].[T_CR_CARD_NO] NULL,
	[CR_CARD_EXP_DAT_1] [dbo].[T_CR_CARD_EXP_DAT] NULL,
	[CR_CARD_NAM_1] [dbo].[T_CR_CARD_NAM] NULL,
	[UNPSTD_BAL] [dbo].[T_MONEY] NOT NULL,
	[BAL_METH] [dbo].[T_FLG] NOT NULL,
	[AR_ACCT_NO] [dbo].[T_ACCT_NO] NULL,
	[BAL] [dbo].[T_MONEY] NOT NULL,
	[ORD_BAL] [dbo].[T_MONEY] NOT NULL,
	[NO_OF_ORDS] [dbo].[T_INT] NOT NULL,
	[USE_ORD_SHIP_TO] [dbo].[T_FLG] NOT NULL,
	[ALLOW_ORDS] [dbo].[T_BOOL] NOT NULL,
	[LST_AGE_DAT] [dbo].[T_DAT] NULL,
	[LST_AGE_BAL] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_1] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_2] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_3] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_4] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_5] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_2_5] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_3_5] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_4_5] [dbo].[T_MONEY] NULL,
	[LST_AGE_BAL_OPN] [dbo].[T_MONEY] NULL,
	[LST_AGE_FUTR_DOCS] [dbo].[T_BOOL] NOT NULL,
	[LST_AGE_METH] [dbo].[T_FLG] NOT NULL,
	[LST_AGE_AS_OF_DAT] [dbo].[T_DAT] NULL,
	[LST_AGE_CUTOFF_DAT] [dbo].[T_DAT] NULL,
	[LST_AGE_MAX_PRD_1] [dbo].[T_INT] NULL,
	[LST_AGE_MAX_PRD_2] [dbo].[T_INT] NULL,
	[LST_AGE_MAX_PRD_3] [dbo].[T_INT] NULL,
	[LST_AGE_MAX_PRD_4] [dbo].[T_INT] NULL,
	[LST_AGE_NO_OF_PRDS] [dbo].[T_INT] NULL,
	[LST_AGE_EVENT_NO] [dbo].[T_DOC_NO] NULL,
	[LST_AGE_NO_CUTOFF] [dbo].[T_BOOL] NOT NULL,
	[LST_AGE_PAST_CUTOFF] [dbo].[T_MONEY] NULL,
	[LST_AGE_NON_STD] [dbo].[T_BOOL] NOT NULL,
	[LST_STMNT_DAT] [dbo].[T_DAT] NULL,
	[LST_STMNT_BAL] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_1] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_2] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_3] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_4] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_5] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_2_5] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_3_5] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_4_5] [dbo].[T_MONEY] NULL,
	[LST_STMNT_BAL_OPN] [dbo].[T_MONEY] NULL,
	[LST_STMNT_METH] [dbo].[T_FLG] NOT NULL,
	[LST_STMNT_BEG_DAT] [dbo].[T_DAT] NULL,
	[LST_STMNT_END_DAT] [dbo].[T_DAT] NULL,
	[LST_STMNT_MAX_PRD_1] [dbo].[T_INT] NULL,
	[LST_STMNT_MAX_PRD_2] [dbo].[T_INT] NULL,
	[LST_STMNT_MAX_PRD_3] [dbo].[T_INT] NULL,
	[LST_STMNT_MAX_PRD_4] [dbo].[T_INT] NULL,
	[LST_STMNT_NO_OF_PRDS] [dbo].[T_INT] NULL,
	[LST_STMNT_PAST_CTOFF] [dbo].[T_MONEY] NULL,
	[FST_SAL_DAT] [dbo].[T_DAT] NULL,
	[LST_SAL_DAT] [dbo].[T_DAT] NULL,
	[LST_SAL_AMT] [dbo].[T_MONEY] NULL,
	[LST_PMT_DAT] [dbo].[T_DAT] NULL,
	[LST_PMT_AMT] [dbo].[T_MONEY] NULL,
	[PROF_ALPHA_1] [dbo].[T_DESCR] NULL,
	[PROF_ALPHA_2] [dbo].[T_DESCR] NULL,
	[PROF_ALPHA_3] [dbo].[T_DESCR] NULL,
	[PROF_ALPHA_4] [dbo].[T_DESCR] NULL,
	[PROF_ALPHA_5] [dbo].[T_DESCR] NULL,
	[PROF_COD_1] [dbo].[T_COD] NULL,
	[PROF_COD_2] [dbo].[T_COD] NULL,
	[PROF_COD_3] [dbo].[T_COD] NULL,
	[PROF_COD_4] [dbo].[T_COD] NULL,
	[PROF_COD_5] [dbo].[T_COD] NULL,
	[PROF_DAT_1] [dbo].[T_DAT] NULL,
	[PROF_DAT_2] [dbo].[T_DAT] NULL,
	[PROF_DAT_3] [dbo].[T_DAT] NULL,
	[PROF_DAT_4] [dbo].[T_DAT] NULL,
	[PROF_DAT_5] [dbo].[T_DAT] NULL,
	[PROF_NO_1] [dbo].[T_USR_DEF_NO] NULL,
	[PROF_NO_2] [dbo].[T_USR_DEF_NO] NULL,
	[PROF_NO_3] [dbo].[T_USR_DEF_NO] NULL,
	[PROF_NO_4] [dbo].[T_USR_DEF_NO] NULL,
	[PROF_NO_5] [dbo].[T_USR_DEF_NO] NULL,
	[LST_MAINT_DT] [dbo].[T_DT] NULL,
	[LST_MAINT_USR_ID] [dbo].[T_USR_ID] NULL,
	[LST_LCK_DT] [dbo].[T_DT] NULL,
	[ROW_TS] [timestamp] NULL,
	[WRK_STMNT_ACTIV] [dbo].[T_BOOL] NOT NULL,
	[LWY_BAL] [dbo].[T_MONEY] NOT NULL,
	[NO_OF_LWYS] [dbo].[T_INT] NOT NULL,
	[USE_LWY_SHIP_TO] [dbo].[T_FLG] NOT NULL,
	[ALLOW_LWYS] [dbo].[T_BOOL] NOT NULL,
	[IS_ECOMM_CUST] [dbo].[T_BOOL] NOT NULL,
	[ECOMM_CUST_NO] [dbo].[T_EC_CUST_NO] NULL,
	[ECOMM_AFFIL_COD] [dbo].[T_COD] NULL,
	[DISC_PCT] [dbo].[T_PCT] NULL,
	[ECOMM_INIT_PWD] [dbo].[T_CUST_NO] NULL,
	[ECOMM_NXT_PUB_UPDT] [dbo].[T_BOOL] NOT NULL,
	[ECOMM_NXT_PUB_FULL] [dbo].[T_BOOL] NOT NULL,
	[ECOMM_LST_PUB_DT] [dbo].[T_DT] NULL,
	[ECOMM_LST_PUB_TYP] [dbo].[T_FLG] NOT NULL,
	[ECOMM_LST_IMP_DT] [dbo].[T_DT] NULL,
	[ECOMM_CREATED_CUST] [dbo].[T_BOOL] NOT NULL,
	[ECOMM_LST_ORD_NO] [dbo].[T_DOC_NO] NULL,
	[ECOMM_LST_ORD_DT] [dbo].[T_DT] NULL,
	[ECOMM_LST_IMP_TYP] [dbo].[T_FLG] NOT NULL,
	[ECOMM_LST_IMP_EVENT_NO] [dbo].[T_DOC_NO] NULL,
	[CR_CARD_NO_1_ENC] [dbo].[T_CR_CARD_NO_ENC] NULL,
	[CR_CARD_NO_1_MSK] [dbo].[T_CR_CARD_NO] NULL,
	[PROMPT_FOR_CUSTOM_FLDS] [dbo].[T_BOOL] NOT NULL,
	[LOY_PGM_COD] [dbo].[T_COD] NULL,
	[LOY_PTS_BAL] [dbo].[T_LOY_PTS] NOT NULL,
	[TOT_LOY_PTS_EARND] [dbo].[T_LOY_PTS] NOT NULL,
	[TOT_LOY_PTS_RDM] [dbo].[T_LOY_PTS] NOT NULL,
	[TOT_LOY_PTS_ADJ] [dbo].[T_LOY_PTS] NOT NULL,
	[LST_LOY_EARN_TKT_DAT] [dbo].[T_DAT] NULL,
	[LST_LOY_EARN_TKT_TIM] [dbo].[T_TIM] NULL,
	[LST_LOY_PTS_EARN] [dbo].[T_LOY_PTS] NULL,
	[LST_LOY_EARN_TKT_NO] [dbo].[T_DOC_NO] NULL,
	[LST_LOY_RDM_TKT_DAT] [dbo].[T_DAT] NULL,
	[LST_LOY_RDM_TKT_TIM] [dbo].[T_TIM] NULL,
	[LST_LOY_PTS_RDM] [dbo].[T_LOY_PTS] NULL,
	[LST_LOY_RDM_TKT_NO] [dbo].[T_DOC_NO] NULL,
	[LST_LOY_ADJ_DAT] [dbo].[T_DAT] NULL,
	[LST_LOY_PTS_ADJ] [dbo].[T_LOY_PTS] NULL,
	[LST_LOY_ADJ_DOC_NO] [dbo].[T_DOC_NO] NULL,
	[LOY_CARD_NO] [dbo].[T_CR_CARD_NO] NULL,
	[FCH_COD] [dbo].[T_COD] NULL,
	[LST_FCH_DAT] [dbo].[T_DAT] NULL,
	[LST_FCH_AMT] [dbo].[T_MONEY] NULL,
	[LST_FCH_PAST_DUE_AMT] [dbo].[T_MONEY] NULL,
	[LST_FCH_DOC_NO] [dbo].[T_DOC_NO] NULL,
	[REQ_PO_NO] [dbo].[T_BOOL] NOT NULL,
	[RS_UTC_DT] [dbo].[T_DT] NULL,
	[CUST_NAM_TYP] [dbo].[T_FLG] NOT NULL,
	[CUST_FST_LST_NAM]  AS (case [CUST_NAM_TYP] when 'P' then case when [LST_NAM] IS NULL then coalesce([FST_NAM],'') else (coalesce([LST_NAM],'')+', ')+coalesce([FST_NAM],'') end when 'B' then [NAM]  end),
	[LST_LOY_EARN_TKT_DT]  AS (([LST_LOY_EARN_TKT_DAT]+[LST_LOY_EARN_TKT_TIM])+(2)),
	[LST_LOY_RDM_TKT_DT]  AS (([LST_LOY_RDM_TKT_DAT]+[LST_LOY_RDM_TKT_TIM])+(2)),
	[CR_CARD_NO_1_KID] [dbo].[T_INT_TINY] NULL,
	[PS_HDR_CUST_FLD_FRM_ID] [dbo].[T_INT_BIG] NULL,
	[EMAIL_STATEMENT] [dbo].[T_BOOL] NOT NULL,
	[RS_STAT] [dbo].[T_INT_TINY] NOT NULL,
	[INCLUDE_IN_MARKETING_MAILOUTS] [dbo].[T_BOOL] NOT NULL,
	[MARKETING_MAILOUT_OPT_IN_DAT] [dbo].[T_DAT_SMALL] NULL,
	[RPT_EMAIL] [dbo].[T_FLG] NOT NULL,
 CONSTRAINT [PK_AR_CUST] PRIMARY KEY CLUSTERED 
(
	[CUST_NO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PS_DOC_HDR]    Script Date: 08/03/2011 16:04:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PS_DOC_HDR](
	[DOC_ID] [dbo].[T_DOC_ID] NOT NULL,
	[STR_ID] [dbo].[T_COD] NOT NULL,
	[STA_ID] [dbo].[T_COD] NOT NULL,
	[TKT_NO] [dbo].[T_DOC_NO] NOT NULL,
	[DOC_TYP] [dbo].[T_FLG] NOT NULL,
	[SAL_LINS] [dbo].[T_INT] NULL,
	[ORD_LINS] [dbo].[T_INT] NOT NULL,
	[SAL_LIN_TOT] [dbo].[T_MONEY] NOT NULL,
	[GFC_LINS] [dbo].[T_INT] NOT NULL,
	[BO_LINS] [dbo].[T_INT] NOT NULL,
	[SO_LINS] [dbo].[T_INT] NOT NULL,
	[DRW_ID] [dbo].[T_COD] NULL,
	[DRW_SESSION_ID] [dbo].[T_DOC_ID] NULL,
	[CUST_NO] [dbo].[T_CUST_NO] NULL,
	[RET_LINS] [dbo].[T_INT] NULL,
	[SHIP_VIA_COD] [dbo].[T_COD] NULL,
	[RET_LIN_TOT] [dbo].[T_MONEY] NOT NULL,
	[SHIP_ZONE_COD] [dbo].[T_COD] NULL,
	[TAX_COD] [dbo].[T_COD] NULL,
	[TERMS_COD] [dbo].[T_COD] NULL,
	[CUST_PO_NO] [dbo].[T_CUST_PO_NO] NULL,
	[TKT_TYP] [dbo].[T_FLG] NOT NULL,
	[USR_ID] [dbo].[T_USR_ID] NULL,
	[SLS_REP] [dbo].[T_USR_ID] NULL,
	[STK_LOC_ID] [dbo].[T_LOC_ID] NULL,
	[PRC_LOC_ID] [dbo].[T_LOC_ID] NULL,
	[SVC_LINS] [dbo].[T_INT] NOT NULL,
	[PFT_CTR] [dbo].[T_ACCT_NO] NULL,
	[VOID_USR_ID] [dbo].[T_USR_ID] NULL,
	[VOID_REAS] [dbo].[T_COD] NULL,
	[TAX_EXEMPT_NO] [dbo].[T_DESCR] NULL,
	[TAX_OVRD_REAS] [dbo].[T_COD] NULL,
	[DOC_GUID] [dbo].[T_GUID] NOT NULL,
	[BILL_TO_CONTACT_ID] [dbo].[T_INT_TINY] NULL,
	[SHIP_TO_CONTACT_ID] [dbo].[T_INT_TINY] NULL,
	[REQ_REPRICE] [dbo].[T_BOOL] NOT NULL,
	[SHIP_DAT] [dbo].[T_DAT] NULL,
	[RS_UTC_DT] [dbo].[T_DT] NULL,
	[IS_DOC_COMMITTED] [dbo].[T_BOOL] NOT NULL,
	[LST_FRM_GRP_PRTD] [dbo].[T_COD] NULL,
	[LST_FRM_PRTD] [dbo].[T_FILENAME] NULL,
	[FOOD_STMP_AMT] [dbo].[T_MONEY] NULL,
	[FOOD_STMP_LINS] [dbo].[T_INT] NOT NULL,
	[FOOD_STMP_TAX_AMT] [dbo].[T_MONEY] NULL,
	[TIMES_PRTD] [dbo].[T_INT] NULL,
	[ERR_REF] [dbo].[T_ERR_REF] NULL,
	[TKT_DT] [dbo].[T_DT] NULL,
	[IS_REL_TKT] [dbo].[T_BOOL] NOT NULL,
	[FOOD_STMP_NORM_TAX_AMT] [dbo].[T_MONEY] NULL,
	[LOY_PGM_COD] [dbo].[T_COD] NULL,
	[NORM_TAX_COD] [dbo].[T_COD] NULL,
	[DATA_UPGRADE_STAT] [dbo].[T_FLG] NULL,
	[REF] [dbo].[T_REF] NULL,
	[HAS_ENTD_LINS] [dbo].[T_BOOL] NOT NULL,
	[HAS_PCKD_LINS] [dbo].[T_BOOL] NOT NULL,
	[HAS_PCKVRFD_LINS] [dbo].[T_BOOL] NOT NULL,
	[HAS_INVCD_LINS] [dbo].[T_BOOL] NOT NULL,
	[HAS_RLSD_LINS] [dbo].[T_BOOL] NOT NULL,
	[TO_REL_LINS] [dbo].[T_INT] NOT NULL,
	[TO_LEAVE_LINS] [dbo].[T_INT] NOT NULL,
	[LST_MAINT_DT] [dbo].[T_DT] NULL,
	[LST_MAINT_USR_ID] [dbo].[T_USR_ID] NULL,
	[IS_OFFLINE] [dbo].[T_BIT] NOT NULL,
	[RS_STAT] [dbo].[T_INT_TINY] NOT NULL,
 CONSTRAINT [PK_PS_DOC_HDR] PRIMARY KEY CLUSTERED 
(
	[DOC_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Default [DF_AR_CUST_CUST_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_CUST_TYP]  DEFAULT ('C') FOR [CUST_TYP]
GO
/****** Object:  Default [DF_AR_CUST_PROMPT_NAM_ADRS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_PROMPT_NAM_ADRS]  DEFAULT ('S') FOR [PROMPT_NAM_ADRS]
GO
/****** Object:  Default [DF_AR_CUST_ALLOW_AR_CHRG]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ALLOW_AR_CHRG]  DEFAULT ('Y') FOR [ALLOW_AR_CHRG]
GO
/****** Object:  Default [DF_AR_CUST_ALLOW_TKTS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ALLOW_TKTS]  DEFAULT ('Y') FOR [ALLOW_TKTS]
GO
/****** Object:  Default [DF_AR_CUST_NO_CR_LIM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_NO_CR_LIM]  DEFAULT ('Y') FOR [NO_CR_LIM]
GO
/****** Object:  Default [DF_AR_CUST_NO_MAX_CHK_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_NO_MAX_CHK_AMT]  DEFAULT ('Y') FOR [NO_MAX_CHK_AMT]
GO
/****** Object:  Default [DF_AR_CUST_UNPSTD_BAL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_UNPSTD_BAL]  DEFAULT (0) FOR [UNPSTD_BAL]
GO
/****** Object:  Default [DF_AR_CUST_BAL_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_BAL_METH]  DEFAULT ('O') FOR [BAL_METH]
GO
/****** Object:  Default [DF_AR_CUST_BAL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_BAL]  DEFAULT (0) FOR [BAL]
GO
/****** Object:  Default [DF_AR_CUST_ORD_BAL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ORD_BAL]  DEFAULT (0) FOR [ORD_BAL]
GO
/****** Object:  Default [DF_AR_CUST_NO_OF_ORDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_NO_OF_ORDS]  DEFAULT (0) FOR [NO_OF_ORDS]
GO
/****** Object:  Default [DF_AR_CUST_USE_ORD_SHIP_TO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_USE_ORD_SHIP_TO]  DEFAULT ('S') FOR [USE_ORD_SHIP_TO]
GO
/****** Object:  Default [DF_AR_CUST_ALLOW_ORDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ALLOW_ORDS]  DEFAULT ('Y') FOR [ALLOW_ORDS]
GO
/****** Object:  Default [DF_AR_CUST_LST_AGE_FUTR_DOCS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LST_AGE_FUTR_DOCS]  DEFAULT ('N') FOR [LST_AGE_FUTR_DOCS]
GO
/****** Object:  Default [DF_AR_CUST_LST_AGE_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LST_AGE_METH]  DEFAULT ('!') FOR [LST_AGE_METH]
GO
/****** Object:  Default [DF_AR_CUST_LST_AGE_NO_CUTOFF]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LST_AGE_NO_CUTOFF]  DEFAULT ('N') FOR [LST_AGE_NO_CUTOFF]
GO
/****** Object:  Default [DF_AR_CUST_LST_AGE_NON_STD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LST_AGE_NON_STD]  DEFAULT ('N') FOR [LST_AGE_NON_STD]
GO
/****** Object:  Default [DF_AR_CUST_LST_STMNT_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LST_STMNT_METH]  DEFAULT ('!') FOR [LST_STMNT_METH]
GO
/****** Object:  Default [DF_AR_CUST_WRK_STMNT_ACTIV]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_WRK_STMNT_ACTIV]  DEFAULT ('N') FOR [WRK_STMNT_ACTIV]
GO
/****** Object:  Default [DF_AR_CUST_LWY_BAL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LWY_BAL]  DEFAULT (0) FOR [LWY_BAL]
GO
/****** Object:  Default [DF_AR_CUST_NO_OF_LWYS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_NO_OF_LWYS]  DEFAULT (0) FOR [NO_OF_LWYS]
GO
/****** Object:  Default [DF_AR_CUST_USE_LWY_SHIP_TO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_USE_LWY_SHIP_TO]  DEFAULT ('S') FOR [USE_LWY_SHIP_TO]
GO
/****** Object:  Default [DF_AR_CUST_ALLOW_LWYS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ALLOW_LWYS]  DEFAULT ('Y') FOR [ALLOW_LWYS]
GO
/****** Object:  Default [DF_AR_CUST_IS_ECOMM_CUST]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_IS_ECOMM_CUST]  DEFAULT ('N') FOR [IS_ECOMM_CUST]
GO
/****** Object:  Default [DF_AR_CUST_DISC_PCT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_DISC_PCT]  DEFAULT (0) FOR [DISC_PCT]
GO
/****** Object:  Default [DF_AR_CUST_ECOMM_NXT_PUB_UPDT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ECOMM_NXT_PUB_UPDT]  DEFAULT ('N') FOR [ECOMM_NXT_PUB_UPDT]
GO
/****** Object:  Default [DF_AR_CUST_ECOMM_NXT_PUB_FULL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ECOMM_NXT_PUB_FULL]  DEFAULT ('Y') FOR [ECOMM_NXT_PUB_FULL]
GO
/****** Object:  Default [DF_AR_CUST_ECOMM_LST_PUB_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ECOMM_LST_PUB_TYP]  DEFAULT ('!') FOR [ECOMM_LST_PUB_TYP]
GO
/****** Object:  Default [DF_AR_CUST_ECOMM_CREATED_CUST]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ECOMM_CREATED_CUST]  DEFAULT ('N') FOR [ECOMM_CREATED_CUST]
GO
/****** Object:  Default [DF_AR_CUST_ECOMM_LST_IMP_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_ECOMM_LST_IMP_TYP]  DEFAULT ('!') FOR [ECOMM_LST_IMP_TYP]
GO
/****** Object:  Default [DF_AR_CUST_PROMPT_FOR_CUSTOM_FLDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_PROMPT_FOR_CUSTOM_FLDS]  DEFAULT ('N') FOR [PROMPT_FOR_CUSTOM_FLDS]
GO
/****** Object:  Default [DF_AR_CUST_LOY_PTS_BAL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_LOY_PTS_BAL]  DEFAULT (0) FOR [LOY_PTS_BAL]
GO
/****** Object:  Default [DF_AR_CUST_TOT_LOY_PTS_EARND]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_TOT_LOY_PTS_EARND]  DEFAULT (0) FOR [TOT_LOY_PTS_EARND]
GO
/****** Object:  Default [DF_AR_CUST_TOT_LOY_PTS_RDM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_TOT_LOY_PTS_RDM]  DEFAULT (0) FOR [TOT_LOY_PTS_RDM]
GO
/****** Object:  Default [DF_AR_CUST_TOT_LOY_PTS_ADJ]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_TOT_LOY_PTS_ADJ]  DEFAULT (0) FOR [TOT_LOY_PTS_ADJ]
GO
/****** Object:  Default [DF_AR_CUST_REQ_PO_NO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_REQ_PO_NO]  DEFAULT ('N') FOR [REQ_PO_NO]
GO
/****** Object:  Default [DF_AR_CUST_RS_UTC_DT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_RS_UTC_DT]  DEFAULT (getutcdate()) FOR [RS_UTC_DT]
GO
/****** Object:  Default [DF_AR_CUST_CUST_NAM_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_CUST_NAM_TYP]  DEFAULT ('B') FOR [CUST_NAM_TYP]
GO
/****** Object:  Default [DF_AR_CUST_EMAIL_STATEMENT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_EMAIL_STATEMENT]  DEFAULT ('N') FOR [EMAIL_STATEMENT]
GO
/****** Object:  Default [DF_AR_CUST_RS_STAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_RS_STAT]  DEFAULT ((1)) FOR [RS_STAT]
GO
/****** Object:  Default [DF_AR_CUST_INCLUDE_IN_MARKETING_MAILOUTS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_INCLUDE_IN_MARKETING_MAILOUTS]  DEFAULT ('N') FOR [INCLUDE_IN_MARKETING_MAILOUTS]
GO
/****** Object:  Default [DF_AR_CUST_RPT_EMAIL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST] ADD  CONSTRAINT [DF_AR_CUST_RPT_EMAIL]  DEFAULT ('1') FOR [RPT_EMAIL]
GO
/****** Object:  Default [DF_PS_DOC_HDR_DOC_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_DOC_TYP]  DEFAULT ('T') FOR [DOC_TYP]
GO
/****** Object:  Default [DF_PS_DOC_HDR_SAL_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_SAL_LINS]  DEFAULT ((0)) FOR [SAL_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_ORD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_ORD_LINS]  DEFAULT ((0)) FOR [ORD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_SAL_LIN_TOT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_SAL_LIN_TOT]  DEFAULT ((0)) FOR [SAL_LIN_TOT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_GFC_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_GFC_LINS]  DEFAULT ((0)) FOR [GFC_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_BO_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_BO_LINS]  DEFAULT ((0)) FOR [BO_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_SO_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_SO_LINS]  DEFAULT ((0)) FOR [SO_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_RET_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_RET_LINS]  DEFAULT ((0)) FOR [RET_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_RET_LIN_TOT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_RET_LIN_TOT]  DEFAULT ((0)) FOR [RET_LIN_TOT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_TKT_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_TKT_TYP]  DEFAULT ('T') FOR [TKT_TYP]
GO
/****** Object:  Default [DF_PS_DOC_HDR_SVC_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_SVC_LINS]  DEFAULT ((0)) FOR [SVC_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_REQ_REPRICE]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_REQ_REPRICE]  DEFAULT ('N') FOR [REQ_REPRICE]
GO
/****** Object:  Default [DF_PS_DOC_HDR_RS_UTC_DT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_RS_UTC_DT]  DEFAULT (getutcdate()) FOR [RS_UTC_DT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_IS_DOC_COMMITTED]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_IS_DOC_COMMITTED]  DEFAULT ('N') FOR [IS_DOC_COMMITTED]
GO
/****** Object:  Default [DF_PS_DOC_HDR_FOOD_STMP_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_FOOD_STMP_AMT]  DEFAULT ((0)) FOR [FOOD_STMP_AMT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_FOOD_STMP_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_FOOD_STMP_LINS]  DEFAULT ((0)) FOR [FOOD_STMP_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_FOOD_STMP_TAX_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_FOOD_STMP_TAX_AMT]  DEFAULT ((0)) FOR [FOOD_STMP_TAX_AMT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_TIMES_PRTD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_TIMES_PRTD]  DEFAULT ((0)) FOR [TIMES_PRTD]
GO
/****** Object:  Default [DF_PS_DOC_HDR_IS_REL_TKT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_IS_REL_TKT]  DEFAULT ('N') FOR [IS_REL_TKT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_FOOD_STMP_NORM_TAX_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_FOOD_STMP_NORM_TAX_AMT]  DEFAULT ((0)) FOR [FOOD_STMP_NORM_TAX_AMT]
GO
/****** Object:  Default [DF_PS_DOC_HDR_HAS_ENTD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_HAS_ENTD_LINS]  DEFAULT ('Y') FOR [HAS_ENTD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_HAS_PCKD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_HAS_PCKD_LINS]  DEFAULT ('N') FOR [HAS_PCKD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_HAS_PCKVRFD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_HAS_PCKVRFD_LINS]  DEFAULT ('N') FOR [HAS_PCKVRFD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_HAS_INVCD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_HAS_INVCD_LINS]  DEFAULT ('N') FOR [HAS_INVCD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_HAS_RLSD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_HAS_RLSD_LINS]  DEFAULT ('N') FOR [HAS_RLSD_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_TO_REL_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_TO_REL_LINS]  DEFAULT ((0)) FOR [TO_REL_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_TO_LEAVE_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_TO_LEAVE_LINS]  DEFAULT ((0)) FOR [TO_LEAVE_LINS]
GO
/****** Object:  Default [DF_PS_DOC_HDR_IS_OFFLINE]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_IS_OFFLINE]  DEFAULT ((0)) FOR [IS_OFFLINE]
GO
/****** Object:  Default [DF_PS_DOC_HDR_RS_STAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR] ADD  CONSTRAINT [DF_PS_DOC_HDR_RS_STAT]  DEFAULT ((1)) FOR [RS_STAT]
GO
/****** Object:  Check [CK_AR_CUST_ALLOW_AR_CHRG]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ALLOW_AR_CHRG] CHECK  (([ALLOW_AR_CHRG] = 'N' or [ALLOW_AR_CHRG] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ALLOW_AR_CHRG]
GO
/****** Object:  Check [CK_AR_CUST_ALLOW_LWYS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ALLOW_LWYS] CHECK  (([ALLOW_LWYS] = 'N' or [ALLOW_LWYS] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ALLOW_LWYS]
GO
/****** Object:  Check [CK_AR_CUST_ALLOW_ORDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ALLOW_ORDS] CHECK  (([ALLOW_ORDS] = 'N' or [ALLOW_ORDS] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ALLOW_ORDS]
GO
/****** Object:  Check [CK_AR_CUST_ALLOW_TKTS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ALLOW_TKTS] CHECK  (([ALLOW_TKTS] = 'N' or [ALLOW_TKTS] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ALLOW_TKTS]
GO
/****** Object:  Check [CK_AR_CUST_BAL_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_BAL_METH] CHECK  (([BAL_METH] = 'O'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_BAL_METH]
GO
/****** Object:  Check [CK_AR_CUST_CR_LIM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_CR_LIM] CHECK  (([CR_LIM] is null or [CR_LIM] >= 0))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_CR_LIM]
GO
/****** Object:  Check [CK_AR_CUST_CUST_NAM_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_CUST_NAM_TYP] CHECK  (([CUST_NAM_TYP] = 'B' or [CUST_NAM_TYP] = 'P'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_CUST_NAM_TYP]
GO
/****** Object:  Check [CK_AR_CUST_CUST_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_CUST_TYP] CHECK  (([CUST_TYP] = 'C' or [CUST_TYP] = 'A'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_CUST_TYP]
GO
/****** Object:  Check [CK_AR_CUST_DISC_PCT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_DISC_PCT] CHECK  (([DISC_PCT] is null or [DISC_PCT] >= 0 and [DISC_PCT] <= 100))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_DISC_PCT]
GO
/****** Object:  Check [CK_AR_CUST_ECOMM_CREATED_CUST]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ECOMM_CREATED_CUST] CHECK  (([ECOMM_CREATED_CUST] = 'N' or [ECOMM_CREATED_CUST] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ECOMM_CREATED_CUST]
GO
/****** Object:  Check [CK_AR_CUST_ECOMM_LST_IMP_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ECOMM_LST_IMP_TYP] CHECK  (([ECOMM_LST_IMP_TYP] = 'U' or ([ECOMM_LST_IMP_TYP] = 'I' or [ECOMM_LST_IMP_TYP] = '!')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ECOMM_LST_IMP_TYP]
GO
/****** Object:  Check [CK_AR_CUST_ECOMM_LST_PUB_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ECOMM_LST_PUB_TYP] CHECK  (([ECOMM_LST_PUB_TYP] = 'F' or ([ECOMM_LST_PUB_TYP] = 'P' or [ECOMM_LST_PUB_TYP] = '!')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ECOMM_LST_PUB_TYP]
GO
/****** Object:  Check [CK_AR_CUST_ECOMM_NXT_PUB_FULL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ECOMM_NXT_PUB_FULL] CHECK  (([ECOMM_NXT_PUB_FULL] = 'N' or [ECOMM_NXT_PUB_FULL] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ECOMM_NXT_PUB_FULL]
GO
/****** Object:  Check [CK_AR_CUST_ECOMM_NXT_PUB_UPDT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_ECOMM_NXT_PUB_UPDT] CHECK  (([ECOMM_NXT_PUB_UPDT] = 'N' or [ECOMM_NXT_PUB_UPDT] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_ECOMM_NXT_PUB_UPDT]
GO
/****** Object:  Check [CK_AR_CUST_EMAIL_STATEMENT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_EMAIL_STATEMENT] CHECK  (([EMAIL_STATEMENT]='N' OR [EMAIL_STATEMENT]='Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_EMAIL_STATEMENT]
GO
/****** Object:  Check [CK_AR_CUST_FST_SAL_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_FST_SAL_DAT] CHECK  (([FST_SAL_DAT] is null or [FST_SAL_DAT] = [dbo].[fnDateOnly]([FST_SAL_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_FST_SAL_DAT]
GO
/****** Object:  Check [CK_AR_CUST_INCLUDE_IN_MARKETING_MAILOUTS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_INCLUDE_IN_MARKETING_MAILOUTS] CHECK  (([INCLUDE_IN_MARKETING_MAILOUTS]='N' OR [INCLUDE_IN_MARKETING_MAILOUTS]='Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_INCLUDE_IN_MARKETING_MAILOUTS]
GO
/****** Object:  Check [CK_AR_CUST_IS_ECOMM_CUST]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_IS_ECOMM_CUST] CHECK  (([IS_ECOMM_CUST] = 'N' or [IS_ECOMM_CUST] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_IS_ECOMM_CUST]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_AS_OF_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_AS_OF_DAT] CHECK  (([LST_AGE_AS_OF_DAT] is null or [LST_AGE_AS_OF_DAT] = [dbo].[fnDateOnly]([LST_AGE_AS_OF_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_AS_OF_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_CUTOFF_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_CUTOFF_DAT] CHECK  (([LST_AGE_CUTOFF_DAT] is null or [LST_AGE_CUTOFF_DAT] = [dbo].[fnDateOnly]([LST_AGE_CUTOFF_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_CUTOFF_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_DAT] CHECK  (([LST_AGE_DAT] is null or [LST_AGE_DAT] = [dbo].[fnDateOnly]([LST_AGE_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_FUTR_DOCS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_FUTR_DOCS] CHECK  (([LST_AGE_FUTR_DOCS] = 'N' or [LST_AGE_FUTR_DOCS] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_FUTR_DOCS]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_METH] CHECK  (([LST_AGE_METH] = 'D' or ([LST_AGE_METH] = 'I' or [LST_AGE_METH] = '!')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_METH]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_NO_CUTOFF]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_NO_CUTOFF] CHECK  (([LST_AGE_NO_CUTOFF] = 'N' or [LST_AGE_NO_CUTOFF] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_NO_CUTOFF]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_NO_OF_PRDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_NO_OF_PRDS] CHECK  (([LST_AGE_NO_OF_PRDS] is null or [LST_AGE_NO_OF_PRDS] >= 2 and [LST_AGE_NO_OF_PRDS] <= 5))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_NO_OF_PRDS]
GO
/****** Object:  Check [CK_AR_CUST_LST_AGE_NON_STD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_AGE_NON_STD] CHECK  (([LST_AGE_NON_STD] = 'N' or [LST_AGE_NON_STD] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_AGE_NON_STD]
GO
/****** Object:  Check [CK_AR_CUST_LST_FCH_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_FCH_DAT] CHECK  (([LST_FCH_DAT] is null or [LST_FCH_DAT] = [dbo].[fnDateOnly]([LST_FCH_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_FCH_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_LOY_ADJ_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_LOY_ADJ_DAT] CHECK  (([LST_LOY_ADJ_DAT] is null or [LST_LOY_ADJ_DAT] = [dbo].[fnDateOnly]([LST_LOY_ADJ_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_LOY_ADJ_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_LOY_EARN_TKT_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_LOY_EARN_TKT_DAT] CHECK  (([LST_LOY_EARN_TKT_DAT] is null or [LST_LOY_EARN_TKT_DAT] = [dbo].[fnDateOnly]([LST_LOY_EARN_TKT_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_LOY_EARN_TKT_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_LOY_EARN_TKT_TIM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_LOY_EARN_TKT_TIM] CHECK  (([LST_LOY_EARN_TKT_TIM] is null or [LST_LOY_EARN_TKT_TIM] = [dbo].[fnTimeOnly]([LST_LOY_EARN_TKT_TIM])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_LOY_EARN_TKT_TIM]
GO
/****** Object:  Check [CK_AR_CUST_LST_LOY_RDM_TKT_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_LOY_RDM_TKT_DAT] CHECK  (([LST_LOY_RDM_TKT_DAT] is null or [LST_LOY_RDM_TKT_DAT] = [dbo].[fnDateOnly]([LST_LOY_RDM_TKT_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_LOY_RDM_TKT_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_LOY_RDM_TKT_TIM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_LOY_RDM_TKT_TIM] CHECK  (([LST_LOY_RDM_TKT_TIM] is null or [LST_LOY_RDM_TKT_TIM] = [dbo].[fnTimeOnly]([LST_LOY_RDM_TKT_TIM])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_LOY_RDM_TKT_TIM]
GO
/****** Object:  Check [CK_AR_CUST_LST_PMT_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_PMT_DAT] CHECK  (([LST_PMT_DAT] is null or [LST_PMT_DAT] = [dbo].[fnDateOnly]([LST_PMT_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_PMT_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_SAL_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_SAL_DAT] CHECK  (([LST_SAL_DAT] is null or [LST_SAL_DAT] = [dbo].[fnDateOnly]([LST_SAL_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_SAL_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_STMNT_BEG_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_STMNT_BEG_DAT] CHECK  (([LST_STMNT_BEG_DAT] is null or [LST_STMNT_BEG_DAT] = [dbo].[fnDateOnly]([LST_STMNT_BEG_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_STMNT_BEG_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_STMNT_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_STMNT_DAT] CHECK  (([LST_STMNT_DAT] is null or [LST_STMNT_DAT] = [dbo].[fnDateOnly]([LST_STMNT_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_STMNT_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_STMNT_END_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_STMNT_END_DAT] CHECK  (([LST_STMNT_END_DAT] is null or [LST_STMNT_END_DAT] = [dbo].[fnDateOnly]([LST_STMNT_END_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_STMNT_END_DAT]
GO
/****** Object:  Check [CK_AR_CUST_LST_STMNT_METH]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_STMNT_METH] CHECK  (([LST_STMNT_METH] = 'D' or ([LST_STMNT_METH] = 'I' or [LST_STMNT_METH] = '!')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_STMNT_METH]
GO
/****** Object:  Check [CK_AR_CUST_LST_STMNT_NO_OF_PRDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_LST_STMNT_NO_OF_PRDS] CHECK  (([LST_STMNT_NO_OF_PRDS] is null or [LST_STMNT_NO_OF_PRDS] >= 2 and [LST_STMNT_NO_OF_PRDS] <= 5))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_LST_STMNT_NO_OF_PRDS]
GO
/****** Object:  Check [CK_AR_CUST_MAX_CHK_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_MAX_CHK_AMT] CHECK  (([MAX_CHK_AMT] is null or [MAX_CHK_AMT] >= 0))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_MAX_CHK_AMT]
GO
/****** Object:  Check [CK_AR_CUST_NO_CR_LIM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_NO_CR_LIM] CHECK  (([NO_CR_LIM] = 'N' or [NO_CR_LIM] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_NO_CR_LIM]
GO
/****** Object:  Check [CK_AR_CUST_NO_MAX_CHK_AMT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_NO_MAX_CHK_AMT] CHECK  (([NO_MAX_CHK_AMT] = 'N' or [NO_MAX_CHK_AMT] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_NO_MAX_CHK_AMT]
GO
/****** Object:  Check [CK_AR_CUST_PROF_DAT_1]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROF_DAT_1] CHECK  (([PROF_DAT_1] is null or [PROF_DAT_1] = [dbo].[fnDateOnly]([PROF_DAT_1])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROF_DAT_1]
GO
/****** Object:  Check [CK_AR_CUST_PROF_DAT_2]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROF_DAT_2] CHECK  (([PROF_DAT_2] is null or [PROF_DAT_2] = [dbo].[fnDateOnly]([PROF_DAT_2])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROF_DAT_2]
GO
/****** Object:  Check [CK_AR_CUST_PROF_DAT_3]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROF_DAT_3] CHECK  (([PROF_DAT_3] is null or [PROF_DAT_3] = [dbo].[fnDateOnly]([PROF_DAT_3])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROF_DAT_3]
GO
/****** Object:  Check [CK_AR_CUST_PROF_DAT_4]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROF_DAT_4] CHECK  (([PROF_DAT_4] is null or [PROF_DAT_4] = [dbo].[fnDateOnly]([PROF_DAT_4])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROF_DAT_4]
GO
/****** Object:  Check [CK_AR_CUST_PROF_DAT_5]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROF_DAT_5] CHECK  (([PROF_DAT_5] is null or [PROF_DAT_5] = [dbo].[fnDateOnly]([PROF_DAT_5])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROF_DAT_5]
GO
/****** Object:  Check [CK_AR_CUST_PROMPT_FOR_CUSTOM_FLDS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROMPT_FOR_CUSTOM_FLDS] CHECK  (([PROMPT_FOR_CUSTOM_FLDS] = 'N' or [PROMPT_FOR_CUSTOM_FLDS] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROMPT_FOR_CUSTOM_FLDS]
GO
/****** Object:  Check [CK_AR_CUST_PROMPT_NAM_ADRS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_PROMPT_NAM_ADRS] CHECK  (([PROMPT_NAM_ADRS] = 'S' or ([PROMPT_NAM_ADRS] = 'N' or [PROMPT_NAM_ADRS] = 'Y')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_PROMPT_NAM_ADRS]
GO
/****** Object:  Check [CK_AR_CUST_REQ_PO_NO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_REQ_PO_NO] CHECK  (([REQ_PO_NO] = 'N' or [REQ_PO_NO] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_REQ_PO_NO]
GO
/****** Object:  Check [CK_AR_CUST_RPT_EMAIL]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_RPT_EMAIL] CHECK  (([RPT_EMAIL]='N' OR [RPT_EMAIL]='2' OR [RPT_EMAIL]='1'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_RPT_EMAIL]
GO
/****** Object:  Check [CK_AR_CUST_TAX_EXEMPT_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_TAX_EXEMPT_DAT] CHECK  (([TAX_EXEMPT_DAT] is null or [TAX_EXEMPT_DAT] = [dbo].[fnDateOnly]([TAX_EXEMPT_DAT])))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_TAX_EXEMPT_DAT]
GO
/****** Object:  Check [CK_AR_CUST_USE_LWY_SHIP_TO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_USE_LWY_SHIP_TO] CHECK  (([USE_LWY_SHIP_TO] = 'S' or ([USE_LWY_SHIP_TO] = 'N' or [USE_LWY_SHIP_TO] = 'Y')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_USE_LWY_SHIP_TO]
GO
/****** Object:  Check [CK_AR_CUST_USE_ORD_SHIP_TO]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_USE_ORD_SHIP_TO] CHECK  (([USE_ORD_SHIP_TO] = 'S' or ([USE_ORD_SHIP_TO] = 'N' or [USE_ORD_SHIP_TO] = 'Y')))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_USE_ORD_SHIP_TO]
GO
/****** Object:  Check [CK_AR_CUST_WRK_STMNT_ACTIV]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [CK_AR_CUST_WRK_STMNT_ACTIV] CHECK  (([WRK_STMNT_ACTIV] = 'N' or [WRK_STMNT_ACTIV] = 'Y'))
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [CK_AR_CUST_WRK_STMNT_ACTIV]
GO
/****** Object:  Check [CK_PS_DOC_HDR_DOC_ID]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_DOC_ID] CHECK  (([DOC_ID]>=(1) AND [DOC_ID]<=(999999999999999.)))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_DOC_ID]
GO
/****** Object:  Check [CK_PS_DOC_HDR_DOC_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH NOCHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_DOC_TYP] CHECK  (([DOC_TYP]='I' OR [DOC_TYP]='F' OR [DOC_TYP]='R' OR [DOC_TYP]='L' OR [DOC_TYP]='O' OR [DOC_TYP]='Q' OR [DOC_TYP]='V' OR [DOC_TYP]='H' OR [DOC_TYP]='T'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_DOC_TYP]
GO
/****** Object:  Check [CK_PS_DOC_HDR_DRW_SESSION_ID_REQD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH NOCHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_DRW_SESSION_ID_REQD] CHECK  ((([DOC_TYP]='V' OR [DOC_TYP]='T') AND [DRW_SESSION_ID] IS NOT NULL OR NOT ([DOC_TYP]='V' OR [DOC_TYP]='T') AND [DRW_SESSION_ID] IS NULL))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_DRW_SESSION_ID_REQD]
GO
/****** Object:  Check [CK_PS_DOC_HDR_HAS_ENTD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_HAS_ENTD_LINS] CHECK  (([HAS_ENTD_LINS]='N' OR [HAS_ENTD_LINS]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_HAS_ENTD_LINS]
GO
/****** Object:  Check [CK_PS_DOC_HDR_HAS_INVCD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_HAS_INVCD_LINS] CHECK  (([HAS_INVCD_LINS]='N' OR [HAS_INVCD_LINS]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_HAS_INVCD_LINS]
GO
/****** Object:  Check [CK_PS_DOC_HDR_HAS_PCKD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_HAS_PCKD_LINS] CHECK  (([HAS_PCKD_LINS]='N' OR [HAS_PCKD_LINS]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_HAS_PCKD_LINS]
GO
/****** Object:  Check [CK_PS_DOC_HDR_HAS_PCKVRFD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_HAS_PCKVRFD_LINS] CHECK  (([HAS_PCKVRFD_LINS]='N' OR [HAS_PCKVRFD_LINS]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_HAS_PCKVRFD_LINS]
GO
/****** Object:  Check [CK_PS_DOC_HDR_HAS_RLSD_LINS]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_HAS_RLSD_LINS] CHECK  (([HAS_RLSD_LINS]='N' OR [HAS_RLSD_LINS]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_HAS_RLSD_LINS]
GO
/****** Object:  Check [CK_PS_DOC_HDR_IS_DOC_COMMITTED]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_IS_DOC_COMMITTED] CHECK  (([IS_DOC_COMMITTED]='N' OR [IS_DOC_COMMITTED]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_IS_DOC_COMMITTED]
GO
/****** Object:  Check [CK_PS_DOC_HDR_IS_REL_TKT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_IS_REL_TKT] CHECK  (([IS_REL_TKT]='N' OR [IS_REL_TKT]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_IS_REL_TKT]
GO
/****** Object:  Check [CK_PS_DOC_HDR_REQ_REPRICE]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_REQ_REPRICE] CHECK  (([REQ_REPRICE]='N' OR [REQ_REPRICE]='Y'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_REQ_REPRICE]
GO
/****** Object:  Check [CK_PS_DOC_HDR_SHIP_DAT]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_SHIP_DAT] CHECK  (([SHIP_DAT] IS NULL OR [SHIP_DAT]=[dbo].[fnDateOnly]([SHIP_DAT])))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_SHIP_DAT]
GO
/****** Object:  Check [CK_PS_DOC_HDR_TKT_TYP]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [CK_PS_DOC_HDR_TKT_TYP] CHECK  (([TKT_TYP]='R' OR [TKT_TYP]='A' OR [TKT_TYP]='O' OR [TKT_TYP]='I' OR [TKT_TYP]='T'))
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [CK_PS_DOC_HDR_TKT_TYP]
GO
/****** Object:  ForeignKey [FK_AR_CUST_AR_CATEG_COD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [FK_AR_CUST_AR_CATEG_COD] FOREIGN KEY([CATEG_COD])
REFERENCES [dbo].[AR_CATEG_COD] ([CATEG_COD])
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [FK_AR_CUST_AR_CATEG_COD]
GO
/****** Object:  ForeignKey [FK_AR_CUST_AR_FCH_COD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [FK_AR_CUST_AR_FCH_COD] FOREIGN KEY([FCH_COD])
REFERENCES [dbo].[AR_FCH_COD] ([FCH_COD])
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [FK_AR_CUST_AR_FCH_COD]
GO
/****** Object:  ForeignKey [FK_AR_CUST_AR_LOY_PGM]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [FK_AR_CUST_AR_LOY_PGM] FOREIGN KEY([LOY_PGM_COD])
REFERENCES [dbo].[AR_LOY_PGM] ([LOY_PGM_COD])
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [FK_AR_CUST_AR_LOY_PGM]
GO
/****** Object:  ForeignKey [FK_AR_CUST_AR_TERMS_COD]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [FK_AR_CUST_AR_TERMS_COD] FOREIGN KEY([TERMS_COD])
REFERENCES [dbo].[AR_TERMS_COD] ([TERMS_COD])
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [FK_AR_CUST_AR_TERMS_COD]
GO
/****** Object:  ForeignKey [FK_AR_CUST_PS_STR]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[AR_CUST]  WITH CHECK ADD  CONSTRAINT [FK_AR_CUST_PS_STR] FOREIGN KEY([STR_ID])
REFERENCES [dbo].[PS_STR] ([STR_ID])
GO
ALTER TABLE [dbo].[AR_CUST] CHECK CONSTRAINT [FK_AR_CUST_PS_STR]
GO
/****** Object:  ForeignKey [FK_PS_DOC_HDR_PS_STA]    Script Date: 08/03/2011 16:04:53 ******/
ALTER TABLE [dbo].[PS_DOC_HDR]  WITH CHECK ADD  CONSTRAINT [FK_PS_DOC_HDR_PS_STA] FOREIGN KEY([STR_ID], [STA_ID])
REFERENCES [dbo].[PS_STA] ([STR_ID], [STA_ID])
GO
ALTER TABLE [dbo].[PS_DOC_HDR] CHECK CONSTRAINT [FK_PS_DOC_HDR_PS_STA]
GO
Go to Top of Page

aharvestofhealth
Yak Posting Veteran

52 Posts
Posted - 2011-08-03 : 16:36:15
Here is some sample data:
dbo.AR_CUST (Primary Key = CUST_NO; Foreign Key = STR_ID, LOY_PGM_COD)
CUST_NO	 NAM		ADRS_1		 CITY	 STATE	 ZIP_COD       STR_ID	  LOY_PGM_COD	  LOY_PTS_BAL
10003	 Jon Doe	1234 Street	 Anytown  TN	 12345		1	     REWARDS		5160

dbo.PS_DOC_HDR (Primary Key = DOC_ID; Foreign Key = STR_ID)
DOC_ID	 STR_ID	 CUST_NO   DOC_TYP   LOY_PGM_COD
101101   1	 10003     T	     REWARDS
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site