biuan SAP® BUSINESS ONE SDK
DTW Financials / Budget Setup / Budget Distribution
API OEOY
OEOY - End-of-Year Transfer Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GenrlDefsGeneral DefinitionsVarChar
Y)
N)
1
Y
ReFilesTransfer Template Designer FilesVarChar
Y)
N)
1
Y
ActIndexTransfer Accounts IndexVarChar
Y)
N)
1
Y
ActFromCodFrom CodenVarChar
15
ActToCodeTo CodenVarChar
15
ActGroupActGroupnVarChar
16
255
CrdIndexTransfer Credit Card IndexVarChar
Y)
N)
1
Y
CrdFromCodFrom CodenVarChar
15
CrdToCodeTo CodenVarChar
15
CrdGrpCustCustomer GroupInt
6
CrdGrpVndrVendor GroupInt
6
CrdToknAndCrdToknAndVarChar
1
CrdUseGrpsCrdUseGrpsVarChar
1
CrdClsRangCrdClsRangVarChar
1
CrdGrpDataPropertiesnVarChar
64
ItmIndexTransfer Item IndexVarChar
Y)
N)
1
Y
ItmFromCodFrom CodenVarChar
20
ItmToCodeTo CodenVarChar
20
ItmGroupItem GroupInt
6
ItmToknAndItmToknAndVarChar
1
ItmUseGrpsItmUseGrpsVarChar
1
ItmClsRangItmClsRangVarChar
1
ItmGrpDataPropertiesnVarChar
64
TransfDocDocuments TransferVarChar
Y)
N)
1
N
UnDpsChkTransfer Undeposited ChecksVarChar
Y)
N)
1
N
DpsChkTransfer Postdated ChecksVarChar
Y)
N)
1
N
UnDpsVouchTransfer Unpaid VouchersVarChar
Y)
N)
1
N
DpsVouchTransfer Deffered VouchersVarChar
Y)
N)
1
N
WorkOrderOpen Work InstructionsVarChar
Y)
N)
1
N
RcrTrtPosting Templates & Rec. TransVarChar
Y)
N)
1
N
ConnectionActivitiesVarChar
Y)
N)
1
N
SpcPriceSpecial PricesVarChar
Y)
N)
1
N
QuotationsTransfer Open Sales QuotationsVarChar
1
N
OrdersTransfer Open OrdersVarChar
Y)
N)
1
N
DlvrNotesTransfer Open Delivery NotesVarChar
Y)
N)
1
N
DlvrInvocsTransfer Open InvoicesVarChar
Y)
N)
1
N
P_OrdersTransfer Purchase OrdersVarChar
Y)
N)
1
N
P_InvoicesA/P InvoicesVarChar
Y)
N)
1
N
ProdTreeProduct TreeVarChar
Y)
N)
1
N
SubstCustomer/Vendor Catalog No.VarChar
Y)
N)
1
N
ImportLanded CostsVarChar
Y)
N)
1
N
RevertReturnsVarChar
Y)
N)
1
N
ActBlncTransfer Account BalancesVarChar
Y)
N)
1
N
ActRef1Ref. 1 for Opening Bal. Trans.nVarChar
11
ActRef2Ref. 2 for Opening Bal. Trans.nVarChar
11
ActRefDatePosting Date for OB TransactionsDate
8
ActDueDateDue date for OB transactionDate
8
ActMemoJournal Entry DetailsnVarChar
50
AOpnBlnActOpening Balances AccountnVarChar
15
AEquetyActRetained Earnings AccountnVarChar
15
ActExpLineTransfer Split BalancesVarChar
Y) Unreconciled Internally
N)
E) Unreconciled Externally
1
N
ActBlncFrCFrom CodenVarChar
15
ActBlncToCTo CodenVarChar
15
ActBlncGrpActBlncGrpnVarChar
16
YYY
ActZeroBlnAccount Transactions with Zero BalanceVarChar
Y)
N)
1
Y
CrdBlncTransfer Credit Card BalancesVarChar
Y)
N)
1
N
CrdRef1Ref. 1 for OB TransactionsnVarChar
11
CrdRef2Ref. 2 for OB TransactionsnVarChar
11
CrdRefDatePosting Date for OB TransactionsDate
8
CrdDueDateDue date for OB transactionDate
8
CrdMemoJournal Entry DetailsnVarChar
50
COpnBlnActOpening Balances AccountnVarChar
15
CrdExpLineTransfer Split BalancesVarChar
Y)
N)
1
N
CrdBlncFrCFrom CodenVarChar
15
CrdBlncToCTo CodenVarChar
15
CrdBlncGrCCustomer GroupInt
6
CrdBlnGrpVVendor GroupInt
6
CrdBTknAndCrdBTknAndVarChar
1
CrdBUseGrpCrdBUseGrpVarChar
1
CrdBClsRngCrdBClsRngVarChar
1
CrdBGrpDatPropertiesnVarChar
64
CrdZeroBlnCard Transactions with Zero BalanceVarChar
Y)
N)
1
Y
ItmBlncTransfer Item BalancesVarChar
Y)
N)
1
N
ItmRef1Ref. 1 for Opening Bal. Trans.nVarChar
11
ItmRef2Ref. 2 for Opening Bal. Trans.nVarChar
11
ItmRefDatePosting Date for OB TransactionDate
8
ItmMemoJournal Entry DetailsnVarChar
50
ItmBlncFrCFrom CodenVarChar
20
ItmBlncToCTo CodenVarChar
20
ItmBlncGrpItem GroupInt
6
ItmBTknAndItmBTknAndVarChar
1
ItmBUseGrpItmBUseGrpVarChar
1
ItmBClsRngItmBClsRngVarChar
1
ItmBGrpDatPropertiesnVarChar
64
ItmPlnNumTransaction Price ListInt
6
1
ItmZeroPrTransfer Items Without PriceVarChar
Y)
N)
1
N
FileReportCreate Report FileVarChar
Y)
N)
1
Y
CompName KEY UNIQUECompany Name for TransferingnVarChar
100
PRIMARYYes
WasGnrlDefWas general data transferredVarChar
Y)
N)
1
N
P_DlvrNotsTransfer PO Del. NotesVarChar
Y)
N)
1
N
SpgTransfer Discount for GroupsVarChar
Y)
N)
1
N
PdnPurchase Delivery NotesVarChar
Y)
N)
1
N
PdnClosedClosed Purchase Delivery NotesVarChar
Y)
N)
1
N
RpdRevert Purchase Delivery NotesVarChar
Y)
N)
1
N
ReportTempReport TemplatesVarChar
Y)
N)
1
N
ConfirmatConfirmationVarChar
Y)
N)
1
N
DocDraftDocument DraftsVarChar
Y)
N)
1
N
ChkOutDrftChecks for Payment DraftsVarChar
Y)
N)
1
N
OptOpenOpen OpportunitiesVarChar
Y)
N)
1
N
OptClosedClosed OpportunitiesVarChar
Y)
N)
1
N
SerBtchNumBatch/Serial No.VarChar
Y)
N)
1
N
CorrInvoicCorrection InvoiceVarChar
Y)
N)
1
N
UserGignUser SignatureInt
6OUSR
Users
PaymDrafPayment DraftVarChar
Y)
N)
1
N
PaymentWizSaved Payment WizardVarChar
N) No
Y) Yes
1
N
AltItemsAlternative ItemsVarChar
N) No
Y) Yes
1
N
DPIInvoiceA/R Down Payment InvoiceVarChar
1
N
DPIRequestA/R Down Payment RequestVarChar
Y) Yes
N) No
1
N
CtrService ContractsVarChar
Y) Yes
N) No
1
N
InsCustomer Equipment CardVarChar
Y) Yes
N) No
1
N
CorrAPInvA/P Correction InvoiceVarChar
Y) Yes
N) No
1
N
CorrAPRevA/P Correction Invoice ReversalVarChar
Y) Yes
N) No
1
N
CorrARInvA/R Correction InvoiceVarChar
Y) Yes
N) No
1
N
CorrARRevA/R Correction Invoice ReversalVarChar
Y) Yes
N) No
1
N
UserObjUser ObjectVarChar
N) No
Y) Yes
1
N
AdWrkOrdrAdvanced Work OrderVarChar
Y) Yes
N) No
1
N
DPOInvoiceA/P Down Payment InvoiceVarChar
Y) Yes
N) No
1
N
DPORequestA/P Down Payment RequestVarChar
Y) Yes
N) No
1
N
P_QuotatioTransfer Open Pur. QuotationsVarChar
Y) Yes
N) No
1
N
WTQInventory Transfer RequestsVarChar
Y) Yes
N) No
1
N
OatBlanket AgreementVarChar
Y) Yes
N) No
1
N
CPNCampaignVarChar
Y) Yes
N) No
1
N
AdvRulesTransfer Advanced RulesVarChar
Y) Yes
N) No
1
N
PrqPurchase RequestVarChar
1
N

