IN_TRANSFER_AET(SQL Table) |
Index Back |
|---|---|
Transfers AE State Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 4 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 5 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 6 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler |
| 9 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 10 | COMMIT_BATCH | Number(6,0) | INTEGER NOT NULL | Commit Batch |
| 11 | COMMIT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count based on Commit Level used to determine the size of a unit of work to commit to the database. A value of zero indicates include all updates in the same unit of work and do one commit at the end of each Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the process. |
| 12 | ALLOW_MV_REL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Rel Allocations Transfer |
| 13 | ALLOW_NEG_INV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Negative Inventory |
| 14 | ALLOW_XFR_INV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Transfers to Owned Loc |
| 15 | TRANSFER_ALLOC_QTY | Character(1) | VARCHAR2(1) NOT NULL | Transfer Allocated Quantity |
| 16 | INCL_QUAR_AVAIL | Character(1) | VARCHAR2(1) NOT NULL | Incl Non-Open in Avail Qty |
| 17 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
| 18 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 19 | EIP_CTL_ID_FROM | Character(25) | VARCHAR2(25) NOT NULL | EIP control ID selection |
| 20 | EIP_CTL_ID_TO | Character(25) | VARCHAR2(25) NOT NULL | EIP control ID selection |
| 21 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 22 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 23 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 24 | SETID_BCT_SETUP | Character(5) | VARCHAR2(5) NOT NULL | SetID BCT Setup |
| 25 | SETID_BU_ATTRIBUTE | Character(5) | VARCHAR2(5) NOT NULL | SetID BU Attributes |
| 26 | SETID_CM_TRANS | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 27 | SETID_CNTR_TYPE | Character(5) | VARCHAR2(5) NOT NULL | SetID Container Type |
| 28 | SETID_INV_ITEMS | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 29 | SETID_ITEM_UOM | Character(5) | VARCHAR2(5) NOT NULL | SetID Item UOM |
| 30 | SETID_MST_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Master Item SETID |
| 31 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 32 | UOM_VOLUME | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 33 | UOM_WEIGHT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 34 | ROWS_RETRIEVED | Number(9,0) | DECIMAL(9) NOT NULL | Number of Rows Retrieved |
| 35 | SQLROWS_TAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 36 | CONTAINER_CONTROL | Character(1) | VARCHAR2(1) NOT NULL | Container Control |
| 37 | MESSAGE_PARM | Character(254) | VARCHAR2(254) NOT NULL | Message Parameter Text |
| 38 | MESSAGE_PARM2 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 2 |
| 39 | MESSAGE_PARM3 | Character(30) | VARCHAR2(30) NOT NULL | Message Parameter 3 |
| 40 | ERROR_LEVEL | Character(1) | VARCHAR2(1) NOT NULL | Error Level |
| 41 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 42 | DFLT_INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Default Lot ID |
| 43 | DFLT_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Default Serial ID |
| 44 | DFLT_STAGED_DATE | Date(10) | DATE | Default Staged Date |
| 45 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 46 | CONTAINER_MATERIAL | Character(20) | VARCHAR2(20) NOT NULL | Container Material |
| 47 | CONTAINER_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Container Type |
| 48 | CREATION_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Container Creation Option
0=Create Container Before Use 1=Create Container Automatically |
| 49 | ITEM_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Item Selection
M=Multiple Items S=Single Item |
| 50 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 51 | MAX_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Weight Capacity |
| 52 | STOCK_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Height |
| 53 | STOCK_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Length |
| 54 | STOCK_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Stock Width |
| 55 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 56 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 57 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 58 | PROCESS_MODE | Character(2) | VARCHAR2(2) NOT NULL |
Run Mode
JB=Job Mode ON=Online Mode PR=Process Mode TR=Transaction Mode |
| 59 | PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Processing Flag |
| 60 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 61 | REPROCESS | Character(1) | VARCHAR2(1) NOT NULL | Reprocess RFQ Response |
| 62 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 63 | SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | SQL Text |