SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Business Partners
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3ACRD3672Business Partners - HistoryBusiness Partners
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CardCode, CardName, CardType, GroupCode, CmpPrivate, Address, ZipCode, MailAddres, MailZipCod, Phone1, Phone2, Fax, CntctPrsn, Notes, Balance, ChecksBal, DNotesBal, OrdersBal, GroupNum, CreditLine, DebtLine, Discount, VatStatus, LicTradNum, DdctStatus, DdctPrcnt, ValidUntil, Chrctrstcs, ExMatchNum, InMatchNum, ListNum, DNoteBalFC, OrderBalFC, DNoteBalSy, OrderBalSy, Transfered, BalTrnsfrd, IntrstRate, Commission, CommGrCode, Free_Text, SlpCode, PrevYearAc, Currency, RateDifAct, BalanceSys, BalanceFC, Protected, Cellular, AvrageLate, City, County, Country, MailCity, MailCounty, MailCountr, E_Mail, Picture, DflAccount, DflBranch, BankCode, AddID, Pager, FatherCard, CardFName, FatherType, QryGroup1, QryGroup2, QryGroup3, QryGroup4, QryGroup5, QryGroup6, QryGroup7, QryGroup8, QryGroup9, QryGroup10, QryGroup11, QryGroup12, QryGroup13, QryGroup14, QryGroup15, QryGroup16, QryGroup17, QryGroup18, QryGroup19, QryGroup20, QryGroup21, QryGroup22, QryGroup23, QryGroup24, QryGroup25, QryGroup26, QryGroup27, QryGroup28, QryGroup29, QryGroup30, QryGroup31, QryGroup32, QryGroup33, QryGroup34, QryGroup35, QryGroup36, QryGroup37, QryGroup38, QryGroup39, QryGroup40, QryGroup41, QryGroup42, QryGroup43, QryGroup44, QryGroup45, QryGroup46, QryGroup47, QryGroup48, QryGroup49, QryGroup50, QryGroup51, QryGroup52, QryGroup53, QryGroup54, QryGroup55, QryGroup56, QryGroup57, QryGroup58, QryGroup59, QryGroup60, QryGroup61, QryGroup62, QryGroup63, QryGroup64, DdctOffice, CreateDate, UpdateDate, ExportCode, DscntObjct, DscntRel, SPGCounter, SPPCounter, DdctFileNo, SCNCounter, MinIntrst, DataSource, OprCount, ExemptNo, Priority, CreditCard, CrCardNum, CardValid, UserSign, LocMth, validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo, sEmployed, MTHCounter, BNKCounter, DdgKey, DdtKey, ValidComm, FrozenComm, chainStore, DiscInRet, State1, State2, VatGroup, LogInstanc, ObjType, Indicator, ShipType, DebPayAcct, ShipToDef, Block, MailBlock, Password, ECVatGroup, Deleted, IBAN, DocEntry, FormCode, Box1099, PymCode, BackOrder, PartDelivr, DunnLevel, DunnDate, BlockDunn, BankCountr, CollecAuth, DME, InstrucKey, SinglePaym, ISRBillId, PaymBlock, RefDetails, HouseBank, OwnerIdNum, PyBlckDesc, HousBnkCry, HousBnkAct, HousBnkBrn, ProjectCod, SysMatchNo, VatIdUnCmp, AgentCode, TolrncDays, SelfInvoic, DeferrTax, LetterNum, MaxAmount, FromDate, ToDate, WTLiable, CrtfcateNO, ExpireDate, NINum, AccCritria, WTCode, Equ, HldCode, ConnBP, MltMthNum, TypWTReprt, VATRegNum, RepName, Industry, Business, WTTaxCat, IsDomestic, IsResident, AutoCalBCG, OtrCtlAcct, AliasName, Building, MailBuildi, BoEPrsnt, BoEDiscnt, BoEOnClct, UnpaidBoE, ITWTCode, DunTerm, ChannlBP, DfTcnician, Territory, BillToDef, DpmClear, IntrntSite, LangCode, HousActKey, Profession, CDPNum, DflBankKey, BCACode, UseShpdGd, RegNum, VerifNum, BankCtlKey, HousCtlKey, AddrType, InsurOp347, MailAddrTy, StreetNo, MailStrNo, TaxRndRule, VendTID, ThreshOver, SurOver, VendorOcup, OpCode347, DpmIntAct, ResidenNum, UserSign2, PlngGroup, VatIDNum, Affiliate, MivzExpSts, HierchDdct, CertWHT, CertBKeep, WHShaamGrp, IndustryC, DatevAcct, DatevFirst, GTSRegNum, GTSBankAct, GTSBilAddr, HsBnkSwift, HsBnkIBAN, DflSwift, AutoPost, IntrAcc, FeeAcc, CpnNo, NTSWebSite, DflIBAN, Series, Number, EDocExpFrm, TaxIdIdent, Attachment, AtcEntry, DiscRel, NoDiscount, SCAdjust, DflAgrmnt, GlblLocNum, SenderID, RcpntID, MainUsage, SefazCheck, free312, free313, DateFrom, DateTill, RelCode, OKATO, OKTMO, KBKCode, TypeOfOp, OwnerCode, MandateID, SignDate, Remark1, ConCerti, TpCusPres, RoleTypCod, BlockComm, EmplymntCt, ExcptnlEvt, ExpnPrfFnd, EdrsFromBP, EdrsToBP, CreateTS, UpdateTS, EDocGenTyp, eStreet, eStreetNum, eBuildnNum, eZipCode, eCityTown, eCountry, eDistrict, RepFName, RepSName, RepCmpName, RepFisCode, RepAddID, PECAddr, IPACodePA, PriceMode, EffecPrice, TxExMxVdTp, MerchantID, UseBilAddr, NaturalPer, DPPStatus, EnAddID, EncryptIV, EnDflAccnt, EnDflIBAN, EnERD4In, EnERD4Out, DflCustomr, TspEntry, TspLine FROM ACRD

