PR_LINE_H(SQL Table) |
Index Back |
|---|---|
XPR LinePayment Request Line - Archive Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Request ID
Default Value: PR_REQUEST.REQUEST_ID |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PR_REQUEST.BUSINESS_UNIT |
| 5 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 6 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Item SetID
Default Value: INV_ITEMS.SETID |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
ITM_PURCH_VW
|
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 11 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 12 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 13 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: PR_REQUEST.TXN_CURRENCY_CD |
| 14 | SPEEDCHART_KEY | Character(10) | VARCHAR2(10) NOT NULL |
SpeedChart Key
Prompt Table: EMSPEEDCHART_VW |
| 15 | ACCOUNT_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Accounting Tag
Prompt Table: TAG_SEL_DVW |
| 16 | MAX_DISTRIB_LINE | Number(5,0) | INTEGER NOT NULL | Highest Distribution Line |