|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Financial Template Import - Files
Table Name: FTT1
Table Description: Financial Template Import - Files
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OFTT | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| FileName | Data Definition File Name | nVarChar | 254 | - | Â | Â | Â |
| ReleaDate | Release Date | Date | 8 | - | Â | Â | Â |
| Descript | Description | nVarChar | 100 | - | Â | Â | Â |
| Localizat | Localization | nVarChar | 3 | - | Â | Â | Â |
| ChartAcct | Chart of Accounts | nVarChar | 128 | - | Â | Â | Â |
| DocType | Template Type | VarChar | 1 | - | B | 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 |
| DimCode | Dimension Code | Int | 11 | ODIM | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineNum |