biuan SAP® BUSINESS ONE SDK
API CASE1
CASE1 - Internal Recon. Upgrade 2007A Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEHeader Internal IDInt
11CASE
Internal Recon. Upgrade 2007A
PRIMARYYes
LineIdInconsistent Amt NumberInt
11
0
ShortNameBP CodenVarChar
15
AccountAccount CodenVarChar
15OACT
G/L Accounts
OrigAbsEntOriginal Doc. Internal IDInt
11
OrigObjTypOriginal Doc. TypeInt
0
13) A/R Invoice
14) A/R Credit Memo
18) A/P Invoice
19) A/P Credit Memo
24) Incoming Payment
30) Journal Entry
46) Outgoing Payment
163) A/P Correction Invoice
165) A/R Correction Invoice
203) A/R Down Payment
204) A/P Down Payment
11
0
OrigDocNumOriginal Document NumberInt
11
OrigInsNumOriginal Installment NumberInt
11
OrigTrnsIdOriginal JE Trans. No.Int
11OJDT
Journal Entry
OrigTrnsLnOriginal JE Row No.Int
11
LnkRecnAbsLinked Recon. Doc. Internal IDInt
11
LnkRecnObjDestination Object TypeInt
11
LnkRecnNumDestination Document NumberInt
11
LnkRecnInsDestination Installment NumberInt
11
LnkRecnTrnLinked and Recon. JE Trans No.Int
11OJDT
Journal Entry
LnkRecnLnLinked and Recon. JE Row No.Int
11
InconsTypeType of InconsistencynVarChar
1) Invoice Linked to Reconciled Payment
2) Credit Memo Linked to Reconciled Payment
3) Canceled Reconciliation
4) Partial Exchange Rate Difference Recognition
5) Payment Linked to Reconciled Transaction
6) Journal Entry Linked to Reconciled Payment
7) Unbalanced Reconciliation
8) Invoice/Credit Linked to Credit/Invoice
9) Balancing Upgrade Journal Transaction
10) Canceled Payment or Journal Entry
11) Cancellation of Payment/JE within Payment
12) Unreconciled Balance Rows in Multiple BPs Reconciliation
13) Missing Exchange Rate Difference behind Multiple BPs Reconciliation
14) Double Application of Payments of Down Payment Request
15) Exchange Difference Recognition of Payments of DPM Requests
16) Reconciliation of Payments Associated with DPM Request
17) Unbalanced Multiple BP Reconciliation
18) Amount Differences
19) Double application of invoice after linking of down payment
20) Canceled payment of down payment request
21) Credit Memo based on a Year Transfered invoice
22) Payment of a year transfer document
23) Processing of Payment Linked to Transactions
24) Consolidating Business Partner
25) Multiple Control Accounts
26) Different Control Accounts in a Canceled Payment
0
2
ReconNumReconciliation NumberInt
11
NewRcnNumNew Reconciliation No.Int
11OITR
Internal Reconciliation
CredDebCredit or DebitVarChar
1
AmountInconsistent AmountNum
20
AmountFCInconsistent Amount (FC)Num
20
AmountSCInconsistent Amount (SC)Num
20
TransIdBalancing Trans. Internal IDInt
11OJDT
Journal Entry
TransLineBalancing Transaction Row No.Int
11
XxNum
20
YYNum
20
ZZNum
20
LnkObjAbsELinked Doc. Internal IDInt
11
LinkObjTypLinked Document TypeInt
11
LinkDocNumLinked Document NumberInt
11
LinkInsNumLinked Doc. Installment NumberInt
11
LinkTrnsIdLinked Doc. JE Trans. No.Int
11OJDT
Journal Entry
LinkTrnsLnLinked Doc. JE Row No.Int
11
TrnsTtlAmtBalancing Trans. Total AmountNum
20
TrnsTtlFcBalancing Trans. Total Amt FCNum
20

Table relationship map

SELECT statement

SELECT CASE1.AbsEntry AS 'Header Internal ID', CASE1.LineId AS 'Inconsistent Amt Number', CASE1.ShortName AS 'BP Code', CASE1.Account AS 'Account Code', CASE1.OrigAbsEnt AS 'Original Doc. Internal ID', CASE1.OrigObjTyp AS 'Original Doc. Type', CASE1.OrigDocNum AS 'Original Document Number', CASE1.OrigInsNum AS 'Original Installment Number', CASE1.OrigTrnsId AS 'Original JE Trans. No.', CASE1.OrigTrnsLn AS 'Original JE Row No.', CASE1.LnkRecnAbs AS 'Linked Recon. Doc. Internal ID', CASE1.LnkRecnObj AS 'Destination Object Type', CASE1.LnkRecnNum AS 'Destination Document Number', CASE1.LnkRecnIns AS 'Destination Installment Number', CASE1.LnkRecnTrn AS 'Linked and Recon. JE Trans No.', CASE1.LnkRecnLn AS 'Linked and Recon. JE Row No.', CASE1.InconsType AS 'Type of Inconsistency', CASE1.ReconNum AS 'Reconciliation Number', CASE1.NewRcnNum AS 'New Reconciliation No.', CASE1.CredDeb AS 'Credit or Debit', CASE1.Amount AS 'Inconsistent Amount', CASE1.AmountFC AS 'Inconsistent Amount (FC)', CASE1.AmountSC AS 'Inconsistent Amount (SC)', CASE1.TransId AS 'Balancing Trans. Internal ID', CASE1.TransLine AS 'Balancing Transaction Row No.', CASE1.X AS 'x', CASE1.Y AS 'Y', CASE1.Z AS 'Z', CASE1.LnkObjAbsE AS 'Linked Doc. Internal ID', CASE1.LinkObjTyp AS 'Linked Document Type', CASE1.LinkDocNum AS 'Linked Document Number', CASE1.LinkInsNum AS 'Linked Doc. Installment Number', CASE1.LinkTrnsId AS 'Linked Doc. JE Trans. No.', CASE1.LinkTrnsLn AS 'Linked Doc. JE Row No.', CASE1.TrnsTtlAmt AS 'Balancing Trans. Total Amount', CASE1.TrnsTtlFc AS 'Balancing Trans. Total Amt FC' FROM CASE1 AS CASE1

Related information


Internal Recon. Upgrade 2007A CASE SQL Table

G/L Accounts OACT SQL Table

Journal Entry OJDT SQL Table

Internal Reconciliation OITR SQL Table



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