PA Combined History Header file (PA11800)

azurecurveProductsProject Accounting (258)ProjectPA Combined History Header file (PA11800)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Combined History Header file
Physical Name: PA11800
Technical Name: PA_Combined_History_WORK_HDR

Group Display Name: PA Combined History
Group Technical Name: PA Combined History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
2PADocnumber20 SearchPA Document No.STR17_LBAUString17
3PATRXType SearchPA TRX TypePA_DDL_TRX_TypeInteger0
4PADOCDT SearchPA Document DatePA_DateDate8
5USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Combined History Header file'].USERID AS 'PA Combined History Header file-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Combined History Header file'].USERID = ['Users Master'].USERID
6BACHNUMB SearchBatch NumberSTR15_LBAUString15
7PAREFNO SearchPA Reference Document No.STR17_LBAUString17
8PAUD1 SearchPA User Defined 1STR20String20
9PAUD2 SearchPA User Defined 2STR20String20
10VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PA Combined History Header file'].VENDORID AS 'PA Combined History Header file-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PA Combined History Header file'].VENDORID = ['PM Vendor Master File'].VENDORID
11PACOSTOWNER SearchPA Cost OwnerSTR30_Item_NumberString30
12PAREPD SearchPA Reporting PeriodINT3Integer3
13PAREPDT SearchPA Reporting DatePA_DateDate8
14PAreptsuff SearchPA Reporting SuffixPA_STR5String5
15PAYR SearchPA YearINT4Integer4
16PAVENINVNO SearchPA Vendor Invoice NumberSTR20_Document_NumberString20
17PAVENADDRESSID SearchPA Vendor Address IDSTR15_Address_CodeString15
18PACOMM SearchPA CommentSTR50String50
19PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PA Combined History Header file'].PYMTRMID AS 'PA Combined History Header file-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PA Combined History Header file'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
20DUEDATE SearchDue DateDTDate8
21DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
22DISCDATE SearchDiscount DateDTDate8
23DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
24PRCTDISC SearchPercent DiscountINT5_%2Integer5
25CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CURNCYID AS 'PA Combined History Header file-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Combined History Header file'].CURNCYID = ['Currency Setup'].CURNCYID
26SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PA Combined History Header file'].SHIPMTHD AS 'PA Combined History Header file-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PA Combined History Header file'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
27PATQTY SearchPA Total QuantityDLR17_QTY_RBS0_UTRCurrency17
28PAtotcosts SearchPA Total CostsPA_DLR17_RBS0_STR$Currency17
29BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency19
30PATACRV SearchPA Total Accrued RevenuesDLR17_RBS0_UTR$Currency17
31TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
32PAFreight_Taxable_P SearchPA Freight Taxable - PurchasePA_DDL_Tax_Options_PurchaseInteger0
33FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].FRTSCHID AS 'PA Combined History Header file-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
35FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency19
36PAMisc_Taxable_P SearchPA Misc Taxable - PurchasePA_DDL_Tax_Options_PurchaseInteger0
37MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].MSCSCHID AS 'PA Combined History Header file-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
38MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
39MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency19
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
41DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
42TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency17
43UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency17
44CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency19
45CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CAMCBKID AS 'PA Combined History Header file-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PA Combined History Header file'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
46CDOCNMBR SearchCash Document NumberSTR20_Document_NumberString20
47CAMTDATE SearchCash Amount DateDTDate8
48CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString20
49CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency19
50CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
51CHEKDATE SearchCheck DateDATEDate6
52CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString20
53CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CHAMCBID AS 'PA Combined History Header file-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PA Combined History Header file'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
54CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency19
55CARDNAME SearchCard NameSTR15_Card_NameString15
56CRCARDDT SearchCredit Card DateDATEDate6
57CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString20
58CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString20
59DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
60CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency19
61LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
62PAPD SearchPA Post DatePA_DateDate8
63VOIDSTTS SearchVoid StatusINTInteger0
64VOIDDATE SearchVoid DateDTDate8
65NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Combined History Header file'].NOTEINDX AS 'PA Combined History Header file-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Combined History Header file'].NOTEINDX = ['Record Notes Master'].NOTEINDX
66RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].RATETPID AS 'PA Combined History Header file-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PA Combined History Header file'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
67EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].EXGTBLID AS 'PA Combined History Header file-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PA Combined History Header file'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
68XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
69EXCHDATE SearchExchange DateDT_DateDate6
70TIME1 SearchTimeTM6Time6
71RTCLCMTD SearchRate Calculation MethodGBInteger0
72DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
73PAORIGTOTCOSTS SearchPA Originating Total CostsDLR17_RBS0_UTR$Currency17
74PAORIACCRREV SearchPA Originating Accrued RevenuesDLR17_RBS0_UTR$Currency17
75DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
76TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].TAXSCHID AS 'PA Combined History Header file-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
77PYMNTTRM SearchPayment TermsPayment_TermString15
78POPTYPE SearchPOP TypeDDL_POP_TypeInteger0
79VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString20
80ACTLSHIP SearchActual Ship DateDTDate8
81GLPOSTDT SearchGL Posting DateDTDate8
82DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
83TRXSORCE SearchTRX SourceSTR13String13
84VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
85DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsProject Accounting (258)ProjectPA Combined History Header file (PA11800)

Leave a Reply

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