|
|
API Documents / Documents
OPID - Period Indicator Table
Documents Documents Object· Table: OIGE OIGN
OPID SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Indicator KEY UNIQUE | Period Indicator | nVarChar | 10 | PRIMARY | Yes |
|---|
SELECT statement
SELECT
OPID.Indicator AS 'Period Indicator'
FROM OPID AS OPID
Related information
Documents Documents Object· Table: OIGE OIGN
Documents is a business object that represents the header data of documents in the Marketing Documents and Receipts module and the Inventory and Production module of SAP Business One application.
The source table for each document is according...
OPID SQL Table
Documents
Object
Documents
Enumeration
Method
Object
AddressExtension INV12, IGE12, IGN12
Documents OIGE, OIGN
Document_Lines IGE1, IGN1
Document_SpecialLines INV10
TaxExtension IGE12, IGN12
Property
Address
DTW DB
Address2
DTW DB
AgentCode
DTW DB
ApplyTaxOnFirstInstallment
DTW DB
BaseAmount
DB
BaseAmountFC
DB
BaseAmountSC
DB
BlockDunning
DTW DB
Box1099
DTW DB
BPChannelCode
DTW DB
BPChannelContact
DTW DB
BPL_IDAssignedToInvoice
DTW DB
CancelDate
DTW DB
CardCode
DTW DB
CardName
DTW DB
CentralBankIndicator
DTW DB
ClosingDate
DTW DB
ClosingRemarks
DTW DB
Comments
DTW DB
Confirmed
DTW DB
ContactPersonCode
DTW DB
ControlAccount
DTW DB
CreationDate
DB
DeferredTax
DTW DB
DiscountPercent
DTW DB
DocCurrency
DTW DB
DocDate
DTW DB
DocDueDate
DTW DB
DocEntry
DB
DocNum
DTW DB
DocObjectCode
DTW DB
DocRate
DTW DB
DocTime
DTW DB
DocTotal
DTW DB
DocTotalFc
DTW DB
DocTotalSys
DB
DocType
DTW DB
DocumentsOwner
DTW DB
DocumentSubType
DTW DB
DownPayment
DTW DB
DownPaymentAmount
DTW DB
DownPaymentAmountFC
DTW DB
DownPaymentAmountSC
DTW DB
DownPaymentPercentage
DTW DB
DownPaymentType
DTW DB
ExemptionValidityDateFrom
DTW DB
ExemptionValidityDateTo
DTW DB
ExternalCorrectedDocNum
DTW DB
FederalTaxID
DTW DB
FolioNumber
DTW DB
FolioPrefixString
DTW DB
Form1099
DTW DB
GroupSeries
DB
HandWritten
DTW DB
ImportFileNum
DTW DB
Indicator
DTW DB
InsuranceOperation347
DTW DB
InternalCorrectedDocNum
DTW DB
IsPayToBank
DTW DB
JournalMemo
DTW DB
LanguageCode
DTW DB
ManualNumber
DTW DB
MaximumCashDiscount
DTW DB
NetProcedure
DB
NumAtCard
DTW DB
NumberOfInstallments
DTW DB
OpeningRemarks
DTW DB
PartialSupply
DTW DB
PaymentBlock
DTW DB
PaymentBlockEntry
DTW DB
PaymentGroupCode
DTW DB
PaymentMethod
DTW DB
PaymentReference
DTW DB
PayToBankAccountNo
DTW DB
PayToBankBranch
DTW DB
PayToBankCode
DTW DB
PayToBankCountry
DTW DB
PayToCode
DTW DB
Pick
DTW DB
PickRemark
DTW DB
PickStatus
DB
Printed
DTW DB
Project
DTW DB
Reference1
DTW DB
Reference2
DTW DB
RequriedDate
DTW DB
Reserve
DB
ReserveInvoice
DTW DB
RevisionPo
DTW DB
Rounding
DTW DB
RoundingDiffAmount
DTW DB
SalesPersonCode
DTW DB
Segment
DB
SequenceCode
DTW DB
SequenceModel
DTW DB
SequenceSerial
DTW DB
Series
DTW DB
SeriesString
DTW DB
ServiceGrossProfitPercent
DTW DB
ShipToCode
DTW DB
ShowSCN
DTW DB
Submitted
DB
SubSeriesString
DTW DB
SummeryType
DTW DB
TaxDate
DTW DB
TaxExemptionLetterNum
DTW DB
TaxExtension
DB
TrackingNumber
DTW DB
TransNum
DB
TransportationCode
DTW DB
UpdateDate
DB
UseCorrectionVATGroup
DTW DB
UseShpdGoodsAct
DTW DB
VatDate
DTW DB
VatPercent
DTW DB
VatSum
DB
VatSumFc
DB
VatSumSys
DB
WareHouseUpdateType
DTW DB
WTAmount
DB
WTAmountFC
DB
WTAmountSC
DB
WTApplied
DB
WTAppliedFC
DB
WTAppliedSC
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
