📚 SAP Business One SDK Help

Table Name: CASE1

Table Description: Internal Recon. Upgrade 2007A

Field Description Type Size Related Default Value Constraints
AbsEntry Header Internal ID Int 11 CASE      
LineId Inconsistent Amt Number Int 11 - 0    
ShortName BP Code nVarChar 15 -      
Account Account Code nVarChar 15 OACT      
OrigAbsEnt Original Doc. Internal ID Int 11 -      
OrigObjTyp Original Doc. Type Int 11 - 0 0 All
            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
OrigDocNum Original Document Number Int 11 -      
OrigInsNum Original Installment Number Int 11 -      
OrigTrnsId Original JE Trans. No. Int 11 OJDT      
OrigTrnsLn Original JE Row No. Int 11 -      
LnkRecnAbs Linked Recon. Doc. Internal ID Int 11 -      
LnkRecnObj Destination Object Type Int 11 -      
LnkRecnNum Destination Document Number Int 11 -      
LnkRecnIns Destination Installment Number Int 11 -      
LnkRecnTrn Linked and Recon. JE Trans No. Int 11 OJDT      
LnkRecnLn Linked and Recon. JE Row No. Int 11 -      
InconsType Type of Inconsistency nVarChar 2 -   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 None
ReconNum Reconciliation Number Int 11 -      
NewRcnNum New Reconciliation No. Int 11 OITR      
CredDeb Credit or Debit VarChar 1 -      
Amount Inconsistent Amount Num 19.6 -      
AmountFC Inconsistent Amount (FC) Num 19.6 -      
AmountSC Inconsistent Amount (SC) Num 19.6 -      
TransId Balancing Trans. Internal ID Int 11 OJDT      
TransLine Balancing Transaction Row No. Int 11 -      
X x Num 19.6 -      
Y Y Num 19.6 -      
Z Z Num 19.6 -      
LnkObjAbsE Linked Doc. Internal ID Int 11 -      
LinkObjTyp Linked Document Type Int 11 -      
LinkDocNum Linked Document Number Int 11 -      
LinkInsNum Linked Doc. Installment Number Int 11 -      
LinkTrnsId Linked Doc. JE Trans. No. Int 11 OJDT      
LinkTrnsLn Linked Doc. JE Row No. Int 11 -      
TrnsTtlAmt Balancing Trans. Total Amount Num 19.6 -      
TrnsTtlFc Balancing Trans. Total Amt FC Num 19.6 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LineId