[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Emergency fixed....I think

OK, so this version works perfectly....any idea why?? Thanks again.

Timm






#include 'setenv.sqc'   !Set environment procedure.


begin-program

display 'Step #1'

begin-SQL
INSERT INTO PS_PYMNT_WTHD_BOOK
(BUSINESS_UNIT
,VOUCHER_ID
,PYMNT_CNT
,VOUCHER_LINE_NUM
,WTHD_ENTITY
,WTHD_TYPE
,WTHD_CLASS
,LEDGER_GROUP
,LEDGER
,BASE_CURRENCY
,CUR_RT_TYPE_PYMNT
,PYMNT_RATE_MULT
,PYMNT_RATE_DIV
,WTHD_BASIS_AMT_BSE
,WTHD_AMT_BSE
,PRIMARY_LEDGER
,PROCESS_INSTANCE
)
VALUES
('BIPER'
,'00077816'
,1
,1
,'IRS'
,'1099'
,'07'
,'ACTUALS'
,'ACTUALS'
,'USD'
,'CRRNT'
,1
,1
,1
,1
,'Y'
,0
)

end-SQL
display 'Step #2'
end-program