|
|
API OUSG / Nota Fiscal Usage
OUSG - Usage of Nota Fiscal Table
Nota Fiscal Usage NotaFiscalUsage Object· Table: OUSG
OUSG SQL Table
CFOP for Nota Fiscal OCFP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ID KEY UNIQUE | Usage ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Usage | Usage | nVarChar | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) OBServer A) Auto Incr. D) Data Doc. P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | nVarChar | 6 | OUSR Users | ||||
| PostTax | Post Tax in Price to Stock | Int | 1) Yes 0 | 6 | 1 | |||
| TaxOnly | Tax Only | VarChar | Y) Yes N) No | 1 | N | |||
| CFOPIIS | CFOP Incoming In-State | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CFOPIOS | CFOP Incoming Out-State | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CFOPII | CFOP Incoming Import | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CFOPOIS | CFOP Outgoing In-State | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CFOPOOS | CFOP Outgoing Out-State | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CFOPOE | CFOP Outgoing Export | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| Descr | Usage Description | nVarChar | 100 | |||||
| FreeChrgBP | Free of Charge (BP) | VarChar | Y) Yes N) No | 1 | N | |||
| ThirdParty | Third Party | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OUSG.ID AS 'Usage ID',
OUSG.Usage AS 'Usage',
OUSG.Locked AS 'Locked',
OUSG.DataSource AS 'Data Source',
OUSG.UserSign AS 'User Signature',
OUSG.PostTax AS 'Post Tax in Price to Stock',
OUSG.TaxOnly AS 'Tax Only',
OUSG.CFOPIIS AS 'CFOP Incoming In-State',
OUSG.CFOPIOS AS 'CFOP Incoming Out-State',
OUSG.CFOPII AS 'CFOP Incoming Import',
OUSG.CFOPOIS AS 'CFOP Outgoing In-State',
OUSG.CFOPOOS AS 'CFOP Outgoing Out-State',
OUSG.CFOPOE AS 'CFOP Outgoing Export',
OUSG.Descr AS 'Usage Description',
OUSG.FreeChrgBP AS 'Free of Charge (BP)',
OUSG.ThirdParty AS 'Third Party'
FROM OUSG AS OUSG
Related information
Nota Fiscal Usage NotaFiscalUsage Object· Table: OUSG
Represents a usage for specifying tax codes for Nota Fiscal documents.
Source table: OUSG
OUSG SQL Table
CFOP for Nota Fiscal OCFP 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
