PROCESS_INSTANCE01=All Par Locations for Unit
02=Specific Par Location for Unit
03=All for Par Location Group
04=All Par Locations
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
Prompt Table: CART_ATTRIB_INV
IN_CART_UPL_AET(SQL Table) |
Index Back |
|---|---|
Import MAF Data Request 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 | CART_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
Par Location Option
01=All Par Locations for Unit 02=Specific Par Location for Unit 03=All for Par Location Group 04=All Par Locations |
| 5 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | BUSINESS_UNIT_SEL | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit entered as a run time parameter when executing the automat |
| 7 | INV_CART_ID_SEL | Character(15) | VARCHAR2(15) NOT NULL | Selected Cart ID |
| 8 | CART_GROUP_SEL | Character(5) | VARCHAR2(5) NOT NULL | Selected Cart Group |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 10 | INV_CART_ID | Character(15) | VARCHAR2(15) NOT NULL |
Par Location ID
Prompt Table: CART_ATTRIB_INV |
| 11 | CART_GROUP | Character(5) | VARCHAR2(5) NOT NULL | Par Location Group |
| 12 | CART_COUNT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Par Location Count ID |
| 13 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 14 | COMPARTMENT | Character(10) | VARCHAR2(10) NOT NULL | Compartment |
| 15 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 16 | NUMROWS | Number(15,0) | DECIMAL(15) NOT NULL | Number of Rows fetched. |
| 17 | RECORD_SEQ_NUMBER | Number(10,0) | DECIMAL(10) NOT NULL | An internal work field utilized to enumerate database records in bank statement processing. |
| 18 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 19 | FATAL_ERROR | Character(1) | VARCHAR2(1) NOT NULL | Fatal Error |
| 20 | COUNT_ORDER | Signed Number(5,0) | DECIMAL(4) NOT NULL | Par Location Count Order |
| 21 | COUNT_ORDER_CH | Character(4) | VARCHAR2(4) NOT NULL | Par Location Count Order |
| 22 | CART_COUNT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Par Location Count Quantity |
| 23 | DEFAULT_QTY_1_CH | Character(16) | VARCHAR2(16) NOT NULL | Default Quantity |
| 24 | QTY_OPTIMAL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Optimal Qty |
| 25 | QTY_OPTIMAL_CH | Character(16) | VARCHAR2(16) NOT NULL | Optimal Qty |
| 26 | FOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Fixed Order Quantity |
| 27 | FOQ_CH | Character(16) | VARCHAR2(16) NOT NULL | Fixed Order Quantity |
| 28 | QTY_MAXIMUM | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Maximum Qty |
| 29 | QTY_MAXIMUM_CH | Character(16) | VARCHAR2(16) NOT NULL | Maximum Qty |
| 30 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
| 31 | TRANSFER_COST_CH | Character(15) | VARCHAR2(15) NOT NULL | Transfer Price |
| 32 | PRICE_MARKUP_PCT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Price Markup % |
| 33 | PRICE_MARKUPPCT_CH | Character(15) | VARCHAR2(15) NOT NULL | Price Markup % |
| 34 | CHARGE_MARKUP_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Charge Markup Amt |
| 35 | CHG_MARKUP_AMT_CH | Character(16) | VARCHAR2(16) NOT NULL | Charge Markup Amt |
| 36 | CHARGE_MARKUP_PCNT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Charge Markup % |
| 37 | CHG_MARKUP_PCNT_CH | Character(15) | VARCHAR2(15) NOT NULL | Charge Markup % |