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

COMPANY..PA10900 Table Definition

(COMPANY..PA Inventory Transfer Work Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAIV_Document_No char(17)
''

PAIV_Transfer_Type smallint
0

IVDOCNBR char(17)
''
IV Documen...(more) Join Now IV10000.IVDOCNBR
PADOCDT datetime
'1/1/1900'

PAREFNO char(17)
''

VENDORID char(15)
''
Vendor ID ...(more) Join Now WC010931.VENDORID
join ... more text available
PAYR smallint
0

PAPD datetime
'1/1/1900'

USERID char(15)
''
The user t...(more) Join Now WRS10001.USERID
join ... more text available
BACHNUMB char(15)
''
Batch Numb...(more) Join Now UPR10304.BACHNUMB
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
PACOMM char(51)
''

REQSTDBY char(21)
''
Requested ...(more) Join Now POP10110.REQSTDBY
PATQTY numeric(19,5)
0.00

PAtotcosts numeric(19,5)
0.00

PATACRV numeric(19,5)
0.00

PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(more) Join Now
PAIV_HDR_Errors binary(4)
0

PAIVDistributionErrors binary(4)
0

LNITMSEQ int
0
Line Item ...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
TAXSCHID char(15)
''

join ... more text available
PAVENADDRESSID char(15)
''

SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now RM20101.Tax_Date
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now POP10300.TaxInvRecvd
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now POP30300.TaxInvReqd
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