Business Partners - History

Table Name: ACRD

Table Description: Business Partners - History

Field	Description	Type	Size	Related	Default Value	Constraints
CardCode	BP Code	nVarChar	15	-
CardName	BP Name	nVarChar	200	-
CardType	BP Type	VarChar	1	-	C	C	Customer
						S	Vendor
						L	Lead
GroupCode	Group Code	Int	6	OCRG
CmpPrivate	Type of Business	VarChar	1	-	C	C	Company
						I	Private
						G	Government
						E	Employee
						S	Sole Taxable Subject
Address	Bill-to Street	nVarChar	100	-
ZipCode	Bill-to Zip Code	nVarChar	20	-
MailAddres	Ship-to Street	nVarChar	100	-
MailZipCod	Ship-to Zip Code	nVarChar	20	-
Phone1	Telephone 1	nVarChar	50	-
Phone2	Telephone 2	nVarChar	50	-
Fax	Fax Number	nVarChar	50	-
CntctPrsn	Contact Person	nVarChar	90	-
Notes	Remarks	nVarChar	100	-
Balance	Account Balance	Num	19.6	-
ChecksBal	Open Checks Balance in FC	Num	19.6	-
DNotesBal	Open Deliveries/GRPO Balance	Num	19.6	-
OrdersBal	Open Orders Balance	Num	19.6	-
GroupNum	Payment Terms Code	Int	6	OCTG	-1
CreditLine	Credit Limit	Num	19.6	-
DebtLine	Commitment Limit	Num	19.6	-
Discount	Discount %	Num	19.6	-
VatStatus	Tax Definition	VarChar	1	-	Y	Y	Liable
						N	Exempted
						E	EU
LicTradNum	Federal Tax ID	nVarChar	32	-
DdctStatus	Liable for Ded. at Source	VarChar	1	-	N	Y	Yes
						N	No
DdctPrcnt	% Withholding Tax Deduction	Num	19.6	-
ValidUntil	Expiration Date for -% of Deduction	Date	8	-
Chrctrstcs	Properties	Int	11	-
ExMatchNum	Last Ext. Reconciliation No.	Int	11	-
InMatchNum	Last Int. Reconciliation No.	Int	11	-
ListNum	Price List No.	Int	6	OPLN
DNoteBalFC	Open DN Balance (BP Currency)	Num	19.6	-
OrderBalFC	Open Orders Balance (BP Crcy)	Num	19.6	-
DNoteBalSy	Open Deliveries/GRPO Balance in SC	Num	19.6	-
OrderBalSy	Open Orders Balance in SC	Num	19.6	-
Transfered	Year Transfer	VarChar	1	-	N	Y	Yes
						N	No
BalTrnsfrd	Balances Transferred	VarChar	1	-	N	Y	Yes
						N	No
IntrstRate	Interest % on Liabilities	Num	19.6	-
Commission	Commission % for Customer	Num	19.6	-
CommGrCode	Commission Group	Int	6	OCOG	0
Free_Text	Free Text	Text	16	-
SlpCode	Sales Employee Code	Int	11	OSLP	-1
PrevYearAc	Previous Year Balance	VarChar	1	-	N	Y	Yes
						N	No
Currency	BP Currency	nVarChar	3	OCRN
RateDifAct	Rate Differences Account	nVarChar	15	OACT
BalanceSys	Account Balance in SC	Num	19.6	-
BalanceFC	BP Balance in FC	Num	19.6	-
Protected	Protected BP	VarChar	1	-	N	Y	Yes
						N	No
Cellular	Mobile Phone Number	nVarChar	50	-
AvrageLate	Average Payment Delay in Days	Int	6	-
City	Bill-to City	nVarChar	100	-
County	Bill-to County	nVarChar	100	-
Country	Bill-to Country/Region	nVarChar	3	-
MailCity	Ship-to City	nVarChar	100	-
MailCounty	Ship-to County	nVarChar	100	-
MailCountr	Ship-to Country/Region	nVarChar	3	-
E_Mail	E-Mail	nVarChar	100	-
Picture	Picture	nVarChar	200	-
DflAccount	Default Account	nVarChar	50	-
DflBranch	Default Branch	nVarChar	50	-
BankCode	Default Bank	nVarChar	30	-	-1
AddID	ID No. 2	nVarChar	64	-
Pager	Pager No.	nVarChar	30	-
FatherCard	Consolidating Business Partner	nVarChar	15	OCRD
CardFName	Foreign Name	nVarChar	200	-
FatherType	Parent Summary Type	VarChar	1	-	P	P	Payment Consolidation
						D	Delivery Consolidation
