RECV_PUSH_AET(SQL Table) |
Index Back |
|---|---|
Receiving AE Cache Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AUTOGEN_LBL | Character(1) | VARCHAR2(1) NOT NULL |
Autogenerate Labels
Y/N Table Edit Default Value: N |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 5 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | CURRENCY_CD_2 | Character(3) | VARCHAR2(3) NOT NULL | Currency code 2 |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 10 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 11 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 12 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 13 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 14 | AE_CNV_FILL_CHAR | Character(1) | VARCHAR2(1) NOT NULL | AE Convert Fill Character |
| 15 | AE_CNV_IN_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE input convert field |
| 16 | AE_CNV_JUSTIFY | Character(1) | VARCHAR2(1) NOT NULL | AE Convert Justify Indicator |
| 17 | AE_CNV_OUT_FLD_NM | Character(18) | VARCHAR2(18) NOT NULL | AE output converion field |
| 18 | AE_RUN_OK | Character(1) | VARCHAR2(1) NOT NULL |
AE Run OK Indicator
Y/N Table Edit |
| 19 | AM | Character(1) | VARCHAR2(1) NOT NULL | Asset Management |
| 20 | AP | Character(1) | VARCHAR2(1) NOT NULL | Payables |
| 21 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 22 | CHUNK_RULE_ID | Character(30) | VARCHAR2(30) NOT NULL | Chunking Rule ID |
| 23 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 24 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 25 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 26 | END_PO_GRP_SEQ | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 27 | HOLD_ASSET | Character(1) | VARCHAR2(1) NOT NULL | Hold Assets |
| 28 | HOLD_INVENTORY | Character(1) | VARCHAR2(1) NOT NULL | Hold Inventory |
| 29 | INV | Character(1) | VARCHAR2(1) NOT NULL | Inventory |
| 30 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 31 | INV_STOCK_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Stock Type |
| 32 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 33 | INTFC_ASSET | Character(1) | VARCHAR2(1) NOT NULL | Process Assets |
| 34 | INTFC_INVENTORY | Character(1) | VARCHAR2(1) NOT NULL | Process Inventory |
| 35 | INTFC_MG | Character(1) | VARCHAR2(1) NOT NULL | Process Manufacturing |
| 36 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 37 | LAST_PRE_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Last Pre-Interface ID |
| 38 | LAST_PRE_INTFC_LN | Number(8,0) | INTEGER NOT NULL | Last AM PreInterface Line Nbr |
| 39 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized |
| 40 | MAX_PO_GRP_SEQ | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 41 | MG | Character(1) | VARCHAR2(1) NOT NULL | Manufacturing |
| 42 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 43 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 44 | PO_DT | Date(10) | DATE | Date |
| 45 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 46 | PO_GRP_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 47 | PRE_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Pre-Interface ID |
| 48 | PRE_INTFC_ID_CNT | Number(8,0) | INTEGER NOT NULL | AM PreInterFace ID Count |
| 49 | PRE_INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Pre-Interface Line Number |
| 50 | PRICE_PO_BSE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Price Base |
| 51 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 52 | QTY_SF_ACCPT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Recv Accepted Qty |
| 53 | QTY_SF_REJCT_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Recv Rejected Qty |
| 54 | 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. |
| 55 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 56 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 57 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 58 | EFFDT_CONVERT | Date(10) | DATE | Bill Rate Convert Date |
| 59 | RECV_OPT_FLG | Number(3,0) | SMALLINT NOT NULL | Receipt Process Options |
| 60 | RECV_WHEN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Do When |
| 61 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 62 | RUN_DT | Date(10) | DATE | Run Date |
| 63 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 64 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 65 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 66 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 67 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 68 | UOM_CONV_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
UOM Conversion Flag
0=Use Entered UOM 1=Convert to Standard UOM 2=Convert to Default Stock UOM |
| 69 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 70 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 71 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |