DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module GL tables > GL10300

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
You are currently viewing the COMPANY database.
Change

COMPANY..GL10300 Table Definition

(COMPANY..General Ledger Tax Work)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
JRNENTRYint Journal En...(more) Join Now DTA10100.JRNENTRY
GP 9
RCTRXSEQnumeric(19,5) Recurring ...(more) Join Now GL10000.RCTRXSEQ
GP 9
SQNCLINEnumeric(19,5) Sequence L...(more) Join Now GL10000.SQNCLINE
GP 9
SQNCLINE2numeric(19,5)
GP 9
TAXDTLIDchar(15) Tax Detail...(more) Join Now PM10500.TAXDTLID
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
Tax_Datedatetime Tax Date: ...(more) Join Now RM20101.Tax_Date
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now PM10000.PSTGDATE
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now RM20101.TAXAMNT
GP 9
ORTAXAMTnumeric(19,5) Orig Tax A...(more) Join Now POP10300.ORTAXAMT
GP 9
Taxable_Amountnumeric(19,5) PAM20601.Taxable_Amount
GP 9
Originating_Taxable_Amtnumeric(19,5) TX30000.Originating_Taxable_Amt
GP 9
DOCAMNTnumeric(19,5) Source Doc...(more) Join Now PM10000.DOCAMNT
GP 9
ORDOCAMTnumeric(19,5) Orig Docum...(more) Join Now SOP10100.ORDOCAMT
GP 9
TXDTLPCTnumeric(19,5) Tax Detail...(more) Join Now TX00201.TXDTLPCT
GP 9
TXDTLAMTnumeric(19,5) Tax Detail...(more) Join Now TX00201.TXDTLAMT
GP 9
TXDTLTYPsmallint Tax Detail...(more) Join Now TX00201.TXDTLTYP
GP 9
ACTINDXint Account In...(more) Join Now
GP 9
join GL00100 on GL00100.ACTINDX = GL10300.ACTINDX
CURRNIDXsmallint Currency I...(more) Join Now CM20200.CURRNIDX
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL10300.CURRNIDX
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9