|
|
DTW Financials / Budget Setup / Budget Distribution
API OEOY
OEOY - End-of-Year Transfer Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | GenrlDefs | General Definitions | VarChar | Y) N) | 1 | Y |
|---|---|---|---|---|---|---|---|---|
| ReFiles | Transfer Template Designer Files | VarChar | Y) N) | 1 | Y | |||
| ActIndex | Transfer Accounts Index | VarChar | Y) N) | 1 | Y | |||
| ActFromCod | From Code | nVarChar | 15 | |||||
| ActToCode | To Code | nVarChar | 15 | |||||
| ActGroup | ActGroup | nVarChar | 16 | 255 | ||||
| CrdIndex | Transfer Credit Card Index | VarChar | Y) N) | 1 | Y | |||
| CrdFromCod | From Code | nVarChar | 15 | |||||
| CrdToCode | To Code | nVarChar | 15 | |||||
| CrdGrpCust | Customer Group | Int | 6 | |||||
| CrdGrpVndr | Vendor Group | Int | 6 | |||||
| CrdToknAnd | CrdToknAnd | VarChar | 1 | |||||
| CrdUseGrps | CrdUseGrps | VarChar | 1 | |||||
| CrdClsRang | CrdClsRang | VarChar | 1 | |||||
| CrdGrpData | Properties | nVarChar | 64 | |||||
| ItmIndex | Transfer Item Index | VarChar | Y) N) | 1 | Y | |||
| ItmFromCod | From Code | nVarChar | 20 | |||||
| ItmToCode | To Code | nVarChar | 20 | |||||
| ItmGroup | Item Group | Int | 6 | |||||
| ItmToknAnd | ItmToknAnd | VarChar | 1 | |||||
| ItmUseGrps | ItmUseGrps | VarChar | 1 | |||||
| ItmClsRang | ItmClsRang | VarChar | 1 | |||||
| ItmGrpData | Properties | nVarChar | 64 | |||||
| TransfDoc | Documents Transfer | VarChar | Y) N) | 1 | N | |||
| UnDpsChk | Transfer Undeposited Checks | VarChar | Y) N) | 1 | N | |||
| DpsChk | Transfer Postdated Checks | VarChar | Y) N) | 1 | N | |||
| UnDpsVouch | Transfer Unpaid Vouchers | VarChar | Y) N) | 1 | N | |||
| DpsVouch | Transfer Deffered Vouchers | VarChar | Y) N) | 1 | N | |||
| WorkOrder | Open Work Instructions | VarChar | Y) N) | 1 | N | |||
| RcrTrt | Posting Templates & Rec. Trans | VarChar | Y) N) | 1 | N | |||
| Connection | Activities | VarChar | Y) N) | 1 | N | |||
| SpcPrice | Special Prices | VarChar | Y) N) | 1 | N | |||
| Quotations | Transfer Open Sales Quotations | VarChar | 1 | N | ||||
| Orders | Transfer Open Orders | VarChar | Y) N) | 1 | N | |||
| DlvrNotes | Transfer Open Delivery Notes | VarChar | Y) N) | 1 | N | |||
| DlvrInvocs | Transfer Open Invoices | VarChar | Y) N) | 1 | N | |||
| P_Orders | Transfer Purchase Orders | VarChar | Y) N) | 1 | N | |||
| P_Invoices | A/P Invoices | VarChar | Y) N) | 1 | N | |||
| ProdTree | Product Tree | VarChar | Y) N) | 1 | N | |||
| Subst | Customer/Vendor Catalog No. | VarChar | Y) N) | 1 | N | |||
| Import | Landed Costs | VarChar | Y) N) | 1 | N | |||
| Revert | Returns | VarChar | Y) N) | 1 | N | |||
| ActBlnc | Transfer Account Balances | VarChar | Y) N) | 1 | N | |||
| ActRef1 | Ref. 1 for Opening Bal. Trans. | nVarChar | 11 | |||||
| ActRef2 | Ref. 2 for Opening Bal. Trans. | nVarChar | 11 | |||||
| ActRefDate | Posting Date for OB Transactions | Date | 8 | |||||
| ActDueDate | Due date for OB transaction | Date | 8 | |||||
| ActMemo | Journal Entry Details | nVarChar | 50 | |||||
| AOpnBlnAct | Opening Balances Account | nVarChar | 15 | |||||
| AEquetyAct | Retained Earnings Account | nVarChar | 15 | |||||
| ActExpLine | Transfer Split Balances | VarChar | Y) Unreconciled Internally N) E) Unreconciled Externally | 1 | N | |||
| ActBlncFrC | From Code | nVarChar | 15 | |||||
| ActBlncToC | To Code | nVarChar | 15 | |||||
| ActBlncGrp | ActBlncGrp | nVarChar | 16 | YYY | ||||
| ActZeroBln | Account Transactions with Zero Balance | VarChar | Y) N) | 1 | Y | |||
| CrdBlnc | Transfer Credit Card Balances | VarChar | Y) N) | 1 | N | |||
| CrdRef1 | Ref. 1 for OB Transactions | nVarChar | 11 | |||||
| CrdRef2 | Ref. 2 for OB Transactions | nVarChar | 11 | |||||
| CrdRefDate | Posting Date for OB Transactions | Date | 8 | |||||
| CrdDueDate | Due date for OB transaction | Date | 8 | |||||
| CrdMemo | Journal Entry Details | nVarChar | 50 | |||||
| COpnBlnAct | Opening Balances Account | nVarChar | 15 | |||||
| CrdExpLine | Transfer Split Balances | VarChar | Y) N) | 1 | N | |||
| CrdBlncFrC | From Code | nVarChar | 15 | |||||
| CrdBlncToC | To Code | nVarChar | 15 | |||||
| CrdBlncGrC | Customer Group | Int | 6 | |||||
| CrdBlnGrpV | Vendor Group | Int | 6 | |||||
| CrdBTknAnd | CrdBTknAnd | VarChar | 1 | |||||
| CrdBUseGrp | CrdBUseGrp | VarChar | 1 | |||||
| CrdBClsRng | CrdBClsRng | VarChar | 1 | |||||
| CrdBGrpDat | Properties | nVarChar | 64 | |||||
| CrdZeroBln | Card Transactions with Zero Balance | VarChar | Y) N) | 1 | Y | |||
| ItmBlnc | Transfer Item Balances | VarChar | Y) N) | 1 | N | |||
| ItmRef1 | Ref. 1 for Opening Bal. Trans. | nVarChar | 11 | |||||
| ItmRef2 | Ref. 2 for Opening Bal. Trans. | nVarChar | 11 | |||||
| ItmRefDate | Posting Date for OB Transaction | Date | 8 | |||||
| ItmMemo | Journal Entry Details | nVarChar | 50 | |||||
| ItmBlncFrC | From Code | nVarChar | 20 | |||||
| ItmBlncToC | To Code | nVarChar | 20 | |||||
| ItmBlncGrp | Item Group | Int | 6 | |||||
| ItmBTknAnd | ItmBTknAnd | VarChar | 1 | |||||
| ItmBUseGrp | ItmBUseGrp | VarChar | 1 | |||||
| ItmBClsRng | ItmBClsRng | VarChar | 1 | |||||
| ItmBGrpDat | Properties | nVarChar | 64 | |||||
| ItmPlnNum | Transaction Price List | Int | 6 | 1 | ||||
| ItmZeroPr | Transfer Items Without Price | VarChar | Y) N) | 1 | N | |||
| FileReport | Create Report File | VarChar | Y) N) | 1 | Y | |||
| CompName KEY UNIQUE | Company Name for Transfering | nVarChar | 100 | PRIMARY | Yes | |||
| WasGnrlDef | Was general data transferred | VarChar | Y) N) | 1 | N | |||
| P_DlvrNots | Transfer PO Del. Notes | VarChar | Y) N) | 1 | N | |||
| Spg | Transfer Discount for Groups | VarChar | Y) N) | 1 | N | |||
| Pdn | Purchase Delivery Notes | VarChar | Y) N) | 1 | N | |||
| PdnClosed | Closed Purchase Delivery Notes | VarChar | Y) N) | 1 | N | |||
| Rpd | Revert Purchase Delivery Notes | VarChar | Y) N) | 1 | N | |||
| ReportTemp | Report Templates | VarChar | Y) N) | 1 | N | |||
| Confirmat | Confirmation | VarChar | Y) N) | 1 | N | |||
| DocDraft | Document Drafts | VarChar | Y) N) | 1 | N | |||
| ChkOutDrft | Checks for Payment Drafts | VarChar | Y) N) | 1 | N | |||
| OptOpen | Open Opportunities | VarChar | Y) N) | 1 | N | |||
| OptClosed | Closed Opportunities | VarChar | Y) N) | 1 | N | |||
| SerBtchNum | Batch/Serial No. | VarChar | Y) N) | 1 | N | |||
| CorrInvoic | Correction Invoice | VarChar | Y) N) | 1 | N | |||
| UserGign | User Signature | Int | 6 | OUSR Users | ||||
| PaymDraf | Payment Draft | VarChar | Y) N) | 1 | N | |||
| PaymentWiz | Saved Payment Wizard | VarChar | N) No Y) Yes | 1 | N | |||
| AltItems | Alternative Items | VarChar | N) No Y) Yes | 1 | N | |||
| DPIInvoice | A/R Down Payment Invoice | VarChar | 1 | N | ||||
| DPIRequest | A/R Down Payment Request | VarChar | Y) Yes N) No | 1 | N | |||
| Ctr | Service Contracts | VarChar | Y) Yes N) No | 1 | N | |||
| Ins | Customer Equipment Card | VarChar | Y) Yes N) No | 1 | N | |||
| CorrAPInv | A/P Correction Invoice | VarChar | Y) Yes N) No | 1 | N | |||
| CorrAPRev | A/P Correction Invoice Reversal | VarChar | Y) Yes N) No | 1 | N | |||
| CorrARInv | A/R Correction Invoice | VarChar | Y) Yes N) No | 1 | N | |||
| CorrARRev | A/R Correction Invoice Reversal | VarChar | Y) Yes N) No | 1 | N | |||
| UserObj | User Object | VarChar | N) No Y) Yes | 1 | N | |||
| AdWrkOrdr | Advanced Work Order | VarChar | Y) Yes N) No | 1 | N | |||
| DPOInvoice | A/P Down Payment Invoice | VarChar | Y) Yes N) No | 1 | N | |||
| DPORequest | A/P Down Payment Request | VarChar | Y) Yes N) No | 1 | N | |||
| P_Quotatio | Transfer Open Pur. Quotations | VarChar | Y) Yes N) No | 1 | N | |||
| WTQ | Inventory Transfer Requests | VarChar | Y) Yes N) No | 1 | N | |||
| Oat | Blanket Agreement | VarChar | Y) Yes N) No | 1 | N | |||
| CPN | Campaign | VarChar | Y) Yes N) No | 1 | N | |||
| AdvRules | Transfer Advanced Rules | VarChar | Y) Yes N) No | 1 | N | |||
| Prq | Purchase Request | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
