Recurring Transaction Template

Table Name: ORCP

Table Description: Recurring Transaction Template

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Number	Int	11	-
Code	Template Code	nVarChar	8	-
Dscription	Description	nVarChar	50	-
IsRemoved	Is Removed	VarChar	1	-	N	Y	Yes
						N	No
DocObjType	Linked Document Type	nVarChar	20	-	-1	-1
						23	Sales Quotation
						17	Sales Order
						15	Delivery
						234000031	Returns Request
						16	Return
						-203	A/R Down Payment Request
						203	A/R Down Payment Invoice
						13	A/R Invoice
						14	A/R Credit Memo
						-13	A/R Reserve Invoice
						1470000113	Purchase Request
						540000006	Purchase Quotation
						22	Purchase Order
						20	Goods Receipt PO
						234000032	Goods Returns Request
						21	Goods Return
						-204	A/P Down Payment Request
						204	A/P Down Payment Invoice
						18	A/P Invoice
						19	A/P Credit Memo
						-18	A/P Reserve Invoice
						59	Goods Receipt
						60	Goods Issue
						1250000001	Inventory Transfer Request
						67	Inventory Transfer
DraftEntry	Linked Draft Entry	Int	11	ODRF
Frequency	Frequency	VarChar	1	-	M	D	Daily
						W	Weekly
						X	Every 2 Weeks
						M	Monthly
						P	Every 2 Months
						Q	Quarterly
						S	Semiannually
						A	Annually
						O	One Time
Remind	Sub-Frequency	Int	6	-	1001	-1
						1	On Sunday
						2	On Monday
						3	On Tuesday
						4	On Wednesday
						5	On Thursday
						6	On Friday
						7	On Saturday
						101	Every 1
						102	Every 2
						103	Every 3
						104	Every 4
						105	Every 5
						106	Every 6
						107	Every 7
						108	Every 8
						109	Every 9
						110	Every 10
						111	Every 11
						112	Every 12
						113	Every 13
						114	Every 14
						115	Every 15
						116	Every 16
						117	Every 17
						118	Every 18
						119	Every 19
						120	Every 20
						121	Every 21
						122	Every 22
						123	Every 23
						124	Every 24
						125	Every 25
						126	Every 26
						127	Every 27
						128	Every 28
						129	Every 29
						130	Every 30
						131	Every 31
						145	Every 45
						160	Every 60
						1001	On 1
						1002	On 2
						1003	On 3
						1004	On 4
						1005	On 5
						1006	On 6
						1007	On 7
						1008	On 8
						1009	On 9
						1010	On 10
						1011	On 11
						1012	On 12
						1013	On 13
						1014	On 14
						1015	On 15
						1016	On 16
						1017	On 17
						1018	On 18
						1019	On 19
						1020	On 20
						1021	On 21
						1022	On 22
						1023	On 23
						1024	On 24
						1025	On 25
						1026	On 26
						1027	On 27
						1028	On 28
						1029	On 29
						1030	On 30
						1031	On 31
StartDate	Execution Start Date	Date	8	-
EndDate	Execution End Date	Date	8	-
LogInstanc	Log Instance	Int	11	-	0
CreateUser	Created by User	Int	6	OUSR
CreateDate	Creation Date	Date	8	-
CreateTime	Creation Time	Int	6	-
UpdateUser	Updated by User	nVarChar	6	OUSR
UpdateDate	Update Date	Date	8	-
UpdateTime	Update Time	Int	6	-
DataSource	Data Source	VarChar	1	-	N	N	Unknown
						I	Interface
						U	Upgrade
						M	Import
						O	DI API
						S	Service Layer
						W	Web Client
						A	Auto Summary
						D	Restore Wizard
						P	Partner Implementation
						T	Year Transfer
PriceUpdat	Prices Update	VarChar	1	-	N	Y	Yes
						N	No
CardCode	Customer/Vendor Code	nVarChar	15	OCRD

Key	Unique	Field
PRIMARY	Yes	AbsEntry