SELECT statement

SELECT OEOY.GenrlDefs AS 'General Definitions', OEOY.ReFiles AS 'Transfer Template Designer Files', OEOY.ActIndex AS 'Transfer Accounts Index', OEOY.ActFromCod AS 'From Code', OEOY.ActToCode AS 'To Code', OEOY.ActGroup AS 'ActGroup', OEOY.CrdIndex AS 'Transfer Credit Card Index', OEOY.CrdFromCod AS 'From Code', OEOY.CrdToCode AS 'To Code', OEOY.CrdGrpCust AS 'Customer Group', OEOY.CrdGrpVndr AS 'Vendor Group', OEOY.CrdToknAnd AS 'CrdToknAnd', OEOY.CrdUseGrps AS 'CrdUseGrps', OEOY.CrdClsRang AS 'CrdClsRang', OEOY.CrdGrpData AS 'Properties', OEOY.ItmIndex AS 'Transfer Item Index', OEOY.ItmFromCod AS 'From Code', OEOY.ItmToCode AS 'To Code', OEOY.ItmGroup AS 'Item Group', OEOY.ItmToknAnd AS 'ItmToknAnd', OEOY.ItmUseGrps AS 'ItmUseGrps', OEOY.ItmClsRang AS 'ItmClsRang', OEOY.ItmGrpData AS 'Properties', OEOY.TransfDoc AS 'Documents Transfer', OEOY.UnDpsChk AS 'Transfer Undeposited Checks', OEOY.DpsChk AS 'Transfer Postdated Checks', OEOY.UnDpsVouch AS 'Transfer Unpaid Vouchers', OEOY.DpsVouch AS 'Transfer Deffered Vouchers', OEOY.WorkOrder AS 'Open Work Instructions', OEOY.RcrTrt AS 'Posting Templates & Rec. Trans', OEOY.Connection AS 'Activities', OEOY.SpcPrice AS 'Special Prices', OEOY.Quotations AS 'Transfer Open Sales Quotations', OEOY.Orders AS 'Transfer Open Orders', OEOY.DlvrNotes AS 'Transfer Open Delivery Notes', OEOY.DlvrInvocs AS 'Transfer Open Invoices', OEOY.P_Orders AS 'Transfer Purchase Orders', OEOY.P_Invoices AS 'A/P Invoices', OEOY.ProdTree AS 'Product Tree', OEOY.Subst AS 'Customer/Vendor Catalog No.', OEOY.Import AS 'Landed Costs', OEOY.Revert AS 'Returns', OEOY.ActBlnc AS 'Transfer Account Balances', OEOY.ActRef1 AS 'Ref. 1 for Opening Bal. Trans.', OEOY.ActRef2 AS 'Ref. 2 for Opening Bal. Trans.', OEOY.ActRefDate AS 'Posting Date for OB Transactions', OEOY.ActDueDate AS 'Due date for OB transaction', OEOY.ActMemo AS 'Journal Entry Details', OEOY.AOpnBlnAct AS 'Opening Balances Account', OEOY.AEquetyAct AS 'Retained Earnings Account', OEOY.ActExpLine AS 'Transfer Split Balances', OEOY.ActBlncFrC AS 'From Code', OEOY.ActBlncToC AS 'To Code', OEOY.ActBlncGrp AS 'ActBlncGrp', OEOY.ActZeroBln AS 'Account Transactions with Zero Balance', OEOY.CrdBlnc AS 'Transfer Credit Card Balances', OEOY.CrdRef1 AS 'Ref. 1 for OB Transactions', OEOY.CrdRef2 AS 'Ref. 2 for OB Transactions', OEOY.CrdRefDate AS 'Posting Date for OB Transactions', OEOY.CrdDueDate AS 'Due date for OB transaction', OEOY.CrdMemo AS 'Journal Entry Details', OEOY.COpnBlnAct AS 'Opening Balances Account', OEOY.CrdExpLine AS 'Transfer Split Balances', OEOY.CrdBlncFrC AS 'From Code', OEOY.CrdBlncToC AS 'To Code', OEOY.CrdBlncGrC AS 'Customer Group', OEOY.CrdBlnGrpV AS 'Vendor Group', OEOY.CrdBTknAnd AS 'CrdBTknAnd', OEOY.CrdBUseGrp AS 'CrdBUseGrp', OEOY.CrdBClsRng AS 'CrdBClsRng', OEOY.CrdBGrpDat AS 'Properties', OEOY.CrdZeroBln AS 'Card Transactions with Zero Balance', OEOY.ItmBlnc AS 'Transfer Item Balances', OEOY.ItmRef1 AS 'Ref. 1 for Opening Bal. Trans.', OEOY.ItmRef2 AS 'Ref. 2 for Opening Bal. Trans.', OEOY.ItmRefDate AS 'Posting Date for OB Transaction', OEOY.ItmMemo AS 'Journal Entry Details', OEOY.ItmBlncFrC AS 'From Code', OEOY.ItmBlncToC AS 'To Code', OEOY.ItmBlncGrp AS 'Item Group', OEOY.ItmBTknAnd AS 'ItmBTknAnd', OEOY.ItmBUseGrp AS 'ItmBUseGrp', OEOY.ItmBClsRng AS 'ItmBClsRng', OEOY.ItmBGrpDat AS 'Properties', OEOY.ItmPlnNum AS 'Transaction Price List', OEOY.ItmZeroPr AS 'Transfer Items Without Price', OEOY.FileReport AS 'Create Report File', OEOY.CompName AS 'Company Name for Transfering', OEOY.WasGnrlDef AS 'Was general data transferred', OEOY.P_DlvrNots AS 'Transfer PO Del. Notes', OEOY.Spg AS 'Transfer Discount for Groups', OEOY.Pdn AS 'Purchase Delivery Notes', OEOY.PdnClosed AS 'Closed Purchase Delivery Notes', OEOY.Rpd AS 'Revert Purchase Delivery Notes', OEOY.ReportTemp AS 'Report Templates', OEOY.Confirmat AS 'Confirmation', OEOY.DocDraft AS 'Document Drafts', OEOY.ChkOutDrft AS 'Checks for Payment Drafts', OEOY.OptOpen AS 'Open Opportunities', OEOY.OptClosed AS 'Closed Opportunities', OEOY.SerBtchNum AS 'Batch/Serial No.', OEOY.CorrInvoic AS 'Correction Invoice', OEOY.UserGign AS 'User Signature', OEOY.PaymDraf AS 'Payment Draft', OEOY.PaymentWiz AS 'Saved Payment Wizard', OEOY.AltItems AS 'Alternative Items', OEOY.DPIInvoice AS 'A/R Down Payment Invoice', OEOY.DPIRequest AS 'A/R Down Payment Request', OEOY.Ctr AS 'Service Contracts', OEOY.Ins AS 'Customer Equipment Card', OEOY.CorrAPInv AS 'A/P Correction Invoice', OEOY.CorrAPRev AS 'A/P Correction Invoice Reversal', OEOY.CorrARInv AS 'A/R Correction Invoice', OEOY.CorrARRev AS 'A/R Correction Invoice Reversal', OEOY.UserObj AS 'User Object', OEOY.AdWrkOrdr AS 'Advanced Work Order', OEOY.DPOInvoice AS 'A/P Down Payment Invoice', OEOY.DPORequest AS 'A/P Down Payment Request', OEOY.P_Quotatio AS 'Transfer Open Pur. Quotations', OEOY.WTQ AS 'Inventory Transfer Requests', OEOY.Oat AS 'Blanket Agreement', OEOY.CPN AS 'Campaign', OEOY.AdvRules AS 'Transfer Advanced Rules', OEOY.Prq AS 'Purchase Request' FROM OEOY AS OEOY

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates