• FULL TABLE DEFINITIONS INCLUDE:

    TABLE:

    CREATE TABLE [dbo].[BD1_STD_TEXT_LDG](

    [ACCNT_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [PERIOD] [dbo].[FIN_PERD_INT] NOT NULL,

    [TRANS_DATETIME] [dbo].[FIN_DATETIME] NOT NULL,

    [JRNAL_NO] [dbo].[FIN_JNL_NUM] NOT NULL,

    [JRNAL_LINE] [dbo].[FIN_JNL_LINE] NOT NULL,

    [STD_TEXT_CLASS_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [STD_TEXT_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [UPDATE_COUNT] [dbo].[UPDATE_CNT] NOT NULL,

    [LAST_CHANGE_USER_ID] [dbo].[LAST_CHANGE_USER_ID] NOT NULL,

    [LAST_CHANGE_DATETIME] [dbo].[LAST_CHANGE_DATETIME] NOT NULL,

    PRIMARY KEY NONCLUSTERED

    (

    [ACCNT_CODE] ASC,

    [PERIOD] ASC,

    [TRANS_DATETIME] ASC,

    [JRNAL_NO] ASC,

    [JRNAL_LINE] ASC,

    [STD_TEXT_CLASS_CODE] ASC,

    [STD_TEXT_CODE] 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

    ALTER TABLE [dbo].[BD1_STD_TEXT_LDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0414_01_0901] FOREIGN KEY([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    REFERENCES [dbo].[BD1_A_SALFLDG] ([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    GO

    ALTER TABLE [dbo].[BD1_STD_TEXT_LDG] CHECK CONSTRAINT [FK_BD1_0414_01_0901]

    GO

    ALTER TABLE [dbo].[BD1_STD_TEXT_LDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0414_02_0136] FOREIGN KEY([STD_TEXT_CLASS_CODE], [STD_TEXT_CODE])

    REFERENCES [dbo].[STD_TEXT] ([STD_TEXT_CLASS_CODE], [STD_TEXT_CODE])

    GO

    ALTER TABLE [dbo].[BD1_STD_TEXT_LDG] CHECK CONSTRAINT [FK_BD1_0414_02_0136]

    TABLE

    CREATE TABLE [dbo].[BD1_A_SALFLEX](

    [ACCNT_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [PERIOD] [dbo].[FIN_PERD_INT] NOT NULL,

    [TRANS_DATETIME] [dbo].[FIN_DATETIME] NOT NULL,

    [JRNAL_NO] [dbo].[FIN_JNL_NUM] NOT NULL,

    [JRNAL_LINE] [dbo].[FIN_JNL_LINE] NOT NULL,

    [DOC_1_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DOC_2_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DOC_3_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DOC_4_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DOC_NUM_PREF_1] [dbo].[FIN_DOC_NUM_PREF_1] NULL,

    [DOC_NUMBER_1] [dbo].[FIN_DOC_NUM] NOT NULL,

    [DOC_NUM_PREF_2] [dbo].[FIN_DOC_NUM_PREF_1] NULL,

    [DOC_NUMBER_2] [dbo].[FIN_DOC_NUM] NOT NULL,

    [DOC_NUM_PREF_3] [dbo].[FIN_DOC_NUM_PREF_1] NULL,

    [DOC_NUMBER_3] [dbo].[FIN_DOC_NUM] NOT NULL,

    [DOC_NUM_PREF_4] [dbo].[FIN_DOC_NUM_PREF_1] NULL,

    [DOC_NUMBER_4] [dbo].[FIN_DOC_NUM] NOT NULL,

    [DISC_1_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DISC_PERCENT_1] [dbo].[FIN_PERCENTAGE] NOT NULL,

    [DISC_2_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [DISC_PERCENT_2] [dbo].[FIN_PERCENTAGE] NOT NULL,

    [INTEREST_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [INTEREST_PERCENT] [dbo].[FIN_PERCENTAGE] NOT NULL,

    [LATE_PAY_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [LATE_PAY_PERCENT] [dbo].[FIN_PERCENTAGE] NOT NULL,

    [PAYMENT_REF] [dbo].[FIN_PYMT_REF] NOT NULL,

    [BANK_CODE] [dbo].[FIN_BANK_CODE] NOT NULL,

    [SOURCE_REF] [dbo].[FIN_SRCE_REF] NOT NULL,

    [MODULE_CODE] [dbo].[FIN_MODULE_CODE] NOT NULL,

    [PAYMENT_TERMS_CODE] [dbo].[FIN_PYMT_TERMS_CODE] NOT NULL,

    [PYMT_SPLITS_TERMS_CODE] [dbo].[REF_MAINT_CODE] NULL,

    PRIMARY KEY CLUSTERED

    (

    [ACCNT_CODE] ASC,

    [PERIOD] ASC,

    [TRANS_DATETIME] ASC,

    [JRNAL_NO] ASC,

    [JRNAL_LINE] 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

    ALTER TABLE [dbo].[BD1_A_SALFLEX] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0900_01_0901] FOREIGN KEY([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    REFERENCES [dbo].[BD1_A_SALFLDG] ([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLEX] CHECK CONSTRAINT [FK_BD1_0900_01_0901]

    TABLE

    CREATE TABLE [dbo].[BD1_A_SALFLDG](

    [ACCNT_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [PERIOD] [dbo].[FIN_PERD_INT] NOT NULL,

    [TRANS_DATETIME] [dbo].[FIN_DATETIME] NOT NULL,

    [JRNAL_NO] [dbo].[FIN_JNL_NUM] NOT NULL,

    [JRNAL_LINE] [dbo].[FIN_JNL_LINE] NOT NULL,

    [AMOUNT] [dbo].[FIN_AMOUNT_BASE] NOT NULL,

    [D_C] [dbo].[FIN_FLAG_D_C] NOT NULL,

    [ALLOCATION] [dbo].[FIN_FLAG_ALLOCN_BR] NOT NULL,

    [JRNAL_TYPE] [dbo].[FIN_JNL_TYPE] NULL,

    [JRNAL_SRCE] [dbo].[FIN_JNL_SRCE] NOT NULL,

    [TREFERENCE] [dbo].[TRANSACTION_REF_MIXED] NULL,

    [DESCRIPTN] [dbo].[FIN_DESCR_50] NULL,

    [ENTRY_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [ENTRY_PRD] [dbo].[FIN_PERD_INT] NOT NULL,

    [DUE_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [ALLOC_REF] [dbo].[FIN_ALLOCN_REF] NOT NULL,

    [ALLOC_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [ALLOC_PERIOD] [dbo].[FIN_PERD_INT] NOT NULL,

    [ASSET_IND] [dbo].[FIN_FLAG_ASSET] NOT NULL,

    [ASSET_CODE] [dbo].[FIN_ASSET_CODE] NOT NULL,

    [ASSET_SUB] [dbo].[FIN_ASSET_SUB_CODE] NOT NULL,

    [CONV_CODE] [dbo].[FIN_CONV_CODE] NOT NULL,

    [CONV_RATE] [dbo].[FIN_CONV_RATE] NOT NULL,

    [OTHER_AMT] [dbo].[FIN_OTHER_AMT_ACC] NOT NULL,

    [OTHER_DP] [dbo].[FIN_FLAG_OTHER_DP] NOT NULL,

    [CLEARDOWN] [dbo].[FIN_SEQ] NOT NULL,

    [REVERSAL] [dbo].[FIN_FLAG_Y_N_NA] NOT NULL,

    [LOSS_GAIN] [dbo].[FIN_LOSS_GAIN] NOT NULL,

    [ROUGH_FLAG] [dbo].[FIN_FLAG_ROUGH] NOT NULL,

    [IN_USE_FLAG] [dbo].[FIN_FLAG_Y_N_NA] NOT NULL,

    [ANAL_T0] [dbo].[FIN_ANL_T0] NOT NULL,

    [ANAL_T1] [dbo].[FIN_ANL_T1] NOT NULL,

    [ANAL_T2] [dbo].[FIN_ANL_T2] NOT NULL,

    [ANAL_T3] [dbo].[FIN_ANL_T3] NOT NULL,

    [ANAL_T4] [dbo].[FIN_ANL_T4] NOT NULL,

    [ANAL_T5] [dbo].[FIN_ANL_T5] NOT NULL,

    [ANAL_T6] [dbo].[FIN_ANL_T6] NOT NULL,

    [ANAL_T7] [dbo].[FIN_ANL_T7] NOT NULL,

    [ANAL_T8] [dbo].[FIN_ANL_T8] NOT NULL,

    [ANAL_T9] [dbo].[FIN_ANL_T9] NOT NULL,

    [POSTING_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [ALLOC_IN_PROGRESS] [dbo].[FIN_ALLOCN_IN_PROG] NOT NULL,

    [HOLD_REF] [dbo].[FIN_JNL_REF] NOT NULL,

    [HOLD_OP_ID] [dbo].[FIN_OPR_ID] NOT NULL,

    [BASE_RATE] [dbo].[FIN_CONV_RATE] NOT NULL,

    [BASE_OPERATOR] [dbo].[FIN_FLAG_OPN] NOT NULL,

    [CONV_OPERATOR] [dbo].[FIN_FLAG_OPN] NOT NULL,

    [REPORT_RATE] [dbo].[FIN_CONV_RATE] NOT NULL,

    [REPORT_OPERATOR] [dbo].[FIN_FLAG_OPN] NOT NULL,

    [REPORT_AMT] [dbo].[FIN_AMT_RPTG_ACC] NOT NULL,

    [MEMO_AMT] [dbo].[FIN_AMT_MEMO_ACC] NOT NULL,

    [EXCLUDE_BAL] [dbo].[FIN_FLAG_Y_N_NA] NOT NULL,

    [LE_DETAILS_IND] [dbo].[FIN_FLAG_LE_DETAILS] NOT NULL,

    [CONSUMED_BDGT_ID] [dbo].[NUM_INT] NOT NULL,

    [CV4_CONV_CODE] [dbo].[FIN_CONV_CODE] NOT NULL DEFAULT (' '),

    [CV4_AMT] [dbo].[FIN_AMOUNT_BASE] NOT NULL DEFAULT ((0)),

    [CV4_CONV_RATE] [dbo].[FIN_CONV_RATE] NOT NULL DEFAULT ((0)),

    [CV4_OPERATOR] [dbo].[FIN_FLAG_OPN] NOT NULL DEFAULT ('*'),

    [CV4_DP] [dbo].[FIN_FLAG_OTHER_DP] NOT NULL DEFAULT (' '),

    [CV5_CONV_CODE] [dbo].[FIN_CONV_CODE] NOT NULL DEFAULT (' '),

    [CV5_AMT] [dbo].[FIN_AMOUNT_BASE] NOT NULL DEFAULT ((0)),

    [CV5_CONV_RATE] [dbo].[FIN_CONV_RATE] NOT NULL DEFAULT ((0)),

    [CV5_OPERATOR] [dbo].[FIN_FLAG_OPN] NOT NULL DEFAULT ('*'),

    [CV5_DP] [dbo].[FIN_FLAG_OTHER_DP] NOT NULL DEFAULT (' '),

    [LINK_REF_1] [dbo].[CHAR_ALPHA_V15] NULL,

    [LINK_REF_2] [dbo].[CHAR_ALPHA_V15] NULL,

    [LINK_REF_3] [dbo].[CHAR_ALPHA_V15] NULL,

    [ALLOCN_CODE] [dbo].[CHAR_CODE_5] NULL,

    [ALLOCN_STMNTS] [dbo].[NUM_SMALLINT] NULL,

    [OPR_CODE] [dbo].[OPERATOR_CODE] NULL,

    [SPLIT_ORIG_LINE] [dbo].[NUM_INT] NOT NULL DEFAULT ((0)),

    [VAL_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [SIGNING_DETAILS] [dbo].[STRING_V30] NULL,

    [INSTLMT_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [PRINCIPAL_REQD] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [BINDER_STATUS] [dbo].[FIN_FLAG_BINDER_STATUS] NOT NULL DEFAULT (' '),

    [AGREED_STATUS] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((1)),

    [SPLIT_LINK_REF] [dbo].[CHAR_ALPHA_V15] NULL,

    [PSTG_REF] [dbo].[CHAR_ALPHA_V15] NULL,

    [TRUE_RATED] [dbo].[FLAG_TRUE_RATED] NOT NULL DEFAULT ((0)),

    [HOLD_DATETIME] [dbo].[FIN_DATETIME] NULL,

    [HOLD_TEXT] [dbo].[STRING_V30] NULL,

    [INSTLMT_NUM] [dbo].[NUM_SMALLINT] NULL,

    [SUPPLMNTRY_EXTSN] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [APRVLS_EXTSN] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [REVAL_LINK_REF] [dbo].[NUM_INT] NULL,

    [SAVED_SET_NUM] [dbo].[NUM_18_0] NULL,

    [AUTHORISTN_SET_REF] [int] NULL,

    [PYMT_AUTHORISTN_SET_REF] [int] NULL,

    [MAN_PAY_OVER] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [PYMT_STAMP] [dbo].[STRING_V10] NULL,

    [AUTHORISTN_IN_PROGRESS] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [SPLIT_IN_PROGRESS] [dbo].[FLAG_Y_N] NOT NULL DEFAULT ((0)),

    [VCHR_NUM] [dbo].[CHAR_ALPHA_V30] NULL,

    [JNL_CLASS_CODE] [dbo].[REF_MAINT_CODE] NULL,

    [ORIGINATOR_ID] [dbo].[OPERATOR_CODE] NULL,

    [ORIGINATED_DATETIME] [datetime] NULL,

    [LAST_CHANGE_USER_ID] [dbo].[LAST_CHANGE_USER_ID] NULL,

    [LAST_CHANGE_DATETIME] [datetime] NULL,

    [AFTER_PSTG_ID] [dbo].[OPERATOR_CODE] NULL,

    [AFTER_PSTG_DATETIME] [datetime] NULL,

    [POSTER_ID] [dbo].[OPERATOR_CODE] NULL,

    [ALLOC_ID] [dbo].[OPERATOR_CODE] NULL,

    [JNL_REVERSAL_TYPE] [dbo].[FLAG_JNL_REVERSAL_TYPE] NOT NULL DEFAULT ((0)),

    PRIMARY KEY CLUSTERED

    (

    [ACCNT_CODE] ASC,

    [PERIOD] ASC,

    [TRANS_DATETIME] ASC,

    [JRNAL_NO] ASC,

    [JRNAL_LINE] 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

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_01_0075] FOREIGN KEY([SAVED_SET_NUM])

    REFERENCES [dbo].[BD1_SAVED_SET] ([SAVED_SET_NUM])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_01_0075]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_01_0152] FOREIGN KEY([ACCNT_CODE])

    REFERENCES [dbo].[BD1_ACNT] ([ACNT_CODE])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_01_0152]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_01_0354] FOREIGN KEY([JRNAL_TYPE])

    REFERENCES [dbo].[BD1_JNL_DEFN] ([JOURNAL_TYPE])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_01_0354]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_01_0541] FOREIGN KEY([JNL_CLASS_CODE])

    REFERENCES [dbo].[BD1_JNL_CLASS] ([JNL_CLASS_CODE])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_01_0541]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_01_0923] FOREIGN KEY([AUTHORISTN_SET_REF])

    REFERENCES [dbo].[BD1_AUTHORISTN_SET_HDR] ([SET_REF_NUM])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_01_0923]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0901_02_0923] FOREIGN KEY([PYMT_AUTHORISTN_SET_REF])

    REFERENCES [dbo].[BD1_AUTHORISTN_SET_HDR] ([SET_REF_NUM])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] CHECK CONSTRAINT [FK_BD1_0901_02_0923]

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([D_C]='T' OR [D_C]='P' OR [D_C]='J' OR [D_C]='D' OR [D_C]='C'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([AGREED_STATUS]=(1) OR [AGREED_STATUS]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([ALLOCATION]='9' OR [ALLOCATION]='8' OR [ALLOCATION]='7' OR [ALLOCATION]='6' OR [ALLOCATION]='5' OR [ALLOCATION]='4' OR [ALLOCATION]='3' OR [ALLOCATION]='2' OR [ALLOCATION]='1' OR [ALLOCATION]='0' OR [ALLOCATION]='T' OR [ALLOCATION]='F' OR [ALLOCATION]='W' OR [ALLOCATION]='B' OR [ALLOCATION]='C' OR [ALLOCATION]='R' OR [ALLOCATION]='P' OR [ALLOCATION]='A' OR [ALLOCATION]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([APRVLS_EXTSN]=(1) OR [APRVLS_EXTSN]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([ASSET_IND]='V' OR [ASSET_IND]='I' OR [ASSET_IND]='D' OR [ASSET_IND]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([AUTHORISTN_SET_REF]<=(999999999)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([AUTHORISTN_IN_PROGRESS]=(1) OR [AUTHORISTN_IN_PROGRESS]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([BASE_OPERATOR]='T' OR [BASE_OPERATOR]='/' OR [BASE_OPERATOR]='-' OR [BASE_OPERATOR]='+' OR [BASE_OPERATOR]='*' OR [BASE_OPERATOR]='%'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([BINDER_STATUS]='B' OR [BINDER_STATUS]='A' OR [BINDER_STATUS]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([CONV_OPERATOR]='T' OR [CONV_OPERATOR]='/' OR [CONV_OPERATOR]='-' OR [CONV_OPERATOR]='+' OR [CONV_OPERATOR]='*' OR [CONV_OPERATOR]='%'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([CV4_DP]='5' OR [CV4_DP]='4' OR [CV4_DP]='3' OR [CV4_DP]='2' OR [CV4_DP]='1' OR [CV4_DP]='0' OR [CV4_DP]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([CV4_OPERATOR]='T' OR [CV4_OPERATOR]='/' OR [CV4_OPERATOR]='-' OR [CV4_OPERATOR]='+' OR [CV4_OPERATOR]='*' OR [CV4_OPERATOR]='%'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([CV5_DP]='5' OR [CV5_DP]='4' OR [CV5_DP]='3' OR [CV5_DP]='2' OR [CV5_DP]='1' OR [CV5_DP]='0' OR [CV5_DP]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([CV5_OPERATOR]='T' OR [CV5_OPERATOR]='/' OR [CV5_OPERATOR]='-' OR [CV5_OPERATOR]='+' OR [CV5_OPERATOR]='*' OR [CV5_OPERATOR]='%'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([EXCLUDE_BAL]=' ' OR [EXCLUDE_BAL]='N' OR [EXCLUDE_BAL]='Y'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([IN_USE_FLAG]=' ' OR [IN_USE_FLAG]='N' OR [IN_USE_FLAG]='Y'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([JNL_REVERSAL_TYPE]=(3) OR [JNL_REVERSAL_TYPE]=(2) OR [JNL_REVERSAL_TYPE]=(1) OR [JNL_REVERSAL_TYPE]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([LE_DETAILS_IND]=' ' OR [LE_DETAILS_IND]='Y'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([MAN_PAY_OVER]=(1) OR [MAN_PAY_OVER]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([OTHER_DP]='5' OR [OTHER_DP]='4' OR [OTHER_DP]='3' OR [OTHER_DP]='2' OR [OTHER_DP]='1' OR [OTHER_DP]='0' OR [OTHER_DP]=' '))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([PRINCIPAL_REQD]=(1) OR [PRINCIPAL_REQD]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([PYMT_AUTHORISTN_SET_REF]<=(999999999)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([REPORT_OPERATOR]='T' OR [REPORT_OPERATOR]='/' OR [REPORT_OPERATOR]='-' OR [REPORT_OPERATOR]='+' OR [REPORT_OPERATOR]='*' OR [REPORT_OPERATOR]='%'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([REVERSAL]=' ' OR [REVERSAL]='N' OR [REVERSAL]='Y'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([ROUGH_FLAG]=' ' OR [ROUGH_FLAG]='Y'))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([SAVED_SET_NUM]>=(1) AND [SAVED_SET_NUM]<=(9999999)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([SPLIT_IN_PROGRESS]=(1) OR [SPLIT_IN_PROGRESS]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([SUPPLMNTRY_EXTSN]=(1) OR [SUPPLMNTRY_EXTSN]=(0)))

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG] WITH NOCHECK ADD CHECK (([TRUE_RATED]=(11) OR [TRUE_RATED]=(10) OR [TRUE_RATED]=(2) OR [TRUE_RATED]=(1) OR [TRUE_RATED]=(0)))

    TABLE

    CREATE TABLE [dbo].[BD1_A_SALFLDG_LAD](

    [ACCNT_CODE] [dbo].[REF_MAINT_CODE] NOT NULL,

    [PERIOD] [dbo].[FIN_PERD_INT] NOT NULL,

    [TRANS_DATETIME] [dbo].[FIN_DATETIME] NOT NULL,

    [JRNAL_NO] [dbo].[FIN_JNL_NUM] NOT NULL,

    [JRNAL_LINE] [dbo].[FIN_JNL_LINE] NOT NULL,

    [UPDATE_COUNT] [dbo].[UPDATE_CNT] NOT NULL,

    [LAST_CHANGE_USER_ID] [dbo].[LAST_CHANGE_USER_ID] NOT NULL,

    [LAST_CHANGE_DATETIME] [dbo].[LAST_CHANGE_DATETIME] NOT NULL,

    [GNRL_DESCR_01] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_02] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_03] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_04] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_05] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_06] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_07] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_08] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_09] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_10] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_11] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_12] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_13] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_14] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_15] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_16] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_17] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_18] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_19] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_20] [dbo].[STRING_V30] NULL,

    [GNRL_1_DATETIME] [datetime] NULL,

    [GNRL_2_DATETIME] [datetime] NULL,

    [GNRL_3_DATETIME] [datetime] NULL,

    [GNRL_4_DATETIME] [datetime] NULL,

    [GNRL_5_DATETIME] [datetime] NULL,

    [GNRL_DESCR_21] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_22] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_23] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_24] [dbo].[STRING_V30] NULL,

    [GNRL_DESCR_25] [dbo].[STRING_V30] NULL,

    [USER_NAME] [dbo].[STRING_V30] NULL,

    PRIMARY KEY CLUSTERED

    (

    [ACCNT_CODE] ASC,

    [PERIOD] ASC,

    [TRANS_DATETIME] ASC,

    [JRNAL_NO] ASC,

    [JRNAL_LINE] 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

    ALTER TABLE [dbo].[BD1_A_SALFLDG_LAD] WITH NOCHECK ADD CONSTRAINT [FK_BD1_0887_01_0901] FOREIGN KEY([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    REFERENCES [dbo].[BD1_A_SALFLDG] ([ACCNT_CODE], [PERIOD], [TRANS_DATETIME], [JRNAL_NO], [JRNAL_LINE])

    GO

    ALTER TABLE [dbo].[BD1_A_SALFLDG_LAD] CHECK CONSTRAINT [FK_BD1_0887_01_0901]

    ACTUAL EXECUTION PLAN:

    see attachment