DanB
(Daniel Bilsky)
February 21, 2017, 5:25pm
1
Hey people, how are u?
Anyone know where i can find a full system transactions values?, (the values used on “System Transaction” of “Transaction Document Type Maintance”)
On help about field see this…
and on tecnical details:
but i see more than the items detailed there… i need a list of all of these. And cant find a referenced table or anithing like that.
Appreciate our answers.
Slds
DanB
(Daniel Bilsky)
February 21, 2017, 6:29pm
2
Ok, here i get the answer, but if any1 know if any db table contains this information, this will very appreciated.
This list was taken to pure lung:
APAdjust - AP Adjustment
APBillExch - AP Bill of Exchange
APInvoice - AP Invoice
APPay - AP Payment
APVoidPay - AP Void Payment
ARAdjust - AR Adjustment
ARBillExch - AR Bill of Exchange
ARInvoice - AR Invoices
ARTaxConf - AR Tax Confirmation
BankAdj - Bank Adjustment
BFundsXfer - Bank Funds Transfer
BStatement - Bank Statement
CashReceipt - Cash Receipts
CashRecCncl - Cash Receipts Cancellation
CountCycle - Count Cycle
CreditMemo - Credit Memos
DebitMemo - Debit Memo
DefExp - Deferred Expenses
DMRProc - DMR Process
GLJournal - GL Journal Entry
InspProc - Inspection Processing
MasterPack - Master Pack
MiscShip - Miscellaneous Shipment
NonConf - Nonconformance
PackSlip - Packing Slips
PayIAP - Payment Instrument AP
PayIAR - Payment Instrument AR
PIMoveAP - PI Movement AP
PIMoveAR - PI Movement AR
JPPB - Periodic Billing
PCI - Petty Cash Issue
PCR - Petty Cash Receipt
PCDR - Petty Cash Day Report
POReceipt - PO Receipt
RSubCnt - Receive from Sub-contract
RetSupplier - Return to Supplier
RMARcpt - RMA Receipt
SCShip - Subcontractor Shipment
StockStock - Stock to Stock
StockWIP - Stock to WIP
STQtyAdj - Stock Quantity Adjustment
STValAdj - Stock Value Adjustment
TOrderShip - Transfer Order Shipment
TxRec - Tax Receipt
UnappRecCM - Unapplied Receipt (CM)
WIPStock - WIP to Stock
WIPWIP - WIP to WIP
WTaxCert - Witholding Tax Certificate
Chris_Conn
(Chris Conn)
February 21, 2017, 7:33pm
3
Can you make a BAQ on the trandoctype table?
bordway
(Bruce Ordway)
February 21, 2017, 7:59pm
4
BAQ - yes - returns any existing records.
DanB
(Daniel Bilsky)
March 1, 2017, 5:44pm
5
Dont work for me, if i do a BAQ returning the rows of trandoctype table, i dont have all of the SystemTranID , Except if i have 1 TranDocType foreach SystemTranID … (not my case)
i need the list of all SystemTranID posible values.