Module List > Module ASI tables ASI25803
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25803 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


PACONTNUMBER char

PA Contrac...(more) Join Now PA01101.PACONTNUMBER
PAPROJNUMBER char

PA Project...(more) Join Now PA11801.PAPROJNUMBER
join ... more text available
PATranType smallint

The Type o...(more) Join Now PA01901.PATranType
PACOSTDATE datetime


PACOSTCATID char

PA Cost Ca...(more) Join Now PA11801.PACOSTCATID
PABILLSEQ int


PABILLSUBLINESEQ int


PABill_Format_Key smallint


PAPrintSortOrd smallint


PABILLDOCNO int


PAREFNO char


PACOMM char


PABILLITEMID char


PABILLITEMNAME char


PACOSTDOCNO char


PACOSTSEQNO int


PACOSTDOCDATE datetime


PACOSTOWNER char


PACost_Owner_Name char


PACOSTCATNME char


PAitemnumber char


PABILRATE numeric


PAORIGBILLRATE numeric


PAQtyQ numeric


PAACREV numeric


PAORIACCRREV numeric


PAtotcosts numeric


PAORIGTOTCOSTS numeric


PABilled_QtyN numeric

PA Billed ...(more) Join Now PA11801.PABilled_QtyN
PANETBILLAMT numeric


PAONETBILLINGAMT numeric


PARecognizedRevenue numeric


PAOrigRecogRevenue numeric


TAXAMNT numeric

Tax Amount...(more) Join Now PA11801.TAXAMNT
ORTAXAMT numeric

Originatin...(more) Join Now PTE30501.ORTAXAMT
PABACKBILL numeric


PAOrigBackoutBillAmt numeric


TRDISAMT numeric

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


PATOTALOVERH numeric


PAORIGTOTOVRHD 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


PAbillnoteidx numeric

PA Billing...(more) Join Now PA01101.PAbillnoteidx
PAbllngtype smallint

PA Billing...(more) Join Now PA11801.PAbllngtype
PAUnit_of_Measure char

PA Unit of...(more) Join Now PA11801.PAUnit_of_Measure
PAMARKPERCENT numeric


PAGROSSBILLAMT numeric


PAOGROSSBILLINGAMT numeric


PAMUDP1 smallint


PAMUDD numeric


PAOMUDD numeric


PASales_Tax_Options smallint

PA Sales T...(more) Join Now PA02101.PASales_Tax_Options
TAXSCHID char


join ... more text available
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
3