biuan SAP® BUSINESS ONE SDK
API OUSG / / Nota Fiscal Usage
OUSG - Usage of Nota Fiscal Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ID KEY UNIQUEUsage IDInt
11
PRIMARYYes
UsageUsagenVarChar
20
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) OBServer
A) Auto Incr.
D) Data Doc.
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignaturenVarChar
6OUSR
Users
PostTaxPost Tax in Price to StockInt
1) Yes
0
6
1
TaxOnlyTax OnlyVarChar
Y) Yes
N) No
1
N
CFOPIISCFOP Incoming In-StatenVarChar
6OCFP
CFOP for Nota Fiscal
CFOPIOSCFOP Incoming Out-StatenVarChar
6OCFP
CFOP for Nota Fiscal
CFOPIICFOP Incoming ImportnVarChar
6OCFP
CFOP for Nota Fiscal
CFOPOISCFOP Outgoing In-StatenVarChar
6OCFP
CFOP for Nota Fiscal
CFOPOOSCFOP Outgoing Out-StatenVarChar
6OCFP
CFOP for Nota Fiscal
CFOPOECFOP Outgoing ExportnVarChar
6OCFP
CFOP for Nota Fiscal
DescrUsage DescriptionnVarChar
100
FreeChrgBPFree of Charge (BP)VarChar
Y) Yes
N) No
1
N
ThirdPartyThird PartyVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates