|
1
|
UPDATE [dbo].[TR_REQ_PAY_ENTRIES]
|
|
2
|
SET [REQ_PAY_DT_ID] = <REQ_PAY_DT_ID, varchar(15),>
|
|
3
|
,[REQ_PAY_ID] = <REQ_PAY_ID, varchar(15),>
|
|
4
|
,[FUNCTION_TYPE] = <FUNCTION_TYPE, varchar(15),>
|
|
5
|
,[TRN_TYPE] = <TRN_TYPE, nvarchar(40),>
|
|
6
|
,[REF_ID] = <REF_ID, varchar(15),>
|
|
7
|
,[ENTRY_PAIR] = <ENTRY_PAIR, varchar(50),>
|
|
8
|
,[DR_CR] = <DR_CR, varchar(2),>
|
|
9
|
,[DR_CR_NAME] = <DR_CR_NAME, nvarchar(50),>
|
|
10
|
,[ACCT] = <ACCT, varchar(100),>
|
|
11
|
,[ACCT_NAME] = <ACCT_NAME, varchar(500),>
|
|
12
|
,[BRANCH_ID] = <BRANCH_ID, varchar(15),>
|
|
13
|
,[DEP_ID] = <DEP_ID, varchar(15),>
|
|
14
|
,[AMT] = <AMT, decimal(18,0),>
|
|
15
|
,[CURRENCY] = <CURRENCY, varchar(20),>
|
|
16
|
,[EXC_RATE] = <EXC_RATE, decimal(18,0),>
|
|
17
|
,[TRN_DATE] = <TRN_DATE, datetime,>
|
|
18
|
,[TRN_DESC] = <TRN_DESC, nvarchar(1000),>
|
|
19
|
,[MAKER_ID] = <MAKER_ID, varchar(15),>
|
|
20
|
,[CREATE_DT] = <CREATE_DT, datetime,>
|
|
21
|
,[AUTH_STATUS] = <AUTH_STATUS, varchar(1),>
|
|
22
|
,[CHECKER_ID] = <CHECKER_ID, varchar(15),>
|
|
23
|
,[APPROVE_DT] = <APPROVE_DT, datetime,>
|
|
24
|
,[MAKER_ID_KT] = <MAKER_ID_KT, varchar(15),>
|
|
25
|
,[CREATE_DT_KT] = <CREATE_DT_KT, datetime,>
|
|
26
|
,[AUTH_STATUS_KT] = <AUTH_STATUS_KT, varchar(1),>
|
|
27
|
,[CHECKER_ID_KT] = <CHECKER_ID_KT, varchar(15),>
|
|
28
|
,[APPROVE_DT_KT] = <APPROVE_DT_KT, datetime,>
|
|
29
|
,[RECORD_STATUS] = <RECORD_STATUS, varchar(1),>
|
|
30
|
WHERE <Search Conditions,,>
|
|
31
|
GO
|