IN_INTUNIT_AET

(SQL Table)
Index Back

Interunit Exp Rcpt State Rec

Interunit 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