25 lines
651 B
Transact-SQL
25 lines
651 B
Transact-SQL
SELECT
|
|
RTRIM([VENDORID]) AS vendorid,
|
|
RTRIM([VCHRNMBR]) AS vchrnmbr,
|
|
[DOCTYPE] AS doctype,
|
|
RTRIM([BACHNUMB]) AS bachnumb,
|
|
RTRIM([TAXDTLID]) AS taxdtlid,
|
|
[BKOUTTAX] AS bkouttax,
|
|
[TAXAMNT] AS taxamnt,
|
|
[ORTAXAMT] AS ortaxamt,
|
|
[PCTAXAMT] AS pctaxamt,
|
|
[ORPURTAX] AS orpurtax,
|
|
[FRTTXAMT] AS frttxamt,
|
|
[ORFRTTAX] AS orfrttax,
|
|
[MSCTXAMT] AS msctxamt,
|
|
[ORMSCTAX] AS ormsctax,
|
|
[ACTINDX] AS actindx,
|
|
RTRIM([TRXSORCE]) AS trxsorce,
|
|
[TDTTXPUR] AS tdttxpur,
|
|
[ORTXBPUR] AS ortxbpur,
|
|
[TXDTTPUR] AS txdttpur,
|
|
[ORTOTPUR] AS ortotpur,
|
|
[CURRNIDX] AS currnidx,
|
|
[DEX_ROW_ID] AS dex_row_id
|
|
FROM [usavmsql01].[CHG].[dbo].[PM30700]
|