biuan SAP® BUSINESS ONE SDK
API ARCT
ARCT - Incoming Payment - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
DocTypeDocument TypeVarChar
C) Customer
A) Account
S) Vendor
P) P.L.A
D) Yes
T) TDS
1
C
Canceled KEYCanceledVarChar
Y) No
N) Yes
1
NCANCELEDNo
Handwrtten KEYManual NumberingVarChar
Y) No
N) Copy
1
NHANDWRITENNo
PrintedPrintedVarChar
Y) Original
N) Yes
1
N
DocDatePosting DateDate
8
DocDueDateDue DateDate
8
CardCode KEYBP CodenVarChar
15
CARDNo
CardNameBP NamenVarChar
100
AddressAddressnVarChar
127
DdctPrcntDeduction %Num
20
DdctSumTotal DeductionsNum
20
DdctSumFCTotal Deductions (FC)Num
20
CashAcctCash AccountnVarChar
15OACT
G/L Accounts
CashSumCash AmountNum
20
CashSumFCCash Amount (FC)Num
20
CreditSumCredit AmountNum
20
CredSumFCCredit Amount (FC)Num
20
CheckAcctCash AccountnVarChar
15OACT
G/L Accounts
CheckSumCheck AmountNum
20
CheckSumFCCheck Amount (FC)Num
20
TrsfrAcctBank Transfer AccountnVarChar
15OACT
G/L Accounts
TrsfrSumBank Transfer AmountNum
20
TrsfrSumFCBank Transfer Amount (FC)Num
20
TrsfrDateBank Transfer DateDate
8
TrsfrRefIntended PurposenVarChar
27
PayNoDocNon-Calculated PaymentVarChar
Y) No
N) No
1
N
NoDocSumNon-Calculated AmountNum
20
NoDocSumFCNon-Calculated Amount (FC)Num
20
DocCurrDocument CurrencynVarChar
3OCRN
Currency Codes
DiffCurrEntered in LCVarChar
N) Yes
Y) Yes
1
N
DocRateDocument RateNum
20
SysRatePrice (SC)Num
20
DocTotalTotal DocumentNum
20
DocTotalFCTotal Document (FC)Num
20
Ref1Ref. 2nVarChar
8
Ref2Ref. 3nVarChar
8
CounterRefCounter ReferencenVarChar
8
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarknVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
DocTimeCreation TimeInt
6
ShowAtCardDisplay Customer Ref. No.VarChar
Y) No
N) Yes
1
N
SpiltTransSplit Journal EntryVarChar
Y) No
N) Yes
1
N
CreateTranCreate Journal EntryVarChar
Y) No
N) Yes
1
Y
FlagsFlagsInt
11
0
CntctCodeContact PersonInt
11OCPR
Contact Persons
DdctSumSyDeduction Amount (SC)Num
20
CashSumSyCash Amount in (SC)Num
20
CredSumSyCredit Amount (SC)Num
20
CheckSumSyCheck Amount (SC)Num
20
TrsfrSumSyBank Transfer Amount (SC)Num
20
NoDocSumSyNot Invoiced Amount (SC)Num
20
DocTotalSyTotal Document (SC)Num
20
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
StornoRateCancellation RateNum
20
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
ApplyVATTax DefinitionVarChar
Y) No
N) Yes
1
N
TaxDateDocument DateDate
8
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
SERIESNo
confirmedApprovedVarChar
Y) No
N) Yes
1
N
ShowJDTDisplay Journal EntriesVarChar
Y) No
N) Unknown
1
N
BankCodeBank Code for Bank TransfernVarChar
30
BankAcctAccount for Bank TransfernVarChar
50
DataSourceData SourceVarChar
N) Interface
I) Update
U) Import
M) DI API
O) Doc. Generation Wizard
A) Restore Wizard
D) Partner Implementation
P) Year Transfer
T) Yes
B) BSP
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatSumTax AmountNum
20
VatSumFCTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
FinncPriodPosting PeriodInt
11OFPR
Posting Period
VatPrcntTax %Num
20
DcountDiscountNum
20
DcntSumDiscount AmountNum
20
DcntSumFCDiscount Amount (FC)Num
20
DcntSumSyDiscount Amount (SC)Num
20
SpltCredLnSplit Credit VoucherVarChar
Y) No
N) Yes
1
N
PrjCodeProject CodenVarChar
20OPRJ
Project Codes
PaymentRefPayment Reference No.nVarChar
27
SubmittedSubmittedVarChar
Y) No
N) Yes
1
N
StatusCreated by Payment WizardVarChar
Y) No
N) BoE Canceled
C) Yes
1
N
PayMthPayment MethodnVarChar
15OPYM
Payment Methods for Payment Wizard
BankCountrBank CountrynVarChar
3OCRY
Countries
FreightSumFreight SumNum
20
FreigtFCFreight Sum (FC)Num
20
FreigtSCFreight Sum (SC)Num
20
BoeAccBoe AccountnVarChar
15OACT
G/L Accounts
BoeNumBill of Exchange No.Int
11
BoeSumBill of Exchange AmountNum
20
BoeSumFcBill of Exchange Amount (FC)Num
20
BoeSumScBill of Exchange Amount (SC)Num
20
BoeAgentBill of Exchange AgentnVarChar
32OAGP
Agent Name
BoeStatusBill of Exchange StatusVarChar
1
WtCodeWTax CodenVarChar
4OWHT
Withholding Tax
WtSumWTax AmountNum
20
WtSumFrgnWTax Amount (FC)Num
20
WtSumSysWTax Amount (FC)Num
20
WtAccountWTax AccountnVarChar
15OACT
G/L Accounts
WtBaseAmntWTax Taxable AmountNum
20
ProformaProformaVarChar
Y) No
N) No
1
N
BoeAbsBoe KeyInt
11OBOE
Bill of Exchange for Payment
BpActBP AccountnVarChar
15OACT
G/L Accounts
BcgSumBank Charges AmountNum
20
BcgSumFCBank Charges Amount (FC)Num
20
BcgSumSyBank Charges Amount (SC)Num
20
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
PaPriorityPayment PriorityVarChar
1)
2)
3)
4)
5)
6)
1
6
PayToCodePay tonVarChar
50
IsPaytoBnkIs Pay to BankVarChar
N) Yes
Y) No.
1
N
PBnkCntPay to Bank CountrynVarChar
3OCRY
Countries
PBnkCodePay to Bank CodenVarChar
30
PBnkAccntPay to Bank Account No.nVarChar
50
PBnkBranchPay to Bank BranchnVarChar
50
WizDunBlckWizard Dunning BlockVarChar
N) YES
Y) Yes
1
N
WtBaseSumWTax Base SumNum
20
WtBaseSumFWTax Base Sum (FC)Num
20
WtBaseSumSWTax Base Sum (SC)Num
20
UndOvDiffUnder/Overpayment DifferenceNum
20
UndOvDiffSUnder/Overpayment Diff. (SC)Num
20
BankActKeyBank Account Internal IDInt
11DSC1
House Bank Accounts
VersionNumVersion NumbernVarChar
11
VatDateTax DateDate
8
TransCodeTransaction CodenVarChar
4OTRC
Journal Entry Codes
PaymTypePayment TypeVarChar
N)
E) Mail
P) Telegraph
T) Express
X) Without
1
N
TfrRealAmtTransfer Real AmountNum
20
CancelDateCancelation DateDate
8
OpenBalOpen Balance AmountNum
20
OpenBalFcOpen Balance Amount (FC)Num
20
OpenBalScOpen Balance Amount (SC)Num
20
BcgTaxSumBank Charge Tax AmountNum
20
BcgTaxSumFBank Charge Tax Amount(FC)Num
20
BcgTaxSumSBank Charge Tax Amount(SC)Num
20
TpwIDTax Payment Wizard IDInt
11
0
ChallanNoChallan No.nVarChar
32
ChallanBakChallan Bank NamenVarChar
60
ChallanDatChallan Received DateDate
8
WddStatusAuthorization StatusVarChar
-) Pending
W) Approved
Y) Rejected
N) Generated
P) Generated by Authorizer
A) Canceled
C) Canceled
1
BcgVatGrpBank Charge Tax GroupnVarChar
8OVTG
Tax Definition
BcgVatPcntBank Charge Tax %Num
20
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
BSRCodeBSR CodenVarChar
25
LocCodeLocation CodeInt
11OLCT
Location
WTOnhldPstWTax On Hold, PostedNum
20
UserSign2Updating UserInt
6OUSR
Users
BuildDescBuild DescriptornVarChar
50
ResidenNumResidence NumberVarChar
1) Spanish Fiscal ID
2) VAT Registration Number
3) Passport
4) Fiscal ID Issued by the Residence Country
5) Certificate of Fiscal Residence
6) Other Document
1
1
OperatCodeOperation CodeVarChar
1
UndOvDiffFUnder/Overpayment Diff. (FC)Num
20
MIEntryMI Entry Include this PaymentInt
11
0
FreeText1Free Text 1nVarChar
100
FreeText2Free Text 2nVarChar
100
FreeText3Free Text 3nVarChar
100
ShowDocNoDisplay Document No.VarChar
Y) Yes
N) No
1
Y
TDSInterstTDS InterestNum
20
0
TDSChargesTDS Other ChargesNum
20
0
CUPUnique Code of ProjectInt
11OCUP
CUP Codes
CIGContract Code IdentificationInt
11OCIG
CIG Codes
MITypeMI Type Include this PaymentnVarChar
270) A/R Monthly Invoice
140000014) A/P Monthly Invoice
20
SupplCodeSupplementary CodenVarChar
127
BPLIdBranchInt
11OBPL
Business Place
BPLNameBranch NamenVarChar
100
VATRegNumVAT Reg. NumbernVarChar
32
BPLCentPmtCentralized PaymentVarChar
N) No
Y) Yes
1
N
DraftKeyPayment Draft Internal IDInt
11OPDF
Payment Draft
TDSFeeTDS FeeNum
20
MinHeadCLMinor Head of ChallanInt
200) TDS Payable by Taxpayer
400) TDS Regular Assessment (Raised by IT Dept)
11
SEPADateRequested SEPA Pmt DateDate
8

