PA Invenotry Transfer Tax WORK file (PA10904)

azurecurveProductsProject Accounting (258)ProjectPA Invenotry Transfer Tax WORK file (PA10904)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA10904

Product: Project Accounting (258)
Series:

Display Name: PA Invenotry Transfer Tax WORK file
Physical Name: PA10904
Technical Name: PA_IV_Transfer_Tax_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAIV_Transfer_Type SearchPA IV Transfer TypeIntegerPA_DDL_IV_Transfer_Type0
2PAIV_Document_No SearchPA IV Document NoStringSTR17_LBAU17
3LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
4TAXDTLID SearchTax Detail IDStringSTR15_Tax_Detail_ID15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['PA Invenotry Transfer Tax WORK file'].TAXDTLID AS 'PA Invenotry Transfer Tax WORK file-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       PA10904 AS ['PA Invenotry Transfer Tax WORK file']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['PA Invenotry Transfer Tax WORK file'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
5VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PA Invenotry Transfer Tax WORK file'].VENDORID AS 'PA Invenotry Transfer Tax WORK file-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PA10904 AS ['PA Invenotry Transfer Tax WORK file']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PA Invenotry Transfer Tax WORK file'].VENDORID = ['PM Vendor Master File'].VENDORID
6TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
7BKOUTTAX SearchBackout TaxBooleanYN0
8PCTAXAMT SearchPurchases Tax AmountCurrencyDLR19_RBSO_UTR$19
9FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
10MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
11TXDTTPUR SearchTax Detail Total PurchasesCurrencyDLR19_RBS0_UTR$19
12TDTTXPUR SearchTax Detail Total Taxable PurchasesCurrencyDLR19_RBS0_UTR$19
13ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PA Invenotry Transfer Tax WORK file'].ACTINDX AS 'PA Invenotry Transfer Tax WORK file-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PA10904 AS ['PA Invenotry Transfer Tax WORK file']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PA Invenotry Transfer Tax WORK file'].ACTINDX = ['Account Index Master'].ACTINDX
azurecurveProductsProject Accounting (258)ProjectPA Invenotry Transfer Tax WORK file (PA10904)

Leave a Reply

Your email address will not be published. Required fields are marked *