TOPB1 9.3  | ACRD COLUMNS

ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CardCodeBP Codenvarchar150 Allow NULL? 
2CardNameBP Namenvarchar1000 Allow NULL? 
3CardTypeBP Typechar10CC=Customer, L=Lead, S=Vendor Allow NULL? 
4GroupCodeGroup Codeint60OCRG Allow NULL? 
5CmpPrivateBusiness Partner Typechar10CC=Company, E=Employee, G=Government, I=Private Allow NULL? 
6AddressBill-to Streetnvarchar1000 Allow NULL? 
7ZipCodeBill-to Zip Codenvarchar200 Allow NULL? 
8MailAddresShip-to Streetnvarchar1000 Allow NULL? 
9MailZipCodShip-to Zip Codenvarchar200 Allow NULL? 
10Phone1Telephone 1nvarchar200 Allow NULL? 
11Phone2Telephone 2nvarchar200 Allow NULL? 
12FaxFax Numbernvarchar200 Allow NULL? 
13CntctPrsnContact Personnvarchar900 Allow NULL? 
14NotesRemarksnvarchar1000 Allow NULL? 
15BalanceAccount Balancenum196 Allow NULL? 
16ChecksBalOpen Checks Balancenum196 Allow NULL? 
17DNotesBalOpen Deliveries/GRPO Balancenum196 Allow NULL? 
18OrdersBalOpen Orders Balancenum196 Allow NULL? 
19GroupNumPayment Terms Codeint60OCTG-1 Allow NULL? 
20CreditLineCredit Limitnum196 Allow NULL? 
21DebtLineCommitment Limitnum196 Allow NULL? 
22DiscountDiscount %num196 Allow NULL? 
23VatStatusTax Definitionchar10YE=EU, N=Exempted, Y=Liable Allow NULL? 
24LicTradNumFederal Tax IDnvarchar320 Allow NULL? 
25DdctStatusLiable for Ded. at Sourcechar10NN=No, Y=Yes Allow NULL? 
26DdctPrcnt% Withholding Tax Deductionnum196 Allow NULL? 
27ValidUntilExpiration Date for -% of Deductiondate80
28ChrctrstcsPropertiesint110 Allow NULL? 
29ExMatchNumLast Ext. Reconciliation No.int110 Allow NULL? 
30InMatchNumLast Int. Reconciliation No.int110 Allow NULL? 
31ListNumPrice List No.int60OPLN Allow NULL? 
32DNoteBalFCOpen DN Balance (BP Currency)num196 Allow NULL? 
33OrderBalFCOpen Orders Balance (BP Crcy)num196 Allow NULL? 
34DNoteBalSyOpen Deliveries/GRPO Balance in SCnum196 Allow NULL? 
35OrderBalSyOpen Orders Balance in SCnum196 Allow NULL? 
36TransferedYear Transferchar10NN=No, Y=Yes Allow NULL? 
37BalTrnsfrdBalances Transferredchar10NN=No, Y=Yes Allow NULL? 
38IntrstRateInterest % on Liabilitiesnum196 Allow NULL? 
39CommissionCommission % for Customernum196 Allow NULL? 
40CommGrCodeCommission Groupint60OCOG0 Allow NULL? 
41Free_TextFree Texttext160
42SlpCodeSales Employee Codeint110OSLP-1 Allow NULL? 
43PrevYearAcPrevious Year Balancechar10NN=No, Y=Yes Allow NULL? 
44CurrencyBP Currencynvarchar30OCRN Allow NULL? 
45RateDifActRate Differences Accountnvarchar150OACT Allow NULL? 
46BalanceSysAccount Balance in SCnum196 Allow NULL? 
47BalanceFCBP Balance in FCnum196 Allow NULL? 
48ProtectedProtected BPchar10NN=No, Y=Yes Allow NULL? 
49CellularMobile Phone Numbernvarchar500 Allow NULL? 
50AvrageLateAverage Payment Delay in Daysint60 Allow NULL? 
51CityBill-to Citynvarchar1000 Allow NULL? 
52CountyBill-to Countynvarchar1000 Allow NULL? 
53CountryBill-to Countrynvarchar30 Allow NULL? 
54MailCityShip-to Citynvarchar1000 Allow NULL? 
55MailCountyShip-to Countynvarchar1000 Allow NULL? 
56MailCountrShip-to Countrynvarchar30 Allow NULL? 
57E_MailE-Mailnvarchar1000 Allow NULL? 
58PicturePicturenvarchar2000 Allow NULL? 
59DflAccountDefault Accountnvarchar500 Allow NULL? 
60DflBranchDefault Branchnvarchar500 Allow NULL? 
61BankCodeDefault Banknvarchar300-1 Allow NULL? 
62AddIDID No. 2nvarchar640 Allow NULL? 
63PagerPager No.nvarchar300 Allow NULL? 
64FatherCardConsolidating BPnvarchar150OCRD Allow NULL? 
65CardFNameForeign Namenvarchar1000 Allow NULL? 
66FatherTypeParent Summary Typechar10PD=Delivery Consolidation, P=Payment Consolidation Allow NULL? 
67QryGroup1Property 1char10NN=No, Y=Yes Allow NULL? 
68QryGroup2Property 2char10NN=No, Y=Yes Allow NULL? 
69QryGroup3Property 3char10NN=No, Y=Yes Allow NULL? 
70QryGroup4Property 4char10NN=No, Y=Yes Allow NULL? 
71QryGroup5Property 5char10NN=No, Y=Yes Allow NULL? 
72QryGroup6Property 6char10NN=No, Y=Yes Allow NULL? 
73QryGroup7Property 7char10NN=No, Y=Yes Allow NULL? 
74QryGroup8Property 8char10NN=No, Y=Yes Allow NULL? 
75QryGroup9Property 9char10NN=No, Y=Yes Allow NULL? 
76QryGroup10Property 10char10NN=No, Y=Yes Allow NULL? 
77QryGroup11Property 11char10NN=No, Y=Yes Allow NULL? 
78QryGroup12Property 12char10NN=No, Y=Yes Allow NULL? 
79QryGroup13Property 13char10NN=No, Y=Yes Allow NULL? 
80QryGroup14Property 14char10NN=No, Y=Yes Allow NULL? 
81QryGroup15Property 15char10NN=No, Y=Yes Allow NULL? 
82QryGroup16Property 16char10NN=No, Y=Yes Allow NULL? 
83QryGroup17Property 17char10NN=No, Y=Yes Allow NULL? 
84QryGroup18Property 18char10NN=No, Y=Yes Allow NULL? 
85QryGroup19Property 19char10NN=No, Y=Yes Allow NULL? 
86QryGroup20Property 20char10NN=No, Y=Yes Allow NULL? 
87QryGroup21Property 21char10NN=No, Y=Yes Allow NULL? 
88QryGroup22Property 22char10NN=No, Y=Yes Allow NULL? 
89QryGroup23Property 23char10NN=No, Y=Yes Allow NULL? 
90QryGroup24Property 24char10NN=No, Y=Yes Allow NULL? 
91QryGroup25Property 25char10NN=No, Y=Yes Allow NULL? 
92QryGroup26Property 26char10NN=No, Y=Yes Allow NULL? 
93QryGroup27Property 27char10NN=No, Y=Yes Allow NULL? 
94QryGroup28Property 28char10NN=No, Y=Yes Allow NULL? 
95QryGroup29Property 29char10NN=No, Y=Yes Allow NULL? 
96QryGroup30Property 30char10NN=No, Y=Yes Allow NULL? 
97QryGroup31Property 31char10NN=No, Y=Yes Allow NULL? 
98QryGroup32Property 32char10NN=No, Y=Yes Allow NULL? 
99QryGroup33Property 33char10NN=No, Y=Yes Allow NULL? 
100QryGroup34Property 34char10NN=No, Y=Yes Allow NULL? 
101QryGroup35Property 35char10NN=No, Y=Yes Allow NULL? 
102QryGroup36Property 36char10NN=No, Y=Yes Allow NULL? 
103QryGroup37Property 37char10NN=No, Y=Yes Allow NULL? 
104QryGroup38Property 38char10NN=No, Y=Yes Allow NULL? 
105QryGroup39Property 39char10NN=No, Y=Yes Allow NULL? 
106QryGroup40Property 40char10NN=No, Y=Yes Allow NULL? 
107QryGroup41Property 41char10NN=No, Y=Yes Allow NULL? 
108QryGroup42Property 42char10NN=No, Y=Yes Allow NULL? 
109QryGroup43Property 43char10NN=No, Y=Yes Allow NULL? 
110QryGroup44Property 44char10NN=No, Y=Yes Allow NULL? 
111QryGroup45Property 45char10NN=No, Y=Yes Allow NULL? 
112QryGroup46Property 46char10NN=No, Y=Yes Allow NULL? 
113QryGroup47Property 47char10NN=No, Y=Yes Allow NULL? 
114QryGroup48Property 48char10NN=No, Y=Yes Allow NULL? 
115QryGroup49Property 49char10NN=No, Y=Yes Allow NULL? 
116QryGroup50Property 50char10NN=No, Y=Yes Allow NULL? 
117QryGroup51Property 51char10NN=No, Y=Yes Allow NULL? 
118QryGroup52Property 52char10NN=No, Y=Yes Allow NULL? 
119QryGroup53Property 53char10NN=No, Y=Yes Allow NULL? 
120QryGroup54Property 54char10NN=No, Y=Yes Allow NULL? 
121QryGroup55Property 55char10NN=No, Y=Yes Allow NULL? 
122QryGroup56Property 56char10NN=No, Y=Yes Allow NULL? 
123QryGroup57Property 57char10NN=No, Y=Yes Allow NULL? 
124QryGroup58Property 58char10NN=No, Y=Yes Allow NULL? 
125QryGroup59Property 59char10NN=No, Y=Yes Allow NULL? 
126QryGroup60Property 60char10NN=No, Y=Yes Allow NULL? 
127QryGroup61Property 61char10NN=No, Y=Yes Allow NULL? 
128QryGroup62Property 62char10NN=No, Y=Yes Allow NULL? 
129QryGroup63Property 63char10NN=No, Y=Yes Allow NULL? 
130QryGroup64Property 64char10NN=No, Y=Yes Allow NULL? 
131DdctOfficeDeduction Approval Officenvarchar100 Allow NULL? 
132CreateDateCreation Datedate80
133UpdateDateDate of Updatedate80
134ExportCodeData Export Codenvarchar80 Allow NULL? 
135DscntObjctSubject for Discountint60-1-1, 43=Companies, 4=Items, 52=Groups, 8=Properties Allow NULL? 
136DscntRelDiscounts Ratiochar10LA=Average Disc., H=Highest Discount, L=Lowest Discount, M=Discount Multiples, S=Discount Totals Allow NULL? 
137SPGCounterSPG Counterint60 Allow NULL? 
138SPPCounterSPP Counterint110 Allow NULL? 
139DdctFileNoTax Deduction File No.nvarchar90 Allow NULL? 
140SCNCounterSCN Counterint60 Allow NULL? 
141MinIntrstMin. Interest Letter Amountnum196 Allow NULL? 
142DataSourceData Sourcechar10NA=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update Allow NULL? 
143OprCountOpen Opportunitiesint110 Allow NULL? 
144ExemptNoExempt No.nvarchar500 Allow NULL? 
145PriorityPriorityint110OBPP-1 Allow NULL? 
146CreditCardCredit Cardsint60OCRC-1 Allow NULL? 
147CrCardNumCredit Card No.nvarchar640 Allow NULL? 
148CardValidCredit Card Validitydate80
149UserSignUser Signatureint60OUSR Allow NULL? 
150LocMthReconciliation (LC)char10YN=No, Y=Yes Allow NULL? 
151validForActivechar10NN=No, Y=Yes Allow NULL? 
152validFromActive Fromdate80
153validToActive Todate80
154frozenForInactivechar10NN=No, Y=Yes Allow NULL? 
155frozenFromInactive Fromdate80
156frozenToInactive Todate80
157sEmployedSelf-Employedchar10NN=No, Y=Yes Allow NULL? 
158MTHCounterMatch History Counterint110 Allow NULL? 
159BNKCounterBNK Counterint110 Allow NULL? 
160DdgKeyWTax Deduction - Groupint110ODDG-1 Allow NULL? 
161DdtKeyCurrent Deduction Hierarchyint110-1 Allow NULL? 
162ValidCommActive Remarksnvarchar300 Allow NULL? 
163FrozenCommInactive Remarksnvarchar300 Allow NULL? 
164chainStoreBelongs to Retail Storechar10NN=No, Y=Yes Allow NULL? 
165DiscInRetAllow Doc Discount in Returnschar10NN=No, Y=Yes Allow NULL? 
166State1Bill-to Statenvarchar30OCST Allow NULL? 
167State2Ship-to Statenvarchar30OCST Allow NULL? 
168VatGroupTax Codenvarchar80OSTC Allow NULL? 
169LogInstancLog Instanceint1100 Allow NULL? 
170ObjTypeObject Typenvarchar200ADP12 Allow NULL? 
171IndicatorIndicatornvarchar20OIDC Allow NULL? 
172ShipTypeShipping Typeint60OSHP Allow NULL? 
173DebPayAcctControl Accountnvarchar150OACT Allow NULL? 
174ShipToDefShip to - Defaultnvarchar500 Allow NULL? 
175BlockBlocknvarchar1000 Allow NULL? 
176MailBlockDelivery Blocknvarchar1000 Allow NULL? 
177PasswordPasswordnvarchar320 Allow NULL? 
178ECVatGroupTax Groupnvarchar80OVTG Allow NULL? 
179DeletedDeletedchar10NN=No, Y=Yes Allow NULL? 
180IBANIBANnvarchar500 Allow NULL? 
181DocEntryNumeratorint110 Allow NULL? 
182FormCode1099 Form Codeint110OTNN Allow NULL? 
183Box10991099 Boxnvarchar200 Allow NULL? 
184PymCodePayment Method Codenvarchar150OPYM-1 Allow NULL? 
185BackOrderBackorderchar10YN=No, Y=Yes Allow NULL? 
186PartDelivrPartial Deliverychar10YN=No, Y=Yes Allow NULL? 
187DunnLevelDunning Levelint110ODUN Allow NULL? 
188DunnDateDunning Datedate80
189BlockDunnBlock Dunningchar10NN=No, Y=Yes Allow NULL? 
190BankCountrBank Countrynvarchar30OCRY Allow NULL? 
191CollecAuthCollection Authorizationchar10NN=No, Y=Yes Allow NULL? 
192DMEDME Identificationnvarchar50 Allow NULL? 
193InstrucKeyInstruction Keynvarchar300 Allow NULL? 
194SinglePaymSingle Paymentchar10NN=No, Y=Yes Allow NULL? 
195ISRBillIdISR Biller IDnvarchar90 Allow NULL? 
196PaymBlockPayment Blockchar10NN=No, Y=Yes Allow NULL? 
197RefDetailsReference Detailsnvarchar200 Allow NULL? 
198HouseBankHouse Banknvarchar300-1 Allow NULL? 
199OwnerIdNumID Numbernvarchar150 Allow NULL? 
200PyBlckDescPayment Block Descriptionint110OPYB-1 Allow NULL? 
201HousBnkCryHouse Bank Countrynvarchar30 Allow NULL? 
202HousBnkActHouse Bank Accountnvarchar500 Allow NULL? 
203HousBnkBrnHouse Bank Branchnvarchar500 Allow NULL? 
204ProjectCodProject Codenvarchar200OPRJ Allow NULL? 
205SysMatchNoLast Sys. Reconciliation No.int110-1 Allow NULL? 
206VatIdUnCmpVAT ID for Unified Companynvarchar320 Allow NULL? 
207AgentCodeAgent Codenvarchar320OAGP Allow NULL? 
208TolrncDaysTolerance Daysint60 Allow NULL? 
209SelfInvoicSelf Invoicechar10 Allow NULL? 
210DeferrTaxDeferred Taxchar10N=No, Y=Yes Allow NULL? 
211LetterNumTax Exemption Letter No.nvarchar200 Allow NULL? 
212MaxAmountMax. Exemption Amountnum196 Allow NULL? 
213FromDateExemption Validity Date Fromdate80
214ToDateExemption Validity Date Todate80
215WTLiableSubject to Withholding Taxchar10N=No, Y=Yes Allow NULL? 
216CrtfcateNOCertificate Numbernvarchar200 Allow NULL? 
217ExpireDateExpiration Datedate80
218NINumRegistration No.nvarchar200 Allow NULL? 
219AccCritriaAccrued Criteriachar10NN=No, Y=Yes Allow NULL? 
220WTCodeWithholding Tax Codenvarchar40OWHT Allow NULL? 
221EquEqualization Taxchar10NN=No, Y=Yes Allow NULL? 
222HldCodeHoliday Set Namenvarchar200OHLD Allow NULL? 
223ConnBPLinked Business Partnernvarchar150OCRD Allow NULL? 
224MltMthNumLast Multi. Reconciliation No.int110 Allow NULL? 
225TypWTReprtBP Type for WTax Reportchar10CC=Company, P=Person Allow NULL? 
226VATRegNumVAT Reg. Numbernvarchar320 Allow NULL? 
227RepNameRepresentative Namenvarchar150 Allow NULL? 
228IndustryIndustrytext160
229BusinessBusinesstext160
230WTTaxCatWithholding Tax Cat.text160
231IsDomesticIs Domesticchar10YN=Foreign, Y=Domestic Allow NULL? 
232IsResidentIs Residentchar10YN=Non-Resident, Y=Resident Allow NULL? 
233AutoCalBCGAuto Calculated Bank Chargeschar10NN=No, Y=Yes Allow NULL? 
234OtrCtlAcctOther Receivable/Payablenvarchar150OACT Allow NULL? 
235AliasNameAlias Nametext160
236BuildingBill-to Building/Floor/Roomtext160
237MailBuildiShip to Building/Floor/Roomtext160
238BoEPrsntCustomer BoE Presentationnvarchar150OACT Allow NULL? 
239BoEDiscntCustomer BoE Discountednvarchar150OACT Allow NULL? 
240BoEOnClctBill of Exchange on Collectionnvarchar150OACT Allow NULL? 
241UnpaidBoEUnpaid Bill of Exchangenvarchar150OACT Allow NULL? 
242ITWTCodeIncome Tax WTax Codenvarchar40OWHT Allow NULL? 
243DunTermDunning Termnvarchar250ODUT Allow NULL? 
244ChannlBPChannel BPnvarchar150OCRD Allow NULL? 
245DfTcnicianDefault Technicianint110OHEM Allow NULL? 
246TerritoryTerritoryint110OTER Allow NULL? 
247BillToDefBill-to Defaultnvarchar500 Allow NULL? 
248DpmClearPayment Advancesnvarchar150OACT Allow NULL? 
249IntrntSiteWeb Sitenvarchar1000 Allow NULL? 
250LangCodeLanguage Codeint110OLNG Allow NULL? 
251HousActKeyHouse Bank Account Keyint110DSC1 Allow NULL? 
252ProfessionProfessionnvarchar500 Allow NULL? 
253CDPNumClosing Date Procedure No.int60OCDP Allow NULL? 
254DflBankKeyDefault Bank IDint110ODSC Allow NULL? 
255BCACodeBank Charges Allocation Codesnvarchar30OBCA Allow NULL? 
256UseShpdGdUse Shipped Goods Accountchar10YN=No, Y=Yes Allow NULL? 
257RegNumCompany Reg. No. (CRN)nvarchar320 Allow NULL? 
258VerifNumVerification No.nvarchar320 Allow NULL? 
259BankCtlKeyDefault Bank Internal IDnvarchar20 Allow NULL? 
260HousCtlKeyHouse Bank Control Numbernvarchar20 Allow NULL? 
261AddrTypeBill-to Address Typenvarchar1000 Allow NULL? 
262InsurOp347347 Insurance Operationchar10NN=No, Y=Yes Allow NULL? 
263MailAddrTyShip-to Address Typenvarchar1000 Allow NULL? 
264StreetNoBill-to Street No.nvarchar1000 Allow NULL? 
265MailStrNoShip-to Street No.nvarchar1000 Allow NULL? 
266TaxRndRuleTax Rounding Rulechar10DC=Round Up, D=Company Default, F=Round Down, R=Round Off Allow NULL? 
267VendTIDVender Type IDint110OVTP Allow NULL? 
268ThreshOverThreshold Overlookchar10NN=No, Y=Yes Allow NULL? 
269SurOverSurcharge Overlookchar10NN=No, Y=Yes Allow NULL? 
270VendorOcupVendor Occupationnvarchar150 Allow NULL? 
271OpCode347347 Operation Codechar10A=Goods or Services Acquisitions, B=Sales or Services Revenues, D=Public Entities Acquisitions, E=Public Subsidies, F=Travel Agent Sales, G=Travel Agent Purchases Allow NULL? 
272DpmIntActDPM Interim Accountnvarchar150OACT Allow NULL? 
273ResidenNumResidence Numberchar1011=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 Allow NULL? 
274UserSign2Updating Userint60OUSR Allow NULL? 
275PlngGroupPlanning Groupnvarchar100 Allow NULL? 
276VatIDNumVAT ID Numbernvarchar320 Allow NULL? 
277AffiliateAffiliatechar10NN=No, Y=Yes Allow NULL? 
278MivzExpStsMivzak Export Statuschar10BB=Not Exported, D=Deleted, U=Exported Allow NULL? 
279HierchDdctHierarchical Deductionchar10YN=No, Y=Yes Allow NULL? 
280CertWHTWithholding Tax Certifiedchar10NN=No, Y=Yes Allow NULL? 
281CertBKeepBookkeeping Certifiedchar10NN=No, Y=Yes Allow NULL? 
282WHShaamGrpWithholding Shaam Groupchar1011=Services and Asset, 2=Agricultural Products, 3=Insurance Commissions, 4=Withholding Tax Instructions, 5=Interest Exchange Rate Differences Allow NULL? 
283IndustryCIndustryint110OOND Allow NULL? 
284DatevAcctDATEV Accountnvarchar90 Allow NULL? 
285DatevFirstFirst Data Entrychar10YN=No, Y=Yes Allow NULL? 
286GTSRegNumGTS Registration Numbernvarchar200 Allow NULL? 
287GTSBankActGTS Bank Accountnvarchar800 Allow NULL? 
288GTSBilAddrGTS Billing Addressnvarchar800 Allow NULL? 
289HsBnkSwiftHouse Bank BIC/SWIFT Codenvarchar500 Allow NULL? 
290HsBnkIBANHouse Bank IBANnvarchar500 Allow NULL? 
291DflSwiftDefault Bank BIC/SWIFT Codenvarchar500 Allow NULL? 
292AutoPostAutomatic Postingchar10NB=Interest and Fee, F=Fee Only, I=Interest Only, N=No Allow NULL? 
293IntrAccInterest Accountnvarchar150 Allow NULL? 
294FeeAccFee Accountnvarchar150 Allow NULL? 
295CpnNoCampaign No.int110OCPN Allow NULL? 
296NTSWebSiteE-Tax Web Siteint60OTWS Allow NULL? 
297DflIBANDefault Bank IBANnvarchar500 Allow NULL? 
298SeriesSeriesint110NNM1 Allow NULL? 
299NumberNumberint110 Allow NULL? 
300EDocExpFrmElectronic Doc. Export Formatint110 Allow NULL? 
301TaxIdIdentTax ID Categorychar1031=Self-Employed, 2=Company, 3=Registered Business, 5=International Company Allow NULL? 
302AttachmentAttachmenttext160
303AtcEntryAttachment Entryint110 Allow NULL? 
304DiscRelDisc. Relationschar10LA=Average, H=Highest Discount, L=Lowest Discount, M=Discount Multiples, S=Total Allow NULL? 
305NoDiscountNo Discountschar10NN=No, Y=Yes Allow NULL? 
306SCAdjustSC Adjustmentchar10NN=No, Y=Yes Allow NULL? 
307DflAgrmntDefault Blanket Agreement No.int110OOAT Allow NULL? 
308GlblLocNumGlobal Location Numbernvarchar500 Allow NULL? 
309SenderIDEDI Message Sender IDnvarchar500 Allow NULL? 
310RcpntIDEDI Message Recipient IDnvarchar500 Allow NULL? 
311MainUsageMain Usageint110 Allow NULL? 
312SefazCheckCheck BP Status on SEFAZchar10NN=No, Y=Yes Allow NULL? 
313free312Reply from SEFAZchar10 Allow NULL? 
314free313Date of Update from SEFAZchar10 Allow NULL? 
315DateFromRelationship Initial Datedate80
316DateTillRelationship Final Datedate80
317RelCodeRelationship Codenvarchar2001=Matriz no exterior, 02=Filial, inclusive agência ou dependência, no exterior, 03=Coligada, inclusive equiparada, 04=Controladora, 05=Controlada (exceto subsidiária integral), 06=Subsidiária integral, 07=Controlada em conjunto, 08=Entidade de Propósito Específico (conforme definição da CVM), 09=Participante do conglomerado, conforme norm Allow NULL? 
318OKATOOKATOnvarchar110 Allow NULL? 
319OKTMOOKTMOnvarchar120 Allow NULL? 
320KBKCodeKBK Budget Classification Codenvarchar200 Allow NULL? 
321TypeOfOpType of Operationchar10O=Others, P=Professional Services, R=Renting Assets Allow NULL? 
322OwnerCodeBP Ownerint110OHEM Allow NULL? 
323MandateIDMandate IDnvarchar350 Allow NULL? 
324SignDateDate of Signaturedate80
325Remark1Remark 1int110ORMK Allow NULL? 
326ConCertiConcessional Certificatenvarchar200 Allow NULL? 
327TpCusPresType of End-User Presenceint110OBNI9 Allow NULL? 
328RoleTypCodRole Type Codenvarchar20 Allow NULL? 
329BlockCommBlock Sending Marketingchar10NN=No, Y=Yes Allow NULL? 
330EmplymntCtEmployment Categorynvarchar20A=Retired, B=Retired belonging to "casellario", C=University Teacher, D=High School Teacher, E=Primary or Kindergarten Teacher, F=Graduates and Troops, G=Military Subofficer, H=Military Officer, K=Judge, L=Employees Abroad, M=Member of Cooperatives, N=Freelance Earning Amounts as Employee, P=Scholarships Beneficiary, Q=Minister, R=Doctor,  Allow NULL? 
331ExcptnlEvtExceptional Eventchar101=Vittime di richieste estorsive, 2=Soggetti colpiti dagli eventi sismici in data 24 agosto 2016, 3=Soggetti nel comune di Lampedusa e Linosa, emergenza umanitaria, 4=Soggetti colpiti dagli eventi sismici in ottobre 2016, 6=Altri eventi eccezionali Allow NULL? 
332ExpnPrfFndProfessional Funds Expensesnum196 Allow NULL? 
333EdrsFromBPEndorsable Checks from This BPchar10YN=No, Y=Yes Allow NULL? 
334EdrsToBPThis BP Accepts Endorsed Checkschar10NN=No, Y=Yes Allow NULL? 
335CreateTSCreatn Time - Incl. Secsint110 Allow NULL? 
336UpdateTSUpdate Full Timeint110 Allow NULL? 
337EDocGenTypElectr. Doc. Generation Typechar10G=Generate, L=Generate - Later, N=Not Relevant, R=Send - Later, S=Send Allow NULL? 
338eStreetStreetnvarchar380 Allow NULL? 
339eStreetNumStreet Numbernvarchar40 Allow NULL? 
340eBuildnNumBuilding Numberint110 Allow NULL? 
341eZipCodeZip Codenvarchar100 Allow NULL? 
342eCityTownCity/Town/Villagenvarchar480 Allow NULL? 
343eCountryCountrynvarchar30OCRY Allow NULL? 
344eDistrictDistrictnvarchar30 Allow NULL? 
345RepFNameRepresentative First Namenvarchar200 Allow NULL? 
346RepSNameRepresentative Surnamenvarchar360 Allow NULL? 
347RepCmpNameCompany Namenvarchar360 Allow NULL? 
348RepFisCodeRepresentative Fiscal Codenvarchar160 Allow NULL? 
349RepAddIDRepresentative Additional IDnvarchar280 Allow NULL? 
350PECAddrPEC Addressnvarchar2540 Allow NULL? 
351IPACodePAReceiver Code for Public Administrationnvarchar320 Allow NULL? 
352PriceModePrice Modechar10G=Gross, N=Net Allow NULL? 
353EffecPriceEffective Pricechar10DD=Default Priority, H=Highest Price, L=Lowest Price Allow NULL? 
354TxExMxVdTpExemption Max validate typechar10IA=Accumulated Document Amount, I=Individual Documents Allow NULL? 
355MerchantIDMerchant IDnvarchar150 Allow NULL? 
356UseBilAddrDetermine GST by Using Bill tochar10NN=No, Y=Yes Allow NULL? 
357NaturalPerNatural Personchar10NN=No, Y=Yes Allow NULL? 
358DPPStatusData Protection Statuschar10NB=Blocked, D=Erased, N=None, U=Unblocked Allow NULL? 
359EnAddIDEncryption of ID No. 2text160
360EncryptIVEncrypt IVnvarchar1000 Allow NULL? 
361EnDflAccntEncryption of Default Accounttext160
362EnDflIBANEncryption of Default IBANtext160
363EnERD4InEnable ERD for Incoming Paymentschar10YN=No, Y=Yes Allow NULL? 
364EnERD4OutEnable ERD for Outgoing Paymentschar10YN=No, Y=Yes Allow NULL? 
365DflCustomrDefault Customerchar10NC=Default customer who has been partially erased, D=Default customer, N=Not a default customer, P=Partially erased Allow NULL? 
366TspEntryDefault Transporterint110 Allow NULL? 
367TspLineDefault Transportation Lineint110 Allow NULL? 

TOPB1 9.3  | ACRD INDEXES

NamePrimaryUniqueTypeColumns
PRIMARYNoYesCardCode, LogInstanc
ABS_ENTRYNoYesDocEntry, LogInstanc