BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRDISTRIB_LINE_NUMDST_ACCT_TYPEAPPL_JRNL_IDACCOUNTING_PERIODFISCAL_YEARORIGINAL_TRANSDT_TIMESTAMPRECV_LN_ACT_VW(SQL View) |
Index Back |
|---|---|
Accounting Entry Table |
| SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.APPL_JRNL_ID , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.ORIGINAL_TRANS , A.DT_TIMESTAMP FROM PS_RECV_LN_ACCTG A WHERE A.BUDGET_LINE_STATUS NOT IN ('V', 'W', ' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 6 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 7 | APPL_JRNL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 8 | 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. |
| 9 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 10 | ORIGINAL_TRANS |
Character(1) | VARCHAR2(1) NOT NULL | Receipt Accrual Original Trans |
| 11 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |