CA_ATTACHMENT_H

(SQL Table)
Index Back

Contracts Attatchments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Default Value: CA_CONTR_HDR.CONTRACT_NUM

4 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests

Default Value: 1

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
7 CA_PGP_SEQ Number(3,0) SMALLINT NOT NULL Progress Payment Sequence
8 SEQ_NBR_3 Number(3,0) SMALLINT NOT NULL Sequence
9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File