DMS_BU_AR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AGENCYID	Character(9)	VARCHAR2(9) NOT NULL	New field used to store a proprietary DMS Agency_Id code.
3	FILE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	File Sequence Number
4	NO_OF_DAYS	Number(3,0)	SMALLINT NOT NULL	Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option. Default Value: 180
5	COLLECTION_CD_PCA1	Character(3)	VARCHAR2(3) NOT NULL	Collection Code - PCA1 Prompt Table: COLLECTION_TBL
6	COLLECTION_CD_PCA2	Character(3)	VARCHAR2(3) NOT NULL	Collection Code - PCA2 Prompt Table: COLLECTION_TBL
7	COLLECTION_CD_JUDG	Character(3)	VARCHAR2(3) NOT NULL	Collection Code Judgmnt Action Prompt Table: COLLECTION_TBL
8	BASIS_DT	Character(1)	VARCHAR2(1) NOT NULL	Basis Date A=As Of Date D=Due Date G=Acctg Date I=Item Date