|
|
API ACH1
ACH1 - Checks for Payment - Rows - History Table
Checks for Payment OCHO SQL Table
Tax Definition OVTG SQL Table
G/L Accounts OACT SQL Table
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CheckKey KEY UNIQUE | SBO Internal Key | Int | 11 | OCHO Checks for Payment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | |||||
| LineDitail | Row Details | nVarChar | 40 | |||||
| LineMoney | Row Total | Num | 20 | |||||
| LineCurr | Row Currency | nVarChar | 3 | |||||
| LineAcct | Row G/L Acct | nVarChar | 15 | |||||
| Line_A_C | G/L Acct/BP Code | VarChar | 1 | 0 | ||||
| Code | Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| CredAcct | Credited Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TotalLine | Row Total | Num | 20 | |||||
| VatPercent | Tax %: | Num | 20 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| LineMnyLC | Row Total (LC) | Num | 20 | |||||
| LineMnySC | Row Total (SC) | Num | 20 | |||||
| LineMnyFC | Row Total (FC) | Num | 20 | |||||
| TotLineLC | Row Total (LC) | Num | 20 | |||||
| TotLineSC | Row Total (SC) | Num | 20 | |||||
| TotLineFC | Row Total (FC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
ACH1.CheckKey AS 'SBO Internal Key',
ACH1.LineId AS 'Row Number',
ACH1.LineDitail AS 'Row Details',
ACH1.LineMoney AS 'Row Total',
ACH1.LineCurr AS 'Row Currency',
ACH1.LineAcct AS 'Row G/L Acct',
ACH1.Line_A_C AS 'G/L Acct/BP Code',
ACH1.Code AS 'Tax Definition',
ACH1.CredAcct AS 'Credited Account',
ACH1.TotalLine AS 'Row Total',
ACH1.VatPercent AS 'Tax %:',
ACH1.UserSign AS 'User Signature',
ACH1.LogInstanc AS 'Log Instance',
ACH1.ObjType AS 'Object Type',
ACH1.LineMnyLC AS 'Row Total (LC)',
ACH1.LineMnySC AS 'Row Total (SC)',
ACH1.LineMnyFC AS 'Row Total (FC)',
ACH1.TotLineLC AS 'Row Total (LC)',
ACH1.TotLineSC AS 'Row Total (SC)',
ACH1.TotLineFC AS 'Row Total (FC)'
FROM ACH1 AS ACH1
Related information
Checks for Payment OCHO SQL Table
Tax Definition OVTG SQL Table
G/L Accounts OACT SQL Table
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
