Table > Module A/P-A/R accounting > Table Prepayment invoice

Table PREPINVOICE

Table	Abbreviation	Description	Module	Activity code
PREPINVOICE	PREPI	Prepayment invoice	A/P-A/R accounting	PREPM

Key	Description	Duplicates	Activity code
PREPI0	PCNTNUM	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
AUUID	Single identifier		AUUID
CCE	Dimension		CCE			[CCE]CCE0=DIE(indice);CCE(indice)	Block	ANA
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[PREPI]CREUSR	Other
CURLED	Ledger currency	10	CUR			[TCU]TCU0=[PREPI]CURLED	Block
CURTYP	Rate type		M	15	202
DEDTYP	Prepayment deduction type		M	15	2824
DIE	Dimension type code		DIE			[DIE]DIE0=[PREPI]DIE	Block	ANA
FNLBPACC	Final invoice control		SAC
FNLDAT	Final date		D
LED	Ledger	10	LED			[LED]LED0=[PREPI]LED	Block
PCNTAMTATI	Amount + tax		MD1
PCNTAMTNOT	Amount - tax		MD1
PCNTBPR	BP		BPR			[BPR]BPR0=[PREPI]PCNTBPR	Block
PCNTCUR	Contract currency		CUR			[TCU]TCU0=[PREPI]PCNTCUR	Block
PCNTDAT	Contract date		D
PCNTDEP	Early discount/Late charge		TDA			[TDA]TDA0=PCNTDEP;[V]GSUPCLE	Block
PCNTDESC	Description		A	50
PCNTFCY	Site		FCY			[FCY]FCY0=[PREPI]PCNTFCY	Block
PCNTNUM	Contract number		PREPI			[PREPI]PREPI0=[PREPI]PCNTNUM	BSRA
PCNTORI	Source		M	15	2825
PCNTPTE	Payment term		PTE			[TPT]TPT0=PCNTPTE;[V]GCURLEG;1	Block
PCNTTYP	Customer/Supplier		M	15	242
PCNTVAC	Tax rule		TVB			[TVB]TVB0=PCNTVAC;[V]GSUPCLE	Block
PPBPACC	Control		SAC
RATAPL	Applicable rate		M	15	2826
RATDAT	Rate date		D
RATDIV	Dividing rate	10	RCU
RATMLT	Multiplying rate	10	RCU
SOHNUM	Sales order		VCR					SALM
SOPLIN	Sales order line		L	8				SALM
SOPSEQ	Sequence		L	8				SALM
STAT	Status		M		2824
TOTPREPAMT	Total prepayment amt.		MD1					SALM
TOTPREPTAX	Total prepayment tax		MD1					SALM
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[PREPI]UPDUSR	Other
VAT	Tax code		VAT			[TVT]TVT0=VAT(indice);[V]GSUPCLE	Block