GAPS/Portal/System/IQD/SKR51_Finanzen_neu.icr

						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