LIBRO_RPTG_BAL(SQL Table) |
Index Back |
|---|---|
Libro Reporting Balance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LIBRO_RPTG_APPL_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Libro reporting Applications
AP=Payables AR=Receivables BI=Billing GL=General Ledger |
| 2 | VAT_ENTITY |
Character(20) | VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
Prompt Table:
VAT_ENTITY
|
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_LEDG_S_NONVW
|
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | ACCOUNTING_PERIOD |
Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 6 | LEDGER_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger Code
Prompt Table: LEDGER_CODE_TBL |
| 7 | BAL_SHEET_IND |
Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 8 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 9 | MONETARY_AMT_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base DR Amount |
| 10 | MONETARY_AMT_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base CR Amount |
| 11 | LIBRO_LAST_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Last Sequence Number Printed |
| 12 | LIBRO_FINAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Final Print Indicator |
| 13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 14 | PROCESS_DATE | Date(10) | DATE | Process Date |