biuan SAP® BUSINESS ONE SDK
DTW Human Resources
API FTT1
FTT1 - Financial Template Import - Files Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OFTT
Financial Template Import
PRIMARYYes
LineNumRow NumberInt
11
FileNameData Definition File NamenVarChar
127
ReleaDateRelease DateDate
8
DescriptDescriptionnVarChar
100
LocalizatLocalizationnVarChar
3
ChartAcctChart of AccountsnVarChar
127
DocTypeTemplate TypeVarChar
B) Balance Sheet
P) Profit and Loss
C) Trial Balance
F) Statement of Cash Flows
S) Sales Unit
T) Form 6111
A) Cost Accounting
E) Asset Devalue Provision
R) Shareholder's Rights and Interests Changing
D) Profit Distribution
V) VAT Payable Detail
L) e-Balance Sheet
O) e-Profit and Loss
H) Asset History Sheet
G) Others
I) Taxable Profit and Loss
J) Appropriation of Net Profit
K) E-Asset History Sheet
1
B

SELECT statement

SELECT FTT1.AbsEntry AS 'Internal Number', FTT1.LineNum AS 'Row Number', FTT1.FileName AS 'Data Definition File Name', FTT1.ReleaDate AS 'Release Date', FTT1.Descript AS 'Description', FTT1.Localizat AS 'Localization', FTT1.ChartAcct AS 'Chart of Accounts', FTT1.DocType AS 'Template Type' FROM FTT1 AS FTT1

Related information


Financial Template Import OFTT 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