QryGroup1	Property 1	VarChar	1	-	N	Y	Yes
						N	No
QryGroup2	Property 2	VarChar	1	-	N	Y	Yes
						N	No
QryGroup3	Property 3	VarChar	1	-	N	Y	Yes
						N	No
QryGroup4	Property 4	VarChar	1	-	N	Y	Yes
						N	No
QryGroup5	Property 5	VarChar	1	-	N	Y	Yes
						N	No
QryGroup6	Property 6	VarChar	1	-	N	Y	Yes
						N	No
QryGroup7	Property 7	VarChar	1	-	N	Y	Yes
						N	No
QryGroup8	Property 8	VarChar	1	-	N	Y	Yes
						N	No
QryGroup9	Property 9	VarChar	1	-	N	Y	Yes
						N	No
QryGroup10	Property 10	VarChar	1	-	N	Y	Yes
						N	No
QryGroup11	Property 11	VarChar	1	-	N	Y	Yes
						N	No
QryGroup12	Property 12	VarChar	1	-	N	Y	Yes
						N	No
QryGroup13	Property 13	VarChar	1	-	N	Y	Yes
						N	No
QryGroup14	Property 14	VarChar	1	-	N	Y	Yes
						N	No
QryGroup15	Property 15	VarChar	1	-	N	Y	Yes
						N	No
QryGroup16	Property 16	VarChar	1	-	N	Y	Yes
						N	No
QryGroup17	Property 17	VarChar	1	-	N	Y	Yes
						N	No
QryGroup18	Property 18	VarChar	1	-	N	Y	Yes
						N	No
QryGroup19	Property 19	VarChar	1	-	N	Y	Yes
						N	No
QryGroup20	Property 20	VarChar	1	-	N	Y	Yes
						N	No
QryGroup21	Property 21	VarChar	1	-	N	Y	Yes
						N	No
QryGroup22	Property 22	VarChar	1	-	N	Y	Yes
						N	No
QryGroup23	Property 23	VarChar	1	-	N	Y	Yes
						N	No
QryGroup24	Property 24	VarChar	1	-	N	Y	Yes
						N	No
QryGroup25	Property 25	VarChar	1	-	N	Y	Yes
						N	No
QryGroup26	Property 26	VarChar	1	-	N	Y	Yes
						N	No
QryGroup27	Property 27	VarChar	1	-	N	Y	Yes
						N	No
QryGroup28	Property 28	VarChar	1	-	N	Y	Yes
						N	No
QryGroup29	Property 29	VarChar	1	-	N	Y	Yes
						N	No
QryGroup30	Property 30	VarChar	1	-	N	Y	Yes
						N	No
QryGroup31	Property 31	VarChar	1	-	N	Y	Yes
						N	No
QryGroup32	Property 32	VarChar	1	-	N	Y	Yes
						N	No
QryGroup33	Property 33	VarChar	1	-	N	Y	Yes
						N	No
QryGroup34	Property 34	VarChar	1	-	N	Y	Yes
						N	No
QryGroup35	Property 35	VarChar	1	-	N	Y	Yes
						N	No
QryGroup36	Property 36	VarChar	1	-	N	Y	Yes
						N	No
QryGroup37	Property 37	VarChar	1	-	N	Y	Yes
						N	No
QryGroup38	Property 38	VarChar	1	-	N	Y	Yes
						N	No
QryGroup39	Property 39	VarChar	1	-	N	Y	Yes
						N	No
QryGroup40	Property 40	VarChar	1	-	N	Y	Yes
						N	No
QryGroup41	Property 41	VarChar	1	-	N	Y	Yes
						N	No
QryGroup42	Property 42	VarChar	1	-	N	Y	Yes
						N	No
QryGroup43	Property 43	VarChar	1	-	N	Y	Yes
						N	No
QryGroup44	Property 44	VarChar	1	-	N	Y	Yes
						N	No
QryGroup45	Property 45	VarChar	1	-	N	Y	Yes
						N	No
QryGroup46	Property 46	VarChar	1	-	N	Y	Yes
						N	No
QryGroup47	Property 47	VarChar	1	-	N	Y	Yes
						N	No
QryGroup48	Property 48	VarChar	1	-	N	Y	Yes
						N	No
