FO_ASGN_BILLING

(SQL Table)
Index Back

Career Assignments Billing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
2 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
3 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
4 CA_PERCENTAGE Signed Number(13,8) DECIMAL(11,8) NOT NULL Percentage
5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text