CM_APRECONCILED (SQL Table)	Index Back
CM/AP Reconciled Receipts This table contains the reconciled receipts.

CM_APRECONCILED

(SQL Table)

CM/AP Reconciled Receipts

This table contains the reconciled receipts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

5 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

8 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

9 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
4	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
5	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
9	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.