PROCESS_INSTANCED=Direct
I=Indirect
P=Pairs
1=Use GL BU Settings Only
2=Use IN BU Settings Only
3=Use Both
1=Print/Load
2=No Load
1=Use Set Based
2=Row by Row
INV_DP_IUT_AET(SQL Table) |
Index Back |
|---|---|
Depletions AE State Table/* 03/16/04 PWF Addition of Depletion AE to Fulfillment Engine */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OM | Character(1) | VARCHAR2(1) NOT NULL | Order Management |
| 3 | BI | Character(1) | VARCHAR2(1) NOT NULL | Billing |
| 4 | DFLT_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Default Serial ID |
| 5 | IU_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct I=Indirect P=Pairs |
| 6 | IUNIT_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Transaction Options
1=Use GL BU Settings Only 2=Use IN BU Settings Only 3=Use Both |
| 7 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 8 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 9 | INTERUNIT_ID_WRK | Character(10) | VARCHAR2(10) NOT NULL | Interunit ID |
| 10 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 11 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 12 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 13 | SEQ_NBR_6 | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 14 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 15 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 16 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 17 | WHERE_CLAUSE7 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 18 | ROWS_RETRIEVED | Number(9,0) | DECIMAL(9) NOT NULL | Number of Rows Retrieved |
| 19 | ROWS_IN_STAGE | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows in Staging Table |
| 20 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 21 | BI_JOB_RUN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Billing Job Run Option
1=Print/Load 2=No Load |
| 22 | PRINT_LISTING | Character(1) | VARCHAR2(1) NOT NULL | Print Listing |
| 23 | LAST_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Last Interface ID |
| 24 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 25 | RANGE_SELECTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Range Selection ID |
| 26 | SEL_SHPNTC_ASN_OPT | Character(1) | VARCHAR2(1) NOT NULL | 12/99 Create: Shipping Notices Selection Button |
| 27 | SEL_SHPNTC_IL_OPT | Character(1) | VARCHAR2(1) NOT NULL | 12/99:Created |
| 28 | SEL_SHPNTC_IU_OPT | Character(1) | VARCHAR2(1) NOT NULL | 12/99:Created |
| 29 | AE_DO_APPLID | Character(8) | VARCHAR2(8) NOT NULL | Do Application |
| 30 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 31 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 32 | ROWS_NO_ERROR | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows to be Loaded |
| 33 | TXN_PRECISION | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 34 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 35 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 36 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 37 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 38 | TOTAL_ROWS_QRY | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows from Query |
| 39 | PROCESSING_GROUP | Number(10,0) | DECIMAL(10) NOT NULL | A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level. |
| 40 | PROCESSING_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Count based on Processing Level used to determine the Processing Group. A value of zero indicates include all data into one 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. When processing, if Commit Count is greater than the specified Processing Count and the Processing Level is the same as the Commit Level, the Processing Count should be set to the Commit Count. |
| 41 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL | Direct Invoicing |
| 42 | LOAD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Load Flag |
| 43 | CUST_ID_TO | Character(15) | VARCHAR2(15) NOT NULL | To Customer ID |
| 44 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 45 | VMI_ORDER_LINK | Character(28) | VARCHAR2(28) NOT NULL | VMI Order Link |
| 46 | IN_SEQUENCE_NO_TBL | Character(15) | VARCHAR2(15) NOT NULL | IN_SEQ_NO_TBL |
| 47 | IN_DMS_RUN_INST | Character(1) | VARCHAR2(1) NOT NULL | IN_DMS_RUN_STATUS |
| 48 | IN_SEQ_PLATFORM_SP | Character(1) | VARCHAR2(1) NOT NULL | Set based Sequencing |
| 49 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 50 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 51 | IN_SET_BASED | Character(1) | VARCHAR2(1) NOT NULL |
Set based Sequencing
1=Use Set Based 2=Row by Row |
| 52 | IN_PLATFORM | Character(8) | VARCHAR2(8) NOT NULL | IN_DB_PLATFORM |
| 53 | MAINJOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Main Job Instance |
| 54 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |