📚 SAP Business One SDK Help

Table Name: ARCT

Table Description: Incoming Payments - History

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
DocType Document Type VarChar 1 - C C Customer
            A Account
            S Vendor
            P P.L.A
            D Yes
            T TDS
Canceled Canceled VarChar 1 - N Y No
            N Yes
            C Cancellation
Handwrtten Manual Numbering VarChar 1 - N Y No
            N Copy
Printed Printed VarChar 1 - N Y Original
            N Yes
DocDate Posting Date Date 8 -      
DocDueDate Due Date Date 8 -      
CardCode BP Code nVarChar 15 OCRD      
CardName BP Name nVarChar 200 -      
Address Address nVarChar 254 -      
DdctPrcnt Deduction % Num 19.6 -      
DdctSum Total Deductions Num 19.6 -      
DdctSumFC Total Deductions (FC) Num 19.6 -      
CashAcct Cash Account nVarChar 15 OACT      
CashSum Cash Amount Num 19.6 -      
CashSumFC Cash Amount (FC) Num 19.6 -      
CreditSum Credit Amount Num 19.6 -      
CredSumFC Credit Amount (FC) Num 19.6 -      
CheckAcct Cash Account nVarChar 15 OACT      
CheckSum Check Amount Num 19.6 -      
CheckSumFC Check Amount (FC) Num 19.6 -      
TrsfrAcct Bank Transfer Account nVarChar 15 OACT      
TrsfrSum Bank Transfer Amount Num 19.6 -      
TrsfrSumFC Bank Transfer Amount (FC) Num 19.6 -      
TrsfrDate Bank Transfer Date Date 8 -      
TrsfrRef Intended Purpose nVarChar 27 -      
PayNoDoc Non-Calculated Payment VarChar 1 - N Y No
            N No
NoDocSum Non-Calculated Amount Num 19.6 -      
NoDocSumFC Non-Calculated Amount (FC) Num 19.6 -      
DocCurr Document Currency nVarChar 3 OCRN      
DiffCurr Entered in LC VarChar 1 - N N Yes
            Y Yes
DocRate Document Rate Num 19.6 -      
SysRate Price (SC) Num 19.6 -      
DocTotal Total Document Num 19.6 -      
DocTotalFC Total Document (FC) Num 19.6 -      
Ref1 Ref. 2 nVarChar 11 -      
Ref2 Ref. 3 nVarChar 50 -      
CounterRef Counter Reference nVarChar 50 -      
Comments Remarks nVarChar 254 -      
JrnlMemo Journal Remark nVarChar 254 -      
TransId Transaction Number Int 11 OJDT      
DocTime Creation Time Int 6 -      
ShowAtCard Display Customer Ref. No. VarChar 1 - N Y No
            N Yes
SpiltTrans Split Journal Entry VarChar 1 - N Y No
            N Yes
CreateTran Create Journal Entry VarChar 1 - Y Y No
            N Yes
Flags Flags Int 11 - 0    
CntctCode Contact Person Int 11 OCPR      
DdctSumSy Deduction Amount (SC) Num 19.6 -      
CashSumSy Cash Amount in (SC) Num 19.6 -      
CredSumSy Credit Amount (SC) Num 19.6 -      
CheckSumSy Check Amount (SC) Num 19.6 -      
TrsfrSumSy Bank Transfer Amount (SC) Num 19.6 -      
NoDocSumSy Not Invoiced Amount (SC) Num 19.6 -      
DocTotalSy Total Document (SC) Num 19.6 -      
ObjType Object Type nVarChar 20 ADP1      
StornoRate Cancellation Rate Num 19.6 -      
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
ApplyVAT Tax Definition VarChar 1 - N Y No
            N Yes
TaxDate Document Date Date 8 -      
Series Series Int 11 NNM1      
confirmed Approved VarChar 1 - N Y No
            N Yes
ShowJDT Display Journal Entries VarChar 1 - N Y No
            N Unknown
BankCode Bank Code for Bank Transfer nVarChar 30 -      
BankAcct Account for Bank Transfer nVarChar 50 -      
DataSource Data Source VarChar 1 - N N Interface
            I Update
            U Import
            M DI API
            S Service Layer
            W Web Client
            O Doc. Generation Wizard
            A Restore Wizard
            D Partner Implementation
            P Year Transfer
            T Yes
            B BSP
UserSign User Signature Int 6 OUSR      
LogInstanc Log Instance Int 11 - 0    
VatGroup Tax Group nVarChar 8 OVTG      
VatSum Tax Amount Num 19.6 -      
VatSumFC Tax Amount (FC) Num 19.6 -      
VatSumSy Tax Amount (SC) Num 19.6 -      
FinncPriod Posting Period Int 11 OFPR      
VatPrcnt Tax % Num 19.6 -      
Dcount Discount Num 19.6 -      
DcntSum Discount Amount Num 19.6 -      
DcntSumFC Discount Amount (FC) Num 19.6 -      
DcntSumSy Discount Amount (SC) Num 19.6 -      
SpltCredLn Split Credit Voucher VarChar 1 - N Y No
            N Yes
