📚 SAP Business One SDK Help

Table Name: OEOY

Table Description: End-of-Year Transfer

Field Description Type Size Related Default Value Constraints
GenrlDefs General Definitions VarChar 1 - Y Y  
            N  
ReFiles Transfer Template Designer Files VarChar 1 - Y Y  
            N  
ActIndex Transfer Accounts Index VarChar 1 - Y Y  
            N  
ActFromCod From Code nVarChar 15 -      
ActToCode To Code nVarChar 15 -      
ActGroup ActGroup nVarChar 16 - 255    
CrdIndex Transfer Credit Card Index VarChar 1 - Y Y  
            N  
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 1 - Y Y  
            N  
ItmFromCod From Code nVarChar 50 -      
ItmToCode To Code nVarChar 50 -      
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 1 - N Y  
            N  
UnDpsChk Transfer Undeposited Checks VarChar 1 - N Y  
            N  
DpsChk Transfer Postdated Checks VarChar 1 - N Y  
            N  
UnDpsVouch Transfer Unpaid Vouchers VarChar 1 - N Y  
            N  
DpsVouch Transfer Deffered Vouchers VarChar 1 - N Y  
            N  
WorkOrder Open Work Instructions VarChar 1 - N Y  
            N  
RcrTrt Posting Templates & Rec. Trans VarChar 1 - N Y  
            N  
Connection Activities VarChar 1 - N Y  
            N  
SpcPrice Special Prices VarChar 1 - N Y  
            N  
Quotations Transfer Open Sales Quotations VarChar 1 - N    
Orders Transfer Open Orders VarChar 1 - N Y  
            N  
DlvrNotes Transfer Open Delivery Notes VarChar 1 - N Y  
            N  
DlvrInvocs Transfer Open Invoices VarChar 1 - N Y  
            N  
P_Orders Transfer Purchase Orders VarChar 1 - N Y  
            N  
P_Invoices A/P Invoices VarChar 1 - N Y  
            N  
ProdTree Product Tree VarChar 1 - N Y  
            N  
Subst Customer/Vendor Catalog No. VarChar 1 - N Y  
            N  
Import Landed Costs VarChar 1 - N Y  
            N  
Revert Returns VarChar 1 - N Y  
            N  
ActBlnc Transfer Account Balances VarChar 1 - N Y  
            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 1 - N Y Unreconciled Internally
            N  
            E Unreconciled Externally
ActBlncFrC From Code nVarChar 15 -      
ActBlncToC To Code nVarChar 15 -      
ActBlncGrp ActBlncGrp nVarChar 16 - YYY    
ActZeroBln Account Transactions with Zero Balance VarChar 1 - Y Y  
            N  
CrdBlnc Transfer Credit Card Balances VarChar 1 - N Y  
            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 1 - N Y  
            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 1 - Y Y  
            N  
ItmBlnc Transfer Item Balances VarChar 1 - N Y  
            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 50 -      
ItmBlncToC To Code nVarChar 50 -      
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 1 - N Y  
            N  
FileReport Create Report File VarChar 1 - Y Y  
            N  
CompName Company Name for Transfering nVarChar 200 -      
WasGnrlDef Was general data transferred VarChar 1 - N Y  
            N  
P_DlvrNots Transfer PO Del. Notes VarChar 1 - N Y  
            N  
Spg Transfer Discount for Groups VarChar 1 - N Y  
            N  
Pdn Purchase Delivery Notes VarChar 1 - N Y  
            N  
PdnClosed Closed Purchase Delivery Notes VarChar 1 - N Y  
            N  
Rpd Revert Purchase Delivery Notes VarChar 1 - N Y  
            N  
ReportTemp Report Templates VarChar 1 - N Y  
            N  
Confirmat Confirmation VarChar 1 - N Y  
            N  
DocDraft Document Drafts VarChar 1 - N Y  
            N  
ChkOutDrft Checks for Payment Drafts VarChar 1 - N Y  
            N  
OptOpen Open Opportunities VarChar 1 - N Y  
            N  
OptClosed Closed Opportunities VarChar 1 - N Y  
            N  
SerBtchNum Batch/Serial No. VarChar 1 - N Y  
            N  
CorrInvoic Correction Invoice VarChar 1 - N Y  
            N  
UserGign User Signature Int 6 OUSR      
PaymDraf Payment Draft VarChar 1 - N Y  
            N  
PaymentWiz Saved Payment Wizard VarChar 1 - N N No
            Y Yes
AltItems Alternative Items VarChar 1 - N N No
            Y Yes
DPIInvoice A/R Down Payment Invoice VarChar 1 - N    
DPIRequest A/R Down Payment Request VarChar 1 - N Y Yes
            N No
Ctr Service Contracts VarChar 1 - N Y Yes
            N No
Ins Customer Equipment Card VarChar 1 - N Y Yes
            N No
CorrAPInv A/P Correction Invoice VarChar 1 - N Y Yes
            N No
CorrAPRev A/P Correction Invoice Reversal VarChar 1 - N Y Yes
            N No
CorrARInv A/R Correction Invoice VarChar 1 - N Y Yes
            N No
CorrARRev A/R Correction Invoice Reversal VarChar 1 - N Y Yes
            N No
UserObj User Object VarChar 1 - N N No
            Y Yes
AdWrkOrdr Advanced Work Order VarChar 1 - N Y Yes
            N No
DPOInvoice A/P Down Payment Invoice VarChar 1 - N Y Yes
            N No
DPORequest A/P Down Payment Request VarChar 1 - N Y Yes
            N No
P_Quotatio Transfer Open Pur. Quotations VarChar 1 - N Y Yes
            N No
WTQ Inventory Transfer Requests VarChar 1 - N Y Yes
            N No
Oat Blanket Agreement VarChar 1 - N Y Yes
            N No
CPN Campaign VarChar 1 - N Y Yes
            N No
AdvRules Transfer Advanced Rules VarChar 1 - N Y Yes
            N No
Prq Purchase Request VarChar 1 - N    
Key Unique Field
PRIMARY Yes CompName