QryGroup49	Property 49	VarChar	1	-	N	Y	Yes
						N	No
QryGroup50	Property 50	VarChar	1	-	N	Y	Yes
						N	No
QryGroup51	Property 51	VarChar	1	-	N	Y	Yes
						N	No
QryGroup52	Property 52	VarChar	1	-	N	Y	Yes
						N	No
QryGroup53	Property 53	VarChar	1	-	N	Y	Yes
						N	No
QryGroup54	Property 54	VarChar	1	-	N	Y	Yes
						N	No
QryGroup55	Property 55	VarChar	1	-	N	Y	Yes
						N	No
QryGroup56	Property 56	VarChar	1	-	N	Y	Yes
						N	No
QryGroup57	Property 57	VarChar	1	-	N	Y	Yes
						N	No
QryGroup58	Property 58	VarChar	1	-	N	Y	Yes
						N	No
QryGroup59	Property 59	VarChar	1	-	N	Y	Yes
						N	No
QryGroup60	Property 60	VarChar	1	-	N	Y	Yes
						N	No
QryGroup61	Property 61	VarChar	1	-	N	Y	Yes
						N	No
QryGroup62	Property 62	VarChar	1	-	N	Y	Yes
						N	No
QryGroup63	Property 63	VarChar	1	-	N	Y	Yes
						N	No
QryGroup64	Property 64	VarChar	1	-	N	Y	Yes
						N	No
DdctOffice	Deduction Approval Office	nVarChar	10	-
CreateDate	Creation Date	Date	8	-
UpdateDate	Date of Update	Date	8	-
ExportCode	Data Export Code	nVarChar	8	-
DscntObjct	Subject for Discount	Int	6	-	-1	-1
						52	Groups
						8	Properties
						43	Companies
						4	Items
DscntRel	Discounts Ratio	VarChar	1	-	L	L	Lowest Discount
						H	Highest Discount
						A	Average Disc.
						S	Discount Totals
						M	Discount Multiples
SPGCounter	SPG Counter	Int	6	-
SPPCounter	SPP Counter	Int	11	-
DdctFileNo	Tax Deduction File No.	nVarChar	9	-
SCNCounter	SCN Counter	Int	6	-
MinIntrst	Min. Interest Letter Amount	Num	19.6	-
DataSource	Data Source	VarChar	1	-	N	N	Unknown
						I	Interface
						U	Update
						M	Import
						O	DI API
						S	Service Layer
						W	Web Client
						A	Doc. Generation Wizard
						D	Restore Wizard
						P	Partner Implementation
						T	Year Transfer
OprCount	Open Opportunities	Int	11	-
ExemptNo	Exempt No.	nVarChar	50	-
Priority	Priority	Int	11	OBPP	-1
CreditCard	Credit Cards	Int	6	OCRC	-1
CrCardNum	Credit Card No.	nVarChar	254	-
CardValid	Credit Card Validity	Date	8	-
UserSign	User Signature	Int	6	OUSR
LocMth	Reconciliation (LC)	VarChar	1	-	Y	Y	Yes
						N	No
validFor	Active	VarChar	1	-	N	Y	Yes
						N	No
validFrom	Active From	Date	8	-
validTo	Active To	Date	8	-
frozenFor	Inactive	VarChar	1	-	N	Y	Yes
						N	No
frozenFrom	Inactive From	Date	8	-
frozenTo	Inactive To	Date	8	-
sEmployed	Self-Employed	VarChar	1	-	N	Y	Yes
						N	No
MTHCounter	Match History Counter	Int	11	-
BNKCounter	BNK Counter	Int	11	-
DdgKey	WTax Deduction - Group	Int	11	ODDG	-1
DdtKey	Current Deduction Hierarchy	Int	11	-	-1
ValidComm	Active Remarks	nVarChar	30	-
FrozenComm	Inactive Remarks	nVarChar	30	-
chainStore	Belongs to Retail Store	VarChar	1	-	N	Y	Yes
						N	No
DiscInRet	Allow Doc Discount in Returns	VarChar	1	-	N	Y	Yes
						N	No
State1	Bill-to State	nVarChar	3	OCST
State2	Ship-to State	nVarChar	3	OCST
VatGroup	Tax Code	nVarChar	8	OSTC
LogInstanc	Log Instance	Int	11	-	0
ObjType	Object Type	nVarChar	20	ADP1	2
Indicator	Indicator	nVarChar	2	OIDC
ShipType	Shipping Type	Int	6	OSHP
DebPayAcct	Control Account	nVarChar	15	OACT
ShipToDef	Ship to - Default	nVarChar	50	-
Block	Block	nVarChar	100	-
MailBlock	Delivery Block	nVarChar	100	-
Password	Password	nVarChar	32	-
ECVatGroup	Tax Group	nVarChar	8	OVTG
Deleted	Deleted	VarChar	1	-	N	Y	Yes
						N	No
IBAN	IBAN	nVarChar	50	-
DocEntry	Numerator	Int	11	-
FormCode	1099 Form Code	Int	11	OTNN
Box1099	1099 Box	nVarChar	20	-
PymCode	Payment Method Code	nVarChar	15	OPYM	-1
BackOrder	Backorder	VarChar	1	-	Y	Y	Yes
						N	No
PartDelivr	Partial Delivery	VarChar	1	-	Y	Y	Yes
						N	No
DunnLevel	Dunning Level	Int	11	ODUN
DunnDate	Dunning Date	Date	8	-
BlockDunn	Block Dunning	VarChar	1	-	N	Y	Yes
						N	No
BankCountr	Bank Country	nVarChar	3	OCRY
CollecAuth	Collection Authorization	VarChar	1	-	N	N	No
						Y	Yes
DME	DME Identification	nVarChar	5	-
InstrucKey	Instruction Key	nVarChar	30	-
SinglePaym	Single Payment	VarChar	1	-	N	N	No
						Y	Yes
ISRBillId	ISR Biller ID	nVarChar	9	-
PaymBlock	Payment Block	VarChar	1	-	N	N	No
						Y	Yes
RefDetails	Reference Details	nVarChar	20	-
HouseBank	House Bank	nVarChar	30	-	-1
OwnerIdNum	ID Number	nVarChar	15	-
PyBlckDesc	Payment Block Description	Int	11	OPYB	-1
HousBnkCry	House Bank Country	nVarChar	3	-
HousBnkAct	House Bank Account	nVarChar	50	-
HousBnkBrn	House Bank Branch	nVarChar	50	-
ProjectCod	Project Code	nVarChar	20	OPRJ
SysMatchNo	Last Sys. Reconciliation No.	Int	11	-	-1
VatIdUnCmp	VAT ID for Unified Company	nVarChar	32	-
AgentCode	Agent Code	nVarChar	32	OAGP
TolrncDays	Tolerance Days	Int	6	-
SelfInvoic	Self Invoice	VarChar	1	-
DeferrTax	Deferred Tax	VarChar	1	-		Y	Yes
						N	No
LetterNum	Tax Exemption Letter No.	nVarChar	50	-
MaxAmount	Max. Exemption Amount	Num	19.6	-
FromDate	Exemption Validity Date From	Date	8	-
ToDate	Exemption Validity Date To	Date	8	-
WTLiable	Subject to Withholding Tax	VarChar	1	-		Y	Yes
						N	No
CrtfcateNO	Certificate Number	nVarChar	20	-
ExpireDate	Expiration Date	Date	8	-
NINum	Registration No.	nVarChar	20	-
AccCritria	Accrued Criteria	VarChar	1	-	N	Y	Yes
						N	No
WTCode	Withholding Tax Code	nVarChar	4	OWHT
Equ	Equalization Tax	VarChar	1	-	N	Y	Yes
						N	No
HldCode	Holiday Set Name	nVarChar	20	OHLD
ConnBP	Linked Business Partner	nVarChar	15	OCRD
MltMthNum	Last Multi. Reconciliation No.	Int	11	-
TypWTReprt	BP Type for WTax Report	VarChar	1	-	C	C	Company
						P	Person
VATRegNum	VAT Reg. Number	nVarChar	32	-
RepName	Representative Name	nVarChar	15	-
Industry	Industry	Text	16	-
Business	Business	Text	16	-
WTTaxCat	Withholding Tax Cat.	Text	16	-
IsDomestic	Is Domestic	VarChar	1	-	Y	Y	Domestic
						N	Foreign
IsResident	Is Resident	VarChar	1	-	Y	Y	Resident
						N	Non-Resident
AutoCalBCG	Auto Calculated Bank Charges	VarChar	1	-	N	N	No
						Y	Yes
