biuan SAP® BUSINESS ONE SDK
API ARC1
ARC1 - Incoming Payment - Checks - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11OVPM
Outgoing Payments
PRIMARYYes
LineIDRow NumberInt
11
DueDateCheck DateDate
8
CheckNumCheck NumberInt
11
BankCodeAccount NumbernVarChar
30
-1
BranchBranch NumbernVarChar
50
AcctNumAccount NumbernVarChar
50
DetailsDetailsnVarChar
127
TrnsfrableNegotiableVarChar
Y) Yes
N) No
1
N
CheckSumCheck AmountNum
20
CurrencyCheck CurrencynVarChar
3
FlagsFlagsInt
11OCRN
Currency Codes
0
ObjTypeObjTypenVarChar
20ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0
CountryCodCountry CodenVarChar
3OCRY
Countries
CheckActCheck AccountnVarChar
15OACT
G/L Accounts
CheckAbsCheck ID EntryInt
11OCHO
Checks for Payment
BnkActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
ManualChkManual CheckVarChar
N) No
Y) Yes
1
N

Table relationship map

SELECT statement

SELECT ARC1.DocNum AS 'Document Number', ARC1.LineID AS 'Row Number', ARC1.DueDate AS 'Check Date', ARC1.CheckNum AS 'Check Number', ARC1.BankCode AS 'Account Number', ARC1.Branch AS 'Branch Number', ARC1.AcctNum AS 'Account Number', ARC1.Details AS 'Details', ARC1.Trnsfrable AS 'Negotiable', ARC1.CheckSum AS 'Check Amount', ARC1.Currency AS 'Check Currency', ARC1.Flags AS 'Flags', ARC1.ObjType AS 'ObjType', ARC1.LogInstanc AS 'Log Instance', ARC1.CountryCod AS 'Country Code', ARC1.CheckAct AS 'Check Account', ARC1.CheckAbs AS 'Check ID Entry', ARC1.BnkActKey AS 'Bank Account Internal ID', ARC1.ManualChk AS 'Manual Check' FROM ARC1 AS ARC1

Related information


House Bank Accounts DSC1 SQL Table

Checks for Payment OCHO SQL Table

G/L Accounts OACT SQL Table

Countries OCRY SQL Table

Outgoing Payments OVPM SQL Table

Currency Codes OCRN SQL Table

Object Settings - History ADP1 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