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

COMPANY..ASI25899 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
PADocnumber20 char
PABILLTRXT smallint
PADOCDT datetime
PACOMM char
CUSTNMBR char

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

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

 Contact Pe...(more) Join Now PA01101.CNTCPRSN
ADDRESS1 char
ADDRESS2 char
ADDRESS3 char
CITY char
STATE char
ZIP char
COUNTRY char
ADRSCODE char

 Address Co...(more) Join Now PA01101.ADRSCODE
PRSTADCD char
join ... more text available
STADDRCD 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
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
PAIFTaxDetailName_1 char
PAIFTaxDetailName_2 char
PAIFTaxDetailName_3 char
PAIFTaxDetailName_4 char
PAIFTaxDetailName_5 char
PAIFTaxDetailName_6 char
PAIFTaxDetailName_7 char
PAIFTaxDetailName_8 char
PAIFTaxDetailName_9 char
PAIFTaxDetailName_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
Outstanding_Amount numeric
PAOOUTSTANDINGAMT numeric
PA_Inv_Frmt_TM tinyint
PA_Inv_Frmt_IV tinyint
PA_Inv_Frmt_CPFP tinyint
PA_Inv_Frmt_Fee tinyint
PAtotbillings numeric
PAOrigTotalBilings numeric
PARetentionFeeAmount numeric

 PA Retenti...(more) Join Now PA01101.PARetentionFeeAmount
PAOrigRetentionFeeAmt numeric
TRDISAMT numeric

 Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric
PA_Freight_Amount numeric
PAOrigFreightAmt numeric
PA_Misc_Amount numeric
PAOrigMiscAmt numeric
PATOTTAX numeric
PAOrigTotalTaxAmt numeric
PABillingAmount numeric
PAOrigBillAmount numeric
PARetainer_Fee_Amount numeric

 PA Project...(more) Join Now PA01101.PARetainer_Fee_Amount
PAOrigRetainerFeeAmt numeric
DOCAMNT numeric

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

 Orig Docum...(more) Join Now RVLPD026.ORDOCAMT
CASHAMNT numeric

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

 Originatin...(more) Join Now PTE30500.ORCASAMT
CHEKAMNT numeric

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

 Originatin...(more) Join Now PTE30500.ORCHKAMT
CRCRDAMT numeric

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

 Originatin...(more) Join Now PTE30500.ORCCDAMT
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
PAProject_Amount numeric

 PA Project...(more) Join Now PA01101.PAProject_Amount
PAProject_Amount1 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
CSTPONBR 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