| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Business Partners / Business Partner Master Data API OCRD / Business Partners | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OCRD - Business Partner Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
OCRD.CardCode AS 'BP Code',
OCRD.CardName AS 'BP Name',
OCRD.CardType AS 'BP Type',
OCRD.GroupCode AS 'Group Code',
OCRD.CmpPrivate AS 'Company/Private/Government',
OCRD.Address AS 'Bill-to Street',
OCRD.ZipCode AS 'Bill-to Zip Code',
OCRD.MailAddres AS 'Ship-to Street',
OCRD.MailZipCod AS 'Ship-to Zip Code',
OCRD.Phone1 AS 'Telephone 1',
OCRD.Phone2 AS 'Telephone 2',
OCRD.Fax AS 'Fax Number',
OCRD.CntctPrsn AS 'Contact Person',
OCRD.Notes AS 'Remarks',
OCRD.Balance AS 'Account Balance',
OCRD.ChecksBal AS 'Open Checks Balance',
OCRD.DNotesBal AS 'Open Del. Notes\GRPO Balance',
OCRD.OrdersBal AS 'Open Orders Balance',
OCRD.GroupNum AS 'Payment Terms Code',
OCRD.CreditLine AS 'Credit Limit',
OCRD.DebtLine AS 'Payable Limit',
OCRD.Discount AS 'Discount %',
OCRD.VatStatus AS 'Tax Definition',
OCRD.LicTradNum AS 'Federal Tax ID',
OCRD.DdctStatus AS 'Liable for Ded. at Source',
OCRD.DdctPrcnt AS 'Withholding Tax Deduction %',
OCRD.ValidUntil AS 'Expiration Date for -% of Deduction',
OCRD.Chrctrstcs AS 'Properties',
OCRD.ExMatchNum AS 'Last Ext. Reconciliation No.',
OCRD.InMatchNum AS 'Last Int. Reconciliation No.',
OCRD.ListNum AS 'Price List No.',
OCRD.DNoteBalFC AS 'Open DN Balance in BP Curr.',
OCRD.OrderBalFC AS 'Open Orders Bal. in BP Curr.',
OCRD.DNoteBalSy AS 'Open DN Balance in SC',
OCRD.OrderBalSy AS 'Open Orders Bal. in SC',
OCRD.Transfered AS 'Year Transfer',
OCRD.BalTrnsfrd AS 'Balances transferred',
OCRD.IntrstRate AS 'Interest % on Liabilities',
OCRD.Commission AS 'Commission % for Customer',
OCRD.CommGrCode AS 'Commission Group',
OCRD.Free_Text AS 'Free Text',
OCRD.SlpCode AS 'Sales Employee Code',
OCRD.PrevYearAc AS 'Previous Year Balance',
OCRD.Currency AS 'BP Currency',
OCRD.RateDifAct AS 'Rate Differences Account',
OCRD.BalanceSys AS 'Balance in Account Currency',
OCRD.BalanceFC AS 'BP Balance in FC',
OCRD.Protected AS 'Protected BP',
OCRD.Cellular AS 'Mobile Phone',
OCRD.AvrageLate AS 'Average Payment Delay in Days',
OCRD.City AS 'Bill-to City',
OCRD.County AS 'Bill-to County',
OCRD.Country AS 'Bill-to Country',
OCRD.MailCity AS 'Ship-to City',
OCRD.MailCounty AS 'Ship-to County',
OCRD.MailCountr AS 'Ship-to Country',
OCRD.E_Mail AS 'E-Mail',
OCRD.Picture AS 'Picture',
OCRD.DflAccount AS 'Default Account',
OCRD.DflBranch AS 'Default Branch',
OCRD.BankCode AS 'Default Bank',
OCRD.AddID AS 'Additional ID No.',
OCRD.Pager AS 'Pager',
OCRD.FatherCard AS 'BP Summary',
OCRD.CardFName AS 'Foreign Name',
OCRD.FatherType AS 'Parent Summary Type',
OCRD.QryGroup1 AS 'Property 1',
OCRD.QryGroup2 AS 'Property 2',
OCRD.QryGroup3 AS 'Property 3',
OCRD.QryGroup4 AS 'Property 4',
OCRD.QryGroup5 AS 'Property 5',
OCRD.QryGroup6 AS 'Property 6',
OCRD.QryGroup7 AS 'Property 7',
OCRD.QryGroup8 AS 'Property 8',
OCRD.QryGroup9 AS 'Property 9',
OCRD.QryGroup10 AS 'Property 10',
OCRD.QryGroup11 AS 'Property 11',
OCRD.QryGroup12 AS 'Property 12',
OCRD.QryGroup13 AS 'Property 13',
OCRD.QryGroup14 AS 'Property 14',
OCRD.QryGroup15 AS 'Property 15',
OCRD.QryGroup16 AS 'Property 16',
OCRD.QryGroup17 AS 'Property 17',
OCRD.QryGroup18 AS 'Property 18',
OCRD.QryGroup19 AS 'Property 19',
OCRD.QryGroup20 AS 'Property 20',
OCRD.QryGroup21 AS 'Property 21',
OCRD.QryGroup22 AS 'Property 22',
OCRD.QryGroup23 AS 'Property 23',
OCRD.QryGroup24 AS 'Property 24',
OCRD.QryGroup25 AS 'Property 25',
OCRD.QryGroup26 AS 'Property 26',
OCRD.QryGroup27 AS 'Property 27',
OCRD.QryGroup28 AS 'Property 28',
OCRD.QryGroup29 AS 'Property 29',
OCRD.QryGroup30 AS 'Property 30',
OCRD.QryGroup31 AS 'Property 31',
OCRD.QryGroup32 AS 'Property 32',
OCRD.QryGroup33 AS 'Property 33',
OCRD.QryGroup34 AS 'Property 34',
OCRD.QryGroup35 AS 'Property 35',
OCRD.QryGroup36 AS 'Property 36',
OCRD.QryGroup37 AS 'Property 37',
OCRD.QryGroup38 AS 'Property 38',
OCRD.QryGroup39 AS 'Property 39',
OCRD.QryGroup40 AS 'Property 40',
OCRD.QryGroup41 AS 'Property 41',
OCRD.QryGroup42 AS 'Property 42',
OCRD.QryGroup43 AS 'Property 43',
OCRD.QryGroup44 AS 'Property 44',
OCRD.QryGroup45 AS 'Property 45',
OCRD.QryGroup46 AS 'Property 46',
OCRD.QryGroup47 AS 'Property 47',
OCRD.QryGroup48 AS 'Property 48',
OCRD.QryGroup49 AS 'Property 49',
OCRD.QryGroup50 AS 'Property 50',
OCRD.QryGroup51 AS 'Property 51',
OCRD.QryGroup52 AS 'Property 52',
OCRD.QryGroup53 AS 'Property 53',
OCRD.QryGroup54 AS 'Property 54',
OCRD.QryGroup55 AS 'Property 55',
OCRD.QryGroup56 AS 'Property 56',
OCRD.QryGroup57 AS 'Property 57',
OCRD.QryGroup58 AS 'Property 58',
OCRD.QryGroup59 AS 'Property 59',
OCRD.QryGroup60 AS 'Property 60',
OCRD.QryGroup61 AS 'Property 61',
OCRD.QryGroup62 AS 'Property 62',
OCRD.QryGroup63 AS 'Property 63',
OCRD.QryGroup64 AS 'Property 64',
OCRD.DdctOffice AS 'Deduction Approval Office',
OCRD.CreateDate AS 'Creation Date',
OCRD.UpdateDate AS 'Date of Update',
OCRD.ExportCode AS 'Data Export Code',
OCRD.DscntObjct AS 'Object for Discounts',
OCRD.DscntRel AS 'Discounts Ratio',
OCRD.SPGCounter AS 'SPG Counter',
OCRD.SPPCounter AS 'SPP Counter',
OCRD.DdctFileNo AS 'Tax Deduction File Number',
OCRD.SCNCounter AS 'SCN Counter',
OCRD.MinIntrst AS 'Min. Interest Letter Amount',
OCRD.DataSource AS 'Data Source',
OCRD.OprCount AS 'Open Opportunities',
OCRD.ExemptNo AS 'Exempt No.',
OCRD.Priority AS 'Priority',
OCRD.CreditCard AS 'Credit Cards',
OCRD.CrCardNum AS 'Credit Card No.',
OCRD.CardValid AS 'Credit Card Validity',
OCRD.UserSign AS 'User Signature',
OCRD.LocMth AS 'LC Reconciliation',
OCRD.validFor AS 'Active',
OCRD.validFrom AS 'Active From',
OCRD.validTo AS 'Active To',
OCRD.frozenFor AS 'Inactive',
OCRD.frozenFrom AS 'Inactive From',
OCRD.frozenTo AS 'Inactive To',
OCRD.sEmployed AS 'Self-Employed',
OCRD.MTHCounter AS 'MTH Counter',
OCRD.BNKCounter AS 'BNK Counter',
OCRD.DdgKey AS 'Withholding Tax Deduction Grp',
OCRD.DdtKey AS 'Current Deduction Hierarchy',
OCRD.ValidComm AS 'Active Remarks',
OCRD.FrozenComm AS 'Inactive Remarks',
OCRD.chainStore AS 'Belongs to Retail Store',
OCRD.DiscInRet AS 'Allow Doc Discount in Returns',
OCRD.State1 AS 'Bill-to State',
OCRD.State2 AS 'Ship-to State',
OCRD.VatGroup AS 'Tax Code',
OCRD.LogInstanc AS 'Log Instance',
OCRD.ObjType AS 'Object Type',
OCRD.Indicator AS 'Indicator',
OCRD.ShipType AS 'Shipping Type',
OCRD.DebPayAcct AS 'Accounts Receivable/Payable',
OCRD.ShipToDef AS 'Ship-to-Default',
OCRD.Block AS 'Bill-to Block',
OCRD.MailBlock AS 'Ship-to Block',
OCRD.Password AS 'Password',
OCRD.ECVatGroup AS 'Tax Group',
OCRD.Deleted AS 'Deleted',
OCRD.IBAN AS 'IBAN',
OCRD.DocEntry AS 'Internal Number',
OCRD.FormCode AS '1099 Form Code',
OCRD.Box1099 AS '1099 Box',
OCRD.PymCode AS 'Payment Method Code',
OCRD.BackOrder AS 'Backorder',
OCRD.PartDelivr AS 'Partial Delivery',
OCRD.DunnLevel AS 'Dunning Level',
OCRD.DunnDate AS 'Dunning Date',
OCRD.BlockDunn AS 'Block Dunning',
OCRD.BankCountr AS 'Bank Country',
OCRD.CollecAuth AS 'Collection Authorization',
OCRD.DME AS 'DME Identification',
OCRD.InstrucKey AS 'Instruction Key',
OCRD.SinglePaym AS 'Single Payment',
OCRD.ISRBillId AS 'ISR Biller ID',
OCRD.PaymBlock AS 'Payment Block',
OCRD.RefDetails AS 'Reference Details',
OCRD.HouseBank AS 'House Bank',
OCRD.OwnerIdNum AS 'ID Number',
OCRD.PyBlckDesc AS 'Payment Block Description',
OCRD.HousBnkCry AS 'House Bank Country',
OCRD.HousBnkAct AS 'House Bank Account',
OCRD.HousBnkBrn AS 'House Bank Branch',
OCRD.ProjectCod AS 'Project Code',
OCRD.SysMatchNo AS 'Last Sys. Reconciliation No.',
OCRD.VatIdUnCmp AS 'Unified Federal Tax ID',
OCRD.AgentCode AS 'Agent Code',
OCRD.TolrncDays AS 'Tolerance Days',
OCRD.SelfInvoic AS 'Self Invoice',
OCRD.DeferrTax AS 'Deferred Tax',
OCRD.LetterNum AS 'Tax Exemption Letter No.',
OCRD.MaxAmount AS 'Max. Exemption Amount',
OCRD.FromDate AS 'Exemption Validity Date From',
OCRD.ToDate AS 'Exemption Validity Date To',
OCRD.WTLiable AS 'Subject to Withholding Tax',
OCRD.CrtfcateNO AS 'Certificate No.',
OCRD.ExpireDate AS 'Expiration Date',
OCRD.NINum AS 'Registration No.',
OCRD.AccCritria AS 'Accrual',
OCRD.WTCode AS 'WTax Code',
OCRD.Equ AS 'Equalization Tax',
OCRD.HldCode AS 'Holidays Name',
OCRD.ConnBP AS 'Linked Business Partner',
OCRD.MltMthNum AS 'Last Multi. Reconciliation No.',
OCRD.TypWTReprt AS 'BP Type for WTax Report',
OCRD.VATRegNum AS 'VAT Reg. Number',
OCRD.RepName AS 'Representative Name',
OCRD.Industry AS 'Industry',
OCRD.Business AS 'Business',
OCRD.WTTaxCat AS 'Withholding Tax Cat.',
OCRD.IsDomestic AS 'Is Domestic',
OCRD.IsResident AS 'Is Resident',
OCRD.AutoCalBCG AS 'Auto Calculated Bank Charges',
OCRD.OtrCtlAcct AS 'Other Receivable/Payable',
OCRD.AliasName AS 'Alias Name',
OCRD.Building AS 'Bill-to Building/Floor/Room',
OCRD.MailBuildi AS 'Ship to Building/Floor/Room',
OCRD.BoEPrsnt AS 'Customer Bill of Exchang Pres',
OCRD.BoEDiscnt AS 'Customer BoE Discounted',
OCRD.BoEOnClct AS 'Bill of Exchange on Collection',
OCRD.UnpaidBoE AS 'Unpaid Bill of Exchange',
OCRD.ITWTCode AS 'Income Tax WTax Code',
OCRD.DunTerm AS 'Dunning Term',
OCRD.ChannlBP AS 'Channel BP',
OCRD.DfTcnician AS 'Default Technician',
OCRD.Territory AS 'Territory',
OCRD.BillToDef AS 'Bill-to Default',
OCRD.DpmClear AS 'Payment Advances',
OCRD.IntrntSite AS 'Web Site',
OCRD.LangCode AS 'Language Code',
OCRD.HousActKey AS 'House Bank Account Key',
OCRD.Profession AS 'Profession',
OCRD.CDPNum AS 'Closing Date Procedure Number',
OCRD.DflBankKey AS 'Default Bank Key',
OCRD.BCACode AS 'Bank Charges Allocation Codes',
OCRD.UseShpdGd AS 'Use Shipped Goods Account',
OCRD.RegNum AS 'Company Reg. No. (CRN)',
OCRD.VerifNum AS 'WTax Verification No.',
OCRD.BankCtlKey AS 'Default Bank Internal ID',
OCRD.HousCtlKey AS 'House Bank Control Number',
OCRD.AddrType AS 'Bill-to Address Type',
OCRD.InsurOp347 AS '347 Insurance Operation',
OCRD.MailAddrTy AS 'Ship-to Address Type',
OCRD.StreetNo AS 'Bill-to Street No.',
OCRD.MailStrNo AS 'Ship-to Street No.',
OCRD.TaxRndRule AS 'Tax Rounding Rule',
OCRD.VendTID AS 'Vender Type ID',
OCRD.ThreshOver AS 'Threshold Overlook',
OCRD.SurOver AS 'Surcharge Overlook',
OCRD.VendorOcup AS 'Vendor Occupation',
OCRD.OpCode347 AS '347 Operation Code',
OCRD.DpmIntAct AS 'DPM Interim Account',
OCRD.ResidenNum AS 'Residence Number',
OCRD.UserSign2 AS 'Updating User',
OCRD.PlngGroup AS 'Planning Group',
OCRD.VatIDNum AS 'VAT ID Number',
OCRD.Affiliate AS 'Affiliate',
OCRD.MivzExpSts AS 'Mivzak Export Status',
OCRD.HierchDdct AS 'Hierarchical Deduction',
OCRD.CertWHT AS 'Withholding Tax Certified',
OCRD.CertBKeep AS 'Bookkeeping Certified',
OCRD.WHShaamGrp AS 'Withholding Shaam Group',
OCRD.IndustryC AS 'Industry',
OCRD.DatevAcct AS 'DATEV Account',
OCRD.DatevFirst AS 'First Data Entry',
OCRD.GTSRegNum AS 'GTS Registration Number',
OCRD.GTSBankAct AS 'GTS Bank Account',
OCRD.GTSBilAddr AS 'GTS Billing Address',
OCRD.HsBnkSwift AS 'House Bank BIC/SWIFT Code',
OCRD.HsBnkIBAN AS 'House Bank IBAN',
OCRD.DflSwift AS 'Default Bank BIC/SWIFT Code',
OCRD.AutoPost AS 'Automatic Posting',
OCRD.IntrAcc AS 'Interest Account',
OCRD.FeeAcc AS 'Fee Account',
OCRD.CpnNo AS 'Campaign No.',
OCRD.NTSWebSite AS 'E-Tax Web Site',
OCRD.DflIBAN AS 'Default Bank IBAN',
OCRD.Series AS 'Series',
OCRD.Number AS 'Number',
OCRD.EDocExpFrm AS 'Electronic Doc. Export Format',
OCRD.TaxIdIdent AS 'Tax ID Category',
OCRD.Attachment AS 'Attachment',
OCRD.AtcEntry AS 'Attachment Entry',
OCRD.DiscRel AS 'Disc. Relations',
OCRD.NoDiscount AS 'No Discounts',
OCRD.SCAdjust AS 'SC Adjustment',
OCRD.DflAgrmnt AS 'Default Blanket Agreement No.',
OCRD.GlblLocNum AS 'Global Location Number',
OCRD.SenderID AS 'EDI Message Sender ID',
OCRD.RcpntID AS 'EDI Message Recipient ID',
OCRD.MainUsage AS 'Main Usage',
OCRD.SefazCheck AS 'Check BP Status on SEFAZ',
OCRD.free312 AS 'Free312',
OCRD.free313 AS 'Free312',
OCRD.DateFrom AS 'Relationship Initial Date',
OCRD.DateTill AS 'Relationship Final Date',
OCRD.RelCode AS 'Relationship Code',
OCRD.OKATO AS 'OKATO',
OCRD.OKTMO AS 'OKTMO',
OCRD.KBKCode AS 'KBK Budget Classification Code',
OCRD.TypeOfOp AS 'Type of Operation',
OCRD.OwnerCode AS 'Document Owner',
OCRD.MandateID AS 'Mandate ID',
OCRD.SignDate AS 'Date of Signature',
OCRD.Remark1 AS 'Remark 1',
OCRD.ConCerti AS 'Concessional Certificate',
OCRD.TpCusPres AS 'Type of End-User Presence',
OCRD.RoleTypCod AS 'Role Type Code',
OCRD.BlockComm AS 'Block Sending Marketing',
OCRD.EmplymntCt AS 'Employment Category',
OCRD.ExcptnlEvt AS 'Exceptional Event',
OCRD.ExpnPrfFnd AS 'Professional Funds Expenses'
FROM OCRD AS OCRD Related informationBusiness Partners BusinessPartners Object· Table: OCRD BusinessPartners is a business object that represents the Business Partners Master Data in the Business Partners module.
This object enables you to:
Add a business partner record.
Retrieve a business partner record by its key.
Update a... Business Partners Service BusinessPartnersService Service· Table: OCRD The BusinessPartnersService enables to transfer credit or debit amounts from a specified opening balance account to one or more business partner accounts. This service creates a journal entry line.
Mandatory properties: OpenBalanceAccount... Business Partner OCRD SQL Table Agent Name OAGP SQL Table Countries OCRY SQL Table Bank Charges Allocation Codes OBCA SQL Table G/L Accounts OACT SQL Table Closing Date Procedure OCDP SQL Table Commission Groups OCOG SQL Table Campaign OCPN SQL Table Credit Cards OCRC SQL Table Currency Codes OCRN SQL Table Withholding Tax Deduction Groups ODDG SQL Table Bank Codes ODSC SQL Table Employees OHEM SQL Table Dunning Letters ODUN SQL Table Dunning Terms ODUT SQL Table Tax Definition OVTG SQL Table 1099 Forms OTNN SQL Table Card Groups OCRG SQL Table Payment Terms OCTG SQL Table Holiday Table OHLD SQL Table House Bank Accounts DSC1 SQL Table Indicator OIDC SQL Table Industries OOND SQL Table Withholding Tax OWHT SQL Table User Language Table OLNG SQL Table Price Lists OPLN SQL Table E-Tax Web Site OTWS SQL Table Object Settings - History ADP1 SQL Table BP Priorities OBPP SQL Table Project Codes OPRJ SQL Table Payment Block OPYB SQL Table Payment Methods for Payment Wizard OPYM SQL Table Remark 1 ORMK SQL Table Documents Numbering - Series NNM1 SQL Table Delivery Types OSHP SQL Table Sales Employee OSLP SQL Table States OCST SQL Table Territories OTER SQL Table Brazil Numeric Indexer OBNI SQL Table Users OUSR SQL Table Sales Tax Codes OSTC SQL Table Vendor Type OVTP SQL Table |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |