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