SETIDSETID1DRAFT_TYPEDRAFT_BUSN_EVENTENTRY_TYPELANGUAGE_CDDR_ENTRTYP_LVW(SQL View) |
Index Back |
|---|---|
Entry Types by Sub Event |
| SELECT DISTINCT A.SETID , B.SETID AS SETID1 , A.DRAFT_TYPE , A.DRAFT_BUSN_EVENT , B.ENTRY_TYPE , D.LANGUAGE_CD , D.DESCR FROM PS_DR_ENTRYSUB_TBL A , PS_AUTO_ENTRY_TBL B , PS_ENTRY_TY_TBL_LG D WHERE A.ENTRY_USE_ID = B.ENTRY_USE_ID AND B.SETID = D.SETID AND B.ENTRY_TYPE = D.ENTRY_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SETID1 |
Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 3 | DRAFT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2). |
| 4 | DRAFT_BUSN_EVENT |
Character(2) | VARCHAR2(2) NOT NULL | Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft. |
| 5 | ENTRY_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |