User manual BUSINESS OBJECTS ACCOUNTS PAYABLE RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0

[. . . ] SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2, version for SAP solutions - User Guide Version 12. 2. 0. 0 October 2009 Copyright © Copyright 2009 SAP AG. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. [. . . ] The Currency source indicates which currency was used as a source for the 2nd or 3rd Local currency. The exchange rate is determined from this source currency to the 2nd or 3rd local currency. Standard Values: · · 1 = Translation taking first local currency as basis, i. e. , the main Local Currency or Company Code Currency was used as the currency source. 2 = Translation taking transaction (or document) currency as basis. Currency Types Currency Types for 2nd and 3rd Local Currencies. Key identifying the role of a currency in the R/3 System. In addition to the local currency as house currency, you can manage parallel currencies with the following currency types: 200 SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2 for SAP solutions User Guide Universe SAP Master Data Universe 5 · · · · Group currency Hard currency Index currency Global company currency Monetary Currencies The Rapid Marts maintain various currencies, including: · · · Benefit Currency - The monetary currency associated with personnel administration. Controlling Area Currency - The monetary currency assigned to the controlling area Group Currency - Group currency is used in the consolidated financial statements. Before the consolidation process can be completed all values in the individual financial statements must be translated from the local or transaction currency into group currency. Local (Company Code) Currency - The monetary currency assigned to the company code Transaction (Document) Currency - The monetary currency of each individual transaction document. Update Currency - Used for Euro conversion in European Union: The update currency is the currency, in addition to the local (company) currency, in which the transaction figures are updated in the general ledger. You specify whether the document or account currencies should also be the update currency in the G/L account master record. · · · Monetary Exchange Rates These are the conversion rates used to convert one currency to another. They are used to compute global currency amounts in the universe. MRP Material Resource Planning - A term for procedures in requirements planning that take into account and plan every future requirement during the creation of order proposals such as independent requirements, and dependent requirements. Contains the following sub-classes: Mrp Controller The person responsible for a group of materials in MRP in a plant or company. Material that takes part in material requirements planning must be assigned to an MRP controller. SAP BusinessObjects Accounts Payable Rapid Mart XI 3. 2 for SAP solutions User Guide 201 5 Universe SAP Master Data Universe Mrp Element Type A term for all objects displayed as items in the MRP list or in the stock and requirements list. Such objects include planned orders, purchase orders, reservations, and sales orders. Mrp Group The MRP group, groups material from the material requirements planning point of view to allocate them control parameters for planning. The control parameters include the strategy group, the planning horizon and the creation indicator for the planning run. Mrp Lot Size A key that defines which lot-sizing procedure the system uses for calculating the quantity to procure in the MRP run. Mrp Profile A collection of data required for updating the material master record for planning. The MRP profile contains the necessary MRP data for the material master. This simplifies updating the material master record. When creating or changing a material master, the data in the MRP profile is copied automatically to the material master. The MRP profile defines: · · · Which fields are mandatory when entering MRP data Values of these fields Which values can be overwritten (default values) or not (fixed values) Mrp Type A key that controls the MRP procedure (MRP or reorder point) used for planning a material. [. . . ] of Reconciliation account in G/L accounting SKB1. SAKNR - Account Code (Reconciliation account in G/L accounting) LFA1-BBBNR -- International location number (part 1) LFA1-BBBSR -- International location number (part 2) Date that this row was loaded into the data warehouse Time that this row was loaded into the data warehouse NVARCSTR 1 0 0 yes 22 NVARCSTR 60 0 0 yes 23 NVARCSTR 10 0 0 yes 24 NVARCSTR 7 0 0 yes 25 NVARCSTR 5 0 0 yes 26 LOAD_DATE DATETIME 24 0 9 yes 27 LOAD_TIME NVARCSTR 10 0 0 yes 28 ONETIME_ACCT_FLA G LFA1. XCPDK - One Time Account flag NVARCSTR 1 0 0 yes 29 OUR_ACCT_NUM LFB1. EIKTO -- Our account number at the vendor NVARCSTR 12 0 0 yes 30 PAYMNT_BLOCK_D ESCR PAYMNT_BLOCK_FLA G_CENTRAL T008T. TEXTL - Payment Block Description NVARCSTR 20 0 0 yes 31 LFA1. SPERZ - Central Payment Block NVARCSTR 1 0 0 yes 32 PAYMNT_BLOCK_ID LFB1. ZAHLS -- Block key for payment NVARCSTR 1 0 0 yes 33 PAYMNT_TERM_DE SCR TVZBT. VTEXT - Standard Payment term description NVARCSTR 50 0 0 yes 34 PAYMNT_TERM_ID LFB1. ZTERM - Payment terms key NVARCSTR 4 0 0 yes Rapid Mart Data Schema 66 Appendix Table Column Details A 35 PLANT_ID LFA1-WERKS Plant NVARCSTR 4 0 0 yes 36 PLANT_NAME T001W. NAME1 - Plant Name NVARCSTR 30 0 0 yes 37 POR_NUM LFA1. ESRNR -- POR subscriber number NVARCSTR 11 0 0 yes 38 POST_BLOCK_FLAG LFB1. SPERR - Company Code Level Posting Block NVARCSTR 1 0 0 yes 39 POST_BLOCK_FLAG_ CENTRAL PURCH_BLOCK_FLAG _CENTRAL LFA1. SPERR - Central Posting Block NVARCSTR 1 0 0 yes 40 LFA1. SPERM - Central Purchasing Block NVARCSTR 1 0 0 yes 41 SOLE_PROPR_FLAG LFA1. STKZN -- Indicator if partner is a sole proprietor NVARCSTR 1 0 0 yes 42 TAX_JURISDIC_NUM LFA1. TXJCD -- Jurisdiction for tax calculation - NVARCSTR tax jurisdiction code 15 0 0 yes 43 TAX_NUM_01 LFA1. STCD1 -- Tax number 1 NVARCSTR 16 0 0 yes 44 TAX_NUM_02 LFA1. STCD2 -- Tax number 2 NVARCSTR 11 0 0 yes 45 VAT_REGISTRTN_NU M VENDOR_FULL_NA ME LFA1. STCEG -- VAT registration number NVARCSTR 20 0 0 yes 46 LFA1. NAME1+ LFA1. LIFNR - Full Name NVARCSTR 120 0 0 yes 47 VENDOR_ID PK LFA1. LIFNR NVARCSTR 10 0 0 no 48 VENDOR_ID_ALT_PA YEE LFA1. LNRZA -- Account number of the alternative payee NVARCSTR 10 0 0 yes 49 VENDOR_NAME LFA1. NAME1 - Vendor Name 1 NVARCSTR 40 0 0 yes Rapid Mart Data Schema 67 Appendix Table Column Details A VENDOR_FIN_DOC_FACT BKPF / BSEG - Payables related Financial Documents # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACCT_TYPE_ID BSEG-KOART - Account type NVARCSTR 10 0 0 yes 2 ALLOCTN_ID BSEG-ZUONR - Allocation number NVARCSTR 18 0 0 yes 3 AMT_LOC BSEG-DMBTR - Amount in local currency DECIMAL 48 13 2 yes 4 AMT_TAX_LOC BSEG-MWSTS - Tax amount in local currency DECIMAL 48 13 2 yes 5 AMT_TAX_TRX BSEG-WMWST - Tax amount in document currency BSEG-WRBTR - Amount in document currency DECIMAL 48 13 2 yes 6 AMT_TRX DECIMAL 48 13 2 yes 7 ASSET_MAIN_ID BSEG-ANLN1 - Asset main number NVARCSTR 12 0 0 yes 8 ASSET_SUB_ID BSEG-ANLN2 - Asset sub-number NVARCSTR 4 0 0 yes 9 BUS_AREA_ID BKPF-GSBER - Business area NVARCSTR 4 0 0 yes 10 CHANGE_DATE BKPF-AEDAT - Date of the last document change by transaction DATETIME 24 0 9 yes 11 CLEARED_DATE BSEG-AUGDT - Clearing date DATETIME 24 0 9 yes 12 CLEARED_FLAG "O" = Open, "C" = Cleared (Closed) NVARCSTR 1 0 0 yes 13 CLEARNG_DOC_ID BSEG-AUGBL - Document number of the clearing document NVARCSTR 10 0 0 yes 14 CMPNY_CODE_ID PK BKPF-BUKRS - Company code NVARCSTR 4 0 0 no 15 COST_CNTR_ID BSEG-KOSTL - Cost center NVARCSTR 10 0 0 yes 16 CTRL_AREA_ID BSEG-KOKRS - Controlling area NVARCSTR 4 0 0 yes Rapid Mart Data Schema 68 Appendix Table Column Details A 17 CURR_ID_GBL Global Currency ID NVARCSTR 5 0 0 yes 18 CURR_ID_GRP BKPF-KZWRS - Currency key for the group currency NVARCSTR 5 0 0 yes 19 CURR_ID_LOC Local (Company code) Currency ID NVARCSTR 5 0 0 yes 20 CURR_ID_TRX BKPF-WAERS - Currency key NVARCSTR 5 0 0 yes 21 DOC_DATE PK BKPF-BLDAT - Date of the document DATETIME 24 0 9 no 22 DOC_TYPE_ID BKPF-BLART - Document type NVARCSTR 2 0 0 yes 23 DR_CR_ID BSEG-SHKZG - Debit/credit indicator NVARCSTR 10 0 0 yes 24 ENTRY_DATE BKPF-CPUDT - Accounting document entry date DATETIME 24 0 9 yes 25 EXCH_TYPE_ID_GBL Global Exch. Rate Type NVARCSTR 4 0 0 yes 26 FIN_DOC_ID PK BKPF-BELNR - Accounting document number NVARCSTR 10 0 0 no 27 FIN_DOC_STATUS_ID BKPF-BSTAT - Document status NVARCSTR 10 0 0 yes 28 FISC_PERIOD PK BKPF-MONAT - Fiscal period INTEGER 4 0 0 no 29 FISC_YEAR PK BKPF-GJAHR - Fiscal year INTEGER 4 0 0 no 30 FISC_YR_VARIANT_ID Fiscal Year Variant in SAP NVARCSTR 2 0 0 yes 31 INTERNAL_ORDER_ID BSEG-AUFNR - Order number NVARCSTR 12 0 0 yes 32 LINE_ITEM_ID PK BSEG-BUZEI - Line item number within the accounting document NVARCSTR 3 0 0 no 33 LINE_ITEM_TXT BSEG-SGTXT - Line item text NVARCSTR 50 0 0 yes 34 LOAD_DATE Load date DATETIME 24 0 9 yes Rapid Mart Data Schema 69 Appendix Table Column Details A 35 LOAD_TIME Load Time NVARCSTR 8 0 0 yes 36 MATERIAL_ID BSEG-MATNR - Material number NVARCSTR 18 0 0 yes 37 PLANT_ID BSEG. WERKS - Plant NVARCSTR 4 0 0 yes 38 POST_DATE PK BKPF-BUDAT - Posting date in the document DATETIME 24 0 9 no 39 POST_KEY_ID BSEG-BSCHL - Posting key NVARCSTR 2 0 0 yes 40 PURCH_DOC_ID BSEG-EBELN - Purchasing document number NVARCSTR 10 0 0 yes 41 PURCH_LINE_ITEM_I D BSEG-EBELP - Item number of purchasing document NVARCSTR 5 0 0 yes 42 REF_DOC_ID BKPF-XBLNR - Reference document number NVARCSTR 16 0 0 yes 43 SPECL_GL_ID BSEG-UMSKZ - Special G/L indicator NVARCSTR 1 0 0 yes 44 SPECL_GL_TRX_TYP E TRADING_PARTNER_I D BSEG-UMSKS - Special G/L transaction type NVARCSTR 1 0 0 yes 45 BSEG-VBUND - Trading partner ID NVARCSTR 6 0 0 yes 46 UPDT_DATE BKPF-UPDDT - Date of the last document update BSEG-LIFNR - Vendor (creditor) account number DATETIME 24 0 9 yes 47 VENDOR_ID NVARCSTR 10 0 0 yes Rapid Mart Data Schema 70 Appendix Table Column Details A VENDOR_FIN_DOC_FACT_BAD BKPF / BSEG - Invalid Payables related Financial Documents # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACCT_TYPE_ID BSEG-KOART - Account type NVARCSTR 10 0 0 yes 2 ALLOCTN_ID BSEG-ZUONR - Allocation number NVARCSTR 18 0 0 yes 3 AMT_LOC BSEG-DMBTR - Amount in local currency DECIMAL 48 13 2 yes 4 AMT_TAX_LOC BSEG-MWSTS - Tax amount in local currency DECIMAL 48 13 2 yes 5 AMT_TAX_TRX BSEG-WMWST - Tax amount in document currency BSEG-WRBTR - Amount in document currency DECIMAL 48 13 2 yes 6 AMT_TRX DECIMAL 48 13 2 yes 7 ASSET_MAIN_ID BSEG-ANLN1 - Asset main number NVARCSTR 12 0 0 yes 8 ASSET_SUB_ID BSEG-ANLN2 - Asset sub-number NVARCSTR 4 0 0 yes 9 BUS_AREA_ID BKPF-GSBER - Business area NVARCSTR 4 0 0 yes 10 CHANGE_DATE BKPF-AEDAT - Date of the last document change by transaction NVARCSTR 10 0 0 yes 11 CLEARED_DATE BSEG-AUGDT - Clearing date NVARCSTR 10 0 0 yes 12 CLEARED_FLAG "O" = Open, "C" = Cleared (Closed) NVARCSTR 1 0 0 yes 13 CLEARNG_DOC_ID BSEG-AUGBL - Document number of the clearing document NVARCSTR 10 0 0 yes 14 CMPNY_CODE_ID PK BKPF-BUKRS - Company code NVARCSTR 4 0 0 no 15 COST_CNTR_ID BSEG-KOSTL - Cost center NVARCSTR 10 0 0 yes 16 CTRL_AREA_ID BSEG-KOKRS - Controlling area NVARCSTR 4 0 0 yes Rapid Mart Data Schema 71 Appendix Table Column Details A 17 CURR_ID_GBL Global Currency ID NVARCSTR 5 0 0 yes 18 CURR_ID_GRP BKPF-KZWRS - Currency key for the group currency NVARCSTR 5 0 0 yes 19 CURR_ID_LOC Local (Company code) Currency ID NVARCSTR 5 0 0 yes 20 CURR_ID_TRX BKPF-WAERS - Currency key NVARCSTR 5 0 0 yes 21 DI_ERROR_ACTN DI Error Action NVARCSTR 1 0 0 yes 22 DI_ERROR_COLUMN DI Error Columns NVARCSTR 500 0 0 yes 23 DOC_DATE PK BKPF-BLDAT - Date of the document NVARCSTR 10 0 0 no 24 DOC_TYPE_ID BKPF-BLART - Document type NVARCSTR 2 0 0 yes 25 DR_CR_ID BSEG-SHKZG - Debit/credit indicator NVARCSTR 1 0 0 yes 26 ENTRY_DATE BKPF-CPUDT - Accounting document entry date NVARCSTR 10 0 0 yes 27 EXCH_TYPE_ID_GBL Global Exch. Rate Type NVARCSTR 4 0 0 yes 28 FIN_DOC_ID PK BKPF-BELNR - Accounting document number NVARCSTR 10 0 0 no 29 FIN_DOC_STATUS_ID BKPF-BSTAT - Document status NVARCSTR 10 0 0 yes 30 FISC_PERIOD PK BKPF-MONAT - Fiscal period INTEGER 4 0 0 no 31 FISC_YEAR PK BKPF-GJAHR - Fiscal year DECIMAL 48 28 0 no 32 FISC_YR_VARIANT_ID Fiscal Year Variant in SAP NVARCSTR 2 0 0 yes 33 INTERNAL_ORDER_ID BSEG-AUFNR - Order number NVARCSTR 12 0 0 yes 34 LINE_ITEM_ID PK BSEG-BUZEI - Line item number within the accounting document NVARCSTR 3 0 0 no Rapid Mart Data Schema 72 Appendix Table Column Details A 35 LINE_ITEM_TXT BSEG-SGTXT - Line item text NVARCSTR 50 0 0 yes 36 LOAD_DATE PK Load date DATETIME 24 0 9 no 37 LOAD_TIME Load Time NVARCSTR 8 0 0 yes 38 MATERIAL_ID BSEG-MATNR - Material number NVARCSTR 18 0 0 yes 39 PLANT_ID BSEG. WERKS - Plant NVARCSTR 4 0 0 yes 40 POST_DATE PK BKPF-BUDAT - Posting date in the document NVARCSTR 10 0 0 no 41 POST_KEY_ID BSEG-BSCHL - Posting key NVARCSTR 2 0 0 yes 42 PURCH_DOC_ID BSEG-EBELN - Purchasing document number NVARCSTR 10 0 0 yes 43 PURCH_LINE_ITEM_I D BSEG-EBELP - Item number of purchasing document NVARCSTR 5 0 0 yes 44 REF_DOC_ID BKPF-XBLNR - Reference document number NVARCSTR 16 0 0 yes 45 SPECL_GL_ID BSEG-UMSKZ - Special G/L indicator NVARCSTR 1 0 0 yes 46 SPECL_GL_TRX_TYP E TRADING_PARTNER_I D BSEG-UMSKS - Special G/L transaction type NVARCSTR 1 0 0 yes 47 BSEG-VBUND - Trading partner ID NVARCSTR 6 0 0 yes 48 UPDT_DATE BKPF-UPDDT - Date of the last document update BSEG-LIFNR - Vendor (creditor) account number NVARCSTR 10 0 0 yes 49 VENDOR_ID NVARCSTR 10 0 0 yes Rapid Mart Data Schema 73 Appendix Table Column Details A VENDOR_ITEM_AP_BALANCE_VIEW The view determines the Open AP Bal per fiscal period. # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 AMT_PER_ROLLING_ LOC Sum Local Currency Rolling Periods Amount DECIMAL 48 28 7 yes 2 AMT_TTL_DUE_LOC Sum of (Local Currency Amount + Local Currency Tax Amount) DECIMAL 48 28 7 yes 3 AMT_TTL_LOC Sum of Local Currency Amount DECIMAL 48 28 7 yes 4 AMT_TTL_SALES_LO C Sum of Local Currency Sales Amount DECIMAL 48 28 7 yes 5 AMT_TTL_TAX_LOC Sum of Local Currency Tax Amount DECIMAL 48 28 7 yes 6 CMPNY_CODE_ID Company code NVARCSTR 4 0 0 no 7 FISC_PERIOD Fiscal period INTEGER 4 4 0 yes 8 FISC_YEAR Fiscal year INTEGER 4 4 0 no 9 VENDOR_ID Vendor NVARCSTR 10 0 0 no Rapid Mart Data Schema 74 Appendix Table Column Details A VENDOR_ITEM_FACT BSIK / BSAK - Open and Closed Vendor Items # Column Name Key Column Desc Column Datatype Dtype Length Precision Scale Is Nullable 1 ACCTNG_CLERK_ID SKB1. BUSAB - Accounting clerk ID NVARCSTR 2 0 0 yes 2 AGING_INTERVAL_ID Aging Interval ID DECIMAL 48 28 0 yes 3 ALLOCATN_ID PK Allocation ID NVARCSTR 18 0 0 no 4 AMT_DISCNT_TAKEN _LOC AMT_DUE_IN_E_DAY S_LOC AMT_DUE_IN_F_DAY S_LOC AMT_DUE_IN_G_DAY S_LOC AMT_DUE_OVER_G _DAYS_LOC AMT_ELIGBL_FOR_DI SCNT_TRX Discount amount taken DECIMAL 48 13 2 yes 5 Value of the invoice if paid within the first forecast period Value of the invoice if paid within the second forecast period Value of the invoice if paid within the third forecast period DECIMAL 48 13 2 yes 6 DECIMAL 48 13 2 yes 7 DECIMAL 48 13 2 yes 8 Amount due in more than interval "G" days DECIMAL 48 13 2 yes 9 Amount of invoice that can be discounted as appropriate DECIMAL 48 13 2 yes 10 AMT_LOC Amount in local (company) currency 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 non-time-related discounts Local currency amount paid by due date (includes any discounts applicable) Local currency amount if the first measuring period after net due date has past DECIMAL 48 13 2 yes 11 AMT_PAID_DISCNT_P ER01_LOC AMT_PAID_DISCNT_P ER02_LOC DECIMAL 48 13 2 yes 12 DECIMAL 48 13 2 yes 13 AMT_PAID_LATE_LOC DECIMAL 48 13 2 yes 14 AMT_PAID_NET_LOC DECIMAL 48 13 2 yes 15 AMT_PAID_ON_TIME_ LOC AMT_PAST_DUE_GT_ A_LOC DECIMAL 48 13 2 yes 16 DECIMAL 48 13 2 yes Rapid Mart Data Schema 75 Appendix Table Column Details AMT_PAST_DUE_GT_ B_LOC AMT_PAST_DUE_GT_ C_LOC AMT_PAST_DUE_GT_ D_LOC AMT_PD_GT_A_LATE _LOC AMT_PD_GT_B_LATE _LOC AMT_PD_GT_C_LATE _LOC AMT_PD_GT_D_LATE _LOC Local currency amount if the second measuring DECIMAL period after net due date has past Local currency amount if the third measuring period after net due date has past Local currency amount if the fourth measuring period after net due date has past 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 A 17 48 13 2 yes 18 DECIMAL 48 13 2 yes 19 DECIMAL 48 13 2 yes 20 DECIMAL 48 13 2 yes 21 DECIMAL 48 13 2 yes 22 DECIMAL 48 13 2 yes 23 DECIMAL 48 13 2 yes 24 AMT_TAX_LOC Tax amount in local (company) currency DECIMAL 48 13 2 yes 25 AMT_TAX_TRX Tax amount in document currency DECIMAL 48 13 2 yes 26 AMT_TRX Amount in document currency DECIMAL 48 13 2 yes 27 AMT_TTL_PAST_DUE _LOC Local currency amount where net due date is past BSIK. PSWBT or BSAK. PSWBT - Update Currency Amt. Past Due * Number of Days Past Due DECIMAL 48 13 2 yes 28 AMT_UPDT DECIMAL 48 13 2 yes 29 AMT_WEIGHT_PAST_ DUE_LOC DECIMAL 48 15 2 yes 30 BANK_ID_HOUSE ID for one house bank NVARCSTR 5 0 0 yes 31 BASELINE_DATE Date from which all due and late dates are calculated Document number of the associated billing document DATETIME 24 0 9 yes 32 BILLING_DOC_ID NVARCSTR 10 0 0 yes 33 BUS_AREA_ID Business area NVARCSTR 4 0 0 yes 34 CASH_DISCNT_PRCN T_01 Discount Percent if paid by first discount period DECIMAL 48 5 3 yes Rapid Mart Data Schema 76 Appendix Table Column Details CASH_DISCNT_PRCN T_02 Discount Percent if paid by second discount period T001. KTOPL - Chart of Accounts (Company Code) A 35 DECIMAL 48 5 3 yes 36 CHART_OF_ACCT_ID NVARCSTR 4 0 0 yes 37 CLEARED_DATE PK Date document cleared DATETIME 24 0 9 no 38 CLEARED_FLAG "O" if item is open; "C" if item is cleared NVARCSTR 1 0 0 yes 39 CLEARNG_DOC_ID PK Document number of the clearing document NVARCSTR 10 0 0 no 40 CMPNY_CODE_ID PK Company code NVARCSTR 4 0 0 no 41 CURR_ID_GBL Global Currency ID from $G_GLOBAL_CURRENCY variable NVARCSTR 5 0 0 yes 42 CURR_ID_GRP BKPF. KZWRS - Group Currency ID NVARCSTR 5 0 0 yes 43 CURR_ID_LOC BKPF. HWAER - Local Currency ID NVARCSTR 5 0 0 yes 44 CURR_ID_TRX Currency type of the document NVARCSTR 5 0 0 yes 45 CURR_ID_UPDT BSIK. PSWSL or BSAK. PSWSL - Update Currency ID Number of days after NEW NET DUE DATE amount was paid Number of days the item was/is open: LOADDATE - POSTING_DATE if still open; CLEARING_DATE - POSTING_DATE if cleared. NVARCSTR 5 0 0 yes 46 DAYS_LATE DECIMAL 48 28 0 yes 47 DAYS_OPEN DECIMAL 48 28 0 yes 48 DAYS_PAST_DUE Number of days since due date if item still open DECIMAL and past due 48 28 0 yes 49 DISCNT_PERIOD_01 Number of days in the first discount period DECIMAL 48 28 0 yes 50 DISCNT_PERIOD_02 Number of days in the second discount period DECIMAL 48 28 0 yes 51 DOC_DATE Date of the actual document DATETIME 24 0 9 yes 52 DOC_TYPE_ID Financial document type NVARCSTR 2 0 0 yes Rapid Mart Data Schema 77 Appendix Table Column Details A 53 DR_CR_ID Debit or credit indicator NVARCSTR 10 0 0 yes 54 ENTRY_DATE Date of entry by accounting DATETIME 24 0 9 yes 55 EXCH_TYPE_ID_GBL Global Exchg. [. . . ]