Table relationship map

SELECT statement

SELECT ARCT.DocEntry AS 'Internal Number', ARCT.DocNum AS 'Document Number', ARCT.DocType AS 'Document Type', ARCT.Canceled AS 'Canceled', ARCT.Handwrtten AS 'Manual Numbering', ARCT.Printed AS 'Printed', ARCT.DocDate AS 'Posting Date', ARCT.DocDueDate AS 'Due Date', ARCT.CardCode AS 'BP Code', ARCT.CardName AS 'BP Name', ARCT.Address AS 'Address', ARCT.DdctPrcnt AS 'Deduction %', ARCT.DdctSum AS 'Total Deductions', ARCT.DdctSumFC AS 'Total Deductions (FC)', ARCT.CashAcct AS 'Cash Account', ARCT.CashSum AS 'Cash Amount', ARCT.CashSumFC AS 'Cash Amount (FC)', ARCT.CreditSum AS 'Credit Amount', ARCT.CredSumFC AS 'Credit Amount (FC)', ARCT.CheckAcct AS 'Cash Account', ARCT.CheckSum AS 'Check Amount', ARCT.CheckSumFC AS 'Check Amount (FC)', ARCT.TrsfrAcct AS 'Bank Transfer Account', ARCT.TrsfrSum AS 'Bank Transfer Amount', ARCT.TrsfrSumFC AS 'Bank Transfer Amount (FC)', ARCT.TrsfrDate AS 'Bank Transfer Date', ARCT.TrsfrRef AS 'Intended Purpose', ARCT.PayNoDoc AS 'Non-Calculated Payment', ARCT.NoDocSum AS 'Non-Calculated Amount', ARCT.NoDocSumFC AS 'Non-Calculated Amount (FC)', ARCT.DocCurr AS 'Document Currency', ARCT.DiffCurr AS 'Entered in LC', ARCT.DocRate AS 'Document Rate', ARCT.SysRate AS 'Price (SC)', ARCT.DocTotal AS 'Total Document', ARCT.DocTotalFC AS 'Total Document (FC)', ARCT.Ref1 AS 'Ref. 2', ARCT.Ref2 AS 'Ref. 3', ARCT.CounterRef AS 'Counter Reference', ARCT.Comments AS 'Remarks', ARCT.JrnlMemo AS 'Journal Remark', ARCT.TransId AS 'Transaction Number', ARCT.DocTime AS 'Creation Time', ARCT.ShowAtCard AS 'Display Customer Ref. No.', ARCT.SpiltTrans AS 'Split Journal Entry', ARCT.CreateTran AS 'Create Journal Entry', ARCT.Flags AS 'Flags', ARCT.CntctCode AS 'Contact Person', ARCT.DdctSumSy AS 'Deduction Amount (SC)', ARCT.CashSumSy AS 'Cash Amount in (SC)', ARCT.CredSumSy AS 'Credit Amount (SC)', ARCT.CheckSumSy AS 'Check Amount (SC)', ARCT.TrsfrSumSy AS 'Bank Transfer Amount (SC)', ARCT.NoDocSumSy AS 'Not Invoiced Amount (SC)', ARCT.DocTotalSy AS 'Total Document (SC)', ARCT.ObjType AS 'Object Type', ARCT.StornoRate AS 'Cancellation Rate', ARCT.UpdateDate AS 'Date of Update', ARCT.CreateDate AS 'Creation Date', ARCT.ApplyVAT AS 'Tax Definition', ARCT.TaxDate AS 'Document Date', ARCT.Series AS 'Series', ARCT.confirmed AS 'Approved', ARCT.ShowJDT AS 'Display Journal Entries', ARCT.BankCode AS 'Bank Code for Bank Transfer', ARCT.BankAcct AS 'Account for Bank Transfer', ARCT.DataSource AS 'Data Source', ARCT.UserSign AS 'User Signature', ARCT.LogInstanc AS 'Log Instance', ARCT.VatGroup AS 'Tax Group', ARCT.VatSum AS 'Tax Amount', ARCT.VatSumFC AS 'Tax Amount (FC)', ARCT.VatSumSy AS 'Tax Amount (SC)', ARCT.FinncPriod AS 'Posting Period', ARCT.VatPrcnt AS 'Tax %', ARCT.Dcount AS 'Discount', ARCT.DcntSum AS 'Discount Amount', ARCT.DcntSumFC AS 'Discount Amount (FC)', ARCT.DcntSumSy AS 'Discount Amount (SC)', ARCT.SpltCredLn AS 'Split Credit Voucher', ARCT.PrjCode AS 'Project Code', ARCT.PaymentRef AS 'Payment Reference No.', ARCT.Submitted AS 'Submitted', ARCT.Status AS 'Created by Payment Wizard', ARCT.PayMth AS 'Payment Method', ARCT.BankCountr AS 'Bank Country', ARCT.FreightSum AS 'Freight Sum', ARCT.FreigtFC AS 'Freight Sum (FC)', ARCT.FreigtSC AS 'Freight Sum (SC)', ARCT.BoeAcc AS 'Boe Account', ARCT.BoeNum AS 'Bill of Exchange No.', ARCT.BoeSum AS 'Bill of Exchange Amount', ARCT.BoeSumFc AS 'Bill of Exchange Amount (FC)', ARCT.BoeSumSc AS 'Bill of Exchange Amount (SC)', ARCT.BoeAgent AS 'Bill of Exchange Agent', ARCT.BoeStatus AS 'Bill of Exchange Status', ARCT.WtCode AS 'WTax Code', ARCT.WtSum AS 'WTax Amount', ARCT.WtSumFrgn AS 'WTax Amount (FC)', ARCT.WtSumSys AS 'WTax Amount (FC)', ARCT.WtAccount AS 'WTax Account', ARCT.WtBaseAmnt AS 'WTax Taxable Amount', ARCT.Proforma AS 'Proforma', ARCT.BoeAbs AS 'Boe Key', ARCT.BpAct AS 'BP Account', ARCT.BcgSum AS 'Bank Charges Amount', ARCT.BcgSumFC AS 'Bank Charges Amount (FC)', ARCT.BcgSumSy AS 'Bank Charges Amount (SC)', ARCT.PIndicator AS 'Period Indicator', ARCT.PaPriority AS 'Payment Priority', ARCT.PayToCode AS 'Pay to', ARCT.IsPaytoBnk AS 'Is Pay to Bank', ARCT.PBnkCnt AS 'Pay to Bank Country', ARCT.PBnkCode AS 'Pay to Bank Code', ARCT.PBnkAccnt AS 'Pay to Bank Account No.', ARCT.PBnkBranch AS 'Pay to Bank Branch', ARCT.WizDunBlck AS 'Wizard Dunning Block', ARCT.WtBaseSum AS 'WTax Base Sum', ARCT.WtBaseSumF AS 'WTax Base Sum (FC)', ARCT.WtBaseSumS AS 'WTax Base Sum (SC)', ARCT.UndOvDiff AS 'Under/Overpayment Difference', ARCT.UndOvDiffS AS 'Under/Overpayment Diff. (SC)', ARCT.BankActKey AS 'Bank Account Internal ID', ARCT.VersionNum AS 'Version Number', ARCT.VatDate AS 'Tax Date', ARCT.TransCode AS 'Transaction Code', ARCT.PaymType AS 'Payment Type', ARCT.TfrRealAmt AS 'Transfer Real Amount', ARCT.CancelDate AS 'Cancelation Date', ARCT.OpenBal AS 'Open Balance Amount', ARCT.OpenBalFc AS 'Open Balance Amount (FC)', ARCT.OpenBalSc AS 'Open Balance Amount (SC)', ARCT.BcgTaxSum AS 'Bank Charge Tax Amount', ARCT.BcgTaxSumF AS 'Bank Charge Tax Amount(FC)', ARCT.BcgTaxSumS AS 'Bank Charge Tax Amount(SC)', ARCT.TpwID AS 'Tax Payment Wizard ID', ARCT.ChallanNo AS 'Challan No.', ARCT.ChallanBak AS 'Challan Bank Name', ARCT.ChallanDat AS 'Challan Received Date', ARCT.WddStatus AS 'Authorization Status', ARCT.BcgVatGrp AS 'Bank Charge Tax Group', ARCT.BcgVatPcnt AS 'Bank Charge Tax %', ARCT.SeqCode AS 'Sequence Code', ARCT.Serial AS 'Serial Number', ARCT.SeriesStr AS 'Series String', ARCT.SubStr AS 'Subseries String', ARCT.BSRCode AS 'BSR Code', ARCT.LocCode AS 'Location Code', ARCT.WTOnhldPst AS 'WTax On Hold, Posted', ARCT.UserSign2 AS 'Updating User', ARCT.BuildDesc AS 'Build Descriptor', ARCT.ResidenNum AS 'Residence Number', ARCT.OperatCode AS 'Operation Code', ARCT.UndOvDiffF AS 'Under/Overpayment Diff. (FC)', ARCT.MIEntry AS 'MI Entry Include this Payment', ARCT.FreeText1 AS 'Free Text 1', ARCT.FreeText2 AS 'Free Text 2', ARCT.FreeText3 AS 'Free Text 3', ARCT.ShowDocNo AS 'Display Document No.', ARCT.TDSInterst AS 'TDS Interest', ARCT.TDSCharges AS 'TDS Other Charges', ARCT.CUP AS 'Unique Code of Project', ARCT.CIG AS 'Contract Code Identification', ARCT.MIType AS 'MI Type Include this Payment', ARCT.SupplCode AS 'Supplementary Code', ARCT.BPLId AS 'Branch', ARCT.BPLName AS 'Branch Name', ARCT.VATRegNum AS 'VAT Reg. Number', ARCT.BPLCentPmt AS 'Centralized Payment', ARCT.DraftKey AS 'Payment Draft Internal ID', ARCT.TDSFee AS 'TDS Fee', ARCT.MinHeadCL AS 'Minor Head of Challan', ARCT.SEPADate AS 'Requested SEPA Pmt Date' FROM ARCT AS ARCT

Related information


House Bank Accounts DSC1 SQL Table

Countries OCRY SQL Table

Tax Definition OVTG SQL Table

Bill of Exchange for Payment OBOE SQL Table

G/L Accounts OACT SQL Table

Agent Name OAGP SQL Table

Business Place OBPL SQL Table

CIG Codes OCIG SQL Table

Contact Persons OCPR SQL Table

CUP Codes OCUP SQL Table

Currency Codes OCRN SQL Table

Payment Draft OPDF SQL Table

Posting Period OFPR SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Period Indicator OPID SQL Table

Project Codes OPRJ SQL Table

Documents Numbering - Series NNM1 SQL Table

Journal Entry Codes OTRC SQL Table

Journal Entry OJDT SQL Table

Users OUSR SQL Table

Withholding Tax OWHT 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