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 ASI25800
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25800 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
USERID char

 The user t...(more) Join Now
join ... more text available
CMPANYID smallint

 Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
PABILLTRXT smallint
PADocnumber20 char
NOTEINDX numeric

 Note Index...(more) Join Now
join ... more text available
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
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
PATax_Detail_ID_Array_1 char
PATax_Detail_ID_Array_2 char
PATax_Detail_ID_Array_3 char
PATax_Detail_ID_Array_4 char
PATax_Detail_ID_Array_5 char
PATax_Detail_ID_Array_6 char
PATax_Detail_ID_Array_7 char
PATax_Detail_ID_Array_8 char
PATax_Detail_ID_Array_9 char
PATax_Detail_ID_Array_10 char
PATax_Amount_Array_1 numeric
PATax_Amount_Array_2 numeric
PATax_Amount_Array_3 numeric
PATax_Amount_Array_4 numeric
PATax_Amount_Array_5 numeric
PATax_Amount_Array_6 numeric
PATax_Amount_Array_7 numeric
PATax_Amount_Array_8 numeric
PATax_Amount_Array_9 numeric
PATax_Amount_Array_10 numeric
PAOTaxAmtArr_1 numeric
PAOTaxAmtArr_2 numeric
PAOTaxAmtArr_3 numeric
PAOTaxAmtArr_4 numeric
PAOTaxAmtArr_5 numeric
PAOTaxAmtArr_6 numeric
PAOTaxAmtArr_7 numeric
PAOTaxAmtArr_8 numeric
PAOTaxAmtArr_9 numeric
PAOTaxAmtArr_10 numeric
PAInvFrmtTaxDetailID_1 char
PAInvFrmtTaxDetailID_2 char
PAInvFrmtTaxDetailID_3 char
PAInvFrmtTaxDetailID_4 char
PAInvFrmtTaxDetailID_5 char
PAInvFrmtTaxDetailID_6 char
PAInvFrmtTaxDetailID_7 char
PAInvFrmtTaxDetailID_8 char
PAInvFrmtTaxDetailID_9 char
PAInvFrmtTaxDetailID_10 char
PAIFTaxAmount_1 numeric
PAIFTaxAmount_2 numeric
PAIFTaxAmount_3 numeric
PAIFTaxAmount_4 numeric
PAIFTaxAmount_5 numeric
PAIFTaxAmount_6 numeric
PAIFTaxAmount_7 numeric
PAIFTaxAmount_8 numeric
PAIFTaxAmount_9 numeric
PAIFTaxAmount_10 numeric
PAIFTaxAmount1_1 numeric
PAIFTaxAmount1_2 numeric
PAIFTaxAmount1_3 numeric
PAIFTaxAmount1_4 numeric
PAIFTaxAmount1_5 numeric
PAIFTaxAmount1_6 numeric
PAIFTaxAmount1_7 numeric
PAIFTaxAmount1_8 numeric
PAIFTaxAmount1_9 numeric
PAIFTaxAmount1_10 numeric
ADDRESS1 char
ADDRESS2 char
ADDRESS3 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
PAProject_Amount numeric

 PA Project...(more) Join Now PA01101.PAProject_Amount
PAROGPROJAMT numeric
PATOTCHGORDAMT numeric
PATOTCHGORDAMT2 numeric
PACOBASEPROJAMT numeric
PACOBASEPROJAMT2 numeric
PACOBSLNFEEPROJAMT numeric
PACOBSLNFEEPROJAMT2 numeric
PATOTCHGORDAMT1 numeric
PATOTCHGORDAMT11 numeric
PACOBASEPROJAMT1 numeric
PACOBASEPROJAMT11 numeric
PACOBSLNFEEPROJAMT1 numeric
PACOBSLNFEEPROJAMT11 numeric
PAPostedBillingsN numeric

 PA Actual ...(more) Join Now PA01101.PAPostedBillingsN
PAPostedBillingsN1 numeric
PAPOSTRETAMT numeric

 PA Actual ...(more) Join Now PA01101.PAPOSTRETAMT
PAPOSTRETAMT1 numeric
PABillingAmount1 numeric
PAOrigBillAmount1 numeric
PATMbillamount1 numeric
PAOrigBillingAmtTM1 numeric
PAFFbillamount1 numeric
PAOrigBillingAmtFF1 numeric
PAFeebillamount1 numeric
PAOrigBillingAmtFee1 numeric
PAFeebillamount2 numeric
PAFeebillamount21 numeric
PAFeebillamount211 numeric
PAFeebillamount2111 numeric
ACCTAMNT numeric

 Account Am...(more) Join Now
ORACTAMT numeric
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