| |||
API RTW1 | |||
RTW1 - Boleto Retorno Wizard: Import Table Table SBO SQL database table detailsSELECT statementSELECT
RTW1.AbsEntry AS 'Internal Number',
RTW1.BoeMatch AS 'BoE Match',
RTW1.BoeNo AS 'BoE Number',
RTW1.BoeDate AS 'BoE Date',
RTW1.BoeDueDate AS 'BoE Due Date',
RTW1.CreditDate AS 'Credit Date',
RTW1.CurrBoeSt AS 'Current BoE Status',
RTW1.ReqBoeSt AS 'Requested BoE Status',
RTW1.Instruct1 AS 'BoE Instruction 1',
RTW1.Instruct2 AS 'BoE Instruction 2',
RTW1.CancelCode AS 'Cancellation Code',
RTW1.MovmntCode AS 'Movement Code',
RTW1.OccurCode AS 'Occurrence Code',
RTW1.OccurDate AS 'Occurrence Date',
RTW1.Portfolio AS 'Portfolio',
RTW1.OurNum AS 'Our Number',
RTW1.ValueOfT AS 'Value of Title',
RTW1.NetAmnt AS 'Net Amount',
RTW1.PaidAmnt AS 'Paid Amount',
RTW1.FineAmnt AS 'Fine Amount',
RTW1.IntAmnt AS 'Interest Amount',
RTW1.Discounts AS 'Discount Amount',
RTW1.ServiceFee AS 'Service Fee',
RTW1.IOFTax AS 'IOF Tax',
RTW1.OtherCred AS 'Other Credits',
RTW1.OtherExp AS 'Other Expenses',
RTW1.OtherInc AS 'Other Incomes',
RTW1.Errors AS 'Errors',
RTW1.RefNum AS 'Reference No.',
RTW1.Ref2 AS 'Reference 2',
RTW1.CardName AS 'BP Name',
RTW1.BoEBPName AS 'BoE BP Name',
RTW1.MatchCode AS 'Match Code',
RTW1.Selected AS 'Selected',
RTW1.BoeRec AS 'BoE Record Number',
RTW1.RetIndex AS 'RET File Record Index',
RTW1.Filtered AS 'Filtered',
RTW1.Executed AS 'Executed',
RTW1.Failed AS 'Failed',
RTW1.LastRun AS 'Last Run',
RTW1.ErrorMsg AS 'Error Message',
RTW1.JETransId AS 'JE Trans. ID',
RTW1.CardCode AS 'BoE BP Code',
RTW1.PostType AS 'Transaction Type'
FROM RTW1 AS RTW1 Related information |
|||
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |