biuan SAP® BUSINESS ONE SDK
API RTW1
RTW1 - Boleto Retorno Wizard: Import Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
BoeMatchBoE MatchnVarChar
10
BoeNoBoE NumbernVarChar
10
BoeDateBoE DateDate
8
BoeDueDateBoE Due DateDate
8
CreditDateCredit DateDate
8
CurrBoeStCurrent BoE StatusVarChar
G) Generated
S) Sent
D) Deposited
P) Paid
C) Canceled
L) Closed
F) Failed
V) BoE to Vendor
1
ReqBoeStRequested BoE StatusVarChar
G) Generated
S) Sent
D) Deposited
P) Paid
C) Canceled
L) Closed
F) Failed
V) BoE to Vendor
1
Instruct1BoE Instruction 1nVarChar
2
Instruct2BoE Instruction 2nVarChar
2
CancelCodeCancellation CodenVarChar
4
MovmntCodeMovement CodeInt
6
OccurCodeOccurrence CodeInt
6
OccurDateOccurrence DateDate
8
PortfolioPortfolioVarChar
1
OurNumOur NumberInt
11
ValueOfTValue of TitleNum
20
NetAmntNet AmountNum
20
PaidAmntPaid AmountNum
20
FineAmntFine AmountNum
20
IntAmntInterest AmountNum
20
DiscountsDiscount AmountNum
20
ServiceFeeService FeeNum
20
IOFTaxIOF TaxNum
20
OtherCredOther CreditsNum
20
OtherExpOther ExpensesNum
20
OtherIncOther IncomesNum
20
ErrorsErrorsnVarChar
8
RefNumReference No.nVarChar
127
Ref2Reference 2nVarChar
127
CardNameBP NamenVarChar
100
BoEBPNameBoE BP NamenVarChar
100
MatchCodeMatch CodeVarChar
A) Automatic
M) Manual
N) Not Identified
1
N
SelectedSelectedVarChar
1
N
BoeRecBoE Record NumberInt
11
RetIndexRET File Record IndexInt
11
FilteredFilteredVarChar
1
Y
ExecutedExecutedVarChar
1
N
FailedFailedVarChar
1
N
LastRunLast RunVarChar
1
N
ErrorMsgError MessagenVarChar
127
JETransIdJE Trans. IDnVarChar
10
CardCodeBoE BP CodenVarChar
15
PostTypeTransaction TypeVarChar
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




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates