KK_SHDR_PORA_H(SQL Table) |
Index Back |
|---|---|
Comm. Cntrl. Source Hdr Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | KK_SOURCE_TRAN |
Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 6 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 7 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 8 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 9 | 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 |
| 10 | APPL_JRNL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 11 | 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. |
| 12 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 13 | ORIGINAL_TRANS |
Character(1) | VARCHAR2(1) NOT NULL | Receipt Accrual Original Trans |
| 14 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 15 | KK_ROLLED_SEQ | Number(3,0) | SMALLINT NOT NULL | PO Rolled Sequence |
| 16 | KK_TRAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Commitment Control Foreign Key for Transaction Identification. |
| 17 | KK_TRAN_DT | Date(10) | DATE NOT NULL | Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID. |
| 18 | SEQUENCE_NBR_9 | Number(9,0) | DECIMAL(9) NOT NULL | Sequence |
| 19 | KK_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist I=Document in process N=Process Unsuccessful P=Provisionally Valid V=No Errors or Warnings W=Only Warnings Exist X=Unrecorded Errors Exist |
| 20 | KK_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 22 | KK_DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |