BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
BILL_OF_LADINGPrompt Table: BOL_INV
SEQ_NUMDefault Value: 1
Prompt Table: NOTE_TYPE
Prompt Table: STD_NOTE
BOL_NOTE(SQL Table) |
Index Back |
|---|---|
Bill of Lading NotesThis record holds the order header, line and schedules standard note code or custom text. It is the parent of ORD_NOTE_DOC and ORD_NOTE_KEYWD. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | BILL_OF_LADING |
Character(30) | VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Prompt Table: BOL_INV |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 4 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Note Type
Prompt Table: NOTE_TYPE |
| 5 | STD_NOTE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table: STD_NOTE |
| 6 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |