PNDG_DST_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for PENDING_DST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL | Represents the high level grouping of multiple general ledger business units. |
| 3 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 6 | ITEM | Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 7 | ITEM_LINE | Number(6,0) | INTEGER NOT NULL | Item Line |
| 8 | GROUP_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated. |
| 9 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 10 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 11 | DST_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 12 | PRIMARY_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group. |
| 13 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 14 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 15 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 16 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 17 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 18 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 19 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 20 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 21 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 22 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 23 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 24 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 25 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 26 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 27 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 28 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 29 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: %EDIT_BU_PC |
| 30 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
| 31 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDIT_ACTIVITY |
| 32 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
| 33 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
| 34 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
| 35 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
| 36 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 37 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 38 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 39 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
| 40 | CF_EDIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not accounting entries have been edited for valid ChartField combinations. If an edit has taken place the status indicates whether or not it was successful. The ChartField Combination Edit program populates the field as Complete Errors or Not Edited.
C=Complete E=Errors N=Not Edited |
| 41 | JRNL_LN_REF | Character(10) | VARCHAR2(10) NOT NULL | Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction. |
| 42 | LINE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered. |
| 43 | SYSTEM_DEFINED | Character(2) | VARCHAR2(2) NOT NULL | "A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). " |
| 44 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 45 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 46 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 47 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 48 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 49 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 50 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 51 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 52 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 53 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 54 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 55 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 56 | MOVEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural R=Reversal |
| 57 | USER1 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 58 | USER2 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 59 | USER3 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 60 | USER4 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 61 | USER5 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 62 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 63 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 64 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
| 65 | VAT_DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. |
| 66 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 67 | IU_ANCHOR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields). |
| 68 | IU_SYS_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries. |
| 69 | IU_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction. |
| 70 | OPEN_ITEM_KEY | Character(30) | VARCHAR2(30) NOT NULL | Open Item Key |
| 71 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 72 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |