ddpar3_raw

Core Schemas > Silverlake > ddpar3_raw

Column name	Description	Mode	Type	Length
__op	Contains the operation type. Values are I for insert, U for update, D for delete.	REQUIRED	STRING
__op_ts	operation timestamp added by export code	REQUIRED	TIMESTAMP
__uid	The Unique ID of this entry. Data, UUID, or GUID	REQUIRED	STRING
__ver	Mapping and Schema Version	REQUIRED	INTEGER
trancd	Transaction code \| DEC(5,0)	NULLABLE	INTEGER	5
revrtc	Reversal code \| DEC(5,0)	NULLABLE	INTEGER	5
dorc	Debit/Credit Code \| CHAR(1)	NULLABLE	STRING	1
bori	Affects Balance/Interest \| CHAR(1)	NULLABLE	STRING	1
efttyp	EFT type code \| CHAR(3)	NULLABLE	STRING	3
fpay	Force Pay \| CHAR(1)	NULLABLE	STRING	1
stops	Check for Stops \| CHAR(1)	NULLABLE	STRING	1
stmt	Stmt Print Code \| CHAR(2)	NULLABLE	STRING	2
scitem	Sc Item \| CHAR(1)	NULLABLE	STRING	1
timnsf	Reversal/returned item? \| CHAR(1)	NULLABLE	STRING	1
mmddr	MMD Dr Count \| CHAR(1)	NULLABLE	STRING	1
listpo	List Post \| CHAR(1)	NULLABLE	STRING	1
pstseq	Posting sequence \| CHAR(1)	NULLABLE	STRING	1
cntenc	Count as enclosure? \| CHAR(1)	NULLABLE	STRING	1
description	Description \| CHAR(30)	NULLABLE	STRING	30
stmdsc	Statement Description \| CHAR(30)	NULLABLE	STRING	30
desstm	Print desc on stmt \| CHAR(1)	NULLABLE	STRING	1
recid	Record identifier \| CHAR(1)	NULLABLE	STRING	1
updtdla	Update Last Active Date \| CHAR(1)	NULLABLE	STRING	1
p3arpntprt	ARP Netteller protect \| CHAR(1)	NULLABLE	STRING	1
p3arpextrc	ARP item extract \| CHAR(1)	NULLABLE	STRING	1
p3trkrefnd	Track as Refund \| CHAR(1)	NULLABLE	STRING	1
p3affnsf	Affects PD/RET/OD ACCR \| CHAR(1)	NULLABLE	STRING	1
p3updnsf	Update STD/YTD/BOTH \| CHAR(1)	NULLABLE	STRING	1
p3cobal	Charge Off Bal affected \| CHAR(1)	NULLABLE	STRING	1
p3rndchg	Round the change \| CHAR(1)	NULLABLE	STRING	1
p3tsa1	Tch Srv use only fld A1 \| CHAR(1)	NULLABLE	STRING	1
p3tsa2	Tch Srv use only fld A2 \| CHAR(1)	NULLABLE	STRING	1
p3tsa3	Tch Srv use only fld A3 \| CHAR(2)	NULLABLE	STRING	2
p3tsa4	Tch Srv use only fld A4 \| CHAR(2)	NULLABLE	STRING	2
p3ieodo	Increment excess OD Occ \| CHAR(1)	NULLABLE	STRING	1
updtdlc	Update Date Last Contact \| CHAR(1)	NULLABLE	STRING	1
updtdlcrel	Relationships for DLC update \| CHAR(135)	NULLABLE	STRING	135
ddpar3_id	Unique row ID \| BIGINT(8)	NULLABLE	INTEGER	8
dd3crtts	Row create timestamp \| TIMESTAMP LEN(26)	NULLABLE	STRING	26
dd3mntts	Row last maint timestamp \| TIMESTAMP LEN(26)	NULLABLE	STRING	26

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.

Last updated Thu Dec 12 2024