RTW1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Banking / Boleto Retorno Wizard: Import Table

API RTW1

RTW1 - Boleto Retorno Wizard: Import Table Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
BoeMatch	BoE Match	nVarChar		10
BoeNo	BoE Number	nVarChar		10
BoeDate	BoE Date	Date		8
BoeDueDate	BoE Due Date	Date		8
CreditDate	Credit Date	Date		8
CurrBoeSt	Current BoE Status	VarChar	G) Generated S) Sent D) Deposited P) Paid C) Canceled L) Closed F) Failed V) BoE to Vendor	1
ReqBoeSt	Requested BoE Status	VarChar	G) Generated S) Sent D) Deposited P) Paid C) Canceled L) Closed F) Failed V) BoE to Vendor	1
Instruct1	BoE Instruction 1	nVarChar		2
Instruct2	BoE Instruction 2	nVarChar		2
CancelCode	Cancellation Code	nVarChar		4
MovmntCode	Movement Code	Int		6
OccurCode	Occurrence Code	Int		6
OccurDate	Occurrence Date	Date		8
Portfolio	Portfolio	VarChar		1
OurNum	Our Number	Int		11
ValueOfT	Value of Title	Num		20
NetAmnt	Net Amount	Num		20
PaidAmnt	Paid Amount	Num		20
FineAmnt	Fine Amount	Num		20
IntAmnt	Interest Amount	Num		20
Discounts	Discount Amount	Num		20
ServiceFee	Service Fee	Num		20
IOFTax	IOF Tax	Num		20
OtherCred	Other Credits	Num		20
OtherExp	Other Expenses	Num		20
OtherInc	Other Incomes	Num		20
Errors	Errors	nVarChar		8
RefNum	Reference No.	nVarChar		127
Ref2	Reference 2	nVarChar		127
CardName	BP Name	nVarChar		100
BoEBPName	BoE BP Name	nVarChar		100
MatchCode	Match Code	VarChar	A) Automatic M) Manual N) Not Identified	1	N
Selected	Selected	VarChar		1	N
BoeRec	BoE Record Number	Int		11
RetIndex	RET File Record Index	Int		11
Filtered	Filtered	VarChar		1	Y
Executed	Executed	VarChar		1	N
Failed	Failed	VarChar		1	N
LastRun	Last Run	VarChar		1	N
ErrorMsg	Error Message	nVarChar		127
JETransId	JE Trans. ID	nVarChar		10
CardCode	BoE BP Code	nVarChar		15
PostType	Transaction Type	VarChar	C) Collection D) Discounted	1	C

SELECT statement

SELECT
   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

biuan SAP® BUSINESS ONE

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