Impromptu Version 7.4.3042.0 Kataloginhaltsbericht Kataloginformationen Katalogname: D:\Gaps\Portal\System\Catalogs\Finance_SKR51_O21_neu.cat Beschreibung: Erstellungsdatum: Freitag, August 27, 2021 Datenbankinformationen Logischer Name: O21_SKR51 Physischer Name: DSN=O21_SKR51;UID=%s;PWD=%s@ASYNC=0@0/0@COLSEQ= Typ: OD Datenbankstruktur MetaKatalog: deop01 MetaSchema: dbo Tabelle : ACCOUNT_INFO Spalte: ACCT_NR Spalte: TRANSACT_DATE Spalte: HANDLER Spalte: LEDGER_ACCTS_NAME Spalte: LEDGER_ACCTS_NAME2 Spalte: SIGN_MARK Spalte: BUDGET_ALLOC_CODE Spalte: DEPT_SPLIT Spalte: CASHBOOK_MARK Spalte: VAT_TYPE Spalte: VAT_RATE_CODE Spalte: TYPE_ACCTT Spalte: CHECK_CODE Spalte: CASH_BAL_NO_SERIE Spalte: PRINT_PAGE_NO Spalte: VAT_TABLE_ACCT Spalte: LAST_PRINT_PAGE_NO Spalte: CASHBON_SERIE Spalte: DEFAULT_AA_TRTYPE Spalte: ACCT_ACCU_CODE Spalte: FISCALYEAR_ENDDATE Spalte: BALANCING_METHOD Spalte: ACCT_SUB_TYPE Spalte: BANK_ACCT Spalte: FIXED_ASSET_ACCT Spalte: ACCT_SCHEDULE_TYPE Spalte: MAIN_CASH_ACCT_NO Spalte: CASH_DIFF_ACCT_NO Spalte: PETTY_CASH_AMOUNT Spalte: SRU_CODE Spalte: ACCT_MAPPING_NO Spalte: RATIO_CODE Spalte: QUANTITY_ALLOWED Spalte: INTERNAL_TRANSFER Spalte: CLEAN_CASH Spalte: CLEAN_CASH_NEXT_NUMBER Spalte: CLEAN_CASH_URL Spalte: CONV_FLAG Spalte: timestamp Spalte: UNIQUE_IDENT Spalte: OPENING_AA_TRTYPE Spalte: DEPARTMENT Spalte: SKR51_ACCT Spalte: ACCT_NO_SAFT Tabelle : ACCT_DOC_KEY Spalte: UNIQUE_IDENT Spalte: ACCT_NO Spalte: BOOKKEEP_DATE Spalte: BOOKKEEP_PERIOD Spalte: DOCUMENT_NO Spalte: BATCH_NO Spalte: JOURNAL_NO Spalte: BOOK_NO Spalte: ORIGIN Spalte: STATUS Spalte: DEBIT_AMOUNT Spalte: CREDIT_AMOUNT Spalte: DEBIT_QUANTITY Spalte: CREDIT_QUANTITY Spalte: AA_TRTYPE Spalte: SITE Spalte: STRATEGIC_AREA Spalte: DEPARTMENT Spalte: ACTIVITY Spalte: STOCK Spalte: MAKE_FAMILY Spalte: MAKE Spalte: VEHICLE_TYPE Spalte: MODEL_LINE Spalte: FACTORY_MODEL Spalte: WORKSHOP_MODEL Spalte: PRODUCT_GROUP Spalte: REPAIR_GROUP Spalte: KIT_GROUP Spalte: VAT_CODE_ORDER Spalte: TIME_CODE Spalte: INT_EXT_CODE Spalte: DESTINATION Spalte: PRICE_CODE Spalte: REDUCTION_CODE Spalte: VAT_RATE_CODE Spalte: MISC_NO Spalte: BOOKKEEPING_CODE Spalte: COST_REVENUE_CODE Spalte: REASON_CODE Spalte: PART_GROUP Spalte: OWN_DIMENSION_1 Spalte: OWN_DIMENSION_2 Spalte: OWN_DIMENSION_3 Spalte: OWN_DIMENSION_4 Spalte: OWN_DIMENSION_5 Spalte: INT_VOUCHER_NO Spalte: BALANCING_MARK Spalte: ACCT_SCHEDULE_ID Spalte: REGISTER_NUMBER Spalte: PURCH_ORIGIN_CODE Spalte: USED_VEH_DEST_CODE Spalte: USE_OF_VEHICLE Spalte: ACCT_NO_NEXT_CHART Spalte: DEPARTMENT_NEXT_CHART Spalte: CONV_FLAG Spalte: timestamp Spalte: CL_DET_CODE Spalte: CL_TROUBLE_CODE Spalte: CL_TYPE Spalte: PURCH_SALESMAN Spalte: SALE_SALESMAN Spalte: SKR51_KEY Spalte: SKR51_COST_BEARER Tabelle : ACCT_DOC_DATA Spalte: REFERENCE_IDENT Spalte: TRANSACT_DATE Spalte: HANDLER Spalte: PROGRAM Spalte: FUNCTION_CODE Spalte: MODUL Spalte: DOCUMENT_KEY Spalte: SUB_ACCT_TYPE Spalte: SUB_ACCT_NO Spalte: TRANSACT_CODE Spalte: COMMENT Spalte: VAT_CODE Spalte: VAT_PERC Spalte: INV_PERC Spalte: PURCH_INVNO Spalte: SETOFF_ACCT Spalte: CHEQUE_NUMBER Spalte: ORIGINAL_BATCH_NO Spalte: DOCUMENT_DATE Spalte: VAT_TABLE_CODE Spalte: ADD_VAT_RATE_CODE Spalte: ADD_VAT_TABLE_CODE Spalte: ADD_VAT_PERC Spalte: BALANCING_COMMENT Spalte: CONV_FLAG Spalte: timestamp Spalte: UNIQUE_IDENT Spalte: EEC_VAT_WORK_CODE Spalte: CREATION_DATE Spalte: VAT_CODE_SAFT Spalte: VAT_CODE_SAFT_CHANGEDATE Spalte: VAT_CODE_SAFT_HANDLER Tabelle : SITE Spalte: SITE_ID Spalte: DESCRIPTION Spalte: HANDLER Spalte: TRANSACT_DATE Spalte: BM_CODE Spalte: CONV_FLAG Spalte: timestamp Spalte: UNIQUE_IDENT Tabelle : DEPARTMENT_TYPE Spalte: DEPARTMENT_TYPE_ID Spalte: TRANSACT_DATE Spalte: HANDLER Spalte: DESCRIPTION Spalte: DEPARTMENT_GROUP Spalte: CONV_FLAG Spalte: timestamp Spalte: UNIQUE_IDENT Tabelle : vPP65 Spalte: PRODUCT_GROUP Spalte: STATE_CODE_PARAM Spalte: TRANSACT_DATE Spalte: HANDLER Spalte: PROD_GRP_SPECIFY Spalte: COEFF Spalte: COST_PERC Spalte: DEPARTMENT_10 Spalte: LINE_MISC_ADDS_PER Spalte: SALES_ACCOUNT Spalte: PRICE_TYPE_PROD_1 Spalte: PRICE_TYPE_PROD_2 Spalte: PRICE_TYPE_PROD_3 Spalte: PRICE_TYPE_PROD_4 Spalte: PRICE_TYPE_PROD_5 Spalte: PROD_SORT_KEY Spalte: PROD_GRP_CHECK Spalte: INVOICE_TOTAL_NO Spalte: BACK_ORDER_PERM Spalte: ORIG_PROD_GRP Spalte: FB_STATISTIC Spalte: FORD_PART Spalte: SALES_PRICE_ZERO Spalte: DC2000_PROD_GRP Spalte: SHORT_COMMUNITY Spalte: RETURN_ALLOWED Spalte: OPEL_PART Spalte: MAKE_CD Spalte: PURCH_PROD_GRP Spalte: PRODUCT_GROUP_TP Spalte: VR_PART Spalte: USE_ONE_CORE_PART Spalte: PRODUCT_GROUP_CORE_PART Spalte: TOYOTA_PART Spalte: SPEC_PURCH_PRICE Spalte: DEFAULT_SUPPLIER Spalte: DISTINCT_DISC Spalte: PRINT_DANGEROUS_CD Spalte: STRATEGIC_AREA Spalte: SKR51_PRODUCT_GROUP Spalte: timestamp Spalte: UNIQUE_IDENT Tabelle : STRATEGIC_AREA Spalte: STRATEGIC_AREA_ID Spalte: DESCRIPTION Spalte: HANDLER Spalte: TRANSACT_DATE Spalte: NAME Spalte: STREET_ADDRESS Spalte: ZIPCODE Spalte: MAIL_ADDR Spalte: ADDR_3 Spalte: COUNTY Spalte: PHONE Spalte: TELEX Spalte: E_MAIL_ADDRESS Spalte: SU_IDENT Spalte: VAT_REGNO_EU Spalte: ILN_35 Spalte: FINANCIAL_RESERVE Spalte: ORGANISATION_NO Spalte: STRAT_AREA_EAN_NUMBER Spalte: CONV_FLAG Spalte: timestamp Spalte: UNIQUE_IDENT Tabelle : vPP5Q Spalte: MAKE_CD Spalte: MODEL_LINE Spalte: STATE_CODE_PARAM Spalte: TRANSACT_DATE Spalte: HANDLER Spalte: MOD_LIN_SPECIFY Spalte: MOD_LIN_OWN_OPT_1 Spalte: MOD_LIN_OWN_OPT_2 Spalte: MOD_LIN_OWN_OPT_3 Spalte: MOD_LIN_OWN_OPT_4 Spalte: MOD_LIN_OWN_OPT_5 Spalte: EDICS_PRICECALC Spalte: EDICS_MODEL_01 Spalte: EDICS_MODEL_02 Spalte: EDICS_MODEL_03 Spalte: EDICS_MODEL_04 Spalte: EDICS_MODEL_05 Spalte: EDICS_MODEL_06 Spalte: EDICS_MODEL_07 Spalte: EDICS_MODEL_08 Spalte: EDICS_MODEL_09 Spalte: EDICS_MODEL_10 Spalte: EDICS_MODEL_11 Spalte: EDICS_MODEL_12 Spalte: EDICS_MODEL_13 Spalte: EDICS_MODEL_14 Spalte: EDICS_MODEL_15 Spalte: EDICS_MODEL_16 Spalte: EDICS_MODEL_17 Spalte: EDICS_MODEL_18 Spalte: EDICS_MODEL_19 Spalte: EDICS_MODEL_20 Spalte: timestamp Spalte: UNIQUE_IDENT Katalogordner Ordner: Account Info Spalte: Acct Nr ("deop01"."dbo"."ACCOUNT_INFO""ACCT_NR") Spalte: Transact Date ("deop01"."dbo"."ACCOUNT_INFO""TRANSACT_DATE") Spalte: Handler ("deop01"."dbo"."ACCOUNT_INFO""HANDLER") Spalte: Ledger Accts Name ("deop01"."dbo"."ACCOUNT_INFO""LEDGER_ACCTS_NAME") Spalte: Ledger Accts Name2 ("deop01"."dbo"."ACCOUNT_INFO""LEDGER_ACCTS_NAME2") Spalte: Sign Mark ("deop01"."dbo"."ACCOUNT_INFO""SIGN_MARK") Spalte: Budget Alloc Code ("deop01"."dbo"."ACCOUNT_INFO""BUDGET_ALLOC_CODE") Spalte: Dept Split ("deop01"."dbo"."ACCOUNT_INFO""DEPT_SPLIT") Spalte: Cashbook Mark ("deop01"."dbo"."ACCOUNT_INFO""CASHBOOK_MARK") Spalte: Vat Type ("deop01"."dbo"."ACCOUNT_INFO""VAT_TYPE") Spalte: Vat Rate Code ("deop01"."dbo"."ACCOUNT_INFO""VAT_RATE_CODE") Spalte: Type Acctt ("deop01"."dbo"."ACCOUNT_INFO""TYPE_ACCTT") Spalte: Check Code ("deop01"."dbo"."ACCOUNT_INFO""CHECK_CODE") Spalte: Cash Bal No Serie ("deop01"."dbo"."ACCOUNT_INFO""CASH_BAL_NO_SERIE") Spalte: Print Page No ("deop01"."dbo"."ACCOUNT_INFO""PRINT_PAGE_NO") Spalte: Vat Table Acct ("deop01"."dbo"."ACCOUNT_INFO""VAT_TABLE_ACCT") Spalte: Last Print Page No ("deop01"."dbo"."ACCOUNT_INFO""LAST_PRINT_PAGE_NO") Spalte: Cashbon Serie ("deop01"."dbo"."ACCOUNT_INFO""CASHBON_SERIE") Spalte: Default Aa Trtype ("deop01"."dbo"."ACCOUNT_INFO""DEFAULT_AA_TRTYPE") Spalte: Acct Accu Code ("deop01"."dbo"."ACCOUNT_INFO""ACCT_ACCU_CODE") Spalte: Fiscalyear Enddate ("deop01"."dbo"."ACCOUNT_INFO""FISCALYEAR_ENDDATE") Spalte: Balancing Method ("deop01"."dbo"."ACCOUNT_INFO""BALANCING_METHOD") Spalte: Acct Sub Type ("deop01"."dbo"."ACCOUNT_INFO""ACCT_SUB_TYPE") Spalte: Bank Acct ("deop01"."dbo"."ACCOUNT_INFO""BANK_ACCT") Spalte: Fixed Asset Acct ("deop01"."dbo"."ACCOUNT_INFO""FIXED_ASSET_ACCT") Spalte: Acct Schedule Type ("deop01"."dbo"."ACCOUNT_INFO""ACCT_SCHEDULE_TYPE") Spalte: Main Cash Acct No ("deop01"."dbo"."ACCOUNT_INFO""MAIN_CASH_ACCT_NO") Spalte: Cash Diff Acct No ("deop01"."dbo"."ACCOUNT_INFO""CASH_DIFF_ACCT_NO") Spalte: Petty Cash Amount ("deop01"."dbo"."ACCOUNT_INFO""PETTY_CASH_AMOUNT") Spalte: Sru Code ("deop01"."dbo"."ACCOUNT_INFO""SRU_CODE") Spalte: Acct Mapping No ("deop01"."dbo"."ACCOUNT_INFO""ACCT_MAPPING_NO") Spalte: Ratio Code ("deop01"."dbo"."ACCOUNT_INFO""RATIO_CODE") Spalte: Quantity Allowed ("deop01"."dbo"."ACCOUNT_INFO""QUANTITY_ALLOWED") Spalte: Internal Transfer ("deop01"."dbo"."ACCOUNT_INFO""INTERNAL_TRANSFER") Spalte: Clean Cash ("deop01"."dbo"."ACCOUNT_INFO""CLEAN_CASH") Spalte: Clean Cash Next Number ("deop01"."dbo"."ACCOUNT_INFO""CLEAN_CASH_NEXT_NUMBER") Spalte: Clean Cash Url ("deop01"."dbo"."ACCOUNT_INFO""CLEAN_CASH_URL") Spalte: Conv Flag ("deop01"."dbo"."ACCOUNT_INFO""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."ACCOUNT_INFO""timestamp") Spalte: Unique Ident ("deop01"."dbo"."ACCOUNT_INFO""UNIQUE_IDENT") Spalte: Opening Aa Trtype ("deop01"."dbo"."ACCOUNT_INFO""OPENING_AA_TRTYPE") Spalte: Department ("deop01"."dbo"."ACCOUNT_INFO""DEPARTMENT") Spalte: Skr51 Acct ("deop01"."dbo"."ACCOUNT_INFO""SKR51_ACCT") Spalte: Acct No Saft ("deop01"."dbo"."ACCOUNT_INFO""ACCT_NO_SAFT") Ordner: Acct Doc Key Spalte: Unique Ident ("deop01"."dbo"."ACCT_DOC_KEY""UNIQUE_IDENT") Spalte: Acct No ("deop01"."dbo"."ACCT_DOC_KEY""ACCT_NO") Spalte: Bookkeep Date ("deop01"."dbo"."ACCT_DOC_KEY""BOOKKEEP_DATE") Spalte: Bookkeep Period ("deop01"."dbo"."ACCT_DOC_KEY""BOOKKEEP_PERIOD") Spalte: Document No ("deop01"."dbo"."ACCT_DOC_KEY""DOCUMENT_NO") Spalte: Batch No ("deop01"."dbo"."ACCT_DOC_KEY""BATCH_NO") Spalte: Journal No ("deop01"."dbo"."ACCT_DOC_KEY""JOURNAL_NO") Spalte: Book No ("deop01"."dbo"."ACCT_DOC_KEY""BOOK_NO") Spalte: Origin ("deop01"."dbo"."ACCT_DOC_KEY""ORIGIN") Spalte: Status ("deop01"."dbo"."ACCT_DOC_KEY""STATUS") Spalte: Debit Amount ("deop01"."dbo"."ACCT_DOC_KEY""DEBIT_AMOUNT") Spalte: Credit Amount ("deop01"."dbo"."ACCT_DOC_KEY""CREDIT_AMOUNT") Spalte: Debit Quantity ("deop01"."dbo"."ACCT_DOC_KEY""DEBIT_QUANTITY") Spalte: Credit Quantity ("deop01"."dbo"."ACCT_DOC_KEY""CREDIT_QUANTITY") Spalte: Aa Trtype ("deop01"."dbo"."ACCT_DOC_KEY""AA_TRTYPE") Spalte: Site ("deop01"."dbo"."ACCT_DOC_KEY""SITE") Spalte: Strategic Area ("deop01"."dbo"."ACCT_DOC_KEY""STRATEGIC_AREA") Spalte: Department ("deop01"."dbo"."ACCT_DOC_KEY""DEPARTMENT") Spalte: Activity ("deop01"."dbo"."ACCT_DOC_KEY""ACTIVITY") Spalte: Stock ("deop01"."dbo"."ACCT_DOC_KEY""STOCK") Spalte: Make Family ("deop01"."dbo"."ACCT_DOC_KEY""MAKE_FAMILY") Spalte: Make ("deop01"."dbo"."ACCT_DOC_KEY""MAKE") Spalte: Vehicle Type ("deop01"."dbo"."ACCT_DOC_KEY""VEHICLE_TYPE") Spalte: Model Line ("deop01"."dbo"."ACCT_DOC_KEY""MODEL_LINE") Spalte: Factory Model ("deop01"."dbo"."ACCT_DOC_KEY""FACTORY_MODEL") Spalte: Workshop Model ("deop01"."dbo"."ACCT_DOC_KEY""WORKSHOP_MODEL") Spalte: Product Group ("deop01"."dbo"."ACCT_DOC_KEY""PRODUCT_GROUP") Spalte: Repair Group ("deop01"."dbo"."ACCT_DOC_KEY""REPAIR_GROUP") Spalte: Kit Group ("deop01"."dbo"."ACCT_DOC_KEY""KIT_GROUP") Spalte: Vat Code Order ("deop01"."dbo"."ACCT_DOC_KEY""VAT_CODE_ORDER") Spalte: Time Code ("deop01"."dbo"."ACCT_DOC_KEY""TIME_CODE") Spalte: Int Ext Code ("deop01"."dbo"."ACCT_DOC_KEY""INT_EXT_CODE") Spalte: Destination ("deop01"."dbo"."ACCT_DOC_KEY""DESTINATION") Spalte: Price Code ("deop01"."dbo"."ACCT_DOC_KEY""PRICE_CODE") Spalte: Reduction Code ("deop01"."dbo"."ACCT_DOC_KEY""REDUCTION_CODE") Spalte: Vat Rate Code ("deop01"."dbo"."ACCT_DOC_KEY""VAT_RATE_CODE") Spalte: Misc No ("deop01"."dbo"."ACCT_DOC_KEY""MISC_NO") Spalte: Bookkeeping Code ("deop01"."dbo"."ACCT_DOC_KEY""BOOKKEEPING_CODE") Spalte: Cost Revenue Code ("deop01"."dbo"."ACCT_DOC_KEY""COST_REVENUE_CODE") Spalte: Reason Code ("deop01"."dbo"."ACCT_DOC_KEY""REASON_CODE") Spalte: Part Group ("deop01"."dbo"."ACCT_DOC_KEY""PART_GROUP") Spalte: Own Dimension 1 ("deop01"."dbo"."ACCT_DOC_KEY""OWN_DIMENSION_1") Spalte: Own Dimension 2 ("deop01"."dbo"."ACCT_DOC_KEY""OWN_DIMENSION_2") Spalte: Own Dimension 3 ("deop01"."dbo"."ACCT_DOC_KEY""OWN_DIMENSION_3") Spalte: Own Dimension 4 ("deop01"."dbo"."ACCT_DOC_KEY""OWN_DIMENSION_4") Spalte: Own Dimension 5 ("deop01"."dbo"."ACCT_DOC_KEY""OWN_DIMENSION_5") Spalte: Int Voucher No ("deop01"."dbo"."ACCT_DOC_KEY""INT_VOUCHER_NO") Spalte: Balancing Mark ("deop01"."dbo"."ACCT_DOC_KEY""BALANCING_MARK") Spalte: Acct Schedule Id ("deop01"."dbo"."ACCT_DOC_KEY""ACCT_SCHEDULE_ID") Spalte: Register Number ("deop01"."dbo"."ACCT_DOC_KEY""REGISTER_NUMBER") Spalte: Purch Origin Code ("deop01"."dbo"."ACCT_DOC_KEY""PURCH_ORIGIN_CODE") Spalte: Used Veh Dest Code ("deop01"."dbo"."ACCT_DOC_KEY""USED_VEH_DEST_CODE") Spalte: Use Of Vehicle ("deop01"."dbo"."ACCT_DOC_KEY""USE_OF_VEHICLE") Spalte: Acct No Next Chart ("deop01"."dbo"."ACCT_DOC_KEY""ACCT_NO_NEXT_CHART") Spalte: Department Next Chart ("deop01"."dbo"."ACCT_DOC_KEY""DEPARTMENT_NEXT_CHART") Spalte: Conv Flag ("deop01"."dbo"."ACCT_DOC_KEY""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."ACCT_DOC_KEY""timestamp") Spalte: Cl Det Code ("deop01"."dbo"."ACCT_DOC_KEY""CL_DET_CODE") Spalte: Cl Trouble Code ("deop01"."dbo"."ACCT_DOC_KEY""CL_TROUBLE_CODE") Spalte: Cl Type ("deop01"."dbo"."ACCT_DOC_KEY""CL_TYPE") Spalte: Purch Salesman ("deop01"."dbo"."ACCT_DOC_KEY""PURCH_SALESMAN") Spalte: Sale Salesman ("deop01"."dbo"."ACCT_DOC_KEY""SALE_SALESMAN") Spalte: Skr51 Key ("deop01"."dbo"."ACCT_DOC_KEY""SKR51_KEY") Spalte: Skr51 Cost Bearer ("deop01"."dbo"."ACCT_DOC_KEY""SKR51_COST_BEARER") Ordner: Acct Doc Data Spalte: Reference Ident ("deop01"."dbo"."ACCT_DOC_DATA""REFERENCE_IDENT") Spalte: Transact Date ("deop01"."dbo"."ACCT_DOC_DATA""TRANSACT_DATE") Spalte: Handler ("deop01"."dbo"."ACCT_DOC_DATA""HANDLER") Spalte: Program ("deop01"."dbo"."ACCT_DOC_DATA""PROGRAM") Spalte: Function Code ("deop01"."dbo"."ACCT_DOC_DATA""FUNCTION_CODE") Spalte: Modul ("deop01"."dbo"."ACCT_DOC_DATA""MODUL") Spalte: Document Key ("deop01"."dbo"."ACCT_DOC_DATA""DOCUMENT_KEY") Spalte: Sub Acct Type ("deop01"."dbo"."ACCT_DOC_DATA""SUB_ACCT_TYPE") Spalte: Sub Acct No ("deop01"."dbo"."ACCT_DOC_DATA""SUB_ACCT_NO") Spalte: Transact Code ("deop01"."dbo"."ACCT_DOC_DATA""TRANSACT_CODE") Spalte: Comment ("deop01"."dbo"."ACCT_DOC_DATA""COMMENT") Spalte: Vat Code ("deop01"."dbo"."ACCT_DOC_DATA""VAT_CODE") Spalte: Vat Perc ("deop01"."dbo"."ACCT_DOC_DATA""VAT_PERC") Spalte: Inv Perc ("deop01"."dbo"."ACCT_DOC_DATA""INV_PERC") Spalte: Purch Invno ("deop01"."dbo"."ACCT_DOC_DATA""PURCH_INVNO") Spalte: Setoff Acct ("deop01"."dbo"."ACCT_DOC_DATA""SETOFF_ACCT") Spalte: Cheque Number ("deop01"."dbo"."ACCT_DOC_DATA""CHEQUE_NUMBER") Spalte: Original Batch No ("deop01"."dbo"."ACCT_DOC_DATA""ORIGINAL_BATCH_NO") Spalte: Document Date ("deop01"."dbo"."ACCT_DOC_DATA""DOCUMENT_DATE") Spalte: Vat Table Code ("deop01"."dbo"."ACCT_DOC_DATA""VAT_TABLE_CODE") Spalte: Add Vat Rate Code ("deop01"."dbo"."ACCT_DOC_DATA""ADD_VAT_RATE_CODE") Spalte: Add Vat Table Code ("deop01"."dbo"."ACCT_DOC_DATA""ADD_VAT_TABLE_CODE") Spalte: Add Vat Perc ("deop01"."dbo"."ACCT_DOC_DATA""ADD_VAT_PERC") Spalte: Balancing Comment ("deop01"."dbo"."ACCT_DOC_DATA""BALANCING_COMMENT") Spalte: Conv Flag ("deop01"."dbo"."ACCT_DOC_DATA""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."ACCT_DOC_DATA""timestamp") Spalte: Unique Ident ("deop01"."dbo"."ACCT_DOC_DATA""UNIQUE_IDENT") Spalte: Eec Vat Work Code ("deop01"."dbo"."ACCT_DOC_DATA""EEC_VAT_WORK_CODE") Spalte: Creation Date ("deop01"."dbo"."ACCT_DOC_DATA""CREATION_DATE") Spalte: Vat Code Saft ("deop01"."dbo"."ACCT_DOC_DATA""VAT_CODE_SAFT") Spalte: Vat Code Saft Changedate ("deop01"."dbo"."ACCT_DOC_DATA""VAT_CODE_SAFT_CHANGEDATE") Spalte: Vat Code Saft Handler ("deop01"."dbo"."ACCT_DOC_DATA""VAT_CODE_SAFT_HANDLER") Ordner: Site Spalte: Site Id ("deop01"."dbo"."SITE""SITE_ID") Spalte: Description ("deop01"."dbo"."SITE""DESCRIPTION") Spalte: Handler ("deop01"."dbo"."SITE""HANDLER") Spalte: Transact Date ("deop01"."dbo"."SITE""TRANSACT_DATE") Spalte: Bm Code ("deop01"."dbo"."SITE""BM_CODE") Spalte: Conv Flag ("deop01"."dbo"."SITE""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."SITE""timestamp") Spalte: Unique Ident ("deop01"."dbo"."SITE""UNIQUE_IDENT") Ordner: Department Type Spalte: Department Type Id ("deop01"."dbo"."DEPARTMENT_TYPE""DEPARTMENT_TYPE_ID") Spalte: Transact Date ("deop01"."dbo"."DEPARTMENT_TYPE""TRANSACT_DATE") Spalte: Handler ("deop01"."dbo"."DEPARTMENT_TYPE""HANDLER") Spalte: Description ("deop01"."dbo"."DEPARTMENT_TYPE""DESCRIPTION") Spalte: Department Group ("deop01"."dbo"."DEPARTMENT_TYPE""DEPARTMENT_GROUP") Spalte: Conv Flag ("deop01"."dbo"."DEPARTMENT_TYPE""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."DEPARTMENT_TYPE""timestamp") Spalte: Unique Ident ("deop01"."dbo"."DEPARTMENT_TYPE""UNIQUE_IDENT") Ordner: Vpp65 Spalte: Product Group ("deop01"."dbo"."vPP65""PRODUCT_GROUP") Spalte: State Code Param ("deop01"."dbo"."vPP65""STATE_CODE_PARAM") Spalte: Transact Date ("deop01"."dbo"."vPP65""TRANSACT_DATE") Spalte: Handler ("deop01"."dbo"."vPP65""HANDLER") Spalte: Prod Grp Specify ("deop01"."dbo"."vPP65""PROD_GRP_SPECIFY") Spalte: Coeff ("deop01"."dbo"."vPP65""COEFF") Spalte: Cost Perc ("deop01"."dbo"."vPP65""COST_PERC") Spalte: Department 10 ("deop01"."dbo"."vPP65""DEPARTMENT_10") Spalte: Line Misc Adds Per ("deop01"."dbo"."vPP65""LINE_MISC_ADDS_PER") Spalte: Sales Account ("deop01"."dbo"."vPP65""SALES_ACCOUNT") Spalte: Price Type Prod 1 ("deop01"."dbo"."vPP65""PRICE_TYPE_PROD_1") Spalte: Price Type Prod 2 ("deop01"."dbo"."vPP65""PRICE_TYPE_PROD_2") Spalte: Price Type Prod 3 ("deop01"."dbo"."vPP65""PRICE_TYPE_PROD_3") Spalte: Price Type Prod 4 ("deop01"."dbo"."vPP65""PRICE_TYPE_PROD_4") Spalte: Price Type Prod 5 ("deop01"."dbo"."vPP65""PRICE_TYPE_PROD_5") Spalte: Prod Sort Key ("deop01"."dbo"."vPP65""PROD_SORT_KEY") Spalte: Prod Grp Check ("deop01"."dbo"."vPP65""PROD_GRP_CHECK") Spalte: Invoice Total No ("deop01"."dbo"."vPP65""INVOICE_TOTAL_NO") Spalte: Back Order Perm ("deop01"."dbo"."vPP65""BACK_ORDER_PERM") Spalte: Orig Prod Grp ("deop01"."dbo"."vPP65""ORIG_PROD_GRP") Spalte: Fb Statistic ("deop01"."dbo"."vPP65""FB_STATISTIC") Spalte: Ford Part ("deop01"."dbo"."vPP65""FORD_PART") Spalte: Sales Price Zero ("deop01"."dbo"."vPP65""SALES_PRICE_ZERO") Spalte: Dc2000 Prod Grp ("deop01"."dbo"."vPP65""DC2000_PROD_GRP") Spalte: Short Community ("deop01"."dbo"."vPP65""SHORT_COMMUNITY") Spalte: Return Allowed ("deop01"."dbo"."vPP65""RETURN_ALLOWED") Spalte: Opel Part ("deop01"."dbo"."vPP65""OPEL_PART") Spalte: Make Cd ("deop01"."dbo"."vPP65""MAKE_CD") Spalte: Purch Prod Grp ("deop01"."dbo"."vPP65""PURCH_PROD_GRP") Spalte: Product Group Tp ("deop01"."dbo"."vPP65""PRODUCT_GROUP_TP") Spalte: Vr Part ("deop01"."dbo"."vPP65""VR_PART") Spalte: Use One Core Part ("deop01"."dbo"."vPP65""USE_ONE_CORE_PART") Spalte: Product Group Core Part ("deop01"."dbo"."vPP65""PRODUCT_GROUP_CORE_PART") Spalte: Toyota Part ("deop01"."dbo"."vPP65""TOYOTA_PART") Spalte: Spec Purch Price ("deop01"."dbo"."vPP65""SPEC_PURCH_PRICE") Spalte: Default Supplier ("deop01"."dbo"."vPP65""DEFAULT_SUPPLIER") Spalte: Distinct Disc ("deop01"."dbo"."vPP65""DISTINCT_DISC") Spalte: Print Dangerous Cd ("deop01"."dbo"."vPP65""PRINT_DANGEROUS_CD") Spalte: Strategic Area ("deop01"."dbo"."vPP65""STRATEGIC_AREA") Spalte: Skr51 Product Group ("deop01"."dbo"."vPP65""SKR51_PRODUCT_GROUP") Spalte: Timestamp ("deop01"."dbo"."vPP65""timestamp") Spalte: Unique Ident ("deop01"."dbo"."vPP65""UNIQUE_IDENT") Ordner: Strategic Area Spalte: Strategic Area Id ("deop01"."dbo"."STRATEGIC_AREA""STRATEGIC_AREA_ID") Spalte: Description ("deop01"."dbo"."STRATEGIC_AREA""DESCRIPTION") Spalte: Handler ("deop01"."dbo"."STRATEGIC_AREA""HANDLER") Spalte: Transact Date ("deop01"."dbo"."STRATEGIC_AREA""TRANSACT_DATE") Spalte: Name ("deop01"."dbo"."STRATEGIC_AREA""NAME") Spalte: Street Address ("deop01"."dbo"."STRATEGIC_AREA""STREET_ADDRESS") Spalte: Zipcode ("deop01"."dbo"."STRATEGIC_AREA""ZIPCODE") Spalte: Mail Addr ("deop01"."dbo"."STRATEGIC_AREA""MAIL_ADDR") Spalte: Addr 3 ("deop01"."dbo"."STRATEGIC_AREA""ADDR_3") Spalte: County ("deop01"."dbo"."STRATEGIC_AREA""COUNTY") Spalte: Phone ("deop01"."dbo"."STRATEGIC_AREA""PHONE") Spalte: Telex ("deop01"."dbo"."STRATEGIC_AREA""TELEX") Spalte: E Mail Address ("deop01"."dbo"."STRATEGIC_AREA""E_MAIL_ADDRESS") Spalte: Su Ident ("deop01"."dbo"."STRATEGIC_AREA""SU_IDENT") Spalte: Vat Regno Eu ("deop01"."dbo"."STRATEGIC_AREA""VAT_REGNO_EU") Spalte: Iln 35 ("deop01"."dbo"."STRATEGIC_AREA""ILN_35") Spalte: Financial Reserve ("deop01"."dbo"."STRATEGIC_AREA""FINANCIAL_RESERVE") Spalte: Organisation No ("deop01"."dbo"."STRATEGIC_AREA""ORGANISATION_NO") Spalte: Strat Area Ean Number ("deop01"."dbo"."STRATEGIC_AREA""STRAT_AREA_EAN_NUMBER") Spalte: Conv Flag ("deop01"."dbo"."STRATEGIC_AREA""CONV_FLAG") Spalte: Timestamp ("deop01"."dbo"."STRATEGIC_AREA""timestamp") Spalte: Unique Ident ("deop01"."dbo"."STRATEGIC_AREA""UNIQUE_IDENT") Ordner: Vpppl Ordner: Vpp5q Spalte: Make Cd ("deop01"."dbo"."vPP5Q""MAKE_CD") Spalte: Model Line ("deop01"."dbo"."vPP5Q""MODEL_LINE") Spalte: State Code Param ("deop01"."dbo"."vPP5Q""STATE_CODE_PARAM") Spalte: Transact Date ("deop01"."dbo"."vPP5Q""TRANSACT_DATE") Spalte: Handler ("deop01"."dbo"."vPP5Q""HANDLER") Spalte: Mod Lin Specify ("deop01"."dbo"."vPP5Q""MOD_LIN_SPECIFY") Spalte: Mod Lin Own Opt 1 ("deop01"."dbo"."vPP5Q""MOD_LIN_OWN_OPT_1") Spalte: Mod Lin Own Opt 2 ("deop01"."dbo"."vPP5Q""MOD_LIN_OWN_OPT_2") Spalte: Mod Lin Own Opt 3 ("deop01"."dbo"."vPP5Q""MOD_LIN_OWN_OPT_3") Spalte: Mod Lin Own Opt 4 ("deop01"."dbo"."vPP5Q""MOD_LIN_OWN_OPT_4") Spalte: Mod Lin Own Opt 5 ("deop01"."dbo"."vPP5Q""MOD_LIN_OWN_OPT_5") Spalte: Edics Pricecalc ("deop01"."dbo"."vPP5Q""EDICS_PRICECALC") Spalte: Edics Model 01 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_01") Spalte: Edics Model 02 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_02") Spalte: Edics Model 03 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_03") Spalte: Edics Model 04 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_04") Spalte: Edics Model 05 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_05") Spalte: Edics Model 06 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_06") Spalte: Edics Model 07 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_07") Spalte: Edics Model 08 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_08") Spalte: Edics Model 09 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_09") Spalte: Edics Model 10 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_10") Spalte: Edics Model 11 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_11") Spalte: Edics Model 12 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_12") Spalte: Edics Model 13 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_13") Spalte: Edics Model 14 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_14") Spalte: Edics Model 15 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_15") Spalte: Edics Model 16 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_16") Spalte: Edics Model 17 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_17") Spalte: Edics Model 18 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_18") Spalte: Edics Model 19 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_19") Spalte: Edics Model 20 ("deop01"."dbo"."vPP5Q""EDICS_MODEL_20") Spalte: Timestamp ("deop01"."dbo"."vPP5Q""timestamp") Spalte: Unique Ident ("deop01"."dbo"."vPP5Q""UNIQUE_IDENT") Tabellenverbindungen ACCOUNT_INFO - ACCT_DOC_KEY : Geschlossene Verbindung ACCOUNT_INFO."ACCT_NR" = ACCT_DOC_KEY."ACCT_NO" ACCT_DOC_KEY - ACCT_DOC_DATA : Geschlossene Verbindung ACCT_DOC_KEY."UNIQUE_IDENT" = ACCT_DOC_DATA."REFERENCE_IDENT" ACCT_DOC_KEY - SITE : Rechte offene Verbindung ACCT_DOC_KEY."SITE" = SITE."SITE_ID" ACCT_DOC_KEY - DEPARTMENT_TYPE : Rechte offene Verbindung ACCT_DOC_KEY."DEPARTMENT" = DEPARTMENT_TYPE."DEPARTMENT_TYPE_ID" ACCT_DOC_KEY - vPP65 : Linke offene Verbindung ACCT_DOC_KEY."PRODUCT_GROUP" = vPP65."PRODUCT_GROUP" ACCT_DOC_KEY - STRATEGIC_AREA : Linke offene Verbindung ACCT_DOC_KEY."STRATEGIC_AREA" = STRATEGIC_AREA."STRATEGIC_AREA_ID" ACCT_DOC_KEY - vPP5Q : Linke offene Verbindung ACCT_DOC_KEY."MAKE" = vPP5Q."MAKE_CD" UND ACCT_DOC_KEY."MODEL_LINE" = vPP5Q."MODEL_LINE" Benutzerklassen-Informationen Benutzerklasse: Ersteller Client/Server-Informationen Abfrageverarbeitung: Verbindungsdauer minimieren: Nein Gouverneur-Informationen Neue Berichte erstellen: Ja Ordner ändern: Ja Neue Benutzerklassen erstellen: Ja SQL-Direkteingabe: Ja Sortieren nicht-indizierter Spalten: Zulassen Offene Verbindungen: Zulassen 'Select Distinct': Zulassen 'Über-Kreuz'-Abfragen: Verhindern Tabellen pro Bericht beschränken Warnen bei: Stoppen bei: Anzahl der abgerufenen Datensätze beschränken Warnen bei: Stoppen bei: Abfrage-Ausführungszeit beschränken Warnen bei: Stoppen bei: Datenbankinformationen Eingabeaufforderung zum Datenbankschutz