IN_INTUNIT_AET(SQL Table) |
Index Back |
---|---|
Interunit Exp Rcpt State RecInterunit Expected Receipts State Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUINVN_NONVW |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | INV_EDI_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Inventory ASN EDI Option
A=All Shipments D=Sold To Customer H=Ship To Customer I=Shipping ID V=Delivery ID Default Value: A |
8 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table: IN_SHIPID_IU_VW |
9 | SEL_DESTBU_OPT | Character(1) | VARCHAR2(1) NOT NULL |
12/99:Created
A=All S=Specific Default Value: A |
10 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: SP_BUINVN_NONVW |
11 | SEL_TRAN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
12/99 Created
C=Closed/Cancelled N=New Default Value: N |
12 | POST_SHIP_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Cancel Instance |
13 | REGEN_MSG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
12/99 Created
Y/N Table Edit Default Value: N |
14 | IN_RECS_EXTRACTED | Number(7,0) | INTEGER NOT NULL | 12/99: Created to tract number of records extracted. |
15 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
16 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |