EM_DISPUTE_LINE(SQL Table) |
Index Back |
|---|---|
eS Invoice Line DisputesUsed for line level disputes of invoices. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 5 | SEQ_NBR_3 |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | EMAIL_ON | Character(1) | VARCHAR2(1) NOT NULL |
Message Active
A=Active I=Inactive Y/N Table Edit |
| 8 | DTTM_STAMP | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime |
| 9 | LINE_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Line in Dispute
Y/N Table Edit |
| 10 | PYMNT_HOLD_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |