PROCESS_INSTANCEA=All BUs
B=1 Bus Unit
D=1 Document
RTV_RECON_AET(SQL Table) |
Index Back |
|---|---|
RTV Reconcile Cache Rec/* 615584 05/05/2005 - Added a new field PO_POST_RUN_IND for RTV Recon Process */ |
| # | 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 | RUN_DT | Date(10) | DATE | Run Date |
| 5 | AM | Character(1) | VARCHAR2(1) NOT NULL | Asset Management |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 8 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 9 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 10 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 11 | PO_POST_RUN_IND | Character(1) | VARCHAR2(1) NOT NULL |
/* 615584 05/05/2005 - Added a new label for RTV Recon Process */
A=All BUs B=1 Bus Unit D=1 Document |
| 12 | CLOSE_DELAY_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Close Processing Delay Days |
| 13 | CANCEL_DELAY_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Cancel Days |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 16 | PO_CLOSE_DATE | Date(10) | DATE | PO Close Date |
| 17 | PO_CANCEL_DATE | Date(10) | DATE | PO Cancel Date |
| 18 | PRE_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Pre-Interface ID |
| 19 | PRE_INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Pre-Interface Line Number |
| 20 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 21 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 22 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 23 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 24 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 25 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 26 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 27 | 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. |
| 28 | RTV_LINE_COUNT | Number(5,0) | INTEGER NOT NULL | RTV Line Count |
| 29 | RTV_SHIP_COUNT | Number(5,0) | INTEGER NOT NULL | RTV Shipped Line Count |
| 30 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 31 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |