|
|
DTW Human Resources
API FTT1
FTT1 - Financial Template Import - Files Table
Financial Template Import OFTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OFTT Financial Template Import | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| FileName | Data Definition File Name | nVarChar | 127 | |||||
| ReleaDate | Release Date | Date | 8 | |||||
| Descript | Description | nVarChar | 100 | |||||
| Localizat | Localization | nVarChar | 3 | |||||
| ChartAcct | Chart of Accounts | nVarChar | 127 | |||||
| DocType | Template Type | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
