OCIN - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Marketing Documents and Receipts / A/R Correction Invoice

API OCIN

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
DocNum ^KEY ^UNIQUE	Document Number	Int		11			NUM	Yes
DocType	Document Type	VarChar	I) Item S) Service	1		I
CANCELED	Canceled	VarChar	Y) Yes N) No	1		N
Handwrtten	Manual Numbering	VarChar	Y) Yes N) No	1		N
Printed	Printed	VarChar	Y) Copy N) Original A) Amended	1		N
DocStatus ^KEY	Document Status	VarChar	O) Open C) Closed	1		O	DOC_STATUS	No
InvntSttus	Warehouse Status	VarChar	O) Open C) Closed	1		O
Transfered	Year Transfer	VarChar	Y) Yes N) No	1		N
ObjType	Object Type	nVarChar	132) Correction Invoice	20	ADP1 Object Settings - History	132
DocDate ^KEY	Posting Date	Date		8			DATE_PIND	No
DocDueDate	Due Date	Date		8
CardCode ^KEY	Customer/Vendor Code	nVarChar		15	OCRD Business Partner		CUSTOMER	No
CardName	Customer/Vendor Name	nVarChar		100
Address	Bill to	nVarChar		127
NumAtCard ^KEY	BP Reference No.	nVarChar		100			AT_CARD	No
VatPercent	Tax Rate	Num		20
VatSum	Total Tax	Num		20
VatSumFC	Tax Amount (FC)	Num		20
DiscPrcnt	Discount % for Document	Num		20
DiscSum	Total Discount	Num		20
DiscSumFC	Total Discount (FC)	Num		20
DocCur	Document Currency	nVarChar		3	OCRN Currency Codes
DocRate	Document Rate	Num		20
DocTotal	Document Total	Num		20
DocTotalFC	Document Total (FC)	Num		20
PaidToDate	Paid to Date	Num		20
PaidFC	Paid (FC)	Num		20
GrosProfit	Gross Profit	Num		20
GrosProfFC	Gross Profit (FC)	Num		20
Ref1	Reference 1	nVarChar		11
Ref2	Reference 2	nVarChar		11
Comments	Remarks	nVarChar		127
JrnlMemo	Journal Remark	nVarChar		50
TransId	Transaction Number	Int		11	OJDT Journal Entry
ReceiptNum	Incoming Payment No.	Int		11
GroupNum	Payment Terms Code	Int		6	OCTG Payment Terms
DocTime	Creation Time	Int		6
SlpCode	Sales Employee	Int		11	OSLP Sales Employee	-1
TrnspCode	Shipping Type	Int		6	OSHP Delivery Types	-1
PartSupply	Partial Delivery	VarChar	Y) Yes N) No	1		Y
Confirmed	Confirmed	VarChar	Y) Yes N) No	1		Y
GrossBase	Price List for Gross Profit	Int		6		0
ImportEnt	Order Number	Int		11
CreateTran	Create Journal Entry	VarChar	Y) Yes N) No	1		N
SummryType	Summary Method	VarChar	N) No Summary I) By Items D) By Documents	1		N
UpdInvnt	Whse Update	VarChar	N) No O) Orders from Vendors C) Customer Orders G) Consignment I) Stock	1		N
UpdCardBal	Update Balances	VarChar	N) No O) Orders D) Delivery Notes B) Bookkeeping	1		N
Instance	Instance	Int		6		0
Flags	Flags	Int		11		0
InvntDirec	Warehouse Direction	VarChar	X) Release E) Receipt	1		E
CntctCode	Contact Person	Int		11	OCPR Contact Persons
ShowSCN	Display BP Catalog Number	VarChar	Y) Yes N) No	1		N
FatherCard ^KEY	Consolidating BP	nVarChar		15	OCRD Business Partner		FTHR_CARD	No
SysRate	System Price	Num		20
CurSource	Base Currency	VarChar	L) Local Currency S) System Currency C) BP Currency	1		C
VatSumSy	Tax Amount (SC)	Num		20
DiscSumSy	Total Discount (SC)	Num		20
DocTotalSy	Document Total (SC)	Num		20
PaidSys	Paid (SC)	Num		20
FatherType	Parent Consolidation Type	VarChar	P) Payment Consolidation D) Delivery Consolidation	1		P
GrosProfSy	Gross Profit (SC)	Num		20
UpdateDate	Date of Update	Date		8
IsICT	A/R Invoice + Payment	VarChar	Y) Yes N) No	1		N
CreateDate	Creation Date	Date		8
Volume	Volume	Num		20
VolUnit	Volume UoM	Int		6
Weight	Weight	Num		20
WeightUnit	Weight UoM	Int		6
Series ^KEY	Series	Int		6	NNM1 Documents Numbering - Series		SERIES	No
TaxDate	Document Date	Date		8
Filler	Filter	nVarChar		8	OWHS Warehouses
DataSource	Data Source	VarChar	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
StampNum	Stamp No.	nVarChar		16
isCrin	Correction Invoice	VarChar	Y) Yes N) No	1		N
FinncPriod	Posting Period	Int		11	OFPR Posting Period
UserSign	User Signature	Int		6	OUSR Users
selfInv	Autom. Invoice	VarChar	N) No Y) Yes	1		N
VatPaid	Tax Paid to Date	Num		20
VatPaidFC	Tax Paid (FC)	Num		20
VatPaidSys	Tax Paid (SC)	Num		20
UserSign2	Updating User	Int		6	OUSR Users
WddStatus	Approval Status	VarChar	-) Without W) Pending Y) Approved N) Rejected P) Generated A) Generated by Authorizer C) Canceled	1
draftKey	Document Draft Internal ID	Int		11	ODRF Drafts	-1
TotalExpns	Total Freight	Num		20
TotalExpFC	Total Freight (FC)	Num		20
TotalExpSC	Total Freight (SC)	Num		20
DunnLevel	Dunning Level	Int		11	ODUN Dunning Letters
Address2	Ship To	nVarChar		127
LogInstanc	Log Instance	Int		11		0
Exported	Exported	VarChar	Y) Yes N) No	1		N
StationID	Workstation ID	Int		11	CSTN Workstation ID
Indicator	Indicator	nVarChar		2	OIDC Indicator
NetProc	Net Procedure	VarChar	Y) Yes N) No	1		N
AqcsTax	Acquisition Tax	Num		20
AqcsTaxFC	Acquisition Tax (FC)	Num		20
AqcsTaxSC	Acquisition Tax (SC)	Num		20
CashDiscPr	Cash Discount %	Num		20
CashDiscnt	Cash Discount	Num		20
CashDiscFC	Cash Discount (FC)	Num		20
CashDiscSC	Cash Discount SC	Num		20
ShipToCode	Ship-to Code	nVarChar		50
LicTradNum	Licensed Dealer No.	nVarChar		32
PaymentRef	Payment Reference No.	nVarChar		27
WTSum	WTax Amount	Num		20
WTSumFC	WTax Amount (FC)	Num		20
WTSumSC	WTax Amount (SC)	Num		20
RoundDif	Rounding Diff. Amount	Num		20
RoundDifFC	Rounding Diff. Amount (FC)	Num		20
RoundDifSy	Rounding Diff. Amount (SC)	Num		20
CheckDigit	Control Digit	VarChar		1
Form1099	1099 Form	Int		11	OTNN 1099 Forms
Box1099	1099 Box	nVarChar		20
submitted	Submitted	VarChar	Y) Yes N) No	1		N
PoPrss	PO Process	VarChar	Y) Yes N) No	1		N
Rounding	Rounding	VarChar	Y) Yes N) No	1		N
RevisionPo	Split PO	VarChar	Y) Yes N) No	1		N
Segment	Segment	Int		6		0
ReqDate	Required Date	Date		8
CancelDate	Cancelation Date	Date		8
PickStatus	Pick Status	VarChar	Y) Yes N) No	1		N
Pick	Pick	VarChar	Y) Yes N) No	1		N
BlockDunn	Block Dunning	VarChar	Y) Yes N) No	1		N
PeyMethod	Payment Method	nVarChar		15	OPYM Payment Methods for Payment Wizard
PayBlock	Payment Block	VarChar	Y) Yes N) No	1		N
PayBlckRef	Payment Block Abs Entry	Int		11	OPYB Payment Block
MaxDscn	Maximum Discount	VarChar	Y) Yes N) No	1		N
Reserve	Reserve	VarChar	Y) Yes N) No	1		N
Max1099	Max. 1099 Amount	Num		20
CntrlBnk	Central Bank Indicator	nVarChar		15	OCBI Central Bank Ind.
PickRmrk	Pick Remarks	nVarChar		127
ISRCodLine	ISR Coding Line	nVarChar		53
ExpAppl	Exp applied	Num		20
ExpApplFC	Exp applied FC	Num		20
ExpApplSC	Exp applied DC	Num		20
Project	Project Code	nVarChar		20	OPRJ Project Codes
DeferrTax	Deferred Tax	VarChar	Y) Yes N) No	1
LetterNum	Tax Exemption Letter No.	nVarChar		20
FromDate	Exemption Validity Date From	Date		8
ToDate	Exemption Validity Date To	Date		8
WTApplied	Applied WTax	Num		20
WTAppliedF	Applied WTax (FC)	Num		20
BoeReserev	Bill of Exchange Reserved	VarChar	Y) Yes N) No	1		N
AgentCode	Agent Code	nVarChar		32	OAGP Agent Name
WTAppliedS	Applied WTax (SC)	Num		20
EquVatSum	Total Equalization Tax	Num		20
EquVatSumF	Total Equalization Tax (FC)	Num		20
EquVatSumS	Total Equalization Tax (SC)	Num		20
Installmnt	No. of Installments	Int		6		1
VATFirst	Apply Tax on 1st Installment	VarChar	Y) Yes N) No	1
NnSbAmnt	WTax Non-Subject Amount	Num		20
NnSbAmntSC	WTax Non-Subject Amount (SC)	Num		20
NbSbAmntFC	WTax Non-Subject Amount (FC)	Num		20
ExepAmnt	Withholding Tax Exempt Amount	Num		20
ExepAmntSC	WTax Exempt Amount (SC)	Num		20
ExepAmntFC	WTax Exempt Amount (FC)	Num		20
VatDate	Document Date	Date		8
CorrExt	External Corrected Document No.	nVarChar		25
CorrInv	Internal Corrected Document No.	Int		11
NCorrInv	Next Correcting Document	Int		11
CEECFlag	Block Creation of Tgt Corr Doc	VarChar	N) No Y) Yes	1		N
BaseAmnt	Base Amount	Num		20
BaseAmntSC	Base Amount (SC)	Num		20
BaseAmntFC	Base Amount (FC)	Num		20
CtlAccount	Control Account	nVarChar		15	OACT G/L Accounts
BPLId	Branch	Int		11	OBPL Business Place
BPLName	Branch Name	nVarChar		100
VATRegNum	VAT Reg. Number	nVarChar		32
TxInvRptNo	Tax Invoice Rpt Number	nVarChar		10
TxInvRptDt	Tax Invoice Rpt Date	Date		8
KVVATCode	VAT Code for Tax Invoice Rpt	Text		16
WTDetails	WTax Details	nVarChar		100
SumAbsId	Summary VAT Abstract ID	Int		11		-1
SumRptDate	Summary VAT Report Date	Date		8
PIndicator	Period Indicator	nVarChar		10	OPID Period Indicator	' '
ManualNum	Manual Number	nVarChar		20
UseShpdGd	Use Shipped Goods Account	VarChar	N) No Y) Yes	1		N
BaseVtAt	BPL ID Assigned to Invoice	Num		20
BaseVtAtSC	BPL Name	Num		20
BaseVtAtFC	Tax Reg. Number	Num		20
NnSbVAt	Tax Invoice Rpt Number	Num		20
NnSbVAtSC	Tax Invoice Rpt Date	Num		20
NbSbVAtFC	WTax Non-Subject VAT Amt (FC)	Num		20
ExptVAt	WTax Exempt VAT Amount	Num		20
ExptVAtSC	WTax Exempt VAT Amount (SC)	Num		20
ExptVAtFC	WTax Exempt VAT Amount (FC)	Num		20
LYPmtAt	Last Year's Payments	Num		20
LYPmtAtSC	Last Years Payments (SC)	Num		20
LYPmtAtFC	Summary Tax Report Date	Num		20
ExpAnSum	Period Indicator	Num		20
ExpAnSys	Manual Number	Num		20
ExpAnFrgn	Use Shipped Goods Account	Num		20
DocSubType	VAT Code for Tax Invoice Rpt	nVarChar	--) Correction Invoice	2		--
DpmStatus	Summary VAT Abstract ID	VarChar	O) Open C) Closed	1		O
DpmAmnt	Down Payment Amount LC	Num		20
DpmAmntSC	Down Payment Amount SC	Num		20
DpmAmntFC	Down Payment Amount FC	Num		20
DpmDrawn	Drawn to Down Payment	VarChar	N) No Y) Yes	1		N
DpmPrcnt	Down Payment Percent	Num		20
PaidSum	Total Paid Sum	Num		20
PaidSumFc	Total Paid Sum (FC)	Num		20
PaidSumSc	Total Paid Sum (SC)	Num		20
FolioPref	Folio Prefix String	nVarChar		4
FolioNum	Folio Number	Int		11
DpmAppl	Down Payment Applied LC	Num		20
DpmApplFc	Down Payment Applied FC	Num		20
DpmApplSc	Down Payment Applied SC	Num		20
LPgFolioN	Folio No. for Last Page in Doc.	Int		11
Header	Header	Text		16
Footer	Footer	Text		16
Posted	Down Payment Was Posted	VarChar	Y) Yes N) No	1		Y
OwnerCode ^KEY	Document Owner	Int		11	OHEM Employees		OWNER_CODE	No
BPChCode	BP Channel Code	nVarChar		15	OCRD Business Partner
BPChCntc	BP Channel Contact Person	Int		11	OCPR Contact Persons
PayToCode	Pay to	nVarChar		50
IsPaytoBnk	Is Pay to Bank	VarChar	N) No Y) Yes	1
BnkCntry	Pay to Bank Country	nVarChar		3	OCRY Countries
BankCode	Pay to Bank Code	nVarChar		30
BnkAccount	Pay to Bank Account No.	nVarChar		50
BnkBranch	Pay to Bank Branch	nVarChar		50
isIns	Reserve Invoice	VarChar	Y) Yes N) No	1		N
TrackNo	Tracking Number	nVarChar		30
VersionNum	Version Number	nVarChar		11
LangCode	Language Code	Int		11	OLNG User Language Table
BPNameOW	BP Name Overwritten	VarChar	Y) Yes N) No	1		N
BillToOW	Bill-To Overwritten	VarChar	Y) Yes N) No	1		N
ShipToOW	Ship-to Overwritten	VarChar	Y) Yes N) No	1		N
RetInvoice	Credit Memo	VarChar	Y) Yes N) No	1		N
ClsDate	Document Closing Date	Date		8
MInvNum	Monthly Invoice No.	Int		11
MInvDate	Monthly Invoice Date	Date		8
SeqCode	Sequence Code	Int		6
Serial	Serial Numbers	Int		11
SeriesStr	Series String	nVarChar		3
SubStr	Sub-Series String	nVarChar		3
Model	Nota Fiscal Model	nVarChar		6	ONFM Nota Fiscal Model	0
TaxOnExp	Tax on Freight Sum	Num		20
TaxOnExpFc	Tax on Freight Sum (FC)	Num		20
TaxOnExpSc	Tax on Freight Sum (SC)	Num		20
TaxOnExAp	Tax on Freight Applied	Num		20
TaxOnExApF	Tax on Freight Applied (FC)	Num		20
TaxOnExApS	Tax on Freight Applied (SC)	Num		20
LastPmnTyp	Last Payment Type	VarChar	R) Receipt V) Vendor Payment	1
LndCstNum	Landed Cost Number	Int		11
UseCorrVat	Use Correction VAT Group	VarChar	N) No Y) Yes	1		N
BlkCredMmo	Block Creation of Target Credit Memo	VarChar	N) No Y) Yes	1		N
OpenForLaC	Open for Landed Costs	VarChar	Y) Open for Landed Costs N) Closed for Landed Costs	1		Y
Excised	Excised	VarChar	O) Open C) Close	1		O
ExcRefDate	Excise Ref. Date	Date		8
ExcRmvTime	Excise Removal Time	nVarChar		8
SrvGpPrcnt	Gross Profit Prcnt of Service	Num		20
DepositNum	Deposit Number	Int		11
CertNum	Certificate Number	nVarChar		31
DutyStatus	Duty Status	VarChar	Y) With Payment of Duty N) Without Payment of Duty	1		Y
AutoCrtFlw	Auto Create Follow-up Document	VarChar	N) No Y) Yes	1		N
FlwRefDate	Follow-up Document Ref. Date	Date		8
FlwRefNum	Follow-up Document Ref. Number	nVarChar		100
VatJENum	VAT Journal Entry Number	Int		11		-1
DpmVat	Down Payment Tax LC	Num		20
DpmVatFc	Down Payment Tax FC	Num		20
DpmVatSc	Down Payment Tax SC	Num		20
DpmAppVat	Down Payment Applied Tax LC	Num		20
DpmAppVatF	Down Payment Applied Tax FC	Num		20
DpmAppVatS	Down Payment Applied Tax SC	Num		20
InsurOp347	347 Insurance Operation	VarChar	N) No Y) Yes	1		N
IgnRelDoc	Ignore Relevant Doc on Archive	VarChar	N) No Y) Yes	1		N
BuildDesc	Build Descriptor	nVarChar		50
ResidenNum	Residence Number	VarChar	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
Checker	Checker	Int		11	OHEM Employees
Payee	Payee	Int		11	OHEM Employees
CopyNumber	Copy Number	Int		11		0
SSIExmpt	SSI Exemption	VarChar	Y) Yes N) No	1
PQTGrpSer	Pur Quotation Group Series	Int		6
PQTGrpNum	Pur Quotation Group Number	Int		11
PQTGrpHW	Pur Quotation Group Manual	VarChar	Y) Yes N) No	1		N
ReopOriDoc	Reopen Origin. Order by Return	VarChar	Y) Yes N) No	1
ReopManCls	Reop. Man. Closed/Canc. Orders	VarChar	Y) Yes N) No	1
DocManClsd	Document Was Closed Manually	VarChar	Y) Yes N) No U) Unknown	1		N
ClosingOpt	Closing Option	Int		6		1
SpecDate	Posting Date Specified by User	Date		8
Ordered	Payment Ordered	VarChar	Y) Yes N) No	1		N
NTSApprov	NTS Approved	VarChar	N) No Y) Yes	1		N
NTSWebSite	E-Tax Web Site	Int		6	OTWS E-Tax Web Site
NTSeTaxNo	E-Tax Number	nVarChar		50
NTSApprNo	NTS Approval Number	nVarChar		50
PayDuMonth	Start From	VarChar	E) Month End H) Half Month Y) Month Start N)	1
ExtraMonth	Number of Additional Months	Int		6
ExtraDays	Number of Additional Days	Int		6
CdcOffset	Cash Discount Offset	Int		6		0
SignMsg	Signature Input Message	Text		16
SignDigest	Signature Digest	Text		16
CertifNum	Certification Number	nVarChar		50
KeyVersion	Private Key Version	Int		11
EDocGenTyp	Electr. Doc. Generation Type	VarChar	G) Generate L) Generate - Later S) Send R) Send - Later N) Not Relevant	1		N
ESeries ^KEY	Electronic Series	Int		6	NNM4 Electronic Series		ESERIES	No
EDocNum	Electronic Document Number	nVarChar		50
EDocExpFrm	Electronic Doc. Export Format	Int		11
OnlineQuo	Create Online Quotation	VarChar	Y) Yes N) No	1		N
POSEqNum	POS Equipment Number	nVarChar		20
POSManufSN	POS Manufacturer Serial Number	nVarChar		20
POSCashN	POS Cashier Number	Int		11
EDocStatus	Electronic Document Status	VarChar	N) New P) Pending S) Sent E) Error C) OK	1		C
EDocCntnt	Electronic Document Content	Text		16
EDocProces	Electronic Document Process	VarChar	C) CFD I) CFDI	1		C
EDocErrCod	Electronic Document Error Code	nVarChar		50
EDocErrMsg	Electronic Document Error Msg	Text		16
EDocCancel	Electronic Document - Canceled	VarChar	N) No Y) Yes	1		N
EDocTest	Electronic Document - Testing	VarChar	N) No Y) Yes	1		N
EDocPrefix	Electronic Document - Prefix	nVarChar		10
CUP	Unique Code of Project	Int		11	OCUP CUP Codes
CIG	Contract Code Identification	Int		11	OCIG CIG Codes
DpmAsDscnt	Discount Document with Dpm	VarChar	N) No Y) Yes	1		N
Attachment	Attachment	Text		16
AtcEntry	Attachment Entry	Int		11
SupplCode	Supplementary Code	nVarChar		127
GTSRlvnt	Relevant To GTS	VarChar	N) No Y) Yes	1		N
BaseDisc	Base Discount LC	Num		20
BaseDiscSc	Base Discount SC	Num		20
BaseDiscFc	Base Discount FC	Num		20
BaseDiscPr	Base Discount Percentage	Num		20
CreateTS	Creatn Time - Incl. Secs	Int		11
UpdateTS	Update Full Time	Int		11
SrvTaxRule	Apply Service Tax Rule	VarChar	Y) Yes N) No	1		N
AnnInvDecR	Annual Inv. Declaration Ref.	Int		11
Supplier	Supplier	nVarChar		15	OCRD Business Partner
Releaser	Goods Distribution Approver	Int		11	OHEM Employees
Receiver	Goods Release Approver	Int		11	OHEM Employees
ToWhsCode	To Warehouse Code	nVarChar		8	OWHS Warehouses
AssetDate	Fixed Asset Value Date	Date		8
Requester	User Requesting Goods	nVarChar		8
ReqName	User Name	nVarChar		127
Branch	Branch	Int		6	OUBR Branches
Department	Department	Int		6	OUDP Departments
Email	E-Mail	nVarChar		100
Notify	Send Notification Needed	VarChar	Y) Yes N) No	1
ReqType	Requester Type User/Employee	Int	12) User 171) Employee	11		12
OriginType	Document Origin	VarChar	M) Manual R) MRP S) Sales Order D) Document Generation Wizard	1		M
IsReuseNum	Is Reusing Document Number	VarChar	Y) Yes N) No	1		N
IsReuseNFN	Is Reusing Nota Fiscal Number	VarChar	Y) Yes N) No	1		N
DocDlvry	Document Delivery	VarChar	0 1) Create Online Document 2) Post to Ariba Network	1
PaidDpm	Paid by Down Payment	Num		20
PaidDpmF	Paid by Down Payment (FC)	Num		20
PaidDpmS	Paid by Down Payment (SC)	Num		20
EnvTypeNFe	Environment Type NF-e	Int		11	OBNI Brazil Numeric Indexer	-1
AgrNo	Agreement No.	Int		11
IsAlt	Is Alteration	VarChar	Y) Yes N) No	1		N
AltBaseTyp	Alteration Base Type	Int	-1) 13) 18) 163) 165)	11		-1
AltBaseEnt	Alteration Base Entry	Int		11
AuthCode	Authorization Code	nVarChar		127
StDlvDate	Start Delivery Date	Date		8
StDlvTime	Start Delivery Time	Int		11
EndDlvDate	End Delivery Date	Date		8
EndDlvTime	End Delivery Time	Int		11
VclPlate	Vehicle Plate	nVarChar		20
ElCoStatus	Elec. Comm. Status	nVarChar	0 1) Pending Approval 2) Rejected	10
AtDocType	AT Document Type	nVarChar	GT) GT GA) GA GD) GD GR) GR GC) GC FT) FT FS) FS NC) NC ND) ND FR) FR	2
ElCoMsg	Elec. Comm. Message	nVarChar		127
PrintSEPA	Print SEPA Direct Debit Prenotification	VarChar	Y) Yes N) No	1		N
FreeChrg	Free of Charge BP	Num		20
FreeChrgFC	Free of Charge BP FC	Num		20
FreeChrgSC	Free of Charge BP SC	Num		20
NfeValue	NF-e Value	Num		20
FiscDocNum	Fiscal Document Number	nVarChar		100
RelatedTyp	Related Type	Int	-1)	11		-1
RelatedEnt	Related Entry	Int		11
CCDEntry	CCD Abs. Entry	Int		11
NfePrntFo	NF-e Printing Format	Int	0 1) Portrait 2) Landscape 3) Simplified 4) DANFE NFC-e 5) Mail	11		0
ZrdAbs	POS Daily Summary Number	Int		11	OZRD POS Daily Summary
POSRcptNo	POS Receipt Number	Int		11
FoCTax	Free of Charge BP Tax	Num		20
FoCTaxFC	Free of Charge BP Tax FC	Num		20
FoCTaxSC	Free of Charge BP Tax SC	Num		20
TpCusPres	Type of End-User Presence	Int		11	OBNI Brazil Numeric Indexer
ExcDocDate	Excise Doc. Date	Date		8
FoCFrght	Free of Charge Freight	Num		20
FoCFrghtFC	Free of Charge Freight FC	Num		20
FoCFrghtSC	Free of Charge Freight SC	Num		20
InterimTyp	Interim Type	Int	0	6		0
PTICode	POI Code	nVarChar		5	OPTI Point of Issue
Letter	Letter	VarChar		1
FolNumFrom	Folio Number From	Int		11
FolNumTo	Folio Number To	Int		11
FolSeries	Folio Series	Int		11	OFNS Folio Numbering - Series
SplitTax	Split Payment Tax	Num		20
SplitTaxFC	Split Payment Tax FC	Num		20
SplitTaxSC	Split Payment Tax SC	Num		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

OAGP SQL Table

OCRY SQL Table

OCPR SQL Table

OCRD SQL Table

OBPL SQL Table

OUBR SQL Table

OHEM SQL Table

OCIG SQL Table

OCBI SQL Table

OACT SQL Table

OCUP SQL Table

OUDP SQL Table

OCRN SQL Table

ODRF SQL Table

ODUN SQL Table

OBNI SQL Table

NNM4 SQL Table

OWHS SQL Table

OFPR SQL Table

OFNS SQL Table

OTNN SQL Table

OCTG SQL Table

OIDC SQL Table

OLNG SQL Table

ONFM SQL Table

OTWS SQL Table

ADP1 SQL Table

OPYB SQL Table

OPYM SQL Table

OPID SQL Table

OPRJ SQL Table

OPTI SQL Table

NNM1 SQL Table

OSLP SQL Table

CSTN SQL Table

OJDT SQL Table

OSHP SQL Table

OUSR SQL Table

OZRD SQL Table

biuan SAP® BUSINESS ONE

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