OtrCtlAcct	Other Receivable/Payable	nVarChar	15	OACT
AliasName	Alias Name	Text	16	-
Building	Bill-to Building/Floor/Room	Text	16	-
MailBuildi	Ship to Building/Floor/Room	Text	16	-
BoEPrsnt	Customer BoE Presentation	nVarChar	15	OACT
BoEDiscnt	Customer BoE Discounted	nVarChar	15	OACT
BoEOnClct	Bill of Exchange on Collection	nVarChar	15	OACT
UnpaidBoE	Unpaid Bill of Exchange	nVarChar	15	OACT
ITWTCode	Income Tax WTax Code	nVarChar	4	OWHT
DunTerm	Dunning Term	nVarChar	25	ODUT
ChannlBP	Channel BP	nVarChar	15	OCRD
DfTcnician	Default Technician	Int	11	OHEM
Territory	Territory	Int	11	OTER
BillToDef	Bill-to Default	nVarChar	50	-
DpmClear	Payment Advances	nVarChar	15	OACT
IntrntSite	Web Site	nVarChar	100	-
LangCode	Language Code	Int	11	OLNG
HousActKey	House Bank Account Key	Int	11	DSC1
Profession	Profession	nVarChar	50	-
CDPNum	Closing Date Procedure No.	Int	6	OCDP
DflBankKey	Default Bank ID	Int	11	ODSC
BCACode	Bank Charges Allocation Codes	nVarChar	3	OBCA
UseShpdGd	Use Shipped Goods Account	VarChar	1	-	Y	Y	Yes
						N	No
RegNum	Company Reg. No. (CRN)	nVarChar	32	-
VerifNum	Verification No.	nVarChar	32	-
BankCtlKey	Default Bank Internal ID	nVarChar	2	-
HousCtlKey	House Bank Control Number	nVarChar	2	-
AddrType	Bill-to Address Type	nVarChar	100	-
InsurOp347	347 Insurance Operation	VarChar	1	-	N	N	No
						Y	Yes
MailAddrTy	Ship-to Address Type	nVarChar	100	-
StreetNo	Bill-to Street No.	nVarChar	100	-
MailStrNo	Ship-to Street No.	nVarChar	100	-
TaxRndRule	Tax Rounding Rule	VarChar	1	-	D	D	Company Default
						R	Round Off
						C	Round Up
						F	Round Down
VendTID	Vender Type ID	Int	11	OVTP
ThreshOver	Threshold Overlook	VarChar	1	-	N	Y	Yes
						N	No
SurOver	Surcharge Overlook	VarChar	1	-	N	Y	Yes
						N	No
VendorOcup	Vendor Occupation	nVarChar	15	-
OpCode347	347 Operation Code	VarChar	1	-		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
DpmIntAct	DPM Interim Account	nVarChar	15	OACT
ResidenNum	Residence Number	VarChar	1	-	1	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
UserSign2	Updating User	Int	6	OUSR
PlngGroup	Planning Group	nVarChar	10	-
VatIDNum	VAT ID Number	nVarChar	32	-
Affiliate	Affiliate	VarChar	1	-	N	Y	Yes
						N	No
MivzExpSts	Mivzak Export Status	VarChar	1	-	B	B	Not Exported
						U	Exported
						D	Deleted
HierchDdct	Hierarchical Deduction	VarChar	1	-	Y	Y	Yes
						N	No
CertWHT	Withholding Tax Certified	VarChar	1	-	N	Y	Yes
						N	No
CertBKeep	Bookkeeping Certified	VarChar	1	-	N	Y	Yes
						N	No
WHShaamGrp	Withholding Shaam Group	VarChar	1	-	1	1	Services and Agriculture Products
						2	Construction and Transportation
						3	Insurance Commissions
						4	Withholding Tax Instructions
						5	Interest Exchange Rate Differences
						6	Rental Fees
IndustryC	Industry	Int	11	OOND
DatevAcct	DATEV Account	nVarChar	9	-
DatevFirst	First Data Entry	VarChar	1	-	Y	Y	Yes
						N	No
GTSRegNum	GTS Registration Number	nVarChar	20	-
GTSBankAct	GTS Bank Account	nVarChar	80	-
GTSBilAddr	GTS Billing Address	nVarChar	80	-
HsBnkSwift	House Bank BIC/SWIFT Code	nVarChar	50	-
HsBnkIBAN	House Bank IBAN	nVarChar	50	-
DflSwift	Default Bank BIC/SWIFT Code	nVarChar	50	-
AutoPost	Automatic Posting	VarChar	1	-	N	N	No
						B	Interest and Fee
						I	Interest Only
						F	Fee Only
