CO_DED_HDRM

(SQL Table)
Index Back

Header record for XML Msg.

Used for Discount and Perks Suppliers. Supplier deduction header record for an inbound XML message.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMP_GROUP_NBR Character(12) VARCHAR2(12) NOT NULL Employee group number which is provided on the deduction header record from the Supplier.
2 SITE_NBR Character(6) VARCHAR2(6) NOT NULL This field is edused to group employee based on their paygroup and pay frequency. The value for this field is assigned by the Supplier.
3 FILE_NUM1 Character(6) VARCHAR2(6) NOT NULL FILE TYPE
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 DEDUCT_DT Date(10) DATE The date the Supplier created the deduction record.
6 INVOICE_NBR Number(6,0) INTEGER NOT NULL Invoice number assigned by the Supplier and it appears in the header record of the inbound deduction data.
7 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
8 TOTAL_DED_CNT Number(6,0) INTEGER NOT NULL The field contains the total count of the number of deduction records sent by the Supplier.
9 TOTAL_DEDAMT Number(10,2) DECIMAL(9,2) NOT NULL This field contains the total deduction amount sent by the SUpplier.