ALLOC_AMT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PROCESS_STEP	Character(10)	VARCHAR2(10) NOT NULL	Process Step
3	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
5	FIELDNAME_POOL	Character(18)	VARCHAR2(18) NOT NULL	Allocations Pool amount field Prompt Table: RECFD_LBL_PA_VW
6	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	FIELDNAME_POOL_B	Character(18)	VARCHAR2(18) NOT NULL	Allocations Pool Base Currency Amount Field Prompt Table: RECFD_LBL_PA_VW
8	FIELDNAME_POOL_T	Character(18)	VARCHAR2(18) NOT NULL	Allocations Pool Transaction Amount Field Prompt Table: RECFD_LBL_PA_VW
9	POOL_FIXED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fixed Pool Amount
10	FIELDNAME_BASIS	Character(18)	VARCHAR2(18) NOT NULL	Allocations basis amount field Prompt Table: RECFD_LBL_BA_VW
11	FIELDNAME_TARGET	Character(18)	VARCHAR2(18) NOT NULL	Allocations Target amount field Prompt Table: RECFD_LBL_TA_VW
12	FIELDNAME_TARGET_B	Character(18)	VARCHAR2(18) NOT NULL	Allocations Target base currency amount field Prompt Table: RECFD_LBL_TA_VW
13	FIELDNAME_TARGET_T	Character(18)	VARCHAR2(18) NOT NULL	Allocations Target Transaction Amount Field Prompt Table: RECFD_LBL_TA_VW
14	FIELDNAME_OFFSET	Character(18)	VARCHAR2(18) NOT NULL	Allocations Offset amount field Prompt Table: RECFD_LBL_OA_VW
15	FIELDNAME_OFFSET_B	Character(18)	VARCHAR2(18) NOT NULL	Allocations Base Currency amount field Prompt Table: RECFD_LBL_OA_VW
16	FIELDNAME_OFFSET_T	Character(18)	VARCHAR2(18) NOT NULL	Allocations OffsetTransaction Amount Field Prompt Table: RECFD_LBL_OA_VW
17	FIELD_LOG_POOL	Character(18)	VARCHAR2(18) NOT NULL	Calc log pool amount field Prompt Table: RECFLD_LOG_VW
18	FIELD_LOG_POOL_B	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log pool base amount field Prompt Table: RECFLD_LOG_VW
19	FIELD_LOG_POOL_TR	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log pool transaction amount field Prompt Table: RECFLD_LOG_VW
20	FIELD_LOG_BASIS	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log basis amount field Prompt Table: RECFLD_LOG_VW
21	FIELD_LOG_BASIS_T	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log basis total amount field Prompt Table: RECFLD_LOG_VW
22	FIELD_LOG_TARGET	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log target amount field Prompt Table: RECFLD_LOG_VW
23	FIELD_LOG_TARGET_B	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log target base amount field Prompt Table: RECFLD_LOG_VW
24	FIELD_LOG_TARG_TR	Character(18)	VARCHAR2(18) NOT NULL	Alloc calc log target base amount field Prompt Table: RECFLD_LOG_VW