IntrAcc	Interest Account	nVarChar	15	-
FeeAcc	Fee Account	nVarChar	15	-
CpnNo	Campaign No.	Int	11	OCPN
NTSWebSite	E-Tax Web Site	Int	6	OTWS
DflIBAN	Default Bank IBAN	nVarChar	50	-
Series	Series	Int	11	NNM1
Number	Number	Int	11	-
EDocExpFrm	Electronic Doc. Export Format	Int	11	-
TaxIdIdent	Tax ID Category	VarChar	1	-	3	1	Self-Employed
						2	Company
						3	Registered Business
						5	International Company
Attachment	Attachment	Text	16	-
AtcEntry	Attachment Entry	Int	11	-
DiscRel	Disc. Relations	VarChar	1	-	L	L	Lowest Discount
						H	Highest Discount
						A	Average
						S	Total
						M	Discount Multiples
NoDiscount	No Discounts	VarChar	1	-	N	Y	Yes
						N	No
SCAdjust	SC Adjustment	VarChar	1	-	N	Y	Yes
						N	No
DflAgrmnt	Default Blanket Agreement No.	Int	11	OOAT
GlblLocNum	Global Location Number	nVarChar	50	-
SenderID	EDI Message Sender ID	nVarChar	50	-
RcpntID	EDI Message Recipient ID	nVarChar	50	-
MainUsage	Main Usage	Int	11	-
SefazCheck	Check BP Status on SEFAZ	VarChar	1	-	N	Y	Yes
						N	No
ChecksBalL	Open Checks Balance in LC	Num	19.6	-
ChecksBalS	Open Checks Balance in SC	Num	19.6	-
DateFrom	Relationship Initial Date	Date	8	-
DateTill	Relationship Final Date	Date	8	-
RelCode	Relationship Code	nVarChar	2	-
						01	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 norma espec�fica do �rg�o regulador, exceto as que se enquadrem nos tipos precedentes
						10	Vinculadas (Art. 23 da Lei 9.430/96), exceto as que se enquadrem nos tipos precedentes
						11	Localizada em pa�s com tributa��o favorecida (Art. 24 da Lei 9.430/96), exceto as que se enquadrem nos tipos precedentes
OKATO	OKATO	nVarChar	11	-
OKTMO	OKTMO	nVarChar	12	-
KBKCode	KBK Budget Classification Code	nVarChar	20	-
TypeOfOp	Type of Operation	VarChar	1	-		P	Professional Services
						R	Renting Assets
						O	Others
						D	Disposal of Goods
						S	Import of Goods and Services
						V	Import by Virtual Transfer
						G	Global Operations
OwnerCode	BP Owner	Int	11	OHEM
MandateID	Mandate ID	nVarChar	35	-
SignDate	Date of Signature	Date	8	-
Remark1	Remark 1	Int	11	ORMK
ConCerti	Concessional Certificate	nVarChar	20	-
TpCusPres	Type of End-User Presence	Int	11	OBNI	9
RoleTypCod	Role Type Code	nVarChar	2	-
BlockComm	Block Sending Marketing	VarChar	1	-	N	N	No
						Y	Yes
EmplymntCt	Employment Category	nVarChar	3	OETC
ExcptnlEvt	Exceptional Event	nVarChar	2	OEPE
ExpnPrfFnd	Professional Funds Expenses	Num	19.6	-
EdrsFromBP	Endorsable Checks from This BP	VarChar	1	-	Y	N	No
						Y	Yes
EdrsToBP	This BP Accepts Endorsed Checks	VarChar	1	-	N	N	No
						Y	Yes
CreateTS	Creatn Time - Incl. Secs	Int	11	-
UpdateTS	Update Full Time	Int	11	-
EDocGenTyp	Electr. Doc. Generation Type	VarChar	1	-		N	Not Relevant
						G	Generate
						L	Generate - Later
						S	Send
						R	Send - Later
