PTE Employee Expense Header (PTE10500)

azurecurveProductsProject Accounting (258)ProjectPTE Employee Expense Header (PTE10500)

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

Product: Project Accounting (258)
Series:

Display Name: PTE Employee Expense Header
Physical Name: PTE10500
Technical Name: PTE_Employee_Expense_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PTE_Empl_Expense_Doc_No SearchPTE Empl Expense Document NoStringSTR30_Item_Number30
2PADOCDT SearchPA Document DateDatePA_Date8
3PAYR SearchPA YearIntegerINT44
4EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
5PAStartDate SearchPA Start DateDateDT8
6PAEnDate SearchPA End DateDateDT8
7PACOMM SearchPA CommentStringSTR5050
8PTE_Total_Quantity SearchPTE Total QuantityCurrencyDLR17_QTY_RBS0_UTR17
9PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
10OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
11PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
12PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
13PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
14PATACRV SearchPA Total Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
15DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
16ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
17TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
18OR1099AM SearchOriginating 1099 AmountCurrencyDLR17_RBS0_UTR$17
19UN1099AM SearchUnapplied 1099 AmountCurrencyDLR17_RBS0_UTR$17
20PAVENADDRESSID SearchPA Vendor Address IDStringSTR15_Address_Code15
21PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].PYMTRMID AS 'PTE Employee Expense Header-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PTE Employee Expense Header'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
22DUEDATE SearchDue DateDateDT8
23DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
24ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
25DISCDATE SearchDiscount DateDateDT8
26DISAMTAV SearchDiscount Amount AvailableCurrencyDLR17_RBS0_UTR$17
27ODISAMTAV SearchOriginating Discount Amount AvailableCurrencyDLR17_RBS0_UTR$17
28DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
29ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
30BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
31OBKPURAMT SearchOriginating Backout Purchases AmountCurrencyDLR19_RBS0_UTR$19
32SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].SHIPMTHD AS 'PTE Employee Expense Header-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PTE Employee Expense Header'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
33PRCTDISC SearchPercent DiscountIntegerINT5_%25
34TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
35ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
36FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
37ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
38MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
39OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
40PAPD SearchPA Post DateDatePA_Date8
41CARDNAME SearchCard NameStringSTR15_Card_Name15
42CRCRDAMT SearchCredit Card AmountCurrencyDLR19_RBS0_UTR$19
43ORCCDAMT SearchOriginating Credit Card AmountCurrencyDLR19_RBSO_UTR$19
44CRCARDDT SearchCredit Card DateDateDATE6
45CCRCTNUM SearchCredit Card Receipt NumberStringSTR20_Document_Number20
46TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
47ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
48TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].TAXSCHID AS 'PTE Employee Expense Header-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PTE Employee Expense Header'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
49PAFreight_Taxable_P SearchPA Freight Taxable - PurchaseIntegerPA_DDL_Tax_Options_Purchase0
50FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].FRTSCHID AS 'PTE Employee Expense Header-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PTE Employee Expense Header'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51FRTTXAMT SearchFreight Tax AmountCurrencyDLR19_RBSO_UTR$19
52ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
53ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
54ODAVPUR SearchOriginating Discount Available PurchasesCurrencyDLR17_RBS0_UTR$17
55ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
56PAMisc_Taxable_P SearchPA Misc Taxable - PurchaseIntegerPA_DDL_Tax_Options_Purchase0
57MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].MSCSCHID AS 'PTE Employee Expense Header-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PTE Employee Expense Header'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
58MSCTXAMT SearchMisc Tax AmountCurrencyDLR19_RBSO_UTR$19
59ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
60CHRGAMNT SearchCharge AmountCurrencyDLR19_RBSO_UTR$19
61OCHGAMT SearchOriginating Charge AmountCurrencyDLR19_RBSO_UTR$19
62NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].NOTEINDX AS 'PTE Employee Expense Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PTE Employee Expense Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
63CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].CURNCYID AS 'PTE Employee Expense Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE Employee Expense Header'].CURNCYID = ['Currency Setup'].CURNCYID
64CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].CURRNIDX AS 'PTE Employee Expense Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE Employee Expense Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
65RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].RATETPID AS 'PTE Employee Expense Header-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PTE Employee Expense Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
66EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].EXGTBLID AS 'PTE Employee Expense Header-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PTE Employee Expense Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
67XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
68EXCHDATE SearchExchange DateDateDT_Date6
69TIME1 SearchTimeTimeTM66
70DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
71PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
72PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
73PAREIMBURSTAXAMT SearchPA Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
74PAORIGREIMTAXAMT SearchPA Originating Reimbursable Tax AmountCurrencyPA_DLR17_RBS0_STR$17
75PAerdocnumber SearchPA Empl Expense Document No.StringSTR30_LBAU30
76BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
77OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
78PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
79Tax_Date SearchTax DateDateDT8
80TaxInvRecvd SearchTax Invoice ReceivedBooleanCB_Tax_Invoice_Received0
81TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
82CAMCBKID SearchCash Amount Checkbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].CAMCBKID AS 'PTE Employee Expense Header-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PTE Employee Expense Header'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
83CDOCNMBR SearchCash Document NumberStringSTR20_Document_Number20
84CAMTDATE SearchCash Amount DateDateDT8
85CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
86ORCASAMT SearchOriginating Cash AmountCurrencyDLR19_RBSO_UTR$19
87CHAMCBID SearchCheck Amount Checkbook IDStringSTR15_Checkbook_ID15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].CHAMCBID AS 'PTE Employee Expense Header-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PTE Employee Expense Header'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
88CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
89CHEKDATE SearchCheck DateDateDATE6
90CHEKAMNT SearchCheck AmountCurrencyDLR19_RBS0_UTR$19
91ORCHKAMT SearchOriginating Check AmountCurrencyDLR19_RBSO_UTR$19
92TEN99TYPE Search1099 TypeInteger1099_Type0
93TEN99BOXNUMBER Search1099 Box NumberIntegerDDL_1099_Box0
94Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
95RTCLCMTD SearchRate Calculation MethodIntegerGB0
96MCTRXSTT SearchMC Transaction StateIntegerINT11
97USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PTE Employee Expense Header'].USERID AS 'PTE Employee Expense Header-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PTE10500 AS ['PTE Employee Expense Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PTE Employee Expense Header'].USERID = ['Users Master'].USERID
98SupervisorADLogin SearchSupervisor ADLoginStringSTR8585
99wfShowOverBudgetWarning SearchwfShowOverBudgetWarningLong IntegerwfShowOverBudgetWarning0
azurecurveProductsProject Accounting (258)ProjectPTE Employee Expense Header (PTE10500)

Leave a Reply

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