Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA42401
Product: Project Accounting (258)
Series:
Display Name: PA Employee Expense Setup
Physical Name: PA42401
Technical Name: PA_Employee_Expense_SETP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PAsetupkey | PA Setup Key | Integer | INT1 | 1 | |
2 | PAerdefinedprompt1 | PA User Defined Prompt 1 - EE | String | STR15 | 15 | |
3 | PAerdefinedprompt2 | PA User Defined Prompt 2 - EE | String | STR15 | 15 | |
4 | PAcostdescer | PA Cost Description - EE | String | STR20 | 20 | |
5 | PAerdoccounter | PA Empl Expense Document Counter | String | STR17_LBAU | 17 | |
6 | PAVIDROAer | PA Unit Cost From - EE | Integer | PA_DDL_Unit_Cost_From - EE | 0 | |
7 | PAeeprofittypefrom | PA Profit Type From - EE | Integer | PA_DDL_Profit_Type_From - EE | 0 | |
8 | PAdescriptionfrom | PA Description From | Integer | PA_DDL_Description_From | 0 | |
9 | USEADVTX | Use Advanced Taxes | Integer | GB | 0 | |
10 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Setup'].TAXSCHID AS 'PA Employee Expense Setup-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA42401 AS ['PA Employee Expense Setup']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Setup'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
11 | PAMisc_Taxable_P | PA Misc Taxable - Purchase | Integer | PA_DDL_Tax_Options_Purchase | 0 | |
12 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Setup'].MSCSCHID AS 'PA Employee Expense Setup-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA42401 AS ['PA Employee Expense Setup']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Setup'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
13 | PAFreight_Taxable_P | PA Freight Taxable - Purchase | Integer | PA_DDL_Tax_Options_Purchase | 0 | |
14 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Setup'].FRTSCHID AS 'PA Employee Expense Setup-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA42401 AS ['PA Employee Expense Setup']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Setup'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
15 | PAallow_1 | PA Allow Options[1] | Boolean | CB | 0 | |
16 | PAallow | PA Allow Options | CB | Boolean | 0 | |
17 | PAallow_2 | PA Allow Options[2] | Boolean | CB | 0 | |
18 | PAallow_3 | PA Allow Options[3] | Boolean | CB | 0 | |
19 | PAallow_4 | PA Allow Options[4] | Boolean | CB | 0 | |
20 | PAallow_5 | PA Allow Options[5] | Boolean | CB | 0 | |
21 | PAallow_6 | PA Allow Options[6] | Boolean | CB | 0 | |
22 | PAallow_7 | PA Allow Options[7] | Boolean | CB | 0 | |
23 | PAallow_8 | PA Allow Options[8] | Boolean | CB | 0 | |
24 | PAallow_9 | PA Allow Options[9] | Boolean | CB | 0 | |
25 | PAallow_10 | PA Allow Options[10] | Boolean | CB | 0 | |
26 | PAallow_11 | PA Allow Options[11] | Boolean | CB | 0 | |
27 | PAallow_12 | PA Allow Options[12] | Boolean | CB | 0 | |
28 | PAallow_13 | PA Allow Options[13] | Boolean | CB | 0 | |
29 | PApasswordoptions_1 | PA Password Options[1] | String | Password | 10 | |
30 | PApasswordoptions | PA Password Options | Password | String | 10 | |
31 | PApasswordoptions_2 | PA Password Options[2] | String | Password | 10 | |
32 | PApasswordoptions_3 | PA Password Options[3] | String | Password | 10 | |
33 | PApasswordoptions_4 | PA Password Options[4] | String | Password | 10 | |
34 | PApasswordoptions_5 | PA Password Options[5] | String | Password | 10 | |
35 | PApasswordoptions_6 | PA Password Options[6] | String | Password | 10 | |
36 | PApasswordoptions_7 | PA Password Options[7] | String | Password | 10 | |
37 | PApasswordoptions_8 | PA Password Options[8] | String | Password | 10 | |
38 | PApasswordoptions_9 | PA Password Options[9] | String | Password | 10 | |
39 | PApasswordoptions_10 | PA Password Options[10] | String | Password | 10 | |
40 | PApasswordoptions_11 | PA Password Options[11] | String | Password | 10 | |
41 | PApasswordoptions_12 | PA Password Options[12] | String | Password | 10 | |
42 | PApasswordoptions_13 | PA Password Options[13] | String | Password | 10 | |
43 | PAbillnoteidx | PA Billing Note Index | Currency | DLR14 | 14 | |
44 | PAExpenseType | PA Expense Type | Integer | PA_DDL_Expense_Type | 0 | |
45 | PAPaymentMethod | PA Payment Method | Integer | PA_DDL_Payment_Method | 0 | |
46 | PApostoDynPM | PA Post to Dyn Payables Mgmt | Boolean | PA_CB_Post_PM | 0 | |
47 | PA_Update_Periodic_Opt | PA Update Periodic Option | Integer | PA_RG_Update_Periodic_Option | 0 |