PrjCode Project Code nVarChar 20 OPRJ      
PaymentRef Payment Reference No. nVarChar 27 -      
Submitted Submitted VarChar 1 - N Y No
            N Yes
Status Created by Payment Wizard VarChar 1 - N Y No
            N BoE Canceled
            C Yes
PayMth Payment Method nVarChar 15 OPYM      
BankCountr Bank Country/Region nVarChar 3 OCRY      
FreightSum Freight Sum Num 19.6 -      
FreigtFC Freight Sum (FC) Num 19.6 -      
FreigtSC Freight Sum (SC) Num 19.6 -      
BoeAcc Boe Account nVarChar 15 OACT      
BoeNum Bill of Exchange No. Int 11 -      
BoeSum Bill of Exchange Amount Num 19.6 -      
BoeSumFc Bill of Exchange Amount (FC) Num 19.6 -      
BoeSumSc Bill of Exchange Amount (SC) Num 19.6 -      
BoeAgent Bill of Exchange Agent nVarChar 32 OAGP      
BoeStatus Bill of Exchange Status VarChar 1 -      
WtCode WTax Code nVarChar 4 OWHT      
WtSum WTax Amount Num 19.6 -      
WtSumFrgn WTax Amount (FC) Num 19.6 -      
WtSumSys WTax Amount (FC) Num 19.6 -      
WtAccount WTax Account nVarChar 15 OACT      
WtBaseAmnt WTax Taxable Amount Num 19.6 -      
Proforma Proforma VarChar 1 - N Y No
            N No
BoeAbs Boe Key Int 11 OBOE      
BpAct BP Account nVarChar 15 OACT      
BcgSum Bank Charges Amount Num 19.6 -      
BcgSumFC Bank Charges Amount (FC) Num 19.6 -      
BcgSumSy Bank Charges Amount (SC) Num 19.6 -      
PIndicator Period Indicator nVarChar 10 OPID ' '    
PaPriority Payment Priority VarChar 1 - 6 1  
            2  
            3  
            4  
            5  
            6  
PayToCode Pay To nVarChar 50 -      
IsPaytoBnk Is Pay to Bank VarChar 1 - N N Yes
            Y No.
PBnkCnt Pay to Bank Country/Region nVarChar 3 OCRY      
PBnkCode Pay to Bank Code nVarChar 30 -      
PBnkAccnt Pay to Bank Account No. nVarChar 50 -      
PBnkBranch Pay to Bank Branch nVarChar 50 -      
WizDunBlck Wizard Dunning Block VarChar 1 - N N YES
            Y Yes
WtBaseSum WTax Base Sum Num 19.6 -      
WtBaseSumF WTax Base Sum (FC) Num 19.6 -      
WtBaseSumS WTax Base Sum (SC) Num 19.6 -      
UndOvDiff Under/Overpayment Difference Num 19.6 -      
UndOvDiffS Under/Overpayment Diff. (SC) Num 19.6 -      
BankActKey Bank Account Internal ID Int 11 DSC1      
VersionNum Version Number nVarChar 13 -      
VatDate Tax Date Date 8 -      
TransCode Transaction Code nVarChar 4 OTRC      
PaymType Payment Type VarChar 1 - N N  
            E Mail
            P Telegraph
            T Express
            X Without
TfrRealAmt Transfer Real Amount Num 19.6 -      
CancelDate Cancelation Date Date 8 -      
OpenBal Open Balance Amount Num 19.6 -      
OpenBalFc Open Balance Amount (FC) Num 19.6 -      
OpenBalSc Open Balance Amount (SC) Num 19.6 -      
BcgTaxSum Bank Charge Tax Amount Num 19.6 -      
BcgTaxSumF Bank Charge Tax Amount(FC) Num 19.6 -      
BcgTaxSumS Bank Charge Tax Amount(SC) Num 19.6 -      
TpwID Tax Payment Wizard ID Int 11 - 0    
ChallanNo Challan No. nVarChar 32 -      
ChallanBak Challan Bank Name nVarChar 60 -      
ChallanDat Challan Received Date Date 8 -      
WddStatus Authorization Status VarChar 1 - - - Pending
            W Approved
            Y Rejected
            N Generated
            P Generated by Authorizer
            A Canceled
            C Canceled
