BI_LINE_ATTACH

(SQL Table)
 Index Back

Ivc Line Supporting Documents

This record is used to link supporting documentation to invoice lines.

  • Parent record: BI_LINE

    • # 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

    2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    4 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.
    5 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.
    6 INTERNAL_FLAG Character(1) VARCHAR2(1) NOT NULL Internal Only Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    7 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    8 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID