biuan SAP® BUSINESS ONE SDK
API SB Obob / Get Table List
ACRD - Business Partners - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CardCode KEY UNIQUEBP CodenVarChar
15
PRIMARYYes
CardNameBP NamenVarChar
100
CardTypeBP TypeVarChar
C) Customer
S) Vendor
L) Lead
1
C
GroupCodeGroup CodeInt
6OCRG
Card Groups
CmpPrivateCompany/Private/GovernmentVarChar
C) Company
I) Private
G) Government
1
C
AddressBill-to StreetnVarChar
100
ZipCodeBill-to Zip CodenVarChar
20
MailAddresShip-to StreetnVarChar
100
MailZipCodShip-to Zip CodenVarChar
20
Phone1Telephone 1nVarChar
20
Phone2Telephone 2nVarChar
20
FaxFax NumbernVarChar
20
CntctPrsnContact PersonnVarChar
90
NotesRemarksnVarChar
100
BalanceAccount BalanceNum
20
ChecksBalOpen Checks BalanceNum
20
DNotesBalOpen Del. Notes\GRPO BalanceNum
20
OrdersBalOpen Orders BalanceNum
20
GroupNumPayment Terms CodeInt
6OCTG
Payment Terms
-1
CreditLineCredit LimitNum
20
DebtLineCommitment LimitNum
20
DiscountDiscount %Num
20
VatStatusTax DefinitionVarChar
Y) Liable
N) Exempted
E) EU
1
Y
LicTradNumFederal Tax IDnVarChar
32
DdctStatusLiable for Ded. at SourceVarChar
Y) Yes
N) No
1
N
DdctPrcnt% Withholding Tax DeductionNum
20
ValidUntilExpiration Date for -% of DeductionDate
8
ChrctrstcsPropertiesInt
11
ExMatchNumLast Ext. Reconciliation No.Int
11
InMatchNumLast Int. Reconciliation No.Int
11
ListNumPrice List No.Int
6OPLN
Price Lists
DNoteBalFCOpen DN Balance (BP Currency)Num
20
OrderBalFCOpen Orders Balance (BP Crcy)Num
20
DNoteBalSyOpen DN Balance (SC)Num
20
OrderBalSyOpen Orders Balance (SC)Num
20
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
BalTrnsfrdBalances TransferredVarChar
Y) Yes
N) No
1
N
IntrstRateInterest % on LiabilitiesNum
20
CommissionCommission % for CustomerNum
20
CommGrCodeCommission GroupInt
6OCOG
Commission Groups
0
Free_TextFree TextText
16
SlpCodeSales Employee CodeInt
11OSLP
Sales Employee
-1
PrevYearAcPrevious Year BalanceVarChar
Y) Yes
N) No
1
N
CurrencyBP CurrencynVarChar
3OCRN
Currency Codes
RateDifActRate Differences AccountnVarChar
15OACT
G/L Accounts
BalanceSysBalance (Account Currency)Num
20
BalanceFCBP Balance in FCNum
20
ProtectedProtected BPVarChar
Y) Yes
N) No
1
N
CellularMobile Phone NumbernVarChar
50
AvrageLateAverage Payment Delay in DaysInt
6
CityBill-to CitynVarChar
100
CountyBill-to CountynVarChar
100
CountryBill-to CountrynVarChar
3
MailCityShip-to CitynVarChar
100
MailCountyShip-to CountynVarChar
100
MailCountrShip-to CountrynVarChar
3
E_MailE-MailnVarChar
100
PicturePicturenVarChar
127
DflAccountDefault AccountnVarChar
50
DflBranchDefault BranchnVarChar
50
BankCodeDefault BanknVarChar
30
-1
AddIDAdditional ID No.nVarChar
64
PagerPager No.nVarChar
30
FatherCardConsolidating BPnVarChar
15OCRD
Business Partner
CardFNameForeign NamenVarChar
100
FatherTypeParent Summary TypeVarChar
P) Payment Consolidation
D) Delivery Consolidation
1
P
QryGroup1Property 1VarChar
Y) Yes
N) No
1
N
QryGroup2Property 2VarChar
Y) Yes
N) No
1
N
QryGroup3Property 3VarChar
Y) Yes
N) No
1
N
QryGroup4Property 4VarChar
Y) Yes
N) No
1
N
QryGroup5Property 5VarChar
Y) Yes
N) No
1
N
QryGroup6Property 6VarChar
Y) Yes
N) No
1
N
QryGroup7Property 7VarChar
Y) Yes
N) No
1
N
QryGroup8Property 8VarChar
Y) Yes
N) No
1
N
QryGroup9Property 9VarChar
Y) Yes
N) No
1
N
QryGroup10Property 10VarChar
Y) Yes
N) No
1
N
QryGroup11Property 11VarChar
Y) Yes
N) No
1
N
QryGroup12Property 12VarChar
Y) Yes
N) No
1
N
QryGroup13Property 13VarChar
Y) Yes
N) No
1
N
QryGroup14Property 14VarChar
Y) Yes
N) No
1
N
QryGroup15Property 15VarChar
Y) Yes
N) No
1
N
QryGroup16Property 16VarChar
Y) Yes
N) No
1
N
QryGroup17Property 17VarChar
Y) Yes
N) No
1
N
QryGroup18Property 18VarChar
Y) Yes
N) No
1
N
QryGroup19Property 19VarChar
Y) Yes
N) No
1
N
QryGroup20Property 20VarChar
Y) Yes
N) No
1
N
QryGroup21Property 21VarChar
Y) Yes
N) No
1
N
QryGroup22Property 22VarChar
Y) Yes
N) No
1
N
QryGroup23Property 23VarChar
Y) Yes
N) No
1
N
QryGroup24Property 24VarChar
Y) Yes
N) No
1
N
QryGroup25Property 25VarChar
Y) Yes
N) No
1
N
QryGroup26Property 26VarChar
Y) Yes
N) No
1
N
QryGroup27Property 27VarChar
Y) Yes
N) No
1
N
QryGroup28Property 28VarChar
Y) Yes
N) No
1
N
QryGroup29Property 29VarChar
Y) Yes
N) No
1
N
QryGroup30Property 30VarChar
Y) Yes
N) No
1
N
QryGroup31Property 31VarChar
Y) Yes
N) No
1
N
QryGroup32Property 32VarChar
Y) Yes
N) No
1
N
QryGroup33Property 33VarChar
Y) Yes
N) No
1
N
QryGroup34Property 34VarChar
Y) Yes
N) No
1
N
QryGroup35Property 35VarChar
Y) Yes
N) No
1
N
QryGroup36Property 36VarChar
Y) Yes
N) No
1
N
QryGroup37Property 37VarChar
Y) Yes
N) No
1
N
QryGroup38Property 38VarChar
Y) Yes
N) No
1
N
QryGroup39Property 39VarChar
Y) Yes
N) No
1
N
QryGroup40Property 40VarChar
Y) Yes
N) No
1
N
QryGroup41Property 41VarChar
Y) Yes
N) No
1
N
QryGroup42Property 42VarChar
Y) Yes
N) No
1
N
QryGroup43Property 43VarChar
Y) Yes
N) No
1
N
QryGroup44Property 44VarChar
Y) Yes
N) No
1
N
QryGroup45Property 45VarChar
Y) Yes
N) No
1
N
QryGroup46Property 46VarChar
Y) Yes
N) No
1
N
QryGroup47Property 47VarChar
Y) Yes
N) No
1
N
QryGroup48Property 48VarChar
Y) Yes
N) No
1
N
QryGroup49Property 49VarChar
Y) Yes
N) No
1
N
QryGroup50Property 50VarChar
Y) Yes
N) No
1
N
QryGroup51Property 51VarChar
Y) Yes
N) No
1
N
QryGroup52Property 52VarChar
Y) Yes
N) No
1
N
QryGroup53Property 53VarChar
Y) Yes
N) No
1
N
QryGroup54Property 54VarChar
Y) Yes
N) No
1
N
QryGroup55Property 55VarChar
Y) Yes
N) No
1
N
QryGroup56Property 56VarChar
Y) Yes
N) No
1
N
QryGroup57Property 57VarChar
Y) Yes
N) No
1
N
QryGroup58Property 58VarChar
Y) Yes
N) No
1
N
QryGroup59Property 59VarChar
Y) Yes
N) No
1
N
QryGroup60Property 60VarChar
Y) Yes
N) No
1
N
QryGroup61Property 61VarChar
Y) Yes
N) No
1
N
QryGroup62Property 62VarChar
Y) Yes
N) No
1
N
QryGroup63Property 63VarChar
Y) Yes
N) No
1
N
QryGroup64Property 64VarChar
Y) Yes
N) No
1
N
DdctOfficeDeduction Approval OfficenVarChar
10
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
ExportCodeData Export CodenVarChar
8
DscntObjctSubject for DiscountInt
-1)
52) Groups
8) Properties
43) Companies
4) Items
6
-1
DscntRelDiscounts RatioVarChar
L) Lowest Discount
H) Highest Discount
A) Average Disc.
S) Discount Totals
M) Discount Multiples
1
L
SPGCounterSPG CounterInt
6
SPPCounterSPP CounterInt
11
DdctFileNoTax Deduction File No.nVarChar
9
SCNCounterSCN CounterInt
6
MinIntrstMin. Interest Letter AmountNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
OprCountOpen OpportunitiesInt
11
ExemptNoExempt No.nVarChar
50
PriorityPriorityInt
11OBPP
BP Priorities
-1
CreditCardCredit CardsInt
6OCRC
Credit Cards
-1
CrCardNumCredit Card No.nVarChar
64
CardValidCredit Card ValidityDate
8
UserSignUser SignatureInt
6OUSR
Users
LocMthReconciliation (LC)VarChar
Y) Yes
N) No
1
Y
validForActiveVarChar
Y) Yes
N) No
1
N
validFromActive FromDate
8
validToActive ToDate
8
frozenForInactiveVarChar
Y) Yes
N) No
1
N
frozenFromInactive FromDate
8
frozenToInactive ToDate
8
sEmployedSelf-EmployedVarChar
Y) Yes
N) No
1
N
MTHCounterMatch History CounterInt
11
BNKCounterBNK CounterInt
11
DdgKeyWTax Deduction - GroupInt
11ODDG
Withholding Tax Deduction Groups
-1
DdtKeyCurrent Deduction HierarchyInt
11
-1
ValidCommActive RemarksnVarChar
30
FrozenCommInactive RemarksnVarChar
30
chainStoreBelongs to Retail StoreVarChar
Y) Yes
N) No
1
N
DiscInRetAllow Doc Discount in ReturnsVarChar
Y) Yes
N) No
1
N
State1Bill-to StatenVarChar
3OCST
States
State2Ship-to StatenVarChar
3OCST
States
VatGroupTax CodenVarChar
8OSTC
Sales Tax Codes
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
2
IndicatorIndicatornVarChar
2OIDC
Indicator
ShipTypeShipping TypeInt
6OSHP
Delivery Types
DebPayAcctControl AccountnVarChar
15OACT
G/L Accounts
ShipToDefShip to - DefaultnVarChar
50
BlockBlocknVarChar
100
MailBlockDelivery BlocknVarChar
100
PasswordPasswordnVarChar
32
ECVatGroupTax GroupnVarChar
8OVTG
Tax Definition
DeletedDeletedVarChar
Y) Yes
N) No
1
N
IBANIBANnVarChar
50
DocEntry KEY UNIQUENumeratorInt
11
ABS_ENTRYYes
FormCode1099 Form CodeInt
11OTNN
1099 Forms
Box10991099 BoxnVarChar
20
PymCodePayment Method CodenVarChar
15OPYM
Payment Methods for Payment Wizard
-1
BackOrderBackorderVarChar
Y) Yes
N) No
1
Y
PartDelivrPartial DeliveryVarChar
Y) Yes
N) No
1
Y
DunnLevelDunning LevelInt
11ODUN
Dunning Letters
DunnDateDunning DateDate
8
BlockDunnBlock DunningVarChar
Y) Yes
N) No
1
N
BankCountrBank CountrynVarChar
3OCRY
Countries
CollecAuthCollection AuthorizationVarChar
N) No
Y) Yes
1
N
DMEDME IdentificationnVarChar
5
InstrucKeyInstruction KeynVarChar
30
SinglePaymSingle PaymentVarChar
N) No
Y) Yes
1
N
ISRBillIdISR Biller IDnVarChar
9
PaymBlockPayment BlockVarChar
N) No
Y) Yes
1
N
RefDetailsReference DetailsnVarChar
20
HouseBankHouse BanknVarChar
30
-1
OwnerIdNumID NumbernVarChar
15
PyBlckDescPayment Block DescriptionInt
11OPYB
Payment Block
-1
HousBnkCryHouse Bank CountrynVarChar
3
HousBnkActHouse Bank AccountnVarChar
50
HousBnkBrnHouse Bank BranchnVarChar
50
ProjectCodProject CodenVarChar
20OPRJ
Project Codes
SysMatchNoLast Sys. Reconciliation No.Int
11
-1
VatIdUnCmpVAT ID for Unified CompanynVarChar
32
AgentCodeAgent CodenVarChar
32OAGP
Agent Name
TolrncDaysTolerance DaysInt
6
SelfInvoicSelf InvoiceVarChar
1
DeferrTaxDeferred TaxVarChar
Y) Yes
N) No
1
LetterNumTax Exemption Letter No.nVarChar
20
MaxAmountMax. Exemption AmountNum
20
FromDateExemption Validity Date FromDate
8
ToDateExemption Validity Date ToDate
8
WTLiableSubject to Withholding TaxVarChar
Y) Yes
N) No
1
CrtfcateNOCertificate NumbernVarChar
20
ExpireDateExpiration DateDate
8
NINumRegistration No.nVarChar
20
AccCritriaAccrued CriteriaVarChar
Y) Yes
N) No
1
N
WTCodeWithholding Tax CodenVarChar
4OWHT
Withholding Tax
EquEqualization TaxVarChar
Y) Yes
N) No
1
N
HldCodeHoliday Set NamenVarChar
20OHLD
Holiday Table
ConnBPLinked Business PartnernVarChar
15OCRD
Business Partner
MltMthNumLast Multi. Reconciliation No.Int
11
TypWTReprtBP Type for WTax ReportVarChar
C) Company
P) Person
1
C
VATRegNumVAT Reg. NumbernVarChar
32
RepNameRepresentative NamenVarChar
15
IndustryIndustryText
16
BusinessBusinessText
16
WTTaxCatWithholding Tax Cat.Text
16
IsDomesticIs DomesticVarChar
Y) Domestic
N) Foreign
1
Y
IsResidentIs ResidentVarChar
Y) Resident
N) Non-Resident
1
Y
AutoCalBCGAuto Calculated Bank ChargesVarChar
N) No
Y) Yes
1
N
OtrCtlAcctOther Receivable/PayablenVarChar
15OACT
G/L Accounts
AliasNameAlias NameText
16
BuildingBill-to Building/Floor/RoomText
16
MailBuildiShip to Building/Floor/RoomText
16
BoEPrsntCustomer BoE PresentationnVarChar
15OACT
G/L Accounts
BoEDiscntCustomer BoE DiscountednVarChar
15OACT
G/L Accounts
BoEOnClctBill of Exchange on CollectionnVarChar
15OACT
G/L Accounts
UnpaidBoEUnpaid Bill of ExchangenVarChar
15OACT
G/L Accounts
ITWTCodeIncome Tax WTax CodenVarChar
4OWHT
Withholding Tax
DunTermDunning TermnVarChar
25ODUT
Dunning Terms
ChannlBPChannel BPnVarChar
15OCRD
Business Partner
DfTcnicianDefault TechnicianInt
11OHEM
Employees
TerritoryTerritoryInt
11OTER
Territories
BillToDefBill-to DefaultnVarChar
50
DpmClearPayment AdvancesnVarChar
15OACT
G/L Accounts
IntrntSiteWeb SitenVarChar
100
LangCodeLanguage CodeInt
11OLNG
User Language Table
HousActKeyHouse Bank Account KeyInt
11DSC1
House Bank Accounts
ProfessionProfessionnVarChar
50
CDPNumClosing Date Procedure No.Int
6OCDP
Closing Date Procedure
DflBankKeyDefault Bank IDInt
11ODSC
Bank Codes
BCACodeBank Charges Allocation CodesnVarChar
3OBCA
Bank Charges Allocation Codes
UseShpdGdUse Shipped Goods AccountVarChar
Y) Yes
N) No
1
Y
RegNumCompany Reg. No. (CRN)nVarChar
32
VerifNumVerification No.nVarChar
32
BankCtlKeyDefault Bank Internal IDnVarChar
2
HousCtlKeyHouse Bank Control NumbernVarChar
2
AddrTypeBill-to Address TypenVarChar
100
InsurOp347347 Insurance OperationVarChar
N) No
Y) Yes
1
N
MailAddrTyShip-to Address TypenVarChar
100
StreetNoBill-to Street No.nVarChar
100
MailStrNoShip-to Street No.nVarChar
100
TaxRndRuleTax Rounding RuleVarChar
D) Company Default
R) Round Off
C) Round Up
F) Round Down
1
D
VendTIDVender Type IDInt
11OVTP
Vendor Type
ThreshOverThreshold OverlookVarChar
Y) Yes
N) No
1
N
SurOverSurcharge OverlookVarChar
Y) Yes
N) No
1
N
VendorOcupVendor OccupationnVarChar
15
OpCode347347 Operation CodeVarChar
A) Goods or Services Acquisitions
D) Public Entities Acquisitions
G) Travel Agent Purchases
B) Sales or Services Revenues
E) Public Subsidies
F) Travel Agent Sales
1
A
DpmIntActDPM Interim AccountnVarChar
15OACT
G/L Accounts
ResidenNumResidence NumberVarChar
1) Spanish Fiscal ID
2) VAT Registration Number
3) Passport
4) Fiscal ID Issued by the Country of Residence
5) Certificate of Fiscal Residence
6) Other Document
1
1
UserSign2Updating UserInt
6OUSR
Users
PlngGroupPlanning GroupnVarChar
10
VatIDNumVAT ID NumbernVarChar
32
AffiliateAffiliateVarChar
Y) Yes
N) No
1
N
MivzExpStsMivzak Export StatusVarChar
B) Not Exported
U) Exported
D) Deleted
1
B
HierchDdctHierarchical DeductionVarChar
Y) Yes
N) No
1
Y
CertWHTWithholding Tax CertifiedVarChar
Y) Yes
N) No
1
N
CertBKeepBookkeeping CertifiedVarChar
Y) Yes
N) No
1
N
WHShaamGrpWithholding Shaam GroupVarChar
1) Services and Asset
2) Agricultural Products
3) Insurance Commissions
4) Withholding Tax Instructions
5) Interest Exchange Rate Differences
1
1
IndustryCIndustryInt
11OOND
Industries
DatevAcctDATEV AccountInt
11
DatevFirstFirst Data EntryVarChar
Y) Yes
N) No
1
Y
GTSRegNumGTS Registration NumbernVarChar
20
GTSBankActGTS Bank AccountnVarChar
80
GTSBilAddrGTS Billing AddressnVarChar
80
HsBnkSwiftHouse Bank BIC/SWIFT CodenVarChar
50
HsBnkIBANHouse Bank IBANnVarChar
50
DflSwiftDefault Bank BIC/SWIFT CodenVarChar
50
AutoPostAutomatic PostingVarChar
1
N
IntrAccInterest AccountnVarChar
15
FeeAccFee AccountnVarChar
15
CpnNoCampaign No.Int
11OCPN
Campaign
NTSWebSiteE-Tax Web SiteInt
6OTWS
E-Tax Web Site
DflIBANDefault Bank IBANnVarChar
50
SeriesSeriesInt
6NNM1
Documents Numbering - Series
NumberNumberInt
11
EDocExpFrmElectronic Doc. Export FormatInt
11
TaxIdIdentTax ID CategoryVarChar
1) Self-Employed
2) Company
3) Registered Business
5) International Company
1
3
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
DiscRelDisc. RelationsVarChar
L) Lowest Discount
H) Highest Discount
A) Average
S) Total
M) Discount Multiples
1
L
NoDiscountNo DiscountsVarChar
Y) Yes
N) No
1
N
SCAdjustSC AdjustmentVarChar
Y) Yes
N) No
1
N
DflAgrmntDefault Blanket Agreement No.Int
11OOAT
Blanket Agreement
GlblLocNumGlobal Location NumbernVarChar
50
SenderIDEDI Message Sender IDnVarChar
50
RcpntIDEDI Message Recipient IDnVarChar
50
MainUsageMain UsageInt
11
SefazCheckCheck BP Status on SEFAZVarChar
Y) Yes
N) No
1
N
free312Reply from SEFAZVarChar
1
free313Date of Update from SEFAZVarChar
1
DateFromRelationship Initial DateDate
8
DateTillRelationship Final DateDate
8
RelCodeRelationship CodenVarChar
2
OKATOOKATOnVarChar
11
OKTMOOKTMOnVarChar
12
KBKCodeKBK Budget Classification CodenVarChar
20
TypeOfOpType of OperationVarChar
P) Professional Services
R) Renting Assets
O) Others
1
OwnerCodeDocument OwnerInt
11OHEM
Employees
MandateIDMandate IDnVarChar
35
SignDateDate of SignatureDate
8
Remark1Remark 1Int
11ORMK
Remark 1
ConCertiConcessional CertificatenVarChar
20
TpCusPresType of End-User PresenceInt
11OBNI
Brazil Numeric Indexer
9
RoleTypCodRole Type CodenVarChar
2
BlockCommBlock Sending MarketingVarChar
N) No
Y) Yes
1
N
EmplymntCtEmployment CategorynVarChar
2
ExcptnlEvtExceptional EventVarChar
1
ExpnPrfFndProfessional Funds ExpensesNum
20

Table relationship map

SELECT statement

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

Related information


Get Table List GetTableList Method· Table: ORTT
Returns a Recordset object that contains a list of all the tables in the database. Each table includes its name and description (for example: OCRD, Business Partner.
   Parent: SB Obob SBObob Object
ACRD 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

Business Partner OCRD 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

Blanket Agreement OOAT 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates