biuan SAP® BUSINESS ONE SDK
API OCIN
OCIN - A/R Correction Invoice Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
DocTypeDocument TypeVarChar
I) Item
S) Service
1
I
CANCELEDCanceledVarChar
Y) Yes
N) No
1
N
HandwrttenManual NumberingVarChar
Y) Yes
N) No
1
N
PrintedPrintedVarChar
Y) Copy
N) Original
A) Amended
1
N
DocStatus KEYDocument StatusVarChar
O) Open
C) Closed
1
ODOC_STATUSNo
InvntSttusWarehouse StatusVarChar
O) Open
C) Closed
1
O
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
ObjTypeObject TypenVarChar
132) Correction Invoice
20ADP1
Object Settings - History
132
DocDate KEYPosting DateDate
8
DATE_PINDNo
DocDueDateDue DateDate
8
CardCode KEYCustomer/Vendor CodenVarChar
15OCRD
Business Partner
CUSTOMERNo
CardNameCustomer/Vendor NamenVarChar
100
AddressBill tonVarChar
127
NumAtCard KEYBP Reference No.nVarChar
100
AT_CARDNo
VatPercentTax RateNum
20
VatSumTotal TaxNum
20
VatSumFCTax Amount (FC)Num
20
DiscPrcntDiscount % for DocumentNum
20
DiscSumTotal DiscountNum
20
DiscSumFCTotal Discount (FC)Num
20
DocCurDocument CurrencynVarChar
3OCRN
Currency Codes
DocRateDocument RateNum
20
DocTotalDocument TotalNum
20
DocTotalFCDocument Total (FC)Num
20
PaidToDatePaid to DateNum
20
PaidFCPaid (FC)Num
20
GrosProfitGross ProfitNum
20
GrosProfFCGross Profit (FC)Num
20
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarknVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
ReceiptNumIncoming Payment No.Int
11
GroupNumPayment Terms CodeInt
6OCTG
Payment Terms
DocTimeCreation TimeInt
6
SlpCodeSales EmployeeInt
11OSLP
Sales Employee
-1
TrnspCodeShipping TypeInt
6OSHP
Delivery Types
-1
PartSupplyPartial DeliveryVarChar
Y) Yes
N) No
1
Y
ConfirmedConfirmedVarChar
Y) Yes
N) No
1
Y
GrossBasePrice List for Gross ProfitInt
6
0
ImportEntOrder NumberInt
11
CreateTranCreate Journal EntryVarChar
Y) Yes
N) No
1
N
SummryTypeSummary MethodVarChar
N) No Summary
I) By Items
D) By Documents
1
N
UpdInvntWhse UpdateVarChar
N) No
O) Orders from Vendors
C) Customer Orders
G) Consignment
I) Stock
1
N
UpdCardBalUpdate BalancesVarChar
N) No
O) Orders
D) Delivery Notes
B) Bookkeeping
1
N
InstanceInstanceInt
6
0
FlagsFlagsInt
11
0
InvntDirecWarehouse DirectionVarChar
X) Release
E) Receipt
1
E
CntctCodeContact PersonInt
11OCPR
Contact Persons
ShowSCNDisplay BP Catalog NumberVarChar
Y) Yes
N) No
1
N
FatherCard KEYConsolidating BPnVarChar
15OCRD
Business Partner
FTHR_CARDNo
SysRateSystem PriceNum
20
CurSourceBase CurrencyVarChar
L) Local Currency
S) System Currency
C) BP Currency
1
C
VatSumSyTax Amount (SC)Num
20
DiscSumSyTotal Discount (SC)Num
20
DocTotalSyDocument Total (SC)Num
20
PaidSysPaid (SC)Num
20
FatherTypeParent Consolidation TypeVarChar
P) Payment Consolidation
D) Delivery Consolidation
1
P
GrosProfSyGross Profit (SC)Num
20
UpdateDateDate of UpdateDate
8
IsICTA/R Invoice + PaymentVarChar
Y) Yes
N) No
1
N
CreateDateCreation DateDate
8
VolumeVolumeNum
20
VolUnitVolume UoMInt
6
WeightWeightNum
20
WeightUnitWeight UoMInt
6
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
SERIESNo
TaxDateDocument DateDate
8
FillerFilternVarChar
8OWHS
Warehouses
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
StampNumStamp No.nVarChar
16
isCrinCorrection InvoiceVarChar
Y) Yes
N) No
1
N
FinncPriodPosting PeriodInt
11OFPR
Posting Period
UserSignUser SignatureInt
6OUSR
Users
selfInvAutom. InvoiceVarChar
N) No
Y) Yes
1
N
VatPaidTax Paid to DateNum
20
VatPaidFCTax Paid (FC)Num
20
VatPaidSysTax Paid (SC)Num
20
UserSign2Updating UserInt
6OUSR
Users
WddStatusApproval StatusVarChar
-) Without
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Canceled
1
draftKeyDocument Draft Internal IDInt
11ODRF
Drafts
-1
TotalExpnsTotal FreightNum
20
TotalExpFCTotal Freight (FC)Num
20
TotalExpSCTotal Freight (SC)Num
20
DunnLevelDunning LevelInt
11ODUN
Dunning Letters
Address2Ship TonVarChar
127
LogInstancLog InstanceInt
11
0
ExportedExportedVarChar
Y) Yes
N) No
1
N
StationIDWorkstation IDInt
11CSTN
Workstation ID
IndicatorIndicatornVarChar
2OIDC
Indicator
NetProcNet ProcedureVarChar
Y) Yes
N) No
1
N
AqcsTaxAcquisition TaxNum
20
AqcsTaxFCAcquisition Tax (FC)Num
20
AqcsTaxSCAcquisition Tax (SC)Num
20
CashDiscPrCash Discount %Num
20
CashDiscntCash DiscountNum
20
CashDiscFCCash Discount (FC)Num
20
CashDiscSCCash Discount SCNum
20
ShipToCodeShip-to CodenVarChar
50
LicTradNumLicensed Dealer No.nVarChar
32
PaymentRefPayment Reference No.nVarChar
27
WTSumWTax AmountNum
20
WTSumFCWTax Amount (FC)Num
20
WTSumSCWTax Amount (SC)Num
20
RoundDifRounding Diff. AmountNum
20
RoundDifFCRounding Diff. Amount (FC)Num
20
RoundDifSyRounding Diff. Amount (SC)Num
20
CheckDigitControl DigitVarChar
1
Form10991099 FormInt
11OTNN
1099 Forms
Box10991099 BoxnVarChar
20
submittedSubmittedVarChar
Y) Yes
N) No
1
N
PoPrssPO ProcessVarChar
Y) Yes
N) No
1
N
RoundingRoundingVarChar
Y) Yes
N) No
1
N
RevisionPoSplit POVarChar
Y) Yes
N) No
1
N
SegmentSegmentInt
6
0
ReqDateRequired DateDate
8
CancelDateCancelation DateDate
8
PickStatusPick StatusVarChar
Y) Yes
N) No
1
N
PickPickVarChar
Y) Yes
N) No
1
N
BlockDunnBlock DunningVarChar
Y) Yes
N) No
1
N
PeyMethodPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard
PayBlockPayment BlockVarChar
Y) Yes
N) No
1
N
PayBlckRefPayment Block Abs EntryInt
11OPYB
Payment Block
MaxDscnMaximum DiscountVarChar
Y) Yes
N) No
1
N
ReserveReserveVarChar
Y) Yes
N) No
1
N
Max1099Max. 1099 AmountNum
20
CntrlBnkCentral Bank IndicatornVarChar
15OCBI
Central Bank Ind.
PickRmrkPick RemarksnVarChar
127
ISRCodLineISR Coding LinenVarChar
53
ExpApplExp appliedNum
20
ExpApplFCExp applied FCNum
20
ExpApplSCExp applied DCNum
20
ProjectProject CodenVarChar
20OPRJ
Project Codes
DeferrTaxDeferred TaxVarChar
Y) Yes
N) No
1
LetterNumTax Exemption Letter No.nVarChar
20
FromDateExemption Validity Date FromDate
8
ToDateExemption Validity Date ToDate
8
WTAppliedApplied WTaxNum
20
WTAppliedFApplied WTax (FC)Num
20
BoeReserevBill of Exchange ReservedVarChar
Y) Yes
N) No
1
N
AgentCodeAgent CodenVarChar
32OAGP
Agent Name
WTAppliedSApplied WTax (SC)Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20
InstallmntNo. of InstallmentsInt
6
1
VATFirstApply Tax on 1st InstallmentVarChar
Y) Yes
N) No
1
NnSbAmntWTax Non-Subject AmountNum
20
NnSbAmntSCWTax Non-Subject Amount (SC)Num
20
NbSbAmntFCWTax Non-Subject Amount (FC)Num
20
ExepAmntWithholding Tax Exempt AmountNum
20
ExepAmntSCWTax Exempt Amount (SC)Num
20
ExepAmntFCWTax Exempt Amount (FC)Num
20
VatDateDocument DateDate
8
CorrExtExternal Corrected Document No.nVarChar
25
CorrInvInternal Corrected Document No.Int
11
NCorrInvNext Correcting DocumentInt
11
CEECFlagBlock Creation of Tgt Corr DocVarChar
N) No
Y) Yes
1
N
BaseAmntBase AmountNum
20
BaseAmntSCBase Amount (SC)Num
20
BaseAmntFCBase Amount (FC)Num
20
CtlAccountControl AccountnVarChar
15OACT
G/L Accounts
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumVAT Reg. NumbernVarChar
32
TxInvRptNoTax Invoice Rpt NumbernVarChar
10
TxInvRptDtTax Invoice Rpt DateDate
8
KVVATCodeVAT Code for Tax Invoice RptText
16
WTDetailsWTax DetailsnVarChar
100
SumAbsIdSummary VAT Abstract IDInt
11
-1
SumRptDateSummary VAT Report DateDate
8
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
ManualNumManual NumbernVarChar
20
UseShpdGdUse Shipped Goods AccountVarChar
N) No
Y) Yes
1
N
BaseVtAtBPL ID Assigned to InvoiceNum
20
BaseVtAtSCBPL NameNum
20
BaseVtAtFCTax Reg. NumberNum
20
NnSbVAtTax Invoice Rpt NumberNum
20
NnSbVAtSCTax Invoice Rpt DateNum
20
NbSbVAtFCWTax Non-Subject VAT Amt (FC)Num
20
ExptVAtWTax Exempt VAT AmountNum
20
ExptVAtSCWTax Exempt VAT Amount (SC)Num
20
ExptVAtFCWTax Exempt VAT Amount (FC)Num
20
LYPmtAtLast Year's PaymentsNum
20
LYPmtAtSCLast Years Payments (SC)Num
20
LYPmtAtFCSummary Tax Report DateNum
20
ExpAnSumPeriod IndicatorNum
20
ExpAnSysManual NumberNum
20
ExpAnFrgnUse Shipped Goods AccountNum
20
DocSubTypeVAT Code for Tax Invoice RptnVarChar
--) Correction Invoice
2
--
DpmStatusSummary VAT Abstract IDVarChar
O) Open
C) Closed
1
O
DpmAmntDown Payment Amount LCNum
20
DpmAmntSCDown Payment Amount SCNum
20
DpmAmntFCDown Payment Amount FCNum
20
DpmDrawnDrawn to Down PaymentVarChar
N) No
Y) Yes
1
N
DpmPrcntDown Payment PercentNum
20
PaidSumTotal Paid SumNum
20
PaidSumFcTotal Paid Sum (FC)Num
20
PaidSumScTotal Paid Sum (SC)Num
20
FolioPrefFolio Prefix StringnVarChar
4
FolioNumFolio NumberInt
11
DpmApplDown Payment Applied LCNum
20
DpmApplFcDown Payment Applied FCNum
20
DpmApplScDown Payment Applied SCNum
20
LPgFolioNFolio No. for Last Page in Doc.Int
11
HeaderHeaderText
16
FooterFooterText
16
PostedDown Payment Was PostedVarChar
Y) Yes
N) No
1
Y
OwnerCode KEYDocument OwnerInt
11OHEM
Employees
OWNER_CODENo
BPChCodeBP Channel CodenVarChar
15OCRD
Business Partner
BPChCntcBP Channel Contact PersonInt
11OCPR
Contact Persons
PayToCodePay tonVarChar
50
IsPaytoBnkIs Pay to BankVarChar
N) No
Y) Yes
1
BnkCntryPay to Bank CountrynVarChar
3OCRY
Countries
BankCodePay to Bank CodenVarChar
30
BnkAccountPay to Bank Account No.nVarChar
50
BnkBranchPay to Bank BranchnVarChar
50
isInsReserve InvoiceVarChar
Y) Yes
N) No
1
N
TrackNoTracking NumbernVarChar
30
VersionNumVersion NumbernVarChar
11
LangCodeLanguage CodeInt
11OLNG
User Language Table
BPNameOWBP Name OverwrittenVarChar
Y) Yes
N) No
1
N
BillToOWBill-To OverwrittenVarChar
Y) Yes
N) No
1
N
ShipToOWShip-to OverwrittenVarChar
Y) Yes
N) No
1
N
RetInvoiceCredit MemoVarChar
Y) Yes
N) No
1
N
ClsDateDocument Closing DateDate
8
MInvNumMonthly Invoice No.Int
11
MInvDateMonthly Invoice DateDate
8
SeqCodeSequence CodeInt
6
SerialSerial NumbersInt
11
SeriesStrSeries StringnVarChar
3
SubStrSub-Series StringnVarChar
3
ModelNota Fiscal ModelnVarChar
6ONFM
Nota Fiscal Model
0
TaxOnExpTax on Freight SumNum
20
TaxOnExpFcTax on Freight Sum (FC)Num
20
TaxOnExpScTax on Freight Sum (SC)Num
20
TaxOnExApTax on Freight AppliedNum
20
TaxOnExApFTax on Freight Applied (FC)Num
20
TaxOnExApSTax on Freight Applied (SC)Num
20
LastPmnTypLast Payment TypeVarChar
R) Receipt
V) Vendor Payment
1
LndCstNumLanded Cost NumberInt
11
UseCorrVatUse Correction VAT GroupVarChar
N) No
Y) Yes
1
N
BlkCredMmoBlock Creation of Target Credit MemoVarChar
N) No
Y) Yes
1
N
OpenForLaCOpen for Landed CostsVarChar
Y) Open for Landed Costs
N) Closed for Landed Costs
1
Y
ExcisedExcisedVarChar
O) Open
C) Close
1
O
ExcRefDateExcise Ref. DateDate
8
ExcRmvTimeExcise Removal TimenVarChar
8
SrvGpPrcntGross Profit Prcnt of ServiceNum
20
DepositNumDeposit NumberInt
11
CertNumCertificate NumbernVarChar
31
DutyStatusDuty StatusVarChar
Y) With Payment of Duty
N) Without Payment of Duty
1
Y
AutoCrtFlwAuto Create Follow-up DocumentVarChar
N) No
Y) Yes
1
N
FlwRefDateFollow-up Document Ref. DateDate
8
FlwRefNumFollow-up Document Ref. NumbernVarChar
100
VatJENumVAT Journal Entry NumberInt
11
-1
DpmVatDown Payment Tax LCNum
20
DpmVatFcDown Payment Tax FCNum
20
DpmVatScDown Payment Tax SCNum
20
DpmAppVatDown Payment Applied Tax LCNum
20
DpmAppVatFDown Payment Applied Tax FCNum
20
DpmAppVatSDown Payment Applied Tax SCNum
20
InsurOp347347 Insurance OperationVarChar
N) No
Y) Yes
1
N
IgnRelDocIgnore Relevant Doc on ArchiveVarChar
N) No
Y) Yes
1
N
BuildDescBuild DescriptornVarChar
50
ResidenNumResidence NumberVarChar
1) Spanish Fiscal ID
2) VAT Registration Number
3) Passport
4) Fiscal ID Issued by the Residence Country
5) Certificate of Fiscal Residence
6) Other Document
1
1
CheckerCheckerInt
11OHEM
Employees
PayeePayeeInt
11OHEM
Employees
CopyNumberCopy NumberInt
11
0
SSIExmptSSI ExemptionVarChar
Y) Yes
N) No
1
PQTGrpSerPur Quotation Group SeriesInt
6
PQTGrpNumPur Quotation Group NumberInt
11
PQTGrpHWPur Quotation Group ManualVarChar
Y) Yes
N) No
1
N
ReopOriDocReopen Origin. Order by ReturnVarChar
Y) Yes
N) No
1
ReopManClsReop. Man. Closed/Canc. OrdersVarChar
Y) Yes
N) No
1
DocManClsdDocument Was Closed ManuallyVarChar
Y) Yes
N) No
U) Unknown
1
N
ClosingOptClosing OptionInt
6
1
SpecDatePosting Date Specified by UserDate
8
OrderedPayment OrderedVarChar
Y) Yes
N) No
1
N
NTSApprovNTS ApprovedVarChar
N) No
Y) Yes
1
N
NTSWebSiteE-Tax Web SiteInt
6OTWS
E-Tax Web Site
NTSeTaxNoE-Tax NumbernVarChar
50
NTSApprNoNTS Approval NumbernVarChar
50
PayDuMonthStart FromVarChar
E) Month End
H) Half Month
Y) Month Start
N)
1
ExtraMonthNumber of Additional MonthsInt
6
ExtraDaysNumber of Additional DaysInt
6
CdcOffsetCash Discount OffsetInt
6
0
SignMsgSignature Input MessageText
16
SignDigestSignature DigestText
16
CertifNumCertification NumbernVarChar
50
KeyVersionPrivate Key VersionInt
11
EDocGenTypElectr. Doc. Generation TypeVarChar
G) Generate
L) Generate - Later
S) Send
R) Send - Later
N) Not Relevant
1
N
ESeries KEYElectronic SeriesInt
6NNM4
Electronic Series
ESERIESNo
EDocNumElectronic Document NumbernVarChar
50
EDocExpFrmElectronic Doc. Export FormatInt
11
OnlineQuoCreate Online QuotationVarChar
Y) Yes
N) No
1
N
POSEqNumPOS Equipment NumbernVarChar
20
POSManufSNPOS Manufacturer Serial NumbernVarChar
20
POSCashNPOS Cashier NumberInt
11
EDocStatusElectronic Document StatusVarChar
N) New
P) Pending
S) Sent
E) Error
C) OK
1
C
EDocCntntElectronic Document ContentText
16
EDocProcesElectronic Document ProcessVarChar
C) CFD
I) CFDI
1
C
EDocErrCodElectronic Document Error CodenVarChar
50
EDocErrMsgElectronic Document Error MsgText
16
EDocCancelElectronic Document - CanceledVarChar
N) No
Y) Yes
1
N
EDocTestElectronic Document - TestingVarChar
N) No
Y) Yes
1
N
EDocPrefixElectronic Document - PrefixnVarChar
10
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
CIGContract Code IdentificationInt
11OCIG
CIG Codes
DpmAsDscntDiscount Document with DpmVarChar
N) No
Y) Yes
1
N
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
SupplCodeSupplementary CodenVarChar
127
GTSRlvntRelevant To GTSVarChar
N) No
Y) Yes
1
N
BaseDiscBase Discount LCNum
20
BaseDiscScBase Discount SCNum
20
BaseDiscFcBase Discount FCNum
20
BaseDiscPrBase Discount PercentageNum
20
CreateTSCreatn Time - Incl. SecsInt
11
UpdateTSUpdate Full TimeInt
11
SrvTaxRuleApply Service Tax RuleVarChar
Y) Yes
N) No
1
N
AnnInvDecRAnnual Inv. Declaration Ref.Int
11
SupplierSuppliernVarChar
15OCRD
Business Partner
ReleaserGoods Distribution ApproverInt
11OHEM
Employees
ReceiverGoods Release ApproverInt
11OHEM
Employees
ToWhsCodeTo Warehouse CodenVarChar
8OWHS
Warehouses
AssetDateFixed Asset Value DateDate
8
RequesterUser Requesting GoodsnVarChar
8
ReqNameUser NamenVarChar
127
BranchBranchInt
6OUBR
Branches
DepartmentDepartmentInt
6OUDP
Departments
EmailE-MailnVarChar
100
NotifySend Notification NeededVarChar
Y) Yes
N) No
1
ReqTypeRequester Type User/EmployeeInt
12) User
171) Employee
11
12
OriginTypeDocument OriginVarChar
M) Manual
R) MRP
S) Sales Order
D) Document Generation Wizard
1
M
IsReuseNumIs Reusing Document NumberVarChar
Y) Yes
N) No
1
N
IsReuseNFNIs Reusing Nota Fiscal NumberVarChar
Y) Yes
N) No
1
N
DocDlvryDocument DeliveryVarChar
0
1) Create Online Document
2) Post to Ariba Network
1
PaidDpmPaid by Down PaymentNum
20
PaidDpmFPaid by Down Payment (FC)Num
20
PaidDpmSPaid by Down Payment (SC)Num
20
EnvTypeNFeEnvironment Type NF-eInt
11OBNI
Brazil Numeric Indexer
-1
AgrNoAgreement No.Int
11
IsAltIs AlterationVarChar
Y) Yes
N) No
1
N
AltBaseTypAlteration Base TypeInt
-1)
13)
18)
163)
165)
11
-1
AltBaseEntAlteration Base EntryInt
11
AuthCodeAuthorization CodenVarChar
127
StDlvDateStart Delivery DateDate
8
StDlvTimeStart Delivery TimeInt
11
EndDlvDateEnd Delivery DateDate
8
EndDlvTimeEnd Delivery TimeInt
11
VclPlateVehicle PlatenVarChar
20
ElCoStatusElec. Comm. StatusnVarChar
0
1) Pending Approval
2) Rejected
10
AtDocTypeAT Document TypenVarChar
GT) GT
GA) GA
GD) GD
GR) GR
GC) GC
FT) FT
FS) FS
NC) NC
ND) ND
FR) FR
2
ElCoMsgElec. Comm. MessagenVarChar
127
PrintSEPAPrint SEPA Direct Debit PrenotificationVarChar
Y) Yes
N) No
1
N
FreeChrgFree of Charge BPNum
20
FreeChrgFCFree of Charge BP FCNum
20
FreeChrgSCFree of Charge BP SCNum
20
NfeValueNF-e ValueNum
20
FiscDocNumFiscal Document NumbernVarChar
100
RelatedTypRelated TypeInt
-1)
11
-1
RelatedEntRelated EntryInt
11
CCDEntryCCD Abs. EntryInt
11
NfePrntFoNF-e Printing FormatInt
0
1) Portrait
2) Landscape
3) Simplified
4) DANFE NFC-e
5) Mail
11
0
ZrdAbsPOS Daily Summary NumberInt
11OZRD
POS Daily Summary
POSRcptNoPOS Receipt NumberInt
11
FoCTaxFree of Charge BP TaxNum
20
FoCTaxFCFree of Charge BP Tax FCNum
20
FoCTaxSCFree of Charge BP Tax SCNum
20
TpCusPresType of End-User PresenceInt
11OBNI
Brazil Numeric Indexer
ExcDocDateExcise Doc. DateDate
8
FoCFrghtFree of Charge FreightNum
20
FoCFrghtFCFree of Charge Freight FCNum
20
FoCFrghtSCFree of Charge Freight SCNum
20
InterimTypInterim TypeInt
0
6
0
PTICodePOI CodenVarChar
5OPTI
Point of Issue
LetterLetterVarChar
1
FolNumFromFolio Number FromInt
11
FolNumToFolio Number ToInt
11
FolSeriesFolio SeriesInt
11OFNS
Folio Numbering - Series
SplitTaxSplit Payment TaxNum
20
SplitTaxFCSplit Payment Tax FCNum
20
SplitTaxSCSplit Payment Tax SCNum
20

Table relationship map

SELECT statement

SELECT OCIN.DocEntry AS 'Internal Number', OCIN.DocNum AS 'Document Number', OCIN.DocType AS 'Document Type', OCIN.CANCELED AS 'Canceled', OCIN.Handwrtten AS 'Manual Numbering', OCIN.Printed AS 'Printed', OCIN.DocStatus AS 'Document Status', OCIN.InvntSttus AS 'Warehouse Status', OCIN.Transfered AS 'Year Transfer', OCIN.ObjType AS 'Object Type', OCIN.DocDate AS 'Posting Date', OCIN.DocDueDate AS 'Due Date', OCIN.CardCode AS 'Customer/Vendor Code', OCIN.CardName AS 'Customer/Vendor Name', OCIN.Address AS 'Bill to', OCIN.NumAtCard AS 'BP Reference No.', OCIN.VatPercent AS 'Tax Rate', OCIN.VatSum AS 'Total Tax', OCIN.VatSumFC AS 'Tax Amount (FC)', OCIN.DiscPrcnt AS 'Discount % for Document', OCIN.DiscSum AS 'Total Discount', OCIN.DiscSumFC AS 'Total Discount (FC)', OCIN.DocCur AS 'Document Currency', OCIN.DocRate AS 'Document Rate', OCIN.DocTotal AS 'Document Total', OCIN.DocTotalFC AS 'Document Total (FC)', OCIN.PaidToDate AS 'Paid to Date', OCIN.PaidFC AS 'Paid (FC)', OCIN.GrosProfit AS 'Gross Profit', OCIN.GrosProfFC AS 'Gross Profit (FC)', OCIN.Ref1 AS 'Reference 1', OCIN.Ref2 AS 'Reference 2', OCIN.Comments AS 'Remarks', OCIN.JrnlMemo AS 'Journal Remark', OCIN.TransId AS 'Transaction Number', OCIN.ReceiptNum AS 'Incoming Payment No.', OCIN.GroupNum AS 'Payment Terms Code', OCIN.DocTime AS 'Creation Time', OCIN.SlpCode AS 'Sales Employee', OCIN.TrnspCode AS 'Shipping Type', OCIN.PartSupply AS 'Partial Delivery', OCIN.Confirmed AS 'Confirmed', OCIN.GrossBase AS 'Price List for Gross Profit', OCIN.ImportEnt AS 'Order Number', OCIN.CreateTran AS 'Create Journal Entry', OCIN.SummryType AS 'Summary Method', OCIN.UpdInvnt AS 'Whse Update', OCIN.UpdCardBal AS 'Update Balances', OCIN.Instance AS 'Instance', OCIN.Flags AS 'Flags', OCIN.InvntDirec AS 'Warehouse Direction', OCIN.CntctCode AS 'Contact Person', OCIN.ShowSCN AS 'Display BP Catalog Number', OCIN.FatherCard AS 'Consolidating BP', OCIN.SysRate AS 'System Price', OCIN.CurSource AS 'Base Currency', OCIN.VatSumSy AS 'Tax Amount (SC)', OCIN.DiscSumSy AS 'Total Discount (SC)', OCIN.DocTotalSy AS 'Document Total (SC)', OCIN.PaidSys AS 'Paid (SC)', OCIN.FatherType AS 'Parent Consolidation Type', OCIN.GrosProfSy AS 'Gross Profit (SC)', OCIN.UpdateDate AS 'Date of Update', OCIN.IsICT AS 'A/R Invoice + Payment', OCIN.CreateDate AS 'Creation Date', OCIN.Volume AS 'Volume', OCIN.VolUnit AS 'Volume UoM', OCIN.Weight AS 'Weight', OCIN.WeightUnit AS 'Weight UoM', OCIN.Series AS 'Series', OCIN.TaxDate AS 'Document Date', OCIN.Filler AS 'Filter', OCIN.DataSource AS 'Data Source', OCIN.StampNum AS 'Stamp No.', OCIN.isCrin AS 'Correction Invoice', OCIN.FinncPriod AS 'Posting Period', OCIN.UserSign AS 'User Signature', OCIN.selfInv AS 'Autom. Invoice', OCIN.VatPaid AS 'Tax Paid to Date', OCIN.VatPaidFC AS 'Tax Paid (FC)', OCIN.VatPaidSys AS 'Tax Paid (SC)', OCIN.UserSign2 AS 'Updating User', OCIN.WddStatus AS 'Approval Status', OCIN.draftKey AS 'Document Draft Internal ID', OCIN.TotalExpns AS 'Total Freight', OCIN.TotalExpFC AS 'Total Freight (FC)', OCIN.TotalExpSC AS 'Total Freight (SC)', OCIN.DunnLevel AS 'Dunning Level', OCIN.Address2 AS 'Ship To', OCIN.LogInstanc AS 'Log Instance', OCIN.Exported AS 'Exported', OCIN.StationID AS 'Workstation ID', OCIN.Indicator AS 'Indicator', OCIN.NetProc AS 'Net Procedure', OCIN.AqcsTax AS 'Acquisition Tax', OCIN.AqcsTaxFC AS 'Acquisition Tax (FC)', OCIN.AqcsTaxSC AS 'Acquisition Tax (SC)', OCIN.CashDiscPr AS 'Cash Discount %', OCIN.CashDiscnt AS 'Cash Discount', OCIN.CashDiscFC AS 'Cash Discount (FC)', OCIN.CashDiscSC AS 'Cash Discount SC', OCIN.ShipToCode AS 'Ship-to Code', OCIN.LicTradNum AS 'Licensed Dealer No.', OCIN.PaymentRef AS 'Payment Reference No.', OCIN.WTSum AS 'WTax Amount', OCIN.WTSumFC AS 'WTax Amount (FC)', OCIN.WTSumSC AS 'WTax Amount (SC)', OCIN.RoundDif AS 'Rounding Diff. Amount', OCIN.RoundDifFC AS 'Rounding Diff. Amount (FC)', OCIN.RoundDifSy AS 'Rounding Diff. Amount (SC)', OCIN.CheckDigit AS 'Control Digit', OCIN.Form1099 AS '1099 Form', OCIN.Box1099 AS '1099 Box', OCIN.submitted AS 'Submitted', OCIN.PoPrss AS 'PO Process', OCIN.Rounding AS 'Rounding', OCIN.RevisionPo AS 'Split PO', OCIN.Segment AS 'Segment', OCIN.ReqDate AS 'Required Date', OCIN.CancelDate AS 'Cancelation Date', OCIN.PickStatus AS 'Pick Status', OCIN.Pick AS 'Pick', OCIN.BlockDunn AS 'Block Dunning', OCIN.PeyMethod AS 'Payment Method', OCIN.PayBlock AS 'Payment Block', OCIN.PayBlckRef AS 'Payment Block Abs Entry', OCIN.MaxDscn AS 'Maximum Discount', OCIN.Reserve AS 'Reserve', OCIN.Max1099 AS 'Max. 1099 Amount', OCIN.CntrlBnk AS 'Central Bank Indicator', OCIN.PickRmrk AS 'Pick Remarks', OCIN.ISRCodLine AS 'ISR Coding Line', OCIN.ExpAppl AS 'Exp applied', OCIN.ExpApplFC AS 'Exp applied FC', OCIN.ExpApplSC AS 'Exp applied DC', OCIN.Project AS 'Project Code', OCIN.DeferrTax AS 'Deferred Tax', OCIN.LetterNum AS 'Tax Exemption Letter No.', OCIN.FromDate AS 'Exemption Validity Date From', OCIN.ToDate AS 'Exemption Validity Date To', OCIN.WTApplied AS 'Applied WTax', OCIN.WTAppliedF AS 'Applied WTax (FC)', OCIN.BoeReserev AS 'Bill of Exchange Reserved', OCIN.AgentCode AS 'Agent Code', OCIN.WTAppliedS AS 'Applied WTax (SC)', OCIN.EquVatSum AS 'Total Equalization Tax', OCIN.EquVatSumF AS 'Total Equalization Tax (FC)', OCIN.EquVatSumS AS 'Total Equalization Tax (SC)', OCIN.Installmnt AS 'No. of Installments', OCIN.VATFirst AS 'Apply Tax on 1st Installment', OCIN.NnSbAmnt AS 'WTax Non-Subject Amount', OCIN.NnSbAmntSC AS 'WTax Non-Subject Amount (SC)', OCIN.NbSbAmntFC AS 'WTax Non-Subject Amount (FC)', OCIN.ExepAmnt AS 'Withholding Tax Exempt Amount', OCIN.ExepAmntSC AS 'WTax Exempt Amount (SC)', OCIN.ExepAmntFC AS 'WTax Exempt Amount (FC)', OCIN.VatDate AS 'Document Date', OCIN.CorrExt AS 'External Corrected Document No.', OCIN.CorrInv AS 'Internal Corrected Document No.', OCIN.NCorrInv AS 'Next Correcting Document', OCIN.CEECFlag AS 'Block Creation of Tgt Corr Doc', OCIN.BaseAmnt AS 'Base Amount', OCIN.BaseAmntSC AS 'Base Amount (SC)', OCIN.BaseAmntFC AS 'Base Amount (FC)', OCIN.CtlAccount AS 'Control Account', OCIN.BPLId AS 'Branch', OCIN.BPLName AS 'Branch Name', OCIN.VATRegNum AS 'VAT Reg. Number', OCIN.TxInvRptNo AS 'Tax Invoice Rpt Number', OCIN.TxInvRptDt AS 'Tax Invoice Rpt Date', OCIN.KVVATCode AS 'VAT Code for Tax Invoice Rpt', OCIN.WTDetails AS 'WTax Details', OCIN.SumAbsId AS 'Summary VAT Abstract ID', OCIN.SumRptDate AS 'Summary VAT Report Date', OCIN.PIndicator AS 'Period Indicator', OCIN.ManualNum AS 'Manual Number', OCIN.UseShpdGd AS 'Use Shipped Goods Account', OCIN.BaseVtAt AS 'BPL ID Assigned to Invoice', OCIN.BaseVtAtSC AS 'BPL Name', OCIN.BaseVtAtFC AS 'Tax Reg. Number', OCIN.NnSbVAt AS 'Tax Invoice Rpt Number', OCIN.NnSbVAtSC AS 'Tax Invoice Rpt Date', OCIN.NbSbVAtFC AS 'WTax Non-Subject VAT Amt (FC)', OCIN.ExptVAt AS 'WTax Exempt VAT Amount', OCIN.ExptVAtSC AS 'WTax Exempt VAT Amount (SC)', OCIN.ExptVAtFC AS 'WTax Exempt VAT Amount (FC)', OCIN.LYPmtAt AS 'Last Year's Payments', OCIN.LYPmtAtSC AS 'Last Years Payments (SC)', OCIN.LYPmtAtFC AS 'Summary Tax Report Date', OCIN.ExpAnSum AS 'Period Indicator', OCIN.ExpAnSys AS 'Manual Number', OCIN.ExpAnFrgn AS 'Use Shipped Goods Account', OCIN.DocSubType AS 'VAT Code for Tax Invoice Rpt', OCIN.DpmStatus AS 'Summary VAT Abstract ID', OCIN.DpmAmnt AS 'Down Payment Amount LC', OCIN.DpmAmntSC AS 'Down Payment Amount SC', OCIN.DpmAmntFC AS 'Down Payment Amount FC', OCIN.DpmDrawn AS 'Drawn to Down Payment', OCIN.DpmPrcnt AS 'Down Payment Percent', OCIN.PaidSum AS 'Total Paid Sum', OCIN.PaidSumFc AS 'Total Paid Sum (FC)', OCIN.PaidSumSc AS 'Total Paid Sum (SC)', OCIN.FolioPref AS 'Folio Prefix String', OCIN.FolioNum AS 'Folio Number', OCIN.DpmAppl AS 'Down Payment Applied LC', OCIN.DpmApplFc AS 'Down Payment Applied FC', OCIN.DpmApplSc AS 'Down Payment Applied SC', OCIN.LPgFolioN AS 'Folio No. for Last Page in Doc.', OCIN.Header AS 'Header', OCIN.Footer AS 'Footer', OCIN.Posted AS 'Down Payment Was Posted', OCIN.OwnerCode AS 'Document Owner', OCIN.BPChCode AS 'BP Channel Code', OCIN.BPChCntc AS 'BP Channel Contact Person', OCIN.PayToCode AS 'Pay to', OCIN.IsPaytoBnk AS 'Is Pay to Bank', OCIN.BnkCntry AS 'Pay to Bank Country', OCIN.BankCode AS 'Pay to Bank Code', OCIN.BnkAccount AS 'Pay to Bank Account No.', OCIN.BnkBranch AS 'Pay to Bank Branch', OCIN.isIns AS 'Reserve Invoice', OCIN.TrackNo AS 'Tracking Number', OCIN.VersionNum AS 'Version Number', OCIN.LangCode AS 'Language Code', OCIN.BPNameOW AS 'BP Name Overwritten', OCIN.BillToOW AS 'Bill-To Overwritten', OCIN.ShipToOW AS 'Ship-to Overwritten', OCIN.RetInvoice AS 'Credit Memo', OCIN.ClsDate AS 'Document Closing Date', OCIN.MInvNum AS 'Monthly Invoice No.', OCIN.MInvDate AS 'Monthly Invoice Date', OCIN.SeqCode AS 'Sequence Code', OCIN.Serial AS 'Serial Numbers', OCIN.SeriesStr AS 'Series String', OCIN.SubStr AS 'Sub-Series String', OCIN.Model AS 'Nota Fiscal Model', OCIN.TaxOnExp AS 'Tax on Freight Sum', OCIN.TaxOnExpFc AS 'Tax on Freight Sum (FC)', OCIN.TaxOnExpSc AS 'Tax on Freight Sum (SC)', OCIN.TaxOnExAp AS 'Tax on Freight Applied', OCIN.TaxOnExApF AS 'Tax on Freight Applied (FC)', OCIN.TaxOnExApS AS 'Tax on Freight Applied (SC)', OCIN.LastPmnTyp AS 'Last Payment Type', OCIN.LndCstNum AS 'Landed Cost Number', OCIN.UseCorrVat AS 'Use Correction VAT Group', OCIN.BlkCredMmo AS 'Block Creation of Target Credit Memo', OCIN.OpenForLaC AS 'Open for Landed Costs', OCIN.Excised AS 'Excised', OCIN.ExcRefDate AS 'Excise Ref. Date', OCIN.ExcRmvTime AS 'Excise Removal Time', OCIN.SrvGpPrcnt AS 'Gross Profit Prcnt of Service', OCIN.DepositNum AS 'Deposit Number', OCIN.CertNum AS 'Certificate Number', OCIN.DutyStatus AS 'Duty Status', OCIN.AutoCrtFlw AS 'Auto Create Follow-up Document', OCIN.FlwRefDate AS 'Follow-up Document Ref. Date', OCIN.FlwRefNum AS 'Follow-up Document Ref. Number', OCIN.VatJENum AS 'VAT Journal Entry Number', OCIN.DpmVat AS 'Down Payment Tax LC', OCIN.DpmVatFc AS 'Down Payment Tax FC', OCIN.DpmVatSc AS 'Down Payment Tax SC', OCIN.DpmAppVat AS 'Down Payment Applied Tax LC', OCIN.DpmAppVatF AS 'Down Payment Applied Tax FC', OCIN.DpmAppVatS AS 'Down Payment Applied Tax SC', OCIN.InsurOp347 AS '347 Insurance Operation', OCIN.IgnRelDoc AS 'Ignore Relevant Doc on Archive', OCIN.BuildDesc AS 'Build Descriptor', OCIN.ResidenNum AS 'Residence Number', OCIN.Checker AS 'Checker', OCIN.Payee AS 'Payee', OCIN.CopyNumber AS 'Copy Number', OCIN.SSIExmpt AS 'SSI Exemption', OCIN.PQTGrpSer AS 'Pur Quotation Group Series', OCIN.PQTGrpNum AS 'Pur Quotation Group Number', OCIN.PQTGrpHW AS 'Pur Quotation Group Manual', OCIN.ReopOriDoc AS 'Reopen Origin. Order by Return', OCIN.ReopManCls AS 'Reop. Man. Closed/Canc. Orders', OCIN.DocManClsd AS 'Document Was Closed Manually', OCIN.ClosingOpt AS 'Closing Option', OCIN.SpecDate AS 'Posting Date Specified by User', OCIN.Ordered AS 'Payment Ordered', OCIN.NTSApprov AS 'NTS Approved', OCIN.NTSWebSite AS 'E-Tax Web Site', OCIN.NTSeTaxNo AS 'E-Tax Number', OCIN.NTSApprNo AS 'NTS Approval Number', OCIN.PayDuMonth AS 'Start From', OCIN.ExtraMonth AS 'Number of Additional Months', OCIN.ExtraDays AS 'Number of Additional Days', OCIN.CdcOffset AS 'Cash Discount Offset', OCIN.SignMsg AS 'Signature Input Message', OCIN.SignDigest AS 'Signature Digest', OCIN.CertifNum AS 'Certification Number', OCIN.KeyVersion AS 'Private Key Version', OCIN.EDocGenTyp AS 'Electr. Doc. Generation Type', OCIN.ESeries AS 'Electronic Series', OCIN.EDocNum AS 'Electronic Document Number', OCIN.EDocExpFrm AS 'Electronic Doc. Export Format', OCIN.OnlineQuo AS 'Create Online Quotation', OCIN.POSEqNum AS 'POS Equipment Number', OCIN.POSManufSN AS 'POS Manufacturer Serial Number', OCIN.POSCashN AS 'POS Cashier Number', OCIN.EDocStatus AS 'Electronic Document Status', OCIN.EDocCntnt AS 'Electronic Document Content', OCIN.EDocProces AS 'Electronic Document Process', OCIN.EDocErrCod AS 'Electronic Document Error Code', OCIN.EDocErrMsg AS 'Electronic Document Error Msg', OCIN.EDocCancel AS 'Electronic Document - Canceled', OCIN.EDocTest AS 'Electronic Document - Testing', OCIN.EDocPrefix AS 'Electronic Document - Prefix', OCIN.CUP AS 'Unique Code of Project', OCIN.CIG AS 'Contract Code Identification', OCIN.DpmAsDscnt AS 'Discount Document with Dpm', OCIN.Attachment AS 'Attachment', OCIN.AtcEntry AS 'Attachment Entry', OCIN.SupplCode AS 'Supplementary Code', OCIN.GTSRlvnt AS 'Relevant To GTS', OCIN.BaseDisc AS 'Base Discount LC', OCIN.BaseDiscSc AS 'Base Discount SC', OCIN.BaseDiscFc AS 'Base Discount FC', OCIN.BaseDiscPr AS 'Base Discount Percentage', OCIN.CreateTS AS 'Creatn Time - Incl. Secs', OCIN.UpdateTS AS 'Update Full Time', OCIN.SrvTaxRule AS 'Apply Service Tax Rule', OCIN.AnnInvDecR AS 'Annual Inv. Declaration Ref.', OCIN.Supplier AS 'Supplier', OCIN.Releaser AS 'Goods Distribution Approver', OCIN.Receiver AS 'Goods Release Approver', OCIN.ToWhsCode AS 'To Warehouse Code', OCIN.AssetDate AS 'Fixed Asset Value Date', OCIN.Requester AS 'User Requesting Goods', OCIN.ReqName AS 'User Name', OCIN.Branch AS 'Branch', OCIN.Department AS 'Department', OCIN.Email AS 'E-Mail', OCIN.Notify AS 'Send Notification Needed', OCIN.ReqType AS 'Requester Type User/Employee', OCIN.OriginType AS 'Document Origin', OCIN.IsReuseNum AS 'Is Reusing Document Number', OCIN.IsReuseNFN AS 'Is Reusing Nota Fiscal Number', OCIN.DocDlvry AS 'Document Delivery', OCIN.PaidDpm AS 'Paid by Down Payment', OCIN.PaidDpmF AS 'Paid by Down Payment (FC)', OCIN.PaidDpmS AS 'Paid by Down Payment (SC)', OCIN.EnvTypeNFe AS 'Environment Type NF-e', OCIN.AgrNo AS 'Agreement No.', OCIN.IsAlt AS 'Is Alteration', OCIN.AltBaseTyp AS 'Alteration Base Type', OCIN.AltBaseEnt AS 'Alteration Base Entry', OCIN.AuthCode AS 'Authorization Code', OCIN.StDlvDate AS 'Start Delivery Date', OCIN.StDlvTime AS 'Start Delivery Time', OCIN.EndDlvDate AS 'End Delivery Date', OCIN.EndDlvTime AS 'End Delivery Time', OCIN.VclPlate AS 'Vehicle Plate', OCIN.ElCoStatus AS 'Elec. Comm. Status', OCIN.AtDocType AS 'AT Document Type', OCIN.ElCoMsg AS 'Elec. Comm. Message', OCIN.PrintSEPA AS 'Print SEPA Direct Debit Prenotification', OCIN.FreeChrg AS 'Free of Charge BP', OCIN.FreeChrgFC AS 'Free of Charge BP FC', OCIN.FreeChrgSC AS 'Free of Charge BP SC', OCIN.NfeValue AS 'NF-e Value', OCIN.FiscDocNum AS 'Fiscal Document Number', OCIN.RelatedTyp AS 'Related Type', OCIN.RelatedEnt AS 'Related Entry', OCIN.CCDEntry AS 'CCD Abs. Entry', OCIN.NfePrntFo AS 'NF-e Printing Format', OCIN.ZrdAbs AS 'POS Daily Summary Number', OCIN.POSRcptNo AS 'POS Receipt Number', OCIN.FoCTax AS 'Free of Charge BP Tax', OCIN.FoCTaxFC AS 'Free of Charge BP Tax FC', OCIN.FoCTaxSC AS 'Free of Charge BP Tax SC', OCIN.TpCusPres AS 'Type of End-User Presence', OCIN.ExcDocDate AS 'Excise Doc. Date', OCIN.FoCFrght AS 'Free of Charge Freight', OCIN.FoCFrghtFC AS 'Free of Charge Freight FC', OCIN.FoCFrghtSC AS 'Free of Charge Freight SC', OCIN.InterimTyp AS 'Interim Type', OCIN.PTICode AS 'POI Code', OCIN.Letter AS 'Letter', OCIN.FolNumFrom AS 'Folio Number From', OCIN.FolNumTo AS 'Folio Number To', OCIN.FolSeries AS 'Folio Series', OCIN.SplitTax AS 'Split Payment Tax', OCIN.SplitTaxFC AS 'Split Payment Tax FC', OCIN.SplitTaxSC AS 'Split Payment Tax SC' FROM OCIN AS OCIN

