CA_LMT_BISQ_TAO (SQL Table)	Index Back
Copy of CA_LMT_BI_TAO Copy of CA_LMT_BI_TAO table. Used for Sequence it.

CA_LMT_BISQ_TAO

(SQL Table)

Copy of CA_LMT_BI_TAO

Copy of CA_LMT_BI_TAO table. Used for Sequence it.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

4 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJ_SCRTY_SRCH

6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_SRCH

7 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

8 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.

9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

10 DELETE_ME Character(1) VARCHAR2(1) NOT NULL Delete Record

11 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number

12 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: PROJ_AN_GRP_VW

13 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RES_TYPE

14 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDITTABLE

15 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDITTABLE2

16 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity

17 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

20 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

21 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

22 BILL_CUR_OPT Character(1) VARCHAR2(1) NOT NULL Bill Currency
D=Contract Currency
M=Transaction Currency

23 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended

24 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

25 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

26 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

27 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

28 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number

29 RETAINAGE_ID Character(15) VARCHAR2(15) NOT NULL Retainage ID

30 RETAINAGE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Retainage Percentage

31 INCLUDE_RETAINAGE Character(1) VARCHAR2(1) NOT NULL Include in Billing
B=Bill
H=Hold
W=Write-off

32 DISCOUNT_ID Character(15) VARCHAR2(15) NOT NULL Discount ID

33 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

34 DISCOUNT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Discount Percentage

35 TRANS_DT Date(10) DATE Transaction Date

36 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

37 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

38 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

39 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

40 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

41 CONTRACT_DT Date(10) DATE Contract Date

42 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

43 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num

44 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

45 SOLD_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Sold To Address Sequence Num

46 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

47 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

48 BILL_INQUIRY_PHONE Character(24) VARCHAR2(24) NOT NULL Bill Inquiry Phone

49 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20

50 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

51 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

52 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

53 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPER_UNIT_TBL

54 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_TBL

55 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_TBL

56 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_TBL

57 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_TBL

58 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_TBL

59 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

60 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

61 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

62 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CHARTFIELD1_TBL

63 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CHARTFIELD2_TBL

64 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CHARTFIELD3_TBL

65 ALTACCT_TO Character(10) VARCHAR2(10) NOT NULL To Alternate Account

66 DEPTID_TO Character(10) VARCHAR2(10) NOT NULL To Department

67 PROJECT_ID_TO Character(15) VARCHAR2(15) NOT NULL Project ID To

68 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

69 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

70 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate

71 TAX_EXEMPT_RC Character(2) VARCHAR2(2) NOT NULL Exempt Reason Code
01=Certificat

72 TAX_JOB_NUM Character(10) VARCHAR2(10) NOT NULL Job Number

73 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

74 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return

75 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None

76 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

77 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

78 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

79 BILL_CYCLE_ID Character(10) VARCHAR2(10) NOT NULL Billing Cycle Identifier

80 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist

81 BILLING_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Billing Authority

82 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

83 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier

84 DESCR Character(30) VARCHAR2(30) NOT NULL Description

85 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
Default Value: PC_CONTRACT.DIRECT_INVOICING

86 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

87 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #

88 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

89 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price

90 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

91 PRE_APPROVAL_FLG Character(1) VARCHAR2(1) NOT NULL Pre Approval Flag

92 TMP_BILL_FLG Character(1) VARCHAR2(1) NOT NULL Temporary Bill

93 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue

94 INCLUDE_OLT Character(1) VARCHAR2(1) NOT NULL Limit Override
B=Bill Items marked OLT
H=Hold items marked OLT
W=Write-off items marked OLT

95 BRT_FLAG Character(1) VARCHAR2(1) NOT NULL BRT Flag

96 INVOICE_FORM_ID Character(10) VARCHAR2(10) NOT NULL Invoice Form

97 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

98 CHARGE_FROM_DT Date(10) DATE From Date for line charges

99 CHARGE_TO_DT Date(10) DATE Through date for charges

100 AMENDMENT_DT Date(10) DATE Amendment Date

101 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

102 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID

103 LOC_DOC_ID Character(30) VARCHAR2(30) NOT NULL Letter of Credit Document ID

104 RESET_FLAG Character(1) VARCHAR2(1) NOT NULL Reset Flag
Default Value: N

105 TOLERANCE_AMT Number(16,2) DECIMAL(15,2) NOT NULL Tolerance Amount

106 FINAL_FLAG Character(1) VARCHAR2(1) NOT NULL Final Bill Option

107 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

108 FROM_DT Date(10) DATE From Date

109 TO_DT Date(10) DATE To Date

110 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID

111 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

112 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

113 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason

114 MAST_CONTR_ID Character(25) VARCHAR2(25) NOT NULL Master Contract #

115 PRICED_RATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.

116 CA_PRICED_RATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in batch job CA_BI_INTFC

