DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module ASI tables ASI25831
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25831 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CMPANYID smallint

 Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
USERID char

 The user t...(more) Join Now
join ... more text available
PABILLTRXT smallint
PADocnumber20 char
PADOCDT datetime
PAPD datetime
BACHNUMB char

 Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char

 Batch Sour...(more) Join Now
TRXSORCE char

 Transactio...(more) Join Now
PAuserid char
LSTEDTDT datetime

 Last Edit ...(more) Join Now ICJC9000.LSTEDTDT
LSTUSRED char
PABill_HDR_Errors binary
PABill_Distribution_Er binary
PAREFNO char
CUSTNMBR char

 Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
CUSTNAME char
TXRGNNUM char

 Tax Regist...(more) Join Now EDCVAT41.TXRGNNUM
CSTPONBR char
PRBTADCD char

 Primary Bi...(more) Join Now PA01101.PRBTADCD
join ... more text available
PYMTRMID char

 Payment Te...(more) Join Now RM50105.PYMTRMID
SY033... more text available
PABILLFORMAT char

 The defaul...(more) Join Now PA01101.PABILLFORMAT
PACOMM char
CURNCYID char

 Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
CURRNIDX smallint

 Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
RTCLCMTD smallint

 Rate calcu...(more) Join Now MC40300.RTCLCMTD
XCHGRATE numeric

 Exchange R...(more) Join Now MC00100.XCHGRATE
DENXRATE numeric

 Exchange R...(more) Join Now PTE30501.DENXRATE
PAUD1 char

 PA User De...(more) Join Now PA11801.PAUD1
PAUD2 char

 PA User De...(more) Join Now PA11801.PAUD2
CASHAMNT numeric

 Cash Amoun...(more) Join Now PTE30500.CASHAMNT
ORCASAMT numeric

 Originatin...(more) Join Now PTE30500.ORCASAMT
CBKIDCSH char
CASHDATE datetime
DCNUMCSH char
CHEKAMNT numeric

 Check Amou...(more) Join Now PTE30500.CHEKAMNT
ORCHKAMT numeric

 Originatin...(more) Join Now PTE30500.ORCHKAMT
CBKIDCHK char
CHEKNMBR char
CHEKDATE datetime
DCNUMCHK char
CRCRDAMT numeric

 Credit Car...(more) Join Now PTE30500.CRCRDAMT
ORCCDAMT numeric

 Originatin...(more) Join Now PTE30500.ORCCDAMT
CRCRDNAM char
RCTNCCRD char
CRCARDDT datetime

 Credit Car...(more) Join Now PTE30500.CRCARDDT
DCNUMCRD char
DSCPCTAM smallint

 Discount P...(more) Join Now PA01101.DSCPCTAM
DSCDLRAM numeric
ORDDLRAT numeric

 Originatin...(more) Join Now PTE30500.ORDDLRAT
DISAVAMT numeric

 Discount A...(more) Join Now ICJC9000.DISAVAMT
ORDAVAMT numeric
DISCAMNT numeric
DISCDATE datetime

 Discount D...(more) Join Now PTE30500.DISCDATE
DISTKNAM numeric

 Discount T...(more) Join Now RM20102.DISTKNAM
PAOrigDiscTakenAmt numeric
DISCRTND numeric

 Discount R...(more) Join Now ICJC9000.DISCRTND
PAOrigDiscRetAmt numeric
PADISCRETAMT numeric
PAODISCRETAMT numeric
PABillingAmount numeric
PAOrigBillAmount numeric
TRDISAMT numeric

 Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric
PA_Freight_Amount numeric
PAOrigFreightAmt numeric
FRTTXAMT numeric

 Freight Ta...(more) Join Now PTE30500.FRTTXAMT
ORFRTTAX numeric

 Originatin...(more) Join Now PTE30500.ORFRTTAX
PA_Misc_Amount numeric
PAOrigMiscAmt numeric
MSCTXAMT numeric

 Misc Tax A...(more) Join Now PTE30500.MSCTXAMT
ORMSCTAX numeric

 Originatin...(more) Join Now PTE30500.ORMSCTAX
PATOTTAX numeric
PAOrigTotalTaxAmt numeric
PABACKBILL numeric
PAOrigBackoutBillAmt numeric
BKTFRTAM numeric

 Backout Fr...(more) Join Now ICJC9001.BKTFRTAM
ORBKTFRT numeric
BKTMSCAM numeric

 Backout Mi...(more) Join Now ICJC9001.BKTMSCAM
ORBKTMSC numeric
DOCAMNT numeric

 Source Doc...(more) Join Now RVLPD026.DOCAMNT
ORDOCAMT numeric

 Orig Docum...(more) Join Now RVLPD026.ORDOCAMT
DUEDATE datetime

 Due Date T...(more) Join Now MOP1071.DUEDATE
APPLDAMT numeric
ORAPPAMT numeric
PALastDateApplied datetime
SLPRSNID char

 Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
SALSTERR char

 Sales Terr...(more) Join Now PA01101.SALSTERR
join ... more text available
TAXSCHID char
join ... more text available
COMDLRAM numeric

 Field Type...(more) Join Now ICJC9000.COMDLRAM
ORCOMAMT numeric
COMAPPTO smallint

 Commission...(more) Join Now PA01101.COMAPPTO
LNITMSEQ int

 Line Item ...(more) Join Now PA11801.LNITMSEQ
CUTOFDAT datetime
SHIPMTHD char
join ... more text available
MSCSCHID char
join ... more text available
MISCTXBL smallint
FRTSCHID char

 Freight Sc...(more) Join Now RM30101.FRTSCHID
join ... more text available
FRGTTXBL smallint
PARetentionFeeAmount numeric

 PA Retenti...(more) Join Now PA01101.PARetentionFeeAmount
PAOrigRetentionFeeAmt numeric
PAtotbillings numeric
PAOrigTotalBilings numeric
PARetainer_Fee_Amount numeric

 PA Project...(more) Join Now PA01101.PARetainer_Fee_Amount
PAOrigRetainerFeeAmt numeric
ADDRESS1 char
ADDRESS2 char
COUNTRY char
CITY char
STATE char
ZIP char
DCSTATUS smallint
PAlastprtby char
PAlastprtdate datetime
PAsfid smallint
PASFile char
PYMTRCVD numeric
ORPMTRVD numeric
BALNCDUE numeric
Outstanding_Amount numeric
PAOOUTSTANDINGAMT numeric
ORIGIN smallint
CNTCPRSN char

 Contact Pe...(more) Join Now PA01101.CNTCPRSN
ADRSCODE char

 Address Co...(more) Join Now PA01101.ADRSCODE
PRSTADCD char
join ... more text available
STADDRCD char
DOCHDR char
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3