OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDAP=Accounts Payable
BI=Billing
OM=Order Management
PO=Purchasing
Prompt Table: %EDITTABLE
Prompt Table: %EDITTABLE2
Default Value: %Date
RUN_TAX_DELETE(SQL Table) |
Index Back |
|---|---|
Tax Delete Process RequestThis table will be used to request tax delete from 3rd party tax product to synchronize tax calculations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | TAX_TRANS_SRC | Character(2) | VARCHAR2(2) NOT NULL |
Source of taxable transaction
AP=Accounts Payable BI=Billing OM=Order Management PO=Purchasing |
| 4 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: %EDITTABLE |
| 5 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE2 |
| 7 | TAX_CALC_TRANS_ID | Character(30) | VARCHAR2(30) NOT NULL | Tax calculation transaction ID (to be used in synching up tax calculation transactions with 3rd party tax software). |
| 8 | ADD_DT | Date(10) | DATE |
Customer Added On
Default Value: %Date |