|
|
API ARC1
ARC1 - Incoming Payment - Checks - History Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocNum KEY UNIQUE | Document Number | Int | 11 | OVPM Outgoing Payments | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineID | Row Number | Int | 11 | |||||
| DueDate | Check Date | Date | 8 | |||||
| CheckNum | Check Number | Int | 11 | |||||
| BankCode | Account Number | nVarChar | 30 | -1 | ||||
| Branch | Branch Number | nVarChar | 50 | |||||
| AcctNum | Account Number | nVarChar | 50 | |||||
| Details | Details | nVarChar | 127 | |||||
| Trnsfrable | Negotiable | VarChar | Y) Yes N) No | 1 | N | |||
| CheckSum | Check Amount | Num | 20 | |||||
| Currency | Check Currency | nVarChar | 3 | |||||
| Flags | Flags | Int | 11 | OCRN Currency Codes | 0 | |||
| ObjType | ObjType | nVarChar | 20 | ADP1 Object Settings - History | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CountryCod | Country Code | nVarChar | 3 | OCRY Countries | ||||
| CheckAct | Check Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CheckAbs | Check ID Entry | Int | 11 | OCHO Checks for Payment | ||||
| BnkActKey | Bank Account Internal ID | Int | 11 | DSC1 House Bank Accounts | ||||
| ManualChk | Manual Check | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
