Business Partner Bank Accounts - History

Table Name: ACRB

Table Description: Business Partner Bank Accounts - History

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Key	Int	11	-
CardCode	BP Code	nVarChar	15	OCRD
BankCode	Bank Code	nVarChar	30	-
Country	Country/Region	nVarChar	3	OCRY
Account	Account No.	nVarChar	50	-
Branch	Branch	nVarChar	50	-
Street	Street	nVarChar	100	-
Block	Block	nVarChar	100	-
ZipCode	Zip Code	nVarChar	20	-
City	City	nVarChar	100	-
County	County	nVarChar	100	-
State	State	nVarChar	3	-
ControlKey	Control Key	nVarChar	2	-
UsrNumber1	User No. 1	nVarChar	25	-
UsrNumber2	User No. 2	nVarChar	25	-
UsrNumber3	User No. 3	nVarChar	25	-
UsrNumber4	User No. 4	nVarChar	25	-
IBAN	IBAN	nVarChar	50	-
LogInstanc	Log Instance	Int	11	-	0
Building	Building/Floor/Room	Text	16	-
AliasName	Alias Name	nVarChar	50	-
AcctType	Account Type	VarChar	1	-
BankKey	Bank Internal ID	Int	11	ODSC
BIK	BIK	nVarChar	15	-
AcctName	Bank Account Name	nVarChar	250	-
CorresAcct	Correspondent Account	nVarChar	30	-
Phone	Phone	nVarChar	50	-
Fax	Fax	nVarChar	50	-
ISRType	ISR Type	Int	6	-
ISRBillerI	ISR Biller ID	nVarChar	9	-
CustIdNum	Customer ID Number	nVarChar	6	-	0
AddrType	Address Type	nVarChar	100	-
StreetNo	Street No.	nVarChar	100	-
SwiftNum	BIC/SWIFT Code	nVarChar	50	-
ABARoutNum	ABA Routing Number	nVarChar	25	-
MandateID	Mandate ID	nVarChar	35	-
SignDate	Date of Signature	Date	8	-
PWZAbsEntr	PWZ ABS Entry	Int	11	OPWZ
BranchChk	Branch Check Digit	nVarChar	5	-
MandatDate	Date Of Mandate Expiration	Date	8	-
SeqType	SEPA Seq. Type	nVarChar	4	-		OOFF	OOFF
						FRST	FRST
						RCUR	RCUR
						FNAL	FNAL
ActType	Account Type	VarChar	1	-		C	Checking Account
						S	Savings Account
IsPrenot	Is Prenotification	VarChar	1	-	N	Y	Yes
						N	No
EnAccount	Encryption of Account	Text	16	-
EnIBAN	Encryption of IBAN	Text	16	-
EncryptIV	Encrypt IV	nVarChar	100	-

Key	Unique	Field
PRIMARY	Yes	AbsEntry
		LogInstanc
ACCOUNT	Yes	Country
		BankCode
		Account
		CardCode
		LogInstanc