Module List > Module PA tables PA13200
You are currently viewing the COMPANY database.
Change

COMPANY..PA13200 Table Definition

(COMPANY..PA Billing Detail WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PABILLTRXT smallint
0

PADocnumber20 char(17)
''

PADOCDT datetime
'1/1/1900'

PAREFNO char(17)
''

LNITMSEQ int
0
Line Item ...(more) Join Now
CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
PACONTNUMBER char(11)
''
PA Contrac...(more) Join Now
PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PAProjectType smallint
0
Project ty...(more) Join Now
PApurordnum char(17)
''
The purcha...(more) Join Now
PABillingAmount numeric(19,5)
0.00

PATMbillamount numeric(19,5)
0.00

PAFFbillamount numeric(19,5)
0.00

PAFeebillamount numeric(19,5)
0.00

PAtotbillings numeric(19,5)
0.00

PA_Discount_Type smallint
0

TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
PA_Trade_Discount_Pcnt smallint
0

PATOTTAX numeric(19,5)
0.00

PATMtaxamt numeric(19,5)
0.00

PAFFtaxamt numeric(19,5)
0.00

PAFeetaxamount numeric(19,5)
0.00

PABACKBILL numeric(19,5)
0.00

PATMbckoutbillamt numeric(19,5)
0.00

PAPBbckoutbillamt numeric(19,5)
0.00

PAFeebckoutbillamt numeric(19,5)
0.00

APPLDAMT numeric(19,5)
0.00

ACCTAMNT numeric(19,5)
0.00
Account Am...(more) Join Now
PARetentionFeeAmount numeric(19,5)
0.00
PA Retenti...(more) Join Now
PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PABill_Line_Errors binary(4)
0

PA_Applied_Retainer numeric(19,5)
0.00

PA_Retainer_Applied tinyint
0

PA_Applied_Freight_Misc numeric(19,5)
0.00

PA_Trade_IDX int
0

TAXSCHID char(15)
''

join ... more text available
PAOrigBillAmount numeric(19,5)
0.00

PAOrigBillingAmtTM numeric(19,5)
0.00

PAOrigBillingAmtFF numeric(19,5)
0.00

PAOrigBillingAmtFee numeric(19,5)
0.00

PAOrigTotalBilings numeric(19,5)
0.00

PAOrigTotalTaxAmt numeric(19,5)
0.00

PAOrigTaxAmtTM_ numeric(19,5)
0.00

PAOrigTaxAmtFF numeric(19,5)
0.00

PAOrigTaxAmtFee numeric(19,5)
0.00

PAOrigBackoutBillAmt numeric(19,5)
0.00

PAOrigBackoutBillTM numeric(19,5)
0.00

PAOrigBackoutBillFF numeric(19,5)
0.00

PAOrigBackoutBillFee numeric(19,5)
0.00

PAOrigRetentionFeeAmt numeric(19,5)
0.00

PAOrigRetainerFeeAmt numeric(19,5)
0.00

PAOrigAppliedDocAmt numeric(19,5)
0.00

PAOrigAppliedFreightMisc numeric(19,5)
0.00

ORTDISAM numeric(19,5)
0.00
Orig Trade...(more) Join Now POP10300.ORTDISAM
ORAPPAMT numeric(19,5)
0.00

ORACTAMT numeric(19,5)
0.00
Orig Accou...(more) Join Now SOP30200.ORACTAMT
BCKTXAMT numeric(19,5)
0.00
Backout Ta...(more) Join Now POP10100.BCKTXAMT
OBTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OBTAXAMT
PA_Third_Party_CB tinyint
0

BackoutTradeDiscTax numeric(19,5)
0.00
Backout Tr...(more) Join Now POP10100.BackoutTradeDiscTax
OrigBackoutTradeDiscTax numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.OrigBackoutTradeDiscTax
PA_Backout_Retention_Tax numeric(19,5)
0.00

PA_OrigBackRetentionTax numeric(19,5)
0.00

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