📚 SAP Business One SDK Help

Table Name: OACP

Table Description: Periods Category

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 - 0    
PeriodCat Period Category nVarChar 10 -      
FinancYear Beginning of Financial Year Date 8 -      
Year Financial Year Int 6 -      
PeriodName Period Name nVarChar 20 -      
SubType Sub-Period Type VarChar 1 - Y Y Year
            Q Quarters
            M Months
            D Days
PeriodNum Number of Periods Int 11 -      
F_RefDate Posting Date From Date 8 -      
T_RefDate Posting Date To Date 8 -      
F_DueDate Due Date From Date 8 -      
T_DueDate Due Date To Date 8 -      
F_TaxDate Document Date From Date 8 -      
T_TaxDate Document Date To Date 8 -      
LogInstanc Log Instance Int 11 -      
UpdateDate Date of Update Date 8 -      
UserSign User Signature Int 6 OUSR      
LinkAct_1 Domestic Accounts Receivable nVarChar 15 OACT      
LinkAct_2 Checks Received nVarChar 15 OACT      
LinkAct_3 Cash on Hand nVarChar 15 OACT      
LinkAct_4 Account nVarChar 15 OACT      
LinkAct_5 Sales Tax Account nVarChar 15 OACT      
LinkAct_6 Customer's Deduction at Source nVarChar 15 OACT      
ComissAct Credit Card Deposit Fee nVarChar 15 OACT      
LinkAct_8 Purchase Tax nVarChar 15 OACT      
LinkAct_9 Foreign Accounts Receivable nVarChar 15 OACT      
LinkAct_10 Domestic Accounts Payable nVarChar 15 OACT      
LinkAct_11 Foreign Accounts Payable nVarChar 15 OACT      
LinkAct_12 Bank Transfer nVarChar 15 OACT      
LinkAct_13 Tax Payable nVarChar 15 OACT      
LinkAct_14 Tax Definition nVarChar 15 OACT      
LinkAct_15 Equipment and Assets nVarChar 15 OACT      
LinkAct_16 Withholding Tax nVarChar 15 OACT      
LinkAct_17 Advances on Corp. Income Tax nVarChar 15 OACT      
LinkAct_18 Opening Balance Account nVarChar 15 OACT      
DfltIncom Revenue Account nVarChar 15 OACT      
ExmptIncom Tax Exempt Revenue Account nVarChar 15 OACT      
DfltExpn Expense Account nVarChar 15 OACT      
ForgnIncm Revenue Account - Foreign nVarChar 15 OACT      
ECIncome Revenue Account - EU nVarChar 15 OACT      
ForgnExpn Expense Account - Foreign nVarChar 15 OACT      
DfltRateDi Ex. Rate Diff. in All Curr. BP nVarChar 15 OACT      
DecresGlAc G/L Decrease Account nVarChar 15 OACT      
LinkAct_27 Automatic Reconciliation Diff. nVarChar 15 OACT      
DftStockOB Acct. for Opening Whse Balance nVarChar 15 OACT      
LinkAct_19 Cash Discount nVarChar 15 OACT      
LinkAct_20 Cash Discount Clearing nVarChar 15 OACT      
LinkAct_21 Realized Exchange Diff. Loss nVarChar 15 OACT      
LinkAct_22 Cash Discount nVarChar 15 OACT      
LinkAct_23 Realized Exchange Diff. Loss nVarChar 15 OACT      
LinkAct_24 Rounding Account nVarChar 15 OACT      
LinkAct_25 Realized Exchange Diff. Gain nVarChar 15 OACT      
LinkAct_26 Realized Exchange Diff. Gain nVarChar 15 OACT      
IncresGlAc G/L Increase Account nVarChar 15 OACT      
RturnngAct Sales Returns Account nVarChar 15 OACT      
COGM_Act Cost of Goods Sold Account nVarChar 15 OACT      
AlocCstAct Allocation Account nVarChar 15 OACT      
VariancAct Variance Account nVarChar 15 OACT      
PricDifAct Price Difference Account nVarChar 15 OACT      
CDownPymnt Customer Down Payment Account nVarChar 15 OACT      
VDownPymnt Vendor Down Payments Account nVarChar 15 OACT      
CBoERcvble BoE Accounts Receivable nVarChar 15 OACT      
CBoEOnClct Bill of Exchange on Collection nVarChar 15 OACT      
CBoEPresnt Bill of Exchange Presentation nVarChar 15 OACT      
CBoEDiscnt Bill of Exchange Discounted nVarChar 15 OACT      
CUnpaidBoE Unpaid Bill of Exchange nVarChar 15 OACT      
VBoEPayble BoE Accounts Payable nVarChar 15 OACT      
VAsstBoEPy BoE Accounts Payable nVarChar 15 OACT      
COpenDebts Customer Doubtful Debts Acct nVarChar 15 OACT      
VOpenDebts Vendor Doubtful Debts Account nVarChar 15 OACT      
PurchseAct Purchase Account nVarChar 15 OACT      
PaReturnAc Purchase Return Account nVarChar 15 OACT      
PaOffsetAc Purchase Offset Account nVarChar 15 OACT      
LinkAct_28 Period-End Closing Account nVarChar 15 OACT      
ExDiffAct Exchange Rate Differences Account nVarChar 15 OACT      
BalanceAct Goods Clearing Account nVarChar 15 OACT      
BnkChgAct Bank Charges Account nVarChar 15 OACT      
LinkAct_29 Other Receivable nVarChar 15 OACT      
LinkAct_30 Other Payable nVarChar 15 OACT      
IncmAcct Default Inv Reval. Revenue nVarChar 15 OACT      
ExpnAcct Def. Inv. Reval. Revenue Acct nVarChar 15 OACT      
VatRevAct VAT in Revenue Account nVarChar 15 OACT      
ExpClrAct Expense Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offset Account nVarChar 15 OACT      
CostRevAct COGS Revaluation Acct nVarChar 15 OACT      
RepomoAct REPOMO Revaluation Account nVarChar 15 OACT      
WipVarAcct WIP Inventory Variance Account nVarChar 15 OACT      
SaleVatOff Down Payment Tax Offset Acct nVarChar 15 OACT      
PurcVatOff Down Payment Tax Offset Acct nVarChar 15 OACT      
DpmSalAct Payment Advances nVarChar 15 OACT      
DpmPurAct Payment Advances nVarChar 15 OACT      
ExpVarAct Expense and Inventory Account nVarChar 15 OACT      
CostOffAct COGS Revaluation Offset Acct nVarChar 15 OACT      
ECExepnses Expense Account - EU nVarChar 15 OACT      
StockAct Inventory Account nVarChar 15 OACT      
DflInPrcss Default for Stk Itm in Process nVarChar 15 OACT      
DfltInCstm Default for Stk Itm in Customs nVarChar 15 OACT      
DfltProfit Inventory Offset - Incr. Acct nVarChar 15 OACT      
DfltLoss Inventory Offset - Decr. Acct nVarChar 15 OACT      
VAssets Vendor Assets Account nVarChar 15 OACT      
StockRvAct Inventory Revaluation Account nVarChar 15 OACT      
StkRvOfAct Inventory Reval. Offset Acct nVarChar 15 OACT      
WipAcct WIP Inventory Account nVarChar 15 OACT      
DfltCard Invoice and Payment BP nVarChar 15 OCRD      
ShpdGdsAct Shipped Goods Account nVarChar 15 OACT      
GlRvOffAct G/L Revaluation Offset Account nVarChar 15 OACT      
OverpayAP Overpayment A/P Account nVarChar 15 OACT      
UndrpayAP Underpayment A/P Account nVarChar 15 OACT      
OverpayAR Overpayment A/R Account nVarChar 15 OACT      
UndrpayAR Underpayment A/R Account nVarChar 15 OACT      
ARCMAct Sales Credit Account nVarChar 15 OACT      
ARCMExpAct Tax Exempt Credit Account nVarChar 15 OACT      
ARCMFrnAct Sales Credit Account - Foreign nVarChar 15 OACT      
ARCMEUAct Sales Credit Account - EU nVarChar 15 OACT      
APCMAct Purchase Credit Account nVarChar 15 OACT      
APCMFrnAct Purchase Credit Acct - Foreign nVarChar 15 OACT      
APCMEUAct Purchase Credit Account - EU nVarChar 15 OACT      
NegStckAct Negative Inventory Adj. Acct nVarChar 15 OACT      
StkInTnAct Stock In Transit Account nVarChar 15 OACT      
GLGainXdif Realized Exchange Diff. Gain nVarChar 15 OACT      
GLLossXdif Realized Exchange Diff. Loss nVarChar 15 OACT      
AmountDiff Amount Differences nVarChar 15 OACT      
SlfInvIncm Self Invoice Revenue Account nVarChar 15 OACT      
SlfInvExpn Self Invoice Expense Account nVarChar 15 OACT      
OnHoldAct Capital Goods On Hold Account nVarChar 15 OACT      
PlaAct PLA nVarChar 15 OACT      
ICClrAct Incoming CENVAT Clearing Acct nVarChar 15 OACT      
OCClrAct Outgoing CENVAT Clearing Acct nVarChar 15 OACT      
PurBalAct Purchase Balance Account nVarChar 15 OACT      
WhICenAct Incoming CENVAT Account (WH) nVarChar 15 OACT      
WhOCenAct Outgoing CENVAT Account (WH) nVarChar 15 OACT      
SalDpmInt A/R DP Interim nVarChar 15 OACT      
PurDpmInt A/P DP Interim nVarChar 15 OACT      
ExrateOnDt Ex Rate on Def Tax Account nVarChar 15 OACT      
UserSign2 Updating User Int 6 OUSR      
EURecvAct EU Accounts Receivable nVarChar 15 OACT      
EUPayAct EU Accounts Payable nVarChar 15 OACT      
WipOffset WIP Offset P&L Account nVarChar 15 OACT      
StockOffst Inventory Offset P&L Account nVarChar 15 OACT      
DunIntrst Dunning Interest nVarChar 15 OACT      
DunFee Dunning Fee nVarChar 15 OACT      
SnapShotId Snapshot ID Int 11 - 0    
TDSInterst TDS Interest Acct nVarChar 15 OACT      
TDSCharges TDS Other Charges Acct nVarChar 15 OACT      
SrvTaxClr Service Tax Clearing Account nVarChar 15 OACT      
ARConDiffG Realized Conversion Diff. Gain nVarChar 15 OACT      
ARConDiffL Realized Conversion Diff. Loss nVarChar 15 OACT      
APConDiffG Realized Conversion Diff. Gain nVarChar 15 OACT      
APConDiffL Realized Conversion Diff. Loss nVarChar 15 OACT      
GLConDiffG Realized Conversion Diff. Gain nVarChar 15 OACT      
GLConDiffL Realized Conversion Diff. Loss nVarChar 15 OACT      
FreeChrgSA Free of Charge Sales Account nVarChar 15 -      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 -      
TDSFee TDS Fee Acct nVarChar 15 OACT      
ResRevenue Revenue Account nVarChar 15 OACT      
ResExpense Expense Account nVarChar 15 OACT      
ResSalesCr Sales Credit Account nVarChar 15 OACT      
ResPurchCr Purchase Credit Account nVarChar 15 OACT      
ResNotInv Res. Received Not Inv. Account nVarChar 15 OACT      
ResStdExp1 Std Cost Expense 1 nVarChar 15 OACT      
ResStdExp2 Std Cost Expense 2 nVarChar 15 OACT      
ResStdExp3 Std Cost Expense 3 nVarChar 15 OACT      
ResStdExp4 Std Cost Expense 4 nVarChar 15 OACT      
ResStdExp5 Std Cost Expense 5 nVarChar 15 OACT      
ResStdExp6 Std Cost Expense 6 nVarChar 15 OACT      
ResStdExp7 Std Cost Expense 7 nVarChar 15 OACT      
ResStdExp8 Std Cost Expense 8 nVarChar 15 OACT      
ResStdExp9 Std Cost Expense 9 nVarChar 15 OACT      
ResStdEx10 Std Cost Expense 10 nVarChar 15 OACT      
ResWipAct Resource WIP Account nVarChar 15 OACT      
ResScrapAc Scrap Account nVarChar 15 OACT      
WipOffPlAc WIP Offset P&L Account nVarChar 15 OACT      
ResOffPlAc Resource Offset P&L Account nVarChar 15 OACT      
ERDInARAct Exchange Rate Interim Sales Account nVarChar 15 OACT      
ERDInAPAct Exchange Rate Interim Purchase Account nVarChar 15 OACT      
CSDInARAct Cash Discount Interim Sales Account nVarChar 15 OACT      
CSDInAPAct Cash Discount Interim Purchase Account nVarChar 15 OACT      
GSTInAct GST Input Interim Account nVarChar 15 OACT      
GSTInterst GST Interest Account nVarChar 15 OACT      
GSTCharges GST Other Charges Account nVarChar 15 OACT      
GSTFee GST Fee Account nVarChar 15 OACT      
WTInARAct Interim Account for Tax nVarChar 15 OACT      
WTInAPAct Interim Account for Tax nVarChar 15 OACT      
WTExDifAct Withholding Tax Exchange Rate Diff. Account nVarChar 15 OACT      
Key Unique Field
PRIMARY Yes AbsEntry
CATEGORY Yes PeriodCat