|
|
API OFNS
OFNS - Folio Numbering - Series Table
OFNS SQL Table
Point of Issue OPTI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Series KEY UNIQUE | Series ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 100 | NAME | Yes | |||
| PTICode | POI Code | nVarChar | 5 | OPTI Point of Issue | ||||
| FirstNum | First Number | Int | 11 | |||||
| NextNum | Next Number | Int | 11 | |||||
| LastNum | Last Number | Int | 11 | |||||
| Letter | Letter | VarChar | A) A B) B C) C E) E M) M R) R | 1 | ||||
| CAI | CAI | nVarChar | 14 | |||||
| CAIDueDate | CAI Due Date | Date | 8 | |||||
| Remarks | Remarks | nVarChar | 100 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OFNS.Series AS 'Series ID',
OFNS.Name AS 'Name',
OFNS.PTICode AS 'POI Code',
OFNS.FirstNum AS 'First Number',
OFNS.NextNum AS 'Next Number',
OFNS.LastNum AS 'Last Number',
OFNS.Letter AS 'Letter',
OFNS.CAI AS 'CAI',
OFNS.CAIDueDate AS 'CAI Due Date',
OFNS.Remarks AS 'Remarks',
OFNS.Locked AS 'Locked'
FROM OFNS AS OFNS
Related information
OFNS SQL Table
Point of Issue OPTI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