eStreet	Street	nVarChar	38	-
eStreetNum	Street Number	nVarChar	4	-
eBuildnNum	Building Number	Int	11	-
eZipCode	Zip Code	nVarChar	10	-
eCityTown	City/Town/Village	nVarChar	48	-
eCountry	Country	nVarChar	3	OCRY
eDistrict	District	nVarChar	3	-
RepFName	Representative First Name	nVarChar	20	-
RepSName	Representative Surname	nVarChar	36	-
RepCmpName	Company Name	nVarChar	36	-
RepFisCode	Representative Fiscal Code	nVarChar	16	-
RepAddID	Representative Additional ID	nVarChar	28	-
PECAddr	PEC Address	nVarChar	254	-
IPACodePA	Receiver Code for Public Administration	nVarChar	32	-
PriceMode	Price Mode	VarChar	1	-		G	Gross
						N	Net
EffecPrice	Effective Price	VarChar	1	-	D	D	Default Priority
						L	Lowest Price
						H	Highest Price
TxExMxVdTp	Exemption Max validate type	VarChar	1	-	I	I	Individual Documents
						A	Accumulated Document Amount
MerchantID	Merchant ID	nVarChar	15	-
UseBilAddr	Determine GST by Using Bill to	VarChar	1	-	N	Y	Yes
						N	No
NaturalPer	Natural Person	VarChar	1	-	N	N	No
						Y	Yes
DPPStatus	Data Protection Status	VarChar	1	-	N	N	None
						D	Erased
						B	Blocked
						U	Unblocked
EnAddID	Encryption of ID No. 2	Text	16	-
EncryptIV	Encrypt IV	nVarChar	100	-
EnDflAccnt	Encryption of Default Account	Text	16	-
EnDflIBAN	Encryption of Default IBAN	Text	16	-
EnERD4In	Enable ERD for Incoming Payments	VarChar	1	-	Y	Y	Yes
						N	No
EnERD4Out	Enable ERD for Outgoing Payments	VarChar	1	-	Y	Y	Yes
						N	No
DflCustomr	Default Customer	VarChar	1	-	N	N	Not a default customer
						D	Default Customer
						P	Partially erased
						C	Default customer who has been partially erased
TspEntry	Default Transporter	Int	11	-
TspLine	Default Transportation Line	Int	11	-
FCERelevnt	FCE Relevant	VarChar	1	-	N	Y	Yes
						N	No
FCEVldte	FCE Validate Base Delivery	VarChar	1	-	N	Y	Yes
						N	No
AggregDoc	Aggregate Document	VarChar	1	-	N	Y	Yes
						N	No
EffcAllSrc	Considers All Price Sources	VarChar	1	-	N	Y	Yes
						N	No
EBVatExCau	VAT Exemption Cause	Int	11	OVEC
DataVers	Data Version	Int	11	-	1
LegalText	Legal Text	nVarChar	254	-
VatResDate	VAT Verfication Response Date	Date	8	-
VatResCode	VAT Verfication Response Code	Int	11	ORVC
EnIBAN	Encryption of IBAN	Text	16	-
DefaultCur	Default Currency	nVarChar	3	OCRN
VatResName	VAT Verfication Response Name	nVarChar	254	-
VatResAddr	VAT Verfication Response Addr	nVarChar	254	-
CertDetail	Certificate Details	nVarChar	100	-
EORINumber	EORI Number	nVarChar	17	-
FCEPmnMean	Use FCEs as Payment Means	VarChar	1	-	N	Y	Yes
						N	No
DefCommDDt	Defer Commitment Limit on Due Date	VarChar	1	-		E	Month End
						H	Half Month
						S	Month Start
DefCommMon	Defer Commitment Limit on Due Date - Months	Int	6	-
DefCommDay	Defer Commitment Limit on Due Date - Days	Int	6	-
ExLettDate	Exemption Letter Registration Date	Date	8	-
NotRel4MI	Not Relevant for Monthly Invoice	VarChar	1	-	N	Y	Yes
						N	No
EnHBnkAcct	Encryption of House Bank Account	Text	16	-
EnVatIDNum	Encrypt VAT ID Number	Text	16	-
EnLicTradN	Encrypt TAX ID Number	Text	16	-
SirenNo	SIREN No.	nVarChar	9	-
SiretNo	SIRET No.	nVarChar	32	-
VATEX	VAT Exemption Reason	nVarChar	32	-
RoutingCod	Routing Code	nVarChar	100	-
PubDirStat	Public Directory Status	nVarChar	2	-		AP	Active Private Entity
						AU	Active Public Entity
						IP	Inactive Private Entity
						IU	Inactive Public Entity
						NR	Not Registered

Key	Unique	Field
PRIMARY	Yes	CardCode
		LogInstanc
ABS_ENTRY	Yes	DocEntry
		LogInstanc