INTFC_IDBUSINESS_UNITPrompt Table: SP_BU_RE_NONVW
LS_NBRDefault Value: NEXT
LEASE_OBLG1=Payables
2=Receivables
Default Value: 1
INTFC_RE_ADD(SQL View) |
Index Back |
|---|---|
Interface Add Search RecordInterface Add Search Record |
| SELECT INTFC_ID , BUSINESS_UNIT , LS_NBR , LEASE_OBLG FROM PS_INTFC_RE_LS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RE_NONVW |
| 3 | LS_NBR |
Character(10) | VARCHAR2(10) NOT NULL |
Lease Number, User Enterable or Generated Sequence Number
Default Value: NEXT |
| 4 | LEASE_OBLG |
Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables Default Value: 1 |