|
|
SQL Finance / Nota Fiscal Model
API ONFM
ONFM - Nota Fiscal Model Table
ONFM SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | NF Model ID | nVarChar | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| NfmName | NF Model Name | nVarChar | 20 | |||||
| NfmDescrip | NF Model Description | nVarChar | 100 | |||||
| UserSign | User Signature - Create | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| NfmCode | NF Model Code | nVarChar | 10 | |||||
| NfmTW | Tax Wizard Relevant | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
ONFM.AbsEntry AS 'NF Model ID',
ONFM.NfmName AS 'NF Model Name',
ONFM.NfmDescrip AS 'NF Model Description',
ONFM.UserSign AS 'User Signature - Create',
ONFM.UserSign2 AS 'Updating User',
ONFM.UpdateDate AS 'Date of Update',
ONFM.NfmCode AS 'NF Model Code',
ONFM.NfmTW AS 'Tax Wizard Relevant'
FROM ONFM AS ONFM
Related information
ONFM 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
