BUSINESS_UNITDefault Value: RF_SO_NOTE.BUSINESS_UNIT
Prompt Table: SP_BU_RC_NONVW
SO_IDDefault Value: RF_SO_NOTE.SO_ID
Prompt Table: RF_SO_HDR
NOTE_SEQ_NBRDefault Value: RF_SO_NOTE.NOTE_SEQ_NBR
Prompt Table: RF_SO_NOTE
ATTACH_SEQ_NBRLANGUAGE_CDRF_SO_ATT_LANG(SQL Table) |
Index Back |
|---|---|
Service Order AttachmentsThis record stores the Service Order Attachments data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RF_SO_NOTE.BUSINESS_UNIT Prompt Table: SP_BU_RC_NONVW |
| 2 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Service Order ID
Default Value: RF_SO_NOTE.SO_ID Prompt Table: RF_SO_HDR |
| 3 | NOTE_SEQ_NBR |
Number(6,0) | INTEGER NOT NULL |
Note ID
Default Value: RF_SO_NOTE.NOTE_SEQ_NBR Prompt Table: RF_SO_NOTE |
| 4 | ATTACH_SEQ_NBR |
Number(6,0) | INTEGER NOT NULL | Attachment Sequence Number |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCRIPTION | Character(35) | VARCHAR2(35) NOT NULL | Description |