📚 SAP Business One SDK Help

Table Name: ODTV

Table Description: Datev Run

Field Description Type Size Related Default Value Constraints
RunId Run Number Int 11 -      
Status Datev Run Status VarChar 1 - 1 1 In Preparation
            2 Scheduled
            3 Running
            4 Finished
            5 Failed
Descrp Description nVarChar 30 -      
ExportPath Export Path nVarChar 254 -      
Updater Updater nVarChar 25 -      
GLAccounts Accounts VarChar 1 - N Y Yes
            N No
Suppliers Suppliers VarChar 1 - N Y Yes
            N No
Customers Customers VarChar 1 - N Y Yes
            N No
Journals Journals VarChar 1 - Y Y Yes
            N No
AllJETypes All Journal Entries VarChar 1 - Y Y Yes
            N No
Manual Manual Journal Entries VarChar 1 - N Y Yes
            N No
Purchase Purchase Invoices/Credit Notes VarChar 1 - N Y Yes
            N No
Sales Sales Invoices/Credit Notes VarChar 1 - N Y Yes
            N No
DateType Date Type VarChar 1 - Y Y Yes
            N No
StartDate Start Date Date 8 -      
EndDate End Date Date 8 -      
StartFisc Start of the Fiscal Year Date 8 -      
AtcEntry Attachment Entry Int 11 -      
UserSign User Signature Int 6 OUSR      
CreateDate Creation Date Date 8 -      
CreateTime Creation Time Int 6 -      
UpdateDate Date of Update Date 8 -      
UpdateTime Update Time Int 6 -      
UserSign2 Updating User Int 6 OUSR      
RunType DATEV Run Type VarChar 1 - F F Full Run
            D Delta Run
Key Unique Field
PRIMARY Yes RunId