17 lines
453 B
Transact-SQL
17 lines
453 B
Transact-SQL
SELECT
|
|
RTRIM([CNTRLNUM]) AS cntrlnum,
|
|
[CNTRLTYP] AS cntrltyp,
|
|
[DCSTATUS] AS dcstatus,
|
|
[DOCTYPE] AS doctype,
|
|
RTRIM([VENDORID]) AS vendorid,
|
|
RTRIM([DOCNUMBR]) AS docnumbr,
|
|
RTRIM([TRXSORCE]) AS trxsorce,
|
|
RTRIM([CHEKBKID]) AS chekbkid,
|
|
[DUEDATE] AS duedate,
|
|
[DISCDATE] AS discdate,
|
|
RTRIM([BCHSOURC]) AS bchsourc,
|
|
[DOCDATE] AS docdate,
|
|
RTRIM([USERID]) AS userid,
|
|
[DEX_ROW_ID] AS dex_row_id
|
|
FROM [usavmsql01].[CHG].[dbo].[PM00400]
|