BcgVatGrp Bank Charge Tax Group nVarChar 8 OVTG      
BcgVatPcnt Bank Charge Tax % Num 19.6 -      
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
BSRCode BSR Code nVarChar 25 -      
LocCode Location Code Int 11 OLCT      
WTOnhldPst WTax On Hold, Posted Num 19.6 -      
UserSign2 Updating User Int 6 OUSR      
BuildDesc Build Descriptor nVarChar 50 -      
ResidenNum Residence Number VarChar 1 - 1 1 Spanish Fiscal ID
            2 VAT Registration Number
            3 Passport
            4 Fiscal ID Issued by the Residence Country/Region
            5 Certificate of Fiscal Residence
            6 Other Document
OperatCode Operation Code VarChar 1 -      
            A Summary Invoices Entry
            B Summary Receipts Entry
            C Invoice with Several VAT Rates
            D Correction Invoice
            E Due VAT Pending Invoice Issuance
            F Expenses Incurred by Travel Agent for Customers
            G Special Regulation for VAT Group
            H Special Regulation for Gold Investment
            I Reverse Charge Procedure
            J Unsummarized Receipts
            K Identification of Error Transactions
            X Transactions with Entrepreneurs Issuing Receipts for Agricultural Compensation
            N Service Invoicing by Travel Agencies on Behalf of Third Parties
            R Business Office Rental
            S Subsidies
            T Incoming Payments for Industrial and Intellectual Property Rights
            U Insurance Transactions
            V Purchases from Travel Agencies
            W Transactions Subject to Production, Service and Import Taxes in Ceuta and Melilla
UndOvDiffF Under/Overpayment Diff. (FC) Num 19.6 -      
MIEntry MI Entry Include this Payment Int 11 - 0    
FreeText1 Free Text 1 nVarChar 254 -      
FreeText2 Free Text 2 nVarChar 254 -      
FreeText3 Free Text 3 nVarChar 254 -      
ShowDocNo Display Document No. VarChar 1 - Y Y Yes
            N No
TDSInterst TDS Interest Num 19.6 - 0    
TDSCharges TDS Other Charges Num 19.6 - 0    
CUP Unique Code of Project Int 11 OCUP      
CIG Contract Code Identification Int 11 OCIG      
MIType MI Type Include this Payment nVarChar 20 -   270 A/R Monthly Invoice
            140000014 A/P Monthly Invoice
SupplCode Supplementary Code nVarChar 254 -      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VATRegNum VAT Reg. Number nVarChar 32 -      
BPLCentPmt Centralized Payment VarChar 1 - N N No
            Y Yes
DraftKey Payment Draft Internal ID Int 11 OPDF      
TDSFee TDS Fee Num 19.6 -      
MinHeadCL Minor Head of Challan Int 11 -   200 TDS Payable by Taxpayer
            400 TDS Regular Assessment (Raised by IT Dept)
SEPADate Requested SEPA Pmt Date Date 8 -      
OwnerCode Payment Owner Int 11 OHEM      
AgrNo Agreement No. Int 11 OOAT      
CreateTS Create Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
TDSType TDS Type VarChar 1 -   E eTDS
            D GST TDS
            C GST TCS
DrNo Dr. No. nVarChar 32 -      
PmntWTCert Payment by WT Certificate Only VarChar 1 - N Y Yes
            N No
EnPBnkAcct Encryption of Pay to Bank Acct Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
PriceMode Price Mode VarChar 1 -   N Net
            G Gross
AtcEntry Attachment Entry Int 11 OATC      
Attachment Attachment Text 16 -      
EnblDpmTax Enable Tax Calculation in Down Payment Invoices VarChar 1 - N Y Yes
            N No
SignMsg Signature Input Message Text 16 -      
SignDigest Signature Digest Text 16 -      
CertifNum Certification Number nVarChar 50 -      
KeyVersion Private Key Version Int 11 -      
QRCodeSPGn QR Code Source Generated from Stored Procedure Text 16 -      
DataVers Data Version Int 11 - 1    
EDocExpFrm Electronic Doc. Export Format Int 11 -      
ElCoStatus Elec. Comm. Status nVarChar 10 -   0 Approved
            1 Pending Approval
            2 Rejected
ElCoMsg Elec. Comm. Message nVarChar 254 -      
DigPayment Digital Payments VarChar 1 - N Y Yes
            N No
AllocNum Allocation Number nVarChar 50 -      
BaseType Base Document Type Int 11 - -1 24 Incoming Payment
            46 Outgoing Payment
BaseEntry Base Document Internal ID Int 11 -      
Key Unique Field
PRIMARY Yes DocEntry
    LogInstanc
    ObjType
NUM Yes DocNum
    LogInstanc
    ObjType
    PIndicator
CARD No CardCode
HANDWRITEN No Handwrtten
CANCELED No Canceled
SERIES No Series