AP_TAB_DEFN_DTL

(SQL Table)
Index Back

Payables Tab Definitions

Payables Tab Definitions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TAB_ID Character(30) VARCHAR2(30) NOT NULL Tab ID
2 TAB_ORDER Number(3,0) SMALLINT NOT NULL Tab Order
3 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
4 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
5 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
6 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID