User manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0
DON'T FORGET : ALWAYS READ THE USER GUIDE BEFORE BUYING !!!
If this document matches the user guide, instructions manual or user manual, feature sets, schematics you are looking for, download it now. Diplodocs provides you a fast and easy access to the user manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0. We hope that this BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0 user guide will be useful to you.
You may also download the following manuals related to this product:
BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0 BUSINESS GUIDE (864 ko)
Manual abstract: user guide BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0
Detailed instructions for use are in the User's Guide.
[. . . ] BusinessObjects Accounts Payable Rapid Mart User's Guide
Version 11. 5. 4. 0
Patents
Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Financial Document Type Filters: These filters restrict the Financial Document Type which is a dimension of Vendor Items. You can restrict to either Revenue or Payment document types.
BusinessObjects Accounts Payable Rapid Mart User Guide
137
5
Universe Customizing the Universe
Customizing the Universe
The universe can be modified easily to suit your specific needs.
De-Linking Vendor Totals Tables:
The VEND_PER_TTL_FACT and VEND_PER_TTL_FACT_VR tables are linked, with most dimensions joined to the VEND_PER_TTL_FACT table. We did this to simplify the universe design by creating only one context for Vendor Totals. In some cases, it may be advantageous for system performance to delink these tables, and create separate contexts for Vendor Totals (Vertical)and Vendor Totals (Horizontal). Duplicate all joins between VEND_PER_TTL_FACT and the dimension tables, but change the fact table in these joins to VEND_PER_TTL_FACT_VR Duplicate all joins between VEND_PER_TTL_FACT_VR and the dimension tables, but change the fact table in these joins to VEND_PER_TTL_FACT. Make sure all joins for VEND_PER_TTL_FACT are in the VEND_PER_TTL_FACT context. Make sure all joins for VEND_PER_TTL_FACT_VR are in the VEND_PER_TTL_FACT_VR context.
3.
4. 6.
View for DPO (Days Payables Outstanding) Calculation
The universe contains a database view VENDOR_ITEMS_AP_BALANCE_VIEW (on VENDOR_ITEMS_FACT). It is joined to the VEND_PER_TTL_FACT_VR table and used in the calculation of DPO (Days Payables Outstanding). The view was created so that we can obtain the open Accounts Payable balance for a vendor. The SQL to create this view is included with the target schema for the Rapid Mart in the SQL source file: AP_Create_Tables. sql For performance reasons, you may decide to create an aggregated fact table to replace the view.
138
BusinessObjects Accounts Payable Rapid Mart User Guide
Universe Customizing the Universe
5
1.
Create a fact table VENDOR_ITEMS_AP_BALANCE_FACT with the same columns included in the view. Make sure the columns have the same data types as their source columns in VENDOR_ITEMS_FACT table. In the Data Integrator job for the Rapid Mart, create a dataflow that runs immediately after the VENDOR_ITEMS_FACT table is populated. The new dataflow populates VENDOR_ITEMS_AP_BALANCE_FACT using the same logic used to create the view in SQL source file: AP_Create_Tables. sql In the Universe, replace VENDOR_ITEMS_AP_BALANCE_VIEW with VENDOR_ITEMS_AP_BALANCE_FACT, preserving the join to the VEND_PER_TTL_FACT_VR table. There are several objects in the Universe that need to be repointed from the view to the new fact table (highlighted below):
2.
3.
4.
5.
Save and export the universe.
BusinessObjects Accounts Payable Rapid Mart User Guide
139
5
Universe Universe Validation
Universe Validation
When validating the universe within the Universe Designer, some errors are expected and acceptable. They are detailed below.
Unlinked Tables
There are 7 tables that are not joined to other tables. This is because we use only aliases of those tables in the universe, or they are stand alone tables. For an alias, the original table must remain as a placeholder for the original table name. They are shown below.
Object Parsing
There are 40 objects that will fail validation. They are all template objects that must be customized to your specific needs. All but one of the remaining objects fail because they use the "@database" function, but will execute correctly in reports. Also, note that the error messages are specific to your database server. [. . . ] Rate Type
NVARCSTR
4
0
0
yes
27
Currency key for the group currency
NVARCSTR
5
0
0
yes
28
INTERNAL_ORDER_ID
Order number
NVARCSTR
12
0
0
yes
29
LINE_ITEM_ID
PK
Financial document line item number
NVARCSTR
5
0
0
no
30
LINE_ITEM_TEXT
Line item text
NVARCSTR
50
0
0
yes
31
LOAD_DATE
Date row was loaded into the target table.
DATETIME
24
0
9
yes
32
LOAD_TIME
Time row was loaded into the target table.
NVARCSTR
10
0
0
yes
33
LOCAL_CURRENCY _AMT
Amount in local currency
DECIMAL
48
13
2
yes
Rapid Mart Data Schema
28
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
34
LOCAL_CURRENCY_I D LOCAL_CURRENCY_T AX
Local (Company code) Currency ID
NVARCSTR
5
0
0
yes
35
Tax amount in local currency
DECIMAL
48
13
2
yes
36
MATERIAL_ID
PK
Material number
NVARCSTR
18
0
0
yes
37
POSTING_DATE
PK
Posting date in the document
DATETIME
24
0
9
no
38
POSTING_KEY_ID
Posting key
NVARCSTR
2
0
0
yes
39
PO_DOCUMENT_ID
PK
Purchasing document number
NVARCSTR
10
0
0
yes
40
PO_LINE_ITEM_ID
PK
Purchasing document line item
NVARCSTR
5
0
0
yes
41
REF_DOC_ID
Reference document number
NVARCSTR
16
0
0
yes
42
SPECIAL_GL_IND
Special G/L indicator
NVARCSTR
1
0
0
yes
43
SPECIAL_GL_TTYPE
Special G/L transaction type
NVARCSTR
1
0
0
yes
44
TRADING_PARTNER_I D
Trading partner ID
NVARCSTR
6
0
0
yes
45
UPDATE_DATE
Date of the last document update
DATETIME
24
0
9
yes
46
VENDOR_ID
PK
Vendor (creditor) account number
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
29
Appendix Table Column Details
A
VEND_OFFSET_FACT_BAD
Rejected financial documents which offset purchase orders
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCOUNT_TYPE
Account type
NVARCSTR
1
0
0
yes
2
ALLOC_ID
Allocation number
NVARCSTR
18
0
0
yes
3
ASSET_MAIN_NUMBE R ASSET_SUB_NUMB ER
Tax amount in document currency
NVARCSTR
12
0
0
yes
4
Asset subnumber
NVARCSTR
4
0
0
yes
5
BUSINESS_AREA_ID
TGSBGSBERBusiness area
NVARCSTR
4
0
0
yes
6
CHANGE_DATE
Date of the last document change by transaction
NVARCSTR
10
0
0
yes
7
CLEARED_FLAG
"O" = Open, "C" = Cleared (Closed)
NVARCSTR
1
0
0
yes
8
CLEARED_ON
Clearing date
NVARCSTR
10
0
0
yes
9
CLEARING_DOC_ID
Document number of the clearing document
NVARCSTR
10
0
0
yes
10
COMPANY_CODE_ID
Company code
NVARCSTR
4
0
0
no
11
COST_CENTER_ID
Cost center
NVARCSTR
10
0
0
yes
12
CTRL_AREA_ID
Controlling area
NVARCSTR
4
0
0
yes
13
CURRENCY_ID
TCURCWAERS Currency Key
NVARCSTR
5
0
0
yes
14
DEB_CRED_IND
Debit/credit indicator
NVARCSTR
1
0
0
yes
15
DI_ERRORACTION
DI Error Action
NVARCSTR
1
0
0
yes
16
DI_ERRORCOLUMNS
DI Error Columns
NVARCSTR
500
0
0
yes
Rapid Mart Data Schema
30
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
17
DOCUMENT_DATE
Date of the document
NVARCSTR
10
0
0
no
18
DOCUMENT_STATUS
Document status
NVARCSTR
1
0
0
yes
19
DOC_CURRENCY_A MT DOC_CURRENCY_T AX
Amount in document currency
DECIMAL
48
13
2
yes
20
Tax amount in document currency
DECIMAL
48
13
2
yes
21
ENTRY_DATE
Accounting document entry date
NVARCSTR
10
0
0
no
22
FINANCIAL_DOC_ID
Accounting document number
NVARCSTR
10
0
0
no
23
FIN_DOC_TYPE_ID
Document type
NVARCSTR
2
0
0
yes
24
FISCAL_PERIOD
Fiscal Period in SAP
DECIMAL
48
28
0
no
25
FISCAL_YEAR
Fiscal Year in SAP
NVARCSTR
4
0
0
no
26
FISC_YR_VARIANT_ID
Fiscal Year Variant in SAP
NVARCSTR
2
0
0
yes
27
GLOBAL_CURRENC Y_ID GLOBAL_EXCHANG E_TYPE_ID GROUP_CURRENCY _ID
Global Currency ID
NVARCSTR
5
0
0
yes
28
Global Exch. Rate Type
NVARCSTR
4
0
0
yes
29
Currency key for the group currency
NVARCSTR
5
0
0
yes
30
INTERNAL_ORDER_ID
Order number
NVARCSTR
12
0
0
yes
31
LINE_ITEM_ID
Financial document line item number
NVARCSTR
5
0
0
no
32
LINE_ITEM_TEXT
Line item text
NVARCSTR
50
0
0
yes
33
LOAD_DATE
Date row was loaded into the target table.
DATETIME
24
0
9
yes
Rapid Mart Data Schema
31
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
34
LOAD_TIME
Time row was loaded into the target table.
NVARCSTR
10
0
0
yes
35
LOCAL_CURRENCY _AMT LOCAL_CURRENCY_I D LOCAL_CURRENCY_T AX
Amount in local currency
DECIMAL
48
13
2
yes
36
Local (Company code) Currency ID
NVARCSTR
5
0
0
yes
37
Tax amount in local currency
DECIMAL
48
13
2
yes
38
MATERIAL_ID
Material number
NVARCSTR
18
0
0
yes
39
POSTING_DATE
Posting date in the document
NVARCSTR
10
0
0
no
40
POSTING_KEY_ID
Posting key
NVARCSTR
2
0
0
yes
41
PO_DOCUMENT_ID
Purchasing document number
NVARCSTR
10
0
0
yes
42
PO_LINE_ITEM_ID
Purchasing document line item
NVARCSTR
5
0
0
yes
43
REF_DOC_ID
Reference document number
NVARCSTR
16
0
0
yes
44
SPECIAL_GL_IND
Special G/L indicator
NVARCSTR
1
0
0
yes
45
SPECIAL_GL_TTYPE
Special G/L transaction type
NVARCSTR
1
0
0
yes
46
TRADING_PARTNER_I D
Trading partner ID
NVARCSTR
6
0
0
yes
47
UPDATE_DATE
Date of the last document update
NVARCSTR
10
0
0
yes
48
VENDOR_ID
Vendor (creditor) account number
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
32
Appendix Table Column Details
A
VENDOR
Vendor Information
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCOUNT_GRP_DE SC
Account group description
NVARCSTR
30
0
0
yes
2
ACCOUNT_GRP_ID
Account group ID
NVARCSTR
4
0
0
yes
3
ALT_PAYEE_ID
Account Number of alternate payee
NVARCSTR
10
0
0
yes
4
CITY
Vendor city
NVARCSTR
35
0
0
yes
5
COUNTRY_ID
Country ID
NVARCSTR
3
0
0
yes
6
COUNTRY_NAME
Country Name
NVARCSTR
15
0
0
yes
7
CREATE_DATE
Record create date
DATETIME
24
0
9
yes
8
CREDIT_INFO_ID
Credit Information Key
NVARCSTR
11
0
0
yes
9
CUSTOMER_ID
Customer ID if vendor is also customer
NVARCSTR
10
0
0
yes
10
DELETED_FLAG
Lookup Vendor Deleted Status Flag
NVARCSTR
5
0
0
yes
11
DISTRICT
District
NVARCSTR
35
0
0
yes
12
FAX
Fax number
NVARCSTR
31
0
0
yes
13
GROUP_ID
Optional vendor group assignment
NVARCSTR
10
0
0
yes
14
INDUSTRY_DESC
Description of industry
NVARCSTR
20
0
0
yes
15
INDUSTRY_ID
Industry
NVARCSTR
4
0
0
yes
16
LANGUAGE_ID
Language Key
NVARCSTR
1
0
0
yes
Rapid Mart Data Schema
33
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
17
ONE_TIME_ACCT_DE SC
Indicates if the account is a one time only vendor
NVARCSTR
5
0
0
yes
18
PLANT_ID
Plant
NVARCSTR
4
0
0
yes
19
PO_BOX
Post Office Box
NVARCSTR
10
0
0
yes
20
PO_BOX_CITY
PO Box City
NVARCSTR
35
0
0
yes
21
PO_BOX_ZIP
Postal code of PO Box (Zip Code)
NVARCSTR
10
0
0
yes
22
REGION_ID
Region ID
NVARCSTR
3
0
0
yes
23
REGION_NAME
Region Name (U. S. State)
NVARCSTR
20
0
0
yes
24
STREET
Street address
NVARCSTR
35
0
0
yes
25
TELEPHONE_1
First telephone number
NVARCSTR
16
0
0
yes
26
TELEPHONE_2
Second telephone number
NVARCSTR
16
0
0
yes
27
TRADING_PARTNER_I D
Trading partner ID
NVARCSTR
6
0
0
yes
28
VENDOR_ID
PK
Vendor number
NVARCSTR
10
0
0
no
29
VENDOR_NAME_1
Vendor name line 1
NVARCSTR
35
0
0
yes
30
VENDOR_NAME_2
Vendor name line 2
NVARCSTR
35
0
0
yes
31
VENDOR_TITLE
Vendor title
NVARCSTR
15
0
0
yes
32
ZIP
Zip Code (Postal Code)
NVARCSTR
20
0
0
yes
Rapid Mart Data Schema
34
Appendix Table Column Details
A
VENDOR_BY_COMPANY
General vendor master data at the vendor at company code level
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
ACCOUNTING_CLERK PK
T001S. BUSAB Accounting clerk
NVARCSTR
2
0
0
yes
2
ACCT_GRP_ONE_TIM E
LFA1. KTOCK Reference account group for onetime account (vendor) LFA1. LNRZA Account number of the alternative payee
NVARCSTR
4
0
0
yes
3
ALT_PAYEE_ID
NVARCSTR
10
0
0
yes
4
CENTRAL_DELETE_B LOCK CENTRAL_PAYMENT_ BLOCK CENTRAL_POSTING_ BLOCK_ID CENTRAL_PURCHASI NG_BLOCK CHART_OF_ACCTS_I PK D
LFA1. NODEL Central Deletion Block
NVARCSTR
1
0
0
yes
5
LFA1. SPERZ Central Payment Block
NVARCSTR
1
0
0
yes
6
LFA1. SPERR Central Posting Block
NVARCSTR
1
0
0
yes
7
LFA1. SPERM Central Purchasing Block
NVARCSTR
1
0
0
yes
8
T001. KTOPL Chart of Accounts (Company Code)
NVARCSTR
4
0
0
yes
9
COMPANY_CODE_ID
PK
LFB1BUKRS Company code
NVARCSTR
4
0
0
no
10
COMP_CODE_DELETI ON_BLOCK COMP_CODE_POST ING_BLOCK
LFB1. NODEL Company Code Level Deletion NVARCSTR Blcok LFB1. SPERR Company Code Level Posting Block
1
0
0
yes
11
NVARCSTR
1
0
0
yes
12
CREDIT_INFO_ID
LFA1. KRAUS Credit information number
NVARCSTR
11
0
0
yes
13
CUSTOMER_ID
LFA1. KUNNR Customer number
NVARCSTR
10
0
0
yes
14
DELETED_IND
LFB1. LOEVM Central deletion flag for master record
NVARCSTR
1
0
0
yes
15
FACTORY_CAL_ID
LFA1. PLKAL Factory calendar key
NVARCSTR
2
0
0
yes
16
GL_RECONCILE_ACC PK T
SKB1. SAKNR Account Code
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
35
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
17
HOUSE_BANK_ID
LFB1. HBKID ID for one house bank
NVARCSTR
5
0
0
yes
18
INTL_LOC_NUM_1
LFA1BBBNR International location number (part 1) LFA1BBBSR International location number (part 2) LFB1. EIKTO Our account number at the vendor
NVARCSTR
7
0
0
yes
19
INTL_LOC_NUM_2
NVARCSTR
5
0
0
yes
20
OUR_ACCOUNT_NUM
NVARCSTR
12
0
0
yes
21
PAYMENT_BLOCK_IN D
LFB1. ZAHLS Block key for payment
NVARCSTR
1
0
0
yes
22
PAYMENT_TERMS_ID PK
Payment terms key
NVARCSTR
4
0
0
yes
23
PLANT_ID
PK
T001W. WERKS Plant
NVARCSTR
4
0
0
yes
24
POR_ID
LFA1. ESRNR POR subscriber number
NVARCSTR
11
0
0
yes
25
SOLE_PROPR_IND
LFA1. STKZN Indicator if partner is a sole proprietor
NVARCSTR
1
0
0
yes
26
TAX_JURIS_ID
LFA1. TXJCD Jurisdiction for tax calculation NVARCSTR tax jurisdiction code
15
0
0
yes
27
TAX_NUM_1
LFA1. STCD1 Tax number 1
NVARCSTR
16
0
0
yes
28
TAX_NUM_2
LFA1. STCD2 Tax number 2
NVARCSTR
11
0
0
yes
29
VAT_REG_NUM
LFA1. STCEG VAT registration number
NVARCSTR
20
0
0
yes
30
VENDOR_ID
PK
LFA1LIFNR Vendor (creditor) account number
NVARCSTR
10
0
0
no
Rapid Mart Data Schema
36
Appendix Table Column Details
A
VENDOR_ITEMS_AP_BALANCE_VIEW
Vendor Items AP Balance View
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
COMPANY_CODE_ID
Company code
NVARCSTR
4
0
0
no
2
FISCAL_PERIOD
Fiscal Period in SAP
DECIMAL
48
28
0
yes
3
FISCAL_YEAR
Fiscal Year in SAP
NVARCSTR
4
0
0
no
4
ROLLING_12_TTL
Rolling 12 Period Total Local Currency
DECIMAL
48
28
7
yes
5
SALES_TTL
Total Sales per Period (Local Currency)
DECIMAL
48
28
7
yes
6
SUM_LOCAL_CURR ENCY_AMT SUM_LOCAL_CURR ENCY_TAX SUM_TOTAL_AMT_DU E
Sum of Local Currency Amount
DECIMAL
48
28
7
yes
7
Sum of Local Currency tax amount
DECIMAL
48
28
7
yes
8
Sum of (Local Currency Amt + Local Currency Tax Amt)
DECIMAL
48
28
7
yes
9
VENDOR_ID
Vendor
NVARCSTR
10
0
0
no
Rapid Mart Data Schema
37
Appendix Table Column Details
A
VENDOR_ITEMS_FACT
Financial documents (such as invoices and payments) regarding vendors
# Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable
1
AGING_INTERVAL_ID PK
Aging Interval ID
DECIMAL
48
28
0
yes
2
ALLOC_ID
PK
Allocation ID
NVARCSTR
18
0
0
no
3
AMT_DUE_IN_E_DAY S AMT_DUE_IN_F_DAY S AMT_DUE_IN_G_DAY S AMT_DUE_OVER_G _DAYS
Amount Due in upto "E" Days
DECIMAL
48
13
2
yes
4
Amt Due between "E" and "F" days
DECIMAL
48
13
2
yes
5
Amt Due between "F" and "G" days
DECIMAL
48
13
2
yes
6
Amount due in more than interval "G" days
DECIMAL
48
13
2
yes
7
AMT_ELIG_FOR_DISC
Amount of invoice that can be discounted as appropriate Local currency amount paid during the first discount period (includes any discounts applicable) Local currency amount paid after the first and during the second discount period (includes any discounts applicable) Paid after due date Local currency amount paid before due date and after any discount periods (includes only nontimerelated discounts Local currency amount paid by due date (includes any discounts applicable) Local currency amount paid after the first measuring period after due date Local currency amount paid after the second measuring period after due date Local currency amount paid after the third measuring period after due date Local currency amount paid after the fourth measuring period after due date
DECIMAL
48
13
2
yes
8
AMT_PAID_DISCOUN T1 AMT_PAID_DISCOUN T2
DECIMAL
48
13
2
yes
9
DECIMAL
48
13
2
yes
10
AMT_PAID_LATE
DECIMAL
48
13
2
yes
11
AMT_PAID_NET
DECIMAL
48
13
2
yes
12
AMT_PAID_ON_TIME
DECIMAL
48
13
2
yes
13
AMT_PD_GT_A_LATE
DECIMAL
48
13
2
yes
14
AMT_PD_GT_B_LATE
DECIMAL
48
13
2
yes
15
AMT_PD_GT_C_LATE
DECIMAL
48
13
2
yes
16
AMT_PD_GT_D_LATE
DECIMAL
48
13
2
yes
Rapid Mart Data Schema
38
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
17
BASELINE_DATE
Date from which all due and late dates are calculated Document number of the associated billing document
DATETIME
24
0
9
yes
18
BILLING_DOC_ID
NVARCSTR
10
0
0
yes
19
BUSINESS_AREA_ID
PK
TGSBGSBERBusiness area
NVARCSTR
4
0
0
yes
20
CASH_DISCOUNT_1
Amount of discount eligible if paid by first discount period Amount of discount eligible if paid by second discount period T001. KTOPL Chart of Accounts (Company Code)
DECIMAL
48
5
3
yes
21
CASH_DISCOUNT_2
DECIMAL
48
5
3
yes
22
CHART_OF_ACCTS_I PK D
NVARCSTR
4
0
0
yes
23
CLEARED_FLAG
PK
"O" if item is open "C" if item is cleared
NVARCSTR
1
0
0
yes
24
CLEARED_ON
PK
Date document cleared
DATETIME
24
0
9
no
25
CLEARING_DOC_ID
PK
Document number of the clearing document
NVARCSTR
10
0
0
no
26
COMPANY_CODE_ID
PK
Company code
NVARCSTR
4
0
0
no
27
CURRENCY_ID
PK
TCURCWAERS Currency Key
NVARCSTR
5
0
0
yes
28
DEB_CRED_IND
Debit or credit indicator
NVARCSTR
1
0
0
yes
29
DISCOUNT_PERIOD_ 1 DISCOUNT_PERIOD_ 2
Number of days in the first discount period
DECIMAL
48
28
0
yes
30
Number of days in the second discount period
DECIMAL
48
28
0
yes
31
DISC_AMT_TAKEN
Discount amount taken
DECIMAL
48
13
2
yes
32
DOCUMENT_DATE
Date of the actual document
DATETIME
24
0
9
yes
33
DOC_CURRENCY_A MT
Amount in document currency
DECIMAL
48
13
2
yes
Rapid Mart Data Schema
39
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
34
DOC_CURRENCY_T AX
Tax amount in document currency
DECIMAL
48
13
2
yes
35
ENTRY_DATE
Date of entry by accounting
DATETIME
24
0
9
yes
36
FINANCIAL_DOC_ID
PK
Financial document number
NVARCSTR
10
0
0
no
37
FIN_DOC_TYPE_ID
Financial document type
NVARCSTR
2
0
0
yes
38
FISCAL_PERIOD
PK
Fiscal Period in SAP
DECIMAL
48
28
0
yes
39
FISCAL_YEAR
PK
Fiscal Year in SAP
NVARCSTR
4
0
0
no
40
FISC_YR_VARIANT_ID PK
Fiscal Year Variant in SAP
NVARCSTR
2
0
0
yes
41
GLOBAL_CURRENC Y_ID GLOBAL_EXCHANG E_TYPE_ID
Global Currency ID from $G_GLOBAL_CURRENCY variable Global Exchg. Rate Type from $G_EXCHANGE_TYPE_ID variable
NVARCSTR
5
0
0
yes
42
NVARCSTR
4
0
0
yes
43
GL_ACCOUNT_ID
PK
SKB1. SAKNR Account Code
NVARCSTR
10
0
0
yes
44
GROUP_CURRENCY _ID
BKPF. KZWRS Group Currency ID
NVARCSTR
5
0
0
yes
45
HOUSE_BANK_ID
ID for one house bank
NVARCSTR
5
0
0
yes
46
INVOICE_ID
Document number of associated invoice
NVARCSTR
10
0
0
yes
47
LINE_ITEM_ID
PK
Financial document line item number
NVARCSTR
5
0
0
no
48
LINE_ITEM_TEXT
Descriptive text of the line item
NVARCSTR
50
0
0
yes
49
LOAD_DATE
Date that this row was loaded into the data warehouse Time that this row was loaded into the data warehouse
DATETIME
24
0
9
yes
50
LOAD_TIME
NVARCSTR
10
0
0
yes
Rapid Mart Data Schema
40
Appendix Table Column Details
Column Datatype Dtype Length Precision Scale
A
#
Column Name
Key
Column Desc
Is Nullable
51
LOCAL_CURRENCY _AMT LOCAL_CURRENCY_I D LOCAL_CURRENCY_T AX
Amount in local (company) currency
DECIMAL
48
13
2
yes
52
BKPF. HWAER Local Currency ID
NVARCSTR
5
0
0
yes
53
Tax amount in local (company) currency
DECIMAL
48
13
2
yes
54
NET_DUE_DATE
Baseline date + Net due period in days
DATETIME
24
0
9
yes
55
NET_DUE_PERIOD
Number of days between second discount period and net due date (SAP value)
DECIMAL
48
28
0
yes
56
NEW_NET_DUE_PERI OD
Creates new net due period for those payment DECIMAL terms that leave the net due period blank. [. . . ]
DISCLAIMER TO DOWNLOAD THE USER GUIDE BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0
Click on "Download the user Manual" at the end of this Contract if you accept its terms, the downloading of the manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART 11.5.4.0 will begin.