117 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

118 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

119 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field

120 LIMIT_CURR Character(3) VARCHAR2(3) NOT NULL Currency Code

121 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

122 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

123 QTY_BILL Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity in Billing UOM

124 QTY_REMAIN Signed Number(17,4) DECIMAL(15,4) NOT NULL Remaining Quantity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
4	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJ_SCRTY_SRCH
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_SRCH
7	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
8	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.
9	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
10	DELETE_ME	Character(1)	VARCHAR2(1) NOT NULL	Delete Record
11	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
12	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_AN_GRP_VW
13	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE
14	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDITTABLE
15	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDITTABLE2
16	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
17	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
20	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
21	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
22	BILL_CUR_OPT	Character(1)	VARCHAR2(1) NOT NULL	Bill Currency D=Contract Currency M=Transaction Currency
23	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
24	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
25	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
26	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
27	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
28	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number
29	RETAINAGE_ID	Character(15)	VARCHAR2(15) NOT NULL	Retainage ID
30	RETAINAGE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Retainage Percentage
31	INCLUDE_RETAINAGE	Character(1)	VARCHAR2(1) NOT NULL	Include in Billing B=Bill H=Hold W=Write-off
32	DISCOUNT_ID	Character(15)	VARCHAR2(15) NOT NULL	Discount ID
33	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
34	DISCOUNT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Discount Percentage
35	TRANS_DT	Date(10)	DATE	Transaction Date
36	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
37	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
38	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
39	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
40	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
41	CONTRACT_DT	Date(10)	DATE	Contract Date
42	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
43	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
44	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
45	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num
46	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
47	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
48	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone
49	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description 20
50	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
51	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
52	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
53	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPER_UNIT_TBL
54	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_TBL
55	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_TBL
56	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_TBL
57	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_TBL
58	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_TBL
59	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
60	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
61	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
62	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CHARTFIELD1_TBL
63	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CHARTFIELD2_TBL
64	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CHARTFIELD3_TBL
65	ALTACCT_TO	Character(10)	VARCHAR2(10) NOT NULL	To Alternate Account
66	DEPTID_TO	Character(10)	VARCHAR2(10) NOT NULL	To Department
67	PROJECT_ID_TO	Character(15)	VARCHAR2(15) NOT NULL	Project ID To
68	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
69	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
70	TAX_EXEMPT_CERT	Character(30)	VARCHAR2(30) NOT NULL	Exemption Certificate
71	TAX_EXEMPT_RC	Character(2)	VARCHAR2(2) NOT NULL	Exempt Reason Code 01=Certificat
72	TAX_JOB_NUM	Character(10)	VARCHAR2(10) NOT NULL	Job Number
73	TAX_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tax Group
74	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
75	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None
76	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
77	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier
78	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
79	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier
80	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist
81	BILLING_AUTHORITY	Character(8)	VARCHAR2(8) NOT NULL	Billing Authority
82	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
83	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
84	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
85	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Default Value: PC_CONTRACT.DIRECT_INVOICING
86	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
87	EMPL_RCD_NUM	Number(3,0)	SMALLINT NOT NULL	Project Employee Job Record #
88	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
89	UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
90	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
91	PRE_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pre Approval Flag
92	TMP_BILL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Temporary Bill
93	REV_RECOG_METHOD	Character(4)	VARCHAR2(4) NOT NULL	Revenue Recognition Method 1=As Incurred 2=Apportionment 3=Percent Complete 4=Milestone 5=Billing Manages Revenue
94	INCLUDE_OLT	Character(1)	VARCHAR2(1) NOT NULL	Limit Override B=Bill Items marked OLT H=Hold items marked OLT W=Write-off items marked OLT
95	BRT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	BRT Flag
96	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
97	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
98	CHARGE_FROM_DT	Date(10)	DATE	From Date for line charges
99	CHARGE_TO_DT	Date(10)	DATE	Through date for charges
100	AMENDMENT_DT	Date(10)	DATE	Amendment Date
101	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location
102	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID
103	LOC_DOC_ID	Character(30)	VARCHAR2(30) NOT NULL	Letter of Credit Document ID
104	RESET_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reset Flag Default Value: N
105	TOLERANCE_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Tolerance Amount
106	FINAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Final Bill Option
107	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
108	FROM_DT	Date(10)	DATE	From Date
109	TO_DT	Date(10)	DATE	To Date
110	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
111	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
112	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
113	ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Activity Type A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason
114	MAST_CONTR_ID	Character(25)	VARCHAR2(25) NOT NULL	Master Contract #
115	PRICED_RATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.
116	CA_PRICED_RATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in batch job CA_BI_INTFC
117	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
118	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
119	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
120	LIMIT_CURR	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
121	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
122	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
123	QTY_BILL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity in Billing UOM
124	QTY_REMAIN	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Remaining Quantity