Related information


OCIN SQL Table

Agent Name OAGP SQL Table

Countries OCRY SQL Table

Contact Persons OCPR SQL Table

Business Partner OCRD SQL Table

Business Place OBPL SQL Table

Branches OUBR SQL Table

Employees OHEM SQL Table

CIG Codes OCIG SQL Table

Central Bank Ind. OCBI SQL Table

G/L Accounts OACT SQL Table

CUP Codes OCUP SQL Table

Departments OUDP SQL Table

Currency Codes OCRN SQL Table

Drafts ODRF SQL Table

Dunning Letters ODUN SQL Table

Brazil Numeric Indexer OBNI SQL Table

Electronic Series NNM4 SQL Table

Warehouses OWHS SQL Table

Posting Period OFPR SQL Table

Folio Numbering - Series OFNS SQL Table

1099 Forms OTNN SQL Table

Payment Terms OCTG SQL Table

Indicator OIDC SQL Table

User Language Table OLNG SQL Table

Nota Fiscal Model ONFM SQL Table

E-Tax Web Site OTWS SQL Table

Object Settings - History ADP1 SQL Table

Payment Block OPYB SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Period Indicator OPID SQL Table

Project Codes OPRJ SQL Table

Point of Issue OPTI SQL Table

Documents Numbering - Series NNM1 SQL Table

Sales Employee OSLP SQL Table

Workstation ID CSTN SQL Table

Journal Entry OJDT SQL Table

Delivery Types OSHP SQL Table

Users OUSR SQL Table

POS Daily Summary OZRD 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