ORD_ATT

(SQL Table)
 Index Back

Order Attachments

This table stores the multi-media attachments identifiers for an order header, line or schedule.

  • Related Language Record: ORD_ATT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_OM

    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

    Prompt Table: ORD_HEADER

    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

    Prompt Table: ORD_LINE

    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

    Prompt Table: ORD_SCHEDULE

    5 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    6 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    9 ATTACH_TYPE Character(5) VARCHAR2(5) NOT NULL Attachment Type

    Prompt Table: FO_ATTACH_TYPE

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description