GL_VAT_TOL_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for GL_ACCOUNT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 4 | EFFDT | Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |
| 9 | BUDG_OVERRIDE_ACCT | Character(1) | VARCHAR2(1) NOT NULL | Budget Override Account |
| 10 | ACCOUNTING_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Accounting Owner |
| 11 | AB_ACCOUNT_SW | Character(1) | VARCHAR2(1) NOT NULL | ABM Account |
| 12 | GL_ACCOUNT_SW | Character(1) | VARCHAR2(1) NOT NULL | General Ledger Account |
| 13 | PF_ACCOUNT_SW | Character(1) | VARCHAR2(1) NOT NULL | Performance Measurement |
| 14 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue. |
| 15 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 16 | OPEN_ITEM | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) to activate processing for tracking debits and credits that post to a general ledger account. Accounts that are not OpenItem track only net posted amounts. |
| 17 | OPEN_ITEM_DESCR | Character(10) | VARCHAR2(10) NOT NULL | Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger. |
| 18 | OPEN_ITEM_EDIT_REC | Character(15) | VARCHAR2(15) NOT NULL | Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger. |
| 19 | OPEN_ITEM_EDIT_FLD | Character(18) | VARCHAR2(18) NOT NULL | Specifies the name of the field in the OpenItem Edit Record (OPEN_ITEM_EDIT_REC) to use for validating the OpenItem search key, and applies only to OpenItem accounts in the general ledger. |
| 20 | OPEN_ITEM_PROMPT | Character(15) | VARCHAR2(15) NOT NULL | Open Item Prompt Table |
| 21 | OPEN_ITEM_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the limit amount that determines when OpenItem entries can be closed. You can manually close (delete) OpenItem rows if the balance of the OpenItem account is less than or equal to the specified tolerance. |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 23 | OI_RECON_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Specifies that open items should get closed only when the sum total for base amount is zero.
Y/N Table Edit Default Value: N |
| 24 | STATISTICS_ACCOUNT | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a general ledger account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. A unit of measure (UNIT_OF_MEASURE) must be specified with a statistical account. |
| 25 | BALANCE_FWD_SW | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward O=Other Y=Carry Forward |
| 26 | CONTROL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This flag in used to desginate an Account or Alternate Account as Control Accounts and Control Alternate Accounts, respectively. |
| 27 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 28 | BOOK_CODE_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow specifying of the Book Code value that is different from the default value as defined in the GL Account table.
Y/N Table Edit Default Value: Y |
| 29 | BAL_SHEET_IND | Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 30 | VAT_ACCOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates the relationship of a general ledger account to VAT processing. An account can be non-VAT, VAT or VAT Applicable.
A=VAT Applicable Account N=Non-VAT Related V=VAT Account |
| 31 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 32 | BUDGETARY_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Budgetary Only |
| 33 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 34 | KK_OVERRIDE_ACCT | Character(1) | VARCHAR2(1) NOT NULL | Override Commitment Control Budget Editting. |
| 35 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 36 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |