|
|
SQL Banking / Installment Layout
API CTG1
CTG1 - Installment Layout Table
Payment Terms OCTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CTGCode KEY UNIQUE | Payment Method Code | Int | 6 | OCTG Payment Terms | ABS_ENTRY | Yes |
|---|---|---|---|---|---|---|---|---|
| IntsNo | Installment No. | Int | 6 | |||||
| InstMonth | Installment Month | Int | 6 | 0 | ||||
| InstDays | Installment Days | Int | 6 | 0 | ||||
| InstPrcnt | Installment % | Num | 20 |
SELECT statement
SELECT
CTG1.CTGCode AS 'Payment Method Code',
CTG1.IntsNo AS 'Installment No.',
CTG1.InstMonth AS 'Installment Month',
CTG1.InstDays AS 'Installment Days',
CTG1.InstPrcnt AS 'Installment %'
FROM CTG1 AS CTG1
Related information
Payment Terms OCTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
