This appendix contains the following topics:
This section lists the composite keys for certain tables that the system converts during the base currency conversion. Use the composite key to create and run a query or batch program over the F0086 table.
Table Name | Table Number | Composite Key |
---|---|---|
Taxes | F0018 | For F03B11 and F0411 table conversions: TDDOCO, TDDCTO, TDKCOO, TDSFXO
For the F0911 table conversion: TDDOCO, TDDCTO, TDKCOO, TDSFXO, TDLNID |
Customer Ledger | F03B11 | RPDOC, RPDCT, RPKCO, RPSFX |
Accounts Payable Ledger | F0411 | RPDOC, RPDCT, RPKCO, RPSFX |
Accounts Payable - Matching Document | F0413 | RMDOCM, RMDCTM, RMPYE |
Accounts Payable Matching Document Detail | F0414 | RNDOC, RNDCT, RNDCTM, RNKCO, RNSFX |
Account Balances | F0902 | GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
Account Balances - 52 Period Accounting | F0902B | GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBSBLT, GBCRCD |
Account Ledger | F0911 | GLDCT, GLDOC, GLKCO, GLDGJ, GLJELN, GLLT, GLEXTL |
Policy Edit Rules | F09E108 | POLICY, EXPTYPE, EFTJ, EXRPTTYP, LOCATN |
Credit Card Transaction Interface | F09E150 | CCTN |
Multi-Site Consolidation Transfer | F1002 | GQEDBT, GBEDUS, GQEDTN, GQSERK, GQMCU, GQOBJ, GQSUB, GQSBL, GQSBLT, GQCRCD, GQCRCX |
Location Tracking Table | F1204 | FMNUMB, FMEFTB, FMAL, FMNNBR |
Equipment License Master | F1206 | FHNUMB, FHADDS, FHLNUM |
Equipment Rates | F1301 | FGRTTB, FGRTGR, FGNUMB, FGEFTB, FGERC |
Rental Rules | F1302 | FKCO, FKMCU |
Equipment Location Billing | F1304 | FNTRNN, FNNNBR, FNLOC |
Equipment Analysis Costs | F1383 | EQGP, EQSP, SEQ, NUMB, AID, SBL, SBLT, LT, SMTP |
Forecast Basis | F1403 | MCU, AID, RVNUM |
Forecast Results - Header | F1404 | MCU, AID, RVNUM |
Forecast Results - Detail | F14041 | AID, RVNUM, FY, CTRY |
Forecast Growth Patterns | F1406 | GRWPC |
Lease Master Header | F1501B | DOCO, LSVR |
Tenant E.P. Class Master | F15012B | DOCO, LSVR, BCI |
Share Factor Denominator Audit | F150122A | ICU, SFDN, ECMP, GLMD, MCUS, MCU, UNIT, MT, CENTYR, ARDEFID |
Sales Overage Master File | F15013B | DOCO, LSVR, YEOV |
Product Scales Master | F15014B | DOCO, LSVR, YEOV, BCI |
Min/Max Rents And Recoveries Master | F15015B | DOCO, LSVR |
Tenant Escalation Master | F15016B | DOCO, BCI |
Recurring Billings Master | F1502B | DOCO, LNID |
Estimated EP Recurring Billings | F1502WB | ICU, DOCO, GLC, MCU, UNIT, BCI, UNGR |
Management Fee Master | F1505B | DOCO, MCU, BCI |
Revenue Fee Generation History | F1505HB | ICU, BCI, PMFY, BPN, CTRY |
Unit Master | F1507 | MCU, UNIT |
Lease Billings Master | F1511B | GENT, ICU, DOC, SFX, KCO |
Lease Billings History | F1511HB | GENT, DOCO, BPN, YR, CTRY, SOBT |
FASB 13 Lease Control | F1513B | DOCO, MCU, UNIT, CTRY, YR, ICU |
Building E.P. Caps | F15151 | CAPID, MCU, SEQ |
Lease E.P. Caps | F15152 | DOCO, LSVR, BCI, SEQN |
Lease Cap History | F15153 | ICU, DOCO, LSVR, BCI, CAPID, CAPLVL, MCU, OBJ, SUB, SBL, SBLT |
Fees and Interest | F1525B | FETP, DOCO, AN8, MCU, GLC, LNID, AGSN |
E.P. Class Cap Expenses History | F15303 | ICU, CAPID, EPCL, MCU, OBJ, SUB, SBL, SBLT |
Expense Participation Class Adjustment | F1531 | EPCL, LNID |
Expense Participation Audit File | F1532B | DCT, DOC, DGJ, JELN, ICU, EPCL, AID, LT, SBL, CO |
Tenant Account Exclusions | F1533B | DOCO, LSVR, ADJL, ADJTY, EPCL, MCU, UNIT, AID, LVLT, BCI |
EP Billing Register | F1538B | DOCO, LSVR, ICU, EPCL, BCI |
Occupancy Gross Up Audit | F1538B1 | ICU, DOCO, LSVR, EPCL, BCI, AID, SBL |
Exclusion/Redistribution | F1538B2 | ICU, DOCO, LSVR, EPCL, AID, BCI, ELRD |
EP Billing Account Adjustments Audit | F1539A | ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Class Adjustments Audit File | F1539C | ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Account Exclusions Audit | F1539E | ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Adj Factor EP Class Audit | F1539FC | ICU, DOCO, LSVR, EPCL, BCI, LNID |
EP Billing Adj Factor Lease Audit | F1539FL | ICU, DOCO, LSVR, EPCL, BCI, LNID |
Sales Report Control | F1540B | DOCO, MCU, UNIT, DBAN, STNR, AN8, PRDC, LIN, RPRD, YR, CTRY |
Tenant Weekly Sales | F15410 | DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
Tenant Sales History | F1541B | DOCO, MCU, UNIT, DBAN, STNR, PRDC, CTRY, YR |
Sales History Work File | F1541BW | DOCO, MCU, MCUS, UNIT, DBAN, STNR, ULI, PRDC, CTRY, YR |
Projected Sales | F1542 | MCUS, DOCO, MCU, UNIT, DBAN, ULI, PRDC, STNR, CTRY, YR |
Tenant Sales Analysis Reporting File | F1543B | SASC, CTRY, YR, RPRD, MCU, AN8, UNIT, DBAN, PRDC, MCUS, CO, DOCO, FLOR, ULI, ULI2, DS40 |
Escalation Billing Register | F1548B | DOCO, ICU, BCI |
Security Deposit Master | F1565 | DOCO, LNID |
Legal Clause Amounts | F15703 | DOCO, AN8, CLNO, SEQN |
Market/Potential/Renewal Rent Master | F159071 | MCU, UNIT, RNTY, SEQ |
AREF Building Constants | F15L100 | MCU, RVNB |
AREF Building Constants Models | F15L1001 | BMCI |
AREF Unit Master | F15L101 | MCU, UNIT, RVNB (Release 8.0)
MCU, UNIT, RVNB, UKID (Release 8.10 and above) |
AREF Unit Assumptions Master Header | F15L102 | MCU, ASSD, RVNB |
AREF Growth Pattern File | F15L105 | MCU, GRPA, RVNB |
AREF Base Account Definition | F15L108 | MCU, AID, RVNB |
AREF Budget Results | F15L109 | MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
AREF Account Status | F15L110 | MCU, RVNB, AID, CTRY, FY, SBL, SBLT |
AREF Account Status Detail | F15L111 | MCU, RVNB, AID, CTRY, FY, SBL, SBLT, LNID |
AREF Unit Assumptions Master Detail | F15L112 | MCU, ASSD, RVNB, LNID |
AREF Sales Overage Detail | F15L113 | MCU, RVNB, SOID, SOSQ |
AREF E.P. Rules Detail | F15L114 | MCU, EPRD, RVNB, SEQ |
AREF Base Account Definition Detail | F15L118 | MCU, AID, RVNB, LNID |
AREF Projected Sales | F15L301 | DOCO, MCU, UNIT, RVNB, DBAN, PRDC, CTRY, YR |
AREF Prior Gross Billings | F15L302 | CTID, MCU, RVNB, DOCO, UNIT, LNID |
Case Master | F1755 | STAW, DOCO, UPMJ, UPMT |
Expense Report Header | F20111 | EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT |
Expense Report Detail | F20112 | EXRPTTP, EXRPTNUM, EMPLOYID, WRKSTNID, DTECRT, LIN, RECTYPE, LNID |
Work Center Rates File | F30008 | IWMCU, IWLEDG |
Bill of Materials Changes File | F3011 | IZMMCU, IZKIT, IZTBM, IZITM |
DFM Bill of Material Master | FF30L002 | FSCID, DFKIT, DFMCU, DFTBM, BQTY, CPNB, SBNT, COBY |
Purge - Shop Floor Parts List | F3111S | WMCMCU, WMCPIT, WMCOBY, WMDOCO, WMOPSQ |
Outbound Work Order Parts List | F3111Z1 | SZCMCU, SZCPIT, SZCOBY, SZDOCO, SZOPSQ |
Work Order Time Transactions | F31122 | WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
Work Order Time Transactions Unedited Transaction Table | F31122Z1 | SZYST, SZAN8, SZDGL, SZDOCO, SZOPSQ, SZTYR |
Purge Work Order Time Transactions | F31122S | WTYST, WTAN8, WTDGL, WTDOCO, WTOPSQ, WTTYR |
Lean Transaction Parts List | FF31111 | UKID |
Lean Transaction Labor Detail | FF31113 | UKID |
Production Costs | FF31200 | PRODF31, TRSID, ITM, COST, PART |
Cost Groups Detail | F31B211 | WCG, LNID |
Blend Lot Costs | F31B31C | MCU, WLOTN, WCOST |
Blend Transactions | F31B66 | WOPID, LNID |
Rules Table Detail | F3283 | $2RRN |
Assembly Inclusion Rules | F3293 | KYKIT, KYMCU, KYATOT, KYATO#, KYATOS |
Needed for upgrade from Xe and below | F32961 | KLDOCO, KLDCTO, KLKCOO, KLLNID, KLITM, KLMCU, KLATLV |
Forecast File | F3460 | MFITM, MFMCU, MFDRQJ, MFTYPF, MFDCTO |
Batch Receiver File - Order Headings | F4001Z | SYDOCO, SYDCTO, SYKCOO |
Batch Receiver File - Order Headings | F4011Z | SZDOCO, SZDCTO, SZKCOO |
Price Adjustment Ledger File | F4074 | ALDOCO, ALDCTO, ALKCOO, ALLNID |
Price Variable Table | F4075 | VBVBT, VBEFTJ |
Grower Block | F40G02 | BLUID |
Grower Harvest | F40G03 | WVID |
Harvest Estimate Freeze Detail | F40G032 | FRZID, TYPEHB, WVID, UPLNMAT, LNID |
Crush and Purchase Report Details | F40G150 | WVID |
Item Cost File | F4105 | COITM, COMCU, COLOCN, COLOTN, COLEDG |
Average Cost Work file | F41051 | CHITM, CHMCU, CHLOCN, CHLOTN |
Item Ledger File | F4111 | ILDOC, ILDCT, ILKCO |
Item ASOF File | F41112 | INITM, INMCU, INLOCN, INGLPT, INCTRY, INFY |
Item History | F4115 | IHITM, IHMCU, IHCTRY, IHFY |
Container Deposit File | F4118 | CNCO, CNMCU, CNAN8, CNITM, CNRORN, CNRCTO |
Container Transaction File | F41181 | CMCO, CMMCU, CMAN8, CMITM, CMDOCO, CMDCTO |
Cycle Count Transaction File | F4141 | PJITM, PJMCU, PJLOCN, PJLOTN |
Item Cost Components | F41291 | IGPRP5, IGITM, IGMCU, IGLVLA, IGEFFT |
Sales Order Header File | F4201 | SHDOCO, SHDCTO, SHKCOO, SHSFXO |
Price by Item | F4207 | PMPCTY, PMMCAT, PMCLV, PMCXPJ |
Sales Order Detail File | F4211 | SDDOCO, SDDCTO, SDKCOO, SDLNID |
S.O. Detail Ledger File | F42199 | SLDOCO, SLDCTO, SLKCOO, SLLNID |
Commission Constants File | F42004 | CMAN8, CMDCTO, CMCCTY, CMCXPJ |
Sales Commission File` | F42005 | SCDOCO, SCDCTO, SCKCOO, SCLNID |
Order Hold Constants | F42008 | HCMCU, HCHCOD |
Sales Summary History File | F4229 | SSAN8, SSMCU, SSDCTO, SSITM, SSLNTY, SSSRP1, SSSRP2, SSSRP3, SSSEP4, SSSPR5, SSSSFY |
Purchase Order Header | F4301 | PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Supplier/Item Relationships | F43090 | PCAN8, PCMCU, PCITM |
P.O. Detail Ledger File - Flexible Version | F43199 | OLDOCO, OLDCTO, OLKCOO, OLSFXO, OLLNID, OLNLIN, OLCORD, OLUPMJ, OLTDAY |
Purchase Order Detail | F4311 | PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Purchase Order Detail File | F4311T | PDDOCO, PDDCTO, PDKCOO, PDSFXO, PDLNID |
Purchase Order Receiver File | F43121 | PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
Purchase Order Receiver Tag File | F43121T | PRMATC, PRDOCO, PRDCTO, PRKCOO, PRMCU, PRLNID, PRNLIN, PRDOC |
Purchase Order Receiver Multiple Account | F43126 | P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
Purchase Order Receiver Multiple Account Tag File | F43126T | P4MATC, P4DOCO, P4DCTO, P4KCOO, P4SFXO, P4LNID, P4NLIN, P4DLIND, P4DOC |
Purchase Order Receiver Tag Table | F43121TB | PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, P4DOC |
Purchase Order Receiver Non-Billable | F43127 | PRMATC, PRDOCO, PRDCTO, PRKCOO, PRSFXO, PRLNID, PRNLIN, PRDLIND, PRNBACTY, PRDOC |
Purchase Order Multiple Account File | F4316 | DOCO, DCTO, KCOO, SFXO, LNID, AID, SBLT, SBL, DGL |
Purchase Order Multiple Account Tag File | F4316T | DOCO, DCTO, KCOO, SFXO, LNID, DLNID |
Purchase Order Detail Non-Billable | F4317 | DOCO, DCTO, KCOO, SFXO, LNID, NBACTY, DLNID, AID |
Purchasing Tolerance Rules | F4322 | PZFNTY, PZITM, PZPRP1, PZCO |
Multiple Requisition File | F4332 | P2DOCO, P2DCTO, P2KCOO, P2LNID, P2OORN, P2OCTO, P2OKCO, P2OGNO |
Purchase Rebate History | F4343 | RHAN8, RHAGSQ, RHDCTO, RHDOCO, RHKCOO, RHLNID |
Contract Header | F43C01 | CNTRTID |
Contract Block | F43C10 | CNTRTID, BLUID |
Contract Detail | F43C11 | CNTRTID, CNTRTDID |
Assessment Donations | F43C30 | ADADUKID |
Requisition Order Header | F43E01 | DOCO, DCTO, KCOO |
Requisition Detail | F43E11 | DOCO, DCTO, KCOO, SFXO, LNID |
Requisition Multiple Account File | F43E16 | DOCO, DCTO, KCOO, SFXO, DLNID |
Shopping Cart Detail | F43E20 | USER, LNID |
Event Header | F43Q10 | EVNU, DCTO, KCOO |
Event Detail | F43Q11 | EVNU, DCTO, KCOO, EVLN |
Event Header Bid Questions | F43Q20 | EVNU, DCTO, KCOO, BIDQN |
Event Detail Bid Questions | F43Q21 | EVNU, DCTO, KCOO, EVLN, BIDQN |
F43Q40 | F43Q40 | EVNU, DCTO, KCOO, BIDNUM, AN8 |
Response Header Question | F43Q401 | EVNU, DCTO, KCOO, BIDNUM, BIDQN, AN8 |
Response Line | F43Q41 | EVNU, DCTO, KCOO,EVLN,BIDNUM, AN8 |
Response Detail Question | F43Q411 | EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8 |
Response Detail Question Price Break | F43Q412 | EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, TRNB |
Response Detail Question Price Components | F43Q413 | EVNU, DCTO, KCOO,EVLN,BIDNUM,BIDQN, AN8, PCPTN |
Analyze Event Detail | F43Q51 | EVNU, DCTO, KCOO,EVLN, AN8, BIDNUM, AWARDNUM |
Bid Questions | F43Q60 | BIDCODE, CMDCDE, ITM |
Community Phase Master | F44H101 | HBMCUS,CPHASE |
Lot Master | F44H201 | HBMCUS,HBLOT |
Plan Master | F44H301 | HBMCUS, HBPLAN, CPHASE, HBELEV |
Option Master | F44H401 | HBAREA, HBMCUS, CPHASE, HBPLAN, HBELEV, OPTION |
Item Master HomeBuilder Extension | F44H4101 | ITM, HBAREA |
Sales Master Table | F44H501 | HBMCUS, HBLOT, CSSEQ |
Option Selections | F44H511 | HBMCUS, HBLOT, OPKID, OPTION |
Closing Worksheet Entries | F44H591 | HBMCUS, HBLOT, CLSRT, OPTION |
Material Item Pricing | F44H603 | HBAREA, ITM, AN8, HBMCUS, CPHASE, EFFF |
Bid Details | F44H611 | KCOO, DOCO, DCTO, SFXO, LNID |
Lot Start Workfile | F44H711 | MCU, OBJ, SUB, OPTION, AN8, ITM, SEQ |
After Start Purchasing | F44H711P | DOCO, DCT, KCOO, SFXO, LNID |
Extended Homebuilder Data | F44H0929 | HBAREA, HBMCUS, CPHASE, HBLOT, CSSEQ, HBPLAN, HBELEV, OPTION, SDTYP, SDKY, SDLIN |
EDI Purchase Order Header - Inbound | F47011 | SYEDOC, SYEDCT, SYEKCO |
EDI Purchase Order Detail - Inbound | F47012 | SZEDOC, SZEDCT, SZEKCO |
EDI Request for Quote Header - Inbound | F47091 | SYEDOC, SYEDCT, SYEKCO |
EDI Request for Quote Detail - Inbound | F47092 | SZEDOC, SZEDCT, SZEKCO |
EDI Product Activity Data Detail - Inbound | F47122 | MJEKCO, MJDOC, MJDCT |
EDI Product Activity Data Detail - Outbound | F47127 | MJEKCO, MJDOC, MJDCT |
EDI Purchase Order Change Header - Inbound | F47131 | EDOC, EDCT, EKCO, EDLN |
EDI Purchase Order Change Detail - Inbound | F47132 | EDOC, EDCT, EKCO, EDLN |
EDI P.O. Acknowledgement. Header - Outbound | F47026 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Acknowledgement. Detail - Outbound | F47027 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Shipping Notice Detail - Outbound | F47037 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Header (Sales) - Outbound | F47046 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Invoice Detail (Sales) - Outbound | F47047 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Response to RFQ Header - Outbound | F47106 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Response to RFQ Detail - Outbound | F47107 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Header - Outbound | F47016 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Purchase Order Additional Header - Outbound | F470161 | S3EDOC, S3EDCT, S3EKCO, S3EDLN |
EDI Purchase Order Additional Detail - Outbound | F47017 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Additional Detail - Outbound | F470171 | S4EDOC, S4EDCT, S4EKCO, S4EDLN |
EDI P.O. Acknowledgment Header - Inbound | F47021 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Acknowledgment Detail - Inbound | F47022 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Header - Inbound | F47041 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Invoice Detail - Inbound | F47042 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Invoice Summary - Inbound | F47044 | SWEDOC, SWEDCT, SWEKCO, SWEDLN |
EDI Planning Schedule Detail - Inbound | F47062 | MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
EDI Planning Schedule Detail - Outbound | F47067 | MYEDOC, MYEDCT, MYEKCO, MYEDLN, MYITM, MYMCU |
EDI Receiving Advice Header - Inbound | F47071 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Receiving Advice Detail - Inbound | F47072 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Receiving Advice Header - Outbound | F47076 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Receiving Advice Detail - Outbound | F47077 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Request for Quote Header - Outbound | F47096 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI Request for Quote Detail - Outbound | F47097 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Purchase Order Change Header - Outbound | F47136 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgment Header - Inbound | F47141 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgment Detail - Inbound | F47142 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI P.O. Change Acknowledgement Header - Outbound | F47146 | SYEDOC, SYEDCT, SYEKCO, SYEDLN |
EDI P.O. Change Acknowledgement Detail - Outbound | F47147 | SZEDOC, SZEDCT, SZEKCO, SZEDLN |
EDI Tolerance Rules | F4722 | PZEDST, PZAN8, PZEDSP, PZCO |
Work Order Master File | F4801 | WADCTO, WATYPS, WASRST, WADPL, WAAN8, WADOCO |
Billing Detail Workfile | F4812 | BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
Billing Workfile History | F4812H | BCI, DGL, SBSQ, PRSQ, SCSQ, SLNK, CLNK, CCOD |
Invoice Summary Work File | F4822 | W4DOCZ, W4DCTI, W4KCOI, W4SFX |
Billing Rate / Mark up Table | F48096 | UKID |
Voucher Summary | F4823 | DOCZ, DCTI, KCOI, SFX |
Component Table Detail | F4861 | CTBL, CRCD, EFTB, UKID |
Burden Rates | F48S85 | SEGMID, EFTB, CRCD, BUCA, BURT, POOLID |
G/L Link | F48S912 | AID, BCI, DGL, PRSQ, SBSQ, SCSQ, CCOD, DCT, LT, UKID |
Sales Order Detail File - Tag File | F49211 | UDDOCO, UDDCTO, UDKCOO, UDLNID |
Load In-Transit Confirmed Quantities | F49633 | LDNM, VMCU, DLNO, SHPN |
Load In-Transit Confirmed Quantities Detail | F49634 | SHPN, DOCO, DCTO, KCOO, LNID |
Contract Billing Line Detail | F5202 | DOCO, DCTO, KCOO, COCH, LNID |
Contract Revenue Summary | F5280 | DOCO, DCTO, KCOO, COCH, LNID, CTRY, FY, PN |
Government Contract Modification | F52G01M | DOCO, DCTO, KCOO |
ACRN Details | F52G05 | DOCO, DCTO, KCOO |
ACRN History | F52G05H | DOCO, DCTO, KCOO, DOCZ, DCTI, KCOI, GACRN |
Government Contract Limit Summary | F52G200 | DOCO, DCTO, KCOO, PRTPG |
Actual Rate Calculation | F52G60 | REFID, SEGMID, SEQ, POOLID, BOBS, TRRN |
Suspended IVA Generation - Receipt/Rebate Control - Italy | F743B14I | TIDOC, TIDCT, TIKCO, TISFX, TIDOCM, TIDCTM |
IM Withholdings Setup | F76V4025 | WSCO, WSV76MUNW, WSV76MIIM, WSEFTJ |
VAT Withholdings Setup | F76V4030 | VWCO, VWV76VATW, VWEFTJ |
Withholding Historical File | F76V4581 | HRKCO, HRDCT, HRDOC, HRSFX, HRSFXE, HRCO |
Withholdings I.S.L.R. Fee 2 | F76V4583 | TDCO, TDAN8, TDAC07, TDFY, TDPN, TDDCT, TDDOC, TDIRQ |
Competitor Table | F90CA060 | CMAN8 |
Opportunity Table | F90CB020 | OPPID |
Opportunity Item Table | F90CB02I | OPPID, LNID |
Cost Table | F90CB02M | COSTID |
Forecast | F90CB060 | FCID |
Opportunity For Forecast | F90CB06B | FCID, OPPID |
Opportunity Item For Forecast | F90CB06C | OPPID, SEQNU, FCID |